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.3 (559 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.
12,752 students enrolled
Free
Start Learning Now
  • Lectures 14
  • Length 1.5 hours
  • Skill Level Intermediate 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 12/2015 English

Course 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
  • 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!

Cheers,

Tolan & Ryan
ProductivityMe Co-Founders

What are the requirements?

  • Basic understanding of worksheets, workbooks, selections, etc.

What am I going to get from this course?

  • 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

What 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

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: Getting Started in the Course
Introduction to the Course
02:14
DOWNLOAD: Course Excel Files
03:10
Section 2: Core Tools in Excel
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
Section 3: Course Wrap-Up
Final Thoughts & Next Steps
02:23

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

The ProductivityMe Company, 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!

Ready to start learning?
Start Learning Now