› Microsoft Excel Class in Boston on September 1, 2017 Excel

Microsoft Excel Class in Boston on September 1, 2017 Excel

Microsoft Excel Training Class

Fri, Sep 1 2017
9:30 a.m. to 4:30 p.m.
American Graphics Institute
AGI Training Boston
American Graphics Institute AGI Training Boston
120 Presidential Way
Woburn MA 01801

Microsoft Excel is the premier spreadsheet application.In this Microsoft Excel training class you will learn how to create spreadsheets using formulas, functions, data sorting, custom charts, link building, macros, and 3-dimensional worksheets. This Microsoft Excel Training course will also teach you how to sort and analyze data, create custom charts and graphs, and much more.

Download Course Description (PDF)     See all Microsoft Office Classes

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

AGI Training Boston
120 Presidential Way
Woburn, MA
01801
USA
(781) 376-6044
Adobe Training, Photoshop Classes, InDesign Courses, HTML Classes, UX Classes, Creative Cloud Classes, Illustrator Classes, and Apple Training in Boston.