- Courses
 - Excel 2013 Basic
 
            4 hour course
Excel 2013 Basic
4.9 out of 5 on G2
Try this course with a Free Trial
Learn to:
- Build & edit spreadsheets
 - Calculate with formulas
 - Add eye-catching formatting
 - Organize and manage workbooks
 
| Skill | Pre-assess | Lesson | Post-assess | Learning mode | 
|---|
| 
                                 
                                        Excel 2013 Basic Outline
                                                                             
                                 | 
                            ||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode | 
|---|---|---|---|---|
| Getting Started | 
                                             
                                                
                                                Verified Learning
                                             
                                         | 
                                    |||
| 
                    Understand the Excel Screen
                                                     Understand the Excel Screen  | 
    Not Started | Not Started | Not Started | |
| 
                    Create Workbooks
                                                     How to create blank & template-based workbooks in Excel  | 
    Not Started | Not Started | Not Started | |
| 
                    Navigate Worksheets
                                                     How to Navigate Worksheets in Excel  | 
    Not Started | Not Started | Not Started | |
| 
                    Open Workbooks
                                                     How to Open Workbooks in Excel  | 
    Not Started | Not Started | Not Started | |
| 
                    Save Workbooks
                                                     How to Save Workbooks in Excel  | 
    Not Started | Not Started | Not Started | |
| 
                    AutoRecover
                                                     How to AutoRecover Excel Files  | 
    Not Started | Not Started | Not Started | |
| 
                    The Quick Access Toolbar
                                                     How to Use The Quick Access Toolbar in Excel  | 
    Not Started | Not Started | Not Started | |
| 
                    Print
                                                     How to Print in Excel  | 
    Not Started | Not Started | Not Started | |
| 
                    Share a Workbook
                                                     How to Share Workbooks in Excel  | 
    Not Started | Not Started | Not Started | |
| 
                    Help
                                                     How to Get Help in Excel  | 
    Not Started | Not Started | Not Started | |
| 
                    Close and Exit
                                                     How to Close and Exit from Excel  | 
    Not Started | Not Started | Not Started | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode | 
|---|---|---|---|---|
| Edit a Workbook | 
                                             
                                                
                                                Verified Learning
                                             
                                         | 
                                    |||
| 
                                                                                                    Select Cells and Ranges
                                                                                                                                                     How to Select Cells and Ranges in Excel  | Account Required | |||
| 
                                                                                                    Edit Cell Data
                                                                                                                                                     How to Edit Cell Data in Excel  | ||||
| 
                                                                                                    Cut, Copy, and Paste
                                                                                                                                                     How to Cut, Copy, and Paste in Excel  | ||||
| 
                                                                                                    Undo, Redo, Repeat
                                                                                                                                                     How to Use Undo, Redo, Repeat Commands in Excel  | ||||
| 
                                                                                                    More Pasting Options
                                                                                                                                                     How to Use Special Paste Options in Excel  | ||||
| 
                                                                                                    Insert and Move Cells
                                                                                                                                                     How to Insert and Move Cells in Excel  | ||||
| 
                                                                                                    Delete Cells
                                                                                                                                                     How to Delete Cells in Excel  | ||||
| 
                                                                                                    Check Spelling
                                                                                                                                                     How to Spell Check in Excel & avoid errors  | ||||
| 
                                                                                                    Find and Replace Text
                                                                                                                                                     How to Use Find and Replace in Excel  | ||||
| 
                                                                                                    Hide Columns and Rows
                                                                                                                                                     How to Hide Columns and Rows in Excel  | ||||
| 
                                                                                                    Workbook Properties
                                                                                                                                                     How to View and Edit Document Properties in Excel  | ||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode | 
|---|---|---|---|---|
| Basic Formulas | 
                                             
                                                
                                                Verified Learning
                                             
                                         | 
                                    |||
| 
                                                                                                    Formula Basics
                                                                                                                                                     How to Create Basic Formulas in Excel  | ||||
| 
                                                                                                    AutoFill
                                                                                                                                                     How to Use AutoFill in Excel  | ||||
| 
                                                                                                    Sums and Averages
                                                                                                                                                     How to Use Sum and Average Formulas in Excel  | ||||
| 
                                                                                                    MIN and MAX
                                                                                                                                                     How to Use MIN and MAX Functions in Microsoft Excel  | ||||
| 
                                                                                                    COUNT
                                                                                                                                                     How to Use the COUNT Function in Excel  | ||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode | 
|---|---|---|---|---|
| Basic Formatting | 
                                             
                                                
                                                Verified Learning
                                             
                                         | 
                                    |||
| 
                                                                                                    Format Text
                                                                                                                                                     How to Apply Formatting to Text in Excel  | ||||
| 
                                                                                                    Align and Merge Cells
                                                                                                                                                     How to align and merge cells in Excel  | ||||
| 
                                                                                                    Format Numbers and Dates
                                                                                                                                                     How to Format Numbers and Dates in Excel  | ||||
| 
                                                                                                    Borders and Background Colors
                                                                                                                                                     How to Add Cell Borders and Background Colors in Excel  | ||||
| 
                                                                                                    Copy Formatting
                                                                                                                                                     How to Copy Formatting in Excel  | ||||
| 
                                                                                                    Row Heights and Column Widths
                                                                                                                                                     How to Adjust Row Heights and Column Widths in Excel  | ||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode | 
|---|---|---|---|---|
| Insert Objects | 
                                             
                                                
                                                Verified Learning
                                             
                                         | 
                                    |||
| 
                                                                                                    Images
                                                                                                                                                     How to Insert Images in Excel  | ||||
| 
                                                                                                    Shapes
                                                                                                                                                     How to Insert and Format Shapes in Excel  | ||||
| 
                                                                                                    Hyperlinks
                                                                                                                                                     How to Insert Hyperlinks in Excel  | ||||
| 
                                                                                                    Object Properties and Alt Text
                                                                                                                                                     How to Adjust Object Properties and Alt Text in Excel  | ||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode | 
|---|---|---|---|---|
| View and Manage Worksheets | 
                                             
                                                
                                                Verified Learning
                                             
                                         | 
                                    |||
| 
                                                                                                    View Worksheets
                                                                                                                                                     How to Change Worksheet Views in Excel  | ||||
| 
                                                                                                    Multiple Windows
                                                                                                                                                     How to Work with Multiple Windows in Excel  | ||||
| 
                                                                                                    Move and Copy Worksheets
                                                                                                                                                     How to Move and Copy Worksheets in Excel  | ||||
| 
                                                                                                    Insert, Rename, and Delete Worksheets
                                                                                                                                                     How to Insert, Rename, and Delete Worksheets in Excel  | ||||
| 
                                                                                                    Freeze Rows and Columns
                                                                                                                                                     How to Freeze and Unfreeze Rows and Columns in Excel  | ||||
| 
                                                                                                    Hide Worksheets and Gridlines
                                                                                                                                                     How to Hide Worksheets and Gridlines in Excel  | ||||