Excel for Business Professionals

By Professor Justin Ren

WELCOME! I am so excited that you can join us.

Below you will find the list of each module. Module 0 lists all the topics covered in this course and provides all the downloadable Excel files that each teaching module uses. Modules 1-4 contain all the training videos for each topic.  I recommend that you download each file, open it in Excel, and then go to each module to watch videos on each topic.

Let's get started!

XBP Module 0: Road Map and Excel File Download

XBP Module 0: Road Map and Excel File Download

This module will get you started using Excel by showing you some Excel basics and tricks that are important for daily professional work.
XBP Module 1: Work Faster and Better in Excel

XBP Module 1: Work Faster and Better in Excel

This module will get you started using Excel by showing you some Excel basics and tricks that are important for daily professional work.
XBP Module 2: Organizing Data

XBP Module 2: Organizing Data

This module will teach you skills in processing and transforming data in Excel.
XBP Module 3: Master Financial Functions

XBP Module 3: Master Financial Functions

This module will teach you most useful Excel 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