Microsoft Office Excel 2016 – Part 2

Mainstream Corporate Training
Training overview
Next start date: Inquire for more information. - Canada
Corporate / Group Training

Course description

Microsoft Office Excel 2016 – Part 2

This course is intended to help all users get up to speed on the different features of Excel and to become familiar with its more advanced selection of features. We will cover how to create and use advanced formulas, analyze data, organize worksheet data with tables, visualize data with charts, insert graphics, and enhance workbooks.

Want to find out more?

Do you have questions about this training and how COVID-19 might affect it?

At findcourses.com we are committed to helping everyone who wants to learn, to learn. So are the training suppliers we partner with.

Get in touch on this page to find out whether there are any changes to this training in light of COVID-19.

Training Content

Creating Advanced Formulas

In this lesson, students will learn how to use range names in formulas and functions, as well as how to use specialized functions.

Analyzing Data with Logical and Lookup Functions

Next, students will learn how to analyze data by using text, logical, lookup, date and financial functions.

Organizing and Analyzing Datasets and Tables

This lesson covers how to create and modify tables, sort and filter data, use subtotal features, and work with database functions.

Visualizing Data with Charts

Students will learn how to create charts, as well as how to modify and format existing charts. They will also learn how to create a trendline and advanced charts.

Analyzing Data with PivotTables, Slicers, and PivotCharts

Creating a PivotTable, filtering data using slicers and, analyzing data using PivotCharts will be covered in this lesson.

Inserting Graphics

Next, students will learn how to insert, modify, layer and group graphical objects. We will also take a look at how to incorporate SmartArt into workbooks.

Enhancing Workbooks

In this final lesson, students will learn how to customize workbooks, manage themes and, create and use templates. Protecting files and preparing a workbook for multiple audiences will also be covered.

About Mainstream Corporate Training

Mainstream Training

Mainstream Corporate Training-- Engaging Professional Development

We are committed to providing quality training that is essential to successful personal and professional growth; our programs help learners maintain a competitive advantage through insightful and effective training topics. Information continues to change and develop our lives -personally and professionally,...


Read more and show all training delivered by this supplier

Request info

Fill out your details to find out more about Microsoft Office Excel 2016 – Part 2.

  Contact the provider

  Get more information

  Register your interest

Contact info

Mainstream Corporate Training

1157 Ouellette Avenue
N9A4K1 Windsor

 Show phone number
mainstreamcorporatetraining.com

Request Information

Have a question about this course? Fill out this form and the provider will get in touch with you shortly

View again
Supplier Directory
Join our Supplier Directory to:
- Gain Traffic
- Get Noticed
- Showcase Your Services
- Free Listing Available