Other
Microsoft Excel - Advanced Excel Formulas & Functions
Torrent info
Torrent Files List
[TutsNode.com] - Microsoft Excel - Advanced Excel Formulas & Functions (Size: 2.71 GB) (Files: 313)
[TutsNode.com] - Microsoft Excel - Advanced Excel Formulas & Functions
05 Lookup & Reference Functions
051 DEMO_ Building Dashboards with XLOOKUP (Office 365 Only).mp4
051 DEMO_ Building Dashboards with XLOOKUP (Office 365 Only).en.srt
049 TROUBLESHOOTING_ VLOOKUP with Duplicate Keys.en.srt
042 Fixing Errors with IFERROR & VLOOKUP.en.srt
052 Selecting List Items with CHOOSE.en.srt
054 Combining OFFSET with COUNTA to Create a Flexible Range.en.srt
055 PRO TIP_ Using OFFSET to Create Interactive Charts.en.srt
047 Combining INDEX & MATCH to Dynamically Search Ranges.en.srt
043 VLOOKUP Reference Array Options.en.srt
041 Joining Data with VLOOKUP.en.srt
040 Introduction to VLOOKUP_HLOOKUP.en.srt
044 Approximate Match Lookups.en.srt
048 Combining MATCH & VLOOKUP for More Flexible Lookups.en.srt
050 SNEAK PEEK_ XLOOKUP (Office 365 Only).en.srt
037 Introduction.en.srt
056 HOMEWORK_ Excel Lookup & Reference Functions.en.srt
038 Working with Named Ranges.en.srt
039 Counting Rows & Columns with ROW_ROWS & COLUMN_COLUMNS.en.srt
046 Matching Text & Values with MATCH.en.srt
053 Defining Ranges with OFFSET.en.srt
045 Navigating Cell Ranges with INDEX.en.srt
041 Joining Data with VLOOKUP.mp4
052 Selecting List Items with CHOOSE.mp4
040 Introduction to VLOOKUP_HLOOKUP.mp4
044 Approximate Match Lookups.mp4
043 VLOOKUP Reference Array Options.mp4
055 PRO TIP_ Using OFFSET to Create Interactive Charts.mp4
048 Combining MATCH & VLOOKUP for More Flexible Lookups.mp4
047 Combining INDEX & MATCH to Dynamically Search Ranges.mp4
050 SNEAK PEEK_ XLOOKUP (Office 365 Only).mp4
049 TROUBLESHOOTING_ VLOOKUP with Duplicate Keys.mp4
042 Fixing Errors with IFERROR & VLOOKUP.mp4
038 Working with Named Ranges.mp4
039 Counting Rows & Columns with ROW_ROWS & COLUMN_COLUMNS.mp4
046 Matching Text & Values with MATCH.mp4
054 Combining OFFSET with COUNTA to Create a Flexible Range.mp4
037 Introduction.mp4
053 Defining Ranges with OFFSET.mp4
045 Navigating Cell Ranges with INDEX.mp4
056 HOMEWORK_ Excel Lookup & Reference Functions.mp4
01 Getting Started
001 Course Structure & Outline.en.srt
003 Excel-Homework-Workbooks.zip
003 DOWNLOAD_ Course Resources.html
004 Setting Expectations.en.srt
002 READ ME_ Important Notes for New Students.html
001 Course Structure & Outline.mp4
004 Setting Expectations.mp4
003 Excel-Demo-Workbooks-COMPLETE.zip
003 Excel-Demo-Workbooks.zip
003 Excel-Formulas-Functions.pdf
09 Array Formulas
097 Creating a _MAX IF_ Array Formula with Multiple Criteria.en.srt
098 Converting Boolean Values Using the Double Unary (_--_).en.srt
099 HOMEWORK_ Excel Array Functions.en.srt
089 Defining Vertical, Horizontal, and 2-Dimensional Arrays.en.srt
092 Restructuring Data with TRANSPOSE.en.srt
091 Defining & Referencing Named Array Constants.en.srt
087 Rules of Excel Array Functions.en.srt
090 Using Array Constants in Formulas.en.srt
096 Creating a _MAX IF_ Array Formula.en.srt
094 Returning the Largest Values in a Range.en.srt
088 Pros & Cons of Array Functions.en.srt
093 Linking Data Between Sheets (Array vs. Non-Array Comparison).en.srt
086 READ ME_ Array Formulas are Changing!.html
085 Introduction.en.srt
095 Counting Characters Across Cells.en.srt
097 Creating a _MAX IF_ Array Formula with Multiple Criteria.mp4
092 Restructuring Data with TRANSPOSE.mp4
089 Defining Vertical, Horizontal, and 2-Dimensional Arrays.mp4
098 Converting Boolean Values Using the Double Unary (_--_).mp4
094 Returning the Largest Values in a Range.mp4
091 Defining & Referencing Named Array Constants.mp4
096 Creating a _MAX IF_ Array Formula.mp4
093 Linking Data Between Sheets (Array vs. Non-Array Comparison).mp4
087 Rules of Excel Array Functions.mp4
090 Using Array Constants in Formulas.mp4
099 HOMEWORK_ Excel Array Functions.mp4
085 Introduction.mp4
095 Counting Characters Across Cells.mp4
088 Pros & Cons of Array Functions.mp4
04 Common Excel Statistical Functions
035 PRO TIP_ Data Profiling with COUNT & SUMPRODUCT.en.srt
034 DEMO_ Counting Duplicates with COUNTIF & SUMPRODUCT.en.srt
033 DEMO_ Building a Basic Dashboard with COUNTIFS & SUMIFS.en.srt
028 Extracting Values with SMALL_LARGE & RANK_PERCENTRANK.en.srt
027 Basic Excel Statistical Functions.en.srt
031 DEMO_ Calculating Shipping Costs with SUMPRODUCT.en.srt
026 Introduction.en.srt
029 Randomization with RAND() & RANDBETWEEN.en.srt
032 Conditional Aggregation with COUNTIFS, SUMIFS & AVERAGEIFS.en.srt
030 Row-Level Calculation with SUMPRODUCT.en.srt
036 HOMEWORK_ Excel Stats Functions.en.srt
035 PRO TIP_ Data Profiling with COUNT & SUMPRODUCT.mp4
034 DEMO_ Counting Duplicates with COUNTIF & SUMPRODUCT.mp4
028 Extracting Values with SMALL_LARGE & RANK_PERCENTRANK.mp4
031 DEMO_ Calculating Shipping Costs with SUMPRODUCT.mp4
033 DEMO_ Building a Basic Dashboard with COUNTIFS & SUMIFS.mp4
027 Basic Excel Statistical Functions.mp4
032 Conditional Aggregation with COUNTIFS, SUMIFS & AVERAGEIFS.mp4
030 Row-Level Calculation with SUMPRODUCT.mp4
026 Introduction.mp4
029 Randomization with RAND() & RANDBETWEEN.mp4
036 HOMEWORK_ Excel Stats Functions.mp4
02 Excel Formulas 101
005 Introduction_ Excel Formulas 101.en.srt
006 Excel Formula Syntax.en.srt
012 Saving Time with Function Shortcuts.en.srt
009 Formula Auditing_ Trace Precedents & Dependents.en.srt
008 Common Excel Error Types.en.srt
007 Writing Efficient Formulas with Fixed & Relative References.en.srt
010 Formula Auditing_ Evaluate Formula & Error Checking (PC Only).en.srt
014 BONUS_ Mac Shortcuts.html
011 Navigating Excel Worksheets with Ctrl Shortcuts.en.srt
015 PRO TIP_ Creating Drop-Down Menus with Data Validation.en.srt
017 HOMEWORK_ Excel Formulas 101.en.srt
016 Congrats, You're a Developer!.en.srt
013 Accessing Tools with Alt Key Tips.en.srt
006 Excel Formula Syntax.mp4
012 Saving Time with Function Shortcuts.mp4
011 Navigating Excel Worksheets with Ctrl Shortcuts.mp4
009 Formula Auditing_ Trace Precedents & Dependents.mp4
008 Common Excel Error Types.mp4
010 Formula Auditing_ Evaluate Formula & Error Checking (PC Only).mp4
007 Writing Efficient Formulas with Fixed & Relative References.mp4
013 Accessing Tools with Alt Key Tips.mp4
015 PRO TIP_ Creating Drop-Down Menus with Data Validation.mp4
016 Congrats, You're a Developer!.mp4
005 Introduction_ Excel Formulas 101.mp4
017 HOMEWORK_ Excel Formulas 101.mp4
07 Date & Time Functions
076 DEMO_ Building a Simple Budget Pacing Tool.en.srt
074 Defining Time Periods with WEEKDAY, WORKDAY & NETWORKDAYS.en.srt
072 Calculating the Month Start or End with EOMONTH.en.srt
068 Understanding Excel Date Syntax with DATEVALUE.en.srt
075 Calculating Differences Between Dates with DATEDIF (Legacy Function).en.srt
069 Formatting Dates & Filling Date Series.en.srt
071 Extracting Time Periods with YEAR, MONTH, DAY, HOUR, MINUTE & SECOND.en.srt
070 Creating Real-Time Functions with TODAY & NOW.en.srt
077 HOMEWORK_ Excel Date & Time Functions.en.srt
073 Calculating % of Year with YEARFRAC.en.srt
067 Introduction.en.srt
074 Defining Time Periods with WEEKDAY, WORKDAY & NETWORKDAYS.mp4
076 DEMO_ Building a Simple Budget Pacing Tool.mp4
068 Understanding Excel Date Syntax with DATEVALUE.mp4
072 Calculating the Month Start or End with EOMONTH.mp4
067 Introduction.mp4
075 Calculating Differences Between Dates with DATEDIF (Legacy Function).mp4
069 Formatting Dates & Filling Date Series.mp4
071 Extracting Time Periods with YEAR, MONTH, DAY, HOUR, MINUTE & SECOND.mp4
073 Calculating % of Year with YEARFRAC.mp4
070 Creating Real-Time Functions with TODAY & NOW.mp4
077 HOMEWORK_ Excel Date & Time Functions.mp4
10 Extra Bonus Functions
101 Creating Custom References with INDIRECT.en.srt
104 Real-Time Weather Conditions with WEBSERVICE & FILTERXML (Part 2).en.srt
103 Real-Time Weather Conditions with WEBSERVICE & FILTERXML (Part 1).en.srt
102 Linking to Worksheet Locations with HYPERLINK.en.srt
100 Introduction.en.srt
104 Real-Time Weather Conditions with WEBSERVICE & FILTERXML (Part 2).mp4
103 Real-Time Weather Conditions with WEBSERVICE & FILTERXML (Part 1).mp4
101 Creating Custom References with INDIRECT.mp4
102 Linking to Worksheet Locations with HYPERLINK.mp4
100 Introduction.mp4
06 Text Functions
065 Replacing Text with SUBSTITUTE.en.srt
064 Combining RIGHT, LEN, and SEARCH.en.srt
063 Categorizing Data with IF(ISNUMBER(SEARCH)).en.srt
062 Searching Text String with SEARCH & FIND.en.srt
061 Converting Text to Values with TEXT & VALUE.en.srt
066 HOMEWORK_ Excel Text Functions.en.srt
060 Extracting Strings with LEFT, MID, RIGHT & LEN.en.srt
058 Capitalization with UPPER, LOWER, PROPER & TRIM.en.srt
059 Combining Text with CONCATENATE (&).en.srt
057 Introduction.en.srt
061 Converting Text to Values with TEXT & VALUE.mp4
064 Combining RIGHT, LEN, and SEARCH.mp4
063 Categorizing Data with IF(ISNUMBER(SEARCH)).mp4
062 Searching Text String with SEARCH & FIND.mp4
059 Combining Text with CONCATENATE (&).mp4
058 Capitalization with UPPER, LOWER, PROPER & TRIM.mp4
060 Extracting Strings with LEFT, MID, RIGHT & LEN.mp4
065 Replacing Text with SUBSTITUTE.mp4
057 Introduction.mp4
066 HOMEWORK_ Excel Text Functions.mp4
03 Conditional Statements & Logical Operators
021 Adding Conditional AND_OR Operators.en.srt
018 Introduction.en.srt
020 Nesting Multiple IF Statements.en.srt
019 Anatomy of the IF Statement.en.srt
023 Fixing Errors with IFERROR.en.srt
024 Common IS Statements.en.srt
022 Using NOT & ____ Conditionals.en.srt
025 HOMEWORK_ Excel Logical Operators.en.srt
021 Adding Conditional AND_OR Operators.mp4
024 Common IS Statements.mp4
023 Fixing Errors with IFERROR.mp4
019 Anatomy of the IF Statement.mp4
020 Nesting Multiple IF Statements.mp4
022 Using NOT & ____ Conditionals.mp4
018 Introduction.mp4
025 HOMEWORK_ Excel Logical Operators.mp4
08 Formula-Based Formatting
084 HOMEWORK_ Excel Formula-Based Formatting.en.srt
083 Formatting Cells Using Text Functions & Logical Operators.en.srt
079 Creating, Editing & Managing Formula-Based Rules.en.srt
082 Formatting Cells Using Stats Functions.en.srt
080 Highlighting Rows Using the MOD Function.en.srt
081 Formatting Based on the Value of Another Cell.en.srt
078 Introduction.en.srt
082 Formatting Cells Using Stats Functions.mp4
083 Formatting Cells Using Text Functions & Logical Operators.mp4
080 Highlighting Rows Using the MOD Function.mp4
079 Creating, Editing & Managing Formula-Based Rules.mp4
081 Formatting Based on the Value of Another Cell.mp4
078 Introduction.mp4
084 HOMEWORK_ Excel Formula-Based Formatting.mp4
11 Wrapping Up
105 BONUS LECTURE_ More from Maven Analytics.html
TutsNode.com.txt
[TGx]Downloaded from torrentgalaxy.to .txt
.pad
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch Microsoft Excel - Advanced Excel Formulas & Functions Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
