Become a Microsoft Excel Wizard in 1 Hour
4.6 (369 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.
9,393 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Become a Microsoft Excel Wizard in 1 Hour to your Wishlist.

Add to Wishlist

Become a Microsoft Excel Wizard in 1 Hour

This tutorial can be used with Excel 2010, Excel 2013, and Excel 2016
4.6 (369 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.
9,393 students enrolled
Created by Cody Baldwin
Last updated 10/2015
English
Price: $20
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Sample file to follow along.
  • Quick reference guide to take to the office.
View Curriculum
Requirements
  • A very basic understanding of Excel.
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.

Who is the target audience?
  • Anyone looking to turbocharge their Excel skills -- fast.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 15 Lectures Collapse All 15 Lectures 58:35
+
Course Materials
3 Lectures 01:01

An overview of the course outcomes and content.

Preview 01:01

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

Quick Reference Guide
1 page

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

Excel Sample File
1 page
+
Essential Skills
11 Lectures 53:27

Allows you to copy patterns from one cell to another.

Preview 02:14

Allows you to explore your data by filtering and sorting.

Preview 05:03

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

Data Validation
06:47

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

Transpose
02:32

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

Vlookup
07:44

You are halfway there!

CHECKPOINT
00:13

Performs an action if certain conditions are met.

If Statements
04:03

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

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

Conditional Formatting
05:10

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

Charts
06:45

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

Data Cleaning
06:35
+
Bonus Material
1 Lecture 02:07

How to add additional value with you spreadsheets.

Preview 02:07
About the Instructor
Cody Baldwin
4.6 Average rating
367 Reviews
9,393 Students
1 Course
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.