• +977-1-4117999
  • +977-9861666678
  • itschoolnepal@gmail.com
  • Gairigaun, Tinkune, Kathmandu
pearson vue test center in nepal
Microsoft Office (MS) Package Training in Nepal

Duration1 monthMicrosoft Office (MS) Package Training in Nepal

We are making easy to learn computer technology for the beginners. This course is set of Windows Customization, Email/Internet, Microsoft Office Word, Microsoft Office Excel, Microsoft Office PowerPoint, Microsoft Office Access, and various exercises. Our aim with the basic Office package is to guide you for your career pathway considering your future in the field of Information Technology.

The basics of Office Package is foundation for beginners to start their career in the field of Information Technology. Today it is often assumed that people know these basics, however in an introductory course it is good to ensure these basics are introduced.

Anyone, who are keen to learn computer technology with professionals can request for this package. It is a short term course making easy for beginners.

Course Contents

Microsoft Office (MS) Package Training in Nepal

Course Coverage

  • Windows System/Resources (Customizing Windows)
  • Internet & Email system
  • Various Google Tools
  • Microsoft Office Word
  • Microsoft Office Excel
  • Microsoft Power Point
  • Fundamental of Microsoft Office Access
  • Course Summary & Test

Unit 1: Windows System/Resources (Customizing Windows)

1.1. Customizing Windows for making computer system more functional and appealing to use

  • Change the desktop background
  • Change the screen saver
  • Change the theme to make multiple changes to the desktop appearance
  • Customize the taskbar (Lock/Unlock and all)
  • Customize the Start menu
  • Windows Sidebar
  • Set the date and time (Time region and its importance)
  • Show how to have multiple users on Windows (File Management)

1.2. Understanding file management seems to be an area

  • What is a file & folder?
  • Naming conventions
  • File Extensions
  • File Pathway
  • Windows Explorer
  • Viewing files
  • File property dialogue box
  • Explain file size (Bytes, Kilo Byte, Mega Byte, Giga Byte …) and abbreviations used.
  • Create a Folder
  • Move a file (multiple files) into a folder
  • Delete files and folders
  • Recovering deleted files
  • Renaming files
  • Searching for files
  • Creating and deleting shortcuts on desktop
  • How programs may save files in specific location by default. How to find where file is being saved.
  • How windows creates a directory for each user.

1.3. Downloading and Installing programs

  • How to download files and programs from the Internet
  • Installing programs on your computer

Unit 2: Internet & Email system

2.1. Internet Fundamentals, Features and Uses 

2.2. Basic Email

  • What is email?
  • What you can do with email.
  • How email works over the internet
  • How mail server works.
  • Parts of an email address
  • How to get an email address
  • Differences between webmail and POP accounts
  • Sign up for free webmail account with Gmail
  • Different email platforms (Google Mail, Hotmail / Outlook, Yahoo Mail etc.)

2.3. How to compose and send email

  • Header (To, From, CC, BCC, Subject), Body, How to attach files, Set Priority of the message, How to save a draft email message, Creating address book/contact list, Setting e-mail expiry date
  • Introduce basic formatting that can be done, Font, Line and paragraph formatting, lists, Spell check, Email Etiquette, Using emoticons, Creating a signature

2.4. Receiving and Responding to Email

  • How to view received messages, How to identify if messages have been read or not
  • Reply, Reply All, Forward, How to open attachments, Setting vacation or away messages, How to block messages, How to filter/redirect messages, Reporting Spam

2.5. Organizing Email

  • How to delete messages from outlook.com, gmail.com. How to recover deleted messages.
  • Creating Folders/mailboxes, How to move messages between folders, How to search for a message, How to sort messages, Date, size, sender.
  • How to set label for special email id

2.6. Computer Maintenance and Troubleshooting

Computers like any equipment need some maintenance to ensure they continue to run like they should. This unit is to introduce some basic maintenance and some troubleshooting techniques to use if there is a problem.

  • Caring for the hardware (Cleaning the case, Cleaning the monitor)
  • Cleaning the keyboard / Mouse
  • Deleting unnecessary files and programs (Disk Clean up, Deleting programs – Delete all toolbars)
  • Delete temporary files
  • Defrag your hard drive
  • Computer Maintenance programs i.e. CC Cleaner, My Defrag, Spin rite, etc.
  • Basic Troubleshooting techniques ( Restart your computer and components, Check cables on the back of computer,  Uninstall newly installed software, Use the Windows troubleshooting software, (access from the Control Panel), Start Windows in Safe Mode, Search the Internet for a solution)

 

Unit 3: Microsoft Office Word

Microsoft Word is Microsoft's word processing software. It was first released in 1983 under the name Multi-Tool Word. It is a component of the Microsoft Office Package; however, it is also sold as a standalone product and included in Microsoft Works Suite. Beginning with the 2003 version, the branding was revised to emphasize Word's identity as a component within the Office suite; Microsoft began calling it Microsoft Office Word instead of merely Microsoft Word. The latest release is Word 2016.

  • Office Button
  • Creating New Document
  • Mini Toolbar (Use the Mini Toolbar, Turn Off the Mini Toolbar)
  • Page Size, Orientation, Columns, and Margin area
  • Applying heading styles
  • Applying normal text styles
  • Text formatting and alignment
  • Adding a bulleted list
  • Inserting a Picture and applying Picture Style
  • Adding a Caption to the picture
  • Create Table
  • Use of Text Box
  • Create various type of Chart
  • Create shapes
  • Create Word Art
  • Apply Drop Cap
  • Create Table of Content
  • Add Footnote
  • Mailing Features
  • Thesaurus, Grammar, Word Count, Comment, and Translate
  • View layout (Read Mode, Print Layout, Web Layout)
  • Window Split, Arrange, Switch
  • Macros (Recording activities for future use)

Unit 4: Microsoft Office Word

The Microsoft Office Excel is an electronic document that stores various types of data. There are vertical columns and horizontal rows.  A cell is where the column and row intersect.  A cell can contain data and can be used in calculations of data within the spreadsheet.  An Excel spreadsheet can contain workbooks and worksheets.  The workbook is the holder for related worksheets.

  • Home
  • Insert
  • Page Layouts
  • Formulas
  • Data
  • Review
  • View
  • To create a new Workbook:
  • Auto Fill (Dragging)
  • Format Cells Dialog Box
  • To apply colors manually:
  • To apply borders and colors using styles:
  • Change Column Width and Row Height
  • Hide or Unhide Rows or Columns
  • Merge Cells
  • Align Cell Contents
  • Format Worksheet Tab
  • To change the color of a worksheet tab
  • Reposition Worksheets in a Workbook
  • Insert and Delete Worksheets
  • To delete a worksheet
  • Copy and Paste Worksheets:
  • Insert Cells, Rows, and Columns
  • Excel Formulas (References, Operators, Constants, Functions, autosum etc)
  • Types of operators
  • Linking Worksheets
  • Recording a Macro
  • Running a Macro
  • Sorting Data
  • Custom Sorts
  • Filtering
  • Convert Text to Columns
  • Set Print Titles
  • Set Page Break
  • Print a Range
  • Split a Worksheet
  • Freeze Rows and Columns
  • Entering and Editing Data
  • Creating Formulas

Unit 5: Microsoft Power Point

  • Introduction to PowerPoint
  • Creating Slides
  • Applying Designs & Animations
  • Slide Master
  • Printing Presentations
  • New Slide
  • Create a slide as a duplicate
  • Create a new slide from another presentation:
  • Text Direction
  • Animations
  • Transitions
  • Adding a Photo Album
  • Adding Video
  • To edit the video options
  • Adding Audio
  • To edit the audio options
  • Themes
  • To apply new colors to a theme
  • Backgrounds
  • Format Background
  • View
  • Run the show
  • Automatic Slide Show:
  • Transition Effect:
  • Animating Text
  • Print a Presentation
  • To access the print options:
  • To print preview:
  • Package a Presentation

Unit 6: Fundamentals of Microsoft Office Access

MS-Access is a program where we can create Table Sheet as well as Accounting Form. This program makes you easy for understanding table, form, and concept of database. In Access terms a database is collection of all the tables, queries, forms, reports, macros & modules that compose a complete system.

  • Run MS-Access
  • Main features of Access Database (Tables, Forms, Queries, Reports, Macro, Modules or Code Builders, Pages, Data Type, Auto, Numbers, Primary Key Fields) 
  • Creating Table
  • Data Sheet View
  • Entering Data in Table
  • Provide primary key
  • Field Size & Formatting
  • Default Value
  • Validation Rule
  • Validation Text
  • Required
  • Table Wizard
  • From Wizard
  • Calculating the Data
  • Query
  • Report
  • Macro
  • Different buttons in form designing
  • Revision & Practice

Unit 7 : Course Summary & Test

 

Facebook Comments

Inquiry / Apply