Excel school training courses in Baltimore, MD (public, in-house or online)

Learn how to create, edit, format and print basic Excel 2007 worksheets. Prerequisite: Windows Intro or equivalent knowledge.

Work with advanced formulas, lookup functions, data validation and database functions. Work with PivotTables and PivotCharts, import and export data, and query external databases. Learn about the analytical features of Excel, run and record macros, and share Excel data via the Web. Prerequisite: Excel 2007 Intermediate or equivalent knowledge.

Gain proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code. Designed for experienced Excel users. Prerequisite: Excel 2007 Advanced or equivalent knowledge.

Learn to create PivotTables to increase productivity and produce reports in minutes instead of hours. Go from creating basic PivotTables to building a dynamic PivotTable reporting system. Prerequisite: Excel 2007 Advanced or equivalent knowledge

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>>