Автор: Daniel Gates
Издательство: Amazon.com Services LLC
Год: 2020
Формат: PDF, EPUB
Страниц: 173
Размер: 21,5 Mb
Язык: English
Pro Excel: Mastering Pivot Tables & VlookUp.
PRO EXCEL helps take your excel skills to the next level. These are "easy to learn" books that cover excel's most challenging topics - Pivot Tables and VLookUp. These books are designed with practice quizzes & workbooks; the readers can download the workbooks and practice advanced quizzes to fully understand the concepts.
This 2 in 1 bundle covers the following topics
Pivot Tables
Introduction to Pivot Tables
Creating a Pivot Table
Creating Pivot Charts
Slicers and Advanced Filtering
Calculations in Pivot Tables
Customizing Pivot Tables
Using VBA to create Pivot Tables
VLookUp
Basic excel lookup functions
Using VLOOKUP to search within a large volume of data
VLOOKUP Error messages
The MATCH function
Applying VLOOKUP in VBA
Advanced Tips & Tricks
& a lot more covered in this "easy to learn" guide that is designed for you to learn everything there is about Pivot Tables & VLookUp.
Download your copy and learn everything you need to know about Pivot Tables & VLookUp.