excel-vba

• Getting started with excel-vba
• Application object
• Arrays
• autofilter ; Uses and best practices
• Binding
• Charts and Charting
• Common Mistakes
• Conditional formatting using VBA
• Conditional statements
• Creating a drop-down menu in the Active Worksheet with a Combo Box
• CustomDocumentProperties in practice
• Debugging and Troubleshooting
• Excel VBA Tips and Tricks
• Excel-VBA Optimization
• File System Object
• How to record a Macro
• Locating duplicate values in a range
• Loop through all Sheets in Active Workbook
• Merged Cells / Ranges
• Methods for Finding the Last Used Row or Column in a Worksheet
• Named Ranges
• Pivot Tables
• PowerPoint Integration Through VBA
• Ranges and Cells
• SQL in Excel VBA - Best Practices
• Use Worksheet object and not Sheet object
• User Defined Functions (UDFs)
• VBA Best Practices
• Always define and set references to all Workbooks and Sheets
• ALWAYS Use "Option Explicit"
• Avoid re-purposing the names of Properties or Methods as your variables
• Avoid using ActiveCell or ActiveSheet in Excel
• Avoid using SELECT or ACTIVATE
• Document Your Work
• Error Handling
• Never Assume The Worksheet
• Switch off properties during macro execution
• Use descriptive variable naming
• Use VB constants when available
• Work with Arrays, Not With Ranges
• WorksheetFunction object executes faster than a UDF equivalent
• VBA Security
• Workbooks
• Working with Excel Tables in VBA