Complete Microsoft Excel 2016 - Beginner to Advanced Excel Mastery Course - 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