Excel 2010 Level 1

Upcoming Courses

You can also contact us by phone at 250-727-2266 or by email at info@sectorlearning.com to register for a course date.

Click here to request a specific date, 1-1 training, or course customization.

Summary

What is Excel?

Microsoft Excel 2010 is a powerful spreadsheet software program that allows you to make quick and accurate numerical calculations. Entering data onto a spreadsheet (or a "worksheet," as it is called in Excel) is quick and easy. Once data has been entered in a worksheet, Excel can instantly perform any type of calculation on it. Excel can also make your information look sharp and professional.

The uses for Excel are limitless: businesses use Excel for creating financial reports, scientists use Excel for statistical analysis, and families use Excel to help manage their investment portfolios. Microsoft Excel is by far the most widely used and, according to most reviews, the most powerful and user friendly spreadsheet program available.

Course Outline

The Excel Environment
Navigating Excel's Environment
The Ribbon and Quick Access Toolbar
Understanding the Backstage
Universal Shortcuts
Understanding Help

Working with Excel Files
Creating and Saving a New Workbook
Opening and Existing Workbook
Navigating a Worksheet
Entering and Editing Data
Copying and Moving Cells
Inserting and Deleting Cells, Rows, and Columns
Adjusting Row Height and Column Width
Selecting, Naming and Switching Between Worksheets
Inserting and Deleting Worksheets

Understanding Formulas
Overview of Formulas and Cell References
Entering Formulas and Functions
Understanding Relative and Absolute References

Formatting a Worksheet
Formatting Text and Values
Working with Cell Alignment
Adding Cell Borders and Shading
Copying Formatting

Preview and Printing Documents
Document Properties
Mark as Final
Compatibility Checker
Page Margins and Print Scale
Setting the Print Area and Print Titles

Prerequisites

This course is designed for beginner Microsoft Excel users.

Basic computer skills are necessary to complete this course. These skills include: a basic understanding of a computer's operating system, the ability to navigate the environment using a mouse and keyboard, an understanding of computer file storage, launching an application, and creating and saving files. It is also recommended that students are also familiar with using the internet.