# 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
110 Lessons (14h 7m)
• 1. Excel 2016 Introduction - What You'll Learn

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

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

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

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

2:42
• 6. Entering Data and Navigating Cells

2:52
• 7. Creating Simple Formulas to Do Powerful Calculations

7:03
• 8. Working with Workbooks and Worksheets

8:42
• 9. Introduction - Creating and Formatting Your Heading

3:24
• 10. Formatting Subheadings and Columns and Alphabetizings Lists

3:28
• 11. Entering and Formatting Numbers

2:55
• 12. Create Formulas to Calculate Total Costs

6:08
• 13. Final Formatting Grids and Spacing

3:24
• 14. Intro to Formulas and Functions

4:00
• 15. What is a Formula

2:00
• 16. What is a Function

8:32
• 17. The Anatomy of a Formula

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

3:46
• 19. Absolute vs. Relative Cell References

6:52
• 20. AVERAGE and AVERAGEA

3:04
• 21. COUNT COUNTA and COUNTBLANK

4:05
• 22. IF Function

9:36
• 23. SUMIF and SUMIFS Functions

6:22
• 24. COUNIF and COUNTIFS Functions

4:26
• 25. VLOOKUP Function

12:35
• 26. LEFT RIGHT MID Functions

8:54
• 27. Concatenate

4:35
• 28. LEN

3:04
• 29. FIND and SEARCH

3:52
• 30. MIN and MAX

4:54
• 31. AND and OR

6:10
• 32. ROUND

13:23
• 33. Conditional Formatting

8:46
• 34. Intro to Charts and Graphs

7:14
• 35. Formatting Charts

7:13
• 36. Create a Bar Chart

5:54
• 37. Create a Pie Chart

11:36
• 38. Create a Line Chart

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

11:07
• 40. How to Create a Pivot Table

12:13
• 41. Put Your Pivot Table to Work

13:37
• 42. Pivot Charts

6:57
• 43. What's New for 2016

5:24
• 44. 6 New Chart Types for 2016

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

3:23
• 46. 1-Click Forecasting

6:23
• 47. 3D Maps

12:33
• 48. Saving as CSV, Text and PDF

12:40
• 49. Backing Up Your Excel Files

3:25
• 50. Using the AutoRecover Feature

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

7:30
• 52. Import from CSV file and Excel Workbook

7:23
• 53. Importing Data from Access Database

5:26
• 54. Printing Your Excel Document

4:38
• 55. Excel Keyboard Shortcuts

8:47
• 56. ALT Key Shortcuts

4:57
• 57. TEXT

7:50
• 58. REPT - Repeat

4:40
• 59. UPPER, LOWER, and PROPER

2:58
• 60. TRIM - Remove Extra Spaces

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

9:43

8:11
• 63. RAND and RANDBETWEEN - Random Numbers

1:56
• 64. ROUND

3:43
• 65. INT - Integer

2:48
• 66. MOD - Remainder

2:15
• 67. DATE and DATEVALUE

6:48
• 68. TIME

2:57
• 69. TODAY and NOW

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

3:31
• 71. WEEKDAY and WEEKNUM

2:40
• 72. IFERROR

4:07
• 73. LARGE and SMALL

5:04
• 74. INDEX and MATCH

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

2:51
• 76. Nested IF, AND and OR Functions

6:33
• 77. Record Your First Macro

12:00
• 78. Saving Your Macro and Security

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

4:08
• 80. How to Use Relative Cell References

14:22
• 81. An Easy Cell-Formatting Macro

5:55
• 82. Find and Delete Empty Cells from Located Outside Your Data

5:46
• 83. Flash Fill and Auto Fill for Fast Data Entry

5:25
• 84. Freezing the Top Row of Your Spreadsheet

3:11
• 85. Hide and Unhide Rows, Columns and Entire Sheets

3:00
• 86. Insert Multiple Rows and Columns Easily

4:52
• 87. Mail Merge with Microsoft Excel and Word

9:19
• 88. Paste Special

16:24
• 89. Sort and Filter

4:44
• 90. Quick Calculatilons with the Status Bar

3:38
• 91. Intro to the Complete Walk-Through of Excel Tools and Ribbons

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

9:38
• 110. Conclusion

5:36
23 students are watching 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!