Microsoft Excel- Formulas - Functions/5. Lookup-Reference Functions/15. DEMO- Building Dashboards with XLOOKUP Video/bpbarnm4u06v67aaqdm0.mp4 397.3 MB
Excel Pro Tips- Formatting/1. Formatting Tips/13. Converting Text to Date Values Video/biht2g5nkrnfm4n3le90.mp4 284.1 MB
Microsoft Excel- Formulas - Functions/2. Excel Formulas 101/2. Formula Syntax Video/bk3r4v9ujavq7bbfl2p0.mp4 218.3 MB
Microsoft Excel- VBA - Macros/14. Main Project -2- Sales Regional Reporting Tool/4. Setting up a Template as the Basis for Different Reports Video/biuv319ujavq7bbf43l0.mp4 216.3 MB
Excel Pro Tips- Formulas/1. Formula Tips/14. Matching Items Between Lists Video/biht91pujavq7bbeu6v0.mp4 213.8 MB
Microsoft Excel- Formulas - Functions/4. Statistical Functions/10. PRO TIP- Data Profiling with COUNT - SUMPRODUCT Video/bpbaqaq894no2mlcndc0.mp4 207.2 MB
Excel Pro Tips- Formatting/1. Formatting Tips/15. Advanced Number Formats Video/biht5o5nkrnfm4n3lef0.mp4 205.1 MB
Microsoft Excel- Formulas - Functions/10. Bonus Functions/5. WEBSERVICE - FILTERXML Demo- Open Weather Map Video/bif2v8vf2qij22kssre0.mp4 195.0 MB
Excel Pro Tips- Formulas/1. Formula Tips/16. Many-to-Many Lookups Video/biht9b9ujavq7bbeu6vg.mp4 171.0 MB
Microsoft Excel- VBA - Macros/18. Main Project -3- Invoice Generation Tool/8. Export PDF - Excel Workbook for Each Invoice based on ListBox Selection Video/biuv80hujavq7bbf4470.mp4 167.6 MB
Excel Pro Tips- Data Visualization/1. Visualization Tips/13. Interactive Form Controls Video/bihtc6hujavq7bbeu74g.mp4 164.5 MB
Excel Pro Tips- Analytics/1. Analytics Tips/9. Data Modeling 101 Video/bihthd9ujavq7bbeu7eg.mp4 162.8 MB
Excel Pro Tips- Productivity/1. Productivity Tips/13. Named Range - Table References Video/biht5itnkrnfm4n3leeg.mp4 162.2 MB
Microsoft Excel- VBA - Macros/13. Excel Tables- Formulas - Pivot Tables/4. Pivot Tables - VBA- What you Need to Know Video/biuv24tnkrnfm4n3rb00.mp4 160.2 MB
Excel Pro Tips- Productivity/1. Productivity Tips/10. Splitting Text to Columns Video/biht4ldnkrnfm4n3ledg.mp4 144.5 MB
Microsoft Excel- VBA - Macros/12. Working with Files- Folders - Text Files/8. Project- Export Data to Text file Video/biuv185nkrnfm4n3ratg.mp4 141.5 MB
Microsoft Excel- VBA - Macros/13. Excel Tables- Formulas - Pivot Tables/3. Excel Tables- Use the Right Syntax Video/biuv1s5nkrnfm4n3ravg.mp4 139.8 MB
Excel Pro Tips- Productivity/1. Productivity Tips/8. Autofill - Flash Fill Video/biht2o9ujavq7bbeu6hg.mp4 131.8 MB
Microsoft Excel- VBA - Macros/4. Referencing Ranges- Worksheets - Workbooks with VBA/9. Project- Save Hard-coded Copy - Macro-free version of workbook Video/biuuilpujavq7bbf42sg.mp4 120.3 MB
Excel Pro Tips- Productivity/1. Productivity Tips/4. ALT Key Tips Video/biht1a9ujavq7bbeu6e0.mp4 118.6 MB
Microsoft Excel- VBA - Macros/4. Referencing Ranges- Worksheets - Workbooks with VBA/6. Properly Referencing Worksheets Video/biuuiadnkrnfm4n3r9v0.mp4 116.9 MB
Excel Pro Tips- Analytics/1. Analytics Tips/8. Power Query Tools Video/bihtg5dnkrnfm4n3lf2g.mp4 116.4 MB
Microsoft Excel- Pivot Tables - Pivot Charts/2. PivotTable 101/11. Removing - Reviving Data from Cache Video/bilm9rdnkrnfm4n3n4i0.mp4 113.0 MB
Microsoft Excel- VBA - Macros/17. Working with Userforms - ActiveX Controls/7. UserForm Basics- What You Need to Get Started Video/biuv63dnkrnfm4n3rb7g.mp4 112.9 MB
Excel Pro Tips- Formulas/1. Formula Tips/11. -Fuzzy Match- Lookups Video/bihta39ujavq7bbeu710.mp4 112.1 MB
Microsoft Excel- VBA - Macros/2. Your First Excel Macro/4. Project- Dynamic Cell Selection -Special Cells- Video/biuufttnkrnfm4n3r9qg.mp4 110.9 MB
Microsoft Excel- VBA - Macros/14. Main Project -2- Sales Regional Reporting Tool/3. Importing Data from Multiple Files using MultiSelect Video/biuv2l9ujavq7bbf43jg.mp4 110.5 MB
Excel Pro Tips- Formulas/1. Formula Tips/10. Hyperlinking Between Worksheets Video/biht9t5nkrnfm4n3leo0.mp4 109.3 MB
Microsoft Excel- VBA - Macros/10. Looping in VBA -Controlling the Flow of Code-/3. For Next Nested Loop Video/biuuug5nkrnfm4n3rang.mp4 108.2 MB
Excel Pro Tips- Formulas/1. Formula Tips/6. Formula Auditing Tools Video/bihtarlnkrnfm4n3lep0.mp4 107.8 MB
Excel Pro Tips- Pivot Tables/1. PivotTable Tips/13. Removing - Reviving Source Data Video/bihtdudnkrnfm4n3leug.mp4 106.3 MB
Excel Pro Tips- Formulas/1. Formula Tips/4. Converting Units of Measurement Video/bihtafpujavq7bbeu720.mp4 104.1 MB
Excel Pro Tips- Formulas/1. Formula Tips/13. Combining INDEX - MATCH Video/biht9n9ujavq7bbeu70g.mp4 103.6 MB
Microsoft Excel- VBA - Macros/15. Interacting with Other Applications -Word- PowerPoint etc.-/5. Microsoft PowerPoint- Export Excel Sheets to PowerPoint Presentation Video/biuv4cdnkrnfm4n3rb5g.mp4 103.4 MB
Excel Pro Tips- Formulas/1. Formula Tips/15. Counting Duplicates with SUMPRODUCT Video/biht7v1ujavq7bbeu6tg.mp4 103.1 MB
Excel Pro Tips- Data Visualization/1. Visualization Tips/9. Analyzing Distribution with Histograms Video/bihtbi9ujavq7bbeu73g.mp4 102.6 MB
Microsoft Excel- VBA - Macros/10. Looping in VBA -Controlling the Flow of Code-/11. Project- Document all Comments in Workbook in a Sheet Video/biuuu3hujavq7bbf437g.mp4 101.5 MB
Microsoft Excel- VBA - Macros/2. Your First Excel Macro/5. Project- Absolute versus Relative Macro Recording Video/biuug4dnkrnfm4n3r9r0.mp4 100.6 MB
Excel Pro Tips- Analytics/1. Analytics Tips/12. Advanced Optimization with Solver Video/bihtfmdnkrnfm4n3lf10.mp4 100.4 MB
Microsoft Excel- VBA - Macros/8. Debugging- Error Handling - Procedure Scope/2. Debugging Options- Watch- Locals- Immediate Windows - More Video/biuusldnkrnfm4n3radg.mp4 98.8 MB
Excel Pro Tips- Analytics/1. Analytics Tips/11. Monte Carlo Simulation Video/bihtgh9ujavq7bbeu7d0.mp4 98.7 MB
Microsoft Excel- VBA - Macros/18. Main Project -3- Invoice Generation Tool/6. Enhanced Searchable ListBox- Write Selection back to Excel Table Video/biuv7gdnkrnfm4n3rbag.mp4 98.0 MB
Excel Pro Tips- Formatting/1. Formatting Tips/5. Format Painter Video/biht571ujavq7bbeu6mg.mp4 97.8 MB
Microsoft Excel- VBA - Macros/4. Referencing Ranges- Worksheets - Workbooks with VBA/4. 4 Methods to Find the Last Row of a Range Video/biuui0dnkrnfm4n3r9ug.mp4 97.7 MB
Excel Pro Tips- Formulas/1. Formula Tips/5. Real-Time Tools with TODAY - NOW Video/bl9du2jje7ib1ccr5j30.mp4 97.2 MB
Excel MO-201 Exam Prep/3. Advanced Formulas - Macros/25. Combining INDEX - MATCH Video/bummnpbi57dcbr645f1g.mp4 97.1 MB
Microsoft Excel- Formulas - Functions/5. Lookup-Reference Functions/5. Joining Data with VLOOKUP Video/blfgcvrje7ib1ccr8ej0.mp4 97.1 MB
Microsoft Excel- VBA - Macros/4. Referencing Ranges- Worksheets - Workbooks with VBA/3. Most Useful Range Properties - Methods Video/biuuhqtnkrnfm4n3r9u0.mp4 96.8 MB
Excel Pro Tips- Formulas/1. Formula Tips/9. Dependent Drop-Downs with INDIRECT Video/bihta8pujavq7bbeu71g.mp4 95.8 MB
Microsoft Excel- Power Query- Power Pivot - DAX/3. Power Query/6. Basic Table Transformations Video/bmrhfka9c233ls0jbsm0.mp4 94.8 MB
Microsoft Excel- VBA - Macros/18. Main Project -3- Invoice Generation Tool/9. Create Email in Outlook - Attach PDF Invoice Video/biuv85tnkrnfm4n3rbd0.mp4 93.9 MB
Microsoft Excel- VBA - Macros/8. Debugging- Error Handling - Procedure Scope/8. Project- Number of Formulas -or Comments- Used in a Workbook Video/biuuthlnkrnfm4n3rak0.mp4 93.2 MB
Microsoft Excel- VBA - Macros/19. Create your own Custom Functions/7. Project- Function That Sums based on Cell Color Video/biuv8mdnkrnfm4n3rbf0.mp4 92.6 MB
Microsoft Excel- VBA - Macros/18. Main Project -3- Invoice Generation Tool/2. Setting up an Input UserForm to Collect Master Data Video/biuv73dnkrnfm4n3rb9g.mp4 90.8 MB
Microsoft Excel- VBA - Macros/16. Workbook and Worksheet Events/2. Workbook Events- Toggle Full Screen -Activate- Deactivate- Open- Close- Video/biuv4opujavq7bbf43s0.mp4 89.3 MB
Microsoft Excel- Power Query- Power Pivot - DAX/6. Common DAX Functions/21. Time Intelligence Formulas Video/bihmfeqmeheka336agvg.mp4 89.3 MB
Microsoft Excel- VBA - Macros/10. Looping in VBA -Controlling the Flow of Code-/4. For Next Reverse Loop -Delete Filtered-Hidden Rows- Video/biuuum9ujavq7bbf439g.mp4 89.2 MB
Microsoft Excel- VBA - Macros/9. Main Project -1- Create a Tool to Automate Table of Contents -TOC-/5. TOC Project- Adding Error Handling - More Checks Video/biuuthtnkrnfm4n3rakg.mp4 89.0 MB
Microsoft Excel- VBA - Macros/4. Referencing Ranges- Worksheets - Workbooks with VBA/7. Properly Referencing Workbooks Video/biuuifdnkrnfm4n3r9vg.mp4 88.5 MB
Microsoft Excel- Pivot Tables - Pivot Charts/7. PivotTable Case Studies/19. Apple App Data Video/bilmh3lnkrnfm4n3n4q0.mp4 87.9 MB
Microsoft Excel- VBA - Macros/14. Main Project -2- Sales Regional Reporting Tool/5. Exporting Reports as Excel files Video/biuv369ujavq7bbf43m0.mp4 87.8 MB
Microsoft Excel- VBA - Macros/20. Working with Charts/4. Show Charts inside UserForms Video/biuv9ppujavq7bbf449g.mp4 87.3 MB
Microsoft Excel- VBA - Macros/18. Main Project -3- Invoice Generation Tool/3. Working with Multi-Column ListBoxes Video/biuv6q5nkrnfm4n3rb90.mp4 85.0 MB
Microsoft Excel- VBA - Macros/7. Useful Built-in Functions/7. Project- Show Top 3 Values in a Message box based on Range Video/biuusudnkrnfm4n3raf0.mp4 84.4 MB
Microsoft Excel- VBA - Macros/16. Workbook and Worksheet Events/4. Refresh PivotTables Automatically - Concept of Range Intersection Video/biuv4vhujavq7bbf43t0.mp4 84.0 MB
Microsoft Excel- VBA - Macros/7. Useful Built-in Functions/1. Overview- VBA versus Worksheet Functions Video/biuus1tnkrnfm4n3rab0.mp4 80.5 MB
Microsoft Excel- VBA - Macros/11. Working with Arrays/8. Project- Create a New Worksheet per Company with Specific Information Video/biuv0d9ujavq7bbf43d0.mp4 80.1 MB
Excel Pro Tips- Data Visualization/1. Visualization Tips/2. Chart Properties -Move - Size- Video/bihtbahujavq7bbeu730.mp4 79.3 MB
Microsoft Excel- Power Query- Power Pivot - DAX/6. Common DAX Functions/7. Logical Functions -IF-AND-OR- Video/bihmf77f2qij22ksu0u0.mp4 79.2 MB
Microsoft Excel- VBA - Macros/16. Workbook and Worksheet Events/7. Project- Link Page Header to Cell Value -BeforePrint Event- Video/biuv571ujavq7bbf43ug.mp4 78.8 MB
Microsoft Excel- VBA - Macros/17. Working with Userforms - ActiveX Controls/8. UserForm for Data Entry -Input - Check Boxes- Video/biuv685nkrnfm4n3rb8g.mp4 78.1 MB
Microsoft Excel- Formulas - Functions/5. Lookup-Reference Functions/8. Approximate Match Lookups Video/bif31v2meheka3369dt0.mp4 75.9 MB
Microsoft Excel- VBA - Macros/18. Main Project -3- Invoice Generation Tool/5. Searchable ListBox -with Selection Change event- Video/biuv7apujavq7bbf4460.mp4 74.9 MB
Microsoft Excel- VBA - Macros/13. Excel Tables- Formulas - Pivot Tables/2. Using Excel Formulas in VBA Video/biuv1klnkrnfm4n3raug.mp4 74.3 MB
Microsoft Excel- Formulas - Functions/2. Excel Formulas 101/5. Formula Auditing- Trace Precedents - Dependents Video/bk3r9n5nkrnfm4n4c9q0.mp4 73.7 MB
Microsoft Excel- VBA - Macros/12. Working with Files- Folders - Text Files/4. FileDialog Property- Loop Inside a Folder Video/biuv0stnkrnfm4n3ras0.mp4 73.2 MB
Microsoft Excel- Charts - Graphs/5. Next-Level Data Visualization Exercises/7. DEMO- Building a Dynamic Dashboard -Part 1- Video/bih442qmeheka336aaf0.mp4 73.1 MB
Microsoft Excel- Pivot Tables - Pivot Charts/7. PivotTable Case Studies/17. Spartan Race Facebook Posts Video/bih3d2qmeheka336a9gg.mp4 72.3 MB
Excel Pro Tips- Data Visualization/1. Visualization Tips/11. Highlighting Time Periods Video/bihtcmpujavq7bbeu760.mp4 72.2 MB
Microsoft Excel- VBA - Macros/17. Working with Userforms - ActiveX Controls/6. ActiveX to Show or Hide Other ActiveX controls Video/biuv5shujavq7bbf442g.mp4 71.5 MB
Microsoft Excel- Pivot Tables - Pivot Charts/7. PivotTable Case Studies/9. Stock Market Data Video/bih3cvff2qij22kstoj0.mp4 71.0 MB
Excel Pro Tips- Formatting/1. Formatting Tips/6. Color - Border Design Video/biht1h1ujavq7bbeu6fg.mp4 70.8 MB
Microsoft Excel- VBA - Macros/15. Interacting with Other Applications -Word- PowerPoint etc.-/4. Microsoft Word- Create Personalized Letters in Word from Excel Video/biuv46dnkrnfm4n3rb4g.mp4 70.2 MB
Microsoft Excel- Power Query- Power Pivot - DAX/3. Power Query/11. Adding Index - Conditional Columns Video/biqi11tnkrnfm4n3pk0g.mp4 69.9 MB
Microsoft Excel- VBA - Macros/14. Main Project -2- Sales Regional Reporting Tool/8. Track the List of Tasks Completed with VBA Video/biuv3hhujavq7bbf43o0.mp4 69.7 MB
Microsoft Excel- Pivot Tables - Pivot Charts/7. PivotTable Case Studies/5. San Francisco Salaries Video/bih3ct2meheka336a9fg.mp4 69.4 MB
Microsoft Excel- Pivot Tables - Pivot Charts/7. PivotTable Case Studies/11. Baseball Team Stats Video/bih3d07f2qij22kstojg.mp4 62.6 MB
Microsoft Excel- VBA - Macros/14. Main Project -2- Sales Regional Reporting Tool/7. Setting up Automatic Export of Text File Video/biuv3dhujavq7bbf43ng.mp4 62.5 MB
Microsoft Excel- VBA - Macros/15. Interacting with Other Applications -Word- PowerPoint etc.-/2. PDF- Save Specific Sheets as a PDF File Video/biuv3vlnkrnfm4n3rb2g.mp4 61.8 MB
Excel Pro Tips- Pivot Tables/1. PivotTable Tips/15. Solve Order - List Formulas Video/bihtdgpujavq7bbeu77g.mp4 61.8 MB
Microsoft Excel- VBA - Macros/11. Working with Arrays/2. One Dimensional Arrays Video/biuv00dnkrnfm4n3raqg.mp4 61.7 MB
Excel Pro Tips- Productivity/1. Productivity Tips/9. Customizing the Ribbon Video/biht511ujavq7bbeu6m0.mp4 61.3 MB
Excel Pro Tips- Pivot Tables/1. PivotTable Tips/9. Adding Value Calculations Video/bihtd8tnkrnfm4n3letg.mp4 61.1 MB
Microsoft Excel- VBA - Macros/18. Main Project -3- Invoice Generation Tool/1. Tool Overview- What You Will Learn Video/biuv6thujavq7bbf444g.mp4 60.9 MB
Excel Pro Tips- Analytics/0. Course Intro/2.DOWNLOAD%3a Course Resources/ProTipWorkbooks-1554822204518.zip 60.9 MB
Excel Pro Tips- Data Visualization/0. Course Intro/2.DOWNLOAD%3a Course Resources/ProTipWorkbooks-1554822204518.zip 60.9 MB
Excel Pro Tips- Formatting/0. Course Intro/2.DOWNLOAD%3a Course Resources/ProTipWorkbooks-1554822204518.zip 60.9 MB
Excel Pro Tips- Formulas/0. Course Intro/2.DOWNLOAD%3a Course Resources/ProTipWorkbooks-1554822204518_2.zip 60.9 MB
Excel Pro Tips- Formatting/1. Formatting Tips/12. Formatting Errors with IFERROR Video/biht2vhujavq7bbeu6ig.mp4 60.4 MB
Microsoft Excel- Power Query- Power Pivot - DAX/6. Common DAX Functions/17. Iterator --X-- Functions- SUMX Video/bihmen2meheka336agr0.mp4 60.2 MB
Excel Pro Tips- Data Visualization/1. Visualization Tips/5. Customizing Charts to Tell a Story Video/bihtcqdnkrnfm4n3lesg.mp4 60.0 MB
Microsoft Excel- Charts - Graphs/5. Next-Level Data Visualization Exercises/6. DEMO- Animating Changes Over Time Video/bih441imeheka336aaeg.mp4 59.7 MB
Microsoft Excel- Power Query- Power Pivot - DAX/6. Common DAX Functions/5. COUNT- COUNTA- DISTINCTCOUNT - COUNTROWS Video/bihmei2meheka336agq0.mp4 55.6 MB
Microsoft Excel- VBA - Macros/20. Working with Charts/3. Animated Charts- Different Methods Video/biuv9k1ujavq7bbf4490.mp4 55.3 MB
Microsoft Excel- Power Query- Power Pivot - DAX/6. Common DAX Functions/13. Adding Filter Context with Filter -Part 2- Video/bihmekvf2qij22ksu0s0.mp4 55.1 MB
Microsoft Excel- VBA - Macros/14. Main Project -2- Sales Regional Reporting Tool/9. Final Touches - Creating Interface to Hide Specific Tabs with a Password Video/biuv3l9ujavq7bbf43og.mp4 54.7 MB
Microsoft Excel- VBA - Macros/10. Looping in VBA -Controlling the Flow of Code-/7. Find Method for Quicker Lookup Results Video/biuuuv5nkrnfm4n3rap0.mp4 54.5 MB
Microsoft Excel- Power Query- Power Pivot - DAX/6. Common DAX Functions/11. The CALCULATE Function Video/bihmegvf2qij22ksu0qg.mp4 52.0 MB
Microsoft Excel- VBA - Macros/6. Looping through Collections - Making Decisions/9. Bonus- Un-hiding All Sheets in One Go -3 Methods- Video/biuus2lnkrnfm4n3rabg.mp4 51.9 MB
Excel Pro Tips- Data Visualization/1. Visualization Tips/6. Adding Sparklines Video/bihtb61ujavq7bbeu72g.mp4 51.8 MB
Excel Pro Tips- Productivity/1. Productivity Tips/2. Customizing the Footer Video/biht2ulnkrnfm4n3lea0.mp4 51.6 MB
Microsoft Excel- VBA - Macros/17. Working with Userforms - ActiveX Controls/10. BONUS- ListBox to Print Multiple Pages at Once Video/bn8bd4a9c233ls0jkbvg.mp4 50.9 MB
Microsoft Excel- Pivot Tables - Pivot Charts/7. PivotTable Case Studies/3. U.S. Voters -2012- Video/bih3cs2meheka336a9f0.mp4 50.9 MB
Microsoft Excel- Pivot Tables - Pivot Charts/6. Pivot Charts/11. Building a Dynamic Dashboard Video/bih3b3vf2qij22kstohg.mp4 50.6 MB
Microsoft Excel- VBA - Macros/7. Useful Built-in Functions/5. Input Box that can Select Ranges Video/biuusjhujavq7bbf434g.mp4 50.6 MB
Microsoft Excel- VBA - Macros/2. Your First Excel Macro/6. 7 Ways to Run Macros - VBA code Video/biuug79ujavq7bbf42p0.mp4 50.4 MB
Microsoft Excel- VBA - Macros/3. The Object Model/7. How to Find the Object- Property - Method Video/biuugs5nkrnfm4n3r9sg.mp4 50.1 MB
Microsoft Excel- VBA - Macros/14. Main Project -2- Sales Regional Reporting Tool/6. Fine-tuning Report Export Procedure Video/biuv39pujavq7bbf43mg.mp4 49.8 MB
Microsoft Excel- VBA - Macros/6. Looping through Collections - Making Decisions/3. For Each to Loop Through Collections Video/biuuri9ujavq7bbf4320.mp4 49.7 MB
Microsoft Excel- Power Query- Power Pivot - DAX/6. Common DAX Functions/9. Text Functions Video/bihmfe2meheka336agv0.mp4 49.5 MB
Microsoft Excel- Charts - Graphs/5. Next-Level Data Visualization Exercises/8. DEMO- Building a Dynamic Dashboard -Part 2- Video/bih444nf2qij22kstpfg.mp4 49.4 MB
Microsoft Excel- VBA - Macros/4. Referencing Ranges- Worksheets - Workbooks with VBA/5. Copying - Resizing a Variable Range Video/biuui41ujavq7bbf42s0.mp4 48.7 MB
Microsoft Excel- Charts - Graphs/5. Next-Level Data Visualization Exercises/11. DEMO- Building a Custom Pacing Chart Video/bih446imeheka336aagg.mp4 48.7 MB
Microsoft Excel- VBA - Macros/12. Working with Files- Folders - Text Files/3. GetOpenFileName Method- User Selects a File Video/biuv0o9ujavq7bbf43g0.mp4 48.3 MB
Microsoft Excel- Charts - Graphs/5. Next-Level Data Visualization Exercises/5. DEMO- Adding Scroll - Zoom Functionality with Form Controls Video/bih440nf2qij22kstpf0.mp4 48.2 MB
Microsoft Excel- VBA - Macros/2. Your First Excel Macro/3. Visual Basic Editor- What You Need to Know Video/biuufntnkrnfm4n3r9q0.mp4 48.0 MB
Microsoft Excel- VBA - Macros/3. The Object Model/3. VB Color Guidelines - Keyboard Shortcuts Video/biuugh1ujavq7bbf42q0.mp4 47.9 MB
Microsoft Excel- VBA - Macros/6. Looping through Collections - Making Decisions/4. IF Then -Else- ElseIF- for Conditional Outcomes Video/biuurllnkrnfm4n3ra90.mp4 47.3 MB
Microsoft Excel- VBA - Macros/4. Referencing Ranges- Worksheets - Workbooks with VBA/2. Referring to Ranges - Writing to Cells in VBA Video/biuuhllnkrnfm4n3r9tg.mp4 47.2 MB
Microsoft Excel- VBA - Macros/19. Create your own Custom Functions/3. Function to Calculate Age -Result in Years - Months- Video/biuv8stnkrnfm4n3rbg0.mp4 46.9 MB
Excel Pro Tips- Data Visualization/1. Visualization Tips/7. Custom Chart Templates Video/bihtb35nkrnfm4n3lepg.mp4 46.7 MB
Excel MO-201 Exam Prep/4. Manage - Format Data/7. Auto Fill - Flash Fill Video/bummrrmje35bt9ciovt0.mp4 46.7 MB
Microsoft Excel- Charts - Graphs/5. Next-Level Data Visualization Exercises/9. DEMO- Value-Based Dynamic Formatting Video/bih445ameheka336aafg.mp4 46.1 MB
Microsoft Excel- VBA - Macros/6. Looping through Collections - Making Decisions/8. Project- Get the Number of Formulas in a Worksheet Video/biuurttnkrnfm4n3raa0.mp4 45.7 MB
Microsoft Excel- Power Query- Power Pivot - DAX/6. Common DAX Functions/18. Iterator --X-- Functions- RANKX Video/bihmf9ff2qij22ksu0v0.mp4 45.2 MB
Microsoft Excel- Power Query- Power Pivot - DAX/5. Power Pivot - DAX 101/5. Calculated Columns Video/bihme62meheka336agng.mp4 44.9 MB
Microsoft Excel- Power Query- Power Pivot - DAX/5. Power Pivot - DAX 101/11. Step-by-Step Measure Calculation Video/bihmea2meheka336agpg.mp4 44.5 MB
Microsoft Excel- VBA - Macros/19. Create your own Custom Functions/4. Functions that Split Text and Numbers from Cell Value Video/biuv901ujavq7bbf448g.mp4 44.5 MB
Excel Pro Tips- Formatting/1. Formatting Tips/8. Center Across Selection Video/biht5qhujavq7bbeu6n0.mp4 44.5 MB
Microsoft Excel- Charts - Graphs/5. Next-Level Data Visualization Exercises/10. DEMO- Dynamically Highlighting a Data Series Video/bih445qmeheka336aag0.mp4 44.3 MB
Microsoft Excel- VBA - Macros/9. Main Project -1- Create a Tool to Automate Table of Contents -TOC-/2. TOC Project- The Basics Video/biuut9dnkrnfm4n3raj0.mp4 44.1 MB
Microsoft Excel- VBA - Macros/16. Workbook and Worksheet Events/5. Resetting a Dependent Drop-down when the first Drop-down is Changed Video/biuv52dnkrnfm4n3rb6g.mp4 43.7 MB
Microsoft Excel- Pivot Tables - Pivot Charts/7. PivotTable Case Studies/7. Shark Attack Records Video/bih3ctvf2qij22kstoig.mp4 43.5 MB
Microsoft Excel- VBA - Macros/17. Working with Userforms - ActiveX Controls/3. ActiveX Check Box to Fix Scroll Area - Toggle Screen Settings Video/biuv5ipujavq7bbf440g.mp4 43.0 MB
Microsoft Excel- VBA - Macros/12. Working with Files- Folders - Text Files/5. Create CSV File from Data in Excel Video/biuv0vdnkrnfm4n3rasg.mp4 42.7 MB
Microsoft Excel- VBA - Macros/10. Looping in VBA -Controlling the Flow of Code-/8. Find Method with Do Loop - Multiple Matches Video/biuuv1lnkrnfm4n3rapg.mp4 41.9 MB
Microsoft Excel- Formulas - Functions/7. Date - Time Functions/8. WEEKDAY- WORKDAY - NETWORKDAYS Video/bkkeehapeoo9q93dc3cg.mp4 41.5 MB
Microsoft Excel- VBA - Macros/8. Debugging- Error Handling - Procedure Scope/6. Passing Arguments to Sub Procedures -By Ref- By Val- Video/biuut7tnkrnfm4n3raig.mp4 41.3 MB
Microsoft Excel- VBA - Macros/15. Interacting with Other Applications -Word- PowerPoint etc.-/3. Email- Automatically Create Personalized Emails with Attachments Video/biuv42dnkrnfm4n3rb3g.mp4 41.2 MB
Excel Pro Tips- Data Visualization/1. Visualization Tips/3. Hidden Chart Source Data Video/bihtbllnkrnfm4n3leqg.mp4 41.1 MB
Microsoft Excel- Power Query- Power Pivot - DAX/6. Common DAX Functions/8. SWITCH - SWITCH-TRUE- Video/bihmfcimeheka336agu0.mp4 40.9 MB
Excel Pro Tips- Pivot Tables/1. PivotTable Tips/2. Customizing the Field List Video/bihte8lnkrnfm4n3lev0.mp4 40.9 MB
Microsoft Excel- Pivot Tables - Pivot Charts/5. Calculated Values- Fields - Items/9. Show Values As- Index Video/bih36q2meheka336a98g.mp4 40.8 MB
Excel Pro Tips- Formatting/1. Formatting Tips/9. Invisible Text Formatting Video/biht2ndnkrnfm4n3le9g.mp4 39.9 MB
Microsoft Excel- VBA - Macros/6. Looping through Collections - Making Decisions/2. With - End With for Easier Code Writing Video/biuurb5nkrnfm4n3ra8g.mp4 34.7 MB
Microsoft Excel- VBA - Macros/10. Looping in VBA -Controlling the Flow of Code-/2. For Next Counter Loops Video/biuuu9pujavq7bbf4390.mp4 34.6 MB
Microsoft Excel- Power Query- Power Pivot - DAX/2. Intro to -Power Excel-/2. -The Best Thing to Happen to Excel in 20 Years- Video/bihmd1vf2qij22ksu0eg.mp4 34.5 MB
Microsoft Excel- Charts - Graphs/5. Next-Level Data Visualization Exercises/12. DEMO- Designing a Custom Gauge Chart Video/bih447ameheka336aah0.mp4 34.2 MB
Excel Pro Tips- Formatting/1. Formatting Tips/1. Introduction Video/biht2qhujavq7bbeu6i0.mp4 34.1 MB
Microsoft Excel- Power Query- Power Pivot - DAX/6. Common DAX Functions/12. Adding Filter Context with Filter -Part 1- Video/bihmejameheka336agqg.mp4 33.9 MB
Microsoft Excel- Pivot Tables - Pivot Charts/5. Calculated Values- Fields - Items/13. PRO TIP- Calculating Using Counts -Part 1- Video/bih36rqmeheka336a990.mp4 33.9 MB
Excel MO-201 Exam Prep/2. The Course Project/2. The Airbnb Dataset Video/buhgeg3i57dcbr63pkv0.mp4 33.4 MB
Microsoft Excel- VBA - Macros/7. Useful Built-in Functions/2. Most Useful VBA Functions Video/biuus4tnkrnfm4n3rac0.mp4 33.0 MB
Microsoft Excel- VBA - Macros/10. Looping in VBA -Controlling the Flow of Code-/1. Overview- Looping in VBA Video/biuuu7dnkrnfm4n3ram0.mp4 32.7 MB
Excel Pro Tips- Formatting/1. Formatting Tips/3. Snap to Grid Video/biht2ipujavq7bbeu6h0.mp4 31.2 MB
Microsoft Excel- VBA - Macros/12. Working with Files- Folders - Text Files/1. Overview- Working with Folders - Files Video/biuv0i9ujavq7bbf43eg.mp4 31.0 MB
Microsoft Excel- VBA - Macros/10. Looping in VBA -Controlling the Flow of Code-/9. Add a Timer to Test - Speech to Inform Video/biuuv3pujavq7bbf43bg.mp4 30.8 MB
Microsoft Excel- VBA - Macros/12. Working with Files- Folders - Text Files/2. DIR Function- Check if Files or Folders Exist Video/biuv0l9ujavq7bbf43f0.mp4 30.5 MB
Microsoft Excel- Power Query- Power Pivot - DAX/3. Power Query/15. Merging Queries Video/bihmdgqmeheka336agg0.mp4 30.1 MB
Microsoft Excel- Power Query- Power Pivot - DAX/3. Power Query/13. Pivoting - Unpivoting Video/bihmdi7f2qij22ksu0i0.mp4 29.9 MB
Excel MO-201 Exam Prep/4. Manage - Format Data/8. Advanced Fill Series Options Video/bumms36je35bt9ciovu0.mp4 29.8 MB
Microsoft Excel- Pivot Tables - Pivot Charts/2. PivotTable 101/5. Navigating the Field List Video/bih31cimeheka336a8u0.mp4 29.7 MB
Microsoft Excel- Charts - Graphs/5. Next-Level Data Visualization Exercises/2. DEMO- Custom Image Overlay Charts Video/bm4lsqal9tga33sbd9rg.mp4 29.6 MB
Excel MO-201 Exam Prep/6. Workbook Options - Settings/4. Linking Data Across Workbooks Video/bun7b2ji57dcbr646pag.mp4 29.5 MB
Microsoft Excel- VBA - Macros/15. Interacting with Other Applications -Word- PowerPoint etc.-/1. Overview- Interacting with Other Applications Video/biuv3rpujavq7bbf43pg.mp4 29.5 MB
Microsoft Excel- VBA - Macros/6. Looping through Collections - Making Decisions/6. Goto Statement to Change Program Flow Video/biuurotnkrnfm4n3ra9g.mp4 29.4 MB
Microsoft Excel- VBA - Macros/3. The Object Model/4. Excel VBA Object Model Video/biuugjdnkrnfm4n3r9rg.mp4 27.9 MB
Microsoft Excel- VBA - Macros/17. Working with Userforms - ActiveX Controls/2. ActiveX Controls- What you Need to Know Video/biuv5g1ujavq7bbf4400.mp4 27.8 MB
Microsoft Excel- Formulas - Functions/9. Array Formulas/13. -MAX IF- with Multiple Criteria Video/bif3147f2qij22kssrpg.mp4 27.6 MB
Microsoft Excel- VBA - Macros/11. Working with Arrays/4. Preserving Dynamic Arrays Video/biuv045nkrnfm4n3rarg.mp4 27.3 MB
Microsoft Excel- Charts - Graphs/5. Next-Level Data Visualization Exercises/13. DEMO- Visualizing a Percentage Using Array Functions Video/bih447vf2qij22kstpg0.mp4 27.0 MB
Microsoft Excel- Formulas - Functions/2. Excel Formulas 101/11. Congrats- You-re a Developer- Video/bk3rl65nkrnfm4n4ca10.mp4 26.9 MB
Microsoft Excel- Power Query- Power Pivot - DAX/5. Power Pivot - DAX 101/9. Creating Explicit Measures -Power Pivot- Video/bihme7ameheka336agog.mp4 26.4 MB
Microsoft Excel- Power Query- Power Pivot - DAX/3. Power Query/12. Grouping - Aggregating Data Video/bihmdf7f2qij22ksu0gg.mp4 26.3 MB
Microsoft Excel- VBA - Macros/19. Create your own Custom Functions/2. Setting up a Simple Function -including Optional Arguments- Video/biuv8q5nkrnfm4n3rbfg.mp4 26.3 MB
Microsoft Excel- Charts - Graphs/5. Next-Level Data Visualization Exercises/4. DEMO- Automation with OFFSET- COUNTA - Named Ranges Video/bih4402meheka336aae0.mp4 25.7 MB
Microsoft Excel- VBA - Macros/9. Main Project -1- Create a Tool to Automate Table of Contents -TOC-/6. TOC Project- Adding to Personal Macro Workbook Video/biuutk1ujavq7bbf4360.mp4 25.5 MB
Microsoft Excel- VBA - Macros/9. Main Project -1- Create a Tool to Automate Table of Contents -TOC-/3. TOC Project- Adding Hyperlinks Video/biuut4dnkrnfm4n3rahg.mp4 25.3 MB
Microsoft Excel- Pivot Tables - Pivot Charts/6. Pivot Charts/7. Pivot Chart Demo- Stacked Area Chart Video/bih3b1nf2qij22kstogg.mp4 24.4 MB
Microsoft Excel- Power Query- Power Pivot - DAX/5. Power Pivot - DAX 101/8. Creating Explicit Measured -AutoSum- Video/bihme5ff2qij22ksu0lg.mp4 24.4 MB
Microsoft Excel- Power Query- Power Pivot - DAX/6. Common DAX Functions/20. Basic Date - Time Functions Video/bihmeivf2qij22ksu0rg.mp4 24.3 MB
Microsoft Excel- VBA - Macros/14. Main Project -2- Sales Regional Reporting Tool/1. What You-ll Learn in this Project Video/biuv2a1ujavq7bbf43ig.mp4 24.1 MB
Microsoft Excel- Power Query- Power Pivot - DAX/4. Data Modeling 101/7. Creating Table Relationships Video/bihmdvameheka336agjg.mp4 24.1 MB
Microsoft Excel- VBA - Macros/3. The Object Model/2. VBA-s Code Reference Object Library Video/biuuge1ujavq7bbf42pg.mp4 22.8 MB
Microsoft Excel- Formulas - Functions/7. Date - Time Functions/10. DEMO- Designing a Sample Budget Pacing Tool Video/bif30eimeheka3369dk0.mp4 22.7 MB
Microsoft Excel- VBA - Macros/9. Main Project -1- Create a Tool to Automate Table of Contents -TOC-/4. TOC Project- Testing the VBA Code Video/biuusutnkrnfm4n3rafg.mp4 22.7 MB
Microsoft Excel- Formulas - Functions/10. Bonus Functions/2. The INDIRECT Function Video/bif31cameheka3369dpg.mp4 22.6 MB
Microsoft Excel- Pivot Tables - Pivot Charts/5. Calculated Values- Fields - Items/15. Inserting a Calculated Item -use with caution-- Video/bih36snf2qij22kstocg.mp4 22.4 MB
Microsoft Excel- VBA - Macros/8. Debugging- Error Handling - Procedure Scope/5. Procedure Scope - Running one Sub from Another Video/biuut3hujavq7bbf435g.mp4 22.3 MB
Microsoft Excel- VBA - Macros/5. Working with Variables/2. Data Types for Better Performance Video/biuuqqtnkrnfm4n3ra6g.mp4 21.6 MB
Microsoft Excel- Charts - Graphs/3. Customizing Charts in Excel/1. Chart Elements- Layouts- Colors - Styles Video/bih3qo2meheka336a9vg.mp4 21.4 MB
Microsoft Excel- VBA - Macros/16. Workbook and Worksheet Events/3. Worksheet Selection Change- Dynamic Font Color of Selected Range Video/biuv4q1ujavq7bbf43sg.mp4 21.3 MB
Microsoft Excel- Pivot Tables - Pivot Charts/6. Pivot Charts/3. Pivot Chart Demo- Pie - Donut Charts Video/bih3avqmeheka336a9d0.mp4 21.2 MB
Microsoft Excel- VBA - Macros/6. Looping through Collections - Making Decisions/1. Overview- Why Collections are a VBA Essential Video/biuur8dnkrnfm4n3ra80.mp4 20.3 MB
Microsoft Excel- Pivot Tables - Pivot Charts/2. PivotTable 101/3. Inserting Your First PivotTable Video/bih31bqmeheka336a8tg.mp4 20.2 MB
Microsoft Excel- Charts - Graphs/4. Mastering Basic Charts - Graphs/16. Tree Maps - Sunburst Charts -Office 365-2016-- Video/bih3s7imeheka336aa4g.mp4 20.2 MB
Microsoft Excel- Pivot Tables - Pivot Charts/5. Calculated Values- Fields - Items/14. PRO TIP- Calculating Using Counts -Part 2- Video/bih36sameheka336a99g.mp4 19.8 MB
Microsoft Excel- Pivot Tables - Pivot Charts/5. Calculated Values- Fields - Items/12. Calculations in Pivots vs. Raw Data Video/bih36rff2qij22kstoc0.mp4 19.7 MB
Microsoft Excel- Pivot Tables - Pivot Charts/5. Calculated Values- Fields - Items/16. The Solve Order - List Formulas Tools Video/bih36t2meheka336a9a0.mp4 19.6 MB
Microsoft Excel- Pivot Tables - Pivot Charts/5. Calculated Values- Fields - Items/6. Show Values As- Difference From Video/bih36oqmeheka336a980.mp4 19.5 MB
Microsoft Excel- Pivot Tables - Pivot Charts/6. Pivot Charts/10. Applying Slicers - Timelines to Multiple Charts Video/bih3b37f2qij22kstoh0.mp4 19.4 MB
Microsoft Excel- VBA - Macros/11. Working with Arrays/1. Overview- Working with Arrays in VBA Video/biuuvstnkrnfm4n3raq0.mp4 19.3 MB
Microsoft Excel- VBA - Macros/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
Microsoft Excel- VBA - Macros/1. Course Intro/3. Getting to Know the Project Files Video/biuuf2tnkrnfm4n3r9og.mp4 19.2 MB
Microsoft Excel- Power Query- Power Pivot - DAX/4. Data Modeling 101/10. Relationship Cardinality Video/bihmduqmeheka336agj0.mp4 19.1 MB
Microsoft Excel- Pivot Tables - Pivot Charts/4. Sorting- Filtering - Grouping/9. Using Slicers - Timelines to Filter Data Video/bih351ameheka336a940.mp4 19.1 MB
Microsoft Excel- VBA - Macros/17. Working with Userforms - ActiveX Controls/1. Overview- UserForms - ActiveX Controls Video/biuv5e5nkrnfm4n3rb70.mp4 19.0 MB
Microsoft Excel- Power Query- Power Pivot - DAX/7. Wrapping Up/3. Sneak Peek- Power BI Video/bihmepff2qij22ksu0tg.mp4 19.0 MB
Microsoft Excel- Formulas - Functions/5. Lookup-Reference Functions/19. DEMO- Using OFFSET to Create a Dynamic Scrolling Chart Video/bif2vkameheka3369dh0.mp4 18.7 MB
Microsoft Excel- Charts - Graphs/4. Mastering Basic Charts - Graphs/29. Geo-Spatial Maps with Power Map Video/bih3scameheka336aa6g.mp4 18.7 MB
Microsoft Excel- Formulas - Functions/4. Statistical Functions/8. DEMO- Building a Basic Dashboard Video/bif2ttameheka3369d40.mp4 18.6 MB
Microsoft Excel- VBA - Macros/3. The Object Model/8. Conclusion- Key Takeaways Video/biuugtdnkrnfm4n3r9t0.mp4 18.5 MB
Microsoft Excel- VBA - Macros/19. Create your own Custom Functions/1. Overview- Function Procedures Video/biuv8npujavq7bbf4480.mp4 18.5 MB
Microsoft Excel- Formulas - Functions/5. Lookup-Reference Functions/6. Fixing Errors with IFERROR - VLOOKUP Video/bif2utameheka3369ddg.mp4 18.3 MB
Microsoft Excel- Formulas - Functions/8. Formula-Based Formatting/5. Formatting Cells Using Statistical Functions Video/bif30kameheka3369dl0.mp4 17.7 MB
Microsoft Excel- Power Query- Power Pivot - DAX/1. Course Intro/1. Course Structure - Outline Video/bjcse39ujavq7bbf9gmg.mp4 17.7 MB
Microsoft Excel- VBA - Macros/12. Working with Files- Folders - Text Files/6. Printing - Writing to Text Files for More Control Video/biuv10lnkrnfm4n3rat0.mp4 17.6 MB
Microsoft Excel- Power Query- Power Pivot - DAX/3. Power Query/10. PRO TIP- Creating a Rolling Calendar Video/bihmdivf2qij22ksu0ig.mp4 17.4 MB
Microsoft Excel- Power Query- Power Pivot - DAX/4. Data Modeling 101/12. Filter Direction Video/bihme0ameheka336agk0.mp4 17.3 MB
Microsoft Excel- Charts - Graphs/3. Customizing Charts in Excel/2. Chart Formatting Options Video/bih3qpff2qij22kstp00.mp4 17.1 MB
Microsoft Excel- Pivot Tables - Pivot Charts/5. Calculated Values- Fields - Items/4. Show Values As- % of Column-Row Video/bih36mqmeheka336a970.mp4 17.1 MB
Microsoft Excel- Pivot Tables - Pivot Charts/6. Pivot Charts/5. PRO TIP- Prevent Charts from Resizing with Cells Video/bih3b0nf2qij22kstofg.mp4 17.1 MB
Microsoft Excel- Charts - Graphs/5. Next-Level Data Visualization Exercises/3. DEMO- Adding Binary Values to Highlight Date Ranges Video/bih43vimeheka336aadg.mp4 17.0 MB
Microsoft Excel- Pivot Tables - Pivot Charts/4. Sorting- Filtering - Grouping/7. Grouping Data Video/bih350ff2qij22ksto80.mp4 16.7 MB
Microsoft Excel- VBA - Macros/10. Looping in VBA -Controlling the Flow of Code-/12. Key Takeaways- Looping in VBA Video/biuuu55nkrnfm4n3ralg.mp4 16.6 MB
Microsoft Excel- Formulas - Functions/9. Array Formulas/14. Using the Double Unary Operator ------ Video/bif3197f2qij22kssrqg.mp4 16.5 MB
Microsoft Excel- VBA - Macros/10. Looping in VBA -Controlling the Flow of Code-/6. Practical Example of Do Loop -with Inputbox- Video/biuuur5nkrnfm4n3raog.mp4 15.8 MB
Microsoft Excel- Formulas - Functions/3. Conditional - Logical Operators/6. Fixing Errors with IFERROR Video/bif2ueimeheka3369d8g.mp4 14.3 MB
Excel MO-201 Exam Prep/3. Advanced Formulas - Macros/15. The TODAY - NOW Functions Video/buhggueje35bt9cid330.mp4 14.3 MB
Microsoft Excel- Pivot Tables - Pivot Charts/4. Sorting- Filtering - Grouping/5. Value Filters Video/bih34vameheka336a930.mp4 14.2 MB
Microsoft Excel- Formulas - Functions/6. Text Functions/3. The CONCATENATE Function --- Video/bif2vlnf2qij22kssrgg.mp4 14.2 MB
Microsoft Excel- VBA - Macros/6. Looping through Collections - Making Decisions/5. Select Case as Alternative for Many IF Statements Video/biuurmpujavq7bbf432g.mp4 14.2 MB
Microsoft Excel- Power Query- Power Pivot - DAX/7. Wrapping Up/2. Data Visualization Options Video/bihmeoff2qij22ksu0t0.mp4 14.1 MB
Microsoft Excel- Charts - Graphs/3. Customizing Charts in Excel/4. Creating- Modifying - Applying Custom Templates Video/bih3qq2meheka336aa00.mp4 14.0 MB
Excel MO-201 Exam Prep/7. Practice Test/3. Practice Test Structure Video/buqc4p6je35bt9cj1e5g.mp4 14.0 MB
Microsoft Excel- Formulas - Functions/6. Text Functions/9. SUBSTITUTE Video/bif2vv2meheka3369dig.mp4 13.6 MB
Microsoft Excel- Pivot Tables - Pivot Charts/5. Calculated Values- Fields - Items/5. Show Values As- % of Parent Video/bih36nameheka336a97g.mp4 12.2 MB
Microsoft Excel- Formulas - Functions/3. Conditional - Logical Operators/3. Nested IF Statements Video/bif2ufimeheka3369d9g.mp4 12.1 MB
Excel MO-201 Exam Prep/3. Advanced Formulas - Macros/24. The MATCH Function Video/bummndeje35bt9ciovfg.mp4 12.1 MB
Microsoft Excel- Power Query- Power Pivot - DAX/3. Power Query/3. The Query Editor Video/bihmdjvf2qij22ksu0j0.mp4 11.9 MB
Microsoft Excel- Formulas - Functions/10. Bonus Functions/3. The HYPERLINK Function Video/bif31e7f2qij22kssrr0.mp4 11.8 MB
Microsoft Excel- Pivot Tables - Pivot Charts/3. PivotTable Formatting/4. PRO TIP- Using Tabular Tables to Create New Source Data Video/bih33gff2qij22ksto5g.mp4 11.8 MB
Microsoft Excel- Pivot Tables - Pivot Charts/6. Pivot Charts/6. Changing Chart Types on the Fly Video/bih3b17f2qij22kstog0.mp4 11.8 MB
Microsoft Excel- VBA - Macros/5. Working with Variables/7. Key Takeaways- Working with Variables Video/biuur4dnkrnfm4n3ra7g.mp4 11.6 MB
Microsoft Excel- Pivot Tables - Pivot Charts/4. Sorting- Filtering - Grouping/2. PRO TIP- Incorrect Alphabetical Sorting Video/bih34tvf2qij22ksto6g.mp4 11.6 MB
Microsoft Excel- Pivot Tables - Pivot Charts/5. Calculated Values- Fields - Items/7. Show Values As- Running Total Video/bih36p7f2qij22kstoag.mp4 11.5 MB
Microsoft Excel- Formulas - Functions/8. Formula-Based Formatting/3. Highlighting Every Other Row Using the MOD Function Video/bif30inf2qij22kssrmg.mp4 11.4 MB
Microsoft Excel- Formulas - Functions/9. Array Formulas/5. Vertical- Horizontal- and 2-Dimensional Array Constants Video/bif30q2meheka3369dmg.mp4 11.3 MB
Microsoft Excel- Formulas - Functions/7. Date - Time Functions/6. The EOMONTH Function Video/bif300nf2qij22kssrig.mp4 11.3 MB
Microsoft Excel- Formulas - Functions/3. Conditional - Logical Operators/2. Anatomy of the IF Statement Video/bif2ugimeheka3369da0.mp4 11.2 MB
Microsoft Excel- Pivot Tables - Pivot Charts/5. Calculated Values- Fields - Items/8. Show Values As- Rank Video/bih36pnf2qij22kstob0.mp4 11.0 MB
Microsoft Excel- Formulas - Functions/9. Array Formulas/7. Named Array Constants Video/bif30s2meheka3369dng.mp4 8.6 MB
Microsoft Excel- Formulas - Functions/8. Formula-Based Formatting/4. Formatting Cells Based on the Value of Another Cell Video/bif30lff2qij22kssrn0.mp4 8.5 MB
Microsoft Excel- Formulas - Functions/3. Conditional - Logical Operators/5. NOT vs. ---- Video/bif2u9nf2qij22kssr90.mp4 8.4 MB
Microsoft Excel- Formulas - Functions/7. Date - Time Functions/9. The DATEDIF Function Video/bif30c2meheka3369djg.mp4 8.3 MB
Microsoft Excel- Formulas - Functions/9. Array Formulas/10. Returning the -X- Largest Values in a Range Video/bif30u7f2qij22kssrog.mp4 8.3 MB
Microsoft Excel- Pivot Tables - Pivot Charts/2. PivotTable 101/2. Structuring Your Source Data Video/bih31bnf2qij22ksto20.mp4 8.3 MB
Microsoft Excel- Formulas - Functions/5. Lookup-Reference Functions/2. Working with Named Arrays Video/bif2upimeheka3369dc0.mp4 8.0 MB
Microsoft Excel- Power Query- Power Pivot - DAX/4. Data Modeling 101/6. Relationships vs. Merged Tables Video/bihme3nf2qij22ksu0l0.mp4 7.8 MB
Maven Analytics - DATA PLAYGROUND (Test & Work Assignment) /S&P 500 Stock Prices/S&P+500+Stock+Prices+2014-2017.csv.zip 7.7 MB
Microsoft Excel- Power Query- Power Pivot - DAX/5. Power Pivot - DAX 101/12. RECAP- Calculated Columns vs. Measures Video/bihme6ff2qij22ksu0mg.mp4 7.7 MB
Microsoft Excel- Formulas - Functions/4. Statistical Functions/5. The SUMPRODUCT Function Video/bif2um7f2qij22kssrcg.mp4 7.6 MB
Microsoft Excel- Power Query- Power Pivot - DAX/5. Power Pivot - DAX 101/6. Intro to DAX Measures Video/bihme8vf2qij22ksu0p0.mp4 7.6 MB
Microsoft Excel- Power Query- Power Pivot - DAX/7. Wrapping Up/1. Introduction Video/bihmeoqmeheka336agrg.mp4 7.5 MB
Microsoft Excel- Charts - Graphs/2. Data Visualization Best Practices/1. Key Data Viz Principles - the 10-Second Rule Video/bih3q22meheka336a9t0.mp4 7.2 MB
Microsoft Excel- Power Query- Power Pivot - DAX/1. Course Intro/4.DOWNLOAD%3a Course Resources/PowerQuery_PowerPivot__DAX-1560900590898.pdf 7.0 MB
Microsoft Excel- Formulas - Functions/9. Array Formulas/9. Linking Data Between Sheets- Array vs. Non-Array Comparison Video/bif30t7f2qij22kssro0.mp4 7.0 MB
Microsoft Excel- Pivot Tables - Pivot Charts/7. PivotTable Case Studies/1. Setting Expectations Video/bih3cr2meheka336a9eg.mp4 7.0 MB
Microsoft Excel- Power Query- Power Pivot - DAX/5. Power Pivot - DAX 101/4. Intro to Data Analysis Expressions -DAX- Video/bihme6nf2qij22ksu0n0.mp4 4.2 MB
Microsoft Excel- Formulas - Functions/9. Array Formulas/4. Pros - Cons of Array Functions Video/bif3162meheka3369dp0.mp4 4.1 MB
Microsoft Excel- Power Query- Power Pivot - DAX/2. Intro to -Power Excel-/3. When to use Power Query - Power Pivot Video/bihmd2imeheka336agd0.mp4 2.4 MB
Maven Analytics - DATA PLAYGROUND (Test & Work Assignment) /Spotify Top 100/top2018.csv.zip 7.5 KB
Microsoft Excel- Power Query- Power Pivot - DAX/3. Power Query/20. HOMEWORK- Power Query Text/HOMEWORK- Power Query.html 4.9 KB
Microsoft Excel- Power Query- Power Pivot - DAX/9. Final Assessment - Next Steps/3. Next Steps Text/Next Steps.html 4.6 KB
Microsoft Excel- Charts - Graphs/7. Final Assessment - Next Steps/3. Next Steps Text/Next Steps.html 4.4 KB
Microsoft Excel- Pivot Tables - Pivot Charts/9. Final Assessment - Next Steps/3. Next Steps Text/Next Steps.html 4.4 KB
Microsoft Excel- Power Query- Power Pivot - DAX/5. Power Pivot - DAX 101/15. HOMEWORK- Power Pivot - DAX 101 Text/HOMEWORK- Power Pivot - DAX 101.html 4.4 KB
Excel Pro Tips- Data Visualization/2. Next Steps/3. Next Steps Text/Next Steps.html 4.3 KB
Microsoft Excel- Pivot Tables - Pivot Charts/7. PivotTable Case Studies/20. HOMEWORK- Apple App Data Text/HOMEWORK- Apple App Data.html 4.2 KB
Excel Pro Tips- Formatting/2. Next Steps/3. Next Steps Text/Next Steps.html 4.2 KB
Excel Pro Tips- Pivot Tables/2. Next Steps/3. Next Steps Text/Next Steps.html 4.2 KB
Excel Pro Tips- Analytics/2. Next Steps/3. Next Steps Text/Next Steps.html 4.2 KB
Microsoft Excel- Power Query- Power Pivot - DAX/6. Common DAX Functions/15. HOMEWORK- CALCULATE- FILTER - ALL Text/HOMEWORK- CALCULATE- FILTER - ALL.html 4.2 KB
Microsoft Excel- Formulas - Functions/12. Final Assessment - Next Steps/3. Next Steps Text/Next Steps.html 4.1 KB
Excel Pro Tips- Productivity/2. Next Steps/3. Next Steps Text/Next Steps.html 3.9 KB
Excel Pro Tips- Formulas/2. Next Steps/3. Next Steps Text/Next Steps.html 3.9 KB
Microsoft Excel- Power Query- Power Pivot - DAX/6. Common DAX Functions/6. HOMEWORK- Math - Stats Functions Text/HOMEWORK- Math - Stats Functions.html 3.9 KB
Microsoft Excel- Power Query- Power Pivot - DAX/6. Common DAX Functions/10. HOMEWORK- Logical - Text Functions Text/HOMEWORK- Logical - Text Functions.html 3.7 KB
Microsoft Excel- Pivot Tables - Pivot Charts/7. PivotTable Case Studies/22. HOMEWORK- Wine Tasting Scores Text/HOMEWORK- Wine Tasting Scores.html 3.5 KB
Microsoft Excel- Power Query- Power Pivot - DAX/4. Data Modeling 101/17. HOMEWORK- Data Modeling 101 Text/HOMEWORK- Data Modeling 101.html 3.4 KB
Microsoft Excel- Power Query- Power Pivot - DAX/6. Common DAX Functions/22. HOMEWORK- Time Intelligence Text/HOMEWORK- Time Intelligence.html 3.3 KB
Microsoft Excel- Charts - Graphs/0. Orientation - Benchmark Assessment/1. Welcome to the Course- Text/Welcome to the Course-.html 3.2 KB
Microsoft Excel- Pivot Tables - Pivot Charts/7. PivotTable Case Studies/12. HOMEWORK- Baseball Team Stats Text/HOMEWORK- Baseball Team Stats.html 3.1 KB
Microsoft Excel- Pivot Tables - Pivot Charts/7. PivotTable Case Studies/8. HOMEWORK- Shark Attack Records Text/HOMEWORK- Shark Attack Records.html 3.1 KB
Microsoft Excel- Power Query- Power Pivot - DAX/0. Orientation - Benchmark Assessment/1. Welcome to the Course- Text/Welcome to the Course-.html 3.0 KB
Microsoft Excel- VBA - Macros/0. Orientation - Benchmark Assessment/1. Welcome to the Course- Text/Welcome to the Course-.html 3.0 KB
Microsoft Excel- Pivot Tables - Pivot Charts/0. Orientation - Benchmark Assessment/1. Welcome to the Course- Text/Welcome to the Course-.html 3.0 KB
Microsoft Excel- Formulas - Functions/0. Orientation - Benchmark Assessment/1. Welcome to the Course- Text/Welcome to the Course-.html 2.9 KB
Microsoft Excel- Pivot Tables - Pivot Charts/7. PivotTable Case Studies/14. HOMEWORK- San Diego Burrito Ratings Text/HOMEWORK- San Diego Burrito Ratings.html 2.8 KB
Microsoft Excel- Pivot Tables - Pivot Charts/7. PivotTable Case Studies/4. HOMEWORK- U.S. Voters -2012- Text/HOMEWORK- U.S. Voters -2012-.html 2.8 KB
Microsoft Excel- Power Query- Power Pivot - DAX/6. Common DAX Functions/19. HOMEWORK- Iterator Functions Text/HOMEWORK- Iterator Functions.html 2.8 KB
Microsoft Excel- Power Query- Power Pivot - DAX/3. Power Query/5. IMPORTANT- Updating Locale Settings Text/IMPORTANT- Updating Locale Settings.html 2.6 KB
Microsoft Excel- Pivot Tables - Pivot Charts/7. PivotTable Case Studies/16. HOMEWORK- Daily Weather Conditions Text/HOMEWORK- Daily Weather Conditions.html 2.4 KB
Microsoft Excel- Pivot Tables - Pivot Charts/7. PivotTable Case Studies/6. HOMEWORK- San Francisco Salaries Text/HOMEWORK- San Francisco Salaries.html 2.2 KB
Microsoft Excel- Formulas - Functions/9. Array Formulas/2. READ ME- Array Formulas are Changing- Text/READ ME- Array Formulas are Changing-.html 1.9 KB
Microsoft Excel- Pivot Tables - Pivot Charts/7. PivotTable Case Studies/10. HOMEWORK- Stock Market Data Text/HOMEWORK- Stock Market Data.html 1.9 KB
Microsoft Excel- VBA - Macros/2. Your First Excel Macro/9. What-s the Difference Between Macros and VBA- Text/What-s the Difference Between Macros and VBA-.html 1.9 KB
Microsoft Excel- VBA - Macros/4. Referencing Ranges- Worksheets - Workbooks with VBA/8. Activity- Save a Hard-coded Copy of Workbook Text/Activity- Save a Hard-coded Copy of Workbook.html 1.8 KB
Microsoft Excel- VBA - Macros/7. Useful Built-in Functions/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
Microsoft Excel- VBA - Macros/2. Your First Excel Macro/7. OFFICE 365 Update- Comments - Notes Text/OFFICE 365 Update- Comments - Notes.html 1.4 KB
Microsoft Excel- VBA - Macros/10. Looping in VBA -Controlling the Flow of Code-/10. Activity- Document all Comments in Workbook in a Sheet Text/Activity- Document all Comments in Workbook in a Sheet.html 1.2 KB
Microsoft Excel- Pivot Tables - Pivot Charts/2. PivotTable 101/4. IMPORTANT- Add to Data Model Text/IMPORTANT- Add to Data Model.html 1.2 KB
Microsoft Excel- Pivot Tables - Pivot Charts/5. Calculated Values- Fields - Items/10. KNOWLEDGE CHECK- Show Values As Text/KNOWLEDGE CHECK- Show Values As.html 1.1 KB
Microsoft Excel- Charts - Graphs/4. Mastering Basic Charts - Graphs/17. HOMEWORK- Tree Maps - Sunburst Charts Text/HOMEWORK- Tree Maps - Sunburst Charts.html 1.1 KB
Microsoft Excel- Charts - Graphs/4. Mastering Basic Charts - Graphs/8. HOMEWORK- Area Charts Text/HOMEWORK- Area Charts.html 1.1 KB
Microsoft Excel- VBA - Macros/11. Working with Arrays/7. Activity- Create a New Worksheet per Company with Specific Information Text/Activity- Create a New Worksheet per Company with Specific Information.html 1010 bytes
Microsoft Excel- VBA - Macros/8. Debugging- Error Handling - Procedure Scope/7. Activity- Number of Formulas -or Comments- Used in a Workbook Text/Activity- Number of Formulas -or Comments- Used in a Workbook.html 991 bytes
Microsoft Excel- VBA - Macros/13. Excel Tables- Formulas - Pivot Tables/5. Activity- Update Existing Formulas with VBA by Adding IFERROR Text/Activity- Update Existing Formulas with VBA by Adding IFERROR.html 984 bytes
Microsoft Excel- Charts - Graphs/4. Mastering Basic Charts - Graphs/6. HOMEWORK- Line Charts - Trendlines Text/HOMEWORK- Line Charts - Trendlines.html 970 bytes
Microsoft Excel- VBA - Macros/2. Your First Excel Macro/8. Activity- Record a Macro that Deletes all Comments Text/Activity- Record a Macro that Deletes all Comments.html 901 bytes
Microsoft Excel- VBA - Macros/16. Workbook and Worksheet Events/6. Activity- Link Page Header to Cell Value -BeforePrint Event- Text/Activity- Link Page Header to Cell Value -BeforePrint Event-.html 897 bytes
Microsoft Excel- VBA - Macros/12. Working with Files- Folders - Text Files/7. Activity- Export Data to Text file Text/Activity- Export Data to Text file.html 863 bytes
Microsoft Excel- VBA - Macros/17. Working with Userforms - ActiveX Controls/11. UserForm Checklist - Course Map Status Text/UserForm Checklist - Course Map Status.html 848 bytes
Microsoft Excel- VBA - Macros/19. Create your own Custom Functions/6. Activity- Function That Sums based on Cell Color Text/Activity- Function That Sums based on Cell Color.html 818 bytes
Microsoft Excel- VBA - Macros/6. Looping through Collections - Making Decisions/7. Activity- Get the Number of Formulas in a Worksheet Text/Activity- Get the Number of Formulas in a Worksheet.html 774 bytes
Microsoft Excel- Power Query- Power Pivot - DAX/2. Intro to -Power Excel-/5. HOMEWORK- Intro to -Power Excel- Text/HOMEWORK- Intro to -Power Excel-.html 770 bytes
Microsoft Excel- Charts - Graphs/4. Mastering Basic Charts - Graphs/30. HOMEWORK- Power Map Text/HOMEWORK- Power Map.html 719 bytes
Microsoft Excel- VBA - Macros/9. Main Project -1- Create a Tool to Automate Table of Contents -TOC-/7. First Milestone Completed- Text/First Milestone Completed-.html 703 bytes
Microsoft Excel- VBA - Macros/19. Create your own Custom Functions/8. Key Takeaways- Function Procedures in VBA Text/Key Takeaways- Function Procedures in VBA.html 650 bytes
Microsoft Excel- VBA - Macros/20. Working with Charts/5. Key Takeaways- VBA Charts Text/Key Takeaways- VBA Charts.html 641 bytes
Microsoft Excel- VBA - Macros/18. Main Project -3- Invoice Generation Tool/11. Last Milestone Completed- Text/Last Milestone Completed-.html 618 bytes
Microsoft Excel- VBA - Macros/11. Working with Arrays/9. Key Takeaways- Arrays Text/Key Takeaways- Arrays.html 607 bytes
Microsoft Excel- VBA - Macros/15. Interacting with Other Applications -Word- PowerPoint etc.-/6. Key Takeaways- Working with Other Applications Text/Key Takeaways- Working with Other Applications.html 594 bytes
Microsoft Excel- VBA - Macros/6. Looping through Collections - Making Decisions/10. Key Takeaways- Collections - Decision Making in VBA Text/Key Takeaways- Collections - Decision Making in VBA.html 586 bytes
Microsoft Excel- VBA - Macros/14. Main Project -2- Sales Regional Reporting Tool/11. Second Milestone Completed- Text/Second Milestone Completed-.html 360 bytes
Excel MO-201 Exam Prep/8. Feedback Survey - Next Steps/2. Share the love- Text/Share the love-.html 152 bytes
Excel Pro Tips- Analytics/2. Next Steps/2. Share the love- Text/Share the love-.html 152 bytes
Excel Pro Tips- Data Visualization/2. Next Steps/2. Share the love- Text/Share the love-.html 152 bytes
Excel Pro Tips- Formatting/2. Next Steps/2. Share the love- Text/Share the love-.html 152 bytes
Excel Pro Tips- Formulas/2. Next Steps/2. Share the love- Text/Share the love-.html 152 bytes
Excel Pro Tips- Pivot Tables/2. Next Steps/2. Share the love- Text/Share the love-.html 152 bytes
Excel Pro Tips- Productivity/2. Next Steps/2. Share the love- Text/Share the love-.html 152 bytes
Microsoft Excel- Charts - Graphs/7. Final Assessment - Next Steps/2. Share the love- Text/Share the love-.html 152 bytes
Microsoft Excel- Formulas - Functions/12. Final Assessment - Next Steps/2. Share the love- Text/Share the love-.html 152 bytes
Microsoft Excel- Pivot Tables - Pivot Charts/9. Final Assessment - Next Steps/2. Share the love- Text/Share the love-.html 152 bytes
Microsoft Excel- Power Query- Power Pivot - DAX/9. Final Assessment - Next Steps/2. Share the love- Text/Share the love-.html 152 bytes
Microsoft Excel- VBA - Macros/22. Final Assessment - Next Steps/2. Share the love- Text/Share the love-.html 152 bytes
Microsoft Excel- Pivot Tables - Pivot Charts/2. PivotTable 101/10. PRO TIP- Dealing with Growing Source Data Video/0.original.mp4 0 bytes