Business Basics

The Complete Mastering Excel 2016: Advanced Learning Path

With expert instruction.

Get Started

25 skill-based courses

In 1 Skill Sets

Learning Path Duration

02H 53M

What Will I Learn?

Learning Path

About Mastering Excel 2016: Advanced

Mastering Excel 2016 Skills

Advanced - Using Links and External References

Advanced - Using Links and External References

Advanced - Using Links and External References

Advanced - Using Links and External References

10m 15s

If you've mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders - from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.

Advanced - Using 3D References

Advanced - Using 3D References

Advanced - Using 3D References

Advanced - Using 3D References

8m 57s

If you've mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders - from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.

Advanced - Consolidating Data

Advanced - Consolidating Data

Advanced - Consolidating Data

Advanced - Consolidating Data

6m 15s

If you've mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders - from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.

Advanced - Using Lookup Functions (Part 1)

Advanced - Using Lookup Functions (Part 1)

Advanced - Using Lookup Functions (Part 1)

Advanced - Using Lookup Functions (Part 1)

12m 0s

If you've mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders - from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.

Advanced - Using Lookup Functions (Part 2)

Advanced - Using Lookup Functions (Part 2)

Advanced - Using Lookup Functions (Part 2)

Advanced - Using Lookup Functions (Part 2)

5m 59s

If you've mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders - from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.

Advanced - Tracing Precedent and Dependent Cells

Advanced - Tracing Precedent and Dependent Cells

Advanced - Tracing Precedent and Dependent Cells

Advanced - Tracing Precedent and Dependent Cells

6m 23s

If you've mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders - from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.

Advanced - Watching and Evaluating Formaulas

Advanced - Watching and Evaluating Formaulas

Advanced - Watching and Evaluating Formaulas

Advanced - Watching and Evaluating Formaulas

5m 29s

If you've mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders - from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.

Advanced - Comments and Track Changes

Advanced - Comments and Track Changes

Advanced - Comments and Track Changes

Advanced - Comments and Track Changes

8m 22s

If you've mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders - from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.

Advanced - Comparing and Merging Workbooks

Advanced - Comparing and Merging Workbooks

Advanced - Comparing and Merging Workbooks

Advanced - Comparing and Merging Workbooks

4m 47s

If you've mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders - from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.

Advanced - Accessibility Checker

Advanced - Accessibility Checker

Advanced - Accessibility Checker

Advanced - Accessibility Checker

4m 19s

If you've mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders - from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.

Advanced - Protecting Worksheets and Workbooks

Advanced - Protecting Worksheets and Workbooks

Advanced - Protecting Worksheets and Workbooks

Advanced - Protecting Worksheets and Workbooks

9m 51s

If you've mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders - from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.

Advanced - Applying Data Validation

Advanced - Applying Data Validation

Advanced - Applying Data Validation

Advanced - Applying Data Validation

9m 33s

If you've mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders - from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.

Advanced - Search for Invalid Data

Advanced - Search for Invalid Data

Advanced - Search for Invalid Data

Advanced - Search for Invalid Data

6m 41s

If you've mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders - from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.

Advanced - Working with Macros (Part 1)

Advanced - Working with Macros (Part 1)

Advanced - Working with Macros (Part 1)

Advanced - Working with Macros (Part 1)

11m 27s

If you've mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders - from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.

Advanced - Working with Macros (Part 2)

Advanced - Working with Macros (Part 2)

Advanced - Working with Macros (Part 2)

Advanced - Working with Macros (Part 2)

7m 20s

If you've mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders - from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.

Advanced - Creating Sparklines

Advanced - Creating Sparklines

Advanced - Creating Sparklines

Advanced - Creating Sparklines

4m 41s

If you've mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders - from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.

Advanced - 3D Maps

Advanced - 3D Maps

Advanced - 3D Maps

Advanced - 3D Maps

6m 31s

If you've mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders - from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.

Advanced - Data Tables

Advanced - Data Tables

Advanced - Data Tables

Advanced - Data Tables

6m 32s

If you've mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders - from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.

Advanced - Using Scenarios

Advanced - Using Scenarios

Advanced - Using Scenarios

Advanced - Using Scenarios

4m 54s

If you've mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders - from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.

Advanced - Goal Seek

Advanced - Goal Seek

Advanced - Goal Seek

Advanced - Goal Seek

2m 42s

If you've mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders - from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.

Advanced - Forecasting Data Trends

Advanced - Forecasting Data Trends

Advanced - Forecasting Data Trends

Advanced - Forecasting Data Trends

3m 0s

If you've mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders - from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.

Advanced - Changing your Display (Appendix 1)

Advanced - Changing your Display (Appendix 1)

Advanced - Changing your Display (Appendix 1)

Advanced - Changing your Display (Appendix 1)

4m 16s

If you've mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders - from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.

Advanced - Importing Delimited Text Files (Appendix 2)

Advanced - Importing Delimited Text Files (Appendix 2)

Advanced - Importing Delimited Text Files (Appendix 2)

Advanced - Importing Delimited Text Files (Appendix 2)

3m 42s

If you've mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders - from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.

Advanced - Data Forms and Form Controls (Appendix 3)

Advanced - Data Forms and Form Controls (Appendix 3)

Advanced - Data Forms and Form Controls (Appendix 3)

Advanced - Data Forms and Form Controls (Appendix 3)

14m 21s

If you've mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders - from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.

Advanced - Calculated Fields and Cube Functions (Appendix 4)

Advanced - Calculated Fields and Cube Functions (Appendix 4)

Advanced - Calculated Fields and Cube Functions (Appendix 4)

Advanced - Calculated Fields and Cube Functions (Appendix 4)

4m 55s

If you've mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders - from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions.

Desktop and Mobile
  • All Access

    Access anywhere, anytime

    Learn at work, at home or on the go. All of our courses our online and play well with desktops and mobile devices.

  • Certificate

    Certificate of Completion

    Upon completion of this Learning Path, you will be awarded a Certificate of Completion showing that you have gained the skills presented.

  • Support

    Support

    Have a question? We're here to help. We have detailed FAQs and resources as well as a support team ready to assist you.

  • Customization

    Customization

    We offer over 90 professionally hand-crafted learning paths to get you started, but we realized that not everyone wants to learn the same things. That's why we give you the flexibility to create your own, custom learning paths just for you and your team.

Mountains

Are you ready to become a Top Performer?

Our video lessons are built by industry experts, proven by learners who are no longer ordinary!

Free Trial