Microsoft Outlook Course

Outlook is one of the most fundamental tools used in the business world, it is the bedrock of communication whether by email or meeting and so we enlisted a highly experienced corporate professional and trainer to teach this. Her background working in high profile Global companies has given her an edge in understanding how to get the most out of Outlook and in the space of a few hours you will know more about Outlook than 90% of users!

MODULE 1: INTRODUCTION

1. 1 Introduction to Outlook

1.1a Introduction to Outlook follow up

1.2 Linking an email

1.3 Creating and formatting email and inserting picture

1.4 Creating email signature

1.5 Pasting in Outlook from Word PPT and Excel

MODULE 2: RULES, FORMATTING & FOLDERS

2.1 Send email, show sent folders and receiver email

2.2 Creating rules

2.3 Conditional formatting

2.4 Different view panes settings

2.5 More about view settings

2.6 Understanding different folders

MODULE 3: PRINTING, SEARCHING & ATTACHMENTS

3.1 Printing an email

3.2 Creating subfolder within new folder

3.3 Sending attachments

3.4 Using categories with Exchange, IMAP and POP email accounts

3.5 Tags and searching for emails

3.6 Using the search folder

Microsoft Powerpoint Course

We worked with a highly experienced corporate professional and trainer who brought many years of using Office in some of the biggest, most high profile Global companies and created an incredible training course which will have you mastering PowerPoint in a few hours. 

MODULE 1: INTRO & BASICS

1.1 Introduction to PowerPoint Ribbon Tabs & Groups

1.2 Ribbon Options

1.3 Customise the Quick Address Toolbar

1.4 Moving through and deleting slides

MODULE 2: SHAPES

2.1 Shapes filled with pictures

2.2 Arranging Shapes 1

2.3 Arranging Shapes 2

2.4 Aligning, grouping and resizing shapes

2.5 How to use shapes

2.6 Merging vs Grouping

2.7 Shapes - all merging options

2.8 Creating customised shapes

MODULE 3: SMARTART, ORG CHART & ARROW DIAGRAM

3.1 Working with SmartArt 1

3.2 Working with SmartArt 2

3.3 Organisational chart - Manual vs SmartArt

3.4 Organisational chart - more tips

3.5 Arrow diagram

MODULE 4: GUIDES, RULERS, GRIDLINES AND FORMATTING

4.1 Guides, Rulers & Gridlines

4.2 Smart Guides and shapes

4.3 Smart Guides and text boxes

4.4 Inserting and formatting text plus setting up tabs

4.5 Changing margins within shapes

4.6 Working with bullets

MODULE 5: SECTIONS, SLIDE MASTER AND DEFAULT STYLES

5.1 Working with sections

5.2 Creating a Slide Master 1

5.3 Creating a Slide Master 2

5.4 Slide Master placeholders

5.5 Slide Master change placeholder shape

5.6 Slide Master change placeholder points

5.7 Changing default style to shapes and text boxes

Advanced Microsoft Word Course

Building on from our previous Word course, our instructor takes you through a much more advanced curriculum for Word users with more serious needs such as Legal resources, Office Managers, PA's and Business Analysts among others with advanced needs.

MODULE 1

1.1 Mail merge with wizard

1.2 Manual mail merge

1.3 Mail merge envelopes with wizard

1.4 Mail merge labels with wizard

1.5 Mail merge Word data source vs Excel data source

1.6 Mail merge basic sorting

1.7 Mail merge advanced filtering

MODULE 2

2.1 Viewing the TOC in different view modes

2.2 Creating and running a macro

2.3 Assigning shortcut key to macro 3

2.4 Deleting a macro

2.5 Working in outline view

2.6 Inserting indexes and creating bookmarks

2.7 Deleting indexes

2.8 Deleting bookmarks

MODULE 3

3.1 Working with master docs

3.2 Inserting and deleting sub docs

3.3 Entering footnotes

3.4 Inserting captions and labels

3.5 Entering cross references

3.6 Creating modifying deleting citations placeholders and bibliography

3.7 Marking legal citations and creating TA

Microsoft Excel Course

Although we have produce some of the most effective Excel courses for professionals, there are still many people who don't use Excel as much and don't need to be experts in the application. For those people we highly recommend this course created by the very experienced accounting professional Andrew Dove. It also serves as a refresher course as well as for those with an interview coming up shortly and requiring a brush up of their Excel skills.

MODULE 1. Starting Excel

1.1 Introduction

1.2 Overview

MODULE 2. What You Can Enter Into Excel

2.1 Combined What you can enter in a cell

2.2 Relative and Absolute Cell Referencing

2.3 Entering Formula

2.4 Order of Operations

2.5 Date Serial Numbers 

MODULE 3. Sheets, Rows and Columns

3.1 Copy and Drag

3.2 Working with rows and columns

3.3 Working with sheets 

MODULE 4. Functions, Ranges and Shortcuts

4.1 Functions

4.2 SUM Function

4.3 Copy and Drag Formula

4.4 more basic functions

4.5 Named Ranges

4.6 Names Constants and Formula

4.7 Shortcuts

4.8 More Shortcuts 

MODULE 5. Formatting and Conditional Formatting

5.1 Formatting Font

5.2 Formatting Alignment

5.3 Formatting Borders

5.4 Formatting Numbers

5.5 Conditional Formatting PreConfigured

5.6 Conditional Formatting with Formula

5.7 Conditional Formatting Dialogue Box Formula Trick 

MODULE 6. Printing

6.1 Icons Shapes and Formatting

6.2 Printing Page Layout

6.3 Printing Headers Footers

MODULE 7. Managing Data

7.1 Data Sort

7.2 Filtering

7.3 Tables

7.4 Text to Columns

7.5 Flash Fill

7.6 Data Validation

7.7 Group and Outline

7.8 Freeze Panes 

Microsoft Word Course

Our trainer is highly experienced corporate professional who brought her many years of using Office in some of the biggest, most high profile Global companies and created an incredible training course which will have you mastering Word in a few hours.

MODULE 1

1.1 Opening a new blank document

1.2 New blank doc 3 ways

1.3 Highlighting and adding text

1.4 Revealing formatting marks

1.5 Customising the QAT (quick access toolbar)

1.6 Changing the ribbon

1.7 Help menu and Search bar

1.8 Save and close doc

MODULE 2

2.1 Formatting big docs at a glance and applying headings

2.2 Explanation of headings

2.3 Spell check

2.4 Spell check cont'd

2.5 Removing extra paragraph and bullet spaces

2.6 Follow up formatting removing bulleted list spaces

MODULE 3

3.1 Inserting a page break

3.2 Creating a table and entering data-text

3.3 Creating a table and entering data-text cont'd

3.4 Creating a table from scratch

3.5 Creating a table from scratch cont'd

3.6 Creating a table – borders and shading

3.7 Creating a table - text direction and shading

MODULE 4

4.1 Preset margins

4.2 Orientation

4.3 Alignments and indenting

4.4 Margins manual adjustment

4.5 Formatting underline and bold

4.6 Cut and paste

4.7 Copy and paste

MODULE 5

5.1 Applying bullets and picture bullets

5.2 Numbered list

5.3 Basic multilevel list

5.4 Paragraph numbering

5.5 Multilevel list with headings

5.6 Inserting a cover page

MODULE 6

6.1 Convert text to table

6.2 Inserting and deleting rows and columns

6.3 Convert text to table with tabs

6.4 Working with text boxes

6.5 Working with text boxes cont’d

6.6 Linking text boxes