Excel 2003 Level 1
Short course
In Southwark
Description
-
Type
Short course
-
Level
Beginner
-
Location
Southwark
-
Duration
1 Day
If you have some Excel knowledge, or no Excel knowledge, this course takes you quickly from basic knowledge to a greater understanding of Excel's features. It touches on Beginner, Intermediate and Advanced features.
Facilities
Location
Start date
Start date
About this course
Basic PC knowledge required
Reviews
Course programme
If you have some Excel knowledge, or no Excel knowledge, this course takes you quickly from basic knowledge to a greater understanding of Excel's features. It touches on Beginner, Intermediate and Advanced features.
PREREQUISITES
Basic PC knowledge required
INTRODUCTION TO MICROSOFT EXCEL
- What Is Excel?
- Excel File Types
- Excel Environment
- Toolbars
- Office Assistant
- Creating And Opening Workbooks
- Working With Workbooks
- Working With Worksheets
- Working With Cells
- Navigating Within A Worksheet
- Navigating The Workbook
- Understanding Dates
- Inserting and deleting rows, columns, cells
- Cutting, Copying, And Pasting
- Using Find And Replace
- Using Undo And Redo
- Spell Check
- Creating Maths formulas
- Using Paste Function
- Entering Functions
- Sum, count, max, min, average
- Percentages
- Using the F4 key to lock cell references (Absolute referencing)
- Creating Named Ranges to use in formulas
- Selecting Items In Excel
- Formatting Text
- Formatting Numbers
- Manipulating Data
- Formatting Columns And Rows
- Formatting With Colours And Patterns
- Adding And Editing Borders
- Using Autoformat
- Using the format painter
- Using Page Setup
- Margins
- Headers And Footers
- Printing A Spreadsheet
- Chart Wizard
- Chart Toolbar
- Working With Charts
- Formatting the Chart
Excel 2003 Level 1