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!
Have thoughts and comments? Enter here!
Facebook