Course not currently available

Microsoft Excel Primary

WDR

Short course

In Horsham ()

£ 175 + VAT

Description

  • Type

    Short course

  • Level

    Beginner

  • Duration

    1 Day

A comprehensive course covering the essential features of Excel, enabling delegates to produce a professional spreadsheet incorporating cell and data formatting, formulae and functions, manipulation of rows, columns and data, printing and an introduction to charting. Course objectives: The course is designed to provide delegates with a good. Suitable for: Secretaries, Administrators, Executives, Managers, Finance and Engineering staff and those who need to produce figures, statistics and graphics.

Questions & Answers

Add your question

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

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Overview
A comprehensive course covering the essential features of Excel, enabling delegates to produce a professional spreadsheet incorporating cell and data formatting, formulae and functions, manipulation of rows, columns and data, printing and an introduction to charting.


Course objectives
The course is designed to provide delegates with a good understanding of the main features of Excel and how best to utilise these to create professional spreadsheets in their work environment.

By the end of this course you will have learned

  • How to open, save and close workbooks
  • Entering and editing data
  • How to use undo and redo
  • Inserting and changing heights/widths of rows and columns
  • Create formulae and functions: use AutoSum and AutoFill
  • Cell formatting, text alignment
  • How to use format painter and AutoFormat
  • Working with worksheets
  • Printing and creating charts.



Who should attend
Secretaries, Administrators, Executives, Managers, Finance and Engineering staff and those who need to produce figures, statistics and graphics.

Pre-requisites
Delegates should have a good understanding of the Windows environment and a need to utilise Excel in their day to day work.

Course synopsis

  • Starting Microsoft Excel - Understanding the Microsoft Excel screen; shortcut menus; opening/closing/saving a workbook; starting a new workbook
  • Entering data - Moving around the workbook; selecting cells; entering data; entering blocks of data; selecting cells; editing data; deleting data; using undo and redo
  • Some more features - Changing column widths; changing row heights; inserting and deleting rows and columns; moving and copying data
  • AutoFill - How to use AutoFill; creating custom AutoFill lists
  • Using formula and functions
  • Creating formulae; mathematical operators; using functions
  • Formatting cells - Changing fonts; formatting numbers; aligning text; applying borders, shading and patterns; using format painter; removing formats
  • Worksheets - Renaming, inserting, deleting, moving and copying worksheets
  • Printing - Using print preview; setting margins; headers and footers; inserting page breaks; printing worksheets; creating a print area
  • Charts - Creating charts using chart wizard; editing and formatting charts


Microsoft Excel Primary

£ 175 + VAT