ADVANCED EXCEL HANDS-ON CLASSES

MANAGING SPREADSHEETS & WORKBOOKS:  

Insert, copy, move, and delete columns, rows and spreadsheets. Copy data from one spreadsheet to another. Name cell ranges. Split panes to view different parts of spreadsheet simultaneously. Freeze and Unfreeze panes to view titles while scrolling down a page. Add notes to a cell. Sort data.   

TEMPLATES: 

Create and edit a Workbook Template, complete with formulas, functions, AutoSum, titles, borders, clip art, etc., so you can base new spreadsheets on it. 

Advanced FORMULAS & FUNCTIONS: 

Use 3-D Formulas to combine data from multiple spreadsheets located within the same workbook (file). Link Workbooks to combine data located in separate workbooks (files). Use Functions such as Count, CountIf, SumIf, and If Statements to calculate text or numeric values. "Nest" one function within another. Use Conditional Formatting.

HLOOKUP & VLOOKUP: 

Use HLookup and VLookup to look up text or numeric values contained in rows or columns.

VALIDATION: 

Use Validation to improve speed and accuracy of data entry. Add drop-down lists and pop-up explanation boxes.

PIVOT TABLES: 

Use Pivot Tables to summarize rows of data for reports.

CHARTS & FORMS: 

Insert, Move, Edit, and Resize a variety of different charts. Create Forms to speed up data entry, editing, and searching.

MISC.:

Create simple Macros to automate basic tasks, add Hyperlinks to connect spreadsheets to Word documents and other files, add Comments to provide documentation for user, Protect a Worksheet or Workbook so it cannot be changed, etc.