We share best use of Excel.Program is based on real scenario problem.Entire program is full of illustration and case study. Practical experience of Program Director will help to have a practical view of each function.Program is spread over couple of weekends that give time to practice and raise question in subsequent sessions. Excel Courses Warm-up Essential shortcuts AutoFill options Paste Special (Value, Transpose) Absolute Relative referencing ($) ROUND() Data Analytics Sort Filter Using SUBTOTAL() with filtered data SUMIFS(), COUNTIFS() Pivot Table for multi-variable analysis Computations %, Sum, Max, Min, Average, Count Grouping (Clustering) Generating multiple reports Data Lookup VLOOKUP() a practical perspective VLOOKUP() with MATCH() Logical Statements IF(), Nested IFs, AND(), OR() ISNUMBER(), ISTEXT(), ISBLANK(), ISERROR() Data Cleaning I LEFT(), RIGHT(), MID() LEN() UPPER(), PROPER(), LOWER() TRIM(), VALUE() CONCATENATE(), Data Cleaning II Find Replace (using wildcard character - Asterisk * ) Go To (Special) Text-to-Columns (incl. advanced tricks) Remove Duplicates Working with Dates Date correction techniques DAY(), MONTH(), YEAR() EDATE(), EOMONTH() TODAY() MIS reporting Automatic row-wise Subtotal Conditional Formatting (Blanks, Errors, Cell Values, Duplicates) File Password Select Dashboard Techniques Activate-Deactivate Gridlines Data Validation (list) Cell-Range Naming Grouping Hyper linking Freeze-Unfreeze panes Hide-Unhide Columns Rows Data Lookup INDEX() and 2 MATCH() MIS reporting Formula based Conditional Formatting 3-D Data Consolidation What-IF Analysis Data Tables, Goal Seek Form Controls - Spin Button Scroll Bar Macros Concept; Macros Recorder Record Run Special Charts (with Videos) Thermometer chart Two-axis chart Trend line chart Exploded Pie-chart Select Formulas Techniques IFERROR() SEARCH(), SUBSTITUTE() SUMPRODUCT() Cell Protection