Excel 2016 Foundation

Training

In Aberdeen

£ 210 + VAT

Description

  • Type

    Training

  • Location

    Aberdeen (Scotland)

  • Duration

    1 Day

  • Start date

    Different dates available

This is a beginner’s course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel 2016.

Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.

Facilities

Location

Start date

Aberdeen (Aberdeenshire)
See map
56-58 Bridge Street, Bridge House, AB116JN

Start date

Different dates availableEnrolment now open

About this course

This course assumes little or no knowledge of spreadsheets or Microsoft Excel 2016. However, it would be beneficial to have a general understanding of personal computers and the operating system environment, especially in regard to working with files and folders.

On completion of the course you will receive a certificate.

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

Subjects

  • Excel
  • Microsoft Excel
  • Microsoft excel training
  • Microsoft Excel 2016
  • Formatting
  • Data
  • Referencing
  • Worksheet
  • Effective charts
  • Workbook Data
  • Foundation

Course programme

EXCEL 2016 FOUNDATION


LEARNING OUTCOMES


At the completion of this course you should be able to:
  • navigate your way around Microsoft Excel 2016
  • create and work with a new workbook
  • open and navigate within workbooks and worksheets
  • make changes to data in a workbook
  • understand and work with ranges in a worksheet
  • copy and paste data in Excel
  • use the fill operations available to fill a data series
  • move the contents of cells and ranges within and between workbooks
  • understand, create and work with formulas and functions
  • understand and use formula cell referencing
  • use font formatting techniques
  • align the contents of cells in a number of ways
  • understand and use the number formatting features in Excel
  • format rows and columns in a worksheet
  • work with elements that make up the structure of a worksheet
  • sort data in a list in a worksheet
  • filter data in a table
  • print your workbook data
  • create effective charts in Microsoft Excel
  • obtain help for Excel whenever you need it
  • understand points to consider to avoid problems in your worksheets

COURSE OUTLINE
  1. Module: Getting to Know Excel 2016
  2. Module: Creating a New Workbook
  3. Module: Working With Workbooks
  4. Module: Editing in a Workbook
  5. Module: Selecting Ranges
  6. Module: Copying Data
  7. Module: Filling Data
  8. Module: Moving Data
  9. Module: Formulas and Functions
  10. Module: Formula Referencing
  11. Module: Font Formatting
  12. Module: Cell Alignment
  13. Module: Number Formatting
  14. Module: Row and Column Formatting
  15. Module: Working With a Worksheet
  16. Module: Sorting Data
  17. Module: Filtering Data
  18. Module: Printing
  19. Module: Creating Charts
  20. Module: Getting Help
  21. Module: A Guide to Brilliant Spreadsheets

Excel 2016 Foundation

£ 210 + VAT