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

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

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

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

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
13 students are watching this class