Adv. Excel with VBA Macros Training in Gurgaon

     Excel VBA Macros is a programming language that enables you to control just about everything in Excel. You all learn how to create Macros that can be run from things like a button on a spreadsheet. Just like our Excel course, these lessons have lots of examples, and we have simplified them as much as possible so that it's easy to learn Excel VBA Macros. Using Excel Excel VBA Macros will extend your knowledge of recorded Macros and provide you powerful skills to automate Excel Macros.

    1: Introduction
  • Different File extensions
  • All Keyboard shortcuts
  • Data types and properties
  • Create, delete and update new templates
  • 2: Basics of Advanced Excel additional Formatting
  • Define Name
  • Paste special
  • Conditional formatting
  • Basic functions
    3: Advanced formulas and linking
  • Advanced formulas like Database, time, date, number, mathematical logical etc.
  • Creating links
  • Errors and error types
  • 4: Sorting & Filtering
  • Multilevel sorting
  • Custom sorting
  • Filtering
    5: Goal Seek, Scenarios, Grouping and Subtotals
  • Creating, using, and ,editing scenarios
  • Concept of Goal seek and using it
  • Grouping large data by different criteria
  • Adding subtotals to grouped data

Office Address

M-48, OLD DLF Colony, Sec-14, Gurgaon, Haryana

Branch Office

M-48, OLD DLF Colony, Sec-14, Gurgaon, Haryana

Call Now

9968523574, 8588809802,
0124-4077100

Email us

Email Us at

website

Office Address

M-48, OLD DLF Colony, Sec-14, Gurgaon, Haryana

Call Now

9968523574, 8588809802,
0124-4077100

Email us

Email Us at

website