Microsoft Excel Intermediate, 1-Day Training Course in Melbourne
Event description
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
Tickets for good, not greed Humanitix dedicates 100% of profits from booking fees to charity