Microsoft Excel 2016 Training

Training Courses

Microsoft Excel 2016 PowerPivot Training

PowerPivot is a powerful data exploration tool based on in-memory computing technologies that provides unmatched analytical performance to process billions of rows almost instantaneously. In this Microsoft Excel 2016 PowerPivot Training course, students will learn how to use PowerPivot to import and manipulate data, create PowerPivot reports, use DAX functions, create key performance indicators (KPI) and use slicers to enhance the visualization of data.More Details

Microsoft Excel 2016 VBA Training

In this Microsoft Excel 2016 VBA Training course, students will learn to use VBA in the Excel 2016 environment to create interactive worksheets and automate common worksheet tasks. More Details

Microsoft Excel 2016 Advanced Training

In this Microsoft Excel 2016 Advanced training course, students will learn the ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions. 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.More Details

Microsoft Excel 2016 Intermediate Training

In this Microsoft Excel 2016 Intermediate Training class, students will learn how to build on their Excel skills by using named ranges in Excel, inserting Excel Functions such as IF and SUMIF, using comparison operators such as AND, OR and NOT and using Date Functions such as DATE and NOW. In addition, students will see how to manipulate text using Text Functions like UPPER, LOWER and CONCATENATE.More Details

Microsoft Excel 2016 Introduction Training

In this Microsoft Excel 2016 Introduction Training course, students will learn how to create worksheets in Microsoft Excel 2016, how to use formulas and perform calculations, how to format cells and worksheets, how to setup worksheets for printing and how to manage various user options to get the most out of Microsoft Excel.More Details