Information Technology

Excel 2013 - Level 1

Instructor-Led 8 Agenda

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.

Course Overview

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.

Who Should Attend

This course is intended for individuals who want to gain basic knowledge of working on Excel 2013.

Getting started Lesson Id 1

Getting started

Entering and editing data Lesson Id 2

Entering and editing data

Modifying a worksheet Lesson Id 3

Modifying a worksheet

Functions Lesson Id 4

Functions

Formatting Lesson Id 5

Formatting

Charts Lesson Id 6

Charts

Graphics Lesson Id 7

Graphics

Printing Lesson Id 8

Printing

Lesson Id	Title	Description
1	Getting started	Spreadsheet terminology<br />The Excel environment<br />Navigating a worksheet<br />Using a template
2	Entering and editing data	Entering and editing text and values<br />Entering and editing formulas<br />Saving and updating workbooks
3	Modifying a worksheet	Moving and copying data<br />Moving, copying, and viewing formulas<br />Absolute and relative references<br />Inserting and deleting ranges, rows, and columns
4	Functions	Entering functions<br />AutoSum<br />Other common functions
5	Formatting	Text formatting <br />Row and column formatting <br />Number formatting <br />Conditional formatting<br />Additional formatting options
6	Charts	Chart basics<br />Formatting charts
7	Graphics	Working with pictures <br />Conditional formatting with graphics<br />SmartArt graphics
8	Printing	Preparing to print<br />Page Setup options<br />Printing worksheets