[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

   069 3-D Data Consolidation from same_different Workbooks #1.en.srt

   070 3-D Data Consolidation from same_different Workbooks #2.en.srt

   071 Formula Auditing techniques.en.srt

   072 File Security & Password Protection #1.en.srt

   073 File Security & Password Protection #2.en.srt

   074 Printing.en.srt

   075 Comments - Picture and Text.mp4

   076 Split Windows, Viewing multiple Windows.mp4

   077 Hyperlinking.mp4

  01 Level 1 (A) - Warm Up, Case Study Files + eBook (zipped folder)

   001 Introduction + Downloadable files.mp4

   001 Lecture-90-3D-Lookup.xlsx

   001 Udemy-Excelnext.zip

   002 Warm-up - Key Shortcuts.mp4

   003 Formula Tricks - SUM, AUTOSUM, MAX, MIN, AVERAGE.mp4

   004 Formula Tricks - SUMPRODUCT, POWER, ROUND, MROUND.mp4

   005 Formula Tricks - COUNT vs. COUNTA.mp4

   006 Formatting Tricks_ Table Concept, Using Format Painter uninterruptedly etc.mp4

   007 Auto fill options - Variations & Settings.mp4

   008 Paste Special - Value, Transpose; Formula TRANSPOSE().mp4

   009 Range Selection; GO TO - Special.mp4

  02 Level 1 (B) - Sort, Filter, Dates, Dashboard tricks

   010 Multi-level Sort, Custom Sort, Color Sort.mp4

   011 Filter & SUBTOTAL() formula.mp4

   012 Advanced Filter I (Differential Filter Criteria).mp4

   013 Advanced Filter II (Differential Filter Criteria).mp4

   014 Cell Referencing using $ - Introduction.mp4

   015 Cell Referencing using $ - Practice #1.mp4

   016 Cell Referencing using $ - Practice #2.mp4

   017 Cell Referencing using $ - Practice #3.mp4

   018 Cell Referencing using $ - Special Trick.mp4

   019 Date Concepts and Format.mp4

   020 Date Formulas-DAY, MONTH, YEAR, DATE, EDATE, EOMONTH, TEXT, WORKDAY, NETWORKDAYS.mp4

   021 Date Cleaning techniques using Text-to-Columns.mp4

   022 Dashboard I_ Grouping, Data Validation (List), Cell-Range Naming.mp4

   023 Dashboard II_ Form Controls Buttons.en.srt

   024 Dashboard III_ Hide_Unhide Columns-Rows, Freeze Panes.en.srt

  03 Level 1 (C) - Lookups

   025 VLOOKUP Introduction - Where_Why_How to use.mp4

   026 VLOOKUP - Pre-requisites and Common Pitfalls.mp4

   027 VLOOKUP - True (1) vs. False (0).mp4

   028 VLOOKUP Practice with IFERROR.mp4

   029 HLOOKUP.mp4

   030 Using MATCH with VLOOKUP_HLOOKUP - 2x2 matrix lookup.mp4

   031 VLOOKUP with MATCH - Practice #1.mp4

   032 VLOOKUP with MATCH - Practice #2.mp4

   033 HLOOKUP with MATCH - Practice #3.mp4

   034 SUMIFS - Introduction.mp4

   035 SUMIF vs. SUMIFS, AVERAGEIFS, COUNTIFS.mp4

   036 COUNTIFS for duplicate detection; Remove Duplicate.mp4

  04 Level 2 (A) - Reverse Lookup & Pivot Table

   037 Data Validation (Numbers, Dates, Text length).mp4

   038 INDEX with MATCH – Reverse 2-way Lookup.mp4

   039 INDEX with MATCH - Practice #1.mp4

   040 INDEX with MATCH - Version 2.mp4

   041 Pivot Table #1 (Payroll).mp4

   042 Pivot Table #2 (Payroll).mp4

   043 Pivot Table #3 (Payroll).mp4

   044 Pivot Table - Practice (Inventory).mp4

   045 SubTotal - Automatic row-wise subtotal #1.mp4

   046 SubTotal - Automatic row-wise subtotal #2.mp4

   047 SubTotal - Automatic row-wise subtotal #3.mp4

  05 Level 2 (B) - Data Cleansing functions

   048 Using CONCATENATE, & - to join data strings.mp4

   049 Text-to-Columns - Delimited.mp4

   050 Text-to-Columns - Fixed Width.mp4

   051 Text-to-Columns - Tricks.mp4

   052 Find & Replace – Advanced.mp4

   053 Text Formulas I – UPPER, PROPER, LOWER, TRIM, T, N, REPT.mp4

   054 Text Formulas II – LEFT-RIGHT-MID, LEN, SEARCH.mp4

   055 Text Formulas III – SEARCH vs. FIND.mp4

   056 Text Formulas IV – REPLACE, SUBSTITUTE.mp4

  06 Level 2 (C) - Logical Formulas and Conditional Formatting

   057 Logical formulas I - IF, Nested IFs.mp4

   058 Logical formulas II - AND, OR with IF.mp4

   059 Logical formulas III - more case studies.mp4

   060 ISERROR, ISBLANK, ISNUMBER, ISTEXT, IFERROR.mp4

   061 Conditional Formatting I (Blanks, Errors, Values, Duplicates).mp4

   062 Conditional Formatting II (Formula-based).mp4

   063 Conditional Formatting III (Data Bars, Color Scales, Icon Sets).mp4

  07 Level 2 (D) - What If Analysis

   064 What IF Analysis – Scenario Manager.mp4

   065 What IF Analysis – Goal Seek.mp4

   066 What IF Analysis – Data Tables.mp4

   067 What IF Analysis – Using Form Control Buttons.mp4

  09 Level 4 - Charts

   078 Charts – Basic Concepts and Elements.mp4

   079 Basic Charts – Bar, Column, Pie.mp4

   080 Special Charts_ Thermometer Charts.mp4

   081 Special Charts_ Multi-axis charts.mp4

   082 Special Charts_ Exploded Pie charts.mp4

   083 Chart tips-n-tricks #1.mp4

   084 Chart tips-n-tricks #2.mp4

  10 Level 5 - Macros Basics

   085 Macros – Overview, Developer tab, Settings.mp4

   086 Macros – Recording, Running; Using Buttons to run Macros.mp4

  11 Level 6 - INDIRECT, OFFSET, MATCH

   087 INDIRECT().mp4

   088 OFFSET() with MATCH().mp4

  12 Bonus - Advanced Tricks

   089 Pivot Table Trick - Generating 600+ reports in _1 min.en.srt

   090 3D Data Lookup using VLookup, Match, Indirect, Naming.en.srt

   090 3D-Lookup.xlsx

 TutsNode.com.txt