Microsoft Excel Intermediate

Microsoft Excel Intermediate Logo

Microsoft Excel Intermediate

Aims: Looks deeper into Excel, including analytical and data retrieval formulas

Pre-requisites: Must have attended the Microsoft Excel Introduction or have a good working knowledge of the product

Duration: One day

 

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
Using Cell Comments and Auditing

Range Names
What is a Range Name?
Using the Name Manager
Creating and defining Range Names
Deleting Range Names
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
Sorting by colours
Text Filters
Number Filters
Date Filters
Colour Filters

For further information on our Microsoft Excel Intermediate Course, please contact us via the contact page, or alternatively telephone the office on 0113 243 2226