Smart Office 101

Excel Basic to Advanced Course Outline

I. Excel Fundamentals

1. Understand the Excel Screen
2. Create Workbooks
3. Navigate Worksheets
4. Open Workbooks
5. Save Workbooks
6. The Quick Access Toolbar
7. Print
8. Close and Exit

II. Edit a Workbook

1. Select Cells and Ranges
2. Edit Cell Data
3. Cut, Copy, and Paste
4. Undo, Redo, Repeat
5. More Pasting Options
6. Insert and Move Cells
7. Delete Cells
8. Check Spelling
9. Find and Replace Text
10. Hide Columns and Rows

III. Basic Formulas

1. Formula Basics
2. AutoFill
3. Sums and Averages
4. MIN and MAX
5. COUNT

IV. Basic Formatting

1. Format Text
2. Align and Merge Cells
3. Format Numbers and Dates
4. Borders and Background Colors
5. Copy Formatting
6. Row Heights and Column Widths

V. Insert Objects

1. Images
2. Shapes
3. Hyperlinks
4. Object Properties and Alt Text

VI. Manage Worksheets

1. How to Zoom in Excel
2. Open Same File in Two Windows
3. Delete a Sheet
4. Copy a Sheet
5. Freeze Rows and Columns
6. Hide Worksheets and Gridlines

VII. Charts

1. Create Charts
2. Move and Resize
3. Chart Types
4. Layout and Style
5. Titles and Legends
6. Gridlines, Labels, Data Tables

VIII. Print and Distribute

1. Page Size and Scale
2. Print Area and Page Breaks
3. Print Gridlines
4. Headers and Footers
5. Margins and Orientation

IX. Intermediate Formulas

1. Reference Worksheets
2. Named Ranges
3. CONCAT Function
4. Show Formulas
5. Date Functions