Learn to:
- Build & edit spreadsheets
- Calculate with formulas
- Add eye-catching formatting
- Organize and manage workbooks
Features:
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|
Excel 2019 Basic Outline
|
||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Excel Fundamentals |
Verified Learning
|
|||
|
Understand the Excel Screen
Learn How to Use and Customize the Excel Ribbon to Access Features and Improve Productivity |
Not Started | Not Started | Not Started | |
|
Create Workbooks
Learn How to Start a New Excel Workbook and Build Spreadsheets for Data Entry and Analysis |
Not Started | Not Started | Not Started | |
|
Navigate Worksheets
Learn How to Switch Between Worksheets in Excel Using Tabs, Shortcuts, and Navigation Tools Efficiently |
Not Started | Not Started | Not Started | |
|
Open Workbooks
Learn How to Access, Browse, and Manage Excel Workbooks for Faster File Opening and Organization |
Not Started | Not Started | Not Started | |
|
Save Workbooks
Learn How to Save Excel Workbooks Properly to Prevent Data Loss and Ensure File Compatibility |
Not Started | Not Started | Not Started | |
|
AutoRecover
Recover Unsaved or Lost Excel Files Using AutoRecover and Backup Options to Restore Your Work |
Not Started | Not Started | Not Started | |
|
The Quick Access Toolbar
Customize the Quick Access Toolbar in Excel to Add Shortcuts and Boost Your Productivity |
Not Started | Not Started | Not Started | |
|
Print
Set and Customize the Print Area in Excel to Print Specific Cells, Ranges, or Tables Accurately |
Not Started | Not Started | Not Started | |
|
Help
Find the Best Ways to Get Help in Excel Using Built-In Tools, Tips, and Online Support Resources |
Not Started | Not Started | Not Started | |
|
Close and Exit
Automate Workbook Management with VBA in Excel to Close Files Safely and Streamline Your Tasks |
Not Started | Not Started | Not Started | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Edit a Workbook |
Verified Learning
|
|||
|
Select Cells and Ranges
Discover Easy Ways to Highlight, Group, and Edit Multiple Cells in Excel for Better Data Control | Account Required | |||
|
Edit Cell Data
Learn How to Edit, Update, and Modify Cell Data in Excel Quickly and Accurately | ||||
|
Cut, Copy, and Paste
Master Cutting, Copying, and Pasting Cells in Excel to Move and Organize Data Efficiently | ||||
|
Undo, Redo, Repeat
Easily Undo or Redo Changes in Excel Using Keyboard Shortcuts and Toolbar Options | ||||
|
More Pasting Options
Learn How to Use Paste Special in Excel to Copy Values, Formats, and Formulas with Precision | ||||
|
Insert and Move Cells
Easily Move, Drag, and Reposition Cells in Excel to Keep Your Data Organized and Structured | ||||
|
Delete Cells
Learn How to Delete Cells, Rows, and Columns in Excel Without Disrupting Your Data Layout | ||||
|
Check Spelling
Learn How to Use Spell Check in Excel to Find and Correct Spelling Errors in Your Worksheets | ||||
|
Find and Replace Text
Use Find and Replace in Excel to Quickly Locate, Edit, and Update Data Across Your Worksheets | ||||
|
Hide Columns and Rows
Learn How to Hide and Unhide Columns in Excel to Organize Data and Keep Your Worksheets Clean | ||||
|
Document Properties
Learn How to View and Edit Document Properties in Excel to Manage File Details and Metadata Effectively | ||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Basic Formulas |
Verified Learning
|
|||
|
Formula Basics
Master Essential Excel Formulas to Perform Calculations, Automate Tasks, and Analyze Data Efficiently | ||||
|
AutoFill
Learn How to Use Excel AutoFill to Quickly Copy Formulas, Patterns, and Data Across Multiple Cells | ||||
|
Sums and Averages
Use the SUM Formula in Excel to Add Values Efficiently Across Rows, Columns, and Data Ranges | ||||
|
MIN and MAX
Use Excel MAX and MIN Functions to Quickly Find the Largest and Smallest Numbers in Your Dataset | ||||
|
COUNT
Learn How to Use the COUNT Function in Excel to Count Numbers, Cells, and Data Ranges Accurately | ||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Basic Formatting |
Verified Learning
|
|||
|
Format Text
Learn How to Format Text in Excel to Improve Readability and Create Professional-Looking Spreadsheets | ||||
|
Align and Merge Cells
Combine and Center Data in Excel by Merging Cells for Cleaner, More Organized Spreadsheets | ||||
|
Format Numbers and Dates
Learn How to Change and Customize Date Formats in Excel to Display Dates the Way You Need | ||||
|
Borders and Background Colors
Learn How to Add and Customize Borders in Excel to Organize Data and Improve Spreadsheet Readability | ||||
|
Copy Formatting
Learn How to Use Format Painter in Excel to Quickly Copy and Apply Formatting Across Cells and Sheets | ||||
|
Row Heights and Column Widths
Learn How to Use AutoFit in Excel to Automatically Adjust Column Widths and Row Heights for Clean Layouts | ||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Insert Objects |
Verified Learning
|
|||
|
Images
Learn How to Insert and Position Pictures in Excel Cells to Enhance Your Data and Reports Visually | ||||
|
Shapes
Learn How to Insert, Format, and Use Shapes in Excel to Enhance Visuals and Create Dynamic Worksheets | ||||
|
Hyperlinks
Learn How to Add and Edit Hyperlinks in Excel to Connect Cells, Files, and Web Pages Easily | ||||
|
Object Properties and Alt Text
Explore Excel Object Properties to Modify Shapes, Charts, and Controls for Better Workbook Design | ||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Manage Worksheets |
Verified Learning
|
|||
|
View Worksheets
Learn How to Zoom In and Out in Excel to View Spreadsheets More Clearly and Improve Navigation | ||||
|
Multiple Windows
View the Same Excel File in Two Windows to Compare, Edit, and Analyze Data Simultaneously | ||||
|
Move and Copy Worksheets
Easily Duplicate or Copy Sheets in Excel to Reuse Data and Streamline Your Workflow | ||||
|
Insert, Rename, and Delete Worksheets
Learn How to Delete Worksheets in Excel Safely Without Affecting Your Workbook Data | ||||
|
Freeze Rows and Columns
Learn How to Freeze Rows and Columns in Excel to Keep Headers Visible While Scrolling Through Data | ||||
|
Hide Worksheets and Gridlines
Learn How to Remove or Hide Gridlines in Excel to Create Cleaner and More Professional Spreadsheets | ||||
Quick Answer: