Short course

In Southwark

Price on request

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

Southwark (London)
See map
202 Blackfriars Road, SE1 8NJ

Start date

On request

About this course

Basic PC knowledge required

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

DESCRIPTION
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
WORKBOOKS AND WORKSHEETS
  • 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
FORMULAS AND FUNCTIONS
  • 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
FORMATTING AND CUSTOMISING DATA
  • 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
PRINTING
  • Using Page Setup
  • Margins
  • Headers And Footers
  • Printing A Spreadsheet
CHARTS
  • Chart Wizard
  • Chart Toolbar
  • Working With Charts
  • Formatting the Chart

Excel 2003 Level 1

Price on request