17. June 2019 - 9:00 till 16:00

Office 365 Excel Level 2, Building 2E Room 108, Monday, 17. June 2019

Excel Level 2 2016
Module 1: Customizing the Excel Environment

Configure Excel Options 
Customize the Ribbon and the Quick Access Toolbar 
Enable Excel Add-Ins

Module 2: Creating Advanced Formulas

Use Range Names in Formulas 
Use Specialized Functions 
Use Array Formulas

Module 3: Analyzing Data with Functions and Conditional Formatting 

Analyze Data by Using Text and Logical Functions 
Apply Advanced Conditional Formatting

Module 4: Organizing and Analyzing Datasets and Tables

Create and Modify Tables 
Sort Data 
Filter Data 
Use SUBTOTAL and Database Functions

Module 5: Visualizing Data with Basic Charts

Create Charts 
Modify and Format Charts

Module 6: Analyzing Data with PivotTables, Slicers, and PivotCharts

Create a PivotTable 
Analyze PivotTable Data  P
resent Data with PivotCharts 
Filter Data by Using Slicers

Monday, 17. June 2019, Building 2E Room 108, Office 365 Excel Level 2

Find more interesting events
Get event recommendations based on your Facebook taste. Get it now!Show me the suitable events for meNot now