### Basic - Working with Functions – Formula’s

###### Building a strong foundation
• Introduction about Excel & why we are using excel
• What is function and formula
• Sorting tables
• Using multiple-level sorting
• Using custom sorting
• Filtering data for selected view (AutoFilter)
• Writing conditional expressions (using IF)
• Using logical functions (AND, OR, NOT)
• Using lookup and reference functions (VLOOKUP, HLOOKUP)
• Specifying a valid range of values for a cell
• Specifying a list of valid values for a cell
• Specifying custom validations based on formula for a cell
• Using auto formatting option for worksheets
• Using conditional formatting option for rows, columns and cells.
• Using Charts
• Formatting Charts
• Using 3D Graphs
• Date and time functions
• Text functions
• Creating Pivot tables
• How to create report using with formulas
• Create Report using with multiple function and formulas

### Advance - Working with Reports along with formulas and Macro

###### The road to deep drive
• Introduction about excel macro vba
• Creating subtotals
• Formatting and customizing Pivot tables
• Using advanced options of Pivot tables
• Pivot charts
• Consolidating data from multiple sheets and files using Pivot tables
• Using external data sources
• Using data consolidation feature to consolidate data
• Viewing Subtotal under Pivot
• Creating Slicers ( Version 2010 & Above)
• Power Functions (CountIf, CountIFS, SumIF, SumIfS)
• Using Bar and Line Chart together
• Using Secondary Axis in Graphs
• Data Modified in Excel, Chart would automatically get updated
• VlookUP with Exact Match, Approximate Match
• Nested VlookUP with Exact Match
• VlookUP with Tables, Dynamic Ranges
• Nested VlookUP with Exact Match
• Absolute and relative cells
• Protecting and un-protecting worksheets and cells
• The Final Assignment would test contains questions to be solved at the end of the Course