46.gif

Search (advanced search)
Use this Search form before posting, asking or make a new thread.
Tips: Use Quotation mark to search words (eg. "How To Make Money Online")

05-04-2014, 06:22 PM
Post: #1
[DIS] Advanced Excel for Professionals
"Advanced Excel for Professionals" is a comprehensive online training program. It is divided in 11 sections and covers exhaustive list of topics. There are 88 tutorial videos and the duration is 13 hrs. Topics often ignored in other intermediate/advanced online programs have been included -
[list][*]VLOOKUP() with MATCH()[*]HLOOKUP() with MATCH()[*]INDEX() with multiple arrays and two MATCH()[*]Using TRANSPOSE() formula[*]Form Control Buttons for Dashboard[*]SUMIF() vs. SUMIFS()[*]SUM() vs. SUBTOTAL() while using Filter[*]Hidden Text-to-Columns tricks[*]Using IFERROR() vs. IF() + ISERROR()[*]Applications of INDIRECT() and OFFSET()[*]Pivot Table tricks on calculating automatic sum, count, percentage and generating grouped data headings[*]3-Data Consolidation[*]Power of "GO TO - Special" along with Ctrl+Enter[*]Using "Find and Replace" with wildcard characters[*]Combo techniques for Data cleaning[*]Formula-based Conditional formatting[*]Charts - Thermometer, 2 axis, Trendline, Axis value settings[*]Inserting Picture in Comments... and the list of such tricks is very long[/list]So if you intend to take your Excel application skills multiple notches higher, gain from the experience of a training instructor who -
[list][*]Is a qualified Chartered Accountant[*]Has worked with KPMG and J.P. Morgan[*]Has trained 3,500+ professionals (Apr 2010 - Oct 2013) in face-to-face training programs[*]Has incorporated in this online program 100s of tip-n-tricks, which he has acquired over the years through various forums, experimentation, problem solving challenges and training interaction[/list][i]And by the way he has conducted more than 60 (sixty) workshops for one of the Big Four firms, where the participants are from numerous departments and domains. The insights acquired have been meticulously incorporated in to the program.[/i]
Instructor: CA. Rishabh Pugalia, Founder, [url=undefined]Excel Next[/url]
The participants will be provided lifetime access to videos plusdownloadable Excel Case Studies and picture-based HandBook (PDF).

Magic Button :
[code]https://www.udemy.com/excelnext_excel/?couponCode=XL66[/code]
++ Reps would be appreciated
05-04-2014, 09:55 PM
Post: #2
RE:
coupon does not work
05-05-2014, 12:48 AM
Post: #3
RE:
READ, READ, READ.... it's a discount code, not a freebie. Thread even states it [DIS]

[quote='shaGuar' pid='703497' dateline='1399204512']
coupon does not work
[/quote]




57.gif