Microsoft Excel Training Class

In this Microsoft Excel training class you will be shown how to utilize this powerful spreadsheet application. Get yourself started and see immediate results with this one-day hands-on course. You will be able to plan and create an organized spreadsheet, use absolute and relative cell references, understand the importance of labels and values, create pivot tables, and export your data into a range of file formats. Our Instructors can show you how to efficiently produce your own spreadsheet for data management and analysis. Learn how to use the powerful functionality of Microsoft Excel by contacting AGI about this Microsoft Excel training class.

Microsoft Excel Training Class Course Dates

All classes in Boston, New York City, and Philadelphia start at 9:30 a.m. and end at 4:30 p.m. and are led by a live instructor in the same classroom with you. All online classes are led by a live instructor and run from 10:00 a.m. to 5:00 p.m. Eastern Time.

Microsoft Excel Training Class Topics Covered

Topics generally covered in the Microsoft Excel course include the following. Course content may be adapted based upon the needs of the specific class.

Getting Started with Excel

Getting to know the workspace

Getting to know the cell pointer

Using the Ribbon

Exploring the Status bar

Using the Quick Access toolbar

Using the Formula bar

Moving around the worksheet

Exploring what’s new in Excel 2013

Creating an Excel Worksheet

Entering data in a cell

Working with cell ranges

Saving and opening workbooks

Editing data, and using undo and redo

Working with rows and columns

Creating additional worksheets

Printing worksheets and workbooks

Formatting a Worksheet in Excel

Understanding cell formats

Changing number formats

Changing the font and font size

Modifying row heights and column widths

Cell alignment and cell styles

Borders and shading

Copying cell formats

Using conditional formatting

Using page themes

Using Formulas in Excel

Entering simple formulas

Referencing cells from other worksheets or workbooks

Using functions and the function Library

Using the AutoSum tool

Using common functions

Working with ranges

Copying formulas

Formula auditing

Working with Charts in Excel

Understanding chart types

Creating moving, and resizing, a chart

Understanding chart elements

Using chart recommendations

Customizing the chart

Printing a chart

Using Sparklines

Working with Data in Excel

Working with lists

Creating a list

Sorting records

Filtering records

Searching records

Deleting records

Removing duplicates

Extracting records

Subtotaling data

Grouping records

Using data validation

Converting text to columns

Using Flash Fill

Working with Excel Templates

Working with templates

Saving a workbook as a template

Opening a custom template

Protecting workbooks and worksheets

Unlocking cells in a protected worksheet

Hide and protect formulas

Searching for templates

Advanced Data Analysis in Excel

Introduction to PivotTables

Creating a PivotTable

Rearranging a PivotTable

Removing fields from a PivotTable

Formatting a PivotTable

Editing and updating a PivotTable

Changing the calculation

Hiding and showing data in a PivotTable

Adding subtotals to a PivotTable

Using recommended PivotTables

Working with PivotCharts

Working with tables

What-If analysis

Course prerequisites

We recommend that you have Microsoft Excel available to use after your return from this Excel class. A computer with Excel is provided for use during the course.

Course materials

You will receive a comprehensive Excel course manual for this class.

AVAILABLE DELIVERY METHODS FOR THIS CLASS

CLASSROOM

LIVE ONLINE

PRIVATE

MY LOCATION

ON-DEMAND

AGI's team of experienced instructors are led by Jennifer Smith the design and usability expert and best-selling author of more than 20 books including Creative Cloud for Dummies, Creative Suite for Dummies, and Photoshop Digital Classroom. Classes are led by experienced professionals who have extensive professional and training experience, and also work in our consulting practice areas and as practicing professionals. For Federal agencies, American Graphics Institute classes are offered under GSA contract 47QTCA19D003Y.