Advance Excel, VBA & Dashboard Training Premium class

Manoj Kumar

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
15 Videos (41m)
    • 1. Define Short Cut key to Open Excel File

      2:04
    • 2. Basic Excel Calculation

      3:55
    • 3. Define Range to perfomr Calculations

      1:28
    • 4. Understand Relative References

      2:23
    • 5. Uderstand Mixed References

      3:05
    • 5. Write a 3D formula and Use Consolidate

      3:38
    • 1. Short Cut to Autosum, Copy, Paste

      2:49
    • 2. Repate Privious Task

      2:09
    • 3. Ctrl D & Ctrl R

      1:10
    • 4. Insear & Delete multiples rows & Columns

      1:55
    • 5. Hide & Unhide Ribbon

      1:29
    • 6. How to use Ribbon & Quick Access toolbar

      2:55
    • 7. Customize Short cuts

      4:47
    • 8 Customize Ribbon

      3:50
    • 8

      3:50

About This Class

Excel, VBA & Dashboards Training for Advance Users:

Use Excel like a Pro and Take Excel reports to the Next Level.

These days almost every job requires data management, presentation and analysis of results.

In this course, the participants are going to learn a wide variety of Excel topics from Basic & Intermediate excel formulas & tools to very advanced dashboards reporting techniques using VBA, Power Pivot & Dynamic Charts. Participants will be able to create high-impact reports and dynamic dashboards in Excel, quickly and efficiently.

We will begin by laying the groundwork by covering Excel short cuts, formulas & functions, various tools & commands of VBA and followed by Dashboards reporting techniques of increasing complexity.

        Topics to be covered:                     Descriptions

  1. Advance Excel Training:             Cover excel short cut, tools and more than 100 Excel functions
  2. Visual Basic for Applications:     Most useful commands, data types, events, User Forms, Protections
  3. Dashboards Reporting:                All chart types, Dynamic Chart & properties, Pivot table, Pivot

                                                        Charts & Power Pivot and other business Intelligence tools