Excel 2013 - Level 1

Course details

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.

Course Outline

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

Target Audience: This course is intended for inpiduals who want to gain basic knowledge of working on Excel 2013.