top of page

Dynamic Lookups in Excel

DURATION: 2 hours 

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:      

                             

  1. Create and Manage Name Ranges and Dynamic Table in MS Excel

  2. 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.

bottom of page