In this Advance Excel & VBA course, you will learn below concepts:
1. Creating and Editing Formulae
2. Conditional Functions & Formats and Date Calculations
3. IF functions and Conditional Formatting
4. Lookup and Reference Functions
5. Pivot Tables & Charts
6. Excel Charts / Graphs
7. Introduction to Excel VBA
8. Variables
9. Excel Object Model
10. Procedures
11. Functions
12. Workbook Object
13. Worksheet Object
14. Range Object
15. If-Else Condition
16. Looping
17. Arrays
18. Collection
19. PivotTable Object
20. Charts Object
21. Using SQL Queries (ADODB)
22. User Form Design
View this Course
Certified
You have 
