Excel VBA Video Training/ EXCEL DASHBOARD REPORTS

CERTIFICATE III INFORMATION DIGITAL MEDIA TECHNOLOGY

EXCEL TRAINING

Got any Excel Questions? Free Excel Help

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

STUDENT RESOURCES

Week 1

1. Excel Revision Exercises INSTRUCTIONS

2. Class Ex 1 Data - Formatting_Fill, Basic calcs

3. Class Ex 2 Data - Creating Formulas

4. CLass Ex 4 Data - Printing

5. OYO Exercise 4

6. OYO Exercise 6

7. Handout - Excel Basics Booklet

EXCEL LEVEL 1 TRAINING

Excel Level 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.

Instant Download and Money Back Guarantee on Most Software

Excel VBA Video Training/ EXCEL DASHBOARD REPORTS

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft