Specializing in Rapid Learning for core Microsoft Office applications (Excel, Word, PowerPoint)

Standard Training Topics

1. Excel introduction and orientation for new users

   1. Glossary of terms

   2. Page setup, headers/footers, etc.

   3. Spreadsheet navigation

   4. Copy/paste data

   5. Workbooks & worksheets

   6. Splitting/freezing panes, hiding/sizing rows & columns

   7. General and view options (Auto formatting worksheets)

   8. Printing and saving documents

   9. Introduction to basic Excel formulas (add, subtract, multiply, divide)

   10. Using Excel Help

2. Creating text based tables

   1. Sorting, filtering, organizing tables

   2. Text formatting

   3. Basic data import/export

   4. Mail Merge with Microsoft Word

   5. Excel as a word processor

   6. Subtotals

   7. Data validation

   8. Search/replace

   9. Auto fill cells/ranges (i.e. numbering, months, weeks, etc.)

10. Creating simple databases

3. Creating simple number based tables

   1. Performing basic calculations (& auto sum columns)

2. Performing calculations of cells/rows/columns

3. Subtotals

4. Conditional formatting

5. Naming and working with ranges

6. Consolidate data

4. Creating charts/graphs

5. Creating and managing databases

6. Multi-dimensional tables

   1. Integrating multiple workbooks/worksheets

7. Importing/exporting data from external programs

   1. Parsing lists created in other programs

   2. Cleansing & transforming data

   3. Converting text to columns

8. Pivot table analysis/pivot charts

9. Office application integration

   1. Integrating live tables/spreadsheets into other Office applications (Word, PowerPoint, etc.)

   2. Pasting static tables into other Office applications

   3. Advanced Mail Merge (including merging into Outlook email documents)

10. Creating and automating Macros

    1. Introduction to VBA (Visual Basic for Applications)

11. Creating Excel based data entry forms

    1. Inserting drop down lists. Checkboxes, radio buttons, etc.

1. Working with advanced formulas

   1. Financial, date-time, Math, Statistical, lookup/reference, database, text, logical, information

2. Sharing workbooks

3. Tracking changes

   1. Track, accept, and reject changes to workbooks

4. Protecting cells

5. Protecting workbooks and worksheets

6. Goal Seeking

7. Creating and applying text styles

8. Inserting comments

9. Saving multiple documents as a workspace

10. Customizing Excel views, menus and toolbars

11. Trace formula precedents, dependents, and errors