Excel VBA Video Training/ EXCEL DASHBOARD REPORTS

Ozgrid, Experts in Microsoft Excel Spreadsheets

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 (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

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

Some of our more popular products are below...
Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To...... | Analyzer Excel | Downloader Excel | MSSQL Migration Toolkit | Monte Carlo Add-in | Excel Costing Templates