Course Outline:

Workbooks

• Concepts of a Workbook
• Moving around a Workbook
• Inserting and deleting worksheets
• Renaming and moving worksheets
• Linking worksheets with formulas
• Workbook defaults

Linking

• Understanding the concepts of Linking
• Using formulas to link sheets
• Linking files using formulas
• Using Paste Link to link files
• Linking to other Microsoft Office programs

Range Names

• What is a Range Name?
• Creating and defining Range Names
• Deleting Range Name
• Using Range Names for navigation
• Using Range Names in formulas

Further Functions

• Writing formulas using Paste Function
• Basic statistical functions

Conditional Functions

• An introduction to Conditional Functions
• Using the IF function

Conditional Formatting

• An introduction to Conditional Formatting
• Creating a Conditional Format
• Modifying and deleting Conditional Formats
• Defining multiple Conditional Formats
• Using Data Visualisations

Data Validation

• Why use Data Validation?
• Using Validation to restrict data input
• Defining Input Messages and Error Alerts

Protecting Data

• Protect cells within a workbook
• Hiding worksheets within a file
• Protecting the structure of a workbook
• Password protecting Excel files

Workbook Templates

• Templates vs. workbooks
• Creating and saving a Template
• Modifying a Template

Working with AutoFilter

• Concepts of AutoFilter
• Sorting Lists
• Text Filters
• Number Filters