Become a Microsoft Excel Wizard in 1 Hour

This tutorial can be used with Excel 2010, Excel 2013, and Excel 2016
4.5 (190 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.
7,030 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 15
  • Length 1 hour
  • Skill Level All Levels
  • 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 10/2015 English

Course Description

Don't waste your time on long, boring course that you may never finish. Learn essential Microsoft Excel skills in 1 hour that will help you to:

  • Save time
  • Boost earning potential
  • Impress your boss


This course will help those with a basic understanding of Excel to turbocharge their skills (and become the office superhero). It covers critical features which provide the most immediate value. Each is clearly explained in video tutorials, which you can follow along with using the sample file. A quick reference guide is also included that can be taken to the office so you will know what feature to use and when to use them.

This course will work with Excel 2010, Excel 2013, and Excel 2016.

What are the requirements?

  • A very basic understanding of Excel.

What am I going to get from this course?

  • Sample file to follow along.
  • Quick reference guide to take to the office.

What is the target audience?

  • Anyone looking to turbocharge their Excel skills -- fast.

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: Course Materials
01:01

An overview of the course outcomes and content.

1 page

An overview and example of each of the essential skills below.

1 page

This file can be used to accompany the tutorial in each lecture.

Section 2: Essential Skills
02:14

Allows you to copy patterns from one cell to another.

05:03

Allows you to explore your data by filtering and sorting.

06:47

Allows you to control the input you receive from others and keep your spreadsheets clean.

02:32

Flips a table so the columns become rows (and vice versa).

07:44

Allows you to search for related information in your spreadsheet or other spreadsheets.

00:13

You are halfway there!

04:03

Performs an action if certain conditions are met.

06:21
Automatically summarizes your data. You can "slide-and-dice" in a million ways.
05:10

Changes the format of a cell when it meets certain conditions.

06:45

Some people may never look at your detailed data. A great chart helps them understand it.

06:35

Sometimes data looks messy or weird. This will help you fix it.

Section 3: Bonus Material
02:07

How to add additional value with you spreadsheets.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Cody Baldwin, The Excel Guy

I am an MBA grad and IT manager that leads global IT programs across 3 continents and 6 countries for a Fortune 100 company. I am passionate about data and teaching, but combining these two disciplines is even better. I look forward to helping you on your journey of continuous education and improvement.

Ready to start learning?
Take This Course