# EXCEL TRAINING

Got any Excel Questions? Free Excel Help

Back To: Auto-Formats in Excel. See Also: Excel Calculations | Excel Formulas

## Week 1

Class Activity 1 - Basic Workbook Creation

Class Activity 2 - Workbook Creation Task

Class Activity 2 - Workbook Creation Task

Class Activity 4 - Creating More Formulas

Class Activity 5 - Formula Revision Task

Class Activity 6 - Essential Functions

Class Activity 7 - Functions Task

## EXCEL LEVEL 1 TRAINING

#### ExcelLevel 1 Excel Training Index

 Excel Lesson 1: The Fundamentals of Excel Excel Lesson 2: How to Start Excel, Creating and Saving Workbooks Excel Lesson 3: Toolbars and Task Panes in Excel Excel Lesson 4: Insert/Delete/Name/Move Worksheets Excel Lesson 5: Cells, Moving Around Workbooks, Exiting Excel Lesson 6: Basic Copy/Cut & Paste Excel Lesson 7: Quick Copying Using the Fill Handle Excel Lesson 8: Pasting Using Paste Special Excel Lesson 9: Inserting Rows, Columns and Cells Excel Lesson 10: Changing the Standard Default Options in Excel Excel Lesson 11: Using the Undo and Redo Feature Excel Lesson 13: Using Dates and Times in Excel Excel Lesson 14: Working with Custom Formats in Excel Excel Lesson 15: The Basics of Excel Formulas Download the associated  Workbook for this lesson Excel Lesson 16: Excel Cell References. Relative and Absolute Cell References Excel Lesson 17: Avoid Typing Whenever Possible. Use Your Mouse Pointer Excel Lesson 18: Excel Arguments and Syntax in Formulas Excel Lesson 19: Excel AutoSum Function/Formula Excel Lesson 20: Excel Auto Calculate. Calculate Without Formulas Excel Lesson 21: How to Use the Insert Function Feature to Create Formulas Excel Lesson 22: Using Some of Excel's most Common Functions Download the associated  Workbook for this lesson Excel Lesson 23: Using Named Ranges in Excel as an Alternative to Cell References Excel Lesson 24: Using Constants to Name Values and the Paste Name Dialog Excel Lesson 25: Excel Calculations/How Excel Calculates/The Order of Calculations Excel Lesson 26: Excel Cell Comments Excel Lesson 27: Excel Find & Replace Excel Lesson 28: Different Methods of Clearing Cell Contents Excel Lesson 29: Effective Printing in Excel 1 Excel Lesson 30: Effective Printing in Excel 2 Excel Lesson 31: Sorting Data in Excel Excel Lesson 32: Hide/Show Rows/Columns in Excel Excel Lesson 33: Excel AutoFormats Excel Lesson 34: Creating a Basic Spreadsheet Excel Lesson 35: Charting the Basic Spreadsheet Excel Lesson 36: Excel Worksheet Protection Excel Lesson 37: Excel IF Formula/Function Excel Lesson 38: Volatile Functions-Now & Today

Back To: AutoFilters in Excel VBA

Next: AutoFilter Date Criteria in VBA

Excel Dashboard Reports & Excel Dashboard Charts 50% Off Become an ExcelUser Affiliate & Earn Money

Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over \$64.00. ALL purchases totaling over \$150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.