-

PC End User

Excel 2016 Level 2 (2 Days) - Virtual or In-person

01-04-D724

Today’s business requires data to be compiled, analyzed and presented visually to make informed decisions. This course builds on the basic concepts of Excel 2016 level 1, providing more advanced tools for analysis and presentation of complex, realistic data. Practice the advanced skills necessary for working with complex workbooks, building complex function, using data analysis tools, making an impact with charts and collaborating with others.

This course covers Excel 2016; however, the similarities with 2013 version are such that all users should be successful learning this latest product.

Performance Objectives: Upon successful completion of this course you should be able to:

  • Use named ranges in formulas
  • Learn logical, date, and text functions
  • Analyzing data with table functions
  • Creating and modifying charts
  • Use PivotTables to summarize and rearrange large amounts of data in a list, and how to use PivotCharts to present such data
  • Use custom conditional formatting
  • How to use Quick Analysis features to conveniently analyze data

Prerequisite: Completion of the Microsoft Excel 2016 Level 1 course or equivalent knowledge and experience is strongly recommended.

Books: Microsoft® Office Excel® 2016: Part 2 (Logical Operations)

Virtually Led Trainings: If you’re registering for a virtual training, the classroom link and materials will be sent to you separately within 1-2 business days before the scheduled class date.

Scheduled Class Location and Dates
City / Facility Date and Time Course Cost Cancel Date Instructor
1 Virtual

Virtual Training
Online
,
  • Jan 20 2021 8:00am-4:30pm
  • Jan 21 2021 8:00am-4:30pm
$255.00 Sun, 01/03/2021 - 16:00 Debbie Lonborg
2 Virtual

Virtual Training
Online
,
  • May 19 2021 8:00am-4:30pm
  • May 20 2021 8:00am-4:30pm
$255.00 Sun, 05/02/2021 - 17:00 Debbie Lonborg