Monday, 30. September 2019, Building 2E Room 108, Office 365 Excel Level 2

from 30. September 2019 - 9:00 till 16:00

Building 2E Room 108

Show map
Event description
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 


Show more
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

Office 365 Excel Level 2, Building 2E Room 108 event

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