Microsoft Excel - Excel from Beginner to Advanced

Learn Excel like a Professional and go all the way to Automate your all Business Functions.

Excel Essentials

(For Beginners)


Course Duration 7 Days

What you'll learn?

  • Master all the basics of Excel, even if you've never seen a spreadsheet before!
  • Build your own spreadsheets from scratch, and actually understand how they work!
  • You will be able to build your own simple, AND complex formulas (and know what the difference is!), and use some of Excels built in functions.
  • Learn the most common Excel functions used in the Office
  • Maintain large sets of Excel data in a list or table
  • Create dynamic reports by mastering one of the most Popular Tools, Pivot Tables, Data Validation etc.
  • Use effective design principles when creating and presenting data
  • Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
  • Effectively summarize and present data clearly
  • Increase your chances of promotion, or a better paying job by understanding the most widely used business software in the world


View Details

Excel Power House

(For Intermediate & Advance Excel Users)


Course Duration 15 Days

What you'll learn?

  • Learn from Intermediate to Advance level Excel
  • Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
  • Create dynamic reports by mastering one of the most Popular Tools, Pivot Tables and Dashboards
  • Build tools to help you automate, streamline, and absolutely revolutionize your workflow with Excel
  • Master data analysis tools like Goal Seek, Scenario Manager, Solver and other Analysis Tools
  • Practice with fun, interactive, and highly effective lessons from a best-selling Excel instructor
  • Build Powerful Advanced Excel Projects From Scratch
  • Build Gantt charts in Excel for project planing
  • Exploit Excels built in advanced functions to do things "regular" users think are impossible!
  • Build Interactive Dashboard Reports with Buttons and Drop Down Menus
  • Impress management with your new version of expertise on most sort out tool_MS Excel

Become an absolute EXCEL POWER HOUSE

View Details

Excel Power User

- Data Analysis & Dashboard Reporting
(For Advance & Creative Excel Users)


Course Duration 10 Days

What you'll learn?

  • Analyze data and create reports in a fraction of the time of spreadsheets
  • How to approach an Excel dashboard project from idea to delivery
  • How to add interactivity to your Excel reports - No VBA required
  • Clever use of Excel core functionality for responsive spreadsheets
  • Creating Interactive as well as static Excel Dashboards
  • Build Dynamic, Interactive Microsoft Excel Dashboards 
  • Create impressive, non-standard Excel charts using smart techniques
  • Learn how to create a professional stunning dashboard for Sales & Marketting, Accounts & Finance, Projects, HR, Admin & IT Departments
  • Use powerful visual techniques so your content has more effect
  • Build Pivot Table-based dashboards for easy interactivity
  • Impress management with reports that make the decision-making process faster

Become an absolute EXCEL POWER USER

View Details

Become Excel Power Ninja

- VBA/Macros
(For Advance & Creative Excel Users)

Rs 9,0006,500+GST

Course Duration 10 Days

What you'll learn?

  • Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA
  • Understand coding, and the thought process behind it
  • Fully automate Excel using Visual Basic for Applications and complete routine tasks thousands of times faster!
  • Fully automate report generation
  • Develop complex full blown applications from scratch
  • Control other Microsoft applications like Outlook, Word, PowerPoint and even Windows itself!
  • Create emails and send them automatically!
  • Create Word documents using VBA code right from Excel!
  • Create PowerPoint presentations in seconds automatically
  • Create entire folder directories in Windows automatically!

Become an absolute EXCEL POWER NINJA

View Details