Other

Microsoft Excel Introduction Course

14th Nov 2024 09:30 am - 04:15 pm

Venue: Virtual Delivery

Paid

Posted By: APS Learning

26th Sep 2022

Event Description

Microsoft Excel Introduction Course Aims and Objectives

This course will introduce new and existing users of Microsoft Excel to the fundamental features of spreadsheets and their use.

Delegates are guided through its use from setting up a simple spreadsheet with values, labels and formulae to displaying information in graphical format.

The course will also be of great benefit to those who have been using Excel for some time but who feel that they are not making best use of its facilities.  The course will undoubtedly introduce these users to many shortcuts which they may not have discovered for themselves.

Course Duration

1 Day

Course Format

  • Virtual based;
  • Trainer led. Interactive with opportunity for questions and discussion.

Who This Course is For

  • People who wish to understand what MS Excel can do for them
  • Those who suspect they are not getting the most out of MS Excel or who feel that they are not using it in the most efficient way.

Course Pre-requisites

  • No prior knowledge of MS Excel is required;
  • Basic computer usage gained using email, internet etc.

Course Content 

Navigation and Introduction

  • Good practice in spreadsheet design
  • Understanding spreadsheet terminology
  • Workbooks and worksheets
  • Rows, columns, cells, ranges
  • Entering values, labels, formulas

Manipulating Data

  • Cut, Copy & Paste
  • Move & Copy Data between sheets
  • Autofill for Dates/Values/Text
  • Find & Replace
  • Clearing and deleting cell contents and formats

Formatting Data

  • Formatting Cells
  • Font & Border Formatting
  • Shading and Colour Formats
  • Alignment Tools
  • Text Wrap
  • Number formatting
  • Decimals/Currency/Dates/Percentages

Introduction to Formula & Functions

  • Create a mathematical formula
  • Add/Subtract/Multiply/Divide
  • Common Functions
  • Sum/Average/Max/Min/Count
  • Absolute References

Worksheet & Data management

  • Sorts & Filters
  • Inserting and deleting Sheets
  • Moving and copying
  • Renaming

Page Setup And Printing

  • Print preview
  • Adjusting margins
  • Applying headers and footers
  • Changing orientation

Tips and tricks for most efficient use of Excel

  • Keyboard Shortcuts
  • Making use of the Right Click

For more information on the Microsoft Excel Introduction Course

Contact Pauline Thompson on Pauline.Thompson@APSlearning.co.uk or 07767 392003.  

Register for Event