种子简介

种子名称： Udemy Excel with Interactive Excel Dashboards
文件类型： 视频
文件数目： 107个文件
文件大小： 2.34 GB
收录时间： 2017-3-25 13:36
已经下载： 3次
资源热度： 111
最近下载： 2024-7-5 11:02

下载BT种子文件

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

磁力链接下载

magnet:?xt=urn:btih:b78557731e96fcbcac67b020c4a57339058a7fe5&dn=Udemy Excel with Interactive Excel Dashboards 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

Udemy Excel with Interactive Excel Dashboards.torrent

01 Introduction/001 Course Overview and Introduction to Excel Dashboards.mp419.73MB

02 Getting Your Data Ready/002 Ideal Data Formats.mp413.09MB

03 Design Principles/003 Getting Your Design Right.mp45.22MB

04 Display Principles/004 Charts and Tricks for Trending.mp437.37MB

04 Display Principles/005 Secondary Axis.mp44.74MB

04 Display Principles/006 Smoothing Data.mp412.25MB

04 Display Principles/007 Sparklines.mp449.35MB

04 Display Principles/008 Formatting Tricks.mp49.92MB

04 Display Principles/009 Highlighting Comparisons.mp413.28MB

04 Display Principles/010 Top and Bottom Ranking.mp424.04MB

04 Display Principles/011 Frequency Distribution.mp417.15MB

04 Display Principles/012 Target vs Variance Charts.mp412.08MB

04 Display Principles/013 Performance Against Target Range.mp411.07MB

04 Display Principles/014 Bullet Graphs.mp441.49MB

04 Display Principles/015 WinLossDraw Conditional Format.mp422.34MB

04 Display Principles/016 Dynamic Data Range.mp446.18MB

04 Display Principles/017 Dynamic Labels.mp46.39MB

04 Display Principles/018 Text Formulas.mp431.76MB

04 Display Principles/019 Symbols in Formulas and Charts.mp419.99MB

04 Display Principles/020 Charts Referencing Non-contiguous Ranges.mp45.81MB

04 Display Principles/021 Embedding Graphics in Charts.mp414.48MB

04 Display Principles/022 Dynamic, Dynamic Data Validation Lists.mp436.05MB

04 Display Principles/023 In Cell Charts.mp429.18MB

04 Display Principles/024 Panel Charts.mp431.92MB

04 Display Principles/025 Step Charts.mp429.38MB

04 Display Principles/026 Supplementary Excel Lecture Excel 2013 Chart Formatting.mp425.07MB

04 Display Principles/027 Supplementary Excel Lecture Excel 2013 Chart Labels.mp422.86MB

04 Display Principles/028 Supplementary Excel Lecture Excel 2013 Combo Charts.mp47.54MB

05 Interactive Controls/029 Form Controls Introduction.mp48.15MB

05 Interactive Controls/030 Check Boxes.mp410.21MB

05 Interactive Controls/031 List Boxes.mp468.22MB

05 Interactive Controls/032 Option Buttons.mp423.63MB

05 Interactive Controls/033 Group Boxes.mp46.8MB

05 Interactive Controls/034 Scroll Bar.mp49.87MB

05 Interactive Controls/035 Buttons.mp47.67MB

05 Interactive Controls/036 Combo Box with Macro.mp423.38MB

05 Interactive Controls/037 Dynamic Date Filters 4 Ways.mp496.51MB

05 Interactive Controls/038 Dynamic Named Range with OFFSET.mp420.37MB

05 Interactive Controls/039 Dynamic Named Range with INDEX.mp427.2MB

05 Interactive Controls/040 Dynamic Ranges for Charts.mp425.93MB

05 Interactive Controls/041 Animating Charts.mp457.74MB

05 Interactive Controls/042 INDIRECT Function Tricks.mp435.39MB

05 Interactive Controls/043 Rollover Technique.mp443.83MB

05 Interactive Controls/044 Scroll and Sort Table.mp477.13MB

05 Interactive Controls/045 Supplementary Excel Lecture Inserting Drop Down Lists.mp47.17MB

06 Analysing the Data/046 PivotCharts.mp420.73MB

06 Analysing the Data/047 Slicers.mp423.88MB

06 Analysing the Data/048 Capture Slicer Selection in Formula.mp416.18MB

06 Analysing the Data/049 GETPIVOTDATA Function.mp455.41MB

06 Analysing the Data/050 Slicer PivotChart Olympic Dashboard Overview.mp447.19MB

06 Analysing the Data/051 Supplementary Excel Lecture Creating PivotTables.mp46.08MB

06 Analysing the Data/052 Supplementary Excel Lecture Choosing Fields.mp47.56MB

06 Analysing the Data/053 Supplementary Excel Lecture PivotTable Layout.mp47.71MB

06 Analysing the Data/054 Supplementary Excel Lecture Filtering PivotTables.mp43.45MB

06 Analysing the Data/055 Supplementary Excel Lecture Modifying PivotTable Data.mp42.94MB

06 Analysing the Data/056 Supplementary Excel Lecture Insert a Table and Style Options.mp46.1MB

06 Analysing the Data/057 Supplementary Excel Lecture Add Rows and Columns to a Table.mp44.91MB

06 Analysing the Data/058 Supplementary Excel Lecture Perform a Function in a Table.mp47.99MB

06 Analysing the Data/059 Supplementary Excel Lecture Summarize a Table with a PivotTable.mp46.08MB

06 Analysing the Data/060 Supplementary Excel Lecture VLOOKUP Formula Sorted List.mp48.6MB

06 Analysing the Data/061 Supplementary Excel Lecture VLOOKUP Formula Exact Match.mp421.53MB

06 Analysing the Data/062 Supplementary Excel Lecture HLOOKUP Formula Sorted List.mp46.27MB

06 Analysing the Data/063 Supplementary Excel Lecture HLOOKUP Formula Exact Match.mp42.61MB

06 Analysing the Data/064 Supplementary Excel Lecture CHOOSE Function.mp412.83MB

06 Analysing the Data/065 Supplementary Excel Lecture INDEX and MATCH Formula.mp413.97MB

06 Analysing the Data/066 Supplementary Excel Lecture IF Function.mp417MB

06 Analysing the Data/067 Supplementary Excel Lecture Nested IF Formula.mp415.04MB

06 Analysing the Data/068 Supplementary Excel Lecture IF AND Formula.mp46.72MB

06 Analysing the Data/069 Supplementary Excel Lecture IF OR Formula.mp46.1MB

06 Analysing the Data/070 Supplementary Excel Lecture IF NOT Formula.mp44.7MB

06 Analysing the Data/071 Supplementary Excel Lecture IFERROR Function.mp45.28MB

06 Analysing the Data/072 Supplementary Excel Lecture SUMIF and SUMIFS Formulas.mp49.82MB

06 Analysing the Data/073 Supplementary Excel Lecture AVERAGEIF and AVERAGEIFS Formulas.mp411.44MB

06 Analysing the Data/074 Supplementary Excel Lecture COUNTIF and COUNTIFS Formulas.mp421.68MB

06 Analysing the Data/075 Supplementary Excel Lecture SUMPRODUCT Formula.mp429.52MB

07 Automating Your Dashboard/076 Linking to Access.mp432.43MB

07 Automating Your Dashboard/077 Incorporating New Data Automatically.mp437.54MB

07 Automating Your Dashboard/078 Auto Refresh PivotTables.mp413.27MB

07 Automating Your Dashboard/079 Supplementary Excel Lecture Introduction to Macros.mp49.6MB

07 Automating Your Dashboard/080 Supplementary Excel Lecture Recording a Macro.mp415.15MB

07 Automating Your Dashboard/081 Supplementary Excel Lecture Assign a Macro to a Button or Shape.mp411.94MB

07 Automating Your Dashboard/082 Supplementary Excel Lecture Run a Macro Upon Opening a Workbook.mp48.06MB

07 Automating Your Dashboard/083 Supplementary Excel Lecture How to Inspect and Modify a Macro.mp411.71MB

08 Putting It All Together/084 Quick Re-cap.mp44.12MB

08 Putting It All Together/085 Example Dashboard Tour.mp412.12MB

08 Putting It All Together/086 Pyramid Chart.mp431.98MB

08 Putting It All Together/087 Array Formula Alternative to SUMIFS.mp433.16MB

08 Putting It All Together/088 LARGE and SMALL Array and DAVERAGE.mp422.76MB

08 Putting It All Together/089 Rank Values with PivotTable.mp414.9MB

08 Putting It All Together/090 Scatter Chart.mp433.39MB

08 Putting It All Together/091 DMAX, DMIN, DAVERAGE.mp422.21MB

08 Putting It All Together/092 Formatting Quickly.mp427.44MB

09 Distributing Your Dashboard/093 Checking and Publishing.mp44.41MB

09 Distributing Your Dashboard/094 Excel Web App - Introduction.mp411.34MB

09 Distributing Your Dashboard/095 Preparing Your File for Excel Web App.mp421.43MB

09 Distributing Your Dashboard/096 Publish with Excel Web App.mp434.43MB

09 Distributing Your Dashboard/097 Password Protection.mp459.58MB

09 Distributing Your Dashboard/098 Supplementary Excel Lecture Workbook Passwords.mp46.32MB

09 Distributing Your Dashboard/099 Supplementary Excel Lecture Protecting Workbooks.mp44.58MB

09 Distributing Your Dashboard/100 Supplementary Excel Lecture Unlocking Cells.mp47.15MB

10 Bonus Tour de France Dashboard/101 Dashboard Overview.mp466.22MB

10 Bonus Tour de France Dashboard/102 SUMIFS Formula.mp426.74MB

10 Bonus Tour de France Dashboard/103 INDEX, MATCH and OFFSET Formula.mp423.68MB

10 Bonus Tour de France Dashboard/104 INDEX, MATCH Multiple Array Formula.mp413.34MB

10 Bonus Tour de France Dashboard/105 Zoom Images VBA Code.mp456.98MB

11 Homework/106 Myndas Homework Dashboard Part 1.mp448.25MB

11 Homework/107 Myndas Homework Dashboard Part 2.mp4106.67MB