
Microsoft Office Course Content
Excel Beginner
-
Getting Started with Excel
-
Data Entry, Data Editing, and Number Formatting
-
Data Formatting
-
Number Formatting in Excel
-
Working with Cells and Ranges in Excel
-
Excel Formula Basics
-
Managing Worksheets
Excel Intermediate
-
Introduction to Excel Tables
-
Auto-fill, Custom Lists, and Flash Fill
-
Logical Formulas in Excel
-
Math Formulas in Excel
-
Lookup and Reference Formulas in Excel
-
Stats Formulas in Excel
-
Text Formulas in Excel
-
Date and Time Formulas in Excel
-
Named Ranges in Excel
-
Data Sorting and Filtering in Excel
-
Using Conditional Formatting in Excel
-
Introduction to Excel Charting
-
Overview of Excel Pivot Table
-
Protection in Excel
-
Introduction to Macros and VB Editor
Outlook Beginner
Create, reply, forward and format emails with attachments
Understand the efficient ways of working with quick styles, quick parts
Create appointments and meeting requests
Create Contacts and export them
Create and manage and automated tasks
Scheduling of meetings
Customising Outlook
Outlook today
Working With personal Folders
Using Help
Handling and sending messages
Managing Emails
Signatures
Printing messages
Outlook Intermediate
All of Beginner plus;
Microsoft Office Outlook Contacts
Using address books
Working with the master category List
Tasks
Working with tasks
Assigning tasks to others
Calendar
Working With appointments
Modifying appointments
Working with events
Managing Meetings
Word Beginner
-
Introduction to Microsoft Word
-
Document Views
-
Entering and Editing Text
-
Saving and Opening Documents
-
Navigating and Selecting Text
-
Editing, Copying and Moving Text
-
Formatting Documents
-
Using Bulleted and Numbered Lists
-
Using Tabs
-
Introduction to Tables
-
Inserting Pictures
-
Page Layout and Printing
Word Intermediate
-
Introduction to Styles, Themes and Templates
-
Managing Bulleted and Numbered Lists
-
Customising Tables and using Formulas
-
Inserting Text Objects
-
Inserting Graphic Objects
-
Using Quick Parts
-
Multi-Section Documents
-
Headers and Footers in large documents
-
Proofing Tools
PowerPoint Beginner
-
Introduction to Microsoft PowerPoint
-
Creating a Presentation
-
Entering and Editing Text
-
Managing Text
-
Text Boxes and Tables
-
Pictures and Drawings
-
SmartArt and Charts
-
Presentation Designs and Formatting
-
Printing PowerPoint Presentations
-
Simple Animations
-
Running Slide Shows
PowerPoint Intermediate
-
Integrating with Word and Excel
-
Managing Slide Masters
-
Multimedia Objects
-
Custom Animations
-
Collaborating with Colleagues
-
Publishing a Presentation
-
Preparing and Presenting a Show