Excel 2010 Level 1 (Basic)

 
Course Length: 6hrs (1 Day)
 
Excel‘s spreadsheet capabilities help you create and format workbooks (a collection of spreadsheets) in order to analyze, display and print data. You can use Excel to track data, predict trends, and write formulas to perform calculations on that data and present data in a variety of professional look charts in just a few easy steps.

​

Learning Objectives:

In this course, you will create, edit, display and print Excel Workbooks. You will:

- Enter Data To Create Workbooks
- Edit And Format Data In Workbooks
- Create Basic Formulas To Calculate Data
- Create Basic Charts To Display Data
- Print Workbooks
 
Target Student:

This course is for individuals who are new to Microsoft Excel 2010.

​

Course Outline:

​

Section 1: Getting Started

Lesson 1.1: Starting Out
Lesson 1.2: About Workbooks
Lesson 1.3: Exploring Your Workbook
Lesson 1.4: Getting Help with Excel

Section 2: The Excel Interface

Lesson 2.1: The Quick Access Toolbar and File Menu
Lesson 2.2: The Home Tab
Lesson 2.3: The Insert Tab
Lesson 2.4: The Page Layout Tab
Lesson 2.5: The Formulas Tab
Lesson 2.6: The Data Tab
Lesson 2.7: The Review Tab

Section 3: Excel Basics

Lesson 3.1: Working with Excel
Lesson 3.2: Basic Excel Features
Lesson 3.3: Moving Your Data
Lesson 3.4: Smart Tags and Options Buttons
Lesson 3.5: Editing Tools

Section 4: Editing Your Workbook
 

Lesson 4.1: Modifying Cells and Data
Lesson 4.2: Cell Formatting
Lesson 4.3: Enhancing a Worksheet's Appearance
Lesson 4.4: Working with Charts, Part 1
Lesson 4.5: Working with Charts, Part 2

Section 5: Printing and Viewing Your Workbook

​

Lesson 5.1: Using the View Tab
Lesson 5.2: Managing a Single Window
Lesson 5.3: Managing Multiple Windows
Lesson 5.4: Printing Your Workbook