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
