Excel for Business Professionals

Module 2: Process Data

24% Complete

Introduction

In this module, we will learn essential skills in processing and transforming data.

If you have any questions or comments, please enter your comments in the "Discussion Area" below the videos.  We learn better through discussion and mutual support!

Topic: Use IF Statement

Topic: Find exact match with VLOOKUP

Topic: Categorize data with VLOOKUP

Topic: Autmatically reference a cell with MATCH and INDEX

Topic: SUMPRODUCT and SUMIF

Topic: COUNT, COUNTA and COUNTIF

Topic: Uncover correlation in data

Topic: Identify high performers with RANK

Topic: Set cutoffs with QUARTILE/PERCENTILE