Excel Intermediate Course Outlines
Pre requisitsDuration: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. |
TopicsModule 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. |