Excel Contents

Excel Basics Module 2

1. Cell Basics
2. Modifying Cells/Rows/Columns
3. Basic Cell formatting
4. Cell Number Formats
5. Cut, Copy & Paste
6. Format Painter
7. Personalizing Worksheets
8. Multiple Worksheets
9. Find & Replace
10. Sheet Protection
11. Printing and Page Layout
12. Assignment

Formulas and functions Module 3

1. Introduction
2. Basic Formulas
3. Advanced Formulas
4. Cell References
5. Excel Functions
6. Date/Time Functions
7. Text Functions
8. Financial Functions
9. Logical Functions
10. Lookup Functions
11. Data Validation
12. Troubleshooting
13. Assignment

Working with Data Module 4

1. Working with data
2. Freezing Options
3. Data Sorting
4. Data filtering
5. Tables
6. Charts
7. Assignment

Advance Concepts

1. Conditional Formatting
2. What-if Analysis
3. Pivot Tables

Integrating AI in Excel

1. Built-in Excel AI tools
2. Getting Started with prompting