Office Excel Tutorials - Microsoft Excel Training

Course

In Cardiff

£ 1,495 + VAT

Description

  • Type

    Course

  • Location

    Cardiff (Wales)

  • Duration

    1 Day

  • Start date

    Different dates available

Delegate pack consisting of course notes and exercises Manual Experienced Instructor Refreshments

Facilities

Location

Start date

Cardiff
See map
Castle Street, CF10 1SZ

Start date

Different dates availableEnrolment now open

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

This centre's achievements

2016

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 8 years

Subjects

  • Excel
  • IT
  • Office IT
  • Microsoft Excel
  • Writing
  • Ms Office
  • Microsoft excel training
  • MS Excel

Course programme

The Knowledge Academy Advanced Function Writing for Microsoft Excel 2010 1 day course covers the following topics:

Introduction

This 1 day course offers delegates a more advanced look at Excel 2010. Delegates will learn more advanced writing functions, keyboard commands and shortcuts. This course will teach delegates how to get more out of their data by using analysis functions.

Pre-Requisites

  • Delegates should have good knowledge of Microsoft Windows, Excel 2010 as well as an understanding of basic functions like Sum and Average.

Who should attend?

  • This course is suitable for delegates who need to make the most out of their data and may work in areas such as finance, statistics, project analysis, market analysis or data manipulation.

What will you learn?

  • Once you have completed the Advanced Function Writing for Microsoft Excel 2010 course you will understand:
  • How to control text values
  • How to manage date and time functions
  • How to use the Aggregate function for conditional formatting
  • How to use the look up function
  • How to use the reference function
  • How to use nested and array combined functions
  • How to use IF and other functions

Course Outline

  • IF Functions
  • Array Functions
  • Aggregate Functions
  • Date and Time Functions
  • Rounding Numbers
  • Compatibility guide
  • Look up and reference functions
  • Function writing

Additional information

  • COURSE BULLET LIST
  • Gain an understanding of how to use the reference function  
  • Learn the key to function writing
  • Develop knowledge of IF Functions
  • GUARANTEED LOWEST PRICE IN THE INDUSTRY
  • Courses delivered by world class training instructors
  • Training provided in luxury venues
  • Includes material and manuals
  • Book Online or Call 01344 203999 to speak to a training advisor today

Office Excel Tutorials - Microsoft Excel Training

£ 1,495 + VAT