Advance Excel

Advance Excel Professional

The real power of Microsoft Advance Excel lies in the advanced functionality it offers. Having been designated as one of the prerequisites expected from the aspiring candidates aiming to join the industry, Microsoft Excel is considered to be an indispensable Management Information Systems (MIS) tool employed by the end-users.

Whether there are basic tasks like entering data, saving and opening sheets, formatting content and creating formulas or advanced tasks like manipulating data with Pivot Tables, handling complex and large calculations, presenting data with charts and drawing up advanced analysis reports, our courses will help you THINK in Excel.

Who Should do this course?

 

Candidates from various quantitative backgrounds, who are not just looking for Advance Excel training but also want to learn job oriented Analytics & Reporting skills using MS-Excel, VBA, MS-Access, SQL and Tableau

MIS and Data Analysis professional course are currently available at our Delhi, Gurgaon / Gurugram  & Noida on weekdays or weekends. As per huge demand of learns we have opened MIS Training Institute in Noida location as well. We Guarantee 100% Interview after successful completion of the 90% of MIS Training and Data Analysis Course

Course Content

  • Introduction to Microsoft Excel
  • User Interface
  • Entering Data
  • Formatting Text & Data
  • Conditional Formatting
  • Validations
  • Views and Layout
  • Pick from Drop-Down List
  • Excel Slicer
  • Smart Lookup
  • Zooming and Zoom Selection
  • Page Layouts
  • Advance Functions- Validation
  • Financial Formulas
  • Informational Formulas with Lookup
  • Wildcard Search
  • Arrays & Index Match
  • Indirect Functions
  • Data Mining-Reporting
  • Pivot Tables
  • Pivot Charts
  • Data Modelling
  • Power Pivot
  • What if Analysis, 
  • Automation
  • Macros
  • Smart Printing
  • Header Footer
  • Custom Page Layouts
  • Sharing and Protecting Workbooks
  • Advance Tools
  • Advance Vlookup & Hlookup
  • Advance Date & Time Format's
  • Advance Conditional Formatting
  • Advance Paste Special 
  • Advance Data Tools, etc.