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

Download Excel File

Topic: Find exact match with VLOOKUP

Download Excel File

Topic: Categorize data with VLOOKUP

Download Excel File

Topic: Autmatically reference a cell with MATCH and INDEX

Download Excel File

Topic: SUMPRODUCT and SUMIF

Download Excel File

Topic: COUNT, COUNTA and COUNTIF

Download Excel File

Topic: Uncover correlation in data

Download Excel File

Topic: Identify high performers with RANK

Download Excel File

Topic: Set cutoffs with QUARTILE/PERCENTILE

Download Excel File

Ready to go to another module?

XBP Module 0: Road Map and Excel File Download

XBP Module 0: Road Map and Excel File Download
XBP Module 1: Work Faster and Better in Excel

XBP Module 1: Work Faster and Better in Excel
XBP Module 2: Organizing Data

XBP Module 2: Organizing Data
XBP Module 3: Master Financial Functions

XBP Module 3: Master Financial Functions
XBP Module 4: Charts and Graphs

XBP Module 4: Charts and Graphs
XBP Module 5: Scenario Analysis and What-ifs

XBP Module 5: Scenario Analysis and What-ifs
XBP Module 6: PivotTable

XBP Module 6: PivotTable
XBP Module 7: Find Patterns in Data

XBP Module 7: Find Patterns in Data

Discussion Area

Have a question or comments?  Enter below!