Introduction to Excel Interface, Ribbons, and Quick Access Toolbar.

Workbook vs Worksheet management and navigating large datasets.

Basic Math operations, Cell referencing (Absolute & Relative).

Essential Keyboard Shortcuts to double your working speed.

Page Setup, Print Scaling, and fitting large data on a single A4 page.

Advanced Cell Formatting, Number formats, and Custom alignments.

Conditional Formatting to highlight duplicates, targets, and errors.

Data Cleaning Tools: Text to Columns, Flash Fill, and Remove Duplicates.

Data Validation to create drop-down lists and restrict wrong entries.

Securing Data: Password protecting sheets and specific cells.

Logical Functions: IF, nested IF, AND, OR for decision making.

Lookup Functions: VLOOKUP, HLOOKUP, and INDEX-MATCH secrets.

Math & Statistics: SUMIFS, COUNTIFS, AVERAGEIFS for deep analysis.

Text Functions: LEFT, RIGHT, MID, CONCATENATE, and LEN.

Date & Time Functions: TODAY, NOW, MONTH, and calculating differences.

Introduction to Pivot Tables and summarizing massive data in seconds.

Formatting Pivot Tables and updating data sources dynamically.

Using Slicers and Timelines for interactive and visual filtering.

Creating Calculated Fields inside Pivot Tables.

Designing Pivot Charts for instant graphical reporting.

Building real-world Corporate Salary Slips and Attendance Trackers.

Creating automated Inventory Management and Billing sheets.

Introduction to designing basic Interactive Dashboards.

Google Sheets Basics: Real-time team collaboration and sharing.

Professional data presentation for boss and management.