Understanding Excel Interface: ribbon, tabs, worksheets, menu, navigation

Workbook and Worksheet management: creating, saving, opening, navigating, renaming, and organizing sheets

Data Entry: entering, editing, deleting data; autofill, series, flash fill

Cell references: absolute, relative, mixed references

Selection techniques and keyboard shortcuts

Formatting cells: font, color, alignment, borders, number/date formats

Managing rows and columns: insertion, deletion, resizing, hiding/unhiding

Worksheet/Workbook protection

Arithmetic Functions: SUM, AVERAGE, MIN, MAX, COUNT, COUNTA

Text Functions: LEFT, RIGHT, MID, LEN, TRIM, UPPER, LOWER, PROPER, CONCATENATE, TEXTJOIN

Date and Time Functions: TODAY, NOW, DATE, DAY, MONTH, YEAR, WEEKDAY, EOMONTH

Logical Functions: IF, AND, OR, NOT, IFERROR

Conditional Functions: SUMIF(S), COUNTIF(S), AVERAGEIF(S)

Lookup Functions: VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP (latest versions)

Sorting and Filtering: basic, advanced, by color/value

Data Validation: dropdowns, lists, custom rules

Removing duplicates

Data cleaning techniques: text-to-columns, find & replace, data parsing

Advanced Paste Special options

Creating and Formatting Charts: Bar, Column, Pie, Line, Area, Scatter

Combo Charts & Secondary Axis

New Excel chart types: Sunburst, Waterfall, Treemap, Funnel (Excel 2016+)

Sparklines for micro visualizations

Conditional formatting: rules, icon sets, data bars, color scales

Creating PivotTables and PivotCharts

Grouping, sorting, and filtering data within PivotTables

Value Field Settings, Calculated Fields and Items

Using Slicers and Timelines for interactive filtering

Connecting multiple tables

Data Tools: Text-to-Columns, Group/Ungroup, Consolidate, Remove Duplicates

What-If Analysis: Goal Seek, Scenario Manager, Data Tables (one/two variable)

Forecast Sheet and Trend Analysis

Using Form Controls (Slicers, Drop-downs)

Array Formulas and Dynamic Arrays: SEQUENCE, SORT, FILTER, UNIQUE

Advanced Lookup: XLOOKUP, XMATCH, INDEX/MATCH for two-way lookups

INDIRECT, OFFSET, ADDRESS for dynamic referencing

Financial Functions: NPV, IRR, PMT, FV, XIRR

Statistical Functions: MEDIAN, MODE, STDEV, VAR, RANK

SUMPRODUCT and advanced aggregations

Introduction to Power Query: importing, transforming, and cleaning data from various sources

Combining datasets (Append, Merge)

Creating and managing Relationships (Data Models)

Working with Power Pivot (Calculated Columns, DAX formulas)

Interactive Dashboards with slicers, form controls, dynamic charts

Specialized charts: Gantt, Waterfall, Tornado, Box & Whisker

Creating custom templates for reporting

Using camera tool for visual snapshots

Advanced Scenario Manager

Monte Carlo Simulation basics (using functions and data tables)

Sensitivity tables and tornado charts

Worksheet and workbook protection, cell locking

Track changes, comments, version history

Data validation security with custom rules

Exporting reports: printing, PDF, PowerPoint

Connecting Excel to SQL databases and web queries

Importing/exporting to/from CSV, XML, and other formats

Integrating with Power BI and other analytics tools

Building full dashboards (end-to-end projects)

Data reconciliation: merging and validating multiple data sources

Real-world scenarios: Sales/Financial/HR analytics

Keyboard shortcuts and workflow automation advice

Troubleshooting formulas (error-checking, auditing tools)

Documentation, annotation, report-writing tips