Advanced Excel Course

Advanced Excel refers to high proficiency in using Microsoft Excel, focusing on sophisticated features and functions beyond basic spreadsheet operations. Advanced Excel skills are crucial for data analysis, financial modeling, reporting, and decision-making in various business and professional contexts.

Content:

• WORKING WITH FUNCTIONS
• Writing conditional expressions (using IF)
• Using logical functions (AND, OR, NOT)
• Using lookup and reference functions (LOOKUP, HOOKUP, 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
• 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 the formula for a cell
• WORKING WITH TEMPLATES
• SORTING AND FILTERING DATA
• Sorting tables, Using multiple-level sorting, Using custom sorting
• Filtering data for selected view (AutoFilter), Using advanced filter options
• WORKING WITH REPORTS
• Creating subtotals, Multiple-level subtotals
• Creating Pivot tables, Formatting, and customizing 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
• MORE FUNCTIONS
• Date and time functions
• Text functions
• Database functions
• Power Functions (CountIf, CountIFS, SumIF, SumIfS)
• FORMATTING
• Using the auto-formatting option for worksheets
• Using conditional formatting option for rows, columns, and cells
• WHAT-IF ANALYSIS
• Goal Seek
• Data Tables
• Scenario Manager
• CHARTS
• Using Charts, Formatting Charts, Using 3D Graphs
• Using Bar and Line Chart together, Using Secondary Axes in Graphs
• Sharing Charts with PowerPoint / MS Word, Dynamically
• (Data Modified in Excel, Chart would automatically get updated)