Home Specialist skills Technology and Software Microsoft Excel Intermediate

Microsoft Excel Intermediate

Summarise multiple sheets of data into one
Transform long lists and reports into easy-to-read tables
Use 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
Ensure formatting and layout consistency by saving as a Template.

Overview

Off the shelf (OTS)

Learn how to quickly summarise multiple sheets of data into one, turn long lists and reports into easy to read tables, create links between cells so that they all update automatically, Highlight targets, trends, duplicates and errors with Conditional Formatting.

Please note that this course uses Microsoft Excel for Windows. It’s not suitable for Excel for Mac. Courses for Mac users are available on request

Visit the open course schedule