Module 01: Summing Techniques
Doing SUM through impressive shortcut, 3D Summing,Data Consolidation, QAT (Quick Analysis Tool)
Module 02: Power Functions / Formulas
SumIF, SumIFS, Average, AverageIFS, Count, CountA, CountIF, CountIFS, Creating Dynamic Reports using Power Functions, ARRAY Formula
Module 03: Formula Referencing
Absolute and Relative Referencing, Problems with Relative Formulas, Creating Absolute References
Module 04: Text Options
Text to Columns, Using Left, Right & Upper Formula, Using TEXT Formula
Module 05: Conditional Formatting
Formatting Cells Containing Values, Clearing Conditional Formatting, More Cell Formatting Options, Top & Bottom Ten Items, Working with Data Bars, Working with Color Scales, Working with Icon Sets
Module 06: Dynamic Table
Converting data into Table, Automated calculation in Table, Converting Table to normal range, Multiple Filters in Table
Module 07: Data Validation
Drop-down List, Restricted Values in a Cell, Error messages in case of wrong entry, Dependent List
Module 08: Database Formulas
DSum, DAverage, DCount, DCountA, DMax, DMin, Creating Dynamic Reports using Database Formulas
Module 09: Advance Filter & Filter
Understanding Filtering, Understanding ADVANCE Filter, Applying and Using a Filter, Clearing a Filter, Multiple Value Filters, Using Wildcards
Module 10: Subtotal
Subtotal Formula, Subtotal Function, Group / UnGroup (Rows & Columns)
Module 11: Sorting
Performing an Alphabetical Sort, Performing a Numerical Sort, Performing Custom Sort, Sorting On More Than One Column, Sorting By Vertically & Horizontally
Module 12: Lookup References
Using Vlookup, Using Hlookup, Using IFerror with Vlookup, Using Multiple Criteria in Vlookup, Using Index, Match
Module 13: Macros
Recording & Running Macros, Adding button to run the macro, Assigning shortcut to macro, Deleting Macros, Using Shapes option in Macros, SPELLNUMBER for Numeric into Text - VBA, SUM if BOLD values - VBA
Module 14: PivotTable
Understanding PivotTable, Dropping Fields into PivotTable, Filtering a PivotTable Report, Clearing a Report Filter, Calculations in PivotTable, Formatting a PivotTable Report, Using SLICERS for Dynamic Reporting, Adding TIMELINE
Module 15: Charts & Graphs
Creating Chart, Best Chart according to your Data, Adding a Linked Chart Title, Adding Axes Titles, Positioning the Legend, Showing Data Labels, Modifying the Axes, Showing Gridlines, Creating & Customizing SPARKLIN
