on site Training

Instructor led training classes enable participants to learn exactly what they need in a few hours rather than spending an entire day away from the office. Each class is typically 4 hours in length; however classes can be customized to accomodate specific client needs. Classes are typically scheduled on site so the training is specific to the client's environment and the needs of its end users. All classes are also available in version 2007.

Excel Training Classes

Excel 2010 Introduction

Enter basic formulas and function formulas like SUM, MIN, MAX, and AVERAGE.  Use AutoFill to copy formulas and quickly enter a sequence of numbers or dates. Insert and delete columns and rows and quickly resize all columns and rows in one step. Apply number formats, format and align data, merge and center cells, apply borders and shading, and clear formatting. Create, duplicate, and group worksheets for consistent formatting. Learn printing features such as Page Break Preview, Page Layout View, and Print Titles to repeat column and row headings on every page. Customize the Quick Access Toolbar and add your favorite tools and commands for quick access. (4 hour session)

Excel 2010 Intermediate

Use Range Names and Absolute Referencing in formulas, apply enhanced Sorting and Filtering techniques, and format data as a Table. Learn statistical functions such as COUNT and COUNTIF, math and trig functions such as SUMIF and SUMIFS, and text functions such as UPPER, LOWER, PROPER, CONCATENATE and TRIM. Learn to use the Text to Columns, Remove Duplicates, and Data Validation tools. Duplicate, copy, and move worksheets and enter three-dimensional formulas. Additional topics include Conditional Formatting, Formula Auditing and linking Excel charts and worksheets in Word and PowerPoint. Excel Introduction is the prerequisite. (4 hour session)

Excel 2010 Charts

Create column, bar, line, pie, and area charts and select a default chart type to insert a chart with one keystroke. Learn which chart types best illustrate changes over time, show comparisons among categories, display contributions to a total, etc. Move and resize charts, use chart buttons, and modify chart elements such as a titles, legends, and scales. Format the data as a Table so you'll never have to redefine the source data. Learn to customize the axis scale; create a chart with two scales, and add visuals such as explanatory text and data labels. Create chart templates to save chart modifications and insert chart sparklines.  Excel Introduction is the prerequisite. (4 hour session)

Excel 2010 Data Analysis & Tables

Format data as an Excel Table and learn all of the advantages that Tables have to offer such as total rows, calculated columns, and structured references. Learn to easily remove Duplicates, Convert tables to ranges, Sort and Filter, and add Subtotals. Create PivotTables and PivotCharts, rearrange fields and refresh PivotTables, change the summary function; analyze data from multiple sources, define Relationships across multiple tables, add Tables and Fields, and create a Power View sheet. Excel Introduction is the recommended prerequisite. (4 hour session)

Excel 2010 Advanced Features

Learn to use lookup functions such as LOOKUP using an array, LOOKUP using a lookup vector and result vector, VLOOKUP, and HLOOKUP. You will also learn to calculate with the Subtotals command and create, modify, and format PivotTable Reports and PivotTable Charts. Record and run Macros to automate repetitive or complicated tasks. Protect worksheets and workbooks to hide data and prevent unwanted modifications. Excel Introduction and Excel Intermediate are the recommended prerequisites. (4 hour session)

Excel 2010 Tips & Shortcuts

Learn new time saving features associated with Range Names and formatting a range as a Table, use new techniques to Sort and Filter data, Group worksheets to apply changes to an entire workbook, and quick tips to remove unwanted blank rows and columns at the end of a worksheet. Learn to create a chart in one step, save a customized chart as a template to use again and again, and change the default chart type. Many other tips and shortcuts are included as well. Excel Introduction is the recommended prerequisite. (2 hour session)