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
- User Interface
- Entering Data
- Formatting Text & Data
- Conditional Formatting
- Validations
- Pick from Drop-Down List
- Excel Slicer
- Smart Lookup
- Zooming and Zoom Selection
- Page Layouts
- Financial Formulas
- Informational Formulas with Lookup
- Wildcard Search
- Arrays & Index Match
- Indirect Functions
- Pivot Tables
- Pivot Charts
- Data Modelling
- Power Pivot
- What if Analysis,
- Macros
- Smart Printing
- Header Footer
- Custom Page Layouts
- Sharing and Protecting Workbooks
- Advance Vlookup & Hlookup
- Advance Date & Time Format’s
- Advance Conditional Formatting
- Advance Paste Special
- Advance Data Tools, etc.
