Microsoft Office Pick and Mix Training in Hong Kong

• Use of mouse and keyboard
• Ability to navigate the Windows environments
• Open and close programs

MICROSOFT EXCEL

90 min sessions

1. Excel (The Basics)

In this session, you will learn how to create a basic spreadsheet.

• Creating and editing a workbook
• Creating Basic Formulas including AutoSum
• Formatting a worksheet (Text formatting and cell alignment)
• Page layout options / printing a worksheet

2. Excel (Beyond The Basics)

In this session, you will build on Excel (The Basics) and use more features to enhance your spreadsheet

• Introducing Functions (SUM, AVERAGE, MIN, MAX, COUNT)
• Understanding Relative and Absolute cell references
• Further formatting features (Format Painter, Cell Styles)
• Managing worksheets and workbooks

3. Working with Data Lists

In this session, you will learn how to manage Data Lists using a variety of commands

• Flash Fill
• Text to columns
• Sorting and filtering
• Creating Custom Views
• Using Subtotals

4. Mastering Excel Tables

In this session, you will see the benefits of using Excel Tables to further analyse data lists

• Creating and Formatting Excel Tables
• Add calculations and totals to a table
• Using Slicers to filter data
• Managing tables

5. Visual Tools

In this session, you will insert Charts and use Sparklines to show trends and use Conditional Formatting to format cells based on rules.

• Creating and managing Charts
• Analyse data using Sparklines
• Creating Conditional Formatting
• Using Quick Analysis

6. Collaborating with Others

In this session, you will use features that allow you to control the entry of data into worksheets that are shared with others

• Data Validation
• Conditional Data Validation
• Protecting Cells, worksheets and workbooks

7. Logical Functions

In this session, you will use some of Excel’s Logical Functions to test conditions within cells

• IF, COUNTIF, SUMIF, AVERAGEIF
• COUNTIFS, SUMIFS, AVERAGEIFS (multiple criteria)
• IF Function with AND / OR
• IFERROR

8. Lookup and Reference Functions

In this session, you will create different LOOKUP functions to search for values and return value(s) from another location.

• Office 365 / Office 2016: VLOOKUP Functions
• Office 365 / Office 2019 Only (XLOOKUP / Dynamic Arrays)

9. Pivot Tables and Pivot Charts

In this session, you will use Pivot Tables to calculate, summarise and analyse data, showing trends and patterns in your data.

• Create and modify Pivot Tables
• Manage and configure Pivot Table fields
• Creating interactive reports using Slicers and Timelines
• Creating Pivot Charts

10. Text Functions

In this session, you will use some of Excel’s Text Functions to transform, extract and split data.

• Flash Fill
• UPPER, LOWER, PROPER
• CONCAT, TEXTJOIN
• Get and transform data using Power Query (if time)

MICROSOFT WORD

90 min sessions

1. Word (The Basics)

In this session, you will learn how to create, format and print a Word document.

• Creating and editing a document
• Formatting Text and Paragraphs
• Adding Headers and Footers
• Printing a document

2. Word (Beyond the Basics)

In this session, you will build on Word (The Basics) and use more features to enhance your document.

• Font and paragraph formatting
• Borders, Shading, Format Painter, Indents, Spacing
• Bullets, Numbering and Multi-level numbering
• Creating Styles
• Navigation Pane

3. Working with Graphics, Word Tables and Excel Charts

In this session, you will enhance your documents by inserting graphics, Word Tables and Excel Charts.

• Inserting Pictures
• Adding SmartArt Diagrams
• Create, Modify and Format Word Tables
• Inserting an Excel Chart

4. Word Mail Merge

This session will show you how to use Mail Merge to automate document creation.

• Creating a Mail Merge Letter
• Data Source linking using Word and Excel
• Creating Mailing Labels

5. Collaborating on Documents

In this session, you will learn how to use collaboration tools in Word to manage and review document changes.

• Inserting Comments
• Using Track Changes
• Track Changes Options
• Review Tracked Changes
• Restrict Editing

6. Managing Long Documents

In this session, you will incorporate various referencing tools into documents to help you manage long documents.

• Review of Heading Styles and Navigation Pane
• Insert Table of Contents
• Using Section Breaks

MICROSOFT POWERPOINT

90 min sessions

1. PowerPoint (The Basics)

In this session, you will learn how to create a basic PowerPoint Presentation.

• Creating and editing a Presentation
• Inserting a Slide Background
• Formatting Slides with Text and Pictures
• Adding Slide Transitions
• Running a Presentation

2. PowerPoint (Beyond the Basics)

In this session, you will build on your PowerPoint skills by use more features to enhance your presentation.

• Working with Sections
• Inserting and managing Shapes and Screenshots
• Adding Animation
• Creating Speaker Notes and Handouts

3. Adding Content

In this session, you will add content to enhance your slides and make your presentation look more professional.

• Re-use Slide Content
• Inserting Audio and Video Files
• Adding SmartArt Diagrams
• Inserting an Excel Chart
• Inserting a Word Table

4. Customising a Slide Show

In this session, you will learn quick ways of running your slideshow.

• Inserting Hyperlinks and Action Buttons
• Creating Custom shows
• Setup a Slide Show / slide show controls
• Slide Annotations
• Presenter View

MICROSOFT OUTLOOK ONLINE

90 min sessions

1. Mailbox Management

• Email Basics and working with Attachments
• Setting up Automatic Replies
• Creating Search Folders
• Creating Email Signatures
• Sorting and Filtering Emails
• Using Flags
• Setting up Email Rules
• Using Quick Steps
• Access Another User’s Folder

2. Calendar Management

• Calendar Views
• Creating an appointment and a Recurring Appointment
• Creating a Meeting
• Setting Calendar Options
• Colour Categories
• Sharing Calendars

MICROSOFT ONENOTE ONLINE

90 minute session

This will give you a basic introduction to Microsoft OneNote. OneNote is a digital notebook that provides a single place to gather notes and information to use for your own use or to share with a Team.

• Explore the OneNote Interface
• Creating a Notebook, Adding Sections and Pages
• Adding Content from Excel, Word and Webpages

MICROSOFT VISIO ONLINE

90 minute session

This will give you a basic introduction to creating a Process Flowchart in Microsoft Visio. Visio is an application for creating diagrams using pre-installed templates e.g. Process Flowcharts, Organisation Charts, new office layouts and many more diagrams.

• Explore the Visio Interface
• Creating and formatting a Process Flowchart
• Creating an Org Chart