Microsoft Excel 2016 Part 3

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

Course description

Microsoft Excel 2016 Part 3

Microsoft Office Excel 2016 is the newest version of Microsoft's popular spreadsheet program. This, the third level of our training program, explores the advanced features in in Excel 2016. Students will cover how to automate worksheet functionality, audit worksheets, analyze data, work with multiple workbooks, export Excel data and import/export XML data.

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

Automating Worksheet Functionality

This lesson gives students the skills to dig into automating worksheet functionality. Along the way they will learn how to update worksheet properties, create and edit a macro, apply conditional formatting, and add data validation criteria to a workbook.

Auditing Worksheets

This lesson digs deeper into worksheets and students will learn here how to: trace cells, troubleshoot invalid data and formula errors, watch and evaluate formulas, and create a data list online.

Analyzing and Presenting Data

Now that your students are very well versed in worksheets, it’s time to move into a deeper look at data with this lesson. Students will learn here how to: create Sparklines, create scenarios, perform a what-if analysis, perform statistical analysis with the Analysis ToolPak, and create interactive data with Power View.

Working with Multiple Workbooks

Often times, users of Excel will be juggling multiple workbooks at once and this lesson takes a look at that skill. This lesson will teach students how to: consolidate data, link cells in different workbooks, and merge workbooks.

Exporting Excel Data

Your students have their data and they want to export it, well they can learn about that here. This lesson covers how to: export Excel data, import an delimited text file, integrate Excel data with the web, and create a web query.

Importing and Exporting XML Data

This course wraps up here with this lesson showing your students how to import and export XML data.

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 Excel 2016 Part 3.

  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