Certificate Program in Microsoft Office For Employees
This training program enables the participants to demonstrate their abilities with Word, Excel, Access, Powerpoint, Email, Internal and Applications. The Certificate Program in Microsoft Office helps you develop technical job ready skills and get exposed to real world experiences through expert instruction and hand on lab exercises. Microsoft Office skills are highly-regarded by employers when searching for suitable candidates. Once employed, students who follow this program can spend less time learning and more time performing important tasks.
Course Duration : 40 Hrs
Date & Time : Sunday from 8.00 AM to 12.00 PM
Couse Fee :
Course Contents
- Operatiing System (Windows 10)
- Word Processing (MS Word)
- Spreadsheet (MS Excel)
- Prsentation (MS Excel)
- DataBase Management System (MS Access)
- Internet & Email
Apply Your Message
Students who completed the course successfully are awarded valuble govt cerified certificate.
Certificate in Office Applications - Course Outline & Modules
Operating System (Windows 10)
- Module 1
- Introducation to OS
- Logging On to Windows 7
- Exploring the Desktop
- Using the Start Menu
- Using the Windows Taskbar
- Exploring Control Panel
- Finding Information About Your Computer System
- Ending a Computing Session
- Control Panel Categories
- Accessing Individual Control Panel Items
Module - 2 (Manage User Accounts )
- Understanding User Accounts and Permissions
- Managing a User Account
- Limiting Computer Access
- Disabling or Deleting a User Account
- User Accounts Types
- User Account Control
Module - 3 (Navigate Windows and Folders )
- Working with Windows
- Understanding Files, Folders, and Libraries
- Finding Your Way Around Your Computer
- Finding Specific Information
- Sizing, Moving, and Arranging Windows
- Hiding and Displaying Windows
- File Types
- Windows System Folders
- Folder Windows Features
- Windows Search
Module - 4 (Manage Folders and Files )
- Viewing Folders and Files in Different Ways
- Working with Folder and File Properties
- Creating and Renaming Folders and Files
- Moving and Copying Folders and Files
- Creating Shortcuts
- Grouping Folder Content
- Changing Folder Options
- File Properties
- Folder Properties
- Compressing Folders and Files
- Deleting and Recovering Folders and Files
- Recycle Bin Size
- Desktop Shortcuts
- Start Menu Pinned Items
- Taskbar Pinned Items
Word Processing (Microsoft Word)
- Module - 1
- Working in the user interface
- Creating, editing text and saving documents
- Opening, Moving around in and closing Documents
- Viewing documents in different ways
- Accessing help feature
- Creating a new blank document
- Entering text
- Saving the document
- Saving into a new folder
Editing and Proofread Text
- Module -2
- Making text changes
- Cut, Copy and Paste
- Paste Options
- Undo and redo
- Office clipboard
- Find and replace text
- Fine-tuning text
- Correcting spelling and grammatical errors
- Selecting text
- Deleting text
- Drag and drop
- Using find and replace
- Thesaurus
- Spell check
- Auto Correct
Editing and Proofread Text
- Module -3
- Making text changes
- Cut, Copy and Paste
- Paste Options
- Undo and redo
- Office clipboard
- Find and replace text
- Fine-tuning text
- Correcting spelling and grammatical errors
- Selecting text
- Deleting text
- Drag and drop
- Using find and replace
- Thesaurus
- Spell check
- Auto Correct
Changing the Look of Text
- Module -4
- Quickly formatting text
- Manually changing the look of characters
- Manually changing the look of paragraphs
- Character formatting and case considerations
- Find and replace formatting
- Creating and modifying lists
- Paragraph styles
- Changing font, font size and font colour
- Bold, Italic and Underline
- Format Painter
- Font dialog box
- Highlight text
- Clear Formatting
- Indenting
- First Line and hanging indents
- Paragraph alignment
- Setting up Tabs
- Adjusting line spacing
- Paragraph spacing
- Borders and Shading
- Bullets and Numbering
- Customizing bullets and numbering
Organizing Information in Columns and Tables
- Module -5
- Presenting information in columns
- Presenting info in tables
- Performing calculations in tables
- Formatting Table
- Inserting columns
- Justify paragraphs
- Column options
- Inserting a table
- Inserting and deleting columns and rows
- Resizing columns
- Merge cells
- Table alignment
- Converting text to table
Add Simple Graphic Elements
- Module -6
- Inserting and modifying pictures
- Changing a document background
- Inserting Building Blocks
- Drawing text boxes
- Adding Word Art
- Inser Pictures
- Resize and crop a picture
- Picture corrections and picture styles
- Artistic effects
- Inserting a Cover page
- Inserting Page Numbers
- Headers and Footers
- Insert WordArt to the documents
- Wrap text around Word Art
Insert and Modify Charts
- Module -7
- Insert a chart into a document
- Customize a chart, and save it as template
- Changing a document background
- Plot Excel data in a chart
- Formatting a chart
- Changing chart types
- Adding axis titles and labels
Explore More Text Techniques
- Module -8
- Adding hyperlinks
- Inserting fields
- Adding Footnotes and End notes
- Password-Protecting Documents
Work with Mail Merge
- Module -9
- Understanding Mail Merge
- Preparing Data Sources
- Using an Database Contact List as a Data Source
- Preparing Main Documents
- Merging Main Documents and Data Sources
- Printing Envelopes
- Sending Personalized Emails to Multiple Recipients
- Creating and Printing Labels
Work with Mail Merge
- Module -9
- Understanding Mail Merge
- Preparing Data Sources
- Using an Database Contact List as a Data Source
- Preparing Main Documents
- Merging Main Documents and Data Sources
- Printing Envelopes
- Sending Personalized Emails to Multiple Recipients
- Creating and Printing Labels
Spreadsheet (Microsoft Excel)
- Module - 1 Setting up a workbook
- Creating Workbooks
- Modifying Workbooks and Worksheets
- Excel Terminology
- Excel Environment
- Customizing Quick Access Toolbar
- Creating a New Workbook
- Entering Data into Workbook
- Entering Data into Workbook
- Open a workbook
- Zoom
- Insert a new worksheet
- Renaming a new worksheet
- Changing the tab colour of worksheet
- Rearranging the order of worksheets
- Rearranging the order of worksheets
- Hide/Unhide Worksheet
- Changing column widths and row heights
- Insert Columns/Rows
- Delete Columns/ Rows
- Hide/Unhide columns or rows
- Hide/Unhide columns or rows
- Moving Data by dragging
Module - 2 - Formatting excel work book:
- New, Open, Close, Save, Save As
- Formatting Text: Font Size, Font Style
- Font Color, Use the Bold, Italic, and Underline
- Wrap text, Merge and Centre
- Currency, Accounting and other formats
- Modifying Columns, Rows & Cells
Module - 3 Perform Calculations with Functions
- Creating Simple Formulas
- Setting up your own formula
- Date and Time Functions, Financial Functions
- Logical Functions, Lookup and Reference
- Functions Mathematical Functions
- Statistical Functions, Text Functions.
- Absolute & Relative Reference
Module - 4 Sort and Filter Data with Excel
- Sort and filtering data
- Using number filter, Text filter
- Custom filtering
- Removing filters from columns
- Conditional formatting
- Advanced Filtering (Criteria Range)
Module - 5 Advanced PivotTables in Excel
- How to create PivotTables
- How to use the value field settings
- Different ways to summarize data
- Using multiple fields and dimension
- Basic to advanced sorting and filtering
- Selecting the right chart to present your data
- Adding slicers and timelines and applying them to multiple tables
- Combining data from multiple worksheets for a PivotTable
- Updating your data in a PivotTable and PivotChart
Presentation (Microsoft PowerPoint)
- Module - 1 Explore PowerPoint
- Working with the user interface
- Creating and saving presentations
- Compatibility with earlier versions
- Opening, Moving around in, and closing presentations
- Viewing presentations in different ways
Module - 2 - Working with Slides
- Adding and Deleting slides
- Adding slides with ready-made content
- Slide Libraries
- Exporting presentations as outlines
- Dividing presentations into section
- Rearranging slides and sections
Module - 3 - Working with Slide content
- Entering text into placeholders
- Adding text boxes
- Changing the default font for text boxes
- Editing text Clipboard
- Correcting and sizing text while typing
- Checking spelling and choosing the best words Research information
- Find and Replacing text and fonts
Module - 4 - Format Slides
- Appling themes
- Using different theme colours and fonts
- Changing the slide background
- Changing the look of placeholders
- Changing the alignment, spacing, size and look of text
Module - 5 - Add Simple Visual Enhancements
- Insert Picture and ClipArt images
- Inserting Diagrams
- Graphic formats
- Converting existing bullets into a diagram
- Inserting charts
- Inserting shapes
- Connecting shapes
- Adding transitions
Module - 6 - Add Other Enhancements
- Adding WordArt Text
- Inserting Symbols and Equations
- Insert Screen Clipping
- Creating Hyperlinks
- Attaching the same hyperlink to every slide
- Attaching actions to text or objects
Module - 7 - Add Animation
- Using Ready Made Animation
- Customizing animation effects
Module - 8 - Add Sound and Movies
- Inserting and playing Sounds
- Inserting and playing Videos
- Inserting videos from web sites
Module - 9 - Review and Deliver Presentation
- Setting up a presentation for delivery
- Previewing and Printing Presentation
- Preparing speaker notes and Handouts
- Enhanced Handouts
- Finalizing Presentation
- Setting up presenter view Delivering a presentation
DBMS (Microsoft Access)
- Module - 1 6. Explore the concept of Database
- Identify the Manual Database Systems
- Explore the Objects of Manual Database
- Create a suitable Form to get information from a Relevant source
- Create a suitable Table to store the collected information
- Identify the fields and records in a Table
- Identify the key field ( Primary Key ) of a Table
- Explore the Relationships with the Tables
- Define a Database and its components
Module - 2 - Analyze DBMS software to identify its components
- Identify Database Management Software
- Explore IDE of DBMS Software ( MS Access )
- Identify the Objects of DBMS software
- Tables
- Forms
- Queries
- Reports
Module - 3 Create Tables using DBMS Software
- Create a Database
- Create Tables
- Identify the Data Types
- Change the properties of Fields of Tables
- Save the Tables
- Identify the types of views
- Design View
- Data Sheet View
Module - 4 Make Relationships between Tables
- Identify the Primary Key Field
- Identify the Foreign Key Field
- Make Relationships Between the relative Tables
Module - 5 Create Forms & Quaries Using DBMS Software
- Use Forms to store data in a Table
- Create Queries to retrieve information according to the use of useful criteria
- 6.7. Create Reports
INTERNET & E-MAIL
- Introducation to Internet
- Exploring Web browsers
- Search Engines
- Using the Search Box
- To empty the Temporary Internet Files folder (cache)
- Clear the browsing history To save a webpage onto your computer
- Bookmarks
- Internet Safety
- Introducation to Emails
- Email addressing
- Email attachments, Browsing, Search engines
- Text chatting, Job Searching
- Downloading video and Music
- Uploading Video or Music, Voice chatting, Webcam Chatting etc.
- Introduction to Zoom, Whatsapp
- Storing your passwords and login details
- Allowing and blocking pop-ups
- InPrivate mode
- Parental Controls
- Viruses and Trojans