Microsoft Excel 2016

Microsoft Excel 2016

SON-BD-MSXLS2016-EN

USD 53.00
excl. VAT
Please note: The price will be deducted in your cart when a course seat is purchased.

We bundled all Excel 2016 courses together for a special price.

This Bundle includes

  • Microsoft Excel 2016: Part 1 - Beginner,
  • Microsoft Excel 2016: Part 2 - Advanced,
  • Microsoft Excel 2016: Part 3 - Expert,
  • Microsoft Excel 2016: Part 4 - Data Analysis with PivotTables,
  • Microsoft Excel 2016: Part 5 - Data Analysis with Power Pivot

Do you want to finally understand the concept of Excel 2016 and learn basic skills? In the basic course you will learn to understand, in which scenarios the use of Excel 2016 makes sense. Create error-free tables and master the first calculations. You will also learn how data, values ​​and formulas are stored in cells and how you can do more calculations from here.

Excel 2016 is one of the most used office programs. However, users without training support usually only use 10% of the functionality of Excel 2016. In the advanced course, you will learn how to organize, analyze, and visualize your data and calculations. We'll also show you how to apply formulas to solve tasks.

Would you like to become an Excel specialist and use the enormous functionality of Excel 2016 to your advantage? In the expert course, you will get to know especially helpful features, such as collaborative editing of workbooks and management of more complex Excel documents, through the implementation of tools such as formula tracking and reference functions.

Maybe you already discovered the power and versatility of PivotTables during previous lessons. The courses are an in-depth training to uncover the full potential of PivotTables and PivotCharts.

USD 53.00

Microsoft Excel 2016: Part 1 - Beginner

Module 1

Microsoft Excel 2016: Part 1 - Beginner

Microsoft Excel 2016: Part 1 - Beginner

SO-MSXLS2016-LVL1-EN
Free of Charge
eLearning | Online
English
365 days

Excel 2016 is one of the most used office programs. However, users without training support usually only use 10% of the functionality of Excel 2016. 

The training starts with the absolute basics of creating your very first worksheet and progresses through learning numerous capabilities of this very powerful program. Practice files will help you follow the step-by-step training and you can check what you've learned with our quizzes. This course will help you to prepare for the official Microsoft Office Specialist exam. 

See more See less
Microsoft Excel 2016: Part 2 - Advanced

Module 2

Microsoft Excel 2016: Part 2 - Advanced

Microsoft Excel 2016: Part 2 - Advanced

SO-MSXLS2016-LVL2-EN
Free of Charge
eLearning | Online
English
365 days

In this course you'll learn create advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level. 

To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data. In other words, when you have questions about your data, you need to know how to get Excel to provide the answers for you.  

This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 Exam and the Excel 2016 Expert Exam. 

See more See less
Microsoft Excel 2016: Part 3 - Expert

Module 3

Microsoft Excel 2016: Part 3 - Expert

Microsoft Excel 2016: Part 3 - Expert

SO-MSXLS2016-LVL3-EN
Free of Charge
eLearning | Online
English
365 days

The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organization generates. 

This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 Exam and the Excel 2016 Expert Exam. 

See more See less
Microsoft Excel 2016: Part 4 - Data Analysis with PivotTables

Module 4

Microsoft Excel 2016: Part 4 - Data Analysis with PivotTables

Microsoft Excel 2016: Part 4 - Data Analysis with PivotTables

SO-MSXLS2016-LVL4-EN
Free of Charge
eLearning | Online
English
365 days

The need to analyze data and gain actionable insight is greater than ever. You already have experience working with Excel and creating basic PivotTables to summarize data. But Excel is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved!

See more See less
Microsoft Excel 2016: Part 5 - Data Analysis with Power Pivot

Module 5

Microsoft Excel 2016: Part 5 - Data Analysis with Power Pivot

Microsoft Excel 2016: Part 5 - Data Analysis with Power Pivot

SO-MSXLS2016-LVL5-EN
Free of Charge
eLearning | Online
English
365 days

Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data. 

See more See less

* Required Fields