- 13 hours on-demand video
- 7 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- Formulas and Functions, MIS Reporting techniques, Data Cleaning, Dashboards, Data Analysis, Charts, Tips-n-Tricks
- Lifetime access to the Videos
- Donwloadable PDF HandBook and Excel Case Studies
- HD Quality available upon single-click [bottom-right of video]
- MS Excel 2007/2010
"Advanced Excel Ninja" is a comprehensive online training program on Microsoft Excel. It is divided in 12 sections and covers exhaustive list of topics. There are 90+ tutorial videos and the duration is 13 hrs. Topics often ignored in other advanced online programs have been included. Demo Preview Lecture 89 and 90 to find the difference.
- VLOOKUP() with MATCH()
- HLOOKUP() with MATCH()
- INDEX() with multiple arrays & 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
So if you intend to take your Excel application skills multiple notches higher, gain from the experience of a training instructor who -
- Is a qualified Chartered Accountant
- Has worked with KPMG and J.P. Morgan
- Has trained 12,500+ professionals (Apr 2010 - June 2016) 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
And by the way he has conducted more than 200 (two hundred) 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.
Instructor: CA. Rishabh Pugalia, Founder, Excel Next
The participants will be provided lifetime access to videos plus downloadable Excel Case Studies and picture-based HandBook (PDF).
- Working Professionals, Students of Professional Courses
- Aspiring Corporate Trainers (Advanced Excel)
Participants can download the accompanying Zipped file that contains PDF HandBook + Excel Case Studies
- SUMPRODUCT() for computing weighted average
- POWER() and ^ for exponential/compounding/discounting computations
- =ROUND(A1/50,0)*50 will yield nearest 50 (multiple of 50) and similar technique can be used to solve for nearest 5, 10, 25 and any such combinations. It is more useful since =MROUND() does not work for +ve and -ve numbers simultaneously.
Always use =SUBTOTAL() formula while working with Filter. The raw formulas of SUM(), MAX(), AVERAGE() will pick up all values (whether hidden/visible as per the filtered list)
Date formulas -
DAY, MONTH, YEAR, DATE
TEXT, WORKDAY, NETWORKDAYS
NB: In Excel 2010/2013, =WORKDAY.INTL() has been introduced that helps find net working days between two dates and more importantly, lets you choose which day(s) of the week should be considered as weekends. E.g. lot of countries keep Friday as weekend.
Activating "DEVELOPER" Tab in 2007. Refer "PDF HandBook" or the "Supplementary Material" to see how to do so in 2010.
This video will show you how to use =SUMIFS() to add up the numbers based on specified criteria.
=VLOOKUP() can pull the answer only for the first occurrence/instance of the specified criteria, whereas, =SUMIFS() can add up the corresponding nos. of all occurrences of the specified criteria.
Chart Elements - Chart Area, Plot Area, Axis Values, Legends, Changing Chart Type, Chart Shortcuts etc.