Complete Microsoft Excel 2016 - Beginner to Advanced Excel Mastery Course | Steve McDonald | Skillshare

Complete Microsoft Excel 2016 - Beginner to Advanced Excel Mastery Course

Steve McDonald, Author, Instructor, Digital Entrepreneur

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
101 Videos (13h 11m)
    • Excel 2016 Introduction - What You'll Learn

      6:21
    • How to Get the Most Out of This Course

      5:19
    • Take a Tour of the Excel Dashboard - How to Use the Tabs and Ribbon

      9:47
    • Using Excel Templates to Save Time and Effort

      8:56
    • Saving Your Document Where You Can Find It

      2:42
    • Entering Data and Navigating Cells

      2:52
    • Creating Simple Formulas to Do Powerful Calculations

      7:03
    • Working with Workbooks and Worksheets

      8:42
    • Introduction - Creating and Formatting Your Heading

      3:24
    • Formatting Subheadings and Columns and Alphabetizings Lists

      3:28
    • Entering and Formatting Numbers

      2:55
    • Create Formulas to Calculate Total Costs

      6:08
    • Final Formatting Grids and Spacing

      3:24
    • Intro to Formulas and Functions

      4:00
    • What is a Formula

      2:00
    • What is a Function

      8:32
    • The Anatomy of a Formula

      6:35
    • Quickly Select Cells to Use in Your Formula

      3:46
    • Absolute vs. Relative Cell References

      6:52
    • AVERAGE and AVERAGEA

      3:04
    • COUNT COUNTA and COUNTBLANK

      4:05
    • IF Function

      9:36
    • SUMIF and SUMIFS Functions

      6:22
    • COUNIF and COUNTIFS Functions

      4:26
    • VLOOKUP Function

      12:35
    • LEFT RIGHT MID Functions

      8:54
    • Concatenate

      4:35
    • LEN

      3:04
    • FIND and SEARCH

      3:52
    • MIN and MAX

      4:54
    • AND and OR

      6:10
    • ROUND

      13:23
    • Conditional Formatting

      8:46
    • Intro to Charts and Graphs

      7:14
    • Formatting Charts

      7:13
    • Create a Bar Chart

      5:54
    • Create a Pie Chart

      11:36
    • Create a Line Chart

      5:14
    • Introduction to Pivot Tables - Preparing Your Data

      11:07
    • How to Create a Pivot Table

      12:13
    • Put Your Pivot Table to Work

      13:37
    • Pivot Charts

      6:57
    • What's New for 2016

      5:24
    • 6 New Chart Types for 2016

      10:36
    • "Tell Me What You Want To Do" - The New Help Feature

      3:23
    • 1-Click Forecasting

      6:23
    • 3D Maps

      12:33
    • Saving as CSV, Text and PDF

      12:40
    • Backing Up Your Excel Files

      3:25
    • Using the AutoRecover Feature

      6:33
    • Import from Web, Copy/Paste, and Cleaning Up Data

      7:30
    • Import from CSV file and Excel Workbook

      7:23
    • Importing Data from Access Database

      5:26
    • Printing Your Excel Document

      4:38
    • Excel Keyboard Shortcuts

      8:47
    • ALT Key Shortcuts

      4:57
    • TEXT

      7:50
    • REPT - Repeat

      4:40
    • UPPER, LOWER, and PROPER

      2:58
    • TRIM - Remove Extra Spaces

      5:53
    • Combining LEFT, MID, FIND and TRIM

      9:43
    • HYPERLINK - Create a Table of Contents for Your Worksheets

      8:11
    • RAND and RANDBETWEEN - Random Numbers

      1:56
    • ROUND

      3:43
    • INT - Integer

      2:48
    • MOD - Remainder

      2:15
    • DATE and DATEVALUE

      6:48
    • TIME

      2:57
    • TODAY and NOW

      2:30
    • YEAR, MONTH, DAY, HOUR, MINUTE and SECOND

      3:31
    • WEEKDAY and WEEKNUM

      2:40
    • IFERROR

      4:07
    • LARGE and SMALL

      5:04
    • INDEX and MATCH

      9:37
    • Nested INDEX, MATCH, IF and IFERROR

      2:51
    • Nested IF, AND and OR Functions

      6:33
    • Record Your First Macro

      12:00
    • Saving Your Macro and Security

      4:38
    • Use a Macro to Create a Kitchen Remodel Costs Template

      4:08
    • How to Use Relative Cell References

      14:22
    • An Easy Cell-Formatting Macro

      5:55
    • Intro to the Complete Walk-Through of Excel Tools and Ribbons

      5:07
    • File Menu - The Complete Walk-Through

      16:10
    • Home Tab (part 1) - The Complete Walk-Through

      17:38
    • Home Tab (part 2) - The Complete Walk-Through

      15:17
    • Insert Tab (part 1) - The Complete Walk-Through

      13:48
    • Insert Tab (part 2) - The Complete Walk-Through

      18:36
    • Insert Tab (part 3) - The Complete Walk-Through

      19:02
    • Page Layout Tab (part 1) - The Complete Walk-Through

      19:01
    • Page Layout Tab (part 2) - The Complete Walk-Through

      4:58
    • Formulas Tab (part 1) - The Complete Walk-Through

      16:47
    • Formulas Tab (part 2) - The Complete Walk-Through

      10:09
    • Data Tab (part 1) - The Complete Walk-Through

      19:28
    • Data Tab (part 2) - The Complete Walk-Through

      7:33
    • Data Tab (part 3) - The Complete Walk-Through

      19:59
    • Review Tab - The Complete Walk-Through

      19:32
    • View Tab (part 1) - The Complete Walk-Through

      9:10
    • View Tab (part 2) - The Complete Walk-Through

      15:24
    • Developer Tab (part 1) - The Complete Walk-Through

      12:47
    • Developer Tab (part 2) - The Complete Walk-Through

      9:38
    • Conclusion

      5:36

About This Class

Welcome to my BIGGEST, most complete, Microsoft Excel course ever!

Excel is one of the most important skills in today's job market. Having a solid working knowledge of Excel can improve your job performance, help you qualify for raises and promotions, or even help you land that new job that you deserve.

If you need to know Excel, you're in the right place. 

This course walks you through Excel from the very basics of opening Excel all the way to advanced Excel skills used by the pros, like pivot tables and macros.

My goal with this course is to give you the skills you need to get that raise, promotion, or new job you deserve.

This course was created using Excel 2016, but it is good for versions 2013 and 2010 as well. It was created for use with a PC (personal computer). Mac (Macintosh) users can still benefit from this course, but the course doesn't cover Mac-specific keyboard shortcuts and interface.

We'll start at the very beginning, with opening and saving a worksheet in Excel. 

I'll show you what all the tools do and walk you through each Excel skill that you need to know.

I'll show you how to enter and format your data and how to create charts, tables and pivot tables so you can organize and analyze your data. I'll teach you amazing keyboard shortcuts to make your work faster and more productive. You'll learn how to record macros so you can do a whole series of actions with the just click of a button.

We'll keep going until you're a pro at Excel. When you finish this course, you'll know more than most people who use Excel at their job every day.

Here's some of what you'll learn.

  • Creating spreadsheets in Excel
  • Saving your work where you can find it
  • Working with multiple workbooks in Excel
  • Formatting and printing
  • Importing data from CSV files, Access and the web
  • Creating and using formulas and functions like: Vlookup, Index/Match, If statements and dozens of others
  • Creating charts including: Bar charts, Line charts, Column charts, Pie charts and more
  • Creating tables
  • Sorting and filtering your data
  • Creating pivot tables
  • Creating pivot charts from your pivot tables
  • Fun New features for Excel 2016
  • Keyboard shortcuts to make your work go faster
  • How to record basic macros to automate repetitive tasks
  • A whole lot more

The course comes with a certificate of completion, a full 30-day money back guarantee, and I'm always available to answer questions or share additional resources if you get stuck.

Thanks for checking out my Biggest Excel Course to date. 

I'll see you in there!

98

Students

--

Projects

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Steve McDonald

Author, Instructor, Digital Entrepreneur

I believe that learning can be easy if you are given the right tools and instruction. In every one of my courses I take my students step-by-step through the tools and knowledge they need to accomplish their goals.

Whether I am teaching How I Retired Early Publishing Kindle eBooks or How to Create Killer Content for the Web I always share an inside view of my knowledge about the subject. You get access to all of my secrets.

For over 10 years I have studied strategies to create pa...

See full profile

Report class