Excel Essentials

Module 1: Orientation and clean worksheets

• Workbooks vs worksheets, ribbon, status bar, and quick access toolbar
• Selecting, moving, copying, filling, and undo or redo
• Column widths, row heights, wrap text, merge carefully, and cell styles
• Number formats for text, numbers, dates, and percentages

Module 2: First formulas that do not break

• Formula basics with equals, references, and order of operations
• Relative vs absolute references with the F4 key
• SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, and simple percentages
• IF for simple decisions and IFERROR for friendly results

Module 3: Organize data and explore

• Turn a range into an Excel Table for safer sorting and filtering
• Sort by multiple keys and filter by values, text, and dates
• Quick totals with AutoSum and status bar insights
• Create a basic column or line chart and format labels and axes

Module 4: Simple report and sharing basics

• Build a one page summary sheet with headings and consistent layout
• Page setup with margins, orientation, print area, and scaling
• Freeze panes, split view, and basic protection for inputs
• Save, version tips, and export to PDF for easy sharing