Intermediate Excel: Crash Course w/ Downloadable Excel Files
4.3 (817 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.
20,553 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Intermediate Excel: Crash Course w/ Downloadable Excel Files to your Wishlist.

Add to Wishlist

Intermediate Excel: Crash Course w/ Downloadable Excel Files

Microsoft Excel: Hone Core Skills in Microsoft Excel in 1+ Hours (Downloadable Excel Files Included in Course)
4.3 (817 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.
20,553 students enrolled
Last updated 7/2017
English
Price: Free
Includes:
  • 1.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Use and employ 10 of Excel’s most powerful intermediate tools
  • Create instant sums, averages, high and low values with Autosum
  • Get one-touch access and customize the Quick Access Toolbar
  • Save time with the Shortcut Menu and Mini Toolbar
  • Use and deploy the Quick Analysis Tool (New to Excel 2013)
  • Create datasets and labels with the Fill Handle
  • Construct, break apart, and re-organize data with Flash Fill (New to Excel 2013)
  • Instantly create, modify, and update Charts & Graphs
  • Use Recommended Charts (New to Excel 2013)
  • Use Sorting and Filters to better organize data and lists
  • Create, modify, and remove Tables from existing data
View Curriculum
Requirements
  • Basic understanding of worksheets, workbooks, selections, etc.
Description

Course Highlights:

  • 10 Individual, Bite-Sized Lessons
  • Downloadable Excel Files
  • Verifiable Certificate of Completion
  • Instant Access to Instructor and the ProductivityMe Community
  • 1080p HD Quality Video

In this Course:

Learning Excel takes time, particularly if you try to do it without any structure!

In this course, we'll walk you through the top ten skills you need to know in order to excel in Microsoft Excel!

Give us an hour, and we’ll help you to get to the next level of mastery in Microsoft Excel.

In this short, easy-to-follow training course...

We'll Cover:

  1. Autosum
  2. The Quick Access Toolbar
  3. The Shortcut Menu & The Mini-Toolbar
  4. The Quick Analysis Tool
  5. The Fill Handle
  6. Flash Fill
  7. Charts & Graphs
  8. Recommended Charts
  9. Sorting & Filters
  10. Tables

Our Approach:

At the end of each video, you have the chance to prove your mastery by completing a small practice exercise thus testing the core skill that you’ve just learned.

You can easily follow along in each lesson by using the downloadable course exercise files provided in Lecture 2.

If you have questions, comments, ideas, we’d love to hear from you. Email or message us any time.

Final Thoughts:

Alright, that’s it for now.

Look forward to having you in class!

Cheers,

Tolan & Ryan
ProductivityMe Co-Founders

Who is the target audience?
  • Course is designed for Windows (PC) users of Microsoft Excel (2010, 2013, or 2016)
  • Course is taught using Excel 2013; certain features shown may not be available for users of Excel 2010
  • Course is NOT designed for Mac users
Students Who Viewed This Course Also Viewed
Curriculum For This Course
14 Lectures
01:17:08
+
Getting Started in the Course
2 Lectures 05:24
Introduction to the Course
02:14

DOWNLOAD: Course Excel Files
03:10
+
Core Tools in Excel
11 Lectures 01:09:21
Autosum
07:11

The Quick Access Toolbar
06:57

The Shortcut Menu & Mini-Toolbar
04:34

The Quick Analysis Tool (New to Excel 2013)
05:42

The Fill Handle
06:11

Half-Way Checkpoint
00:23

Flash Fill (New to Excel 2013)
07:15

Charts & Graphs
09:21

Recommended Charts (New to Excel 2013)
04:41

Sorting & Filters
08:00

Tables
09:06
+
Course Wrap-Up
1 Lecture 02:23
Final Thoughts & Next Steps
02:23
About the Instructor
The ProductivityMe Company
4.1 Average rating
1,692 Reviews
36,654 Students
26 Courses
Excel Tips, Tricks, & Tutorials, One Lesson at a Time.

ProductivityMe

Try. Learn. Conquer. Excel.

We create short, engaging videos that help people Master Excel.

We offer simple and easy-to-follow courses, and like our thousands of students, we’re always excited to learn cool new things.

This is ProductivityMe.

Udemy Course Instructors

Tolan Thornton
ProductivityMe Co-founder & Lead Udemy Instructor

Tolan went to the University of Arizona. He graduated summa cuma laude in the top 1% of his class with a Bachelor’s of Science Administration in Finance & Entrepreneurship and a Bachelor’s of Arts in French & East Asian Studies.

Tolan has worked at a top-tier economic consulting firm, specializing in Energy Deals and Financial Litigation.

Fun Facts about Tolan:

Tolan is the oldest of 3 children. He loves to travel.

Tolan has lived in Paris, New York, London, Beijing, Hangzhou, and Casablanca.

Odd fact? Tolan’s left leg is 5mm shorter than his right.

If Tolan had a year off, he’d learn a fourth language- maybe Portuguese, Spanish, or Hindi.

Ryan FitzPatrick
ProductivityMe Co-founder & Udemy Instructor

Ryan graduated summa cuma laude in the top 3% of his class with a Bachelor’s of Science Administration in Management Information Systems & Entrepreneurship.

Ryan has worked in non-profits as well as in Enterprise Management Software. He has worked as a consultant, as a tutor, even a bit in retail!

Fun Facts about Ryan:

Ryan is the younger of 2 children. Though he travels a lot for work, Ryan thinks of Tucson as home.

Ryan loves to write. Short-stories and essays are mostly his passion, but Ryan has even started screenplays, just for kicks!

If Ryan had a year off, he’d probably learn to code. That or start (another) company. Who knows, maybe he’d even do both!