Microsoft Excel - Introduction

1 Day

Introduction

Designed for those who have little or no knowledge of using a computerised spreadsheet program.

Pre-requisites
Participants should have used a mouse and have knowledge of Microsoft Windows. A pre-course questionnaire is available for participants to confirm their existing knowledge before attending

Benefits
Time efficient and effective manipulation, creation and reporting of data to support decisions

Programme Objectives

Participants will be able to create, edit, print and improve the appearance of spreadsheets.  Participants will also have learned how to construct formulae and different calculation types that are available.  The course finishes with instruction in graphically representing your data and the various graph types that are available.
 

Programme Content

• Ribbons
• Quick Access Toolbar
• Moving Around
• Entering & Editing Data
• Help
• Saving/Opening Files
• Using OneDrive (Office 365 only)
• Sharing Documents
• Using AutoFill
• Printing and Print Preview
• Changing Column Widths & Row Heights
• Enhancing Worksheets Presentation using Borders, Colours, Patterns and Font Enhancements
• Entering Formulas & Mathematical Priorities
• Basic Functions
• Function Wizard
• Naming Cells
• Absolute and Relative Addressing
• Recommended Charts
• Using quick analysis to create charts
• Creating 2D & 3D Charts using Chart Quick Key and Chart Wizard
• Creating Picture Charts