Beginning Microsoft Excel

Microsoft Excel 2010 Online Course

Level 1 Introductory Skills

$59.99

6 Weekly Lessons - Open Entry (Join Anytime) Your login to E-Lab will be emailed to you upon enrollment.

Enrollment Options

This microsoft office online class is designed to take 6 weeks although you have up to 2 years from the date of enrollment to complete the course. With our anytime, anywhere policy, you can complete the assignments at a time and place that is convenient for you. This course is hosted on E-Lab. Upon enrollment, you will receive your class URL, Course Code, and login details for the course.

DESCRIPTION

Microsoft® Excel 2010: Level 1 provides thorough introductory training of Excel 2010. This course covers beginning-level skills, and is ideal for the newer computer user who wants to become well versed in Excel. Topics introduced include the Ribbon interface; entering and editing data; selecting cells and ranges; printing worksheets; creating formulas and functions; formatting cell contents; inserting and deleting columns, rows, and cells; charts; and more. After completing this course, students can successfully face the challenges presented in the Microsoft Excel 2010: Level 2 course that will be offered at a later date on Officeskills.org.

Pre-Requisites

None.

Requirements:

You will need Microsoft Office 2010. 60 Day Free Trials are available at the following link: Microsoft Office 2010 Free Trials. Please note: Depending on the course(s) you are enrolled in, this may not be long enough to complete your course.
Adobe Flash Player so you can view the Video Lessons. You can download the latest version at the following link: Adobe Flash Play er.
Adobe Reader to view pdf presentation files is available at the following link: Adobe Reader Download

Recommended Books:.

FastCourse Microsoft Excel 2010: Level 1 By Sandra Rittman . This book is available through the publisher and also very limited copies may be available on Amazon.com.

COURSE OBJECTIVES

By the end of this course, you will be able to:

Enter text and numbers into cells
Clear cell contents, including formatting
Create, modify, and copy formulas
Format worksheets and apply workbook themes
Work with date functions
Modify column width and row heights
Much, much more!

DETAILED COURSE OUTLINE

LESSON 1: - EXPLORING EXCEL 2010

Presenting Excel 2010
Starting Excel
Exploring the Excel Program Window
Using Worksheets and Workbooks
Mousing Around in Excel
Scrolling Along in a Worksheet
Navigating in a Worksheet
Working with Tabs and Ribbons
The Quick Access Toolbar
Displaying Tabs and Working with Ribbons
Hiding the Ribbon
Entering Data in Excel
Data Types
Completing Cell Entries
The Enter and Cancel Buttons
Deleting and Replacing Entries
Long Text Entries
Working with Numbers and Number Formats
Decimals and Negative Numbers
Understanding Save Concepts and Storing Your Exercise Files
The Save Command and Save As Options
Locating Workbooks
Issuing Commands from the Keyboard
Closing and Starting New Workbooks and Exiting from Excel 17
LESSON 2: EDITING AND PRINTING WORKSHEETS
Opening Workbooks
Editing Entries
Replacing Entries
Deleting Characters
Selecting Cells and Ranges
Excel Ranges
Working with Cut, Copy, and Paste
Marquee and Paste Options Button
The Office Clipboard
Moving and Copying Cells via Drag and Drop
Editing Cells via Right-Dragging
Using Undo and Redo
Undoing Multiple Actions
Using Auto Features
Working with AutoFill
AutoComplete vs. AutoFill
Auto Fill Options
Printing Worksheets
Print Preview
Print the Worksheet
Printing Selections

LESSON 3: WORKING WITH FORMULAS AND FUNCTIONS

Working with Formulas and Functions 37
Using AutoSum to Create a SUM Formula
Status Bar Functions and Customization
Creating Formulas
Beginning Character in Formulas
Cell and Range References
The Language of Excel Formulas “Please Excuse My Dear Aunt Sally”
Using Cell References in Formulas
Relative Cell References
Point Mode
Absolute Cell References and Mixed References
Using the (F4) Function Key
What-If Analysis
Modifying and Copying Formulas
Using Formula AutoComplete
Functions Defined
Using Insert Function
Creating Formulas with the IF Function
IF Function Syntax and how the IF Function Works
LESSON 4: FORMATTING THE CONTENTS OF CELLS
Formatting Worksheets
Formatting Entries with the Ribbon
Using the Mini Toolbar
Live Preview
Using Excel’s Alignment and Indent Features
Aligning Entries and Indenting Cell Entries
Using Excel’s Text Control Options
Merging and Splitting Cells
Wrapping Text
Shrinking Text to Fit Within a Cell
Formatting Numbers
Using the Number Command Group
Using Accounting and Currency Styles
Applying the Percent Style
How Numbers Display in Cells
Adjusting Decimal Places
Displaying Negative Numbers
Using the Format Cells Dialog Box
Applying Borders and Fills to Cells
Applying Fill Colors and Patterns
Working with Format Painter and Quick Styles
Applying Quick Styles to Cells

LESSON 5: CHANGING THE APPEARANCE OF WORKSHEETS
Managing Worksheets
Inserting and Deleting Worksheets
Rearranging, Copying, and Renaming Worksheet Tabs
Modifying Column Widths and Row Heights
Standard Column Widths and Row Heights
Using AutoFit
Inserting and Deleting Columns, Rows, and Cells
Formatting and Hiding Columns and Rows Simultaneously
Unhiding Columns and Rows
Changing Vertical Alignment and Rotating Text
Using Excel’s Find and Replace Commands
Replacing Cell Formats 85

LESSON 6: CHARTING WORKSHEET DATA
Creating Charts in Excel
Integrated Chart Engine Creating New Charts
Choosing the Proper Data Source
Column Charts and Bar Charts
Category Axis and Value Axis
Legend
Chart and Axis Titles
Using The Chart Tools
Moving and Sizing Embedded Charts
Deleting Charts
Exploring Other Chart Types
Line Charts and Pie Charts
Modifying Existing Charts
Changing the Chart Type
Reselecting Data
Modifying Chart Elements
Formatting Chart Elements
Previewing and Printing Charts

View Current Schedule