zhongziso
搜索
zhongziso
首页
首页
功能
磁力转BT
BT转磁力
关于
使用教程
免责声明
磁力助手
[DesireCourse.Net] Udemy - Microsoft Excel - Advanced Excel Formulas & Functions
magnet:?xt=urn:btih:0c5f80a761cc239a66ed2b114fbdff377f157e6a&dn=[DesireCourse.Net] Udemy - Microsoft Excel - Advanced Excel Formulas & Functions
磁力链接详情
文件列表详情
0c5f80a761cc239a66ed2b114fbdff377f157e6a
infohash:
101
文件数量
2.64 GB
文件大小
2024-2-2 07:11
创建日期
2024-10-31 20:28
最后访问
相关分词
DesireCourse
Net
Udemy
-
Microsoft
Excel
-
Advanced
Excel
Formulas
&
Functions
01 Getting Started/001 Course Structure Outline.mp4 28.62 MB
01 Getting Started/004 Setting Expectations.mp4 24.5 MB
02 Excel Formulas 101/005 Introduction Excel Formulas 101.mp4 6.21 MB
02 Excel Formulas 101/006 Excel Formula Syntax.mp4 114.41 MB
02 Excel Formulas 101/007 Writing Efficient Formulas with Fixed Relative References.mp4 50.69 MB
02 Excel Formulas 101/008 Common Excel Error Types.mp4 53.41 MB
02 Excel Formulas 101/009 Formula Auditing Trace Precedents Dependents.mp4 80.39 MB
02 Excel Formulas 101/010 Formula Auditing Evaluate Formula Error Checking (PC Only).mp4 53.12 MB
02 Excel Formulas 101/011 Navigating Excel Worksheets with Ctrl Shortcuts.mp4 89.35 MB
02 Excel Formulas 101/012 Saving Time with Function Shortcuts.mp4 103.67 MB
02 Excel Formulas 101/013 Accessing Tools with Alt Key Tips.mp4 49.14 MB
02 Excel Formulas 101/014 PRO TIP Creating Drop-Down Menus with Data Validation.mp4 44.03 MB
02 Excel Formulas 101/015 Congrats Youre a Developer.mp4 33.88 MB
02 Excel Formulas 101/016 HOMEWORK Excel Formulas 101.mp4 4.68 MB
03 Conditional Statements Logical Operators/017 Introduction.mp4 6.24 MB
03 Conditional Statements Logical Operators/018 Anatomy of the IF Statement.mp4 16.86 MB
03 Conditional Statements Logical Operators/019 Nesting Multiple IF Statements.mp4 16.03 MB
03 Conditional Statements Logical Operators/020 Adding Conditional ANDOR Operators.mp4 28.21 MB
03 Conditional Statements Logical Operators/021 Using NOT Conditionals.mp4 11.36 MB
03 Conditional Statements Logical Operators/022 Fixing Errors with IFERROR.mp4 20.08 MB
03 Conditional Statements Logical Operators/023 Common IS Statements.mp4 20.92 MB
03 Conditional Statements Logical Operators/024 HOMEWORK Excel Logical Operators.mp4 1.84 MB
04 Common Excel Statistical Functions/025 Introduction.mp4 6.31 MB
04 Common Excel Statistical Functions/026 Basic Excel Statistical Functions.mp4 14.75 MB
04 Common Excel Statistical Functions/027 Extracting Values with SMALLLARGE RANKPERCENTRANK.mp4 54.26 MB
04 Common Excel Statistical Functions/028 Randomization with RAND() RANDBETWEEN.mp4 6.31 MB
04 Common Excel Statistical Functions/029 Row-Level Calculation with SUMPRODUCT.mp4 10.59 MB
04 Common Excel Statistical Functions/030 DEMO Calculating Shipping Costs with SUMPRODUCT.mp4 31.27 MB
04 Common Excel Statistical Functions/031 Conditional Aggregation with COUNTIFS SUMIFS AVERAGEIFS.mp4 14.14 MB
04 Common Excel Statistical Functions/032 DEMO Building a Basic Dashboard with COUNTIFS SUMIFS.mp4 23.59 MB
04 Common Excel Statistical Functions/033 DEMO Counting Duplicates with COUNTIF SUMPRODUCT.mp4 73.13 MB
04 Common Excel Statistical Functions/034 PRO TIP Data Profiling with COUNT SUMPRODUCT.mp4 95.3 MB
04 Common Excel Statistical Functions/035 HOMEWORK Excel Stats Functions.mp4 1.82 MB
05 Lookup Reference Functions/036 Introduction.mp4 7.23 MB
05 Lookup Reference Functions/037 Working with Named Ranges.mp4 11.31 MB
05 Lookup Reference Functions/038 Counting Rows Columns with ROWROWS COLUMNCOLUMNS.mp4 9.55 MB
05 Lookup Reference Functions/039 Introduction to VLOOKUPHLOOKUP.mp4 51.78 MB
05 Lookup Reference Functions/040 Joining Data with VLOOKUP.mp4 81.83 MB
05 Lookup Reference Functions/041 Fixing Errors with IFERROR VLOOKUP.mp4 15.19 MB
05 Lookup Reference Functions/042 VLOOKUP Reference Array Options.mp4 40.16 MB
05 Lookup Reference Functions/043 Approximate Match Lookups.mp4 46.41 MB
05 Lookup Reference Functions/044 Navigating Cell Ranges with INDEX.mp4 6.15 MB
05 Lookup Reference Functions/045 Matching Text Values with MATCH.mp4 9.22 MB
05 Lookup Reference Functions/046 Combining INDEX MATCH to Dynamically Search Ranges.mp4 23.72 MB
05 Lookup Reference Functions/047 Combining MATCH VLOOKUP for More Flexible Lookups.mp4 26.64 MB
05 Lookup Reference Functions/048 TROUBLESHOOTING VLOOKUP with Duplicate Keys.mp4 18.5 MB
05 Lookup Reference Functions/049 SNEAK PEEK XLOOKUP (Office 365 Only).mp4 19.87 MB
05 Lookup Reference Functions/050 DEMO Building Dashboards with XLOOKUP (Office 365 Only).mp4 172.49 MB
05 Lookup Reference Functions/051 Selecting List Items with CHOOSE.mp4 80.25 MB
05 Lookup Reference Functions/052 Defining Ranges with OFFSET.mp4 6.91 MB
05 Lookup Reference Functions/053 Combining OFFSET with COUNTA to Create a Flexible Range.mp4 7.77 MB
05 Lookup Reference Functions/054 PRO TIP Using OFFSET to Create Interactive Charts.mp4 30.3 MB
05 Lookup Reference Functions/055 HOMEWORK Excel Lookup Reference Functions.mp4 2.83 MB
06 Text Functions/056 Introduction.mp4 4.04 MB
06 Text Functions/057 Capitalization with UPPER LOWER PROPER TRIM.mp4 21.17 MB
06 Text Functions/058 Combining Text with CONCATENATE ().mp4 23.63 MB
06 Text Functions/059 Extracting Strings with LEFT MID RIGHT LEN.mp4 16.94 MB
06 Text Functions/060 Converting Text to Values with TEXT VALUE.mp4 55.38 MB
06 Text Functions/061 Searching Text String with SEARCH FIND.mp4 31.06 MB
06 Text Functions/062 Categorizing Data with IF(ISNUMBER(SEARCH)).mp4 33.61 MB
06 Text Functions/063 Combining RIGHT LEN and SEARCH.mp4 41.87 MB
06 Text Functions/064 Replacing Text with SUBSTITUTE.mp4 9.79 MB
06 Text Functions/065 HOMEWORK Excel Text Functions.mp4 2.55 MB
07 Date Time Functions/066 Introduction.mp4 10.91 MB
07 Date Time Functions/067 Understanding Excel Date Syntax with DATEVALUE.mp4 13.96 MB
07 Date Time Functions/068 Formatting Dates Filling Date Series.mp4 8.64 MB
07 Date Time Functions/069 Creating Real-Time Functions with TODAY NOW.mp4 5.4 MB
07 Date Time Functions/070 Extracting Time Periods with YEAR MONTH DAY HOUR MINUTE SECOND.mp4 7.88 MB
07 Date Time Functions/071 Calculating the Month Start or End with EOMONTH.mp4 13.07 MB
07 Date Time Functions/072 Calculating of Year with YEARFRAC.mp4 5.76 MB
07 Date Time Functions/073 Defining Time Periods with WEEKDAY WORKDAY NETWORKDAYS.mp4 55.27 MB
07 Date Time Functions/074 Calculating Differences Between Dates with DATEDIF (Legacy Function).mp4 10.11 MB
07 Date Time Functions/075 DEMO Building a Simple Budget Pacing Tool.mp4 26.1 MB
07 Date Time Functions/076 HOMEWORK Excel Date Time Functions.mp4 1.36 MB
08 Formula-Based Formatting/077 Introduction.mp4 9.2 MB
08 Formula-Based Formatting/078 Creating Editing Managing Formula-Based Rules.mp4 12.06 MB
08 Formula-Based Formatting/079 Highlighting Rows Using the MOD Function.mp4 14.95 MB
08 Formula-Based Formatting/080 Formatting Based on the Value of Another Cell.mp4 10.06 MB
08 Formula-Based Formatting/081 Formatting Cells Using Stats Functions.mp4 24.27 MB
08 Formula-Based Formatting/082 Formatting Cells Using Text Functions Logical Operators.mp4 20.57 MB
08 Formula-Based Formatting/083 HOMEWORK Excel Formula-Based Formatting.mp4 1.73 MB
09 Array Formulas/084 Introduction.mp4 6.96 MB
09 Array Formulas/086 Rules of Excel Array Functions.mp4 8.79 MB
09 Array Formulas/087 Pros Cons of Array Functions.mp4 5.2 MB
09 Array Formulas/088 Defining Vertical Horizontal and 2-Dimensional Arrays.mp4 12.71 MB
09 Array Formulas/089 Using Array Constants in Formulas.mp4 7.1 MB
09 Array Formulas/090 Defining Referencing Named Array Constants.mp4 9.96 MB
09 Array Formulas/091 Restructuring Data with TRANSPOSE.mp4 13.56 MB
09 Array Formulas/092 Linking Data Between Sheets (Array vs. Non-Array Comparison).mp4 9.05 MB
09 Array Formulas/093 Returning the Largest Values in a Range.mp4 10.78 MB
09 Array Formulas/094 Counting Characters Across Cells.mp4 5.5 MB
09 Array Formulas/095 Creating a MAX IF Array Formula.mp4 9.22 MB
09 Array Formulas/096 Creating a MAX IF Array Formula with Multiple Criteria.mp4 20.13 MB
09 Array Formulas/097 Converting Boolean Values Using the Double Unary (--).mp4 12.26 MB
09 Array Formulas/098 HOMEWORK Excel Array Functions.mp4 7.08 MB
10 Extra Bonus Functions/099 Introduction.mp4 8.67 MB
10 Extra Bonus Functions/100 Creating Custom References with INDIRECT.mp4 30.16 MB
10 Extra Bonus Functions/101 Linking to Worksheet Locations with HYPERLINK.mp4 14.17 MB
10 Extra Bonus Functions/102 Real-Time Weather Conditions with WEBSERVICE FILTERXML (Part 1).mp4 71.78 MB
10 Extra Bonus Functions/103 Real-Time Weather Conditions with WEBSERVICE FILTERXML (Part 2).mp4 92.27 MB
11 Wrapping Up/104 Conclusion Next Steps.mp4 678.25 KB
其他位置