Add to basket or enquire
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!
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
Present it in different ways
Extract information from large data sources
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
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.
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.