# Top 10 Excel Skills For Successful Business Professionals

Learn how successful business professionals and managers are using Microsoft Excel with maximal efficiency
3.9 (112 ratings) 1,873 students enrolled
Instructed by Justin Ren
Free
• Lectures 13
• Length 1 hour
• Skill Level All Levels
• Languages English
30 day money back guarantee!
Available on iOS and Android
Certificate of Completion
Wishlisted Wishlist

### Discover

Find online courses made by experts from around the world.

### Learn

Take your courses with you and learn anywhere, anytime.

### Master

Learn and practice real-world skills and achieve your goals.

Published 5/2015 English

### Course Description

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: 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.

### What are the requirements?

• Just fire up your Excel on your computer, tablet or phone, and start learning!
• This is an introductory course, but it covers some advanced skills such as PIVOTABLE.
• Advanced users should check out my other speciality courses offered on Udemy

### What am I going to get from this course?

• Master essential Excel functions and formula that are most used in workplace
• Be more productive with the skills we teach in this course

### Who is the target audience?

• Anyone who is interested in increasing his or her productivity and skills in Excel
• Anyone who wants to be a better Excel user
• This course covers some introductory functions such as LARGE and SMALL, but also some intermeidate skills such as VLOOKUP
• Some advanced techniques such as PIVOTABLE is also covered

### What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

# Curriculum

Section 1: Introduction
Introduction
02:55
Section 2: Top 10 Excel Skills For Business Professionals
Use Ctrl (⌘) + Arrow key to quickly navigate in a data set
01:23
Find data quickly: VLOOKUP
03:25
Find numbers quickly: INDEX and MATCH
04:43
Select numbers that meet certain conditions: COUNTIF and SUMIF
03:04
Multiply and sum up numbers with SUMPRODUCT
04:48
Work with Texts
04:19
PERCENTILE, SMALL and LARGE
03:15
Slice and dice data with PivotTable
05:54
Absolute and relative reference with "\$"
03:24
Perform sensitivity analysis with DATATABLE
02:59
Section 3: Bonus and Further Learning
Bonus: Net Present Value - the most used function in Finance
02:38
Bonus: Flashfill (Windows only) is a Godsend
02:57