Preparatory Excel for VBA Macro Training

Course for VBA Macro applicants. By Microsoft Certified Trainers.

  • (1948)

This is a 9­-hour, activity­-based program, focusing only on the core topics like Excel Functions & Formulae, Pivots, Charts & Dashboards, etc. required to learn VBA Macro programming, hassle­-free.

The course is offered along with the Excel VBA Macro program and, cannot be taken as stand alone. A pre-­assesment will be scheduled to, understand your current Excel skills-­This should help you to decide if the preparatory course is required for you to learn Excel VBA Programming effectively.

  • Course Duration:
  • 9 Hours (3 Saturdays, each of 3­-hour)
  • Mode of Training:
  • Classroom, Instructor-Led

Course Content - Overview

Formulae Fundamentals
  1. Entering Formulas
  2. Editing Formulas
Referencing Techniques
  1. Relative Reference
  2. Absolute Reference
  3. Mixed Reference
Mathematical Functions
  1. Sum
  2. Sumif
  3. Sumifs
  4. Average
  5. Averageif
  6. Averageifs
  7. Max
  8. Min
  9. Sumproduct
  10. Count
  11. CountA
  12. Countblank
  13. Subtotal
Lookup Functions
  1. Vlookup
  2. Dynamic Vlookup
  3. Hlookup
  4. Dynamic Hlookups
  5. Match
  6. Index
  7. Indirect
  8. Offset
Logical Functions
  1. Nested IF
  2. And
  3. Or
  4. Not
Text Functions
  1. Istext
  2. Code
  3. Char
  4. Exact
  5. Len
  6. Trim
  7. Upper
  8. Lower
  9. Proper
  10. Left
  11. Right
  12. Mid
  13. Substitute
  14. Replace
  15. Find
  16. Search
Date & Time Functions
  1. Date
  2. Datevalue
  3. Day
  4. Days360
  5. EDate
  6. Emonth
  7. Month
  8. Today
  9. Weekday
  10. Year
  11. Now
  12. Hour
  13. Minute
  14. Second
  15. Time
  16. Timevalue
Rounding Numbers
  1. Ceiling
  2. Even
  3. Floor
  4. INT
  5. Mround
  6. Odd
  7. Round
  8. Roundup
  9. Rounddown
  10. Trunc
Error Handling Functions
  1. Isna
  2. Iserr
  3. Iserror
CREATING PIVOT TABLE
  1. Changing the Pivot Table layout
  2. Formatting row , column and value fields
  3. Grouping items – Number Grouping and Date Grouping
  4. Inserting calculated fields
  5. Display and hide data in fields
  6. Layout reports directly on worksheet
  7. Manual, Single & Multi sorting options
  8. Manual, Single & Multi Filtering options
  9. Multiple ways of presenting data in Pivot Table
  10. Using advanced value field setting
  11. Display Amount in Percentage
  12. Pivot Table – Design Tab
PIVOT TABLE OPTIONS USING SLIZERS CHARTS & PIVOT CHARTS
  1. Bar Charts / Pie Charts / Line Charts
  2. Dual Axis Charts
  3. Dynamic Charting
  4. Other Advanced Charting Techniques
EXCEL DASHBOARD
  1. Bar Charts / Pie Charts / Line Charts
  2. Planning a Dashboard
  3. Adding Tables to Dashboard
  4. Adding Charts to Dashboard

Training Schedule

About the Trainer

Mr.Sami (MCT, MOS, MEE)

Mr. Sami, Microsoft Certified Trainer, with his qualifications in Finance and IT brings in 14 years of Industry experience. He has successfully trained 3000+ professionals by now, and the counting is still on.

He has undertaken the renowned VBA assignments with IRS, The World Bank, Tata Chemicals, Buckman Laboratories, Standard Chartered, ING Barings and much more. His nature of going that Extra Mile has got him the startling popularity amongst the Excelgoodies prominent clients.

Contact Us

  • ExcelGoodies Software Private Limited
  • 56, 1st Floor, North Boag Road,
  • T. Nagar, Chennai - 600 017
  • +91 9176633248
  • inquiry_Chennai@excelgoodies.com

Learner stories around the world!