Microsoft Excel Intermediate, 1-Day Online Training Course

* Please note that this is an online course, delivered remotely by a live instructor through Zoom *

Course Code: EXLINT

Duration: 1 Day

Overview

This one-day Excel Intermediate course takes learners through techniques associated with creating better and more productive workbooks. As well as covering several Excel functions, including logical & date and time functions, this one-day course includes data set-up and management techniques, conditional formatting, advanced charting features and more streamlined methods to enhance efficient spreadsheet creation.

Audience

Designed for current Microsoft Excel users, this course is for those wanting to build on existing fundamental skills to go beyond building simple workbooks. At the end of the course, students should be able to use advanced techniques to analyse, manipulate and manage complex data and in the process create effective workbooks more efficiently.

Prerequisites

Participants should have already completed the Excel for Beginners course before attending this course, or have equivalent skills creating and printing formatted spreadsheets containing simple formulas and functions.

Module List

• Module 1: Filling Data in Excel
• Module 2: Formula Referencing
• Module 3: Defined Names
• Module 4: Essential Functions
• Module 5: Logical Functions
• Module 6: Date and Time Functions
• Module 7: Conditional Formatting
• Module 8: Working with a Worksheet
• Module 9: Worksheet Techniques
• Module 10: Finding and Replacing Data
• Module 11: Importing and Exporting Data
• Module 12: Sorting Data in Excel
• Module 13: Filtering Data in Excel
• Module 14: Creating Charts in Excel
• Module 15: Chart Elements
• Module 16: Chart Object Formatting

Click here for the full 'Excel Intermediate' course outline