Unleash the Power of MS Excel to master all the essential functions, tools and features taking
your
efficiency from Basic to Advance level.
Leverage tools and functions to format and prepare data in MS Excel
Represent data by highlighting trends using Pivot Tables
Use data security features to protect and distribute MS Excel files
Construct interactive power dashboards by applying business intelligence tools to make data-driven decisions
Present dashboards with impact using MS PowerPoint Presentation
1.1 Overview (Interface/Tools/Options)
1.2 Security (Editing/Restricted sharing/ Book-Sheet-Cell Production)
1.3 Tips & Tricks (Short Keys/ Techniques)
2.1 Cleaning Formulas (Text/Trim/IsText/Right/Left/Mid/Upper/Lower/Proper/Len/Clean/Find)
2.2 Conditional Formatting
2.3 Subtotal/Aggregate
2.3 Flash Fill/Fill Series
2.4 Text to Column (Fixed/Delimated)
2.5 Remove Duplicate (By Conditional Formatting)
2.6 Tips & Tricks (Short Keys/ Techniques)
3.1 Data Validation
3.2 Group/UnGroup Data
3.3 Conditional Formatting (Simple/Advance)
3.4 Data Consolidations
3.5 Filtering (Simple/Advance)
3.6 Tips & Tricks (Short Keys/ Techniques)
4.1 Time Intelligence (Dateif/Now/Today/Workday/Networkdays
4.2 Logical Operation Functions (IF/IFS/OR/NOT/AND/SUMIFS/COUNTIFS/AVGIFS/MAXIFS/MINIFS/SWITCH)
4.3 Look-Ups (Vlook-up/Hlook-up/Index/Match)
4.4 Troubleshoot Formulas
4.5 Tips & Tricks (Short Keys/ Techniques)
5.1 What if Analysis (All 3 functions)
6.1 Power Query - ETL (Extract/Transform/Load) Automate Daily Task
6.2 Table/pivot Tables/Power Tables
6.3 Tips & Tricks (Short Keys/ Techniques)
7.1 Theory Discussion on Types of Visuals (KPS's Card/Chart's/Visuals/Slicer/Timeliner)
7.2 Create Automated System
7.3 Create Automated Dashboards
7.3 Tips & Tricks (Shortkeys/Techniques)
Experienced business and data analyst consultant, associated with many industries like FMCG, Retail, Textile, HR, IT, Telecommunication, Banking, and NGO
He is currently associated with Hilal Food Group Pvt Ltd, in the capacity of Associate Manager – Business Intelligence, further also serving as a seasonal consultant in Arthur Lawrence Group LLC (USA) as a Business Analyst.