Microsoft Excel Introduction

Microsoft Excel Introduction

About the course:
This course aims to provide participants with a basic introduction to Excel and enable them to use a spreadsheet with confidence and ease.

By the end of the course, delegates will be able to work with cells, rows and columns, move and copy data, explore cell references and formulas and functions, format cells and work with charts.

Course Content:
Getting Started with Excel

• Open Microsoft Office Excel
• Examine the Excel Window
• Open and view Worksheets and Work Books

Working With Cells, Rows and Columns

• Create Workbooks
• Enter and Edit Cell Content
• Check Spelling
• Insert, Delete, Merge and Split Cells
• Insert, Delete and Modify Columns and Rows

Exploring Functions

• Understand and Build Functions
• Use AutoSum and AutoCalculate
• Calculate Sums using functions
• Create Averages, Minimum and Maximum Function

Formatting Cells and Cell Contents

• Understand Date and Number Formatting
• Change Text Alignment
• Wrap Text Within Cells
• Modify Text Appearance
• Apply Shading
• Use the Format Painter
• Use Border Drawing

Moving and Copying Data

• Look at the Clipboard
• Examine Cut, Copy and Paste
• Use Paste Special
• Move Cells and Ranges
• Understand Fills

Exploring Cell References and Formulas

• Understand Formulas
• Understand Cell References
• Use Cell References in Formulas
• Enter a Formula in the Formula Bar
• Copy and Edit Formulas

Working With Charts

• Examine Charts
• Use the Chart Wizard
• Change Chart Types
• Elevate, Rotate, Resize and Position Charts
• Edit and Resize Chart Titles

Exploring Printing

• Understanding Printing
• Preview Worksheets
• Change Page Orientation and Scaling
• Set Page Margins and Alignment
• Create Headers and Footers
• Select Print Options
• Set Print and Clear Print Areas
• Print Selections, Worksheets and Workbooks

Equipment Requirements:
All equipment will be supplied by City Business.

Assessment:
Due to the workshop nature of this one day course, there are no formal examinations or assessments.

Progression:
Delegates may wish to extend their knowledge by attending an Excel Intermediate course after successfully completing the Introduction level.


Code : Time : Duration : Day : Tuition Fee : Admin Fee
B01533 001 00:00 - 00:00 06/01/2010 - 06/01/2010 Wednesday Fee Enquiry

B01533 003 00:00 - 00:00 14/07/2010 - 14/07/2010 Wednesday Fee Enquiry