Excel 2010: Level 2
CLASS DATE(s):
Request a Class

COURSE LENGTH: 1 Day

COURSE COST: $295

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print

COURSE OVERVIEW

This course builds upon the foundational knowledge presented in the Microsoft® Office Excel® 2010 Level 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your organizational intelligence. The ability to analyze massive amounts of data, extract actionable intelligence from it, and present that information to decision makers is the cornerstone of driving a successful organization that is able to compete at a high level.

AUDIENCE AND PREREQUISITES

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.

To ensure success, students should have completed Microsoft® Office Excel® 2010 Level 1 or have the equivalent knowledge and experience.

PREREQUISITE COURSESFOLLOW UP COURSES  

*Course cost listed does not include the cost of courseware or lunch. Course is subject to minimum enrollment. Please contact us at learn@vtec.org or 207-775-0244 for additional pricing information, or if you have any questions.

COURSE TOPICS:


Lesson 1: Calculating Data with Advanced Formulas
Apply Cell and Range Names
Calculate Data Across Worksheets
Use Specialized Functions
Analyze Data wit Logical and Lookup Functions

Lesson 2: Organizing Worksheet and Table Data
Create and Modify Tables
Format Tables
Sort or Filter Data
Use Functions to Calculate Data

Lesson 3: Presenting Data Using Charts
Create a Chart
Modify Charts
Format Charts

Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts
Creating a PivotTable Report
Filter Data Using Slicers
Analyze Data Using PivotCharts

Lesson 5: Inserting Graphic Objects
Insert and Modify Pictures and ClipArt
Draw and Modify Shapes
Illustrate Workflow Using SmartArt Graphics
Layer and Group Graphing Objects

Lesson 6: Customizing and Enhancing the Excel Environment
Customize the Excel Environment
Customize Workbooks
Manage Themes
Create and Use Templates