How to Create a Pivot Table
How to create a Pivot Table and how to avoid invalid data. This 3 hr course will cover the essentials that you will need to get you started. Setting your data up ready to make into a Pivot Table. Change Report Layouts, group dates by year, create totals, averages and percentages.
Half Day Courses
Session 1: Pivot Tables
This short half day course will cover how to set out your data correctly ready for creating pivot tables and pivot charts, you will learn the basics to get you going.
Session 2: Functions: If, Absolute
This short half day course will guide you through the syntax of an If function, used to return two possible answers in Excel. The Absolute cell referencing is used to lock a cell. It's when you see $A$1, there are 3 combinations of where the $ is positioned.
Session 3: Range names and Vlookup
This short half day courses will show you how to create a Vlookup using a range name for the table syntax. A Vlookup is used to compare and return data from a particular column in a Master List.
Session 4: Create a Basic Macro
You will be able to create a macro to run a subtotal and assign a command button to a macro.