Download Now

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

Excel Advanced: VLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS
MP4 | Video: AVC 1280x720 | 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).

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



DOWNLOAD LINKS:

Download from Rapidgator.net
http://rapidgator.net/file/c3de3f249ef57f39a6f7f2a834ea932b/kvj2x.E.A.VLOOKUP.INDEX.MATCH.SUMIFS.COUNTIFS.part1.rar.html
http://rapidgator.net/file/fae8c31186a1eaf8e63366c9395d5930/kvj2x.E.A.VLOOKUP.INDEX.MATCH.SUMIFS.COUNTIFS.part2.rar.html
http://rapidgator.net/file/2acdc5554bf59fbba81e8b5b5c29ff87/kvj2x.E.A.VLOOKUP.INDEX.MATCH.SUMIFS.COUNTIFS.part3.rar.html
http://rapidgator.net/file/503cc3b814140e083536f7d45b642bfb/kvj2x.E.A.VLOOKUP.INDEX.MATCH.SUMIFS.COUNTIFS.part4.rar.html
http://rapidgator.net/file/c806fa935e79ea7ac299435fd1f57bfb/kvj2x.E.A.VLOOKUP.INDEX.MATCH.SUMIFS.COUNTIFS.part5.rar.html

Download from Nitroflare.com
http://nitroflare.com/view/F1490640779CD09/kvj2x.E.A.VLOOKUP.INDEX.MATCH.SUMIFS.COUNTIFS.part1.rar
http://nitroflare.com/view/9CF030599211AFA/kvj2x.E.A.VLOOKUP.INDEX.MATCH.SUMIFS.COUNTIFS.part2.rar
http://nitroflare.com/view/B1D9551C93DB94C/kvj2x.E.A.VLOOKUP.INDEX.MATCH.SUMIFS.COUNTIFS.part3.rar
http://nitroflare.com/view/90F41CFD0BD3DA8/kvj2x.E.A.VLOOKUP.INDEX.MATCH.SUMIFS.COUNTIFS.part4.rar
http://nitroflare.com/view/38B9DAF18F746DB/kvj2x.E.A.VLOOKUP.INDEX.MATCH.SUMIFS.COUNTIFS.part5.rar

Download from Turbobit.net
http://turbobit.net/hhulsgehullg/kvj2x.E.A.VLOOKUP.INDEX.MATCH.SUMIFS.COUNTIFS.part1.rar.html
http://turbobit.net/2b1hd7i9mtjc/kvj2x.E.A.VLOOKUP.INDEX.MATCH.SUMIFS.COUNTIFS.part2.rar.html
http://turbobit.net/1i5py4ykulp2/kvj2x.E.A.VLOOKUP.INDEX.MATCH.SUMIFS.COUNTIFS.part3.rar.html
http://turbobit.net/90ga7ohv1ftj/kvj2x.E.A.VLOOKUP.INDEX.MATCH.SUMIFS.COUNTIFS.part4.rar.html
http://turbobit.net/o3gbbdroof9a/kvj2x.E.A.VLOOKUP.INDEX.MATCH.SUMIFS.COUNTIFS.part5.rar.html

Direct Download

Tags: Advanced, VLOOKUP, SUMIFS, COUNTIFS

Comments
Name:*
E-Mail:*
Add Comments:
Enter Code: *