Prerequisites
This course requires Basic knowledge in Excel.
Course Description
Course Description
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.
Course Objectives
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
Course Content
Lesson 1: Organizing Worksheet and Table Data
-
Create and Modify Name Ranges
-
Create and Modify Tables
-
Format 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.