reed.co.uk Courses

Header

Microsoft Excel Pivot tables, V Look Up and IF functions


eTrain

Summary

Price
Save 29%
£25 inc VAT (was £35)
Offer ends 23 June 2019
Study method
Online, self-paced
Duration
3 Hours
Qualification
No formal qualification
Additional info
  • Tutor is available to students
  • Certificate of completion available and is included in the price

4 students purchased this course

Add to basket or enquire

Overview

3 courses in one! Have you ever struggled with pivot tables, IF functions and or vlook up? If you have than this is the course for you. Whether you are new to excel or at advanced level this course will teach you everything you need to know about pivot tables and vlook up. You can work at your own pace as there is no time limit and you will have access to this course forever!

Improve your excel skills!

Description

Learn how to use Pivot Tables

Excel spreadsheets are handy tools for tracking and analysing data. However, they do have some limitations. If you build a spreadsheet in a certain layout, it will often take a fair amount of time and work to provide alternate views of the data.

That’s where Pivot Tables come to the rescue. Pivot Tables allow you to take a large block of Excel data and slice & dice it in numerous useful ways. The best thing is that you don’t ever have to risk damaging your source data to produce these alternate views.

Pivot tables are interactive tables you can use reach excels full potential.

You will learn:

Creating a pivot table from existing data

Analysing data

Organising data

Rearrange data

Present it in different ways

Extract information from large data sources

VLook up

How to use V Look up definition

The Vlookup function in Excel is used to see if a value in one cell (or list of cells) is in another group of cells. (“V” is for vertical – you can use the H lookup function to check horizontally too) Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify.

What you will learn:

Syntax of Vlook up function

Named ranges

V look up formulas

Function Argument tables

N/A and error messages

Combining V Look Up and IF Statements

Excel Nested IF Functions

How and when to use the IF and AND function

You are not permitted to, in anyway, copy this course (all it's contents) for re-sale or to gain profits from this course. This course is solely for the purpose of learning and is to be used by only the purchaser of this course.

Who is this course for?

Anyone wanting to learn more about excel and it's features at a more advance level

Questions and answers

No questions or answers have been posted about this course.

Rating and reviews

There haven't been any reviews for this course yet.

Please sign in to review this course.