Introduction to Microsoft Excel

• Understanding the Excel Interface

• Ribbon, Tabs, and Toolbars

• Creating, Opening, and Saving Workbooks

• Understanding Rows, Columns, and Cells

• Entering and Editing Data

• Workbook Navigation Techniques

Basic Formatting and Worksheet Management

• Formatting Text and Numbers

• Adjusting Row Height and Column Width

• Cell Alignment and Text Wrapping

• Borders, Colors, and Styles

• Inserting and Deleting Rows and Columns

• Renaming and Moving Worksheets

Basic Formulas and Functions

• Understanding Formulas

• Using Mathematical Operators

• Using AutoSum

• Working with SUM, AVERAGE, COUNT, MIN, and MAX Functions

• Relative and Absolute Cell References

Working with Data

• Sorting Data

• Filtering Data

• Using Find and Replace

• Using Text to Columns

• Removing Duplicate Data

• Basic Data Validation

Intermediate Formatting and Productivity Tools

• Conditional Formatting

• Using Format Painter

• Using Flash Fill

• Custom Number Formats

• Freeze Panes

• Page Setup and Printing

Intermediate Functions

• Logical Functions: IF, AND, OR, IFERROR

• Text Functions: LEFT, RIGHT, MID, CONCAT

• Date Functions: TODAY, NOW, and DATEDIF

• Creating Automated Calculations

Lookup Functions and Data Analysis

• Using VLOOKUP

• Introduction to XLOOKUP

• Using INDEX and MATCH

• Creating Named Ranges

• Introduction to PivotTables

Charts and Data Visualization

• Creating Column, Bar, Pie, and Line Charts

• Customizing Charts

• Using Sparklines

• Creating Simple Dashboards

Workbook Protection and Collaboration

• Protecting Worksheets and Workbooks

• Sharing Excel Files

• Using Comments and Notes

• Co-authoring Basics

• Exporting Workbooks to PDF

Final Project and Course Review

• Creating a Complete Excel Report

• Using Formulas, Charts, and PivotTables Together

• Review of Key Excel Skills

• Next Steps for Advanced Excel Learning