Excel 2016 – Part 2 (Half Day Sessions)
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 Objectives
Once you complete Excel 2016 – Part 2, you’ll be able to apply custom formulas and present data to make informed business decisions.
This course empowers you to:
-
- 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
Agenda
- Define Cell Ranges and Reference Them in Formulas
- Perform Conditional Calculations
- Carry Out Logical and Specialized Functions
- Work with Date and Time Functions
- Understand and Execute Text Functions
- Sort and Filter Data
- Learn the Capabilities of Database Functions
- Query Data with Database Functions
- Outline and Subtotal Data
- Build and Modify Tables
- Create Formatting Rules
- Apply Conditional Formatting to Alter Groups of Cells
- Organize and Represent Data with Charts
- Modify and Format Charts
- Discover and Implement Advanced Chart Features
- Create a PivotTable
- Analyze PivotTable Data
- Present Data with PivotCharts
- Filter Data Using Timelines and Slicers
FREE
Interested in course?
Course Type: Instructor Led