New Horizons Lexington KY Computer Training
New Horizons Computer Learning Center presents
 

Excel - Level 2 On-Site Training

This on-site training class is also available as Public Schedule Seminar.

In this course, students will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Course Description/Agenda


Duration
Classroom Learning - 1 Day(s)
Mentored Learning - Flexible
Online LIVE - 1 Sessions

Overview
The student will learn to use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.

Who Should Attend
This course is meant for those desiring to gain advanced skill sets necessary for calculating data using functions and formulas, sorting and filtering data, using PivotTables and PivotCharts for analyzing data, and customizing workbooks.

Prerequisite(s) or equivalent knowledge
Excel 2010 - Level 1

Suggested Next Steps
Excel 2010 - Level 3

Outline
Lesson 1: Calculating Data with Advanced Formulas
Apply Cell and Range Names
Calculate Data Across Worksheets
Use Specialized Functions
Analyze Data with 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
Create 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 Graphic Objects
Lesson 6: Customizing and Enhancing the Excel Environment
Customize the Excel Environment
Customize Workbooks
Manage Themes
Create and Use Templates

 

More Seminar Information

New Horizons Computer Learning Center
New Horizons Lexington KY Computer Training

Delivery Method

 On-Site Training On-Site Training

Also Available As

 Seminar Seminar

  		Add to favorites Add to favorites
Email Email this page
 

On-Site Training
Information Request Form

Please complete the form for more information and/or a quote for this on-site class.

Name:

Email

Phone:

City and State

Company:

Number of students:
(at least 10 for consideration)

When do you want to hold the
seminar?

How long would you like for the
seminar?

Additional comments to trainer:

We value your privacy!