Don't like banners? Log in and we will make sure you see no banners. For free.
Advanced Excel - Beginner to Ninja level (includes Charts)

Advanced Excel - Beginner to Ninja level (includes Charts)

Other
Size
2 GB
Seeders
0
Leechers
1
Files
99
Category
Other
Added
at 7:30am GMT+1
Infohash
b724da5d600292776a6c5a5c024b5728ea695805
Direct linkTorrent fileDownload now
Don't like banners? Log in and we will make sure you see no banners. For free.

Description


Description



“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

File list
  • Advanced Excel - Beginner to Ninja level (includes Charts)
  • 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 39 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/010 Multi-level Sort, Custom Sort, Color Sort.en.srt 13.5 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/010 Multi-level Sort, Custom Sort, Color Sort.mp4 24 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/011 Filter & SUBTOTAL() formula.en.srt 22.2 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/011 Filter & SUBTOTAL() formula.mp4 54.8 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/012 Advanced Filter I (Differential Filter Criteria).en.srt 13 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/012 Advanced Filter I (Differential Filter Criteria).mp4 37 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/013 Advanced Filter II (Differential Filter Criteria).en.srt 6.3 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/013 Advanced Filter II (Differential Filter Criteria).mp4 13 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/014 Cell Referencing using $ - Introduction.en.srt 3.7 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/014 Cell Referencing using $ - Introduction.mp4 4.6 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/015 Cell Referencing using $ - Practice #1.en.srt 6.1 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/015 Cell Referencing using $ - Practice #1.mp4 11.6 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/016 Cell Referencing using $ - Practice #2.en.srt 5.1 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/016 Cell Referencing using $ - Practice #2.mp4 8.5 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/017 Cell Referencing using $ - Practice #3.en.srt 5.2 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/017 Cell Referencing using $ - Practice #3.mp4 8.9 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/018 Cell Referencing using $ - Special Trick.en.srt 3.3 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/018 Cell Referencing using $ - Special Trick.mp4 4.4 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/019 Date Concepts and Format.en.srt 14.1 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/019 Date Concepts and Format.mp4 20.5 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/020 Date Formulas-DAY, MONTH, YEAR, DATE, EDATE, EOMONTH, TEXT, WORKDAY, NETWORKDAYS.en.srt 23.3 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/020 Date Formulas-DAY, MONTH, YEAR, DATE, EDATE, EOMONTH, TEXT, WORKDAY, NETWORKDAYS.mp4 25.4 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/021 Date Cleaning techniques using Text-to-Columns.en.srt 14 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/021 Date Cleaning techniques using Text-to-Columns.mp4 21.3 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/022 Dashboard I_ Grouping, Data Validation (List), Cell-Range Naming.en.srt 26 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/022 Dashboard I_ Grouping, Data Validation (List), Cell-Range Naming.mp4 46.3 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/023 Activating-Developer-Tab-In-Version-E0.pdf 232.2 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/023 Dashboard II_ Form Controls Buttons.en.srt 9.7 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/023 Dashboard II_ Form Controls Buttons.mp4 13 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/024 Dashboard III_ Hide_Unhide Columns-Rows, Freeze Panes.en.srt 7.4 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/024 Dashboard III_ Hide_Unhide Columns-Rows, Freeze Panes.mp4 22.3 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/025 VLOOKUP Introduction - Where_Why_How to use.en.srt 7.2 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/025 VLOOKUP Introduction - Where_Why_How to use.mp4 9.8 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/026 VLOOKUP - Pre-requisites and Common Pitfalls.en.srt 8.8 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/026 VLOOKUP - Pre-requisites and Common Pitfalls.mp4 13.6 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/027 VLOOKUP - True (1) vs. False (0).en.srt 12.6 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/027 VLOOKUP - True (1) vs. False (0).mp4 17.8 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/028 VLOOKUP Practice with IFERROR.en.srt 12.9 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/028 VLOOKUP Practice with IFERROR.mp4 30.8 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/029 HLOOKUP.en.srt 4.1 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/029 HLOOKUP.mp4 7.2 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/030 Using MATCH with VLOOKUP_HLOOKUP - 2x2 matrix lookup.en.srt 14.8 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/030 Using MATCH with VLOOKUP_HLOOKUP - 2x2 matrix lookup.mp4 24.4 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/031 VLOOKUP with MATCH - Practice #1.en.srt 6.9 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/031 VLOOKUP with MATCH - Practice #1.mp4 12.6 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/032 VLOOKUP with MATCH - Practice #2.en.srt 7.3 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/032 VLOOKUP with MATCH - Practice #2.mp4 10.9 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/033 HLOOKUP with MATCH - Practice #3.en.srt 8.9 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/033 HLOOKUP with MATCH - Practice #3.mp4 19.1 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/034 SUMIFS - Introduction.en.srt 6.2 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/034 SUMIFS - Introduction.mp4 21.6 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/035 SUMIF vs. SUMIFS, AVERAGEIFS, COUNTIFS.en.srt 17.7 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/035 SUMIF vs. SUMIFS, AVERAGEIFS, COUNTIFS.mp4 44 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/036 COUNTIFS for duplicate detection; Remove Duplicate.en.srt 7.9 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/036 COUNTIFS for duplicate detection; Remove Duplicate.mp4 27.6 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/04 Level 2 (A) - Reverse Lookup & Pivot Table/037 Data Validation (Numbers, Dates, Text length).en.srt 13 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/04 Level 2 (A) - Reverse Lookup & Pivot Table/037 Data Validation (Numbers, Dates, Text length).mp4 22.1 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/04 Level 2 (A) - Reverse Lookup & Pivot Table/038 INDEX with MATCH – Reverse 2-way Lookup.en.srt 21.3 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/04 Level 2 (A) - Reverse Lookup & Pivot Table/038 INDEX with MATCH – Reverse 2-way Lookup.mp4 37.4 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/04 Level 2 (A) - Reverse Lookup & Pivot Table/039 INDEX with MATCH - Practice #1.en.srt 5 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/04 Level 2 (A) - Reverse Lookup & Pivot Table/039 INDEX with MATCH - Practice #1.mp4 8.8 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/04 Level 2 (A) - Reverse Lookup & Pivot Table/040 INDEX with MATCH - Version 2.en.srt 7.7 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/04 Level 2 (A) - Reverse Lookup & Pivot Table/040 INDEX with MATCH - Version 2.mp4 12.9 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/04 Level 2 (A) - Reverse Lookup & Pivot Table/041 Pivot Table #1 (Payroll).en.srt 17.8 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/04 Level 2 (A) - Reverse Lookup & Pivot Table/041 Pivot Table #1 (Payroll).mp4 33.2 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/04 Level 2 (A) - Reverse Lookup & Pivot Table/042 Pivot Table #2 (Payroll).en.srt 9.1 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/04 Level 2 (A) - Reverse Lookup & Pivot Table/042 Pivot Table #2 (Payroll).mp4 19 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/04 Level 2 (A) - Reverse Lookup & Pivot Table/043 Pivot Table #3 (Payroll).en.srt 18.5 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/04 Level 2 (A) - Reverse Lookup & Pivot Table/043 Pivot Table #3 (Payroll).mp4 40 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/04 Level 2 (A) - Reverse Lookup & Pivot Table/044 Pivot Table - Practice (Inventory).en.srt 15.5 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/04 Level 2 (A) - Reverse Lookup & Pivot Table/044 Pivot Table - Practice (Inventory).mp4 32.8 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/04 Level 2 (A) - Reverse Lookup & Pivot Table/045 SubTotal - Automatic row-wise subtotal #1.en.srt 19.1 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/04 Level 2 (A) - Reverse Lookup & Pivot Table/045 SubTotal - Automatic row-wise subtotal #1.mp4 55.6 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/04 Level 2 (A) - Reverse Lookup & Pivot Table/046 SubTotal - Automatic row-wise subtotal #2.en.srt 10 KB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/04 Level 2 (A) - Reverse Lookup & Pivot Table/046 SubTotal - Automatic row-wise subtotal #2.mp4 25.9 MB
  • [TutsNode.com] - Advanced Excel - Beginner to Ninja level/08 Level 3 - 3D Data Consolidation, Print tricks, Password, Formula Audit etc/074 Printing.mp4 79 MB

Rating
Not rated yet
Log in to rate

Comments

No comments yet.


Similar torrents
NameSizeDate
2 GB01