* 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