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.
| Course Title | Course Dates | Course Location | Fee | Register |
|---|---|---|---|---|
|
Microsoft Excel Training Class
Boston |
Fri, Jul 13 2018 |
Boston American Graphics Institute 120 Presidential Way Boston - Woburn, MA 01801 |
$395.00 | |
|
Microsoft Excel Training Class
NYC |
Fri, Jul 20 2018 |
New York American Graphics Institute 21 W 46th St. New York, NY 10036 |
$495.00 | |
|
Microsoft Excel Training Class
Boston |
Fri, Aug 17 2018 |
Boston American Graphics Institute 120 Presidential Way Boston - Woburn, MA 01801 |
$395.00 | |
|
Microsoft Excel Training Class
Boston |
Fri, Sep 14 2018 |
Boston American Graphics Institute 120 Presidential Way Boston - Woburn, MA 01801 |
$395.00 | |
|
Microsoft Excel Training Class
Boston |
Fri, Oct 19 2018 |
Boston American Graphics Institute 120 Presidential Way Boston - Woburn, MA 01801 |
$395.00 | |
|
Microsoft Excel Training Class
Boston |
Fri, Nov 30 2018 |
Boston American Graphics Institute 120 Presidential Way Boston - Woburn, MA 01801 |
$395.00 |
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 UX professionals who have extensive professional and training experience, and also work in our UX consulting practice
Average 5 out of 5 from all reviewers!
