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
• VBA Security
• Workbooks
• Working with Excel Tables in VBA