Excel Training at Ipoh – Kent Lau

Using Excel Time Saving Advanced Formulas
Using Formulas to Conditionally Summarize Data
– SUMIF, COUNTIF
Using Formulas to Look Up Data in a Workbook
– VLOOKUP, MATCH, INDEX

Adding Conditional Logic Functions to Formulas
– IF, IF + VLOOKUP

Using Formulas to modify Text
– MID, RIGHT, LEFT, LEN, TEXT, CONCAT

Adding Comments
How to Insert A Comment
How to View a Comment
How to Edit a Comment
How to Delete a Comment
How to Print Comments in a Workbook

Outlining and Subtotaling Data
Grouping and Ungrouping data
Auto-Outlining Data
Collapsing groups of data in an outline
Subtotaling data in outlines

Pivot Table and Pivot Chart
Creating Your First Pivot Table Report
Creating Your first Pivot Chart

What If Analysis
Goal Seek
Data Table
Scenario Manager

Introduction to Excel’s Macro/VBA
How to record your first basic macro
2 Ways to run a macro
Managing macro security

Securing Your Well designed Excel template with Password
Protecting a Well designed Dashboard
Protecting a workbook with password

Tracking Changes
How to turn Track Changes On and Off
Setting Track Change Options
Inserting Tracked Changes
Deleting Your Changes
How to accept Changes from Another User
How to Reject Changes from Another User