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)

Created byThe ProductivityMe Company

Last updated 10/2017

English

English [Auto],

What you'll 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

Course content

3 sections • 14 lectures • 1h 17m total length

Introduction to the Course2:14
Join this beginner-to-intermediate crash course to master 10 essential Excel features in just over an hour, from AutoSum and shortcuts to pivot tables and graphs.
DOWNLOAD: Course Excel Files3:10
Learn how to download, extract, and organize the course exercise files (before, after, final) for Excel practice, enable editing, and verify changes using autofill and fill handle.

Autosum7:11
Master autosum in excel to quickly total ranges, using the home tab, formula library, and keyboard shortcuts, then apply sums, averages, min, and max with the fill handle.
The Quick Access Toolbar6:57
Learn to customize the quick access toolbar in Excel, add and arrange commands, use access keys, and reset or relocate the toolbar to streamline your workflow.
The Shortcut Menu & Mini-Toolbar4:34
Explore the shortcut menu and mini toolbar in Excel to quickly format, paste values, and apply a quick analysis, sorting, filtering, and column insertion via right-click.
The Quick Analysis Tool (New to Excel 2013)5:42
Explore the quick analysis tool in Excel, revealing conditional formatting options like data bars, color scales, totals and averages, line charts, spark lines, and pivot tables to analyze data quickly.
The Fill Handle6:11
Master the fill handle and autofill in Excel to auto populate series, dates, and text by dragging, plus Flash Fill for splitting or merging text.
Half-Way Checkpoint0:23
Celebrate reaching halfway through the Excel crash course and share questions or ideas in the course discussion to boost productivity in Microsoft Excel.
Flash Fill (New to Excel 2013)7:15
Learn how to use Flash Fill in Excel 2013 to insert and deconstruct text, create full names and emails, and streamline text to columns and concatenation with pattern-based data assembly.
Charts & Graphs9:21
Explore charts and graphs in Microsoft Excel, learn how to insert and modify charts, and customize chart types, data labels, axes, and formats for clear visual data.
Recommended Charts (New to Excel 2013)4:41
Learn how to use Excel 2013's recommended charts to visualize data, choosing cluster column, line, or stacked area charts, with data labels and regional categories.
Sorting & Filters8:00
Master sorting and filtering in Microsoft Excel to organize data by department, last name, or salary, using multi-level sorts and targeted filters.
Tables9:06
Explore how to create and format tables in Excel, using four methods, table tools, styles, headers, filters, and converting between ranges and tables.

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:

Autosum
The Quick Access Toolbar
The Shortcut Menu & The Mini-Toolbar
The Quick Analysis Tool
The Fill Handle
Flash Fill
Charts & Graphs
Recommended Charts
Sorting & Filters
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

Boost Your Excel Skills: Crash Course w/ Downloadable Files

What you'll learn

Explore related topics

Course content

Getting Started in the Course2 lectures • 5min

Core Tools in Excel11 lectures • 1hr 9min

Course Wrap-Up1 lecture • 2min

Requirements

Description

Who this course is for: