Excel Level 2

A one-day course to build on Excel Level 1

Prerequisite: Microsoft Excel Level 1 with some experience and practice

COURSE CONTENTS

Module 1: Fundamentals revisited
BODMAS or BEDMAS
Absolute vs relative cell referencing
Basic functions

Module 2: Viewing and Organising Worksheet Data
The zoom feature
Using freeze panes
Hiding rows and columns
Grouping data
Creating subtotals

Module 3: Working with Tables
Creating a Table
Parts of a Table
Naming a Table
Navigating to a Table
Column Headers
Selecting an Entire Column
Selecting an Entire Row
Selecting an Entire Table
Adding a Total Row
Converting a Table Back to a Normal Range

 Module 4: Sorting and Filtering Data

Sorting Data
Filtering Data
Types of Filters
Wildcards

Module 5: Working with Dates

Dates in Excel
Inserting and Formatting Dates
Entering Date Functions
Using Dates in Formulas

Module 6: Conditional Formulas and Formatting
Conditional formatting
Applying conditional formatting
Using the manage rules option
Creating a conditional formatting rule
Removing conditional formatting

Module 7: Documenting and Auditing
The formula auditing group

Module 8: Worksheet Protection
Unlocking cells
Protecting your worksheets

Module 9: Using Templates
What is a template?
Creating a workbook from a template
Creating a template

Module 10: Working with Charts
Creating a chart
Manipulating a chart
Formatting a chart

Module 11: Printing Large Worksheets
Print titles
Page break preview
Inserting a page break
Printing multiple sheets

Module 12: Multiple Worksheets and Workbooks (Bonus Module if time permits)
Inserting worksheets
Navigating between sheets
Consolidating data
Creating 3-D formulas
Linking workbooks
Using the paste link option
Creating a formula to link workbooks
Controlling link updates
Manually update all of the links or none of the links in a workbook
Manually update only some of the links to other workbooks
Dealing with broken links

Quick reference: Excel shortcuts
Ctrl combination shortcut keys
Function keys
Other useful shortcut keys

You can view all our courses HERE