Excel 2013 - Level 1


E-Learning
Description
In this course, students will use Microsoft® Office Excel® 2013 to create spreadsheets and workbooks that you can use to store, manipulate, and share your data.
In this course, students will use Microsoft® Office Excel® 2013 to create spreadsheets and workbooks that you can use to store, manipulate, and share your data.
This course is intended for individuals who want to gain basic knowledge of working on Excel 2013.
| Lesson Id | Title | Description |
|---|---|---|
| 1 | Getting started |
Spreadsheet terminology The Excel environment Navigating a worksheet Using a template |
| 2 | Entering and editing data |
Entering and editing text and values Entering and editing formulas Saving and updating workbooks |
| 3 | Modifying a worksheet |
Moving and copying data Moving, copying, and viewing formulas Absolute and relative references Inserting and deleting ranges, rows, and columns |
| 4 | Functions |
Entering functions AutoSum Other common functions |
| 5 | Formatting |
Text formatting Row and column formatting Number formatting Conditional formatting Additional formatting options |
| 6 | Charts |
Chart basics Formatting charts |
| 7 | Graphics |
Working with pictures Conditional formatting with graphics SmartArt graphics |
| 8 | Printing |
Preparing to print Page Setup options Printing worksheets |