Name: | Udemy - Advanced Excel - Beginner to Ninja level (includes Charts) |
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 | |
YouTube Video: | |
Category: | Tutorials |
Language: | English |
Total Size: | 2.04 GB |
Info Hash: | B724DA5D600292776A6C5A5C024B5728EA695805 |
Added By: | tutsnode |
Date Added: | 2020-12-07 14:18:02 |
Torrent Status: | Torrent Verified |
Ratings: | Not Yet Rated (Log in to rate it) |
URL | Seeders | Leechers | Completed |
---|---|---|---|
udp://inferno.demonoid.pw:3391/announce | 0 | 0 | 0 |
udp://tracker.openbittorrent.com:80/announce | 6 | 2 | 10 |
udp://tracker.opentrackr.org:1337/announce | 4 | 3 | 69 |
udp://torrent.gresille.org:80/announce | 0 | 0 | 0 |
udp://glotorrents.pw:6969/announce | 0 | 0 | 0 |
udp://tracker.leechers-paradise.org:6969/announce | 0 | 0 | 0 |
udp://tracker.pirateparty.gr:6969/announce | 0 | 0 | 0 |
udp://tracker.coppersurfer.tk:6969/announce | 0 | 0 | 0 |
udp://ipv4.tracker.harry.lu:80/announce | 0 | 0 | 0 |
udp://9.rarbg.to:2710/announce | 0 | 0 | 0 |
udp://shadowshq.yi.org:6969/announce | 0 | 0 | 0 |
udp://tracker.zer0day.to:1337/announce | 0 | 0 | 0 |
File | Size |
---|---|
TutsNode.com.txt | 63.00 B |
[TGx]Downloaded from torrentgalaxy.to .txt | 585.00 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.38 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.16 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.48 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.51 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.37 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.44 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.90 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.62 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.47 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.22 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.77 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.40 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.35 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.24 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.21 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 | 29.97 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.68 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.31 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.05 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.08 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.87 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.04 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.52 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.02 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.16 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks/011 Filter & SUBTOTAL() formula.mp4 | 54.78 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.01 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 | 36.95 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.31 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 | 12.98 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.66 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.60 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.07 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.63 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.06 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.54 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.18 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.86 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.28 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.37 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.11 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.53 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.33 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.45 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 | 13.96 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.27 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.02 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.27 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.23 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.70 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.02 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.36 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.31 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.22 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/025 VLOOKUP Introduction - Where_Why_How to use.mp4 | 9.77 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/026 VLOOKUP - Pre-requisites and Common Pitfalls.en.srt | 8.83 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/026 VLOOKUP - Pre-requisites and Common Pitfalls.mp4 | 13.57 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/027 VLOOKUP - True (1) vs. False (0).en.srt | 12.61 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/027 VLOOKUP - True (1) vs. False (0).mp4 | 17.81 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/028 VLOOKUP Practice with IFERROR.en.srt | 12.92 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/028 VLOOKUP Practice with IFERROR.mp4 | 30.80 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/029 HLOOKUP.en.srt | 4.12 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/029 HLOOKUP.mp4 | 7.24 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.83 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.36 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/031 VLOOKUP with MATCH - Practice #1.en.srt | 6.87 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/031 VLOOKUP with MATCH - Practice #1.mp4 | 12.59 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/032 VLOOKUP with MATCH - Practice #2.en.srt | 7.26 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/032 VLOOKUP with MATCH - Practice #2.mp4 | 10.94 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/033 HLOOKUP with MATCH - Practice #3.en.srt | 8.88 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/033 HLOOKUP with MATCH - Practice #3.mp4 | 19.05 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/034 SUMIFS - Introduction.en.srt | 6.20 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/034 SUMIFS - Introduction.mp4 | 21.55 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/035 SUMIF vs. SUMIFS, AVERAGEIFS, COUNTIFS.en.srt | 17.72 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/035 SUMIF vs. SUMIFS, AVERAGEIFS, COUNTIFS.mp4 | 44.03 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/036 COUNTIFS for duplicate detection; Remove Duplicate.en.srt | 7.85 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/03 Level 1 (C) - Lookups/036 COUNTIFS for duplicate detection; Remove Duplicate.mp4 | 27.64 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 | 12.99 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.14 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.27 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.39 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.04 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.83 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.70 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.90 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.75 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/04 Level 2 (A) - Reverse Lookup & Pivot Table/041 Pivot Table #1 (Payroll).mp4 | 33.23 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.10 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/04 Level 2 (A) - Reverse Lookup & Pivot Table/042 Pivot Table #2 (Payroll).mp4 | 19.02 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.50 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/04 Level 2 (A) - Reverse Lookup & Pivot Table/043 Pivot Table #3 (Payroll).mp4 | 40.01 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.48 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/04 Level 2 (A) - Reverse Lookup & Pivot Table/044 Pivot Table - Practice (Inventory).mp4 | 32.83 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.07 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.62 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.04 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.94 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/04 Level 2 (A) - Reverse Lookup & Pivot Table/047 SubTotal - Automatic row-wise subtotal #3.en.srt | 8.42 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/04 Level 2 (A) - Reverse Lookup & Pivot Table/047 SubTotal - Automatic row-wise subtotal #3.mp4 | 27.73 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/05 Level 2 (B) - Data Cleansing functions/048 Using CONCATENATE, & - to join data strings.en.srt | 14.46 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/05 Level 2 (B) - Data Cleansing functions/048 Using CONCATENATE, & - to join data strings.mp4 | 19.54 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/05 Level 2 (B) - Data Cleansing functions/049 Text-to-Columns - Delimited.en.srt | 8.19 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/05 Level 2 (B) - Data Cleansing functions/049 Text-to-Columns - Delimited.mp4 | 16.68 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/05 Level 2 (B) - Data Cleansing functions/050 Text-to-Columns - Fixed Width.en.srt | 8.62 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/05 Level 2 (B) - Data Cleansing functions/050 Text-to-Columns - Fixed Width.mp4 | 21.39 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/05 Level 2 (B) - Data Cleansing functions/051 Text-to-Columns - Tricks.en.srt | 5.61 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/05 Level 2 (B) - Data Cleansing functions/051 Text-to-Columns - Tricks.mp4 | 10.02 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/05 Level 2 (B) - Data Cleansing functions/052 Find & Replace – Advanced.en.srt | 13.01 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/05 Level 2 (B) - Data Cleansing functions/052 Find & Replace – Advanced.mp4 | 22.85 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/05 Level 2 (B) - Data Cleansing functions/053 Text Formulas I – UPPER, PROPER, LOWER, TRIM, T, N, REPT.en.srt | 17.76 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/05 Level 2 (B) - Data Cleansing functions/053 Text Formulas I – UPPER, PROPER, LOWER, TRIM, T, N, REPT.mp4 | 23.60 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/05 Level 2 (B) - Data Cleansing functions/054 Text Formulas II – LEFT-RIGHT-MID, LEN, SEARCH.en.srt | 14.24 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/05 Level 2 (B) - Data Cleansing functions/054 Text Formulas II – LEFT-RIGHT-MID, LEN, SEARCH.mp4 | 18.37 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/05 Level 2 (B) - Data Cleansing functions/055 Text Formulas III – SEARCH vs. FIND.en.srt | 7.82 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/05 Level 2 (B) - Data Cleansing functions/055 Text Formulas III – SEARCH vs. FIND.mp4 | 15.78 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/05 Level 2 (B) - Data Cleansing functions/056 Text Formulas IV – REPLACE, SUBSTITUTE.en.srt | 10.06 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/05 Level 2 (B) - Data Cleansing functions/056 Text Formulas IV – REPLACE, SUBSTITUTE.mp4 | 13.62 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/06 Level 2 (C) - Logical Formulas and Conditional Formatting/057 Logical formulas I - IF, Nested IFs.en.srt | 9.06 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/06 Level 2 (C) - Logical Formulas and Conditional Formatting/057 Logical formulas I - IF, Nested IFs.mp4 | 13.12 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/06 Level 2 (C) - Logical Formulas and Conditional Formatting/058 Logical formulas II - AND, OR with IF.en.srt | 11.64 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/06 Level 2 (C) - Logical Formulas and Conditional Formatting/058 Logical formulas II - AND, OR with IF.mp4 | 19.08 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/06 Level 2 (C) - Logical Formulas and Conditional Formatting/059 Logical formulas III - more case studies.en.srt | 12.46 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/06 Level 2 (C) - Logical Formulas and Conditional Formatting/059 Logical formulas III - more case studies.mp4 | 16.44 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/06 Level 2 (C) - Logical Formulas and Conditional Formatting/060 ISERROR, ISBLANK, ISNUMBER, ISTEXT, IFERROR.en.srt | 12.04 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/06 Level 2 (C) - Logical Formulas and Conditional Formatting/060 ISERROR, ISBLANK, ISNUMBER, ISTEXT, IFERROR.mp4 | 18.04 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/06 Level 2 (C) - Logical Formulas and Conditional Formatting/061 Conditional Formatting I (Blanks, Errors, Values, Duplicates).en.srt | 12.87 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/06 Level 2 (C) - Logical Formulas and Conditional Formatting/061 Conditional Formatting I (Blanks, Errors, Values, Duplicates).mp4 | 36.42 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/06 Level 2 (C) - Logical Formulas and Conditional Formatting/062 Conditional Formatting II (Formula-based).en.srt | 16.11 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/06 Level 2 (C) - Logical Formulas and Conditional Formatting/062 Conditional Formatting II (Formula-based).mp4 | 29.54 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/06 Level 2 (C) - Logical Formulas and Conditional Formatting/063 Conditional Formatting III (Data Bars, Color Scales, Icon Sets).en.srt | 8.60 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/06 Level 2 (C) - Logical Formulas and Conditional Formatting/063 Conditional Formatting III (Data Bars, Color Scales, Icon Sets).mp4 | 21.89 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/07 Level 2 (D) - What If Analysis/064 What IF Analysis – Scenario Manager.en.srt | 9.27 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/07 Level 2 (D) - What If Analysis/064 What IF Analysis – Scenario Manager.mp4 | 16.83 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/07 Level 2 (D) - What If Analysis/065 What IF Analysis – Goal Seek.en.srt | 10.98 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/07 Level 2 (D) - What If Analysis/065 What IF Analysis – Goal Seek.mp4 | 18.88 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/07 Level 2 (D) - What If Analysis/066 What IF Analysis – Data Tables.en.srt | 15.66 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/07 Level 2 (D) - What If Analysis/066 What IF Analysis – Data Tables.mp4 | 38.71 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/07 Level 2 (D) - What If Analysis/067 What IF Analysis – Using Form Control Buttons.en.srt | 9.91 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/07 Level 2 (D) - What If Analysis/067 What IF Analysis – Using Form Control Buttons.mp4 | 28.00 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/08 Level 3 - 3D Data Consolidation, Print tricks, Password, Formula Audit etc/068 Tables - Concept and Applications.en.srt | 7.23 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/08 Level 3 - 3D Data Consolidation, Print tricks, Password, Formula Audit etc/068 Tables - Concept and Applications.mp4 | 30.84 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/08 Level 3 - 3D Data Consolidation, Print tricks, Password, Formula Audit etc/069 3-D Data Consolidation from same_different Workbooks #1.en.srt | 10.04 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/08 Level 3 - 3D Data Consolidation, Print tricks, Password, Formula Audit etc/069 3-D Data Consolidation from same_different Workbooks #1.mp4 | 22.57 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/08 Level 3 - 3D Data Consolidation, Print tricks, Password, Formula Audit etc/070 3-D Data Consolidation from same_different Workbooks #2.en.srt | 10.33 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/08 Level 3 - 3D Data Consolidation, Print tricks, Password, Formula Audit etc/070 3-D Data Consolidation from same_different Workbooks #2.mp4 | 28.19 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/08 Level 3 - 3D Data Consolidation, Print tricks, Password, Formula Audit etc/071 Formula Auditing techniques.en.srt | 10.23 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/08 Level 3 - 3D Data Consolidation, Print tricks, Password, Formula Audit etc/071 Formula Auditing techniques.mp4 | 21.80 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/08 Level 3 - 3D Data Consolidation, Print tricks, Password, Formula Audit etc/072 File Security & Password Protection #1.en.srt | 9.36 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/08 Level 3 - 3D Data Consolidation, Print tricks, Password, Formula Audit etc/072 File Security & Password Protection #1.mp4 | 18.01 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/08 Level 3 - 3D Data Consolidation, Print tricks, Password, Formula Audit etc/073 File Security & Password Protection #2.en.srt | 11.11 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/08 Level 3 - 3D Data Consolidation, Print tricks, Password, Formula Audit etc/073 File Security & Password Protection #2.mp4 | 26.77 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/08 Level 3 - 3D Data Consolidation, Print tricks, Password, Formula Audit etc/074 Printing.en.srt | 25.15 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/08 Level 3 - 3D Data Consolidation, Print tricks, Password, Formula Audit etc/074 Printing.mp4 | 79.00 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/08 Level 3 - 3D Data Consolidation, Print tricks, Password, Formula Audit etc/075 Comments - Picture and Text.en.srt | 11.51 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/08 Level 3 - 3D Data Consolidation, Print tricks, Password, Formula Audit etc/075 Comments - Picture and Text.mp4 | 19.09 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/08 Level 3 - 3D Data Consolidation, Print tricks, Password, Formula Audit etc/076 Split Windows, Viewing multiple Windows.en.srt | 6.82 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/08 Level 3 - 3D Data Consolidation, Print tricks, Password, Formula Audit etc/076 Split Windows, Viewing multiple Windows.mp4 | 15.12 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/08 Level 3 - 3D Data Consolidation, Print tricks, Password, Formula Audit etc/077 Hyperlinking.en.srt | 6.38 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/08 Level 3 - 3D Data Consolidation, Print tricks, Password, Formula Audit etc/077 Hyperlinking.mp4 | 10.91 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/09 Level 4 - Charts/078 Charts – Basic Concepts and Elements.en.srt | 11.25 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/09 Level 4 - Charts/078 Charts – Basic Concepts and Elements.mp4 | 21.62 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/09 Level 4 - Charts/079 Basic Charts – Bar, Column, Pie.en.srt | 8.20 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/09 Level 4 - Charts/079 Basic Charts – Bar, Column, Pie.mp4 | 17.79 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/09 Level 4 - Charts/080 Special Charts_ Thermometer Charts.en.srt | 8.02 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/09 Level 4 - Charts/080 Special Charts_ Thermometer Charts.mp4 | 15.57 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/09 Level 4 - Charts/081 Special Charts_ Multi-axis charts.en.srt | 9.29 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/09 Level 4 - Charts/081 Special Charts_ Multi-axis charts.mp4 | 21.97 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/09 Level 4 - Charts/082 Special Charts_ Exploded Pie charts.en.srt | 9.74 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/09 Level 4 - Charts/082 Special Charts_ Exploded Pie charts.mp4 | 20.45 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/09 Level 4 - Charts/083 Chart tips-n-tricks #1.en.srt | 8.72 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/09 Level 4 - Charts/083 Chart tips-n-tricks #1.mp4 | 18.10 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/09 Level 4 - Charts/084 Chart tips-n-tricks #2.en.srt | 7.81 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/09 Level 4 - Charts/084 Chart tips-n-tricks #2.mp4 | 15.53 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/10 Level 5 - Macros Basics/085 Macros – Overview, Developer tab, Settings.en.srt | 14.62 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/10 Level 5 - Macros Basics/085 Macros – Overview, Developer tab, Settings.mp4 | 40.53 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/10 Level 5 - Macros Basics/086 Macros – Recording, Running; Using Buttons to run Macros.en.srt | 14.08 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/10 Level 5 - Macros Basics/086 Macros – Recording, Running; Using Buttons to run Macros.mp4 | 38.44 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/11 Level 6 - INDIRECT, OFFSET, MATCH/087 INDIRECT().en.srt | 11.11 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/11 Level 6 - INDIRECT, OFFSET, MATCH/087 INDIRECT().mp4 | 16.05 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/11 Level 6 - INDIRECT, OFFSET, MATCH/088 OFFSET() with MATCH().en.srt | 21.69 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/11 Level 6 - INDIRECT, OFFSET, MATCH/088 OFFSET() with MATCH().mp4 | 30.32 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/12 Bonus - Advanced Tricks/089 B-04C-Self-Practice.xlsx | 4.48 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/12 Bonus - Advanced Tricks/089 Pivot Table Trick - Generating 600+ reports in _1 min.en.srt | 9.72 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/12 Bonus - Advanced Tricks/089 Pivot Table Trick - Generating 600+ reports in _1 min.mp4 | 36.74 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/12 Bonus - Advanced Tricks/090 3D Data Lookup using VLookup, Match, Indirect, Naming.en.srt | 11.13 kB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/12 Bonus - Advanced Tricks/090 3D Data Lookup using VLookup, Match, Indirect, Naming.mp4 | 31.64 MB |
[TutsNode.com] - Advanced Excel - Beginner to Ninja level/12 Bonus - Advanced Tricks/090 3D-Lookup.xlsx | 36.51 kB |