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 Intermediate Excelin 1+ Hours (Downloadable Excel Files Included in Course)
4.4 (656 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.
15,511 students enrolled
Last updated 12/2015
  • 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
  • Basic understanding of worksheets, workbooks, selections, etc.

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
  • Regular Course Updates

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!


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
Expand All 14 Lectures Collapse All 14 Lectures 01:17:08
Getting Started in the Course
2 Lectures 05:24
Introduction to the Course

DOWNLOAD: Course Excel Files
Core Tools in Excel
11 Lectures 01:09:21

The Quick Access Toolbar

The Shortcut Menu & Mini-Toolbar

The Quick Analysis Tool (New to Excel 2013)

The Fill Handle

Half-Way Checkpoint

Flash Fill (New to Excel 2013)

Charts & Graphs

Recommended Charts (New to Excel 2013)

Sorting & Filters

Course Wrap-Up
1 Lecture 02:23
Final Thoughts & Next Steps
About the Instructor
4.3 Average rating
1,349 Reviews
29,434 Students
26 Courses
Excel Tips, Tricks, & Tutorials, One Lesson at a Time.


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!

Report Abuse