MS Excel - From 0 to Working Professional in 1 hour

Learn Excel as fast as possible
4.3 (160 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,566 students enrolled
Free
Start Learning Now
  • Lectures 22
  • Contents Video: 43 mins
    Other: 1 min
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

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.

About This Course

Published 5/2016 English

Course Description

This course covers Excel basics in the way that's very short and concise. You may use Excel before but this course shows you a better way of using these functions in real work environment. If you are going back to workforce, or looking for jobs, this is the fastest way to refresh your skill or Jump Start your skills. Within 1 hour, you can use Excel the way a working professional would use.  

This course IS NOT for everyone because of 2 things

1. Excel is powerful. Microsoft tries to make Excel as relevant to anyone as possible. However, each occupation use Excel differently. I've no idea how scientists or engineers use Excel. But I know how working professionals, especially analysts use Excel. I've worked as Business Analyst, Market Analyst, and till this day a full time Financial Analyst. Excel changed my life, I get hired, get promoted because that. I hope more people can do the same and better.

2. The pace of the course is super fast. If you like things go slowly, this is NOT for you. This course covers basic Excel. Most of the things in this course should be learnt by doing. Therefore I have enclosed a downloadable workbook. You can see me demonstrating on the left side of the sheet, while you would be practicing on the right.  

What are the requirements?

  • Have Excel 2007 or above installed in the computer

What am I going to get from this course?

  • 50% increase in productivity
  • Start using Excel as fast as possible
  • The right way to use many functions in Excel

What is the target audience?

  • People who are looking for jobs
  • Refresh Excel skills
  • People who are tired of watching long Youtube tutorial videos
  • This course is NOT comprehensive training, it's a quick start guide
  • This is NOT for people who want to learn VBA or coding

What you get with this course?

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

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Things you need to know before learning
Watch this before you start
01:38
How to download course file
Article
How to learn more
Article
Excel Road Map and What's covered
03:20
01:57

Skip this video if you use Excel before. 

Section 2: Excel Formula Hack
Simple Calculation
01:02
Relative and Absolute Reference
01:53
Autofill
01:27
3X your productivity using 3 shortcuts + 1 useful tip
03:01
Basic Excel Formulas
04:15
When to use which function and how to learn
02:06
Check in with you
01:43
Section 3: Excel Function Hack
Basic Formatting-From Basic to Best Sequence
04:21
Group & Freeze Panes - From Basic to Fancy way to use it
01:51
Format as Table Basic and Why Use it
01:50
Filter in table and in range, Pros&Cons
01:47
Conditional Formatting - From Basic to Fancy
03:35
Format Painter- the Right Way
01:08
Comment- Best Practice
02:19
Section 4: Bonus Lecture
Data Validation - Creative Way for Data Entry
02:10
Closing Remark
01:15
Coupons are here
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Jason Zhang, Financial Analyst

Jason has worked as a financial analyst, business analyst, and research analyst from start-up to fortune 500 companies. He holds a Master Degree in Finance from the Johns Hopkins University. He passed CFA level 3 exam.

Jason dedicates his time to help analysts get promoted, get better job and better life, starting from having outstanding Excel skills.

Excel is a powerful tool. It's like golf. You can learn it within several hours, but improve it for the rest of your life. There are tons of free materials out there. But you need structured lectures to build a good mindset in order to reach your goal, which is getting the job done beautifully. So that you can ask for raise, for promotion, even your dream job.

Ready to start learning?
Start Learning Now