Skip to content

Microsoft Excel Pivot tables, V Look Up and IF functions


eTrain

Summary

Price
£15 inc VAT
Study method
Online
Duration
3 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Certificate of completion - Free
Additional info
  • Tutor is available to students

64 students purchased this course

Add to basket or enquire

Buy with Apple Pay
Buy with Google Pay

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!

This course is non interactive. You will receive word documents ONLY

Certificates

Certificate of completion

Digital certificate - Included

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 found containing ''.


Alan asked:

Does the course come with examples and a test at the end? Is there any pratice questions that you can recommend please?

Answer:

Hi, There are no example questions and no practice questions. Thanks eTrain

This was helpful. Thank you for your feedback.

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.