Overview

Mastering the use of most popular LOOKUP'S and Pivot Tables will allow you to manipulate, extract and Analyze information like never before! The learners becomes experts after following this Video Course. This Complete course is About LOOKUP and References from Formulas and Complete Pivot Tables in Excel. Explained by Industry experts with all their experience here.This course is recorded with the latest version of Excel 2019. All the lectures are explained with the examples and you can download all these excel files and practice the formulas.This Course improves your Excel workflow faster with the true power of Excel lookup-and-reference functions. Course OverviewPivot Tables90% of Excel users do not use Pivot Tables but those that do save hours of time and become valuable assets in their companies.You learn Excel Pivot Tables & Pivot Charts quickly and effectively, download the companion exercise files so you can follow along with the instructor by performing the same actions he is showing you on the videos.By the end, you will be an Expert user of Pivot Tables, able to create reliable analyses which are able to be drilled-down quickly, and you'll be able to help others with their data analysis.Look up FunctionExcel makes it easy to search for values, both in rows and columns. While there are advanced functions also that enable Excel users to search for data "database-style", the HLookup and VLookup functions are their simpler-yet-powerful Functions.VLOOKUP was launched in 1985. It has been with Excel from the beginning; it was included in Excel 1 for Macintosh released in 1985. For 34 years, VLOOKUP has been the first lookup function learned by Excel users and our 3rd most used function (after SUM and AVERAGE).Topics CoveredVLOOKUP to the LeftVLOOKUP to Replace Nested IF FormulaVLOOKUP Multiple TablesVLOOKUP Multiple CriteriaVLOOKUP Different Sheets with Same FormulaVLOOKUP Auto Update Column NumberUse of wildcard in VLOOKUPNested VLOOKUP Trick3D LOOKUP with VLOOKUP2D LOOKUP with VLOOKUPHLOOKUP, INDEX, MATCH, TRANSPOSE, and INDIRECTLearning OutcomesBe an Expert using Powerful Excel functions: VLOOKUP, HLOOKUP, INDEX, MATCH, TRANSPOSE, and INDIRECTConsolidate data from multiple sheets with the INDIRECT functionCreate automatically-expanding references with the OFFSET functionCreate flexible lookups for Excel dashboards with drop-down listsCreate range-based lookups with the "approximate match"Create two-dimensional lookups by combining VLOOKUP and MATCHFind specific items using the "exact match"Overcome the limitations of VLOOKUP by using INDEX and MATCHRecognize the value of lookups and references to your specific workflowUse named ranges and Excel tables as reference listsUse TRANSPOSE function to flip your data 90 degrees with links to the original cells

Skills

Reviews