Udemy

Boost Your Excel Skills: Crash Course w/ Downloadable Files

Microsoft Excel: Hone Core Skills in Microsoft Excel in 1+ Hours (Downloadable Excel Files Included in Course)
Free tutorial
Rating: 4.4 out of 5 (3,947 ratings)
71,889 students
1hr 17min of on-demand video
English
English [Auto]

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

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 this course is for:

  • 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

Instructor

Excel Tips, Tricks, & Tutorials, One Lesson at a Time.
  • 4.3 Instructor Rating
  • 5,020 Reviews
  • 118,418 Students
  • 7 Courses

ProductivityMe

SPECIAL NOTE: In response to Covid-19, we would like to offer any of our courses for free to those experiencing economic hardship. Please message us directly, and 3 times a month we have the ability to generate unlimited free enrollments for up to 72 hours. We hope that you are safe, and ask that you work to treat yourself and others with kindness and empathy. Take care. Tolan & Ryan


NORMAL BIOGRAPHY:


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 is software engineer, with a focus on education and contributing to open-source projects. He went to the University of Arizona. Tolan 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. He as also done coursework in Computer Science NYU and Stanford.

Before working in software engineering, Tolan lead complex data analysis 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 works as a PM. He 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!

Top companies trust Udemy

Get your team access to Udemy's top 30,000+ courses