Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 0

Excel is a powerful spreadsheet software program that allows you to make quick and accurate numerical calculations. In this course you will learn: The Fundamentals Managing Workbooks Worksheet Basics Editing a Worksheet Formatting a Worksheet

Course Outline
About the Course     

Excel is a powerful spreadsheet software program that allows you to make quick and accurate numerical calculations. Entering data onto a spreadsheet (or worksheet as they are 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. You've made a great choice by deciding to learn Microsoft Excel 2007.

Chapter One: The Fundamentals
What's New in Excel 2007
Understanding the Excel Program Screen
Understanding the Ribbon
Using the Office Button and Quick Access Toolbar
Using Keyboard Commands
Using Contextual Menus and the Mini Toolbar
Customizing the Quick Access Toolbar
Changing Excel's Default Options
Viewing document Properties and Finding a File
Publishing a Workbook to a Document Workspace

Chapter Two: managing Workbooks
Viewing a Workbook
Working with the Workbook Window
Splitting and Freezing a Workbook Window
Selecting Worksheets in a Workbook
Inserting and Deleting Worksheets
Renaming, Moving and Copying Worksheets
Working with Multiple Workbooks
Hiding Rows, columns, Worksheets and Windows

Chapter Three: Worksheet Basics
Navigating a Worksheet
Entering Labels
Entering Values
Selecting a Cell Range
Overview of Formulas and Using AutoSum
Entering Formulas
Using AutoFill
Understanding Absolute and Relative Cell References
Using Undo and Redo
Previewing and Printing a Worksheet
Creating a Template

Chapter Four: Editing a Worksheet
Editing Cell Contents
Cutting, Copying, and Pasting Cells
Moving and Copying Cells Using the Mouse
Using the Office Clipboard
Using the Paste Special command
Checking Your Spelling
Inserting Cells, Rows and Columns
Deleting Cells, Rows and Columns
Using Find and Replace
Using Cell Comments
Using the Research Task Pane
Tracking Changes

Chapter Five: Formatting a Worksheet
Formatting Lables
Formatting Values
Adjusting Row Height and Column Width
Working with Cell Alignment
Adding Cell Borders, Background Colours and Patterns
Using the Format Painter
Using Cell Styles
Using Document Themes
Applying Conditional Formatting
Creating and Managing Conditional Formatting Rules
Finding and Replacing Formatting
Protecting a Workbook
Protecting Worksheets and Worksheet Elements
Sharing a Workbook
Creating a Template

Chapter Six: Working with Page Layout & Printing
Creating Headers and Footers
Using Page Breaks
Adjusting Margins and Orientation
Adjusting Size and Scale
Adding Print Titles, Gridlines and Headings
Advanced Printing Options

Prerequisites & Certificates

It is recommended that students have basic experience with the underlying operating system, i.e. the ability to navigate the environment using a mouse and keyboard plus an understanding of computer file storage.

Certificates offered

Certificate of Completion

Cancellation Policy
Full refund or credit up to first break on day of the course. Learning is guaranteed and students can re-take as many times as needed within 6 months for $50 re-booking fee.
Map & Reviews
Sector Learning
[ View Provider's Profile ]


This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 253 times.