Advanced Excel Course Content Advanced Excel Course - Overview of the Basics of Excel~ Customizing common options in Excel

~ Absolute and relative cells

~ Protecting and un-protecting worksheets and cells Advanced Excel Course - Working with Functions~ Writing conditional expressions (using IF)

~ Using logical functions (AND, OR, NOT)

~ Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)

~ VlookUP with Exact Match, Approximate Match

~ Nested VlookUP with Exact Match

~ VlookUP with Tables, Dynamic Ranges

~ Nested VlookUP with Exact Match

~ Using VLookUP to consolidate Data from Multiple Sheets Advanced Excel Course - Data Validations~ 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 Advanced Excel Course - Working with Templates~ Designing the structure of a template

~ Using templates for standardization of worksheets Advanced Excel Course - Sorting and Filtering Data~ Sorting tables

~ Using multiple-level sorting

~ Using custom sorting

~ Filtering data for selected view (AutoFilter)

~ Using advanced filter options Advanced Excel Course - Working with Reports~ Creating subtotals

~ Multiple-level subtotals

~ Creating Pivot tables

~ 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

~ Show Value As ( % of Row, % of Column, Running Total, Compare with Specific Field)

~ Viewing Subtotal under Pivot

~ Creating Slicers ( Version 2010 & Above) Advanced Excel Course - More Functions~ Date and time functions

~ Text functions

~ Database functions

~ Power Functions (CountIf, CountIFS, SumIF, SumIfS) Advanced Excel Course - Formatting~ Using auto formatting option for worksheets

~ Using conditional formatting option for rows, columns and cells  Advanced Excel Course - Macros~ Relative & Absolute Macros

~ Editing Macro's  Advanced Excel Course - WhatIf Analysis~ Goal Seek

~ Data Tables

~ Scenario Manager Advanced Excel Course - Charts~ Using Charts

~ Formatting Charts 

~ Using 3D Graphs 

~ Using Bar and Line Chart together 

~ Using Secondary Axis in Graphs 

~ Sharing Charts with PowerPoint / MS Word, Dynamically 

~ (Data Modified in Excel, Chart would automatically get updated) Advanced Excel Course - New Features Of Excel~ Sparklines, Inline Charts, data Charts

~ Overview of all the new features Advanced Excel Course - Final Assignment~ The Final Assignment would test contains questions to be solved at the end of the Course