| # | Topic |
|---|---|
| 1 | Introduction to Excel An overview of the Excel interface, including navigating workbooks and worksheets, using the ribbon, and customizing options. |
| 2 | Entering and Editing Data Techniques for entering data accurately and efficiently, including using AutoFill and AutoComplete. Learn how to edit data within cells and navigate between cells. |
| 3 | Formatting Cells How to format cells, including changing fonts, styles, and colors, as well as adjusting alignment and applying borders and shading. |
| 4 | Creating Formulas and Functions Understanding basic formulas, such as SUM, AVERAGE, and COUNT, and using functions to perform calculations in Excel. |
| 5 | Working with Rows and Columns Manipulating rows and columns, including inserting, deleting, hiding, and resizing them to organize data effectively. |
| 6 | Sorting and Filtering Data Sorting data alphabetically or numerically, and filtering data to display only specific information based on criteria. |
| 7 | Charts and Graphs Creating visually appealing charts and graphs to represent data in a meaningful way, including bar graphs, pie charts, and line graphs. |
| 8 | Conditional Formatting Applying conditional formatting to highlight important data trends, comparisons, or outliers within a range of cells. |
| 9 | Data Validation Setting rules and restrictions on data entry to ensure accuracy and consistency in spreadsheets. |
| 10 | PivotTables Using PivotTables to summarize, analyze, and present data in a dynamic and interactive format. |