Class Files

• Class Outline
• Customize Quick Access Toolbar and Ribbon
• Formatting and Printing
• Examples of commonly used formulas
• 193 Keyboard shortcuts in Excel 2010

Sample Files:

• Addresses
• Basic.xlsx
• Excel Tips and Tricks

Excel 2010 Training sites

• Microsoft Excel 2010 Training Page
• Microsoft Excel Training Advanced
• Printing Option in excel 30-40 minute video training course

Class Files:

• Excel 2010 Intermediate

Sample Files:

• FunctionsData.xlsx

Excel 2010 Training site

• Alphabetical Listing of Excel 2010 Functions
• Custom Lists for AutoFill
• Duplicate Records filtering
• Filtering data
• Text to Columns feature
• Wrapping text in a cell

Class Files:

• Creating Charts/Graphs

Sample Files:

• Student Statistics.xls
• Diversity.doc
• Diversity.ppt

Excel 2010 Training site

• Microsoft Training - Chart I
• Excel 2010- Creating Charts
• Microsoft Training - Chart II
• Excel 2010 - Formatting Charts
• Microsoft Training - Chart III
• Choosing a chart type

Class Files

Class Files:

• Creating and Running Macros
• First Export.xls
• Addresses.xls
• Macrocanned.xls
• Macroproblem.doc

Excel 2010 Training site

• Excel 2003 - Macros
• Excel 2010 - Macros
• Word Macro
• Excel Macro

Class Files

• Formulas and Functions
• Formula Sheet.xls
• Class Roster.xls
• Grade Sheet.xls

Excel 2010 Training site

• Excel 2003 - Formulas
• Excel 2010 - Creating Formulas
• Editing Text with formulas