# EXCEL TRAINING

Got any Excel Questions? Free Excel Help

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

## Week 1 (Topic 10)

1. Excel Revision Tutorial Instructions

2. Exercise 1 Data - Formatting, Fill, Basic Calcs

3. Exercise 2 Data - Creating Formulas

4. Handout - Excel Basics Booklet

## Week 2 (Topic 11)

1. Excel Revision Tutorial Instructions

2. Revision - Formulas.

3. Printing - Class Data.

4. OYO Exercise 4 - Printing.

5. Charts - Class Data.

6. OYO Exercise 5 - Charts.

7. Essential Functions - Class Data.

8. OYO Exercise 6 - Essential Functions.

## Week 3 (Topic 12)

1. Absolute Referencing - Class Data.

2. OYO Exercise 7 - Absolute Referencing.

3. IF Function - Class Data.

4. OYO Exercise 8 - IF Function.

5. Sorting - Class Data.

6. OYO Exercise 9 - Sorting.

7. Filters - Class Copy.

8. OYO Exercise 10 - Filters.

## Week 4 (Topic 13)

1. _Partial Absolution - Class Data

2. OYO Exercise 13 - Partial Absolution

3. OYO Exercise 14 - Filling Series

4. _OYO Exercise 15 - Formatting

5. Named Ranges - Class Data

6. _OYO Exercise 16 - Named Ranges

7. Workbook Protection - Class Data

8. OYO Exercise 17 - Workbook Protection

9. _Validation - Class Data

10. OYO Exercise 18 - Validation

11. _Useful Formulas - Class Data

12. OYO Exercise 19 - Useful Formulas

## 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.