Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Update 6/8/16: Students have told me repeatedly that PivotTable is something they find most useful in their work - check it out in this course!
Update 11/6/15: NEW bonus material added! Do you know flashfill? You would not believe what it can do!
Update 5/30/15: To download all Excel files, go to excelprof dot com, and follow direction there.
Update 5/30/15: We have now more than 500 registered students! With 5-star rating!
Have you wondered how some of your colleagues are always able to get ahead with their data analysis?
The answer is that they are proficient in the tools they use.
The same is true with using Microsoft Excel.
Today, always very business person uses Excel. And yet only a small set of them know how to use Excel truly effectively and efficiently.
From my over ten years of teaching MBA students, I have gained a good understanding of what specific Excel skills companies of all lines of businesses are looking for in a successful employee (By the way, year over year, more and more employers say they want people with good Excel skills). The course gives you the top 10 Excel skills that will enable you to acquire some of those highly-sought-after skills.
These top ten skills are:
1. Use Ctrl (⌘) + Arrow key to quickly navigate in a data set
2. Find and augment data quickly: VLOOKUP
3. Find numbers quickly: INDEX and MATCH
4. Select data that meet certain conditions: COUNTIF and SUMIF
5. Multiply and sum up numbers with SUMPRODUCT
6. Work with Texts:
7. Find Top and Bottom Performers: LARGE and SMALL, PERCENTILE
8. Slice and dice data with PIVOTABLE
9. Absolute and relative reference with “$"
10. Perform What-if analysis with DATATABLE
Once you have mastered your skills, you will see immediate results - higher productivity, better Excel spreadsheets, and more work done.
Sign up NOW!
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
|Section 2: Top 10 Excel Skills For Business Professionals|
Use Ctrl (⌘) + Arrow key to quickly navigate in a data set
Find data quickly: VLOOKUP
Find numbers quickly: INDEX and MATCH
Select numbers that meet certain conditions: COUNTIF and SUMIF
Multiply and sum up numbers with SUMPRODUCT
Work with Texts
PERCENTILE, SMALL and LARGE
Slice and dice data with PivotTable
Absolute and relative reference with "$"
Perform sensitivity analysis with DATATABLE
|Section 3: Bonus and Further Learning|
Bonus: Net Present Value - the most used function in Finance
Bonus: Flashfill (Windows only) is a Godsend
Dr. Justin Ren is an Associate Professor of Business Administration in the Operations and Technology Management Department, Dean's Research Fellow, and Senior Fellow of Health Policy Institute at Boston University School of Management. He was also a Visiting Scholar and Research Affiliate at Massachusetts Institute of Technology (MIT) Sloan School of Management from 2009-2013.
For almost ten years, Professor Ren has been teaching analytics courses which focuses on tools and frameworks that help managers gain market intelligence and make strategic decisions. He also teaches in executive education in financial risk management. He is a certified teacher by the Harvard Business School Case Method Discussion Leadership Program.
Professor Ren has consulted for Fortune 500 companies as well as start-ups. His work has been mentioned in Sloan Management Review, China Daily, and the World Financial Review. He has been invited to give lectures and presentations around the world at institutions such as Harvard University, MIT, Duke, Dartmouth, Georgetown, Emory, INSEAD (France), Hong Kong University of Science and Technology, Peking University (China), and Tsinghua University (China).
Professor Ren received his M.S. in Operations Research and Ph.D. in Operations and Information Management from The Wharton School at the University of Pennsylvania.