top of page

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

bottom of page