Excel 2013 Intermediate

Training

In Aberdeen

£ 210 + VAT

Description

  • Type

    Training

  • Location

    Aberdeen (Scotland)

  • Duration

    1 Day

Microsoft Excel is a spreadsheet application that incorporates tools for assisting in the recording and analysis of numerical data and which has the ability of turning numerical data into charts. This functionality, combined with many powerful and sophisticated features allow the creation, manipulation, editing, printing and storage of workbooks.

Facilities

Location

Start date

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

Start date

On request

About this course

Excel Intermediate will allow you to gain the skills necessary to:

Create functions to analyse and manage your data
Sort and filter to find and organise data
Format your data to present or track your data
Protect your workbooks
Create charts to present your data.

Delegates wishing to attend this course should have completed our MS Excel 2013 Foundation Course or Work regularly with MS Excel 2013 and be able to insert, delete, resize columns and rows, copy and paste, write basic formulas (add, subtract, divide and multiply) and format worksheets.

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
  • MS Excel
  • Excel 2013
  • Date Functions
  • Criteria
  • Vlookup
  • Flash fill
  • Columns
  • Freezing Rows
  • Protection
  • Intermediate

Course programme

Excel 2013 Intermediate
1-Day Instructor-led classroom based training.

COURSE OUTLINE
  • Module 1: Working with Date Functions
  • Module 2: Counting and Summing based on Criteria
  • Module 3: Defined Names
  • Module 4: Vlookup
  • Module 5: Flash Fill
  • Module 6: Freezing Rows and Columns
  • Module 7: Conditional Formatting
  • Module 8: Sorting and Filtering
  • Module 9: Protection
  • Module 10: Charts
  • Module 11: Chart Elements and Formatting
  • Module 12: Quick Analysis


Knowledge of Windows and experience with a PC is presumed, therefore, it is advisable to register participants on our “Introduction to Computing” or “Microsoft Windows” course prior to attending, should this experience be lacking.

Excel 2013 Intermediate

£ 210 + VAT