Getting to know Excel is a MUST for Business Professionals.

Microsoft Office Excel is a unique spreadsheet-application that features calculation, graphing tools and pivot tables.

Our training courses are designed around the various functions in Excel to fit your level of interest.  If you have the basics down and want more, try the advanced course where we will show you how to automate repetitive tasks.

Are you still intimidated by this tool, but you know you have to learn it because everyone in the office keeps sending Excel files to your inbox?

If so, we will break down this seemingly complicated Microsoft Office tool into three levels of understanding to ensure you absorb the new and useful tips of the program without overwhelming you.

Beginner	Intermediate	Advanced
Creating a Basic Worksheet Explore the User Interface and the Ribbon Customize the Quick Access Toolbar Navigate and Select in Excel Enter Data and Save a Workbook Performing Calculations Create Basic Formulas Calculate with Functions Copy Formulas and Functions Modifying a Worksheet Manipulate Data Working with Cells, Columns, and Rows Search for Data in a Worksheet Spell Check a Worksheet Formatting a Worksheet Modify Fonts Add Borders and Color to Cells Change Column Width and Row Height Apply Number Formats Using Styles Printing Workbook Contents Print Workbook Contents Using Default Print Options Setting Page Breaks Managing Large Workbooks Format Worksheet Tabs Manage Worksheets in a Workbook Manage the View of Large Worksheets	Calculating Data with Advanced Formulas Manage Cell and Range Names Calculating Data Across Worksheets Analyzing Data with Logical and Lookup Functions Organizing Worksheet and Table Data Creating and Modifying Tables Formatting Tables Sorting or Filtering Worksheet or Table Data Calculating Data in a Table or Worksheet Presenting Data Using Charts How to Create a Chart Modifying Charts Formatting Charts Analyzing Data Using PivotTables and PivotCharts Creating a PivotTable Report Analyzing and Modifying a PivotTable Inserting Graphic Objects Inserting and Modifying Pictures and ClipArt Drawing and Modifying Shapes Customizing and Enhancing Workbooks and the Excel Environment How to Customize the Excel Environment Customizing Workbooks Managing Themes How to Create and Use Templates	Streamlining Workflow Creating Macros Adding Macros to the Quick Access Toolbar Editing a Macro Using Conditional Formatting Applying Data Validation to a Worksheet Updating Workbook Properties Modifying Excel Options Collaborating with Others Protecting Files and Sharing Workbooks Merging Multiple Workbooks Adjusting Macro Settings Restricting Document Access Auditing Worksheets Tracing Cell Precedents and Dependents Troubleshooting Errors in Formulas Watching and Evaluating Formulas Creating a Data List Outline Analyzing Data Adding a Trend Line to Charts Create Scenarios and Performing What-If Analysis Working with Multiple Workbooks Create a Workspace Consolidate Data Managing Linked Cells in Different Workbooks Importing and Exporting Data Exporting Excel Data Importing a Table from Word Importing a Delimited Text File

Microsoft Excel Certification

Microsoft certifications demonstrate your computing skills and help advance your career prospects in a competitive job market. Microsoft Certified Application Specialist certifications are primarily for office workers who use Microsoft Office programs as a vital part of their job functions.

• Microsoft Excel 2007 - Beginner
• Microsoft Excel 2007 - Intermediate
• Microsoft Excel 2007 - Advanced
• Microsoft Excel 2007 - MCAS