Microsoft® Excel™ 2016 Advanced

Pre-Requisites: Windows 10, MS Excel 2016 Intermediate

5-stars

Key Features

  • Online live classroom available
  • Quality learning materials
  • Small Class Sizes
  • State of the Art Facility
  • Free Retakes
  • Instructor Led Classroom training
  • Certified Industry Experienced Teachers
  • 100% Job Placement assistance

This course will provide an introduction to spreadsheets and the practical uses and versatility of Microsoft® Office Excel® 2016. Students will learn time saving features and tips for using Excel effectively.

Microsoft Excel’s robust built in functionality will allow your organization to gain a level of insight into its raw data that would have been nearly impossible just a couple of decades ago. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction.

Of course, knowing exactly how to ask Excel the questions that you need answered, which questions you can even ask, and how to interpret the answers Excel gives is necessary before you can even begin to embark on the journey ahead. This course aims to provide you with the foundational Excel knowledge and skills necessary to begin that journey and takes you through the advanced levels of using this powerful tool to the highest levels of accounting expertise if desired.

Microsoft Excel 2016 – Part 3

Working with Multiple Worksheets and Workbooks

  • Use Links and External References
  • Use 3-D References
  • Consolidate Data

Using Lookup Functions and Formula Auditing

  • Use Lookup Functions
  • Trace Cells
  • Watch and Evaluate Formulas

Sharing and Protecting Workbooks

  • Collaborate on a Workbook
  • Protect Worksheets and Workbooks

Automating Workbook Functionality

  • Apply Data Validation
  • Search for Invalid Data and Formulas with Errors
  • Work with Macros

Creating Sparklines and Mapping Data

  • Create Sparklines
  • Map Data

Forecasting Data

  • Determine Potential Outcomes Using Data Tables
  • Determine Potential Outcomes Using Scenarios
  • Use the Goal Seek Feature
  • Forecasting Data Trends

Course Number : MO16-3-0103

Duration : 8 hours

1 Step 1

Request Information!

Who you are?

By submitting this form, you are giving your express written consent for Global Information Technology to contact you regarding our programs and services using email, telephone or text.  This consent is not required to purchase goods/services, and you may always call us directly at 1-866-464-4846.

reCaptcha v3
keyboard_arrow_leftPrevious
Nextkeyboard_arrow_right
FormCraft - WordPress form builder