23 OCT 2025 - We are back! If you have been following us over the last few years, you will know that the last 2 months have been rough. We website was practically not loading. Sorry for the mess. We are back though and everything should run smoothly now. New servers. Updated domains. And new owners. We invite you all to start uploading torrents again!
TORRENT DETAILS
Advanced Excel - Beginner To Ninja Level (includes Charts)
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
“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).
Who this course is for:
Working Professionals, Students of Professional Courses
Aspiring Corporate Trainers (Advanced Excel)
Requirements
MS Excel 2007/2010
Last Updated 8/2020
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
TutsNode.com.txt
63 B
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/01 Level 1 (A) - Warm Up, Case Study Files + eBook (zipped folder)/001 Introduction + Downloadable files.en.srt
10.4 KB
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/01 Level 1 (A) - Warm Up, Case Study Files + eBook (zipped folder)/001 Introduction + Downloadable files.mp4
10.2 MB
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/01 Level 1 (A) - Warm Up, Case Study Files + eBook (zipped folder)/001 Lecture-89-Pivot-Trick.xlsx
4.5 MB
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/01 Level 1 (A) - Warm Up, Case Study Files + eBook (zipped folder)/001 Lecture-90-3D-Lookup.xlsx
36.5 KB
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/01 Level 1 (A) - Warm Up, Case Study Files + eBook (zipped folder)/001 PROGRESS-TRACKER.pdf
340.4 KB
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/01 Level 1 (A) - Warm Up, Case Study Files + eBook (zipped folder)/001 Udemy-Excelnext.zip
7.4 MB
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/01 Level 1 (A) - Warm Up, Case Study Files + eBook (zipped folder)/002 Warm-up - Key Shortcuts.en.srt
12.9 KB
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/01 Level 1 (A) - Warm Up, Case Study Files + eBook (zipped folder)/002 Warm-up - Key Shortcuts.mp4
26.6 MB
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/01 Level 1 (A) - Warm Up, Case Study Files + eBook (zipped folder)/003 Formula Tricks - SUM, AUTOSUM, MAX, MIN, AVERAGE.en.srt
17.5 KB
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/01 Level 1 (A) - Warm Up, Case Study Files + eBook (zipped folder)/003 Formula Tricks - SUM, AUTOSUM, MAX, MIN, AVERAGE.mp4
23.2 MB
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/01 Level 1 (A) - Warm Up, Case Study Files + eBook (zipped folder)/004 Formula Tricks - SUMPRODUCT, POWER, ROUND, MROUND.en.srt
15.8 KB
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/01 Level 1 (A) - Warm Up, Case Study Files + eBook (zipped folder)/004 Formula Tricks - SUMPRODUCT, POWER, ROUND, MROUND.mp4
22.4 MB
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/01 Level 1 (A) - Warm Up, Case Study Files + eBook (zipped folder)/005 Formula Tricks - COUNT vs. COUNTA.en.srt
2.3 KB
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/01 Level 1 (A) - Warm Up, Case Study Files + eBook (zipped folder)/005 Formula Tricks - COUNT vs. COUNTA.mp4
5.2 MB
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/01 Level 1 (A) - Warm Up, Case Study Files + eBook (zipped folder)/006 Formatting Tricks_ Table Concept, Using Format Painter uninterruptedly etc.en.srt
15.2 KB
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/01 Level 1 (A) - Warm Up, Case Study Files + eBook (zipped folder)/006 Formatting Tricks_ Table Concept, Using Format Painter uninterruptedly etc.mp4
30 MB
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/01 Level 1 (A) - Warm Up, Case Study Files + eBook (zipped folder)/007 Auto fill options - Variations & Settings.en.srt
10.7 KB
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/01 Level 1 (A) - Warm Up, Case Study Files + eBook (zipped folder)/007 Auto fill options - Variations & Settings.mp4
17.3 MB
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/01 Level 1 (A) - Warm Up, Case Study Files + eBook (zipped folder)/008 Paste Special - Value, Transpose; Formula TRANSPOSE().en.srt
9.1 KB
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/01 Level 1 (A) - Warm Up, Case Study Files + eBook (zipped folder)/008 Paste Special - Value, Transpose; Formula TRANSPOSE().mp4
15.1 MB
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/01 Level 1 (A) - Warm Up, Case Study Files + eBook (zipped folder)/009 Range Selection; GO TO - Special.en.srt
14.9 KB
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/01 Level 1 (A) - Warm Up, Case Study Files + eBook (zipped folder)/009 Range Selection; GO TO - Special.mp4
