•  +91 7066 716 001
  •  info@aimcomputerseducation.com

Adv. Excel & VBA

Adv. Excel & VBA: Step by Step

Courses Description :

Duration   2.5 Months

We all know Excel is essential for any business. When applied effectively it is a powerful tool, allowing you to manipulate huge amounts of data, automate tasks and present complex information however you see fit. We also know how difficult it is to find quality instruction that is:

  • Easy to follow
  • Gets you the results you want
  • Teaches you advanced methods that you can quickly put into practise

That’s why we developed our online Advanced Excel course. It’s split into 5 clear sections to get the results you want right away. Your teacher is Simon Hurst, an Excel expert and trainer for 20+ years, whose experienced instruction will transform your Excel skills in under a week with none of the usual frustration.

Take your Excel skills to the next level with our Advanced Excel course. You’ll soon be crunching data, using advanced formulas, creating impressive graphs and charts like a pro, plus much more.

 

VBA is a language used for programming tasks and actions in Excel or developing additional functions in Excel worksheets that are customised to your work needs.

VBA is great for automating actions – saving time by performing programmed actions time and time again.  So you don’t have to set things up from scratch each time.

For example, if you are at an intermediate level, you can use macros without opting for the use of VBA.  However, understanding and using VBA gives you more flexibility to set up Excel to act on commands that may be too complex to be recorded in a macro. In this situation, VBA is suited to more advanced users of Excel. VBA is key to speeding up work and cutting out inaccuracies for everyone in the organization

Overview of the Basics of Excel
Functions/ Data Validations
HLOOKUP & VLOOKUP
Templates
Sorting and Filtering Data
Reports/Goalseek
Conditional Formatting
Macros /What If Analysis
Pivot Charts/Sparklines
Scenario Manager
Final Assignment
Intro VBA
If..else / Loop
Cell/Range
GUI formation
User Response
Array/MIS
Final Project

Scroll to top

logo

Education Template

Purchase Now