This course requires Basic knowledge in Excel.
This Virtual Class course on Microsoft Excel is intended for participants who has basic knowledge in Excel and want to go beyond the spreadsheet capabilities. The “Table” feature of Excel allows you to have a dynamic range which automatically expands as you add data and provides flexibility to formula ranges. In addition, this course also introduces lookup functions such as the popular VLOOKUP.
At the end of this course, the participant should be able to:
Create and Manage Name Ranges and Dynamic Table in MS Excel
Utilize the VLOOKUP and HLOOKUP Functions
Lesson 1: Organizing Worksheet and Table Data
Create and Modify Name Ranges
Create and Modify Tables
Calculate Data in a Table or Worksheet
Lesson 2: LOOKUP FUNCTIONS
What are LOOKUP Functions
Setting up Table Array
VLOOKUP and HLOOKUP
Who Should Join
Experienced users who want to maximize their learning and further improve their ability in Formulas and Analysis in MS Excel. This also targets people who really work heavily in MS Excel and want to discover a faster and reliable way of dealing with huge amount of records and reports.