Advanced Excel Topics Covered
| 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 |