Excel Introduction The Essentials

Course Outline

Audience

This one-day course is for those new to Excel or who have some experience editing data but are not confident creating calculations and charts.

Aims

By the end of the course delegates will be confident using the essential features of Excel to create, edit, format and print worksheets, construct simple formulas. Delegates will also be able to create basic charts; sort and filter data.

Objectives

At the end of the course delegates will be able to:

  • Create, save, close, open and print worksheets
  • Apply page setups to print and read worksheets on screen and print out
  • Insert and delete rows or columns and move data
  • Use Excel’s SUM function to add up numbers automatically
  • Construct and copy formulae using relative and absolute cell references
  • Sort lists into order and filter to show only the data you need
  • Format the appearance and layout of numbers and text
  • Introduction to Charts and Graphs

Course Content

EXCEL INTRODUCTION

  • The Interface and Workspace
  • Navigating a Worksheet
  • Understanding Excel Mouse pointers
  • Enter, Edit and Delete Data
  • The Undo and Redo command
  • Adjusting Column Widths
  • Autofill
  • Working with Ranges
  • Inserting/deleting Columns, Rows and Cells
  • Moving and copying data
  • Saving and file formats

FORMATTING

  • Font formatting, borders and shading
  • Alignment of data, Wrap Text, Merge Cells
  • Number formats - Date, Currency and Text Formats
  • Clear Formats

SIMPLE CALCULATIONS

  • Construct, edit and view formula
  • Write formula with both Relative and Absolute Cell References
  • Copy a formula
  • Good worksheet design

INTRODUCTION TO SIMPLE FUNCTIONS

  • Generate statistics using SUM, AVERAGE, COUNT, MIN and MAX functions

PRINTING AND PREVIEWING

  • Setting up the printed page
  • Viewing and scaling Worksheet
  • Headers and Footers
  • Printing

UNDERSTANDING WORKSHEETS

  • Inserting, deleting, renaming worksheets
  • Colour sheet tab
  • Move and Copy worksheets

MANAGING LISTS

  • Sorting
  • Filtering

CHARTS

  • Types of Charts
  • Create and modify charts
  • Printing Chart

Show the next months in

Location Dates Time Price exc. VAT   Status
Growtrain Ltd 8C PO20 2BX 12 Jul 2019 09:00h – 16:00h £145.00 Registration Closes
Jul 11, 2019 10:00AM


Growtrain Ltd 8C PO20 2BX

12 Jul 2019

09:00h – 16:00h

£145.00 exc. VAT

 

Register Now » 3 Places Available!
Register Now » 3 Places Available!
Growtrain Ltd 8C PO20 2BX 04 Oct 2019 09:00h – 16:00h £145.00 Registration Closes
Oct 03, 2019 10:00AM


Growtrain Ltd 8C PO20 2BX

04 Oct 2019

09:00h – 16:00h

£145.00 exc. VAT

 

Register Now » 8 Places Available!
Register Now » 8 Places Available!
Contact Nina or Graham on 01243 216278 or email courses@growtrain.co.uk to book this course
Share This