CourseInfo | SimpliTrain
Back
Information Technology

Excel 2016 - Part 2 (Half Day Sessions)

Instructor-Led 5 Agenda

Description

"

You’ve mastered the basics of Excel. In Excel 2016 - Part 2 training, you’ll build upon your data manipulation skills and unlock more capabilities within the platform.

Deepen your understanding of Excel by learning how to create advanced workbooks and worksheets. With Part 2 training from New Horizons under your belt, you’ll be ready to create custom formulas, apply built-in Excel functions and manipulate data to extract the insights you need.

"

Course Overview

You’ve mastered the basics of Excel. In Excel 2016 - Part 2 training, you’ll build upon your data manipulation skills and unlock more capabilities within the platform.

Deepen your understanding of Excel by learning how to create advanced workbooks and worksheets. With Part 2 training from New Horizons under your belt, you’ll be ready to create custom formulas, apply built-in Excel functions and manipulate data to extract the insights you need.

Course Objective

  • Perform calculations using functions and formulas
  • Sort, filter and query data
  • Create and format tables
  • Visualize data with charts
  • Create advanced formulas
  • Analyze data with PivotTables and PivotCharts

Who Should Attend

  • If you’re responsible for analyzing, managing or manipulating data sets, this course is for you. You can apply the learnings from Excel 2016 - Part 2 to virtually any industry, including accounting, office administration, business or financial analysis, marketing, sales and more.