Excel Interface: Understanding the Ribbon, workbook, worksheets, and cell structure.
Basic Navigation: Moving around the worksheet, selecting cells, rows, and columns.
Creating a Workbook: Opening, saving, and closing workbooks.
Entering Data: Typing text, numbers, and dates into cells.
Cell Formatting: Changing font style, size, color, and cell alignment.
Number Formatting: Formatting numbers, currency, percentages, and dates.
Using the Format Painter: Copying formatting from one cell to another.
Borders and Shading: Adding borders and background colors to cells.
Simple Formulas: Using basic arithmetic operators (+, -, *, /) to perform calculations.
AutoSum: Quickly summing a range of cells.
Basic Functions: Using SUM, AVERAGE, MIN, MAX, and COUNT.
Cell Referencing: Understanding relative, absolute, and mixed references.
Adding and Deleting Sheets: Inserting, deleting, renaming, and navigating between worksheets.
Copying and Moving Sheets: Duplicating and repositioning worksheets within a workbook.
Grouping Worksheets: Editing multiple worksheets simultaneously.
Creating Charts: Inserting and modifying basic charts (Column, Line, Pie, Bar).
Chart Elements: Adding titles, labels, and legends.
Chart Formatting: Changing the chart style and color scheme.
Page Setup: Setting margins, orientation, and paper size.
Headers and Footers: Adding and customizing headers and footers.
Print Area: Defining and adjusting the print area.
Print Preview and Print: Previewing and printing worksheets.