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!
Digital certificate - Included
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.
Anyone wanting to learn more about excel and it's features at a more advance level
Higher courses within excel. Become a pro with excel
Hi, I was wondering if there is a certificate or proof of completing this course for my CV/Record of achievement? Thanks
Answer:Hello Justin, Thanks for your enquiry. Once you have completed the course we will issue you with a certificate as proof that you have taken the course. Please do let us know once you have completed so we can issue the certificate without delay. I hope this answers your query. Regards, KnowledgeChum
This was helpful.Currently there are no reviews for this course. Be the first to leave a review.
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.
Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2024. All rights reserved.
