NewEra Technology Facebook
Excel 2010 - Part 2 - Virtual Live - Course Information
PRINT
SEND TO A FRIEND
Name: Excel 2010 - Part 2 - Virtual Live
Category: Microsoft Office Suite
Length (Days): 1
Course Price (CAD): 300
Description:
TARGET AUDIENCE
This course is designed for students who already have foundational knowledge and skills in Excel 2010 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.
Prerequisites:
Excel 2010 - Part 1
Outline:
1 - CUSTOMIZING THE EXCEL ENVIRONMENT

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

2 - CREATING ADVANCED FORMULAS

Use Range Names in Formulas
Use Specialized Functions
Use Array Formulas

3 - ANALYZING DATA WITH FUNCTIONS AND CONDITIONAL FORMATTING

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

4 - ORGANIZING AND ANALYZING DATASETS AND TABLES

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

5 - VISUALIZING DATA WITH BASIC CHARTS

Create Charts
Modify and Format Charts

6 - ANALYZING DATA WITH PIVOTTABLES, SLICERS, AND PIVOTCHARTS

Create a PivotTable
Analyze PivotTable Data
Present Data with PivotCharts
Filter Data by Using Slicers
Guaranteed to run courses