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!


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

Skill #2: Find data quickly using VLOOKUP

Skill #3: Find numbers quickly using INDEX and MATCH

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

Skill #5: Multiply and sum up numbers with SUMPRODUCT

Skill #6: Work with Texts

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

Skill #8: Slice and dice data with PivotTable

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

Skill #10: Perform sensitivity analysis with DataTable

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


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!


Have thoughts and comments? Enter here!