MS Excel 2010 – Training Schedule

BEGINNER

Excel Essentials & Intro to Formulas & Functions (Module 1)

Introduction to the Excel 2010 interface, the ribbon, the backstage view & the quick access toolbar, zooming in and out of a worksheet, navigating and selecting cells, keyboard shortcuts, entering and editing data, deleting/replacing cell data, performing simple calculations, saving the workbook file, checking compatibility with older versions of Excel, overview of the formulas ribbon, building basic formulas, using simple functions, copying formulas/functions with the autofill command, using relative and absolute cell references in calculations.

June 13, &
October 24

8:00am-12:00pm

Formatting Spreadsheet Design, Page Setup & Printing (Module 2)

Inserting rows & columns, moving & copying data, using autofill to complete a series of values, introduction to worksheet themes, formatting worksheet data/using cell styles, using excel templates/creating custom templates, managing worksheets - inserting, deleting, renaming, move/copy, grouping worksheets, freezing or splitting panes, creating custom views, spell checking your worksheets, setting print options through page setup, using the page layout view, printing your worksheet.

June 13 & October 24

1:00pm-5:00pm

INTERMEDIATE

List/Table Essentials & Charting
(Module 3)

Overview of list design, formatting lists as tables, single and multi-level sorting, removing duplicates from a list or table, filtering records in a list or table, search by filter, inserting automatic subtotals in a list, inserting data charts, formatting and editing chart elements, adding/removing data from a chart, creating custom chart templates, printing charts, changing table and chart formatting through themes, inserting sparkline.

August 8 & November 7

8:00am-12:00pm

Importing Data, Pivot Tables, Protecting & Linking Data
(Module 4)

Importing data from other sources, overview of exporting options, creating a database query, creating pivot tables from lists or tables, filtering pivot tables, using the slicer tool within a pivot table, working with pivot charts, applying data validation rules, applying built in conditional formatting, creating custom conditional formats, inserting & editing comments, linking data, cell, sheet, and file protection.

August 8 & November 7

1:00pm-5:00pm

ADVANCED

Creating Advanced Functions
(Module 5)

Creating and applying names in a worksheet, using the IF function, introduction to nesting functions, using the formula auditing tools, using the LOOKUP functions, using SUMIF(S), COUNTIF(S), AVERAGEIF(S) functions, using the IFERROR function, other useful functions (Database, Text and Date Functions - time permitting)

October 10 & November 14

8:00am-12:00pm

Using the "What If" Analysis Tools & Recording Macros
(Module 6)

Using the consolidate data commands, using the goal seek and solver tools, creating data tables, using the scenario manager, adding the developer tab to the ribbon, recording and running macros, editing macros with the visual basic editor, creating buttons to run macros (quick access toolbar & worksheet buttons), microsoft skydrive overview, customizing the ribbon.

October 10 & November 14

1:00pm-5:00pm

SPECIAL

Excel for Science

Database Management & Pivot Tables: list design, sorting and filtering, subtotals, pivot tables, advanced functions in pivot tables, data validation, LOOKUP functions, database functions;
Advanced Formulas & Intro to VBA: relative vs absolute, linking names, IF functions, nesting functions, formula auditing tools, macros, user-defined functions;
Agenda Scientists and Engineers:  freeze and split screens, custom formatting, count functions, named ranges, max/min functions, standard deviation function, variance, median, mode functions, COUNTIF functions, SUMIF functions, data validation, conditional formatting, X-Y scatter charts, array functions/tend function/growth function, goal seek, custom views, solver, linking workbooks/worksheets.

September 26 & December 12

8:00am-5:00pm