Excel 2007/2010 Introduction

Course details

Microsoft Excel is a useful tool for generating spreadsheets from a number of data sources. Using calculations and predefined formulas, users can easily manage any type of data including budgets, financial data, statistical data, reports, charts, graphs, and small lists. On the course you will be introduced to many of the topics required for the Microsoft Office Specialist (MOS) Core level.

Objectives

The Excel Introduction course covers a range of topics which will introduce you to Excel features and the steps required to use these features correctly. On completion of this course, all participants will be able to perform the following:

Content

Creating a Basic Worksheet

• Explore the User Interface and the Ribbon
• Customize the Quick Access Toolbar
• Enter Data and Save a workbook
• Navigate and Select in Excel
• Use the Online Help

Modifying a Worksheet

• Modifying Cells and Data
• Insert and Delete Cells, Columns and Rows
• Cell Merging and AutoFit

Performing Calculations

• Create Basic Formulas
• Calculate with Functions
• Copy Formulas and Functions
• Use the AutoSum and AutoFill

Formatting a Worksheet

• Using Conditional Formatting
• Using the Format Painter
• Adding Borders
• Adding Patterns and Colors
• Applying Styles and Themes
• Managing Multiple Windows
• Switching Between Open Windows
• Arranging Workbooks
• Comparing Workbooks Side by Side

Working with Charts

• Creating a Chart
• Changing the Chart Type
• Working with Chart Axes and Data Series
• Changing the Source Data
• Saving the Chart as a Template

Printing and Viewing your Workbook

• Using Page Break Preview
• Setting Print Options
• Setting Print Area
• Print Titles

Managing Large Workbooks

• Insert, Delete and Move Worksheets
• Format Worksheet Tabs
• Freeze Titles

Prerequisites

A working knowledge of PCs and a mouse is assumed.

Who should attend?

This course is designed to introduce new and infrequent users of Microsoft Excel seeking proficiency in the use of Excel.