Top 10 Excel Skills for Business Professionals

By Professor Justin Ren

Hi - A warm welcome to the class!

After you finish this course, please let me know what you think by writing on the discussion area below the videos!

Introduction

Skill #1:  Use Ctrl (Cmd) + Arrow key to quickly navigate in a large data set

Download Excel File

Skill #2: Find data quickly using VLOOKUP

Download Excel File

Skill #3: Find numbers quickly using INDEX and MATCH

Download Excel File

Skill #4: Select numbers that meet certain conditions using COUNTIF and SUMIF

Download Excel File

Skill #5: Multiply and sum up numbers with SUMPRODUCT

Download Excel File

Skill #6: Work with Texts

Download Excel File

Skill #7: Identify top and bottom performers with PERCENTILE and QUARTILE

Download Excel File

Skill #8: Slice and dice data with PivotTable

Download Excel File

Skill #9: Absolute and relative referencing with "$"

Download Excel File

Skill #10: Perform sensitivity analysis with DataTable

Download Excel File

Bonus: Net Present Value (NPV) the most used financial function

Download Excel File

~~~

Thank you for taking this course.

Have a question or thought? Want me to cover something in particular? Or have a question to your fellow students?  Enter your comments below!

arrow

Have thoughts and comments? Enter here!