种子简介

种子名称： Microsoft Excel - Advanced Excel Formulas & Functions
文件类型： 视频
文件数目： 102个文件
文件大小： 3.47 GB
收录时间： 2022-7-15 05:18
已经下载： 3次
资源热度： 124
最近下载： 2024-6-8 04:25

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:bd80d4305b510f9c3ccf3f51a4f73b8736336e3e&dn=Microsoft Excel - Advanced Excel Formulas & Functions 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

Microsoft Excel - Advanced Excel Formulas & Functions.torrent

01 - Getting Started/001 Course Structure & Outline.mp428.03MB

01 - Getting Started/004 Setting Expectations.mp421.55MB

02 - Excel Formulas 101/001 Introduction Excel Formulas 101.mp42.99MB

02 - Excel Formulas 101/002 Excel Formula Syntax.mp495.32MB

02 - Excel Formulas 101/003 Writing Efficient Formulas with Fixed & Relative References.mp441.97MB

02 - Excel Formulas 101/004 Common Excel Error Types.mp424.51MB

02 - Excel Formulas 101/005 Formula Auditing Trace Precedents & Dependents.mp465.77MB

02 - Excel Formulas 101/006 Formula Auditing Evaluate Formula & Error Checking (PC Only).mp427.51MB

02 - Excel Formulas 101/007 Navigating Excel Worksheets with Ctrl Shortcuts.mp480.46MB

02 - Excel Formulas 101/008 Saving Time with Function Shortcuts.mp488.14MB

02 - Excel Formulas 101/009 Accessing Tools with Alt Key Tips.mp429.81MB

02 - Excel Formulas 101/011 PRO TIP Creating Drop-Down Menus with Data Validation.mp419.91MB

02 - Excel Formulas 101/012 Congrats, You're a Developer!.mp417.77MB

03 - Conditional Statements & Logical Operators/001 Introduction.mp42.11MB

03 - Conditional Statements & Logical Operators/002 Anatomy of the IF Statement.mp432.62MB

03 - Conditional Statements & Logical Operators/003 Nesting Multiple IF Statements.mp423.28MB

03 - Conditional Statements & Logical Operators/004 Adding Conditional ANDOR Operators.mp458.78MB

03 - Conditional Statements & Logical Operators/005 Using NOT & Conditionals.mp410.79MB

03 - Conditional Statements & Logical Operators/006 Fixing Errors with IFERROR.mp433.49MB

03 - Conditional Statements & Logical Operators/007 Common IS Statements.mp438.38MB

04 - Common Excel Statistical Functions/001 Introduction.mp42.29MB

04 - Common Excel Statistical Functions/002 Basic Excel Statistical Functions.mp425.99MB

04 - Common Excel Statistical Functions/003 Extracting Values with SMALLLARGE & RANKPERCENTRANK.mp433.89MB

04 - Common Excel Statistical Functions/004 Randomization with RAND() & RANDBETWEEN.mp412.86MB

04 - Common Excel Statistical Functions/005 Row-Level Calculation with SUMPRODUCT.mp412.73MB

04 - Common Excel Statistical Functions/006 DEMO Calculating Shipping Costs with SUMPRODUCT.mp425.95MB

04 - Common Excel Statistical Functions/007 Conditional Aggregation with COUNTIFS, SUMIFS & AVERAGEIFS.mp416.53MB

04 - Common Excel Statistical Functions/008 DEMO Building a Basic Dashboard with COUNTIFS & SUMIFS.mp454MB

04 - Common Excel Statistical Functions/009 DEMO Counting Duplicates with COUNTIF & SUMPRODUCT.mp450.76MB

04 - Common Excel Statistical Functions/010 PRO TIP Data Profiling with COUNT & SUMPRODUCT.mp476.37MB

05 - Lookup & Reference Functions/001 Introduction.mp42.67MB

05 - Lookup & Reference Functions/002 Working with Named Ranges.mp420.47MB

05 - Lookup & Reference Functions/003 Counting Rows & Columns with ROWROWS & COLUMNCOLUMNS.mp414.09MB

05 - Lookup & Reference Functions/004 Introduction to VLOOKUPHLOOKUP.mp420.54MB

05 - Lookup & Reference Functions/005 Joining Data with VLOOKUP.mp468.3MB

05 - Lookup & Reference Functions/006 Fixing Errors with IFERROR & VLOOKUP.mp431.63MB

05 - Lookup & Reference Functions/007 VLOOKUP Reference Array Options.mp466.22MB

05 - Lookup & Reference Functions/008 Approximate Match Lookups.mp428.83MB

05 - Lookup & Reference Functions/009 Navigating Cell Ranges with INDEX.mp44.75MB

05 - Lookup & Reference Functions/010 Matching Text & Values with MATCH.mp46.65MB

05 - Lookup & Reference Functions/011 Combining INDEX & MATCH to Dynamically Search Ranges.mp423.74MB

05 - Lookup & Reference Functions/012 Combining MATCH & VLOOKUP for More Flexible Lookups.mp441.2MB

05 - Lookup & Reference Functions/013 TROUBLESHOOTING VLOOKUP with Duplicate Keys.mp425.96MB

05 - Lookup & Reference Functions/014 SNEAK PEEK XLOOKUP (Office 365 Only).mp48.92MB

05 - Lookup & Reference Functions/015 DEMO Building Dashboards with XLOOKUP (Office 365 Only).mp4165.74MB

05 - Lookup & Reference Functions/016 Selecting List Items with CHOOSE.mp447.19MB

05 - Lookup & Reference Functions/017 Defining Ranges with OFFSET.mp45.08MB

05 - Lookup & Reference Functions/018 Combining OFFSET with COUNTA to Create a Flexible Range.mp49.31MB

05 - Lookup & Reference Functions/019 PRO TIP Using OFFSET to Create Interactive Charts.mp430.26MB

06 - Text Functions/001 Introduction.mp41.45MB

06 - Text Functions/002 Capitalization with UPPER, LOWER, PROPER & TRIM.mp423.25MB

06 - Text Functions/003 Combining Text with CONCATENATE (&).mp429.23MB

06 - Text Functions/004 Extracting Strings with LEFT, MID, RIGHT & LEN.mp424.3MB

06 - Text Functions/005 Converting Text to Values with TEXT & VALUE.mp444.6MB

06 - Text Functions/006 Searching Text String with SEARCH & FIND.mp442.71MB

06 - Text Functions/007 Categorizing Data with IF(ISNUMBER(SEARCH)).mp435.69MB

06 - Text Functions/008 Combining RIGHT, LEN, and SEARCH.mp454.68MB

06 - Text Functions/009 Replacing Text with SUBSTITUTE.mp422.85MB

07 - Date & Time Functions/001 Introduction.mp44.05MB

07 - Date & Time Functions/002 Understanding Excel Date Syntax with DATEVALUE.mp418.93MB

07 - Date & Time Functions/003 Formatting Dates & Filling Date Series.mp49.18MB

07 - Date & Time Functions/004 Creating Real-Time Functions with TODAY & NOW.mp46.55MB

07 - Date & Time Functions/005 Extracting Time Periods with YEAR, MONTH, DAY, HOUR, MINUTE & SECOND.mp48.93MB

07 - Date & Time Functions/006 Calculating the Month Start or End with EOMONTH.mp430.24MB

07 - Date & Time Functions/007 Calculating % of Year with YEARFRAC.mp45.7MB

07 - Date & Time Functions/008 Defining Time Periods with WEEKDAY, WORKDAY & NETWORKDAYS.mp427.53MB

07 - Date & Time Functions/009 Calculating Differences Between Dates with DATEDIF (Legacy Function).mp412.45MB

07 - Date & Time Functions/010 DEMO Building a Simple Budget Pacing Tool.mp445.56MB

08 - Formula-Based Formatting/001 Introduction.mp43.21MB

08 - Formula-Based Formatting/002 Creating, Editing & Managing Formula-Based Rules.mp415.38MB

08 - Formula-Based Formatting/003 Highlighting Rows Using the MOD Function.mp431.79MB

08 - Formula-Based Formatting/004 Formatting Based on the Value of Another Cell.mp412.35MB

08 - Formula-Based Formatting/005 Formatting Cells Using Stats Functions.mp438.38MB

08 - Formula-Based Formatting/006 Formatting Cells Using Text Functions & Logical Operators.mp433.52MB

09 - Dynamic Array Formulas/001 Intro & Compatibility.mp47.12MB

09 - Dynamic Array Formulas/002 Project Intro Maven Recruiters.mp46.44MB

09 - Dynamic Array Formulas/003 Legacy vs. Dynamic Excel.mp450.33MB

09 - Dynamic Array Formulas/004 Spill Range Properties.mp438.1MB

09 - Dynamic Array Formulas/005 PRO TIP Growing Source Data.mp464.85MB

09 - Dynamic Array Formulas/006 Common Dynamic Array Functions.mp42.45MB

09 - Dynamic Array Formulas/007 The SORT Function.mp445.41MB

09 - Dynamic Array Formulas/008 The SORTBY Function.mp428.24MB

09 - Dynamic Array Formulas/009 The FILTER Function.mp4124.03MB

09 - Dynamic Array Formulas/010 The UNIQUE Function.mp420.87MB

09 - Dynamic Array Formulas/011 PRO TIP Drop-Down Lists with SORT & UNIQUE.mp442.41MB

09 - Dynamic Array Formulas/012 Combining SORT, FILTER & UNIQUE.mp442.1MB

09 - Dynamic Array Formulas/013 Referencing Spill Ranges in Calculations.mp443.22MB

09 - Dynamic Array Formulas/014 Conditional Formatting with Dynamic Arrays.mp435.8MB

09 - Dynamic Array Formulas/015 PRO TIP Creating Charts from Dynamic Arrays.mp462.2MB

09 - Dynamic Array Formulas/016 The SEQUENCE Function.mp43.46MB

09 - Dynamic Array Formulas/017 PRO TIP Top N Calculations with SEQUENCE & LARGE.mp468.84MB

09 - Dynamic Array Formulas/018 The RANDARRAY Function.mp44.9MB

09 - Dynamic Array Formulas/019 PRO TIP Creating Random Top N Lists.mp4114.03MB

09 - Dynamic Array Formulas/020 The FREQUENCY Function.mp436.43MB

09 - Dynamic Array Formulas/021 The TRANSPOSE Function.mp475.12MB

09 - Dynamic Array Formulas/022 PRO TIP Joining Dynamic Arrays with CHOOSE.mp476.45MB

09 - Dynamic Array Formulas/023 PRO TIP Declaring Variables with LET.mp497.43MB

10 - Bonus Functions/001 Introduction.mp43.27MB

10 - Bonus Functions/002 Creating Custom References with INDIRECT.mp467.55MB

10 - Bonus Functions/003 Linking to Worksheet Locations with HYPERLINK.mp420.5MB

10 - Bonus Functions/004 Real-Time Weather Conditions with WEBSERVICE & FILTERXML (Part 1).mp432.27MB

10 - Bonus Functions/005 Real-Time Weather Conditions with WEBSERVICE & FILTERXML (Part 2).mp476.23MB