Excel VBA Notes for Professionals
- Книги
- 25-08-2019, 18:14
- 362
- 0
- GFX_Muawia
Excel VBA Notes for Professionals
2018 | ISBN: N/A | English | 128 pages | PDF | 2.08 MB
Chapters:
Getting started with Excel VBA
Arrays
Conditional statements
Ranges and Cells
Named Ranges
Merged Cells / Ranges
Locating duplicate values in a range
User Defined Functions (UDFs)
Conditional formatting using VBA
Workbooks
Working with Excel Tables in VBA
Loop through all Sheets in Active Workbook
Use Worksheet object and not Sheet object
Methods for Finding the Last Used Row or Column in a Worksheet
Creating a drop-down menu in the Active Worksheet with a Combo Box
File System Object
Pivot Tables
Binding
autofilter ; Uses and best practices
Application object
Charts and Charting
CustomDocumentProperties in practice
PowerPoint Integration Through VBA
How to record a Macro
SQL in Excel VBA - Best Practices
Excel-VBA Optimization
VBA Security
Debugging and Troubleshooting
VBA Best Practices
Excel VBA Tips and Tricks
Common Mistakes
