Desktop IT Intermediate Excel classroom

About the course

Building on your existing knowledge of Excel, this course includes formulas that link worksheets together and linking workbooks, getting Excel to make decisions using the IF function and adding conditional formatting to highlight certain data. You will learn how to create templates for commonly used worksheets and protect data using the security features. You will gain an insight into data tables and use Excel lookup features to automate worksheets. This course will also enable you to create, build and customise graphs including plotting trend lines. You will learn how to use the new sparklines features and data bar enhancements.

Learning objectives

Be able to use Excel to make decisions using the IF function
Understand conditional formatting and highlighting certain data
Be able to use lookup functions for range and exact matches
Know how to use the new Quick Analysis tools and sparklines, apply filters and sort larger data sets
Work with tables and see how useful they can be