Microsoft Excel Pivot tables, V Look Up and IF functions
Summary
- Certificate of completion - Free
- Tutor is available to students
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!
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
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.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Provider
eTrain has been providing online courses for over 5 years.
We have over 900 online courses to choose from.
We pride ourselves on excellent customer service and give our students as much information as possible before enrolling on any of our courses. For us, there is nothing more rewarding than our students achieving what they set out to achieve when they enrolled with us.
Add to basket or enquire
Legal information
This course is advertised on Reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.
