Introduction / Intermediate Microsoft Excel

Objectives: After completing this course delegates will be able to navigate an Excel Spreadsheet, create and manipulate simple formulae and create charts.

Pre Requisites: A basic understanding of Microsoft Windows is recommended.

Duration: 2 days

The topics covered are as follows:

Introduction

1 Excel Basics
• Spreadsheet Concepts
• Entering Text & Numbers
• Summing Rows and Columns

2 Excel Workbooks
• Opening and Saving Workbooks
• Switching between Workbooks

3 Calculations & Corrections
• Entering Formulae
• Correcting Mistakes

4 Moving, Copying, and Inserting
• Moving/Copying Cells
• Inserting Rows/Columns/ Cells

5 Formatting Worksheets
• Formatting Basics
• Number Formatting
• Alignment of Entries
• Changing Fonts
• Adding Borders/Shading to Cells
• Column Width / Row Height

6 Printing Basics
• Previewing the Printout
• Fitting a Spreadsheet on a Page
• Altering Page Margins

7 Charting Basics
• Using the Chart Wizard
• Formatting the Chart

Intermediate

8 More about Calculations
• Absolute References
• Using Functions
• Examples of Functions

9 More Features
• Using Comments
• Splitting and Freezing
• Using Zoom
• The Paste Special Command

10 More about Printing
• Adding Headers & Footers
• Setting the Print Area
• Using Print Titles
• Controlling Page Breaks

11 More about Charts
• The Chart Menu
• Revising a Chart
• Further Formatting
• Drag and Plot

12 Working with Multiple Worksheets
• Selecting Multiple Worksheets
• Navigating Multiple Worksheets
• Calculations between Worksheets

13 Data Commands
• Working with Lists
• Sorting Lists
• Filtering a List

microcomputing serves the Tyne & Wear, Northeast England region, with software training courses arranged for all types of companies in Sunderland, Washington, Gateshead and Newcastle as well as County Durham, Northumberland and the Teeside area with courses for organisations in Middlesbrough, Darlington and Stockton.