| Excel MO-201 Exam Prep | |||
| 0. Course Intro | |||
| 1. Course Structure - Outline Video | |||
| bulkrseje35bt9cim690.mp4 | 128.54 MB | ||
| 2.DOWNLOAD%3a Course Resources | |||
| ExcelExpertCourseFiles-201118-105001.zip | 45.96 MB | ||
| MO201ExamStudyGuide-201118-104914.pdf | 5.72 MB | ||
| 3. Setting Expectations Video | |||
| buhgdtmje35bt9cid2qg.mp4 | 4.95 MB | ||
| 1. About the MO-201 Exam | |||
| 1. Exam Structure Video | |||
| buhge0uje35bt9cid2r0.mp4 | 2.76 MB | ||
| 2. Objective Domains - Skills Measured Video | |||
| buhge2ri57dcbr63pks0.mp4 | 3.94 MB | ||
| 3. Exam Interface - Scheduling Video | |||
| buhge5bi57dcbr63pksg.mp4 | 5.39 MB | ||
| 4. Helpful Resources Video | |||
| buhge93i57dcbr63pkt0.mp4 | 5.36 MB | ||
| 2. The Course Project | |||
| 1. Course Project Intro Video | |||
| buhgecbi57dcbr63pkug.mp4 | 2.76 MB | ||
| 2. The Airbnb Dataset Video | |||
| buhgeg3i57dcbr63pkv0.mp4 | 33.44 MB | ||
| 3. Advanced Formulas - Macros | |||
| 1. Objective Domain Intro Video | |||
| buhgekbi57dcbr63pkvg.mp4 | 4.06 MB | ||
| 10. The COUNTIF-SUMIF-AVERAGEIF Functions Video | |||
| buhgg23i57dcbr63pl40.mp4 | 42.22 MB | ||
| 11. COUNTIFS-SUMIFS-AVERAGEIFS for Multiple Criteria Video | |||
| buhggaeje35bt9cid30g.mp4 | 42.36 MB | ||
| 12. The MINIFS - MAXIFS Functions Video | |||
| buhgge3i57dcbr63pl50.mp4 | 16.32 MB | ||
| 13. Excel Date Values - Formatting Video | |||
| buhggi6je35bt9cid320.mp4 | 17.59 MB | ||
| 14. PRO TIP- Converting Text to Dates Video | |||
| buhggn6je35bt9cid32g.mp4 | 39.89 MB | ||
| 15. The TODAY - NOW Functions Video | |||
| buhggueje35bt9cid330.mp4 | 14.25 MB | ||
| 16. YEAR-MONTH-DAY - HOUR-MINUTE-SECOND Video | |||
| buhgh26je35bt9cid33g.mp4 | 15.91 MB | ||
| 17. WEEKDAY- WORKDAY - NETWORKDAYS Video | |||
| bummkp6je35bt9ciov4g.mp4 | 35.6 MB | ||
| 18. Recording a Macro Video | |||
| bumml53i57dcbr645eq0.mp4 | 55.7 MB | ||
| 19. Modifying - Deleting Macros Video | |||
| bummlquje35bt9ciov80.mp4 | 16.12 MB | ||
| 2. Fixed vs. Relative References Video | |||
| buhgeori57dcbr63pl00.mp4 | 23.45 MB | ||
| 20. PRO TIP- Adding Form Controls Video | |||
| bummmhji57dcbr645erg.mp4 | 15.89 MB | ||
| 21. Lookup Functions Video | |||
| bummmm3i57dcbr645es0.mp4 | 2.83 MB | ||
| 22. The VLOOKUP - HLOOKUP Functions Video | |||
| bummn3bi57dcbr645eug.mp4 | 93.87 MB | ||
| 23. The INDEX Function Video | |||
| bummn7ri57dcbr645f00.mp4 | 10.41 MB | ||
| 24. The MATCH Function Video | |||
| bummndeje35bt9ciovfg.mp4 | 12.07 MB | ||
| 25. Combining INDEX - MATCH Video | |||
| bummnpbi57dcbr645f1g.mp4 | 97.1 MB | ||
| 26. Approximate Match Lookups Video | |||
| bummo2ji57dcbr645f3g.mp4 | 20.73 MB | ||
| 27. The PMT - NPER Functions Video | |||
| bummomuje35bt9ciovj0.mp4 | 28.68 MB | ||
| 28. Scenario Manager Video | |||
| bummovbi57dcbr645f70.mp4 | 21.09 MB | ||
| 29. Consolidate Data Video | |||
| bummp7ri57dcbr645f7g.mp4 | 21.19 MB | ||
| 3. Explicit vs. Structured References Video | |||
| buhgesri57dcbr63pl10.mp4 | 26.65 MB | ||
| 30. Goal Seek Video | |||
| bummpfri57dcbr645f80.mp4 | 29.37 MB | ||
| 31. Formula Auditing Video | |||
| bummprmje35bt9ciovn0.mp4 | 42.35 MB | ||
| 4. Logical Operations Video | |||
| buhgf0uje35bt9cid2s0.mp4 | 6.32 MB | ||
| 5. The IF Function Video | |||
| buhgf4ri57dcbr63pl20.mp4 | 38.97 MB | ||
| 6. Nested IF Functions vs. The IFS Function Video | |||
| buhgfbuje35bt9cid2sg.mp4 | 53.65 MB | ||
| 7. The NOT - “--” Operators Video | |||
| buhgfg6je35bt9cid2t0.mp4 | 42.25 MB | ||
| 8. The AND-OR Operators Video | |||
| buhgfl6je35bt9cid2u0.mp4 | 54.03 MB | ||
| 9. The SWITCH Function Video | |||
| buhgfpji57dcbr63pl30.mp4 | 56.56 MB | ||
| 4. Manage - Format Data | |||
| 1. Objective Domain Intro Video | |||
| bummq3ji57dcbr645f9g.mp4 | 2.9 MB | ||
| 10. Formula-based Conditional Formatting Video | |||
| bummsvji57dcbr645fj0.mp4 | 67.99 MB | ||
| 11. Managing Conditional Formatting Rules Video | |||
| bummtkeje35bt9cip020.mp4 | 59.7 MB | ||
| 12. PRO TIP- Hiding Values to Create Heatmaps Video | |||
| bummtsmje35bt9cip03g.mp4 | 17.92 MB | ||
| 2. Custom Number Formats Video | |||
| bummqbbi57dcbr645fb0.mp4 | 32.15 MB | ||
| 3. Data Validation Video | |||
| bummqkeje35bt9ciovo0.mp4 | 31.49 MB | ||
| 4. Group - Ungroup Data Video | |||
| bummqs6je35bt9ciovpg.mp4 | 23.53 MB | ||
| 5. Subtotals - Totals Video | |||
| bummr4ri57dcbr645fg0.mp4 | 28.85 MB | ||
| 6. Removing Duplicates Video | |||
| bummrebi57dcbr645fhg.mp4 | 44.33 MB | ||
| 7. Auto Fill - Flash Fill Video | |||
| bummrrmje35bt9ciovt0.mp4 | 46.7 MB | ||
| 8. Advanced Fill Series Options Video | |||
| bumms36je35bt9ciovu0.mp4 | 29.84 MB | ||
| 9. Conditional Formatting Video | |||
| bummt9ri57dcbr645fkg.mp4 | 36.48 MB | ||
| 5. Advanced Charts - Tables | |||
| 1. Objective Domain Intro Video | |||
| bummucri57dcbr645fo0.mp4 | 3.34 MB | ||
| 10. Modifying Pivot Table Views Video | |||
| bumn71ji57dcbr645gng.mp4 | 12.34 MB | ||
| 11. -Summarize Values By- Options Video | |||
| bumn76ji57dcbr645gq0.mp4 | 15.6 MB | ||
| 12. -Show Values As- Calculations Video | |||
| bumn84ri57dcbr645gtg.mp4 | 32.04 MB | ||
| 13. Analyze - Design Tabs Video | |||
| bumn8amje35bt9cip170.mp4 | 3.18 MB | ||
| 14. Report Layouts - Options Video | |||
| bumn8p6je35bt9cip19g.mp4 | 16.05 MB | ||
| 15. Number Formatting Video | |||
| bumn916je35bt9cip1b0.mp4 | 26.41 MB | ||
| 16. Sorting - Filtering Video | |||
| bumn9ieje35bt9cip1d0.mp4 | 26.76 MB | ||
| 17. Slicers - Timelines Video | |||
| bumn9qeje35bt9cip1e0.mp4 | 13.6 MB | ||
| 18. Grouping Text Fields Video | |||
| bumn9uri57dcbr645h5g.mp4 | 10.45 MB | ||
| 19. Grouping Numerical Fields Video | |||
| bumna5eje35bt9cip1fg.mp4 | 20.66 MB | ||
| 2. Box - Whisker Chart Video | |||
| bumn466je35bt9cip0n0.mp4 | 25.57 MB | ||
| 20. Grouping Date Fields Video | |||
| bumnabeje35bt9cip1g0.mp4 | 18.86 MB | ||
| 21. Calculated Fields Video | |||
| bun7663i57dcbr646osg.mp4 | 34.5 MB | ||
| 22. Calculated Items Video | |||
| bun76deje35bt9ciq7t0.mp4 | 20.16 MB | ||
| 23. Pivot Charts Video | |||
| bun790uje35bt9ciq8a0.mp4 | 16.88 MB | ||
| 24. Pivot Chart Formatting Video | |||
| bun79j3i57dcbr646p7g.mp4 | 7.99 MB | ||
| 25. Expanding - Collapsing Pivot Charts Video | |||
| bun79puje35bt9ciq8bg.mp4 | 12.39 MB | ||
| 3. Histogram Video | |||
| bumn4buje35bt9cip0og.mp4 | 19.45 MB | ||
| 4. Filled Map Video | |||
| bumn4hri57dcbr645gb0.mp4 | 25.04 MB | ||
| 5. Combo Chart Video | |||
| bumn4ori57dcbr645gd0.mp4 | 39.9 MB | ||
| 6. Tree Map - Sunburst Chart Video | |||
| bumn53eje35bt9cip0s0.mp4 | 30.77 MB | ||
| 7. Waterfall Chart Video | |||
| bumn58ji57dcbr645gfg.mp4 | 14.87 MB | ||
| 8. Funnel Chart Video | |||
| bumn5eeje35bt9cip0sg.mp4 | 18.27 MB | ||
| 9. Creating a Pivot Table Video | |||
| bumn5mmje35bt9cip0tg.mp4 | 39.44 MB | ||
| 6. Workbook Options - Settings | |||
| 1. Objective Domain Intro Video | |||
| bun7a0mje35bt9ciq8c0.mp4 | 2.94 MB | ||
| 10. Language Options Video | |||
| bun7c2ri57dcbr646pe0.mp4 | 24.33 MB | ||
| 2. Enabling Macros Video | |||
| bun7anri57dcbr646p8g.mp4 | 7.24 MB | ||
| 3. Copying Macros to Other Files Video | |||
| bun7asji57dcbr646p90.mp4 | 13.03 MB | ||
| 4. Linking Data Across Workbooks Video | |||
| bun7b2ji57dcbr646pag.mp4 | 29.52 MB | ||
| 5. Protecting Worksheets - Cell Ranges Video | |||
| bun7b8ri57dcbr646pb0.mp4 | 25.85 MB | ||
| 6. Protecting - Encrypting Workbooks Video | |||
| bun7bh3i57dcbr646pbg.mp4 | 15.67 MB | ||
| 7. Recovering Workbooks Video | |||
| bun7bl3i57dcbr646pc0.mp4 | 15.57 MB | ||
| 8. Managing Comments Video | |||
| bun7bqji57dcbr646pcg.mp4 | 21.61 MB | ||
| 9. Formula Calculation Modes Video | |||
| bun7buji57dcbr646pd0.mp4 | 20.52 MB | ||
| 7. Practice Test | |||
| 1. Practice Test Intro Video | |||
| buqc266je35bt9cj1e30.mp4 | 3.95 MB | ||
| 3. Practice Test Structure Video | |||
| buqc4p6je35bt9cj1e5g.mp4 | 13.95 MB | ||
| 4. SOLUTION- Project 1 Video | |||
| buqc70bi57dcbr64e53g.mp4 | 42.44 MB | ||
| 5. SOLUTION- Project 2 Video | |||
| buqc85ri57dcbr64e56g.mp4 | 28.82 MB | ||
| 6. SOLUTION- Project 3 Video | |||
| buqc913i57dcbr64e580.mp4 | 31.38 MB | ||
| 7. SOLUTION- Project 4 Video | |||
| buqcacbi57dcbr64e5d0.mp4 | 39.24 MB | ||
| 8. SOLUTION- Project 5 Video | |||
| buqcbvmje35bt9cj1eeg.mp4 | 46.93 MB | ||
| 9. SOLUTION- Project 6 Video | |||
| buqcd0mje35bt9cj1ehg.mp4 | 23.77 MB | ||
| 8. Feedback Survey - Next Steps | |||
| 2. Share the love- Text | |||
| Share the love-.html | 152 B | ||
| 3. Next Steps Text | |||
| Next Steps.html | 3.59 KB | ||
| Excel Pro Tips- Analytics | |||
| 0. Course Intro | |||
| 1. Course Structure - Outline Video | |||
| bjcsf51ujavq7bbf9gog.mp4 | 114.32 MB | ||
| 2.DOWNLOAD%3a Course Resources | |||
| Excel_Pro_Tips-1560900902764.pdf | 14.29 MB | ||
| ProTipWorkbooks-1554822204518.zip | 60.86 MB | ||
| kickstarter_projects-1554822241991 (1).csv | 55.34 MB | ||
| 3. Setting Expectations Video | |||
| biht1e1ujavq7bbeu6eg.mp4 | 8.12 MB | ||
| 1. Analytics Tips | |||
| 1. Introduction Video | |||
| bihtgk1ujavq7bbeu7dg.mp4 | 36.77 MB | ||
| 10. CUBE Functions Video | |||
| bihthmhujavq7bbeu7f0.mp4 | 156.2 MB | ||
| 11. Monte Carlo Simulation Video | |||
| bihtgh9ujavq7bbeu7d0.mp4 | 98.72 MB | ||
| 12. Advanced Optimization with Solver Video | |||
| bihtfmdnkrnfm4n3lf10.mp4 | 100.4 MB | ||
| 13. Analysis ToolPak -Preview- Video | |||
| bihthr9ujavq7bbeu7fg.mp4 | 85.79 MB | ||
| 2. Quick Analysis Tools Video | |||
| bihtfttnkrnfm4n3lf1g.mp4 | 47.86 MB | ||
| 3. Scenario Manager Video | |||
| bihtfqpujavq7bbeu7c0.mp4 | 76.19 MB | ||
| 4. Optimization with Goal Seek Video | |||
| bihtgndnkrnfm4n3lf30.mp4 | 52.95 MB | ||
| 5. Basic Forecasting Video | |||
| bihtgulnkrnfm4n3lf3g.mp4 | 121.25 MB | ||
| 6. Outlier Detection Video | |||
| bihtgahujavq7bbeu7cg.mp4 | 87.26 MB | ||
| 7. Automated Data Tables Video | |||
| bihth39ujavq7bbeu7e0.mp4 | 76.97 MB | ||
| 8. Power Query Tools Video | |||
| bihtg5dnkrnfm4n3lf2g.mp4 | 116.39 MB | ||
| 9. Data Modeling 101 Video | |||
| bihthd9ujavq7bbeu7eg.mp4 | 162.84 MB | ||
| 2. Next Steps | |||
| 2. Share the love- Text | |||
| Share the love-.html | 152 B | ||
| 3. Next Steps Text | |||
| Next Steps.html | 4.15 KB | ||
| Excel Pro Tips- Data Visualization | |||
| 0. Course Intro | |||
| 1. Course Structure - Outline Video | |||
| bjcsf51ujavq7bbf9gog.mp4 | 114.32 MB | ||
| 2.DOWNLOAD%3a Course Resources | |||
| Excel_Pro_Tips-1560900837467.pdf | 14.29 MB | ||
| ProTipWorkbooks-1554822204518.zip | 60.86 MB | ||
| 3. Setting Expectations Video | |||
| biht1e1ujavq7bbeu6eg.mp4 | 8.12 MB | ||
| 1. Visualization Tips | |||
| 1. Introduction Video | |||
| bihtbclnkrnfm4n3leq0.mp4 | 32.24 MB | ||
| 10. Goal Pacing with Gauge Charts Video | |||
| bihtbtlnkrnfm4n3lerg.mp4 | 65.04 MB | ||
| 11. Highlighting Time Periods Video | |||
| bihtcmpujavq7bbeu760.mp4 | 72.17 MB | ||
| 12. Dynamic Source Ranges Video | |||
| bihtcipujavq7bbeu75g.mp4 | 146.02 MB | ||
| 13. Interactive Form Controls Video | |||
| bihtc6hujavq7bbeu74g.mp4 | 164.49 MB | ||
| 2. Chart Properties -Move - Size- Video | |||
| bihtbahujavq7bbeu730.mp4 | 79.25 MB | ||
| 3. Hidden Chart Source Data Video | |||
| bihtbllnkrnfm4n3leqg.mp4 | 41.08 MB | ||
| 4. Filled Maps -Excel 2016-- Video | |||
| bihtc9pujavq7bbeu750.mp4 | 53.82 MB | ||
| 5. Customizing Charts to Tell a Story Video | |||
| bihtcqdnkrnfm4n3lesg.mp4 | 59.95 MB | ||
| 6. Adding Sparklines Video | |||
| bihtb61ujavq7bbeu72g.mp4 | 51.77 MB | ||
| 7. Custom Chart Templates Video | |||
| bihtb35nkrnfm4n3lepg.mp4 | 46.71 MB | ||
| 8. Heat Maps with Color Scales Video | |||
| bihtbpdnkrnfm4n3ler0.mp4 | 66.19 MB | ||
| 9. Analyzing Distribution with Histograms Video | |||
| bihtbi9ujavq7bbeu73g.mp4 | 102.6 MB | ||
| 2. Next Steps | |||
| 2. Share the love- Text | |||
| Share the love-.html | 152 B | ||
| 3. Next Steps Text | |||
| Next Steps.html | 4.32 KB | ||
| Excel Pro Tips- Formatting | |||
| 0. Course Intro | |||
| 1. Course Structure - Outline Video | |||
| bjcsf51ujavq7bbf9gog.mp4 | 114.32 MB | ||
| 2.DOWNLOAD%3a Course Resources | |||
| Excel_Pro_Tips-1560900767291.pdf | 14.29 MB | ||
| ProTipWorkbooks-1554822204518.zip | 60.86 MB | ||
| 3. Setting Expectations Video | |||
| biht1e1ujavq7bbeu6eg.mp4 | 8.12 MB | ||
| 1. Formatting Tips | |||
| 1. Introduction Video | |||
| biht2qhujavq7bbeu6i0.mp4 | 34.1 MB | ||
| 10. Zip Codes - Phone Numbers Video | |||
| biht18tnkrnfm4n3le70.mp4 | 45.47 MB | ||
| 11. Grouping Columns - Rows Video | |||
| biht3i5nkrnfm4n3lec0.mp4 | 129.22 MB | ||
| 12. Formatting Errors with IFERROR Video | |||
| biht2vhujavq7bbeu6ig.mp4 | 60.39 MB | ||
| 13. Converting Text to Date Values Video | |||
| biht2g5nkrnfm4n3le90.mp4 | 284.06 MB | ||
| 14. Formula-Based Formats Video | |||
| biht4lhujavq7bbeu6l0.mp4 | 165.25 MB | ||
| 15. Advanced Number Formats Video | |||
| biht5o5nkrnfm4n3lef0.mp4 | 205.09 MB | ||
| 2. Formatting Shortcuts Video | |||
| biht4r1ujavq7bbeu6lg.mp4 | 45.25 MB | ||
| 3. Snap to Grid Video | |||
| biht2ipujavq7bbeu6h0.mp4 | 31.19 MB | ||
| 4. Hiding Workbook Elements Video | |||
| biht32lnkrnfm4n3leag.mp4 | 32.17 MB | ||
| 5. Format Painter Video | |||
| biht571ujavq7bbeu6mg.mp4 | 97.81 MB | ||
| 6. Color - Border Design Video | |||
| biht1h1ujavq7bbeu6fg.mp4 | 70.76 MB | ||
| 7. Freezing Panes Video | |||
| biht451ujavq7bbeu6k0.mp4 | 193.95 MB | ||
| 8. Center Across Selection Video | |||
| biht5qhujavq7bbeu6n0.mp4 | 44.45 MB | ||
| 9. Invisible Text Formatting Video | |||
| biht2ndnkrnfm4n3le9g.mp4 | 39.95 MB | ||
| 2. Next Steps | |||
| 2. Share the love- Text | |||
| Share the love-.html | 152 B | ||
| 3. Next Steps Text | |||
| Next Steps.html | 4.16 KB | ||
| Excel Pro Tips- Formulas | |||
| 0. Course Intro | |||
| 1. Course Structure - Outline Video | |||
| bjcsf51ujavq7bbf9gog.mp4 | 114.32 MB | ||
| 2.DOWNLOAD%3a Course Resources | |||
| Excel_Pro_Tips-1560900803824.pdf | 14.29 MB | ||
| ProTipWorkbooks-1554822204518_2.zip | 60.86 MB | ||
| 3. Setting Expectations Video | |||
| biht1e1ujavq7bbeu6eg.mp4 | 8.12 MB | ||
| 1. Formula Tips | |||
| 1. Introduction Video | |||
| biht9hdnkrnfm4n3leng.mp4 | 38.26 MB | ||
| 10. Hyperlinking Between Worksheets Video | |||
| biht9t5nkrnfm4n3leo0.mp4 | 109.28 MB | ||
| 11. -Fuzzy Match- Lookups Video | |||
| bihta39ujavq7bbeu710.mp4 | 112.09 MB | ||
| 12. Random Selection with OFFSET - RANDBETWEEN Video | |||
| biht8d1ujavq7bbeu6ug.mp4 | 130.15 MB | ||
| 13. Combining INDEX - MATCH Video | |||
| biht9n9ujavq7bbeu70g.mp4 | 103.56 MB | ||
| 14. Matching Items Between Lists Video | |||
| biht91pujavq7bbeu6v0.mp4 | 213.77 MB | ||
| 15. Counting Duplicates with SUMPRODUCT Video | |||
| biht7v1ujavq7bbeu6tg.mp4 | 103.11 MB | ||
| 16. Many-to-Many Lookups Video | |||
| biht9b9ujavq7bbeu6vg.mp4 | 171.04 MB | ||
| 2. Manual vs. Automatic Calculation Video | |||
| bihtakdnkrnfm4n3leog.mp4 | 65.91 MB | ||
| 3. Formula Line Breaks Video | |||
| biht9epujavq7bbeu700.mp4 | 58.64 MB | ||
| 4. Converting Units of Measurement Video | |||
| bihtafpujavq7bbeu720.mp4 | 104.14 MB | ||
| 5. Real-Time Tools with TODAY - NOW Video | |||
| bl9du2jje7ib1ccr5j30.mp4 | 97.21 MB | ||
| 6. Formula Auditing Tools Video | |||
| bihtarlnkrnfm4n3lep0.mp4 | 107.81 MB | ||
| 7. Pivot-Style Reports with Formulas Video | |||
| biht8m5nkrnfm4n3len0.mp4 | 158.55 MB | ||
| 8. Counting Words in a Cell Video | |||
| biht7otnkrnfm4n3lemg.mp4 | 189.55 MB | ||
| 9. Dependent Drop-Downs with INDIRECT Video | |||
| bihta8pujavq7bbeu71g.mp4 | 95.76 MB | ||
| 2. Next Steps | |||
| 2. Share the love- Text | |||
| Share the love-.html | 152 B | ||
| 3. Next Steps Text | |||
| Next Steps.html | 3.88 KB | ||
| Excel Pro Tips- Pivot Tables | |||
| 0. Course Intro | |||
| 1. Course Structure - Outline Video | |||
| bjcsf51ujavq7bbf9gog.mp4 | 114.32 MB | ||
| 2.DOWNLOAD%3a Course Resources | |||
| Excel_Pro_Tips-1560900871360.pdf | 14.29 MB | ||
| ProTipWorkbooks1554822204518-200417-093239.zip | 60.86 MB | ||
| 3. Setting Expectations Video | |||
| biht1e1ujavq7bbeu6eg.mp4 | 8.12 MB | ||
| 1. PivotTable Tips | |||
| 1. Introduction Video | |||
| bihte51ujavq7bbeu78g.mp4 | 24.97 MB | ||
| 10. Showing Empty Items Video | |||
| bihteetnkrnfm4n3levg.mp4 | 69.78 MB | ||
| 11. Configuring Slicers - Timelines Video | |||
| bihtdntnkrnfm4n3leu0.mp4 | 105.65 MB | ||
| 12. Conditional Formatting Video | |||
| bihtf3lnkrnfm4n3lf0g.mp4 | 127.33 MB | ||
| 13. Removing - Reviving Source Data Video | |||
| bihtdudnkrnfm4n3leug.mp4 | 106.3 MB | ||
| 14. Adding Custom Sort Lists Video | |||
| bihtephujavq7bbeu79g.mp4 | 59.29 MB | ||
| 15. Solve Order - List Formulas Video | |||
| bihtdgpujavq7bbeu77g.mp4 | 61.85 MB | ||
| 2. Customizing the Field List Video | |||
| bihte8lnkrnfm4n3lev0.mp4 | 40.86 MB | ||
| 3. Autofitting Column Width Video | |||
| bihtf81ujavq7bbeu7a0.mp4 | 80.94 MB | ||
| 4. Outline - Tabular Layouts Video | |||
| bihtdd9ujavq7bbeu770.mp4 | 77.8 MB | ||
| 5. Counting Non-Numerical Fields Video | |||
| bihteslnkrnfm4n3lf00.mp4 | 51 MB | ||
| 6. Grouping Dates Video | |||
| bihtelpujavq7bbeu790.mp4 | 77.85 MB | ||
| 7. Enabling Multiple Filters Video | |||
| bihte31ujavq7bbeu780.mp4 | 64.16 MB | ||
| 8. Grouping Values Video | |||
| bihtd3tnkrnfm4n3let0.mp4 | 55.33 MB | ||
| 9. Adding Value Calculations Video | |||
| bihtd8tnkrnfm4n3letg.mp4 | 61.08 MB | ||
| 2. Next Steps | |||
| 2. Share the love- Text | |||
| Share the love-.html | 152 B | ||
| 3. Next Steps Text | |||
| Next Steps.html | 4.16 KB | ||
| Excel Pro Tips- Productivity | |||
| 0. Course Intro | |||
| 1. Course Structure - Outline Video | |||
| bjcsf51ujavq7bbf9gog.mp4 | 114.32 MB | ||
| 2. Course Structure & Outline | |||
| Excel_Pro_Tips-1560900716028.pdf | 14.29 MB | ||
| ProTipWorkbooks-1554822204518_3.zip | 60.86 MB | ||
| 3. Setting Expectations Video | |||
| biht1e1ujavq7bbeu6eg.mp4 | 8.12 MB | ||
| 1. Productivity Tips | |||
| 1. Introduction Video | |||
| biht37hujavq7bbeu6j0.mp4 | 39.27 MB | ||
| 10. Splitting Text to Columns Video | |||
| biht4ldnkrnfm4n3ledg.mp4 | 144.48 MB | ||
| 11. Synchronous Scrolling Video | |||
| biht4qtnkrnfm4n3lee0.mp4 | 38.09 MB | ||
| 12. Extracting Unique Values Video | |||
| biht45pujavq7bbeu6kg.mp4 | 67.92 MB | ||
| 13. Named Range - Table References Video | |||
| biht5itnkrnfm4n3leeg.mp4 | 162.2 MB | ||
| 14. Protecting Cells - Formulas Video | |||
| biht3epujavq7bbeu6jg.mp4 | 65.78 MB | ||
| 15. Multi-Level Row - Column Sorting Video | |||
| biht3utnkrnfm4n3lecg.mp4 | 159.2 MB | ||
| 16. Advanced Filter Criteria Video | |||
| biht0rpujavq7bbeu6d0.mp4 | 145.52 MB | ||
| 2. Customizing the Footer Video | |||
| biht2ulnkrnfm4n3lea0.mp4 | 51.58 MB | ||
| 3. CTRL Shortcuts Video | |||
| biht24lnkrnfm4n3le8g.mp4 | 193.31 MB | ||
| 4. ALT Key Tips Video | |||
| biht1a9ujavq7bbeu6e0.mp4 | 118.55 MB | ||
| 5. -Go To- Special Options Video | |||
| biht32lnkrnfm4n3leb0.mp4 | 32.34 MB | ||
| 6. Removing Blank Rows Video | |||
| biht1ehujavq7bbeu6f0.mp4 | 31.53 MB | ||
| 7. Data Validation Drop-Downs Video | |||
| biht2a1ujavq7bbeu6gg.mp4 | 53.08 MB | ||
| 8. Autofill - Flash Fill Video | |||
| biht2o9ujavq7bbeu6hg.mp4 | 131.75 MB | ||
| 9. Customizing the Ribbon Video | |||
| biht511ujavq7bbeu6m0.mp4 | 61.34 MB | ||
| 2. Next Steps | |||
| 2. Share the love- Text | |||
| Share the love-.html | 152 B | ||
| 3. Next Steps Text | |||
| Next Steps.html | 3.89 KB | ||
| Maven Analytics - DATA PLAYGROUND (Test & Work Assignment) | |||
| 120 years of Olympic History | |||
| Olympic_Athletes.zip | 5.29 MB | ||
| UbmlZj1.png | 90.84 KB | ||
| Airline Flight Delays | |||
| Airlines+Airports+Cancellation+Codes+&+Flights.zip | 185.92 MB | ||
| WDZ1zpn.png | 92.58 KB | ||
| YLM3ibk.png | 89.81 KB | ||
| Inc 5000 Companies | |||
| INC+5000+Companies+2019.csv.zip | 233.68 KB | ||
| JMVi6eq.png | 79.44 KB | ||
| Jordan & LeBron Career Stats | |||
| Jordan+vs.+Lebron+Data.zip | 72.25 KB | ||
| rufp9XI (1).png | 75.21 KB | ||
| Madrid Daily Weather | |||
| MBbctH4.png | 79.73 KB | ||
| Madrid+Daily+Weather+1997-2015.csv.zip | 137.66 KB | ||
| Marketing Campaign Results | |||
| 8uVPBte.png | 72.13 KB | ||
| Marketing+Data.zip | 54.15 KB | ||
| Movie Ratings | |||
| Rotten+Tomatoes+Movies.csv.zip | 9.47 MB | ||
| ftRwylE.png | 94.53 KB | ||
| NYC Traffic Accidents | |||
| NYC+Accidents+2020.csv.zip | 2.49 MB | ||
| ZwyENCK.png | 87.03 KB | ||
| New Year's Eve Resolutions | |||
| 5UXuOZG.png | 74.49 KB | ||
| New_years_resolutions.zip | 246.95 KB | ||
| Online Chess Games | |||
| 4YqYbbA.png | 72.67 KB | ||
| Online+Chess+Games.zip | 2.35 MB | ||
| S&P 500 Stock Prices | |||
| S&P+500+Stock+Prices+2014-2017.csv.zip | 7.74 MB | ||
| VxHJzpX.png | 79.37 KB | ||
| Shark Attacks | |||
| 6kKoU0N.png | 92.04 KB | ||
| attacks.csv.zip | 534.6 KB | ||
| Spotify Top 100 | |||
| Kc60hrr.png | 70.37 KB | ||
| top2018.csv.zip | 7.47 KB | ||
| UFO Sightings | |||
| LlLLEbr.png | 89.03 KB | ||
| ufo_sightings_scrubbed.csv.zip | 4.81 MB | ||
| Wine Tasting | |||
| 6Nxrev6.png | 78.85 KB | ||
| winemag-data-130k-v2.csv.zip | 16.15 MB | ||
| World Cup | |||
| Q9wZHny.png | 91.62 KB | ||
| World+Cups+Matches+&+Players.zip | 351.28 KB | ||
| Microsoft Excel- Charts - Graphs | |||
| 0. Orientation - Benchmark Assessment | |||
| 1. Welcome to the Course- Text | |||
| Welcome to the Course-.html | 3.18 KB | ||
| 1. Course Intro | |||
| 1. Course Structure - Outline Video | |||
| bjcsdc5nkrnfm4n40n00.mp4 | 15.64 MB | ||
| 2.DOWNLOAD%3a Course Resources | |||
| DataVizDemoWorkbooks-200211-162500.zip | 1.2 MB | ||
| DataVizHomeworkWorkbooks-1554821330911.zip | 3.37 MB | ||
| Excel_Charts__Graphs-1560900499179.pdf | 2.03 MB | ||
| Thermometer-1554821337358.png | 31.89 KB | ||
| ThumbsUp-1554821339997.png | 30.4 KB | ||
| 3. Setting Expectations Video | |||
| bk79ss5nkrnfm4n4die0.mp4 | 9.43 MB | ||
| 2. Data Visualization Best Practices | |||
| 1. Key Data Viz Principles - the 10-Second Rule Video | |||
| bih3q22meheka336a9t0.mp4 | 7.22 MB | ||
| 2. The Good- the Bad- and the Ugly Video | |||
| bih3q2ameheka336a9tg.mp4 | 10.16 MB | ||
| 3. The 3 Key Questions Video | |||
| bih3q2nf2qij22kstov0.mp4 | 4.43 MB | ||
| 3. Customizing Charts in Excel | |||
| 1. Chart Elements- Layouts- Colors - Styles Video | |||
| bih3qo2meheka336a9vg.mp4 | 21.37 MB | ||
| 2. Chart Formatting Options Video | |||
| bih3qpff2qij22kstp00.mp4 | 17.14 MB | ||
| 3. Changing Chart Types - Adding a Secondary Axis Video | |||
| bih3qpvf2qij22kstp0g.mp4 | 9.6 MB | ||
| 4. Creating- Modifying - Applying Custom Templates Video | |||
| bih3qq2meheka336aa00.mp4 | 14.02 MB | ||
| 4. Mastering Basic Charts - Graphs | |||
| 1. Bar - Column Charts Video | |||
| bih3s2ameheka336aa2g.mp4 | 28.75 MB | ||
| 10. HOMEWORK- Pies- Donuts - Race Tracks Text | |||
| HOMEWORK- Pies- Donuts - Race Tracks.html | 1.27 KB | ||
| 11. Scatter Plots Video | |||
| bih3s5qmeheka336aa3g.mp4 | 29.19 MB | ||
| 12. Bubble Charts Video | |||
| bih3s6qmeheka336aa40.mp4 | 23.09 MB | ||
| 13. HOMEWORK- Scatter Plots - Bubble Charts Text | |||
| HOMEWORK- Scatter Plots - Bubble Charts.html | 1.5 KB | ||
| 14. Box - Whisker Charts -Office 365-2016-- Video | |||
| bih3s7ff2qij22kstp30.mp4 | 18.11 MB | ||
| 15. HOMEWORK- Box - Whisker Charts Text | |||
| HOMEWORK- Box - Whisker Charts.html | 1.08 KB | ||
| 16. Tree Maps - Sunburst Charts -Office 365-2016-- Video | |||
| bih3s7imeheka336aa4g.mp4 | 20.17 MB | ||
| 17. HOMEWORK- Tree Maps - Sunburst Charts Text | |||
| HOMEWORK- Tree Maps - Sunburst Charts.html | 1.06 KB | ||
| 18. Waterfall Charts -Office 365-2016-- Video | |||
| bih3s87f2qij22kstp3g.mp4 | 9.52 MB | ||
| 19. Funnel Charts -Office 365-2016-- Video | |||
| bih3s97f2qij22kstp40.mp4 | 10.74 MB | ||
| 2. HOMEWORK- Bar - Column Charts Text | |||
| HOMEWORK- Bar - Column Charts.html | 1.16 KB | ||
| 20. HOMEWORK- Waterfall - Funnel Charts Text | |||
| HOMEWORK- Waterfall - Funnel Charts.html | 1.19 KB | ||
| 21. Radar Charts Video | |||
| bih3s9imeheka336aa50.mp4 | 23.99 MB | ||
| 22. HOMEWORK- Radar Charts Text | |||
| HOMEWORK- Radar Charts.html | 973 B | ||
| 23. Stock Charts Video | |||
| bih3saimeheka336aa5g.mp4 | 24.47 MB | ||
| 24. HOMEWORK- Stock Charts Text | |||
| HOMEWORK- Stock Charts.html | 789 B | ||
| 25. Heat Maps Video | |||
| bih3sc2meheka336aa60.mp4 | 14.73 MB | ||
| 26. HOMEWORK- Heat Maps Text | |||
| HOMEWORK- Heat Maps.html | 983 B | ||
| 27. Surface - Contour Charts Video | |||
| bih3sbnf2qij22kstp4g.mp4 | 24.65 MB | ||
| 28. HOMEWORK- Surface - Contour Charts Text | |||
| HOMEWORK- Surface - Contour Charts.html | 847 B | ||
| 29. Geo-Spatial Maps with Power Map Video | |||
| bih3scameheka336aa6g.mp4 | 18.66 MB | ||
| 3. Histogram - Pareto Charts -Office 365-2016-- Video | |||
| bih3s2vf2qij22kstp1g.mp4 | 22.36 MB | ||
| 30. HOMEWORK- Power Map Text | |||
| HOMEWORK- Power Map.html | 719 B | ||
| 31. Basic Combo Charts Video | |||
| bih3scvf2qij22kstp50.mp4 | 27.64 MB | ||
| 32. HOMEWORK- Combo Charts Text | |||
| HOMEWORK- Combo Charts.html | 1.29 KB | ||
| 33. Sparklines Video | |||
| bih3sd2meheka336aa70.mp4 | 6.16 MB | ||
| 34. HOMEWORK- Sparklines Text | |||
| HOMEWORK- Sparklines.html | 737 B | ||
| 4. HOMEWORK- Histogram - Pareto Charts Text | |||
| HOMEWORK- Histogram - Pareto Charts .html | 765 B | ||
| 5. Line Charts - Trendlines Video | |||
| bih3s3ff2qij22kstp20.mp4 | 15.54 MB | ||
| 6. HOMEWORK- Line Charts - Trendlines Text | |||
| HOMEWORK- Line Charts - Trendlines.html | 970 B | ||
| 7. Area Charts Video | |||
| bih3s3imeheka336aa30.mp4 | 14.94 MB | ||
| 8. HOMEWORK- Area Charts Text | |||
| HOMEWORK- Area Charts.html | 1.06 KB | ||
| 9. Pies- Donuts - Race Tracks Video | |||
| bih3s5ff2qij22kstp2g.mp4 | 37.52 MB | ||
| 5. Next-Level Data Visualization Exercises | |||
| 1. Setting Expectations Video | |||
| bih43uvf2qij22kstpe0.mp4 | 4.35 MB | ||
| 10. DEMO- Dynamically Highlighting a Data Series Video | |||
| bih445qmeheka336aag0.mp4 | 44.26 MB | ||
| 11. DEMO- Building a Custom Pacing Chart Video | |||
| bih446imeheka336aagg.mp4 | 48.65 MB | ||
| 12. DEMO- Designing a Custom Gauge Chart Video | |||
| bih447ameheka336aah0.mp4 | 34.17 MB | ||
| 13. DEMO- Visualizing a Percentage Using Array Functions Video | |||
| bih447vf2qij22kstpg0.mp4 | 26.98 MB | ||
| 2. DEMO- Custom Image Overlay Charts Video | |||
| bm4lsqal9tga33sbd9rg.mp4 | 29.58 MB | ||
| 3. DEMO- Adding Binary Values to Highlight Date Ranges Video | |||
| bih43vimeheka336aadg.mp4 | 17.03 MB | ||
| 4. DEMO- Automation with OFFSET- COUNTA - Named Ranges Video | |||
| bih4402meheka336aae0.mp4 | 25.7 MB | ||
| 5. DEMO- Adding Scroll - Zoom Functionality with Form Controls Video | |||
| bih440nf2qij22kstpf0.mp4 | 48.15 MB | ||
| 6. DEMO- Animating Changes Over Time Video | |||
| bih441imeheka336aaeg.mp4 | 59.75 MB | ||
| 7. DEMO- Building a Dynamic Dashboard -Part 1- Video | |||
| bih442qmeheka336aaf0.mp4 | 73.06 MB | ||
| 8. DEMO- Building a Dynamic Dashboard -Part 2- Video | |||
| bih444nf2qij22kstpfg.mp4 | 49.41 MB | ||
| 9. DEMO- Value-Based Dynamic Formatting Video | |||
| bih445ameheka336aafg.mp4 | 46.14 MB | ||
| 7. Final Assessment - Next Steps | |||
| 2. Share the love- Text | |||
| Share the love-.html | 152 B | ||
| 3. Next Steps Text | |||
| Next Steps.html | 4.44 KB | ||
| Microsoft Excel- Formulas - Functions | |||
| 0. Orientation - Benchmark Assessment | |||
| 1. Welcome to the Course- Text | |||
| Welcome to the Course-.html | 2.92 KB | ||
| 1. Course Intro | |||
| 1. Course Structure - Outline Video | |||
| bjcsct5nkrnfm4n40mv0.mp4 | 15.84 MB | ||
| 2.DOWNLOAD%3a Course Resources | |||
| ExcelDemoWorkbooks-200226-124417.zip | 5.33 MB | ||
| ExcelHomeworkWorkbooks-1560783659577.zip | 138.5 KB | ||
| Excel_Formulas__Functions-200226-125141.pdf | 2.44 MB | ||
| 3. Setting Expectations Video | |||
| bk3qn09ujavq7bbfl26g.mp4 | 23.62 MB | ||
| 10. Bonus Functions | |||
| 1. Introduction Video | |||
| billgolnkrnfm4n3n470.mp4 | 8.16 MB | ||
| 2. The INDIRECT Function Video | |||
| bif31cameheka3369dpg.mp4 | 22.59 MB | ||
| 3. The HYPERLINK Function Video | |||
| bif31e7f2qij22kssrr0.mp4 | 11.85 MB | ||
| 4. WEBSERVICE - FILTERXML Demo- Weather Underground Video | |||
| bif327qmeheka3369du0.mp4 | 20.06 MB | ||
| 5. WEBSERVICE - FILTERXML Demo- Open Weather Map Video | |||
| bif2v8vf2qij22kssre0.mp4 | 195.04 MB | ||
| 12. Final Assessment - Next Steps | |||
| 2. Share the love- Text | |||
| Share the love-.html | 152 B | ||
| 3. Next Steps Text | |||
| Next Steps.html | 4.09 KB | ||
| 2. Excel Formulas 101 | |||
| 1. Introduction Video | |||
| bk3r26lnkrnfm4n4c9l0.mp4 | 4.98 MB | ||
| 10. PRO TIP- Data Validation Video | |||
| bk3rkh5nkrnfm4n4ca0g.mp4 | 39.32 MB | ||
| 11. Congrats- You-re a Developer- Video | |||
| bk3rl65nkrnfm4n4ca10.mp4 | 26.94 MB | ||
| 13. HOMEWORK- Formulas 101 Video | |||
| bk3srtdnkrnfm4n4camg.mp4 | 4.3 MB | ||
| 2. Formula Syntax Video | |||
| bk3r4v9ujavq7bbfl2p0.mp4 | 218.32 MB | ||
| 3. Fixed - Relative References Video | |||
| bk3r5p9ujavq7bbfl2pg.mp4 | 45.57 MB | ||
| 4. Common Error Types Video | |||
| bk3r8llnkrnfm4n4c9p0.mp4 | 76.41 MB | ||
| 5. Formula Auditing- Trace Precedents - Dependents Video | |||
| bk3r9n5nkrnfm4n4c9q0.mp4 | 73.68 MB | ||
| 6. Formula Auditing- Evaluate Formula - Error Checking Video | |||
| bk3raqlnkrnfm4n4c9r0.mp4 | 58.23 MB | ||
| 7. Ctrl Shortcuts Video | |||
| bk3rea1ujavq7bbfl300.mp4 | 172.36 MB | ||
| 8. Function Shortcuts Video | |||
| bk3rgqlnkrnfm4n4ca00.mp4 | 188.81 MB | ||
| 9. Alt Key Tips Video | |||
| bk3rjn9ujavq7bbfl320.mp4 | 65.36 MB | ||
| 3. Conditional - Logical Operators | |||
| 1. Introduction Video | |||
| billfe1ujavq7bbevt10.mp4 | 6.79 MB | ||
| 2. Anatomy of the IF Statement Video | |||
| bif2ugimeheka3369da0.mp4 | 11.17 MB | ||
| 3. Nested IF Statements Video | |||
| bif2ufimeheka3369d9g.mp4 | 12.09 MB | ||
| 4. AND-OR Operators Video | |||
| bif2ucqmeheka3369d7g.mp4 | 20.51 MB | ||
| 5. NOT vs. ---- Video | |||
| bif2u9nf2qij22kssr90.mp4 | 8.43 MB | ||
| 6. Fixing Errors with IFERROR Video | |||
| bif2ueimeheka3369d8g.mp4 | 14.26 MB | ||
| 7. Common IS Statements Video | |||
| bif2uhvf2qij22kssrag.mp4 | 14.95 MB | ||
| 9. HOMEWORK- Logical Operators Video | |||
| bif2ulff2qij22kssrc0.mp4 | 2.62 MB | ||
| 4. Statistical Functions | |||
| 1. Introduction Video | |||
| billfppujavq7bbevt1g.mp4 | 6.42 MB | ||
| 10. PRO TIP- Data Profiling with COUNT - SUMPRODUCT Video | |||
| bpbaqaq894no2mlcndc0.mp4 | 207.23 MB | ||
| 12. HOMEWORK- Statistical Functions Video | |||
| bif2uq2meheka3369dcg.mp4 | 2.72 MB | ||
| 2. Basic Statistical Functions Video | |||
| bif2ukqmeheka3369db0.mp4 | 11.77 MB | ||
| 3. SMALL-LARGE - RANK-PERCENTRANK Video | |||
| bkke5jkun9aqs06nst9g.mp4 | 16.74 MB | ||
| 4. RAND-- - RANDBETWEEN Video | |||
| bif2umnf2qij22kssrd0.mp4 | 5.08 MB | ||
| 5. The SUMPRODUCT Function Video | |||
| bif2um7f2qij22kssrcg.mp4 | 7.64 MB | ||
| 6. SUMPRODUCT Demo Video | |||
| bif322vf2qij22kssrtg.mp4 | 31.94 MB | ||
| 7. COUNTIFS-SUMIFS-AVERAGEIFS Video | |||
| bif2ujvf2qij22kssrbg.mp4 | 9.74 MB | ||
| 8. DEMO- Building a Basic Dashboard Video | |||
| bif2ttameheka3369d40.mp4 | 18.63 MB | ||
| 9. Combining COUNTIF - SUMPRODUCT Video | |||
| bif30a7f2qij22kssrkg.mp4 | 131.56 MB | ||
| 5. Lookup-Reference Functions | |||
| 1. Introduction Video | |||
| billfuhujavq7bbevt20.mp4 | 7.1 MB | ||
| 10. The MATCH Function Video | |||
| bif2vdnf2qij22kssrf0.mp4 | 4.86 MB | ||
| 11. Using INDEX - MATCH Together Video | |||
| bif2vcqmeheka3369dfg.mp4 | 13.13 MB | ||
| 12. Combining MATCH with VLOOKUP Video | |||
| bif2uivf2qij22kssrb0.mp4 | 13.44 MB | ||
| 13. UPDATE- VLOOKUP Correction Video | |||
| bif2vgff2qij22kssrfg.mp4 | 22.35 MB | ||
| 14. SNEAK PEEK- XLOOKUP -Office 365 Only- Video | |||
| bpbar3i894no2mlcnddg.mp4 | 17.69 MB | ||
| 15. DEMO- Building Dashboards with XLOOKUP Video | |||
| bpbarnm4u06v67aaqdm0.mp4 | 397.32 MB | ||
| 16. Selecting List Items with CHOOSE Video | |||
| bpbas8a894no2mlcndf0.mp4 | 146.6 MB | ||
| 17. The OFFSET Function Video | |||
| bif2vgqmeheka3369dg0.mp4 | 3.89 MB | ||
| 18. Combining OFFSET with COUNTA Video | |||
| bif2vhqmeheka3369dgg.mp4 | 10.04 MB | ||
| 19. DEMO- Using OFFSET to Create a Dynamic Scrolling Chart Video | |||
| bif2vkameheka3369dh0.mp4 | 18.74 MB | ||
| 2. Working with Named Arrays Video | |||
| bif2upimeheka3369dc0.mp4 | 7.97 MB | ||
| 21. HOMEWORK- Lookup-Reference Functions Video | |||
| bif2uu2meheka3369de0.mp4 | 3.75 MB | ||
| 3. ROW-ROWS - COLUMN-COLUMNS Video | |||
| bif2uqqmeheka3369dd0.mp4 | 6.33 MB | ||
| 4. VLOOKUP-HLOOKUP Video | |||
| bkken0sun9aqs06nstd0.mp4 | 24.29 MB | ||
| 5. Joining Data with VLOOKUP Video | |||
| blfgcvrje7ib1ccr8ej0.mp4 | 97.06 MB | ||
| 6. Fixing Errors with IFERROR - VLOOKUP Video | |||
| bif2utameheka3369ddg.mp4 | 18.3 MB | ||
| 7. VLOOKUP Reference Array Options Video | |||
| bif2vaameheka3369df0.mp4 | 21.91 MB | ||
| 8. Approximate Match Lookups Video | |||
| bif31v2meheka3369dt0.mp4 | 75.95 MB | ||
| 9. The INDEX Function Video | |||
| bif2vavf2qij22kssreg.mp4 | 3.51 MB | ||
| 6. Text Functions | |||
| 1. Introduction Video | |||
| billg39ujavq7bbevt2g.mp4 | 4.61 MB | ||
| 11. HOMEWORK- Text Functions Video | |||
| bif2u1nf2qij22kssr60.mp4 | 3.87 MB | ||
| 2. UPPER-LOWER-PROPER - TRIM Video | |||
| bif2vsqmeheka3369di0.mp4 | 10.08 MB | ||
| 3. The CONCATENATE Function --- Video | |||
| bif2vlnf2qij22kssrgg.mp4 | 14.18 MB | ||
| 4. LEFT-MID-RIGHT - LEN Video | |||
| bif2vmimeheka3369dhg.mp4 | 10.13 MB | ||
| 5. TEXT-VALUE Video | |||
| bif324qmeheka3369dtg.mp4 | 21.04 MB | ||
| 6. SEARCH-FIND Video | |||
| bif2voff2qij22kssrh0.mp4 | 15.53 MB | ||
| 7. Categorizing Data with IF-ISNUMBER-SEARCH-- Video | |||
| bif2vs7f2qij22kssri0.mp4 | 16.18 MB | ||
| 8. Combining RIGHT- LEN- and SEARCH Video | |||
| bif2vqnf2qij22kssrhg.mp4 | 24.79 MB | ||
| 9. SUBSTITUTE Video | |||
| bif2vv2meheka3369dig.mp4 | 13.65 MB | ||
| 7. Date - Time Functions | |||
| 1. Introduction Video | |||
| billg79ujavq7bbevt30.mp4 | 9.56 MB | ||
| 10. DEMO- Designing a Sample Budget Pacing Tool Video | |||
| bif30eimeheka3369dk0.mp4 | 22.75 MB | ||
| 12. HOMEWORK- Date - Time Functions Video | |||
| bif30hnf2qij22kssrm0.mp4 | 2.19 MB | ||
| 2. DATEVALUE Video | |||
| bif30gqmeheka3369dkg.mp4 | 10.08 MB | ||
| 3. Date Formatting - Fill Series Video | |||
| bif301ameheka3369dj0.mp4 | 6.66 MB | ||
| 4. TODAY---NOW-- Video | |||
| bif301vf2qij22kssrjg.mp4 | 4.55 MB | ||
| 5. YEAR-MONTH-DAY - HOUR-MINUTE-SECOND Video | |||
| bif302vf2qij22kssrk0.mp4 | 6.62 MB | ||
| 6. The EOMONTH Function Video | |||
| bif300nf2qij22kssrig.mp4 | 11.25 MB | ||
| 7. The YEARFRAC Function Video | |||
| bif30b7f2qij22kssrl0.mp4 | 4.81 MB | ||
| 8. WEEKDAY- WORKDAY - NETWORKDAYS Video | |||
| bkkeehapeoo9q93dc3cg.mp4 | 41.5 MB | ||
| 9. The DATEDIF Function Video | |||
| bif30c2meheka3369djg.mp4 | 8.32 MB | ||
| 8. Formula-Based Formatting | |||
| 1. Introduction Video | |||
| billgclnkrnfm4n3n460.mp4 | 8.73 MB | ||
| 2. Creating- Editing - Managing Formula-Based Rules Video | |||
| bif30mameheka3369dlg.mp4 | 9.01 MB | ||
| 3. Highlighting Every Other Row Using the MOD Function Video | |||
| bif30inf2qij22kssrmg.mp4 | 11.37 MB | ||
| 4. Formatting Cells Based on the Value of Another Cell Video | |||
| bif30lff2qij22kssrn0.mp4 | 8.51 MB | ||
| 5. Formatting Cells Using Statistical Functions Video | |||
| bif30kameheka3369dl0.mp4 | 17.68 MB | ||
| 6. Formatting Cells Using Text Functions - Logical operators Video | |||
| bif30nqmeheka3369dm0.mp4 | 14.83 MB | ||
| 8. HOMEWORK- Formula-Based Formatting Video | |||
| bif30onf2qij22kssrng.mp4 | 2.48 MB | ||
| 9. Array Formulas | |||
| 1. Introduction Video | |||
| billgjtnkrnfm4n3n46g.mp4 | 6.94 MB | ||
| 10. Returning the -X- Largest Values in a Range Video | |||
| bif30u7f2qij22kssrog.mp4 | 8.32 MB | ||
| 11. Counting Characters Across Cells Video | |||
| bif30uqmeheka3369do0.mp4 | 4.26 MB | ||
| 12. Creating a -MAX IF- Array Formula Video | |||
| bif310nf2qij22kssrp0.mp4 | 6.8 MB | ||
| 13. -MAX IF- with Multiple Criteria Video | |||
| bif3147f2qij22kssrpg.mp4 | 27.64 MB | ||
| 14. Using the Double Unary Operator ------ Video | |||
| bif3197f2qij22kssrqg.mp4 | 16.54 MB | ||
| 16. HOMEWORK- Array Functions Video | |||
| bif315ff2qij22kssrq0.mp4 | 9.41 MB | ||
| 2. READ ME- Array Formulas are Changing- Text | |||
| READ ME- Array Formulas are Changing-.html | 1.91 KB | ||
| 3. Rules of Array Functions Video | |||
| bif311imeheka3369dog.mp4 | 6.48 MB | ||
| 4. Pros - Cons of Array Functions Video | |||
| bif3162meheka3369dp0.mp4 | 4.14 MB | ||
| 5. Vertical- Horizontal- and 2-Dimensional Array Constants Video | |||
| bif30q2meheka3369dmg.mp4 | 11.27 MB | ||
| 6. Using Array Constants in Formulas Video | |||
| bif30r2meheka3369dn0.mp4 | 6.37 MB | ||
| 7. Named Array Constants Video | |||
| bif30s2meheka3369dng.mp4 | 8.63 MB | ||
| 8. The Transpose Function Video | |||
| bif30fnf2qij22kssrlg.mp4 | 9.73 MB | ||
| 9. Linking Data Between Sheets- Array vs. Non-Array Comparison Video | |||
| bif30t7f2qij22kssro0.mp4 | 6.99 MB | ||
| Microsoft Excel- Pivot Tables - Pivot Charts | |||
| 0. Orientation - Benchmark Assessment | |||
| 1. Welcome to the Course- Text | |||
| Welcome to the Course-.html | 2.96 KB | ||
| 1. Course Intro | |||
| 1. Course Structure - Outline Video | |||
| bjcsdmtnkrnfm4n40n0g.mp4 | 32.6 MB | ||
| 2.DOWNLOAD%3a Course Resources | |||
| 2016_Movies-1554821519587.xlsx | 9.83 KB | ||
| Excel_PivotTables__PivotCharts-1560951714742.pdf | 4.87 MB | ||
| IMDbMovieDatabase-1554821516150.xlsx | 459.61 KB | ||
| 3. Getting to Know the IMDb Movie Database Video | |||
| bih308imeheka336a8s0.mp4 | 15.46 MB | ||
| 4. Setting Expectations Video | |||
| bih30aqmeheka336a8sg.mp4 | 4.26 MB | ||
| 2. PivotTable 101 | |||
| 1. Why PivotTables- Video | |||
| bih31bff2qij22ksto1g.mp4 | 15.09 MB | ||
| 11. Removing - Reviving Data from Cache Video | |||
| bilm9rdnkrnfm4n3n4i0.mp4 | 112.97 MB | ||
| 12. How PivotTables ACTUALLY Work Video | |||
| bih31g7f2qij22ksto40.mp4 | 14.87 MB | ||
| 14. HOMEWORK- PivotTable 101 Text | |||
| HOMEWORK- PivotTable 101.html | 3.55 KB | ||
| 2. Structuring Your Source Data Video | |||
| bih31bnf2qij22ksto20.mp4 | 8.27 MB | ||
| 3. Inserting Your First PivotTable Video | |||
| bih31bqmeheka336a8tg.mp4 | 20.23 MB | ||
| 4. IMPORTANT- Add to Data Model Text | |||
| IMPORTANT- Add to Data Model.html | 1.22 KB | ||
| 5. Navigating the Field List Video | |||
| bih31cimeheka336a8u0.mp4 | 29.71 MB | ||
| 6. KNOWLEDGE CHECK- Manipulating PivotTable Views Text | |||
| KNOWLEDGE CHECK- Manipulating PivotTable Views.html | 1.83 KB | ||
| 7. PivotTable Options- -Analyze- - -Design- Video | |||
| bih31cvf2qij22ksto2g.mp4 | 6.49 MB | ||
| 8. Selecting- Clearing- Moving - Copying Pivots Video | |||
| bih31dameheka336a8ug.mp4 | 20.6 MB | ||
| 9. Refreshing - Updating Pivots Video | |||
| bih31eff2qij22ksto30.mp4 | 55.36 MB | ||
| 3. PivotTable Formatting | |||
| 1. Number Formatting Video | |||
| bih33eimeheka336a8vg.mp4 | 8.96 MB | ||
| 10. HOMEWORK- PivotTable Formatting Text | |||
| HOMEWORK- PivotTable Formatting.html | 3.01 KB | ||
| 2. PRO TIP- Automatically Formatting Empty Cells Video | |||
| bih33eqmeheka336a900.mp4 | 8.73 MB | ||
| 3. Table Layouts - Styles Video | |||
| bih33fvf2qij22ksto50.mp4 | 23.83 MB | ||
| 4. PRO TIP- Using Tabular Tables to Create New Source Data Video | |||
| bih33gff2qij22ksto5g.mp4 | 11.8 MB | ||
| 5. Customizing Headers - Labels Video | |||
| bih33gameheka336a90g.mp4 | 4.84 MB | ||
| 6. Conditional Formatting Video | |||
| bih33i2meheka336a910.mp4 | 34.83 MB | ||
| 7. PRO TIP- Data Bars with Invisible Text Video | |||
| bih33iimeheka336a91g.mp4 | 10.74 MB | ||
| 8. Advanced Conditional Formatting Video | |||
| bilmaplnkrnfm4n3n4jg.mp4 | 79.42 MB | ||
| 4. Sorting- Filtering - Grouping | |||
| 1. Sorting Options Video | |||
| bih34t7f2qij22ksto60.mp4 | 23.24 MB | ||
| 10. Breaking Out Report Filter Pages Video | |||
| bih3527f2qij22ksto8g.mp4 | 17.73 MB | ||
| 12. HOMEWORK- Sorting- Filtering - Grouping Text | |||
| HOMEWORK- Sorting- Filtering - Grouping.html | 2.78 KB | ||
| 2. PRO TIP- Incorrect Alphabetical Sorting Video | |||
| bih34tvf2qij22ksto6g.mp4 | 11.57 MB | ||
| 3. Label Filters - Manual Selections Video | |||
| bih34uff2qij22ksto70.mp4 | 42.55 MB | ||
| 4. PRO TIP- Label Filters with Wildcards Video | |||
| bih34uqmeheka336a92g.mp4 | 23.68 MB | ||
| 5. Value Filters Video | |||
| bih34vameheka336a930.mp4 | 14.2 MB | ||
| 6. PRO TIP- Enabling Multiple Filters Video | |||
| bih34vvf2qij22ksto7g.mp4 | 14.77 MB | ||
| 7. Grouping Data Video | |||
| bih350ff2qij22ksto80.mp4 | 16.73 MB | ||
| 8. PRO TIP- Automatic Date Grouping Video | |||
| bih350qmeheka336a93g.mp4 | 20.13 MB | ||
| 9. Using Slicers - Timelines to Filter Data Video | |||
| bih351ameheka336a940.mp4 | 19.07 MB | ||
| 5. Calculated Values- Fields - Items | |||
| 1. -Summarize Values By- Options Video | |||
| bih36l2meheka336a960.mp4 | 17.58 MB | ||
| 10. KNOWLEDGE CHECK- Show Values As Text | |||
| KNOWLEDGE CHECK- Show Values As.html | 1.07 KB | ||
| 11. Inserting Calculated Fields Video | |||
| bih36qvf2qij22kstobg.mp4 | 30.78 MB | ||
| 12. Calculations in Pivots vs. Raw Data Video | |||
| bih36rff2qij22kstoc0.mp4 | 19.68 MB | ||
| 13. PRO TIP- Calculating Using Counts -Part 1- Video | |||
| bih36rqmeheka336a990.mp4 | 33.9 MB | ||
| 14. PRO TIP- Calculating Using Counts -Part 2- Video | |||
| bih36sameheka336a99g.mp4 | 19.85 MB | ||
| 15. Inserting a Calculated Item -use with caution-- Video | |||
| bih36snf2qij22kstocg.mp4 | 22.38 MB | ||
| 16. The Solve Order - List Formulas Tools Video | |||
| bih36t2meheka336a9a0.mp4 | 19.58 MB | ||
| 18. HOMEWORK- Calculated Values- Fields - Items Text | |||
| HOMEWORK- Calculated Values- Fields - Items.html | 3.75 KB | ||
| 2. PRO TIP- Avoiding the -Count Of- Trap Video | |||
| bih36m7f2qij22kstoa0.mp4 | 18.05 MB | ||
| 3. -Show Values As- Calculations Video | |||
| bih36mimeheka336a96g.mp4 | 12.92 MB | ||
| 4. Show Values As- % of Column-Row Video | |||
| bih36mqmeheka336a970.mp4 | 17.13 MB | ||
| 5. Show Values As- % of Parent Video | |||
| bih36nameheka336a97g.mp4 | 12.19 MB | ||
| 6. Show Values As- Difference From Video | |||
| bih36oqmeheka336a980.mp4 | 19.5 MB | ||
| 7. Show Values As- Running Total Video | |||
| bih36p7f2qij22kstoag.mp4 | 11.46 MB | ||
| 8. Show Values As- Rank Video | |||
| bih36pnf2qij22kstob0.mp4 | 10.98 MB | ||
| 9. Show Values As- Index Video | |||
| bih36q2meheka336a98g.mp4 | 40.85 MB | ||
| 6. Pivot Charts | |||
| 1. Intro to PivotCharts Video | |||
| bih3atimeheka336a9c0.mp4 | 8.83 MB | ||
| 10. Applying Slicers - Timelines to Multiple Charts Video | |||
| bih3b37f2qij22kstoh0.mp4 | 19.37 MB | ||
| 11. Building a Dynamic Dashboard Video | |||
| bih3b3vf2qij22kstohg.mp4 | 50.59 MB | ||
| 13. HOMEWORK- Pivot Charts Text | |||
| HOMEWORK- Pivot Charts.html | 3.62 KB | ||
| 2. Pivot Chart Demo- Column Chart Video | |||
| bih3av2meheka336a9cg.mp4 | 15.1 MB | ||
| 3. Pivot Chart Demo- Pie - Donut Charts Video | |||
| bih3avqmeheka336a9d0.mp4 | 21.25 MB | ||
| 4. Pivot Chart Demo- Clustered Bar Chart Video | |||
| bih3b0ff2qij22kstof0.mp4 | 13.47 MB | ||
| 5. PRO TIP- Prevent Charts from Resizing with Cells Video | |||
| bih3b0nf2qij22kstofg.mp4 | 17.06 MB | ||
| 6. Changing Chart Types on the Fly Video | |||
| bih3b17f2qij22kstog0.mp4 | 11.79 MB | ||
| 7. Pivot Chart Demo- Stacked Area Chart Video | |||
| bih3b1nf2qij22kstogg.mp4 | 24.43 MB | ||
| 8. Pivot Chart Layouts - Styles Video | |||
| bih3b22meheka336a9dg.mp4 | 14.55 MB | ||
| 9. Moving Pivot Charts to New Sheets Video | |||
| bih3b2ameheka336a9e0.mp4 | 8.02 MB | ||
| 7. PivotTable Case Studies | |||
| 1. Setting Expectations Video | |||
| bih3cr2meheka336a9eg.mp4 | 6.97 MB | ||
| 10. HOMEWORK- Stock Market Data Text | |||
| HOMEWORK- Stock Market Data.html | 1.88 KB | ||
| 11. Baseball Team Stats Video | |||
| bih3d07f2qij22kstojg.mp4 | 62.56 MB | ||
| 12. HOMEWORK- Baseball Team Stats Text | |||
| HOMEWORK- Baseball Team Stats.html | 3.08 KB | ||
| 13. San Diego Burrito Ratings Video | |||
| bih3d0qmeheka336a9g0.mp4 | 86.39 MB | ||
| 14. HOMEWORK- San Diego Burrito Ratings Text | |||
| HOMEWORK- San Diego Burrito Ratings.html | 2.83 KB | ||
| 15. Daily Weather Conditions Video | |||
| bih3d27f2qij22kstok0.mp4 | 58.98 MB | ||
| 16. HOMEWORK- Daily Weather Conditions Text | |||
| HOMEWORK- Daily Weather Conditions.html | 2.37 KB | ||
| 17. Spartan Race Facebook Posts Video | |||
| bih3d2qmeheka336a9gg.mp4 | 72.29 MB | ||
| 18. HOMEWORK- Spartan Race Facebook Posts Text | |||
| HOMEWORK- Spartan Race Facebook Posts.html | 2.35 KB | ||
| 19. Apple App Data Video | |||
| bilmh3lnkrnfm4n3n4q0.mp4 | 87.91 MB | ||
| 20. HOMEWORK- Apple App Data Text | |||
| HOMEWORK- Apple App Data.html | 4.17 KB | ||
| 21. Wine Tasting Scores Video | |||
| bilmhc1ujavq7bbevtj0.mp4 | 86.18 MB | ||
| 22. HOMEWORK- Wine Tasting Scores Text | |||
| HOMEWORK- Wine Tasting Scores.html | 3.55 KB | ||
| 3. U.S. Voters -2012- Video | |||
| bih3cs2meheka336a9f0.mp4 | 50.87 MB | ||
| 4. HOMEWORK- U.S. Voters -2012- Text | |||
| HOMEWORK- U.S. Voters -2012-.html | 2.78 KB | ||
| 5. San Francisco Salaries Video | |||
| bih3ct2meheka336a9fg.mp4 | 69.44 MB | ||
| 6. HOMEWORK- San Francisco Salaries Text | |||
| HOMEWORK- San Francisco Salaries.html | 2.24 KB | ||
| 7. Shark Attack Records Video | |||
| bih3ctvf2qij22kstoig.mp4 | 43.48 MB | ||
| 8. HOMEWORK- Shark Attack Records Text | |||
| HOMEWORK- Shark Attack Records.html | 3.08 KB | ||
| 9. Stock Market Data Video | |||
| bih3cvff2qij22kstoj0.mp4 | 70.97 MB | ||
| 9. Final Assessment - Next Steps | |||
| 2. Share the love- Text | |||
| Share the love-.html | 152 B | ||
| 3. Next Steps Text | |||
| Next Steps.html | 4.42 KB | ||
| Microsoft Excel- Power Query- Power Pivot - DAX | |||
| 0. Orientation - Benchmark Assessment | |||
| 1. Welcome to the Course- Text | |||
| Welcome to the Course-.html | 3.02 KB | ||
| 1. Course Intro | |||
| 1. Course Structure - Outline Video | |||
| bjcse39ujavq7bbf9gmg.mp4 | 17.67 MB | ||
| 2. IMPORTANT- Versions - Compatibility Video | |||
| bihm9snf2qij22ksu0b0.mp4 | 15.93 MB | ||
| 3. Introducing the Course Project Video | |||
| bihm9tqmeheka336agb0.mp4 | 4.52 MB | ||
| 4.DOWNLOAD%3a Course Resources | |||
| FoodMartCSVFiles-1554821743351.zip | 2.1 MB | ||
| FoodMartDataModelCOMPLETE-1554821750569.xlsx | 4.27 MB | ||
| PowerQuery_PowerPivot__DAX-1560900590898.pdf | 7.02 MB | ||
| 5. Setting Expectations Video | |||
| bihm9sqmeheka336aga0.mp4 | 6.64 MB | ||
| 2. Intro to -Power Excel- | |||
| 1. The -Power Excel- Workflow Video | |||
| bihmd27f2qij22ksu0f0.mp4 | 12.52 MB | ||
| 2. -The Best Thing to Happen to Excel in 20 Years- Video | |||
| bihmd1vf2qij22ksu0eg.mp4 | 34.54 MB | ||
| 3. When to use Power Query - Power Pivot Video | |||
| bihmd2imeheka336agd0.mp4 | 2.44 MB | ||
| 5. HOMEWORK- Intro to -Power Excel- Text | |||
| HOMEWORK- Intro to -Power Excel-.html | 770 B | ||
| 3. Power Query | |||
| 1. Introduction Video | |||
| bihmdfqmeheka336agfg.mp4 | 3.72 MB | ||
| 10. PRO TIP- Creating a Rolling Calendar Video | |||
| bihmdivf2qij22ksu0ig.mp4 | 17.43 MB | ||
| 11. Adding Index - Conditional Columns Video | |||
| biqi11tnkrnfm4n3pk0g.mp4 | 69.92 MB | ||
| 12. Grouping - Aggregating Data Video | |||
| bihmdf7f2qij22ksu0gg.mp4 | 26.35 MB | ||
| 13. Pivoting - Unpivoting Video | |||
| bihmdi7f2qij22ksu0i0.mp4 | 29.87 MB | ||
| 14. Modifying Workbook Queries Video | |||
| bihmdh2meheka336aggg.mp4 | 16.16 MB | ||
| 15. Merging Queries Video | |||
| bihmdgqmeheka336agg0.mp4 | 30.11 MB | ||
| 16. Appending Queries Video | |||
| bihmdbimeheka336agdg.mp4 | 21.88 MB | ||
| 17. Connecting to a Folder of Files Video | |||
| bihmde2meheka336agf0.mp4 | 36.79 MB | ||
| 18. Power Query Best Practices Video | |||
| bihmdcff2qij22ksu0fg.mp4 | 9.43 MB | ||
| 2. Meet Power Query -aka -Get - Transform-- Video | |||
| bihmdgff2qij22ksu0hg.mp4 | 8.97 MB | ||
| 20. HOMEWORK- Power Query Text | |||
| HOMEWORK- Power Query.html | 4.86 KB | ||
| 3. The Query Editor Video | |||
| bihmdjvf2qij22ksu0j0.mp4 | 11.94 MB | ||
| 4. Data Loading Options Video | |||
| bihmdcimeheka336ageg.mp4 | 5.06 MB | ||
| 5. IMPORTANT- Updating Locale Settings Text | |||
| IMPORTANT- Updating Locale Settings.html | 2.63 KB | ||
| 6. Basic Table Transformations Video | |||
| bmrhfka9c233ls0jbsm0.mp4 | 94.82 MB | ||
| 7. Text-Specific Tools Video | |||
| binnpflnkrnfm4n3o690.mp4 | 128.43 MB | ||
| 8. Number-Specific Tools Video | |||
| bihmdhimeheka336agh0.mp4 | 32.46 MB | ||
| 9. Date-Specific Tools Video | |||
| binnrmhujavq7bbf10mg.mp4 | 87.2 MB | ||
| 4. Data Modeling 101 | |||
| 1. Introduction Video | |||
| bihme1ameheka336aglg.mp4 | 3.95 MB | ||
| 10. Relationship Cardinality Video | |||
| bihmduqmeheka336agj0.mp4 | 19.1 MB | ||
| 11. Connecting Multiple Data Tables Video | |||
| bihme2imeheka336agmg.mp4 | 20.6 MB | ||
| 12. Filter Direction Video | |||
| bihme0ameheka336agk0.mp4 | 17.31 MB | ||
| 13. Hiding Fields from Client Tools Video | |||
| bihme0qmeheka336agkg.mp4 | 15.9 MB | ||
| 14. Defining Hierarchies Video | |||
| bihme12meheka336agl0.mp4 | 12.36 MB | ||
| 15. Data Model Best Practices Video | |||
| bihmduameheka336agig.mp4 | 5.01 MB | ||
| 17. HOMEWORK- Data Modeling 101 Text | |||
| HOMEWORK- Data Modeling 101.html | 3.38 KB | ||
| 2. Meet Excel-s -Data Model- Video | |||
| bihme1imeheka336agm0.mp4 | 14.59 MB | ||
| 3. Data vs. Diagram View Video | |||
| bihmdvvf2qij22ksu0jg.mp4 | 10.58 MB | ||
| 4. Database Normalization Video | |||
| bihme32meheka336agn0.mp4 | 15.18 MB | ||
| 5. Data Tables vs. Lookup Tables Video | |||
| bihme07f2qij22ksu0k0.mp4 | 20.11 MB | ||
| 6. Relationships vs. Merged Tables Video | |||
| bihme3nf2qij22ksu0l0.mp4 | 7.81 MB | ||
| 7. Creating Table Relationships Video | |||
| bihmdvameheka336agjg.mp4 | 24.09 MB | ||
| 8. Modifying Table Relationships Video | |||
| bihme27f2qij22ksu0kg.mp4 | 9.15 MB | ||
| 9. Active vs. Inactive Relationships Video | |||
| bihmdu2meheka336agi0.mp4 | 13.57 MB | ||
| 5. Power Pivot - DAX 101 | |||
| 1. Introduction Video | |||
| bihme8nf2qij22ksu0og.mp4 | 4.48 MB | ||
| 10. Understanding Filter Context Video | |||
| bihme7vf2qij22ksu0ng.mp4 | 32.53 MB | ||
| 11. Step-by-Step Measure Calculation Video | |||
| bihmea2meheka336agpg.mp4 | 44.53 MB | ||
| 12. RECAP- Calculated Columns vs. Measures Video | |||
| bihme6ff2qij22ksu0mg.mp4 | 7.72 MB | ||
| 13. Power Pivot Best Practices Video | |||
| bihme5nf2qij22ksu0m0.mp4 | 6.05 MB | ||
| 15. HOMEWORK- Power Pivot - DAX 101 Text | |||
| HOMEWORK- Power Pivot - DAX 101.html | 4.37 KB | ||
| 2. Creating a -Power- PivotTable Video | |||
| bihme9ameheka336agp0.mp4 | 17.8 MB | ||
| 3. Power Pivots vs. -Normal- Pivots Video | |||
| bihme6qmeheka336ago0.mp4 | 9.75 MB | ||
| 4. Intro to Data Analysis Expressions -DAX- Video | |||
| bihme6nf2qij22ksu0n0.mp4 | 4.21 MB | ||
| 5. Calculated Columns Video | |||
| bihme62meheka336agng.mp4 | 44.85 MB | ||
| 6. Intro to DAX Measures Video | |||
| bihme8vf2qij22ksu0p0.mp4 | 7.63 MB | ||
| 7. Creating Implicit Measures Video | |||
| bihme8ff2qij22ksu0o0.mp4 | 6.72 MB | ||
| 8. Creating Explicit Measured -AutoSum- Video | |||
| bihme5ff2qij22ksu0lg.mp4 | 24.38 MB | ||
| 9. Creating Explicit Measures -Power Pivot- Video | |||
| bihme7ameheka336agog.mp4 | 26.37 MB | ||
| 6. Common DAX Functions | |||
| 1. Introduction Video | |||
| bihmel7f2qij22ksu0sg.mp4 | 3.66 MB | ||
| 10. HOMEWORK- Logical - Text Functions Text | |||
| HOMEWORK- Logical - Text Functions.html | 3.68 KB | ||
| 11. The CALCULATE Function Video | |||
| bihmegvf2qij22ksu0qg.mp4 | 52.01 MB | ||
| 12. Adding Filter Context with Filter -Part 1- Video | |||
| bihmejameheka336agqg.mp4 | 33.93 MB | ||
| 13. Adding Filter Context with Filter -Part 2- Video | |||
| bihmekvf2qij22ksu0s0.mp4 | 55.11 MB | ||
| 14. Removing Filter Context with ALL Video | |||
| bihmefnf2qij22ksu0pg.mp4 | 36.86 MB | ||
| 15. HOMEWORK- CALCULATE- FILTER - ALL Text | |||
| HOMEWORK- CALCULATE- FILTER - ALL.html | 4.15 KB | ||
| 16. Joining Data with RELATED Video | |||
| bihmf9qmeheka336agt0.mp4 | 13.08 MB | ||
| 17. Iterator --X-- Functions- SUMX Video | |||
| bihmen2meheka336agr0.mp4 | 60.18 MB | ||
| 18. Iterator --X-- Functions- RANKX Video | |||
| bihmf9ff2qij22ksu0v0.mp4 | 45.21 MB | ||
| 19. HOMEWORK- Iterator Functions Text | |||
| HOMEWORK- Iterator Functions.html | 2.76 KB | ||
| 2. DAX Formula Syntax - Operators Video | |||
| bihmfcqmeheka336agug.mp4 | 13.37 MB | ||
| 20. Basic Date - Time Functions Video | |||
| bihmeivf2qij22ksu0rg.mp4 | 24.26 MB | ||
| 21. Time Intelligence Formulas Video | |||
| bihmfeqmeheka336agvg.mp4 | 89.27 MB | ||
| 22. HOMEWORK- Time Intelligence Text | |||
| HOMEWORK- Time Intelligence.html | 3.32 KB | ||
| 23. Speed - Performance Considerations Video | |||
| bihmfaimeheka336agtg.mp4 | 10.49 MB | ||
| 24. DAX Best Practices Video | |||
| bihmefvf2qij22ksu0q0.mp4 | 6.46 MB | ||
| 3. Common DAX Function Categories Video | |||
| bihmehff2qij22ksu0r0.mp4 | 12.59 MB | ||
| 4. Basic Math - Stats Functions Video | |||
| bihmf7qmeheka336agsg.mp4 | 55.85 MB | ||
| 5. COUNT- COUNTA- DISTINCTCOUNT - COUNTROWS Video | |||
| bihmei2meheka336agq0.mp4 | 55.61 MB | ||
| 6. HOMEWORK- Math - Stats Functions Text | |||
| HOMEWORK- Math - Stats Functions.html | 3.86 KB | ||
| 7. Logical Functions -IF-AND-OR- Video | |||
| bihmf77f2qij22ksu0u0.mp4 | 79.24 MB | ||
| 8. SWITCH - SWITCH-TRUE- Video | |||
| bihmfcimeheka336agu0.mp4 | 40.89 MB | ||
| 9. Text Functions Video | |||
| bihmfe2meheka336agv0.mp4 | 49.54 MB | ||
| 7. Wrapping Up | |||
| 1. Introduction Video | |||
| bihmeoqmeheka336agrg.mp4 | 7.47 MB | ||
| 2. Data Visualization Options Video | |||
| bihmeoff2qij22ksu0t0.mp4 | 14.14 MB | ||
| 3. Sneak Peek- Power BI Video | |||
| bihmepff2qij22ksu0tg.mp4 | 18.96 MB | ||
| 9. Final Assessment - Next Steps | |||
| 2. Share the love- Text | |||
| Share the love-.html | 152 B | ||
| 3. Next Steps Text | |||
| Next Steps.html | 4.57 KB | ||
| Microsoft Excel- VBA - Macros | |||
| 0. Orientation - Benchmark Assessment | |||
| 1. Welcome to the Course- Text | |||
| Welcome to the Course-.html | 2.98 KB | ||
| 1. Course Intro | |||
| 1. Course Structure - Content Video | |||
| biuueupujavq7bbf42n0.mp4 | 43.11 MB | ||
| 2. Important Compatibility - Setup Information Video | |||
| biuuf1hujavq7bbf42o0.mp4 | 36.56 MB | ||
| 3. Getting to Know the Project Files Video | |||
| biuuf2tnkrnfm4n3r9og.mp4 | 19.19 MB | ||
| 4.DOWNLOAD%3a Course Resources | |||
| ALL_VBA_Section_Milestone_Files_In_One_Place-191116-215942.zip | 3.44 MB | ||
| Excel_VBA_Course_Slides-1557416329478.pdf | 2 MB | ||
| IconSets-1557416339603 (1).xlsx | 838.61 KB | ||
| VBA_Project_Guide-1557416345292.pdf | 184.49 KB | ||
| 5. Setting Expectations Video | |||
| biuuf4tnkrnfm4n3r9p0.mp4 | 23.66 MB | ||
| 10. Looping in VBA -Controlling the Flow of Code- | |||
| 1. Overview- Looping in VBA Video | |||
| biuuu7dnkrnfm4n3ram0.mp4 | 32.75 MB | ||
| 10. Activity- Document all Comments in Workbook in a Sheet Text | |||
| Activity- Document all Comments in Workbook in a Sheet.html | 1.23 KB | ||
| 11. Project- Document all Comments in Workbook in a Sheet Video | |||
| biuuu3hujavq7bbf437g.mp4 | 101.46 MB | ||
| 12. Key Takeaways- Looping in VBA Video | |||
| biuuu55nkrnfm4n3ralg.mp4 | 16.64 MB | ||
| 2. For Next Counter Loops Video | |||
| biuuu9pujavq7bbf4390.mp4 | 34.58 MB | ||
| 3. For Next Nested Loop Video | |||
| biuuug5nkrnfm4n3rang.mp4 | 108.19 MB | ||
| 4. For Next Reverse Loop -Delete Filtered-Hidden Rows- Video | |||
| biuuum9ujavq7bbf439g.mp4 | 89.2 MB | ||
| 5. Do Until - Do While Loop Video | |||
| biuuuptnkrnfm4n3rao0.mp4 | 38.73 MB | ||
| 6. Practical Example of Do Loop -with Inputbox- Video | |||
| biuuur5nkrnfm4n3raog.mp4 | 15.76 MB | ||
| 7. Find Method for Quicker Lookup Results Video | |||
| biuuuv5nkrnfm4n3rap0.mp4 | 54.55 MB | ||
| 8. Find Method with Do Loop - Multiple Matches Video | |||
| biuuv1lnkrnfm4n3rapg.mp4 | 41.85 MB | ||
| 9. Add a Timer to Test - Speech to Inform Video | |||
| biuuv3pujavq7bbf43bg.mp4 | 30.8 MB | ||
| 11. Working with Arrays | |||
| 1. Overview- Working with Arrays in VBA Video | |||
| biuuvstnkrnfm4n3raq0.mp4 | 19.34 MB | ||
| 2. One Dimensional Arrays Video | |||
| biuv00dnkrnfm4n3raqg.mp4 | 61.67 MB | ||
| 3. Dynamic Arrays Video | |||
| biuv02dnkrnfm4n3rar0.mp4 | 31.99 MB | ||
| 4. Preserving Dynamic Arrays Video | |||
| biuv045nkrnfm4n3rarg.mp4 | 27.31 MB | ||
| 5. Two Dimensional Arrays Video | |||
| biuv061ujavq7bbf43c0.mp4 | 30.62 MB | ||
| 6. Variant Arrays- Quick Method to Write to Cells Video | |||
| biuv089ujavq7bbf43cg.mp4 | 38.27 MB | ||
| 7. Activity- Create a New Worksheet per Company with Specific Information Text | |||
| Activity- Create a New Worksheet per Company with Specific Information.html | 1010 B | ||
| 8. Project- Create a New Worksheet per Company with Specific Information Video | |||
| biuv0d9ujavq7bbf43d0.mp4 | 80.11 MB | ||
| 9. Key Takeaways- Arrays Text | |||
| Key Takeaways- Arrays.html | 607 B | ||
| 12. Working with Files- Folders - Text Files | |||
| 1. Overview- Working with Folders - Files Video | |||
| biuv0i9ujavq7bbf43eg.mp4 | 31.01 MB | ||
| 2. DIR Function- Check if Files or Folders Exist Video | |||
| biuv0l9ujavq7bbf43f0.mp4 | 30.46 MB | ||
| 3. GetOpenFileName Method- User Selects a File Video | |||
| biuv0o9ujavq7bbf43g0.mp4 | 48.29 MB | ||
| 4. FileDialog Property- Loop Inside a Folder Video | |||
| biuv0stnkrnfm4n3ras0.mp4 | 73.15 MB | ||
| 5. Create CSV File from Data in Excel Video | |||
| biuv0vdnkrnfm4n3rasg.mp4 | 42.74 MB | ||
| 6. Printing - Writing to Text Files for More Control Video | |||
| biuv10lnkrnfm4n3rat0.mp4 | 17.6 MB | ||
| 7. Activity- Export Data to Text file Text | |||
| Activity- Export Data to Text file.html | 863 B | ||
| 8. Project- Export Data to Text file Video | |||
| biuv185nkrnfm4n3ratg.mp4 | 141.45 MB | ||
| 9. Key Takeaways- Files - Folders Text | |||
| Key Takeaways- Files - Folders.html | 596 B | ||
| 13. Excel Tables- Formulas - Pivot Tables | |||
| 1. Overview- -Pivot- Tables - Formulas Video | |||
| biuv1g1ujavq7bbf43gg.mp4 | 30.23 MB | ||
| 2. Using Excel Formulas in VBA Video | |||
| biuv1klnkrnfm4n3raug.mp4 | 74.3 MB | ||
| 3. Excel Tables- Use the Right Syntax Video | |||
| biuv1s5nkrnfm4n3ravg.mp4 | 139.79 MB | ||
| 4. Pivot Tables - VBA- What you Need to Know Video | |||
| biuv24tnkrnfm4n3rb00.mp4 | 160.22 MB | ||
| 5. Activity- Update Existing Formulas with VBA by Adding IFERROR Text | |||
| Activity- Update Existing Formulas with VBA by Adding IFERROR.html | 984 B | ||
| 6. Project- Update Existing Formulas with VBA by Adding IFERROR Video | |||
| biuv1dtnkrnfm4n3rau0.mp4 | 65.79 MB | ||
| 7. Key Takeaways- -Pivot- Tables - Formulas Text | |||
| Key Takeaways- -Pivot- Tables - Formulas.html | 594 B | ||
| 14. Main Project -2- Sales Regional Reporting Tool | |||
| 1. What You-ll Learn in this Project Video | |||
| biuv2a1ujavq7bbf43ig.mp4 | 24.13 MB | ||
| 10. Key Takeaways- VBA-based Excel Tools Video | |||
| biuv3n5nkrnfm4n3rb20.mp4 | 26.49 MB | ||
| 11. Second Milestone Completed- Text | |||
| Second Milestone Completed-.html | 360 B | ||
| 2. Project Overview- Regional Sales Reporting Tool Video | |||
| biuv2e9ujavq7bbf43j0.mp4 | 65.74 MB | ||
| 3. Importing Data from Multiple Files using MultiSelect Video | |||
| biuv2l9ujavq7bbf43jg.mp4 | 110.48 MB | ||
| 4. Setting up a Template as the Basis for Different Reports Video | |||
| biuv319ujavq7bbf43l0.mp4 | 216.33 MB | ||
| 5. Exporting Reports as Excel files Video | |||
| biuv369ujavq7bbf43m0.mp4 | 87.77 MB | ||
| 6. Fine-tuning Report Export Procedure Video | |||
| biuv39pujavq7bbf43mg.mp4 | 49.81 MB | ||
| 7. Setting up Automatic Export of Text File Video | |||
| biuv3dhujavq7bbf43ng.mp4 | 62.53 MB | ||
| 8. Track the List of Tasks Completed with VBA Video | |||
| biuv3hhujavq7bbf43o0.mp4 | 69.66 MB | ||
| 9. Final Touches - Creating Interface to Hide Specific Tabs with a Password Video | |||
| biuv3l9ujavq7bbf43og.mp4 | 54.72 MB | ||
| 15. Interacting with Other Applications -Word- PowerPoint etc.- | |||
| 1. Overview- Interacting with Other Applications Video | |||
| biuv3rpujavq7bbf43pg.mp4 | 29.48 MB | ||
| 2. PDF- Save Specific Sheets as a PDF File Video | |||
| biuv3vlnkrnfm4n3rb2g.mp4 | 61.85 MB | ||
| 3. Email- Automatically Create Personalized Emails with Attachments Video | |||
| biuv42dnkrnfm4n3rb3g.mp4 | 41.23 MB | ||
| 4. Microsoft Word- Create Personalized Letters in Word from Excel Video | |||
| biuv46dnkrnfm4n3rb4g.mp4 | 70.24 MB | ||
| 5. Microsoft PowerPoint- Export Excel Sheets to PowerPoint Presentation Video | |||
| biuv4cdnkrnfm4n3rb5g.mp4 | 103.44 MB | ||
| 6. Key Takeaways- Working with Other Applications Text | |||
| Key Takeaways- Working with Other Applications.html | 594 B | ||
| 16. Workbook and Worksheet Events | |||
| 1. Overview- Event Procedures Video | |||
| biuv4jpujavq7bbf43r0.mp4 | 23.43 MB | ||
| 2. Workbook Events- Toggle Full Screen -Activate- Deactivate- Open- Close- Video | |||
| biuv4opujavq7bbf43s0.mp4 | 89.28 MB | ||
| 3. Worksheet Selection Change- Dynamic Font Color of Selected Range Video | |||
| biuv4q1ujavq7bbf43sg.mp4 | 21.34 MB | ||
| 4. Refresh PivotTables Automatically - Concept of Range Intersection Video | |||
| biuv4vhujavq7bbf43t0.mp4 | 84.05 MB | ||
| 5. Resetting a Dependent Drop-down when the first Drop-down is Changed Video | |||
| biuv52dnkrnfm4n3rb6g.mp4 | 43.68 MB | ||
| 6. Activity- Link Page Header to Cell Value -BeforePrint Event- Text | |||
| Activity- Link Page Header to Cell Value -BeforePrint Event-.html | 897 B | ||
| 7. Project- Link Page Header to Cell Value -BeforePrint Event- Video | |||
| biuv571ujavq7bbf43ug.mp4 | 78.84 MB | ||
| 8. Key Takeaways- Workbook - Worksheet Events Video | |||
| biuv589ujavq7bbf43v0.mp4 | 17.95 MB | ||
| 17. Working with Userforms - ActiveX Controls | |||
| 1. Overview- UserForms - ActiveX Controls Video | |||
| biuv5e5nkrnfm4n3rb70.mp4 | 19 MB | ||
| 10. BONUS- ListBox to Print Multiple Pages at Once Video | |||
| bn8bd4a9c233ls0jkbvg.mp4 | 50.94 MB | ||
| 11. UserForm Checklist - Course Map Status Text | |||
| UserForm Checklist - Course Map Status.html | 848 B | ||
| 2. ActiveX Controls- What you Need to Know Video | |||
| biuv5g1ujavq7bbf4400.mp4 | 27.78 MB | ||
| 3. ActiveX Check Box to Fix Scroll Area - Toggle Screen Settings Video | |||
| biuv5ipujavq7bbf440g.mp4 | 42.98 MB | ||
| 4. ActiveX to Show and Hide Help Video | |||
| biuv5l1ujavq7bbf4410.mp4 | 37.57 MB | ||
| 5. ActiveX Combo Box for Easy Sheet Navigation Video | |||
| biuv5ohujavq7bbf4420.mp4 | 56.38 MB | ||
| 6. ActiveX to Show or Hide Other ActiveX controls Video | |||
| biuv5shujavq7bbf442g.mp4 | 71.49 MB | ||
| 7. UserForm Basics- What You Need to Get Started Video | |||
| biuv63dnkrnfm4n3rb7g.mp4 | 112.89 MB | ||
| 8. UserForm for Data Entry -Input - Check Boxes- Video | |||
| biuv685nkrnfm4n3rb8g.mp4 | 78.12 MB | ||
| 9. Practical UserForm to Document External Links - Comments -Combo Box - Option button- Video | |||
| biuv6f9ujavq7bbf4430.mp4 | 123.37 MB | ||
| 18. Main Project -3- Invoice Generation Tool | |||
| 1. Tool Overview- What You Will Learn Video | |||
| biuv6thujavq7bbf444g.mp4 | 60.95 MB | ||
| 10. Final Updates - Debugging Video | |||
| biuv8flnkrnfm4n3rbeg.mp4 | 174.57 MB | ||
| 11. Last Milestone Completed- Text | |||
| Last Milestone Completed-.html | 618 B | ||
| 2. Setting up an Input UserForm to Collect Master Data Video | |||
| biuv73dnkrnfm4n3rb9g.mp4 | 90.82 MB | ||
| 3. Working with Multi-Column ListBoxes Video | |||
| biuv6q5nkrnfm4n3rb90.mp4 | 84.98 MB | ||
| 4. Edit Master Data with UserForm Video | |||
| biuv76hujavq7bbf445g.mp4 | 52.55 MB | ||
| 5. Searchable ListBox -with Selection Change event- Video | |||
| biuv7apujavq7bbf4460.mp4 | 74.91 MB | ||
| 6. Enhanced Searchable ListBox- Write Selection back to Excel Table Video | |||
| biuv7gdnkrnfm4n3rbag.mp4 | 97.96 MB | ||
| 7. MultiPage UserForm to Create Invoices - Email -Setup- Video | |||
| biuv7ntnkrnfm4n3rbb0.mp4 | 127.07 MB | ||
| 8. Export PDF - Excel Workbook for Each Invoice based on ListBox Selection Video | |||
| biuv80hujavq7bbf4470.mp4 | 167.59 MB | ||
| 9. Create Email in Outlook - Attach PDF Invoice Video | |||
| biuv85tnkrnfm4n3rbd0.mp4 | 93.85 MB | ||
| 19. Create your own Custom Functions | |||
| 1. Overview- Function Procedures Video | |||
| biuv8npujavq7bbf4480.mp4 | 18.53 MB | ||
| 2. Setting up a Simple Function -including Optional Arguments- Video | |||
| biuv8q5nkrnfm4n3rbfg.mp4 | 26.34 MB | ||
| 3. Function to Calculate Age -Result in Years - Months- Video | |||
| biuv8stnkrnfm4n3rbg0.mp4 | 46.91 MB | ||
| 4. Functions that Split Text and Numbers from Cell Value Video | |||
| biuv901ujavq7bbf448g.mp4 | 44.46 MB | ||
| 5. Using Functions in Sub Procedures Video | |||
| biuv92lnkrnfm4n3rbgg.mp4 | 42.43 MB | ||
| 6. Activity- Function That Sums based on Cell Color Text | |||
| Activity- Function That Sums based on Cell Color.html | 818 B | ||
| 7. Project- Function That Sums based on Cell Color Video | |||
| biuv8mdnkrnfm4n3rbf0.mp4 | 92.63 MB | ||
| 8. Key Takeaways- Function Procedures in VBA Text | |||
| Key Takeaways- Function Procedures in VBA.html | 650 B | ||
| 2. Your First Excel Macro | |||
| 1. Overview- Macros - Visual Basic Editor -VBE- Video | |||
| biuufi9ujavq7bbf42og.mp4 | 23.2 MB | ||
| 2. Steps to Your First Macro Recording Video | |||
| biuufl5nkrnfm4n3r9pg.mp4 | 28.77 MB | ||
| 3. Visual Basic Editor- What You Need to Know Video | |||
| biuufntnkrnfm4n3r9q0.mp4 | 48.05 MB | ||
| 4. Project- Dynamic Cell Selection -Special Cells- Video | |||
| biuufttnkrnfm4n3r9qg.mp4 | 110.89 MB | ||
| 5. Project- Absolute versus Relative Macro Recording Video | |||
| biuug4dnkrnfm4n3r9r0.mp4 | 100.58 MB | ||
| 6. 7 Ways to Run Macros - VBA code Video | |||
| biuug79ujavq7bbf42p0.mp4 | 50.36 MB | ||
| 7. OFFICE 365 Update- Comments - Notes Text | |||
| OFFICE 365 Update- Comments - Notes.html | 1.39 KB | ||
| 8. Activity- Record a Macro that Deletes all Comments Text | |||
| Activity- Record a Macro that Deletes all Comments.html | 901 B | ||
| 9. What-s the Difference Between Macros and VBA- Text | |||
| What-s the Difference Between Macros and VBA-.html | 1.86 KB | ||
| 20. Working with Charts | |||
| 1. Overview- The Chart Object Library Video | |||
| biuv9c5nkrnfm4n3rbh0.mp4 | 14.81 MB | ||
| 2. Create and Modify a Chart with VBA Video | |||
| biuv9gtnkrnfm4n3rbhg.mp4 | 77.11 MB | ||
| 3. Animated Charts- Different Methods Video | |||
| biuv9k1ujavq7bbf4490.mp4 | 55.26 MB | ||
| 4. Show Charts inside UserForms Video | |||
| biuv9ppujavq7bbf449g.mp4 | 87.3 MB | ||
| 5. Key Takeaways- VBA Charts Text | |||
| Key Takeaways- VBA Charts.html | 641 B | ||
| 22. Final Assessment - Next Steps | |||
| 2. Share the love- Text | |||
| Share the love-.html | 152 B | ||
| 3. Next Steps Text | |||
| Next Steps.html | 3.59 KB | ||
| 3. The Object Model | |||
| 1. Overview- VBA Object Model Video | |||
| biuuh3hujavq7bbf42r0.mp4 | 23.39 MB | ||
| 2. VBA-s Code Reference Object Library Video | |||
| biuuge1ujavq7bbf42pg.mp4 | 22.77 MB | ||
| 3. VB Color Guidelines - Keyboard Shortcuts Video | |||
| biuugh1ujavq7bbf42q0.mp4 | 47.89 MB | ||
| 4. Excel VBA Object Model Video | |||
| biuugjdnkrnfm4n3r9rg.mp4 | 27.85 MB | ||
| 5. Object Properties Video | |||
| biuugldnkrnfm4n3r9s0.mp4 | 25.02 MB | ||
| 6. Object Methods Video | |||
| biuugohujavq7bbf42qg.mp4 | 35.36 MB | ||
| 7. How to Find the Object- Property - Method Video | |||
| biuugs5nkrnfm4n3r9sg.mp4 | 50.09 MB | ||
| 8. Conclusion- Key Takeaways Video | |||
| biuugtdnkrnfm4n3r9t0.mp4 | 18.54 MB | ||
| 4. Referencing Ranges- Worksheets - Workbooks with VBA | |||
| 1. Overview- Referencing Ranges- Worksheets - Workbooks Video | |||
| biuuhihujavq7bbf42rg.mp4 | 15.89 MB | ||
| 10. Key Takeaways- Referencing Ranges Video | |||
| biuuimlnkrnfm4n3ra00.mp4 | 13.1 MB | ||
| 2. Referring to Ranges - Writing to Cells in VBA Video | |||
| biuuhllnkrnfm4n3r9tg.mp4 | 47.19 MB | ||
| 3. Most Useful Range Properties - Methods Video | |||
| biuuhqtnkrnfm4n3r9u0.mp4 | 96.77 MB | ||
| 4. 4 Methods to Find the Last Row of a Range Video | |||
| biuui0dnkrnfm4n3r9ug.mp4 | 97.73 MB | ||
| 5. Copying - Resizing a Variable Range Video | |||
| biuui41ujavq7bbf42s0.mp4 | 48.75 MB | ||
| 6. Properly Referencing Worksheets Video | |||
| biuuiadnkrnfm4n3r9v0.mp4 | 116.87 MB | ||
| 7. Properly Referencing Workbooks Video | |||
| biuuifdnkrnfm4n3r9vg.mp4 | 88.48 MB | ||
| 8. Activity- Save a Hard-coded Copy of Workbook Text | |||
| Activity- Save a Hard-coded Copy of Workbook.html | 1.82 KB | ||
| 9. Project- Save Hard-coded Copy - Macro-free version of workbook Video | |||
| biuuilpujavq7bbf42sg.mp4 | 120.27 MB | ||
| 5. Working with Variables | |||
| 1. Overview- Role of Assignment - Variables Video | |||
| biuuqp1ujavq7bbf430g.mp4 | 29.13 MB | ||
| 2. Data Types for Better Performance Video | |||
| biuuqqtnkrnfm4n3ra6g.mp4 | 21.58 MB | ||
| 3. Declaring Variables- Arrays - Constants Video | |||
| biuuqu1ujavq7bbf4310.mp4 | 35.43 MB | ||
| 4. Setting Object Variables Video | |||
| biuur11ujavq7bbf431g.mp4 | 36.6 MB | ||
| 5. Scoping Variables Video | |||
| biuur3dnkrnfm4n3ra70.mp4 | 24.52 MB | ||
| 6. Activity- Revisit Hard-coded Workbook Project Text | |||
| Activity- Revisit Hard-coded Workbook Project.html | 1.27 KB | ||
| 7. Key Takeaways- Working with Variables Video | |||
| biuur4dnkrnfm4n3ra7g.mp4 | 11.61 MB | ||
| 6. Looping through Collections - Making Decisions | |||
| 1. Overview- Why Collections are a VBA Essential Video | |||
| biuur8dnkrnfm4n3ra80.mp4 | 20.27 MB | ||
| 10. Key Takeaways- Collections - Decision Making in VBA Text | |||
| Key Takeaways- Collections - Decision Making in VBA.html | 586 B | ||
| 2. With - End With for Easier Code Writing Video | |||
| biuurb5nkrnfm4n3ra8g.mp4 | 34.66 MB | ||
| 3. For Each to Loop Through Collections Video | |||
| biuuri9ujavq7bbf4320.mp4 | 49.65 MB | ||
| 4. IF Then -Else- ElseIF- for Conditional Outcomes Video | |||
| biuurllnkrnfm4n3ra90.mp4 | 47.31 MB | ||
| 5. Select Case as Alternative for Many IF Statements Video | |||
| biuurmpujavq7bbf432g.mp4 | 14.17 MB | ||
| 6. Goto Statement to Change Program Flow Video | |||
| biuurotnkrnfm4n3ra9g.mp4 | 29.44 MB | ||
| 7. Activity- Get the Number of Formulas in a Worksheet Text | |||
| Activity- Get the Number of Formulas in a Worksheet.html | 774 B | ||
| 8. Project- Get the Number of Formulas in a Worksheet Video | |||
| biuurttnkrnfm4n3raa0.mp4 | 45.75 MB | ||
| 9. Bonus- Un-hiding All Sheets in One Go -3 Methods- Video | |||
| biuus2lnkrnfm4n3rabg.mp4 | 51.95 MB | ||
| 7. Useful Built-in Functions | |||
| 1. Overview- VBA versus Worksheet Functions Video | |||
| biuus1tnkrnfm4n3rab0.mp4 | 80.52 MB | ||
| 2. Most Useful VBA Functions Video | |||
| biuus4tnkrnfm4n3rac0.mp4 | 33 MB | ||
| 3. Message Box Options Video | |||
| biuus89ujavq7bbf4330.mp4 | 36.88 MB | ||
| 4. Input Box -VBA InputBox Function- Video | |||
| biuuse1ujavq7bbf4340.mp4 | 30.6 MB | ||
| 5. Input Box that can Select Ranges Video | |||
| biuusjhujavq7bbf434g.mp4 | 50.59 MB | ||
| 6. Activity- Show Top 3 Values in a Message Box Based on Range Text | |||
| Activity- Show Top 3 Values in a Message Box Based on Range.html | 1.4 KB | ||
| 7. Project- Show Top 3 Values in a Message box based on Range Video | |||
| biuusudnkrnfm4n3raf0.mp4 | 84.37 MB | ||
| 8. Key Takeaways- Built-in Functions Text | |||
| Key Takeaways- Built-in Functions.html | 600 B | ||
| 8. Debugging- Error Handling - Procedure Scope | |||
| 1. Overview- Debugging- Handling Errors - Procedure Scope Video | |||
| biuusc1ujavq7bbf433g.mp4 | 26.68 MB | ||
| 2. Debugging Options- Watch- Locals- Immediate Windows - More Video | |||
| biuusldnkrnfm4n3radg.mp4 | 98.76 MB | ||
| 3. Error Handling- Different Methods Video | |||
| biuussdnkrnfm4n3raeg.mp4 | 58.12 MB | ||
| 4. Faster Code by Suppressing Pop-ups - Flickering Screen Video | |||
| biuut15nkrnfm4n3rag0.mp4 | 52.13 MB | ||
| 5. Procedure Scope - Running one Sub from Another Video | |||
| biuut3hujavq7bbf435g.mp4 | 22.33 MB | ||
| 6. Passing Arguments to Sub Procedures -By Ref- By Val- Video | |||
| biuut7tnkrnfm4n3raig.mp4 | 41.26 MB | ||
| 7. Activity- Number of Formulas -or Comments- Used in a Workbook Text | |||
| Activity- Number of Formulas -or Comments- Used in a Workbook.html | 991 B | ||
| 8. Project- Number of Formulas -or Comments- Used in a Workbook Video | |||
| biuuthlnkrnfm4n3rak0.mp4 | 93.19 MB | ||
| 9. Key Takeaways- Debugging - Error Handling Video | |||
| biuutjdnkrnfm4n3ral0.mp4 | 11.71 MB | ||
| 9. Main Project -1- Create a Tool to Automate Table of Contents -TOC- | |||
| 1. Project Overview- Table of Contents -TOC- Video | |||
| biuut1dnkrnfm4n3ragg.mp4 | 19.2 MB | ||
| 2. TOC Project- The Basics Video | |||
| biuut9dnkrnfm4n3raj0.mp4 | 44.09 MB | ||
| 3. TOC Project- Adding Hyperlinks Video | |||
| biuut4dnkrnfm4n3rahg.mp4 | 25.32 MB | ||
| 4. TOC Project- Testing the VBA Code Video | |||
| biuusutnkrnfm4n3rafg.mp4 | 22.66 MB | ||
| 5. TOC Project- Adding Error Handling - More Checks Video | |||
| biuuthtnkrnfm4n3rakg.mp4 | 88.96 MB | ||
| 6. TOC Project- Adding to Personal Macro Workbook Video | |||
| biuutk1ujavq7bbf4360.mp4 | 25.54 MB | ||
| 7. First Milestone Completed- Text | |||
| First Milestone Completed-.html | 703 B |
This path is for Excel users looking to ace the Microsoft MO-201 Exam and build a deep, expert-level skill set, including formulas, charts, PivotTables, Power Query and more.
ABOUT THIS PATH
This path is for Excel users looking to build a deep, expert-level skill set, including formulas, charts, PivotTables, Power Query, and more.
We'll start with a deep dive into some of Excel's core capabilities, including formulas, charts & graphs, and PivotTables. You'll learn how to explore and analyze raw data, build custom visuals and interactive reports, and quickly expose patterns and insights with user-friendly pivots.
From there we'll dive into more advanced tools like Power Query, Power Pivot & DAX, introduce advanced dashboard design principles, and explore tips and techniques to help you maximize your productivity.
Finally, we'll wrap up with an exam prep course to help you earn your official MO-201 Excel Expert certification from Microsoft.
WHO SHOULD TAKE THIS PATH?
Excel users who want to work more efficiently and develop expert-level analytics and data visualization skills
Analysts or business intelligence professionals looking to develop a deep and well-rounded Excel skill set
Excel users looking to ace the MO-201 exam and become a Microsoft Certified Expert
WHAT ARE THE PATH REQUIREMENTS?
Microsoft Excel, ideally Excel 2019 or Office 365 for Windows/PC (some features and charts are unavailable in older versions)
Familiarity with basic Excel functionality is strongly recommended
NOTE: The MO-201 Exam specifically covers Excel 2019/Office 365
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 1.6 GB | freecoursewb | 6 months | 0 | 0 | |
|
DevOps: CI/CD using Jenkins, Maven, Git, Sonar, OWASP, Trivy (Oct-2025) Posted by
notimmune in Other
|
3.3 GB | notimmune | 7 months | 10 | 6 |
| 8.3 GB | xHOBBiTx | 8 months | 36 | 4 | |
| 3.3 GB | freecoursewb | 10 months | 3 | 2 | |
| 928.1 MB | xHOBBiTx | 2 years | 5 | 0 |
All Comments