Microsoft Excel Intermediate Training Course

Do you understand how Excel works? Then this Microsoft Excel Intermediate Course is for you. It is designed for Excel 2013, 2016, 2019 & 365.

Who is this course for?

This Excel intermediate course is designed for people who have used Excel before and want to expand their knowledge. Improving formatting, organising data, highlighting key information and creating formulas/links between sheets.

Prerequisites

A working knowledge of creating/formatting simple spreadsheets, basic formulas and functions e.g. AutoSum. Or our Excel Introduction course.

Benefits

  • Quickly summarise multiple sheets of data into one
  • Turn long lists and reports into easy to read tables
  • Formulas to check whether cells pass or fail your rules
  • Create links between cells so that they all update automatically
  • Highlight targets, trends, duplicates and errors with Conditional Formatting
  • Formatting and layout consistency by saving as a Template

Course Outline

Working with Multiple Worksheets and Workbooks

Using multiple worksheets
– Navigating between sheets
– Moving and copying sheets
Linking worksheets
– Creating 3-D formulas
– Consolidating data

Working with dates

Entering date functions
– TODAY function
– NOW function
Date and time formats
Using dates in formulas

Conditional Formulas and Formatting

The IF function
Conditional formatting
Creating named ranges
Using named ranges in formulas
COUNTIF(s), SUMIF(s), AVERAGEIF(s)

List Management

Working with lists
Creating dynamic ranges
Sorting and filtering lists
Sorting by multiple columns
Using AutoFilter
Tables

Documenting and Auditing

Best practice spreadsheet design
Viewing, adding, editing and deleting comments
Auditing features
Tracing formula errors
Protecting a worksheet
Protecting cell ranges

Creating Charts

Creating and modifying charts
Adding trendlines
Visualising multiple data sets
Using Sparklines

Training Mode

  • Online/virtual
  • Physical/in-person

Get In Touch

Send us a message & we will respond shortly

WhatsApp-Image-2022-06-15-at-10.43.56-AM.jpeg

Registration Form

Enter your name, like you want it to appear on your Certificate