Excel 2013 Advanced

Solab

Training

In Aberdeen

£ 210 + VAT

The best Excel courses

See all

See all

Description

  • Type

    Training

  • Location

    Aberdeen (Scotland)

  • Duration

    1 Day

  • Start date

    Different dates available

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

Different dates availableEnrolment now open

About this course

Excel Advanced will allow you to gain the skills necessary to

Nest functions to extract and analyse data
Audit functions to identify errors and calculation steps
Create, edit and format Pivot Tables to summarise, analyse and report on data
Record Macros and edit recorded code in the Visual Basic Editor
Restrict user data entry using Data Validation
Share a workbook for multiple editors and enable Track Changes.

Completed our MS Excel 2013 Intermediate 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. They should also be aware of the use of functions to reduce manual input.

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
  • Formula Auditing
  • Advanced Functions
  • Macros
  • Data validation
  • Excel 2013 Advanced
  • Visual Basic Editor
  • Track Changes
  • Advanced

Course programme

Excel 2013 Advanced

COURSE OUTLINE

  • Module 1: Advanced Functions
  • Module 2: Formula auditing
  • Module 3: Pivot tables
  • Module 4: Macros
  • Module 5: Data validation
  • Module 6: What if analysis
  • Module 7: Sharing and tracking changes


Excel 2013 Advanced can be delivered as a scheduled open course, a company private closed course or as a one to one consultancy. We can run this course either at our training centre in Aberdeen, your premises or using our portable training school.



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



Course duration:

One day instructor led training

See related categories

Excel 2013 Advanced

£ 210 + VAT

The best Excel courses

See all

See all