Course Details
Course Outline
1 - Working with Functions
Define Cell Ranges and Reference Them in FormulasPerform Conditional Calculations Carry Out Logical and Specialized Functions Work with Date and Time FunctionsUnderstand and Execute Text Functions
2 - Working with Lists
Sort and Filter DataLearn the Capabilities of Database FunctionsQuery Data with Database FunctionsOutline and Subtotal Data
3 - Analyzing Data
Build and Modify TablesCreate Formatting RulesApply Conditional Formatting to Alter Groups of Cells
4 - Visualizing Data with Charts
Organize and Represent Data with ChartsModify and Format ChartsDiscover and Implement Advanced Chart Features
5 - Analyzing Data with PivotTables and PivotCharts
Create a PivotTableAnalyze PivotTable DataPresent Data with PivotChartsFilter Data Using Timelines and Slicers
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
Target Audience
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.
Prerequisites
Other Prerequisites
To get the most out of your Excel 2016 training, you should have completed Excel 2016: Part 1 or possess the equivalent knowledge and experience. Some essential Excel skills you should have include performing worksheet calculations, amending elements, formatting cells and managing workbook properties.