zhongziso种子搜
首页
功能
磁力转BT
BT转磁力
使用教程
免责声明
关于
zhongziso
搜索
Microsoft Excel - Advanced Excel Formulas & Functions
magnet:?xt=urn:btih:bd80d4305b510f9c3ccf3f51a4f73b8736336e3e&dn=Microsoft Excel - Advanced Excel Formulas & Functions
磁力链接详情
Hash值:
bd80d4305b510f9c3ccf3f51a4f73b8736336e3e
点击数:
129
文件大小:
3.47 GB
文件数量:
102
创建日期:
2022-7-15 05:18
最后访问:
2024-6-27 15:25
访问标签:
Microsoft
Excel
-
Advanced
Excel
Formulas
&
Functions
文件列表详情
01 - Getting Started/001 Course Structure & Outline.mp4 28.03 MB
01 - Getting Started/004 Setting Expectations.mp4 21.55 MB
02 - Excel Formulas 101/001 Introduction Excel Formulas 101.mp4 2.99 MB
02 - Excel Formulas 101/002 Excel Formula Syntax.mp4 95.32 MB
02 - Excel Formulas 101/003 Writing Efficient Formulas with Fixed & Relative References.mp4 41.97 MB
02 - Excel Formulas 101/004 Common Excel Error Types.mp4 24.51 MB
02 - Excel Formulas 101/005 Formula Auditing Trace Precedents & Dependents.mp4 65.77 MB
02 - Excel Formulas 101/006 Formula Auditing Evaluate Formula & Error Checking (PC Only).mp4 27.51 MB
02 - Excel Formulas 101/007 Navigating Excel Worksheets with Ctrl Shortcuts.mp4 80.46 MB
02 - Excel Formulas 101/008 Saving Time with Function Shortcuts.mp4 88.14 MB
02 - Excel Formulas 101/009 Accessing Tools with Alt Key Tips.mp4 29.81 MB
02 - Excel Formulas 101/011 PRO TIP Creating Drop-Down Menus with Data Validation.mp4 19.91 MB
02 - Excel Formulas 101/012 Congrats, You're a Developer!.mp4 17.77 MB
03 - Conditional Statements & Logical Operators/001 Introduction.mp4 2.11 MB
03 - Conditional Statements & Logical Operators/002 Anatomy of the IF Statement.mp4 32.62 MB
03 - Conditional Statements & Logical Operators/003 Nesting Multiple IF Statements.mp4 23.28 MB
03 - Conditional Statements & Logical Operators/004 Adding Conditional ANDOR Operators.mp4 58.78 MB
03 - Conditional Statements & Logical Operators/005 Using NOT & Conditionals.mp4 10.79 MB
03 - Conditional Statements & Logical Operators/006 Fixing Errors with IFERROR.mp4 33.49 MB
03 - Conditional Statements & Logical Operators/007 Common IS Statements.mp4 38.38 MB
04 - Common Excel Statistical Functions/001 Introduction.mp4 2.29 MB
04 - Common Excel Statistical Functions/002 Basic Excel Statistical Functions.mp4 25.99 MB
04 - Common Excel Statistical Functions/003 Extracting Values with SMALLLARGE & RANKPERCENTRANK.mp4 33.89 MB
04 - Common Excel Statistical Functions/004 Randomization with RAND() & RANDBETWEEN.mp4 12.86 MB
04 - Common Excel Statistical Functions/005 Row-Level Calculation with SUMPRODUCT.mp4 12.73 MB
04 - Common Excel Statistical Functions/006 DEMO Calculating Shipping Costs with SUMPRODUCT.mp4 25.95 MB
04 - Common Excel Statistical Functions/007 Conditional Aggregation with COUNTIFS, SUMIFS & AVERAGEIFS.mp4 16.53 MB
04 - Common Excel Statistical Functions/008 DEMO Building a Basic Dashboard with COUNTIFS & SUMIFS.mp4 54 MB
04 - Common Excel Statistical Functions/009 DEMO Counting Duplicates with COUNTIF & SUMPRODUCT.mp4 50.76 MB
04 - Common Excel Statistical Functions/010 PRO TIP Data Profiling with COUNT & SUMPRODUCT.mp4 76.37 MB
05 - Lookup & Reference Functions/001 Introduction.mp4 2.67 MB
05 - Lookup & Reference Functions/002 Working with Named Ranges.mp4 20.47 MB
05 - Lookup & Reference Functions/003 Counting Rows & Columns with ROWROWS & COLUMNCOLUMNS.mp4 14.09 MB
05 - Lookup & Reference Functions/004 Introduction to VLOOKUPHLOOKUP.mp4 20.54 MB
05 - Lookup & Reference Functions/005 Joining Data with VLOOKUP.mp4 68.3 MB
05 - Lookup & Reference Functions/006 Fixing Errors with IFERROR & VLOOKUP.mp4 31.63 MB
05 - Lookup & Reference Functions/007 VLOOKUP Reference Array Options.mp4 66.22 MB
05 - Lookup & Reference Functions/008 Approximate Match Lookups.mp4 28.83 MB
05 - Lookup & Reference Functions/009 Navigating Cell Ranges with INDEX.mp4 4.75 MB
05 - Lookup & Reference Functions/010 Matching Text & Values with MATCH.mp4 6.65 MB
05 - Lookup & Reference Functions/011 Combining INDEX & MATCH to Dynamically Search Ranges.mp4 23.74 MB
05 - Lookup & Reference Functions/012 Combining MATCH & VLOOKUP for More Flexible Lookups.mp4 41.2 MB
05 - Lookup & Reference Functions/013 TROUBLESHOOTING VLOOKUP with Duplicate Keys.mp4 25.96 MB
05 - Lookup & Reference Functions/014 SNEAK PEEK XLOOKUP (Office 365 Only).mp4 8.92 MB
05 - Lookup & Reference Functions/015 DEMO Building Dashboards with XLOOKUP (Office 365 Only).mp4 165.74 MB
05 - Lookup & Reference Functions/016 Selecting List Items with CHOOSE.mp4 47.19 MB
05 - Lookup & Reference Functions/017 Defining Ranges with OFFSET.mp4 5.08 MB
05 - Lookup & Reference Functions/018 Combining OFFSET with COUNTA to Create a Flexible Range.mp4 9.31 MB
05 - Lookup & Reference Functions/019 PRO TIP Using OFFSET to Create Interactive Charts.mp4 30.26 MB
06 - Text Functions/001 Introduction.mp4 1.45 MB
06 - Text Functions/002 Capitalization with UPPER, LOWER, PROPER & TRIM.mp4 23.25 MB
06 - Text Functions/003 Combining Text with CONCATENATE (&).mp4 29.23 MB
06 - Text Functions/004 Extracting Strings with LEFT, MID, RIGHT & LEN.mp4 24.3 MB
06 - Text Functions/005 Converting Text to Values with TEXT & VALUE.mp4 44.6 MB
06 - Text Functions/006 Searching Text String with SEARCH & FIND.mp4 42.71 MB
06 - Text Functions/007 Categorizing Data with IF(ISNUMBER(SEARCH)).mp4 35.69 MB
06 - Text Functions/008 Combining RIGHT, LEN, and SEARCH.mp4 54.68 MB
06 - Text Functions/009 Replacing Text with SUBSTITUTE.mp4 22.85 MB
07 - Date & Time Functions/001 Introduction.mp4 4.05 MB
07 - Date & Time Functions/002 Understanding Excel Date Syntax with DATEVALUE.mp4 18.93 MB
07 - Date & Time Functions/003 Formatting Dates & Filling Date Series.mp4 9.18 MB
07 - Date & Time Functions/004 Creating Real-Time Functions with TODAY & NOW.mp4 6.55 MB
07 - Date & Time Functions/005 Extracting Time Periods with YEAR, MONTH, DAY, HOUR, MINUTE & SECOND.mp4 8.93 MB
07 - Date & Time Functions/006 Calculating the Month Start or End with EOMONTH.mp4 30.24 MB
07 - Date & Time Functions/007 Calculating % of Year with YEARFRAC.mp4 5.7 MB
07 - Date & Time Functions/008 Defining Time Periods with WEEKDAY, WORKDAY & NETWORKDAYS.mp4 27.53 MB
07 - Date & Time Functions/009 Calculating Differences Between Dates with DATEDIF (Legacy Function).mp4 12.45 MB
07 - Date & Time Functions/010 DEMO Building a Simple Budget Pacing Tool.mp4 45.56 MB
08 - Formula-Based Formatting/001 Introduction.mp4 3.21 MB
08 - Formula-Based Formatting/002 Creating, Editing & Managing Formula-Based Rules.mp4 15.38 MB
08 - Formula-Based Formatting/003 Highlighting Rows Using the MOD Function.mp4 31.79 MB
08 - Formula-Based Formatting/004 Formatting Based on the Value of Another Cell.mp4 12.35 MB
08 - Formula-Based Formatting/005 Formatting Cells Using Stats Functions.mp4 38.38 MB
08 - Formula-Based Formatting/006 Formatting Cells Using Text Functions & Logical Operators.mp4 33.52 MB
09 - Dynamic Array Formulas/001 Intro & Compatibility.mp4 7.12 MB
09 - Dynamic Array Formulas/002 Project Intro Maven Recruiters.mp4 6.44 MB
09 - Dynamic Array Formulas/003 Legacy vs. Dynamic Excel.mp4 50.33 MB
09 - Dynamic Array Formulas/004 Spill Range Properties.mp4 38.1 MB
09 - Dynamic Array Formulas/005 PRO TIP Growing Source Data.mp4 64.85 MB
09 - Dynamic Array Formulas/006 Common Dynamic Array Functions.mp4 2.45 MB
09 - Dynamic Array Formulas/007 The SORT Function.mp4 45.41 MB
09 - Dynamic Array Formulas/008 The SORTBY Function.mp4 28.24 MB
09 - Dynamic Array Formulas/009 The FILTER Function.mp4 124.03 MB
09 - Dynamic Array Formulas/010 The UNIQUE Function.mp4 20.87 MB
09 - Dynamic Array Formulas/011 PRO TIP Drop-Down Lists with SORT & UNIQUE.mp4 42.41 MB
09 - Dynamic Array Formulas/012 Combining SORT, FILTER & UNIQUE.mp4 42.1 MB
09 - Dynamic Array Formulas/013 Referencing Spill Ranges in Calculations.mp4 43.22 MB
09 - Dynamic Array Formulas/014 Conditional Formatting with Dynamic Arrays.mp4 35.8 MB
09 - Dynamic Array Formulas/015 PRO TIP Creating Charts from Dynamic Arrays.mp4 62.2 MB
09 - Dynamic Array Formulas/016 The SEQUENCE Function.mp4 3.46 MB
09 - Dynamic Array Formulas/017 PRO TIP Top N Calculations with SEQUENCE & LARGE.mp4 68.84 MB
09 - Dynamic Array Formulas/018 The RANDARRAY Function.mp4 4.9 MB
09 - Dynamic Array Formulas/019 PRO TIP Creating Random Top N Lists.mp4 114.03 MB
09 - Dynamic Array Formulas/020 The FREQUENCY Function.mp4 36.43 MB
09 - Dynamic Array Formulas/021 The TRANSPOSE Function.mp4 75.12 MB
09 - Dynamic Array Formulas/022 PRO TIP Joining Dynamic Arrays with CHOOSE.mp4 76.45 MB
09 - Dynamic Array Formulas/023 PRO TIP Declaring Variables with LET.mp4 97.43 MB
10 - Bonus Functions/001 Introduction.mp4 3.27 MB
10 - Bonus Functions/002 Creating Custom References with INDIRECT.mp4 67.55 MB
10 - Bonus Functions/003 Linking to Worksheet Locations with HYPERLINK.mp4 20.5 MB
10 - Bonus Functions/004 Real-Time Weather Conditions with WEBSERVICE & FILTERXML (Part 1).mp4 32.27 MB
10 - Bonus Functions/005 Real-Time Weather Conditions with WEBSERVICE & FILTERXML (Part 2).mp4 76.23 MB
其他位置