Learn Advance EXCEL and VBA
Advance EXCEL & VBA

Advance EXCEL & VBA

Introduction

You may use Excel daily, or maybe only casually, but one thing’s for sure—you’ve probably wished you knew more about this dynamic program. That’s why you’ll want to attend this workshop. In it, you’ll learn ways to make your job easier and increase the sophistication of your data reporting and analyzing. Each session focuses on saving-you-time techniques, advanced “how-to’s,” exploring those previously “programmer only” features and more.

Along with this practical and usable training, you’ll learn how to integrate your work within the Office “family” for even greater results.

If you’ve ever been frustrated using Excel because you knew there had to be a better way of accomplishing your tasks, you’ll soon be on your way to getting more done—and more efficiently—with this power-boosting workshop.

Content

MS Excel is widely considered as one of the most popular basic spreadsheet programs which is used by millions of users and corporate all over the world to keep records of their valuable data in a more systematic and accurate way. This workshop will aid learners to learn the advanced concepts of MS Excel in order to become a professional in no time.

Below is the content of the workshop: -
  • Introduction and Basic Brush-up of MS Excel and Excel Back-End Operations:
    • Excel basic formulas and look up functions
    • Structuring Of The Data & What If Analysis
    • Conditional Formatting And Working With Charts
  • Pivot Table and Pivot Charts with Slicer and Handling of Errors In Excel
  • VBA Macro Programming:
    • Recording of Macros and Writing of Macro
    • Programming Writing Concepts & Data Types
    • Working With Loops and Range Objects
    • Writing of Formula in VBA and Error Handling
  • Advanced VBA Functions

Popular Courses

SQL Python Excel Tableau SAS

5 months course including relevant capstone projects. This program offers Job Guarantee of minimum 5 lakh per annum.

View Details
Quant LR DI VARC Puzzles

20 days of online classes. 400+ question marathons, 50+ practice tests to bolster confidence

View Details
Statements Valuation Options Trading

8-week long class covering Accounting principles, Financial statements analysis, Excel and Valuation

View Details