Excel 2019 Basic
Try this course with a Free Trial
|
What you'll learn:
- Create and edit worksheets to summarize information.
- Basics of entering and formatting data and numbers.
- Build formulas to calculate totals and averages.
- Format data with visually stunning designs.
What’s Included:
-
Customizable, LMS-compatible content
-
Skill assessments
-
Bite-sized, interactive lessons
-
LinkedIn-ready skills certificate
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Excel Fundamentals |
Verified Learning
|
|||
Understand the Excel Screen Click to start | Not Started | Not Started | Not Started | |
Create Workbooks | Not Started | Not Started | Not Started | |
Navigate Worksheets | Not Started | Not Started | Not Started | |
Open Workbooks | Not Started | Not Started | Not Started | |
Save Workbooks | Not Started | Not Started | Not Started | |
AutoRecover | Not Started | Not Started | Not Started | |
The Quick Access Toolbar | Not Started | Not Started | Not Started | |
Not Started | Not Started | Not Started | ||
Help | Not Started | Not Started | Not Started | |
Close and Exit | Not Started | Not Started | Not Started |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Edit a Workbook |
Verified Learning
|
|||
Select Cells and Ranges | Account Required | |||
Edit Cell Data | ||||
Cut, Copy, and Paste | ||||
Undo, Redo, Repeat | ||||
More Pasting Options | ||||
Insert and Move Cells | ||||
Delete Cells | ||||
Check Spelling | ||||
Find and Replace Text | ||||
Hide Columns and Rows | ||||
Document Properties |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Basic Formulas |
Verified Learning
|
|||
Formula Basics | ||||
AutoFill | ||||
Sums and Averages | ||||
MIN and MAX | ||||
COUNT |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Basic Formatting |
Verified Learning
|
|||
Format Text | ||||
Align and Merge Cells | ||||
Format Numbers and Dates | ||||
Borders and Background Colors | ||||
Copy Formatting | ||||
Row Heights and Column Widths |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Insert Objects |
Verified Learning
|
|||
Images | ||||
Shapes | ||||
Hyperlinks | ||||
Object Properties and Alt Text |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Manage Worksheets |
Verified Learning
|
|||
View Worksheets | ||||
Multiple Windows | ||||
Move and Copy Worksheets | ||||
Insert, Rename, and Delete Worksheets | ||||
Freeze Rows and Columns | ||||
Hide Worksheets and Gridlines |
Quick Answer: