CourseInfo | SimpliTrain

Excel 2013 - Level 1

Learning plan iconE-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