Add to Wish List this Microsoft Excel Training Class see dates for this Microsoft Excel Training Class contact us about this Microsoft Excel Training Class

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

American Graphics Institute
Boston
American Graphics Institute
AGI Training Boston
120 Presidential Way
Boston - Woburn, MA 01801
2017-12-08 13:19:29 $395.00
Microsoft Excel Training Class

NYC

American Graphics Institute
New York
American Graphics Institute
AGI Training New York
21 W 46th St.
New York, NY 10036
2017-12-13 12:24:48 $395.00
Microsoft Excel Training Class

Boston

American Graphics Institute
Boston
American Graphics Institute
AGI Training Boston
120 Presidential Way
Boston - Woburn, MA 01801
2017-12-08 13:19:29 $395.00
Microsoft Excel Training Class

Boston

American Graphics Institute
Boston
American Graphics Institute
AGI Training Boston
120 Presidential Way
Boston - Woburn, MA 01801
2017-12-08 13:19:29 $395.00
Microsoft Excel Training Class

Boston

American Graphics Institute
Boston
American Graphics Institute
AGI Training Boston
120 Presidential Way
Boston - Woburn, MA 01801
2017-12-08 13:19:29 $395.00
Microsoft Excel Training Class

Boston

American Graphics Institute
Boston
American Graphics Institute
AGI Training Boston
120 Presidential Way
Boston - Woburn, MA 01801
2017-12-08 13:19:29 $395.00
Microsoft Excel Training Class

Boston

American Graphics Institute
Boston
American Graphics Institute
AGI Training Boston
120 Presidential Way
Boston - Woburn, MA 01801
2017-12-08 13:19:29 $395.00
Microsoft Excel Training Class

Boston

American Graphics Institute
Boston
American Graphics Institute
AGI Training Boston
120 Presidential Way
Boston - Woburn, MA 01801
2017-12-08 13:19:29 $395.00
Microsoft Excel Training Class

Boston

American Graphics Institute
Boston
American Graphics Institute
AGI Training Boston
120 Presidential Way
Boston - Woburn, MA 01801
2017-12-08 13:19:29 $395.00
Microsoft Excel Training Class

Boston

American Graphics Institute
Boston
American Graphics Institute
AGI Training Boston
120 Presidential Way
Boston - Woburn, MA 01801
2017-12-08 13:19:29 $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

Microsoft Office Classes Classroom Training IconLive Online Microsoft Office Classes Training IconPrivate Microsoft Office Classes Training IconMicrosoft Office Classes Training at My Location IconOn-Demand Microsoft Office Classes Training Icon
CLASSROOMLIVE ONLINEPRIVATEMY LOCATIONON-DEMAND

 

AGI's team of experienced instructors are led by 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