种子简介

种子名称： [FreeCourseWorld.Com] Udemy - Microsoft Excel - Advanced Excel Formulas & Functions
文件类型： 视频
文件数目： 101个文件
文件大小： 2.64 GB
收录时间： 2023-9-22 21:50
已经下载： 3次
资源热度： 131
最近下载： 2024-12-3 15:39

下载BT种子文件

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

磁力链接下载

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

喜欢这个种子的人也喜欢

种子包含的文件

[FreeCourseWorld.Com] Udemy - Microsoft Excel - Advanced Excel Formulas & Functions.torrent

01 Getting Started/001 Course Structure Outline.mp428.62MB

01 Getting Started/004 Setting Expectations.mp424.5MB

02 Excel Formulas 101/005 Introduction Excel Formulas 101.mp46.21MB

02 Excel Formulas 101/006 Excel Formula Syntax.mp4114.41MB

02 Excel Formulas 101/007 Writing Efficient Formulas with Fixed Relative References.mp450.69MB

02 Excel Formulas 101/008 Common Excel Error Types.mp453.41MB

02 Excel Formulas 101/009 Formula Auditing Trace Precedents Dependents.mp480.39MB

02 Excel Formulas 101/010 Formula Auditing Evaluate Formula Error Checking (PC Only).mp453.12MB

02 Excel Formulas 101/011 Navigating Excel Worksheets with Ctrl Shortcuts.mp489.35MB

02 Excel Formulas 101/012 Saving Time with Function Shortcuts.mp4103.67MB

02 Excel Formulas 101/013 Accessing Tools with Alt Key Tips.mp449.14MB

02 Excel Formulas 101/014 PRO TIP Creating Drop-Down Menus with Data Validation.mp444.03MB

02 Excel Formulas 101/015 Congrats Youre a Developer.mp433.88MB

02 Excel Formulas 101/016 HOMEWORK Excel Formulas 101.mp44.68MB

03 Conditional Statements Logical Operators/017 Introduction.mp46.24MB

03 Conditional Statements Logical Operators/018 Anatomy of the IF Statement.mp416.86MB

03 Conditional Statements Logical Operators/019 Nesting Multiple IF Statements.mp416.03MB

03 Conditional Statements Logical Operators/020 Adding Conditional ANDOR Operators.mp428.21MB

03 Conditional Statements Logical Operators/021 Using NOT Conditionals.mp411.36MB

03 Conditional Statements Logical Operators/022 Fixing Errors with IFERROR.mp420.08MB

03 Conditional Statements Logical Operators/023 Common IS Statements.mp420.92MB

03 Conditional Statements Logical Operators/024 HOMEWORK Excel Logical Operators.mp41.84MB

04 Common Excel Statistical Functions/025 Introduction.mp46.31MB

04 Common Excel Statistical Functions/026 Basic Excel Statistical Functions.mp414.75MB

04 Common Excel Statistical Functions/027 Extracting Values with SMALLLARGE RANKPERCENTRANK.mp454.26MB

04 Common Excel Statistical Functions/028 Randomization with RAND() RANDBETWEEN.mp46.31MB

04 Common Excel Statistical Functions/029 Row-Level Calculation with SUMPRODUCT.mp410.59MB

04 Common Excel Statistical Functions/030 DEMO Calculating Shipping Costs with SUMPRODUCT.mp431.27MB

04 Common Excel Statistical Functions/031 Conditional Aggregation with COUNTIFS SUMIFS AVERAGEIFS.mp414.14MB

04 Common Excel Statistical Functions/032 DEMO Building a Basic Dashboard with COUNTIFS SUMIFS.mp423.59MB

04 Common Excel Statistical Functions/033 DEMO Counting Duplicates with COUNTIF SUMPRODUCT.mp473.13MB

04 Common Excel Statistical Functions/034 PRO TIP Data Profiling with COUNT SUMPRODUCT.mp495.3MB

04 Common Excel Statistical Functions/035 HOMEWORK Excel Stats Functions.mp41.82MB

05 Lookup Reference Functions/036 Introduction.mp47.23MB

05 Lookup Reference Functions/037 Working with Named Ranges.mp411.31MB

05 Lookup Reference Functions/038 Counting Rows Columns with ROWROWS COLUMNCOLUMNS.mp49.55MB

05 Lookup Reference Functions/039 Introduction to VLOOKUPHLOOKUP.mp451.78MB

05 Lookup Reference Functions/040 Joining Data with VLOOKUP.mp481.83MB

05 Lookup Reference Functions/041 Fixing Errors with IFERROR VLOOKUP.mp415.19MB

05 Lookup Reference Functions/042 VLOOKUP Reference Array Options.mp440.16MB

05 Lookup Reference Functions/043 Approximate Match Lookups.mp446.41MB

05 Lookup Reference Functions/044 Navigating Cell Ranges with INDEX.mp46.15MB

05 Lookup Reference Functions/045 Matching Text Values with MATCH.mp49.22MB

05 Lookup Reference Functions/046 Combining INDEX MATCH to Dynamically Search Ranges.mp423.72MB

05 Lookup Reference Functions/047 Combining MATCH VLOOKUP for More Flexible Lookups.mp426.64MB

05 Lookup Reference Functions/048 TROUBLESHOOTING VLOOKUP with Duplicate Keys.mp418.5MB

05 Lookup Reference Functions/049 SNEAK PEEK XLOOKUP (Office 365 Only).mp419.87MB

05 Lookup Reference Functions/050 DEMO Building Dashboards with XLOOKUP (Office 365 Only).mp4172.49MB

05 Lookup Reference Functions/051 Selecting List Items with CHOOSE.mp480.25MB

05 Lookup Reference Functions/052 Defining Ranges with OFFSET.mp46.91MB

05 Lookup Reference Functions/053 Combining OFFSET with COUNTA to Create a Flexible Range.mp47.77MB

05 Lookup Reference Functions/054 PRO TIP Using OFFSET to Create Interactive Charts.mp430.3MB

05 Lookup Reference Functions/055 HOMEWORK Excel Lookup Reference Functions.mp42.83MB

06 Text Functions/056 Introduction.mp44.04MB

06 Text Functions/057 Capitalization with UPPER LOWER PROPER TRIM.mp421.17MB

06 Text Functions/058 Combining Text with CONCATENATE ().mp423.63MB

06 Text Functions/059 Extracting Strings with LEFT MID RIGHT LEN.mp416.94MB

06 Text Functions/060 Converting Text to Values with TEXT VALUE.mp455.38MB

06 Text Functions/061 Searching Text String with SEARCH FIND.mp431.06MB

06 Text Functions/062 Categorizing Data with IF(ISNUMBER(SEARCH)).mp433.61MB

06 Text Functions/063 Combining RIGHT LEN and SEARCH.mp441.87MB

06 Text Functions/064 Replacing Text with SUBSTITUTE.mp49.79MB

06 Text Functions/065 HOMEWORK Excel Text Functions.mp42.55MB

07 Date Time Functions/066 Introduction.mp410.91MB

07 Date Time Functions/067 Understanding Excel Date Syntax with DATEVALUE.mp413.96MB

07 Date Time Functions/068 Formatting Dates Filling Date Series.mp48.64MB

07 Date Time Functions/069 Creating Real-Time Functions with TODAY NOW.mp45.4MB

07 Date Time Functions/070 Extracting Time Periods with YEAR MONTH DAY HOUR MINUTE SECOND.mp47.88MB

07 Date Time Functions/071 Calculating the Month Start or End with EOMONTH.mp413.07MB

07 Date Time Functions/072 Calculating of Year with YEARFRAC.mp45.76MB

07 Date Time Functions/073 Defining Time Periods with WEEKDAY WORKDAY NETWORKDAYS.mp455.27MB

07 Date Time Functions/074 Calculating Differences Between Dates with DATEDIF (Legacy Function).mp410.11MB

07 Date Time Functions/075 DEMO Building a Simple Budget Pacing Tool.mp426.1MB

07 Date Time Functions/076 HOMEWORK Excel Date Time Functions.mp41.36MB

08 Formula-Based Formatting/077 Introduction.mp49.2MB

08 Formula-Based Formatting/078 Creating Editing Managing Formula-Based Rules.mp412.06MB

08 Formula-Based Formatting/079 Highlighting Rows Using the MOD Function.mp414.95MB

08 Formula-Based Formatting/080 Formatting Based on the Value of Another Cell.mp410.06MB

08 Formula-Based Formatting/081 Formatting Cells Using Stats Functions.mp424.27MB

08 Formula-Based Formatting/082 Formatting Cells Using Text Functions Logical Operators.mp420.57MB

08 Formula-Based Formatting/083 HOMEWORK Excel Formula-Based Formatting.mp41.73MB

09 Array Formulas/084 Introduction.mp46.96MB

09 Array Formulas/086 Rules of Excel Array Functions.mp48.79MB

09 Array Formulas/087 Pros Cons of Array Functions.mp45.2MB

09 Array Formulas/088 Defining Vertical Horizontal and 2-Dimensional Arrays.mp412.71MB

09 Array Formulas/089 Using Array Constants in Formulas.mp47.1MB

09 Array Formulas/090 Defining Referencing Named Array Constants.mp49.96MB

09 Array Formulas/091 Restructuring Data with TRANSPOSE.mp413.56MB

09 Array Formulas/092 Linking Data Between Sheets (Array vs. Non-Array Comparison).mp49.05MB

09 Array Formulas/093 Returning the Largest Values in a Range.mp410.78MB

09 Array Formulas/094 Counting Characters Across Cells.mp45.5MB

09 Array Formulas/095 Creating a MAX IF Array Formula.mp49.22MB

09 Array Formulas/096 Creating a MAX IF Array Formula with Multiple Criteria.mp420.13MB

09 Array Formulas/097 Converting Boolean Values Using the Double Unary (--).mp412.26MB

09 Array Formulas/098 HOMEWORK Excel Array Functions.mp47.08MB

10 Extra Bonus Functions/099 Introduction.mp48.67MB

10 Extra Bonus Functions/100 Creating Custom References with INDIRECT.mp430.16MB

10 Extra Bonus Functions/101 Linking to Worksheet Locations with HYPERLINK.mp414.17MB

10 Extra Bonus Functions/102 Real-Time Weather Conditions with WEBSERVICE FILTERXML (Part 1).mp471.78MB

10 Extra Bonus Functions/103 Real-Time Weather Conditions with WEBSERVICE FILTERXML (Part 2).mp492.27MB

11 Wrapping Up/104 Conclusion Next Steps.mp4678.25KB