Excel Intermediate Course Outlines
Duration:2 Day (8:30 am - 3:30 pm)
Objective: To become familiar with functions and working with multiple sheets.
Essential: An awareness of keys on keyboard e.g.: Shift, space bar, and Enter key. Completed Introduction or equivalent.
Learning Outcome By the end of the day you will be able to understand Absolute cell references, have a greater understanding of Functions & linking sheets. You will be more confident in manipulating data.
Module 1 Cell Referencing Mixed Absolute Cell Referencing.
Module 2 Range Names: Defining a Range Name Creating a Range Name Using range names in Functions Create Range Name from Selection Paste List.
Module 3 Functions: Basic IF Function SumIf, CountIf Nested If Functions IF with And/Or/Not Vlookup.
Module 4 Arrays: Using Array instead of Absolute Creating Arrays Edit an array.
Module 5 Working with Sheets: Create Multiple Sheets using Group mode Naming/ Deleting/Inserting Moving/Copying Linking sheets External sheet linking 3D Formulas Data Consolidate.
Module 6 Working with Data: Sorting/Filtering Sort/Filter by Colour Filter by dates Using Search filter Create a Table Sheet Protection Workbook Protection.
Module 7 Graphs: Creating Graphs using Insert Creating Quick Graphs Manipulating Graphs Change Chart types Change Layouts Combinations charts Secondary axis.