Excel for Data Analysis
• Excel shortcuts make life easy
• Data Validation
• Data Analysis techniques
• Filter, Multi Filter, Sort, Multi Sort and Custom Sort
• Conditional Formatting
• Working with Basic Charts
• Working with Multiple Worksheets and workbooks (Links)
• Applying Security to Files, Workbooks & Worksheets

Essential Formulas for Data Analysis
• SUM, AVERAGE, COUNT, MIN, MAX for basic calculations
• AVERAGEIFS, COUNTIFS, SUMIFS for multi-condition analysis
• SUBTOTAL for filter data analysis

Logical and Lookup Functions
• Logical Functions (IF, AND, OR)
• VLOOKUP, HLOOKUP, and XLOOKUP for searching data
• INDEX and MATCH for advanced lookup scenarios

Advanced Data Analysis Techniques
• Consolidating Techniques
• Working with the Name Manager
• Advanced Charting and Graphs
• Data Analysis with What-If Analysis Tools

Data Analysis with Pivot Tables
• Creating Pivot Tables from raw data
• Summarizing data using Pivot Tables
• Grouping data by categories, dates, and values
• Using slicers to filter data interactively
• Creating dynamic Pivot Charts from Pivot Table data
• Formatting and customizing charts for presentation

Visualizing Data with Charts
• Bar, line, pie, and column charts for visualizing trends
• Adding and formatting data labels, axes, and legends
• Combination charts (e.g., bar and line charts)

Dashboards and Reporting in Excel
• Designing a dashboard layout for clear data representation
• Design Principles for Effective Dashboards
• Optimizing dashboards for sharing and collaboration
• Exporting dashboards and reports as PDFs or Excel workbooks
• Protecting data and restricting access to sensitive information
• Conditional Formatting for Data Highlighting
• Creating Sparklines for In-Line Data Trends

Data Analysis with Power Query
• Importing data from multiple sources
• Cleaning and transforming data using Power Query
• Combining data from multiple tables and sources
• Creating automated data transformations