Cradle Mountain

Category: Scenery

Excel VBA Basics
Excel VBA Objects
- Working with Objects
Working with Variables
- Declare Variables in VBA
Conditional Statements
- If…Then…Else Statements
- Select…Case Statements
Excel VBA Loops
- Excel VBA For & Do Loops
Excel Application Object
- Application Object, Properties & Methods
- Application.OnTime VBA, Schedule Macros
Workbooks & Worksheets
Excel VBA Cells & Ranges
Text, String & Date Functions
Excel VBA Procedures
Excel VBA Arrays
- Excel VBA Arrays
Error Handling & Debugging
- Error Handling in VBA
- Debugging Tools in VBE
Excel VBA Events
Custom Classes & Objects
- Custom Classes & Objects, Custom Events
ActiveX & Form Controls, AutoShapes
- ActiveX & Form Controls, AutoShapes
UserForms in Excel VBA
Charts in Excel VBA
Excel Pivot Tables with VBA
Automation with VBA
Connect with Databases (ADO)
Connect with Databases (DAO)

Ebook
- Ebook of Excel Formulas
Extract Unique Values
Extract Duplicate Values
- Extract Duplicates in 2 Columns
Sort & Rank Values
Count Uniques & Duplicates
Sum Unique Values
- SUM Values for Items which appear only Once
Count & Countif
Count Non-Contiguous Ranges
Sumif & Countif Hidden Cells & Rows
- Sumif to Exclude Cells Hidden with the Hide Rows command
- Sumif to Exclude Cells Hidden by a Filter
Sum & Sumif
Sum NonContiguous Ranges
Average and Averageif
Average NonContiguous Ranges
- Average of Non-Contiguous cells which are evenly distributed
- Average of Non-Contiguous cells which are unevenly distributed
Dates, Days & Months
- Calculate End Date / Time from Start Date / Time per given Work Hours in Excel
String & Text Formulas

Scroll to top