Microsoft Advanced Excel Training Outline
Intermediate and Advanced Classes Thoughts
Review Tony's Place Key Points
Names
Formulas
Inserting Names
Formatting a spreadsheet
Conditional Formatting
Print Area
Sort
Auto Filter
Link to other Sheets
Summarize Date
Concatenate
Look at some options | Columns to Numbers | no zeros
Freeze Headings
Creating Charts
Pivot Tables
Format Painter
Text File to Excel Trick
Manipulating Data in Excel |