Pro in Excel gives professionals an much needed advantage over others in worklife. Most of our M.I.S and Data Analysis work take place in excel. 

So i Have made a course on Excel covering all areas of Excel to make you a pro in Excel

What’s covered in the Advanced Excel course…

• Beginner Skills like Best usage of Shortcuts, Formatting tricks, cell referencing; Simple problem solving using Sort and Filter basics and Essential Business Math
• Intermediate Skills like Build simple models using Combo Formulas, 3-dimensional lookups, Date formulas; Error-handling using data validation, auditing, track variables to to avoid humiliation;  Indepth logical understanding of Data Cleaning Techniques like Go-to-Special, Text formulas, Flashfill;  and Summarize your data with Pivot Tables Slicers, Sparklines, Calcs, Differential Criteria Filters
• Advanced Skills like Modelling Uncertainty using Scenario, Sensitivity Analysis, Data Tables, Goal Seek;  Using Charts and Graphs and Printing techniques for Slide-ready output;  Use of Get Pivotdata, Reverse lookups, conditional calculations to make Dynamic Dashboards and Managing Data Security using Passwords & sheet protection

If the answer to any one of the questions is YES, you may want to try Microsoft Word Tutorials.

Enroll Now & Get 50% Off

This course is for you if…

✓ You use ERP downloaded Excel files as a base to generate custom MIS reports

✓ You want to reduce your TAT significantly (turnaround time)

✓ You want to prepare Financial Models with combo-logical statements

✓ You prepare Management Reporting dashboards

✓ You are involved in Performing CAAT & Forensic Audit techniques