CourseInfo | SimpliTrain

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.

No results found.

Working with Functions Lesson Id 1

Working with Functions

Working with Lists Lesson Id 2

Working with Lists

Analyzing Data Lesson Id 3

Analyzing Data

Visualizing Data with Charts Lesson Id 4

Visualizing Data with Charts

Analyzing Data with PivotTables and PivotCharts Lesson Id 5

Analyzing Data with PivotTables and PivotCharts

Lesson Id	Title	Description
1	Working with Functions	Define Cell Ranges and Reference Them in Formulas<br />Perform Conditional Calculations <br />Carry Out Logical and Specialized Functions <br />Work with Date and Time Functions<br />Understand and Execute Text Functions <br />
2	Working with Lists	Sort and Filter Data<br />Learn the Capabilities of Database Functions<br />Query Data with Database Functions<br />Outline and Subtotal Data<br />
3	Analyzing Data	Build and Modify Tables<br />Create Formatting Rules<br />Apply Conditional Formatting to Alter Groups of Cells<br />
4	Visualizing Data with Charts	Organize and Represent Data with Charts<br />Modify and Format Charts<br />Discover and Implement Advanced Chart Features<br />
5	Analyzing Data with PivotTables and PivotCharts	Create a PivotTable<br />Analyze PivotTable Data<br />Present Data with PivotCharts<br />Filter Data Using Timelines and Slicers<br />