Do you understand how Excel works? Then this Microsoft Excel Intermediate Course is for you. It is designed for Excel 2013, 2016, 2019 & 365.
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.
A working knowledge of creating/formatting simple spreadsheets, basic formulas and functions e.g. AutoSum. Or our Excel Introduction course.
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
Send us a message & we will respond shortly
Enter your name, like you want it to appear on your Certificate