Excel Advanced: VLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS

Excel Advanced: VLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS

MP4 | Video: AVC 1280×720 | Audio: AAC 44KHz 2ch | Duration: 2.5 Hours | 810 MB
Genre: eLearning | Language: English
Learn Beginner to Advanced tricks on VLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS, INDIRECT – multi dimensional, reverse

Before you read what I have to say, see what my students are saying about my courses on Excel:

“I would like to tell you that I am very impressed with your courses so far – I particularly like the short videos that allow me to get to a topic quickly and then move on (your competitors mostly offer 20-30 min videos which is a bit much to keep one’s attention span). The other gem in your training are the shortcuts, I found no other course with the same insights.” by Peter Klugsberger, Australia, ex-McKinsey & Co., served various senior roles (CEO, COO) in various companies

“I thought you knew me – You solved the exact problem which I face at my office in your course” by Rajesh Dhoot, India, ex-Sr. Manager, Finance and Accounts, Ultratech Cements – An Aditya Birla Group Co.

–––––––––––––––––––––––––––––––––––––––––––––––––––––––––-

The top seven functions for data lookup are VLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS, INDIRECT, and OFFSET. These alone will cover more than 50% of your Excel tasks – data analysis and MIS reporting requirements.

We have 26 videos of duration 2 hrs. Through practical examples, they start from the foundation and take you to the Ninja level application.

–––––––––––––––––––––––––––––––––––––––––––––––––––––––––-

Your Question – Why should I take this mini-course on Excel?

Our Response – Because we cover the following –

WHY should we use a certain formula or technique in a given situation
What are the alternative approaches to solving the same problem
Combo formulas and hidden tricks to truly make you a Master of Excel Lookup.
Example – By itself, VLOOKUP is a one-dimensional (1-D) lookup. We take you to Ninja level where you will also learn to use 2-D, 3-D, combo and reverse lookup.

–––––––––––––––––––––––––––––––––––––––––––––––––––––––––

Your Question – So will I learn Pivot table, Sort & Filter?

Our Response – No. This course covers Lookups (1D, 2D, 3D, Combo, Reverse), VLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS, OFFSET & Conditional Calculations (Sum, Average, Count, and Special Running Total).

Download uploaded
http://uploaded.net/file/vcd11dt5/Excel%20Advanced%20VLOOKUP%2C%20INDEX%2C%20MATCH%2C%20SUMIFS.part1.rar
http://uploaded.net/file/hraogu9f/Excel%20Advanced%20VLOOKUP%2C%20INDEX%2C%20MATCH%2C%20SUMIFS.part2.rar
http://uploaded.net/file/pqas2e2f/Excel%20Advanced%20VLOOKUP%2C%20INDEX%2C%20MATCH%2C%20SUMIFS.part3.rar
http://uploaded.net/file/0eivvot9/Excel%20Advanced%20VLOOKUP%2C%20INDEX%2C%20MATCH%2C%20SUMIFS.part4.rar
http://uploaded.net/file/ee2ypcb8/Excel%20Advanced%20VLOOKUP%2C%20INDEX%2C%20MATCH%2C%20SUMIFS.part5.rar

Download nitroflare
http://nitroflare.com/view/C175F6FBD9988B5/Excel_Advanced_VLOOKUP%2C_INDEX%2C_MATCH%2C_SUMIFS.part1.rar
http://nitroflare.com/view/4825B77C032E94D/Excel_Advanced_VLOOKUP%2C_INDEX%2C_MATCH%2C_SUMIFS.part2.rar
http://nitroflare.com/view/B518716CAB4D945/Excel_Advanced_VLOOKUP%2C_INDEX%2C_MATCH%2C_SUMIFS.part3.rar
http://nitroflare.com/view/7966312D2E8029F/Excel_Advanced_VLOOKUP%2C_INDEX%2C_MATCH%2C_SUMIFS.part4.rar
http://nitroflare.com/view/C5E831DB26D9B17/Excel_Advanced_VLOOKUP%2C_INDEX%2C_MATCH%2C_SUMIFS.part5.rar

Download 百度云

你是VIP 1个月(1 month)赞助会员，