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 PowerPoint
- Fundamental of Microsoft Office Access
- Course Summary & Test
Unit 1: Windows System/Resources (Customizing Windows)
1.1. Customizing Windows for making a 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, MegaByte, GigaByte …) 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 the desktop
- How programs may save files in a specific location by default. How to find where the file is being saved.
- How windows create 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 a 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 an 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 a label for a special email id
2.6. Computer Maintenance and Troubleshooting
Computers like any equipment need some maintenance to ensure they continue to run as 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 the 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 types 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
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 PowerPoint
- 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 a Table Sheet as well as Accounting Form. This program makes it easy for understanding the table, form, and concept of the database. In Access terms, a database is a 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
- Form Wizard
- Calculating the Data
- Query
- Report
- Macro
- Different buttons in form designing
- Revision & Practice
Unit 7: Course Summary & Test
