Excel school training courses in Boston, MA (public, in-house or online)

You Will Learn How To

Summarize data with Excel by incorporating formulas, formatting, and charts and graphs
Efficiently navigate and manipulate multiple spreadsheets in a workbook
Optimize your worksheets using templates, graphs and formulas
Design simple-to-complex formulas by nesting Excel functions
Present data visually using Excel tables and charts
Import, fine-tune and share Excel data in your workgroup

Course Benefits

In today’s workplace, Mi...

Full archival course description>>

In this course, students create and edit basic Microsoft® Office Excel® 2007 worksheets and workbooks. (Second Edition)

At Course Completion:
Upon successful completion of this course, students will be able to: - Explore the Microsoft® Office Excel® 2007 environment and create a basic worksheet. - Perform calculations. - Modify a worksheet. - Format a worksheet. - Print workbook contents. - Manage large workbooks.

Outline :
Lesson 1: Creating a Basic Worksheet
Explore ...

Full archival course description>>

Students will learn how to customize workbooks, collaborate with others, audit workbooks and analyze data. Students will also learn how to work with multiple workbooks, import and export data, and structure workbooks with XML.


Prerequisites: Intermediate Excel or equivalent experience


Length: One day



Streamlining Workflow
�Create a Macro
�Edit a Macro
�Customize Access to Excel Commands
�Apply Conditional Formatting
�Add Data Validati...

Full archival course description>>

Students will gain the skills needed to create and apply templates, create and modify charts and work with graphic objects. Students will also learn how to calculate with advanced formulas and sort and filter data.


Prerequisites: Introduction to Excel or equivalent experience


Length: One day



Creating and Applying Templates
�Create a Workbook from a Template
�Create a Custom Template
�Working with Comments
�Create a Hyperlink
�Use Web-...

Full archival course description>>

Students will create, edit, and print basic worksheets in Excel. They will enter formulas for calculations and improve the appearance of worksheet data by using a variety of formatting techniques.


Prerequisites: Windows or equivalent skills


Length: One day



Getting Started with Excel
�An Overview of Excel
�Navigate in Excel
�Select Data
�Enter Data
�Save a Workbook
�Spell Check a Worksheet

Performing Calculations
�Creat...

Full archival course description>>