Other
[Maven Analytics] Excel Courses (2021) [En]
Torrent info
Torrent Files List
Microsoft Excel- Pivot Tables - Pivot Charts (Size: 27.65 GB) (Files: 785)
Microsoft Excel- Pivot Tables - Pivot Charts
2. PivotTable 101
10. PRO TIP- Dealing with Growing Source Data Video
0.original.mp4
1. Why PivotTables- Video
bih31bff2qij22ksto1g.mp4
2. Structuring Your Source Data Video
bih31bnf2qij22ksto20.mp4
3. Inserting Your First PivotTable Video
bih31bqmeheka336a8tg.mp4
4. IMPORTANT- Add to Data Model Text
IMPORTANT- Add to Data Model.html
5. Navigating the Field List Video
bih31cimeheka336a8u0.mp4
6. KNOWLEDGE CHECK- Manipulating PivotTable Views Text
KNOWLEDGE CHECK- Manipulating PivotTable Views.html
7. PivotTable Options- -Analyze- - -Design- Video
bih31cvf2qij22ksto2g.mp4
8. Selecting- Clearing- Moving - Copying Pivots Video
bih31dameheka336a8ug.mp4
9. Refreshing - Updating Pivots Video
bih31eff2qij22ksto30.mp4
11. Removing - Reviving Data from Cache Video
bilm9rdnkrnfm4n3n4i0.mp4
12. How PivotTables ACTUALLY Work Video
bih31g7f2qij22ksto40.mp4
14. HOMEWORK- PivotTable 101 Text
HOMEWORK- PivotTable 101.html
0. Orientation - Benchmark Assessment
1. Welcome to the Course- Text
Welcome to the Course-.html
1. Course Intro
1. Course Structure - Outline Video
bjcsdmtnkrnfm4n40n0g.mp4
2.DOWNLOAD%3a Course Resources
2016_Movies-1554821519587.xlsx
Excel_PivotTables__PivotCharts-1560951714742.pdf
IMDbMovieDatabase-1554821516150.xlsx
3. Getting to Know the IMDb Movie Database Video
bih308imeheka336a8s0.mp4
4. Setting Expectations Video
bih30aqmeheka336a8sg.mp4
3. PivotTable Formatting
1. Number Formatting Video
bih33eimeheka336a8vg.mp4
2. PRO TIP- Automatically Formatting Empty Cells Video
bih33eqmeheka336a900.mp4
3. Table Layouts - Styles Video
bih33fvf2qij22ksto50.mp4
4. PRO TIP- Using Tabular Tables to Create New Source Data Video
bih33gff2qij22ksto5g.mp4
5. Customizing Headers - Labels Video
bih33gameheka336a90g.mp4
6. Conditional Formatting Video
bih33i2meheka336a910.mp4
7. PRO TIP- Data Bars with Invisible Text Video
bih33iimeheka336a91g.mp4
8. Advanced Conditional Formatting Video
bilmaplnkrnfm4n3n4jg.mp4
10. HOMEWORK- PivotTable Formatting Text
HOMEWORK- PivotTable Formatting.html
4. Sorting- Filtering - Grouping
1. Sorting Options Video
bih34t7f2qij22ksto60.mp4
2. PRO TIP- Incorrect Alphabetical Sorting Video
bih34tvf2qij22ksto6g.mp4
3. Label Filters - Manual Selections Video
bih34uff2qij22ksto70.mp4
4. PRO TIP- Label Filters with Wildcards Video
bih34uqmeheka336a92g.mp4
5. Value Filters Video
bih34vameheka336a930.mp4
6. PRO TIP- Enabling Multiple Filters Video
bih34vvf2qij22ksto7g.mp4
7. Grouping Data Video
bih350ff2qij22ksto80.mp4
8. PRO TIP- Automatic Date Grouping Video
bih350qmeheka336a93g.mp4
9. Using Slicers - Timelines to Filter Data Video
bih351ameheka336a940.mp4
10. Breaking Out Report Filter Pages Video
bih3527f2qij22ksto8g.mp4
12. HOMEWORK- Sorting- Filtering - Grouping Text
HOMEWORK- Sorting- Filtering - Grouping.html
5. Calculated Values- Fields - Items
1. -Summarize Values By- Options Video
bih36l2meheka336a960.mp4
2. PRO TIP- Avoiding the -Count Of- Trap Video
bih36m7f2qij22kstoa0.mp4
3. -Show Values As- Calculations Video
bih36mimeheka336a96g.mp4
4. Show Values As- % of Column-Row Video
bih36mqmeheka336a970.mp4
5. Show Values As- % of Parent Video
bih36nameheka336a97g.mp4
6. Show Values As- Difference From Video
bih36oqmeheka336a980.mp4
7. Show Values As- Running Total Video
bih36p7f2qij22kstoag.mp4
8. Show Values As- Rank Video
bih36pnf2qij22kstob0.mp4
9. Show Values As- Index Video
bih36q2meheka336a98g.mp4
10. KNOWLEDGE CHECK- Show Values As Text
KNOWLEDGE CHECK- Show Values As.html
11. Inserting Calculated Fields Video
bih36qvf2qij22kstobg.mp4
12. Calculations in Pivots vs. Raw Data Video
bih36rff2qij22kstoc0.mp4
13. PRO TIP- Calculating Using Counts -Part 1- Video
bih36rqmeheka336a990.mp4
14. PRO TIP- Calculating Using Counts -Part 2- Video
bih36sameheka336a99g.mp4
15. Inserting a Calculated Item -use with caution-- Video
bih36snf2qij22kstocg.mp4
16. The Solve Order - List Formulas Tools Video
bih36t2meheka336a9a0.mp4
18. HOMEWORK- Calculated Values- Fields - Items Text
HOMEWORK- Calculated Values- Fields - Items.html
6. Pivot Charts
1. Intro to PivotCharts Video
bih3atimeheka336a9c0.mp4
2. Pivot Chart Demo- Column Chart Video
bih3av2meheka336a9cg.mp4
3. Pivot Chart Demo- Pie - Donut Charts Video
bih3avqmeheka336a9d0.mp4
4. Pivot Chart Demo- Clustered Bar Chart Video
bih3b0ff2qij22kstof0.mp4
5. PRO TIP- Prevent Charts from Resizing with Cells Video
bih3b0nf2qij22kstofg.mp4
6. Changing Chart Types on the Fly Video
bih3b17f2qij22kstog0.mp4
7. Pivot Chart Demo- Stacked Area Chart Video
bih3b1nf2qij22kstogg.mp4
8. Pivot Chart Layouts - Styles Video
bih3b22meheka336a9dg.mp4
9. Moving Pivot Charts to New Sheets Video
bih3b2ameheka336a9e0.mp4
10. Applying Slicers - Timelines to Multiple Charts Video
bih3b37f2qij22kstoh0.mp4
11. Building a Dynamic Dashboard Video
bih3b3vf2qij22kstohg.mp4
13. HOMEWORK- Pivot Charts Text
HOMEWORK- Pivot Charts.html
7. PivotTable Case Studies
1. Setting Expectations Video
bih3cr2meheka336a9eg.mp4
3. U.S. Voters -2012- Video
bih3cs2meheka336a9f0.mp4
4. HOMEWORK- U.S. Voters -2012- Text
HOMEWORK- U.S. Voters -2012-.html
5. San Francisco Salaries Video
bih3ct2meheka336a9fg.mp4
6. HOMEWORK- San Francisco Salaries Text
HOMEWORK- San Francisco Salaries.html
7. Shark Attack Records Video
bih3ctvf2qij22kstoig.mp4
8. HOMEWORK- Shark Attack Records Text
HOMEWORK- Shark Attack Records.html
9. Stock Market Data Video
bih3cvff2qij22kstoj0.mp4
10. HOMEWORK- Stock Market Data Text
HOMEWORK- Stock Market Data.html
11. Baseball Team Stats Video
bih3d07f2qij22kstojg.mp4
12. HOMEWORK- Baseball Team Stats Text
HOMEWORK- Baseball Team Stats.html
13. San Diego Burrito Ratings Video
bih3d0qmeheka336a9g0.mp4
14. HOMEWORK- San Diego Burrito Ratings Text
HOMEWORK- San Diego Burrito Ratings.html
15. Daily Weather Conditions Video
bih3d27f2qij22kstok0.mp4
16. HOMEWORK- Daily Weather Conditions Text
HOMEWORK- Daily Weather Conditions.html
17. Spartan Race Facebook Posts Video
bih3d2qmeheka336a9gg.mp4
18. HOMEWORK- Spartan Race Facebook Posts Text
HOMEWORK- Spartan Race Facebook Posts.html
19. Apple App Data Video
bilmh3lnkrnfm4n3n4q0.mp4
20. HOMEWORK- Apple App Data Text
HOMEWORK- Apple App Data.html
21. Wine Tasting Scores Video
bilmhc1ujavq7bbevtj0.mp4
22. HOMEWORK- Wine Tasting Scores Text
HOMEWORK- Wine Tasting Scores.html
9. Final Assessment - Next Steps
2. Share the love- Text
Share the love-.html
3. Next Steps Text
Next Steps.html
Microsoft Excel- Formulas - Functions
5. Lookup-Reference Functions
15. DEMO- Building Dashboards with XLOOKUP Video
bpbarnm4u06v67aaqdm0.mp4
1. Introduction Video
billfuhujavq7bbevt20.mp4
2. Working with Named Arrays Video
bif2upimeheka3369dc0.mp4
3. ROW-ROWS - COLUMN-COLUMNS Video
bif2uqqmeheka3369dd0.mp4
4. VLOOKUP-HLOOKUP Video
bkken0sun9aqs06nstd0.mp4
5. Joining Data with VLOOKUP Video
blfgcvrje7ib1ccr8ej0.mp4
6. Fixing Errors with IFERROR - VLOOKUP Video
bif2utameheka3369ddg.mp4
7. VLOOKUP Reference Array Options Video
bif2vaameheka3369df0.mp4
8. Approximate Match Lookups Video
bif31v2meheka3369dt0.mp4
9. The INDEX Function Video
bif2vavf2qij22kssreg.mp4
10. The MATCH Function Video
bif2vdnf2qij22kssrf0.mp4
11. Using INDEX - MATCH Together Video
bif2vcqmeheka3369dfg.mp4
12. Combining MATCH with VLOOKUP Video
bif2uivf2qij22kssrb0.mp4
13. UPDATE- VLOOKUP Correction Video
bif2vgff2qij22kssrfg.mp4
14. SNEAK PEEK- XLOOKUP -Office 365 Only- Video
bpbar3i894no2mlcnddg.mp4
16. Selecting List Items with CHOOSE Video
bpbas8a894no2mlcndf0.mp4
17. The OFFSET Function Video
bif2vgqmeheka3369dg0.mp4
18. Combining OFFSET with COUNTA Video
bif2vhqmeheka3369dgg.mp4
19. DEMO- Using OFFSET to Create a Dynamic Scrolling Chart Video
bif2vkameheka3369dh0.mp4
21. HOMEWORK- Lookup-Reference Functions Video
bif2uu2meheka3369de0.mp4
0. Orientation - Benchmark Assessment
1. Welcome to the Course- Text
Welcome to the Course-.html
1. Course Intro
1. Course Structure - Outline Video
bjcsct5nkrnfm4n40mv0.mp4
2.DOWNLOAD%3a Course Resources
Excel_Formulas__Functions-200226-125141.pdf
ExcelDemoWorkbooks-200226-124417.zip
ExcelHomeworkWorkbooks-1560783659577.zip
3. Setting Expectations Video
bk3qn09ujavq7bbfl26g.mp4
2. Excel Formulas 101
1. Introduction Video
bk3r26lnkrnfm4n4c9l0.mp4
2. Formula Syntax Video
bk3r4v9ujavq7bbfl2p0.mp4
3. Fixed - Relative References Video
bk3r5p9ujavq7bbfl2pg.mp4
4. Common Error Types Video
bk3r8llnkrnfm4n4c9p0.mp4
5. Formula Auditing- Trace Precedents - Dependents Video
bk3r9n5nkrnfm4n4c9q0.mp4
6. Formula Auditing- Evaluate Formula - Error Checking Video
bk3raqlnkrnfm4n4c9r0.mp4
7. Ctrl Shortcuts Video
bk3rea1ujavq7bbfl300.mp4
8. Function Shortcuts Video
bk3rgqlnkrnfm4n4ca00.mp4
9. Alt Key Tips Video
bk3rjn9ujavq7bbfl320.mp4
10. PRO TIP- Data Validation Video
bk3rkh5nkrnfm4n4ca0g.mp4
11. Congrats- You-re a Developer- Video
bk3rl65nkrnfm4n4ca10.mp4
13. HOMEWORK- Formulas 101 Video
bk3srtdnkrnfm4n4camg.mp4
3. Conditional - Logical Operators
1. Introduction Video
billfe1ujavq7bbevt10.mp4
2. Anatomy of the IF Statement Video
bif2ugimeheka3369da0.mp4
3. Nested IF Statements Video
bif2ufimeheka3369d9g.mp4
4. AND-OR Operators Video
bif2ucqmeheka3369d7g.mp4
5. NOT vs. ---- Video
bif2u9nf2qij22kssr90.mp4
6. Fixing Errors with IFERROR Video
bif2ueimeheka3369d8g.mp4
7. Common IS Statements Video
bif2uhvf2qij22kssrag.mp4
9. HOMEWORK- Logical Operators Video
bif2ulff2qij22kssrc0.mp4
4. Statistical Functions
1. Introduction Video
billfppujavq7bbevt1g.mp4
2. Basic Statistical Functions Video
bif2ukqmeheka3369db0.mp4
3. SMALL-LARGE - RANK-PERCENTRANK Video
bkke5jkun9aqs06nst9g.mp4
4. RAND-- - RANDBETWEEN Video
bif2umnf2qij22kssrd0.mp4
5. The SUMPRODUCT Function Video
bif2um7f2qij22kssrcg.mp4
6. SUMPRODUCT Demo Video
bif322vf2qij22kssrtg.mp4
7. COUNTIFS-SUMIFS-AVERAGEIFS Video
bif2ujvf2qij22kssrbg.mp4
8. DEMO- Building a Basic Dashboard Video
bif2ttameheka3369d40.mp4
9. Combining COUNTIF - SUMPRODUCT Video
bif30a7f2qij22kssrkg.mp4
10. PRO TIP- Data Profiling with COUNT - SUMPRODUCT Video
bpbaqaq894no2mlcndc0.mp4
12. HOMEWORK- Statistical Functions Video
bif2uq2meheka3369dcg.mp4
6. Text Functions
1. Introduction Video
billg39ujavq7bbevt2g.mp4
2. UPPER-LOWER-PROPER - TRIM Video
bif2vsqmeheka3369di0.mp4
3. The CONCATENATE Function --- Video
bif2vlnf2qij22kssrgg.mp4
4. LEFT-MID-RIGHT - LEN Video
bif2vmimeheka3369dhg.mp4
5. TEXT-VALUE Video
bif324qmeheka3369dtg.mp4
6. SEARCH-FIND Video
bif2voff2qij22kssrh0.mp4
7. Categorizing Data with IF-ISNUMBER-SEARCH-- Video
bif2vs7f2qij22kssri0.mp4
8. Combining RIGHT- LEN- and SEARCH Video
bif2vqnf2qij22kssrhg.mp4
9. SUBSTITUTE Video
bif2vv2meheka3369dig.mp4
11. HOMEWORK- Text Functions Video
bif2u1nf2qij22kssr60.mp4
7. Date - Time Functions
1. Introduction Video
billg79ujavq7bbevt30.mp4
2. DATEVALUE Video
bif30gqmeheka3369dkg.mp4
3. Date Formatting - Fill Series Video
bif301ameheka3369dj0.mp4
4. TODAY---NOW-- Video
bif301vf2qij22kssrjg.mp4
5. YEAR-MONTH-DAY - HOUR-MINUTE-SECOND Video
bif302vf2qij22kssrk0.mp4
6. The EOMONTH Function Video
bif300nf2qij22kssrig.mp4
7. The YEARFRAC Function Video
bif30b7f2qij22kssrl0.mp4
8. WEEKDAY- WORKDAY - NETWORKDAYS Video
bkkeehapeoo9q93dc3cg.mp4
9. The DATEDIF Function Video
bif30c2meheka3369djg.mp4
10. DEMO- Designing a Sample Budget Pacing Tool Video
bif30eimeheka3369dk0.mp4
12. HOMEWORK- Date - Time Functions Video
bif30hnf2qij22kssrm0.mp4
8. Formula-Based Formatting
1. Introduction Video
billgclnkrnfm4n3n460.mp4
2. Creating- Editing - Managing Formula-Based Rules Video
bif30mameheka3369dlg.mp4
3. Highlighting Every Other Row Using the MOD Function Video
bif30inf2qij22kssrmg.mp4
4. Formatting Cells Based on the Value of Another Cell Video
bif30lff2qij22kssrn0.mp4
5. Formatting Cells Using Statistical Functions Video
bif30kameheka3369dl0.mp4
6. Formatting Cells Using Text Functions - Logical operators Video
bif30nqmeheka3369dm0.mp4
8. HOMEWORK- Formula-Based Formatting Video
bif30onf2qij22kssrng.mp4
9. Array Formulas
1. Introduction Video
billgjtnkrnfm4n3n46g.mp4
2. READ ME- Array Formulas are Changing- Text
READ ME- Array Formulas are Changing-.html
3. Rules of Array Functions Video
bif311imeheka3369dog.mp4
4. Pros - Cons of Array Functions Video
bif3162meheka3369dp0.mp4
5. Vertical- Horizontal- and 2-Dimensional Array Constants Video
bif30q2meheka3369dmg.mp4
6. Using Array Constants in Formulas Video
bif30r2meheka3369dn0.mp4
7. Named Array Constants Video
bif30s2meheka3369dng.mp4
8. The Transpose Function Video
bif30fnf2qij22kssrlg.mp4
9. Linking Data Between Sheets- Array vs. Non-Array Comparison Video
bif30t7f2qij22kssro0.mp4
10. Returning the -X- Largest Values in a Range Video
bif30u7f2qij22kssrog.mp4
11. Counting Characters Across Cells Video
bif30uqmeheka3369do0.mp4
12. Creating a -MAX IF- Array Formula Video
bif310nf2qij22kssrp0.mp4
13. -MAX IF- with Multiple Criteria Video
bif3147f2qij22kssrpg.mp4
14. Using the Double Unary Operator ------ Video
bif3197f2qij22kssrqg.mp4
16. HOMEWORK- Array Functions Video
bif315ff2qij22kssrq0.mp4
10. Bonus Functions
1. Introduction Video
billgolnkrnfm4n3n470.mp4
2. The INDIRECT Function Video
bif31cameheka3369dpg.mp4
3. The HYPERLINK Function Video
bif31e7f2qij22kssrr0.mp4
4. WEBSERVICE - FILTERXML Demo- Weather Underground Video
bif327qmeheka3369du0.mp4
5. WEBSERVICE - FILTERXML Demo- Open Weather Map Video
bif2v8vf2qij22kssre0.mp4
12. Final Assessment - Next Steps
2. Share the love- Text
Share the love-.html
3. Next Steps Text
Next Steps.html
Excel MO-201 Exam Prep
0. Course Intro
2.DOWNLOAD%3a Course Resources
MO201ExamStudyGuide-201118-104914.pdf
ExcelExpertCourseFiles-201118-105001.zip
3. Setting Expectations Video
buhgdtmje35bt9cid2qg.mp4
1. Course Structure - Outline Video
bulkrseje35bt9cim690.mp4
1. About the MO-201 Exam
1. Exam Structure Video
buhge0uje35bt9cid2r0.mp4
2. Objective Domains - Skills Measured Video
buhge2ri57dcbr63pks0.mp4
3. Exam Interface - Scheduling Video
buhge5bi57dcbr63pksg.mp4
4. Helpful Resources Video
buhge93i57dcbr63pkt0.mp4
2. The Course Project
1. Course Project Intro Video
buhgecbi57dcbr63pkug.mp4
2. The Airbnb Dataset Video
buhgeg3i57dcbr63pkv0.mp4
3. Advanced Formulas - Macros
1. Objective Domain Intro Video
buhgekbi57dcbr63pkvg.mp4
2. Fixed vs. Relative References Video
buhgeori57dcbr63pl00.mp4
3. Explicit vs. Structured References Video
buhgesri57dcbr63pl10.mp4
4. Logical Operations Video
buhgf0uje35bt9cid2s0.mp4
5. The IF Function Video
buhgf4ri57dcbr63pl20.mp4
6. Nested IF Functions vs. The IFS Function Video
buhgfbuje35bt9cid2sg.mp4
7. The NOT - “--” Operators Video
buhgfg6je35bt9cid2t0.mp4
8. The AND-OR Operators Video
buhgfl6je35bt9cid2u0.mp4
9. The SWITCH Function Video
buhgfpji57dcbr63pl30.mp4
10. The COUNTIF-SUMIF-AVERAGEIF Functions Video
buhgg23i57dcbr63pl40.mp4
11. COUNTIFS-SUMIFS-AVERAGEIFS for Multiple Criteria Video
buhggaeje35bt9cid30g.mp4
12. The MINIFS - MAXIFS Functions Video
buhgge3i57dcbr63pl50.mp4
13. Excel Date Values - Formatting Video
buhggi6je35bt9cid320.mp4
14. PRO TIP- Converting Text to Dates Video
buhggn6je35bt9cid32g.mp4
15. The TODAY - NOW Functions Video
buhggueje35bt9cid330.mp4
16. YEAR-MONTH-DAY - HOUR-MINUTE-SECOND Video
buhgh26je35bt9cid33g.mp4
17. WEEKDAY- WORKDAY - NETWORKDAYS Video
bummkp6je35bt9ciov4g.mp4
18. Recording a Macro Video
bumml53i57dcbr645eq0.mp4
19. Modifying - Deleting Macros Video
bummlquje35bt9ciov80.mp4
20. PRO TIP- Adding Form Controls Video
bummmhji57dcbr645erg.mp4
21. Lookup Functions Video
bummmm3i57dcbr645es0.mp4
22. The VLOOKUP - HLOOKUP Functions Video
bummn3bi57dcbr645eug.mp4
23. The INDEX Function Video
bummn7ri57dcbr645f00.mp4
24. The MATCH Function Video
bummndeje35bt9ciovfg.mp4
25. Combining INDEX - MATCH Video
bummnpbi57dcbr645f1g.mp4
26. Approximate Match Lookups Video
bummo2ji57dcbr645f3g.mp4
27. The PMT - NPER Functions Video
bummomuje35bt9ciovj0.mp4
28. Scenario Manager Video
bummovbi57dcbr645f70.mp4
29. Consolidate Data Video
bummp7ri57dcbr645f7g.mp4
30. Goal Seek Video
bummpfri57dcbr645f80.mp4
31. Formula Auditing Video
bummprmje35bt9ciovn0.mp4
4. Manage - Format Data
1. Objective Domain Intro Video
bummq3ji57dcbr645f9g.mp4
2. Custom Number Formats Video
bummqbbi57dcbr645fb0.mp4
3. Data Validation Video
bummqkeje35bt9ciovo0.mp4
4. Group - Ungroup Data Video
bummqs6je35bt9ciovpg.mp4
5. Subtotals - Totals Video
bummr4ri57dcbr645fg0.mp4
6. Removing Duplicates Video
bummrebi57dcbr645fhg.mp4
7. Auto Fill - Flash Fill Video
bummrrmje35bt9ciovt0.mp4
8. Advanced Fill Series Options Video
bumms36je35bt9ciovu0.mp4
9. Conditional Formatting Video
bummt9ri57dcbr645fkg.mp4
10. Formula-based Conditional Formatting Video
bummsvji57dcbr645fj0.mp4
11. Managing Conditional Formatting Rules Video
bummtkeje35bt9cip020.mp4
12. PRO TIP- Hiding Values to Create Heatmaps Video
bummtsmje35bt9cip03g.mp4
5. Advanced Charts - Tables
1. Objective Domain Intro Video
bummucri57dcbr645fo0.mp4
2. Box - Whisker Chart Video
bumn466je35bt9cip0n0.mp4
3. Histogram Video
bumn4buje35bt9cip0og.mp4
4. Filled Map Video
bumn4hri57dcbr645gb0.mp4
5. Combo Chart Video
bumn4ori57dcbr645gd0.mp4
6. Tree Map - Sunburst Chart Video
bumn53eje35bt9cip0s0.mp4
7. Waterfall Chart Video
bumn58ji57dcbr645gfg.mp4
8. Funnel Chart Video
bumn5eeje35bt9cip0sg.mp4
9. Creating a Pivot Table Video
bumn5mmje35bt9cip0tg.mp4
10. Modifying Pivot Table Views Video
bumn71ji57dcbr645gng.mp4
11. -Summarize Values By- Options Video
bumn76ji57dcbr645gq0.mp4
12. -Show Values As- Calculations Video
bumn84ri57dcbr645gtg.mp4
13. Analyze - Design Tabs Video
bumn8amje35bt9cip170.mp4
14. Report Layouts - Options Video
bumn8p6je35bt9cip19g.mp4
15. Number Formatting Video
bumn916je35bt9cip1b0.mp4
16. Sorting - Filtering Video
bumn9ieje35bt9cip1d0.mp4
17. Slicers - Timelines Video
bumn9qeje35bt9cip1e0.mp4
18. Grouping Text Fields Video
bumn9uri57dcbr645h5g.mp4
19. Grouping Numerical Fields Video
bumna5eje35bt9cip1fg.mp4
20. Grouping Date Fields Video
bumnabeje35bt9cip1g0.mp4
21. Calculated Fields Video
bun7663i57dcbr646osg.mp4
22. Calculated Items Video
bun76deje35bt9ciq7t0.mp4
23. Pivot Charts Video
bun790uje35bt9ciq8a0.mp4
24. Pivot Chart Formatting Video
bun79j3i57dcbr646p7g.mp4
25. Expanding - Collapsing Pivot Charts Video
bun79puje35bt9ciq8bg.mp4
6. Workbook Options - Settings
1. Objective Domain Intro Video
bun7a0mje35bt9ciq8c0.mp4
2. Enabling Macros Video
bun7anri57dcbr646p8g.mp4
3. Copying Macros to Other Files Video
bun7asji57dcbr646p90.mp4
4. Linking Data Across Workbooks Video
bun7b2ji57dcbr646pag.mp4
5. Protecting Worksheets - Cell Ranges Video
bun7b8ri57dcbr646pb0.mp4
6. Protecting - Encrypting Workbooks Video
bun7bh3i57dcbr646pbg.mp4
7. Recovering Workbooks Video
bun7bl3i57dcbr646pc0.mp4
8. Managing Comments Video
bun7bqji57dcbr646pcg.mp4
9. Formula Calculation Modes Video
bun7buji57dcbr646pd0.mp4
10. Language Options Video
bun7c2ri57dcbr646pe0.mp4
7. Practice Test
1. Practice Test Intro Video
buqc266je35bt9cj1e30.mp4
3. Practice Test Structure Video
buqc4p6je35bt9cj1e5g.mp4
4. SOLUTION- Project 1 Video
buqc70bi57dcbr64e53g.mp4
5. SOLUTION- Project 2 Video
buqc85ri57dcbr64e56g.mp4
6. SOLUTION- Project 3 Video
buqc913i57dcbr64e580.mp4
7. SOLUTION- Project 4 Video
buqcacbi57dcbr64e5d0.mp4
8. SOLUTION- Project 5 Video
buqcbvmje35bt9cj1eeg.mp4
9. SOLUTION- Project 6 Video
buqcd0mje35bt9cj1ehg.mp4
8. Feedback Survey - Next Steps
2. Share the love- Text
Share the love-.html
3. Next Steps Text
Next Steps.html
Excel Pro Tips- Analytics
0. Course Intro
1. Course Structure - Outline Video
bjcsf51ujavq7bbf9gog.mp4
2.DOWNLOAD%3a Course Resources
Excel_Pro_Tips-1560900902764.pdf
kickstarter_projects-1554822241991 (1).csv
ProTipWorkbooks-1554822204518.zip
3. Setting Expectations Video
biht1e1ujavq7bbeu6eg.mp4
1. Analytics Tips
1. Introduction Video
bihtgk1ujavq7bbeu7dg.mp4
2. Quick Analysis Tools Video
bihtfttnkrnfm4n3lf1g.mp4
3. Scenario Manager Video
bihtfqpujavq7bbeu7c0.mp4
4. Optimization with Goal Seek Video
bihtgndnkrnfm4n3lf30.mp4
5. Basic Forecasting Video
bihtgulnkrnfm4n3lf3g.mp4
6. Outlier Detection Video
bihtgahujavq7bbeu7cg.mp4
7. Automated Data Tables Video
bihth39ujavq7bbeu7e0.mp4
8. Power Query Tools Video
bihtg5dnkrnfm4n3lf2g.mp4
9. Data Modeling 101 Video
bihthd9ujavq7bbeu7eg.mp4
10. CUBE Functions Video
bihthmhujavq7bbeu7f0.mp4
11. Monte Carlo Simulation Video
bihtgh9ujavq7bbeu7d0.mp4
12. Advanced Optimization with Solver Video
bihtfmdnkrnfm4n3lf10.mp4
13. Analysis ToolPak -Preview- Video
bihthr9ujavq7bbeu7fg.mp4
2. Next Steps
2. Share the love- Text
Share the love-.html
3. Next Steps Text
Next Steps.html
Excel Pro Tips- Data Visualization
0. Course Intro
1. Course Structure - Outline Video
bjcsf51ujavq7bbf9gog.mp4
2.DOWNLOAD%3a Course Resources
Excel_Pro_Tips-1560900837467.pdf
ProTipWorkbooks-1554822204518.zip
3. Setting Expectations Video
biht1e1ujavq7bbeu6eg.mp4
1. Visualization Tips
1. Introduction Video
bihtbclnkrnfm4n3leq0.mp4
2. Chart Properties -Move - Size- Video
bihtbahujavq7bbeu730.mp4
3. Hidden Chart Source Data Video
bihtbllnkrnfm4n3leqg.mp4
4. Filled Maps -Excel 2016-- Video
bihtc9pujavq7bbeu750.mp4
5. Customizing Charts to Tell a Story Video
bihtcqdnkrnfm4n3lesg.mp4
6. Adding Sparklines Video
bihtb61ujavq7bbeu72g.mp4
7. Custom Chart Templates Video
bihtb35nkrnfm4n3lepg.mp4
8. Heat Maps with Color Scales Video
bihtbpdnkrnfm4n3ler0.mp4
9. Analyzing Distribution with Histograms Video
bihtbi9ujavq7bbeu73g.mp4
10. Goal Pacing with Gauge Charts Video
bihtbtlnkrnfm4n3lerg.mp4
11. Highlighting Time Periods Video
bihtcmpujavq7bbeu760.mp4
12. Dynamic Source Ranges Video
bihtcipujavq7bbeu75g.mp4
13. Interactive Form Controls Video
bihtc6hujavq7bbeu74g.mp4
2. Next Steps
2. Share the love- Text
Share the love-.html
3. Next Steps Text
Next Steps.html
Excel Pro Tips- Formatting
0. Course Intro
1. Course Structure - Outline Video
bjcsf51ujavq7bbf9gog.mp4
2.DOWNLOAD%3a Course Resources
Excel_Pro_Tips-1560900767291.pdf
ProTipWorkbooks-1554822204518.zip
3. Setting Expectations Video
biht1e1ujavq7bbeu6eg.mp4
1. Formatting Tips
1. Introduction Video
biht2qhujavq7bbeu6i0.mp4
2. Formatting Shortcuts Video
biht4r1ujavq7bbeu6lg.mp4
3. Snap to Grid Video
biht2ipujavq7bbeu6h0.mp4
4. Hiding Workbook Elements Video
biht32lnkrnfm4n3leag.mp4
5. Format Painter Video
biht571ujavq7bbeu6mg.mp4
6. Color - Border Design Video
biht1h1ujavq7bbeu6fg.mp4
7. Freezing Panes Video
biht451ujavq7bbeu6k0.mp4
8. Center Across Selection Video
biht5qhujavq7bbeu6n0.mp4
9. Invisible Text Formatting Video
biht2ndnkrnfm4n3le9g.mp4
10. Zip Codes - Phone Numbers Video
biht18tnkrnfm4n3le70.mp4
11. Grouping Columns - Rows Video
biht3i5nkrnfm4n3lec0.mp4
12. Formatting Errors with IFERROR Video
biht2vhujavq7bbeu6ig.mp4
13. Converting Text to Date Values Video
biht2g5nkrnfm4n3le90.mp4
14. Formula-Based Formats Video
biht4lhujavq7bbeu6l0.mp4
15. Advanced Number Formats Video
biht5o5nkrnfm4n3lef0.mp4
2. Next Steps
2. Share the love- Text
Share the love-.html
3. Next Steps Text
Next Steps.html
Excel Pro Tips- Formulas
0. Course Intro
1. Course Structure - Outline Video
bjcsf51ujavq7bbf9gog.mp4
2.DOWNLOAD%3a Course Resources
Excel_Pro_Tips-1560900803824.pdf
ProTipWorkbooks-1554822204518_2.zip
3. Setting Expectations Video
biht1e1ujavq7bbeu6eg.mp4
1. Formula Tips
1. Introduction Video
biht9hdnkrnfm4n3leng.mp4
2. Manual vs. Automatic Calculation Video
bihtakdnkrnfm4n3leog.mp4
3. Formula Line Breaks Video
biht9epujavq7bbeu700.mp4
4. Converting Units of Measurement Video
bihtafpujavq7bbeu720.mp4
5. Real-Time Tools with TODAY - NOW Video
bl9du2jje7ib1ccr5j30.mp4
6. Formula Auditing Tools Video
bihtarlnkrnfm4n3lep0.mp4
7. Pivot-Style Reports with Formulas Video
biht8m5nkrnfm4n3len0.mp4
8. Counting Words in a Cell Video
biht7otnkrnfm4n3lemg.mp4
9. Dependent Drop-Downs with INDIRECT Video
bihta8pujavq7bbeu71g.mp4
10. Hyperlinking Between Worksheets Video
biht9t5nkrnfm4n3leo0.mp4
11. -Fuzzy Match- Lookups Video
bihta39ujavq7bbeu710.mp4
12. Random Selection with OFFSET - RANDBETWEEN Video
biht8d1ujavq7bbeu6ug.mp4
13. Combining INDEX - MATCH Video
biht9n9ujavq7bbeu70g.mp4
14. Matching Items Between Lists Video
biht91pujavq7bbeu6v0.mp4
15. Counting Duplicates with SUMPRODUCT Video
biht7v1ujavq7bbeu6tg.mp4
16. Many-to-Many Lookups Video
biht9b9ujavq7bbeu6vg.mp4
2. Next Steps
2. Share the love- Text
Share the love-.html
3. Next Steps Text
Next Steps.html
Excel Pro Tips- Pivot Tables
0. Course Intro
1. Course Structure - Outline Video
bjcsf51ujavq7bbf9gog.mp4
2.DOWNLOAD%3a Course Resources
Excel_Pro_Tips-1560900871360.pdf
ProTipWorkbooks1554822204518-200417-093239.zip
3. Setting Expectations Video
biht1e1ujavq7bbeu6eg.mp4
1. PivotTable Tips
1. Introduction Video
bihte51ujavq7bbeu78g.mp4
2. Customizing the Field List Video
bihte8lnkrnfm4n3lev0.mp4
3. Autofitting Column Width Video
bihtf81ujavq7bbeu7a0.mp4
4. Outline - Tabular Layouts Video
bihtdd9ujavq7bbeu770.mp4
5. Counting Non-Numerical Fields Video
bihteslnkrnfm4n3lf00.mp4
6. Grouping Dates Video
bihtelpujavq7bbeu790.mp4
7. Enabling Multiple Filters Video
bihte31ujavq7bbeu780.mp4
8. Grouping Values Video
bihtd3tnkrnfm4n3let0.mp4
9. Adding Value Calculations Video
bihtd8tnkrnfm4n3letg.mp4
10. Showing Empty Items Video
bihteetnkrnfm4n3levg.mp4
11. Configuring Slicers - Timelines Video
bihtdntnkrnfm4n3leu0.mp4
12. Conditional Formatting Video
bihtf3lnkrnfm4n3lf0g.mp4
13. Removing - Reviving Source Data Video
bihtdudnkrnfm4n3leug.mp4
14. Adding Custom Sort Lists Video
bihtephujavq7bbeu79g.mp4
15. Solve Order - List Formulas Video
bihtdgpujavq7bbeu77g.mp4
2. Next Steps
2. Share the love- Text
Share the love-.html
3. Next Steps Text
Next Steps.html
Excel Pro Tips- Productivity
0. Course Intro
1. Course Structure - Outline Video
bjcsf51ujavq7bbf9gog.mp4
2. Course Structure & Outline
Excel_Pro_Tips-1560900716028.pdf
ProTipWorkbooks-1554822204518_3.zip
3. Setting Expectations Video
biht1e1ujavq7bbeu6eg.mp4
1. Productivity Tips
1. Introduction Video
biht37hujavq7bbeu6j0.mp4
2. Customizing the Footer Video
biht2ulnkrnfm4n3lea0.mp4
3. CTRL Shortcuts Video
biht24lnkrnfm4n3le8g.mp4
4. ALT Key Tips Video
biht1a9ujavq7bbeu6e0.mp4
5. -Go To- Special Options Video
biht32lnkrnfm4n3leb0.mp4
6. Removing Blank Rows Video
biht1ehujavq7bbeu6f0.mp4
7. Data Validation Drop-Downs Video
biht2a1ujavq7bbeu6gg.mp4
8. Autofill - Flash Fill Video
biht2o9ujavq7bbeu6hg.mp4
9. Customizing the Ribbon Video
biht511ujavq7bbeu6m0.mp4
10. Splitting Text to Columns Video
biht4ldnkrnfm4n3ledg.mp4
11. Synchronous Scrolling Video
biht4qtnkrnfm4n3lee0.mp4
12. Extracting Unique Values Video
biht45pujavq7bbeu6kg.mp4
13. Named Range - Table References Video
biht5itnkrnfm4n3leeg.mp4
14. Protecting Cells - Formulas Video
biht3epujavq7bbeu6jg.mp4
15. Multi-Level Row - Column Sorting Video
biht3utnkrnfm4n3lecg.mp4
16. Advanced Filter Criteria Video
biht0rpujavq7bbeu6d0.mp4
2. Next Steps
2. Share the love- Text
Share the love-.html
3. Next Steps Text
Next Steps.html
Maven Analytics - DATA PLAYGROUND (Test & Work Assignment)
120 years of Olympic History
Olympic_Athletes.zip
UbmlZj1.png
Airline Flight Delays
Airlines+Airports+Cancellation+Codes+&+Flights.zip
WDZ1zpn.png
YLM3ibk.png
Inc 5000 Companies
INC+5000+Companies+2019.csv.zip
JMVi6eq.png
Jordan & LeBron Career Stats
Jordan+vs.+Lebron+Data.zip
rufp9XI (1).png
Madrid Daily Weather
Madrid+Daily+Weather+1997-2015.csv.zip
MBbctH4.png
Marketing Campaign Results
8uVPBte.png
Marketing+Data.zip
Movie Ratings
ftRwylE.png
Rotten+Tomatoes+Movies.csv.zip
New Year's Eve Resolutions
5UXuOZG.png
New_years_resolutions.zip
NYC Traffic Accidents
NYC+Accidents+2020.csv.zip
ZwyENCK.png
Online Chess Games
4YqYbbA.png
Online+Chess+Games.zip
S&P 500 Stock Prices
S&P+500+Stock+Prices+2014-2017.csv.zip
VxHJzpX.png
Shark Attacks
6kKoU0N.png
attacks.csv.zip
Spotify Top 100
Kc60hrr.png
top2018.csv.zip
UFO Sightings
LlLLEbr.png
ufo_sightings_scrubbed.csv.zip
Wine Tasting
6Nxrev6.png
winemag-data-130k-v2.csv.zip
World Cup
Q9wZHny.png
World+Cups+Matches+&+Players.zip
Microsoft Excel- Charts - Graphs
0. Orientation - Benchmark Assessment
1. Welcome to the Course- Text
Welcome to the Course-.html
1. Course Intro
1. Course Structure - Outline Video
bjcsdc5nkrnfm4n40n00.mp4
2.DOWNLOAD%3a Course Resources
DataVizDemoWorkbooks-200211-162500.zip
DataVizHomeworkWorkbooks-1554821330911.zip
Excel_Charts__Graphs-1560900499179.pdf
Thermometer-1554821337358.png
ThumbsUp-1554821339997.png
3. Setting Expectations Video
bk79ss5nkrnfm4n4die0.mp4
2. Data Visualization Best Practices
1. Key Data Viz Principles - the 10-Second Rule Video
bih3q22meheka336a9t0.mp4
2. The Good- the Bad- and the Ugly Video
bih3q2ameheka336a9tg.mp4
3. The 3 Key Questions Video
bih3q2nf2qij22kstov0.mp4
3. Customizing Charts in Excel
1. Chart Elements- Layouts- Colors - Styles Video
bih3qo2meheka336a9vg.mp4
2. Chart Formatting Options Video
bih3qpff2qij22kstp00.mp4
3. Changing Chart Types - Adding a Secondary Axis Video
bih3qpvf2qij22kstp0g.mp4
4. Creating- Modifying - Applying Custom Templates Video
bih3qq2meheka336aa00.mp4
4. Mastering Basic Charts - Graphs
1. Bar - Column Charts Video
bih3s2ameheka336aa2g.mp4
2. HOMEWORK- Bar - Column Charts Text
HOMEWORK- Bar - Column Charts.html
3. Histogram - Pareto Charts -Office 365-2016-- Video
bih3s2vf2qij22kstp1g.mp4
4. HOMEWORK- Histogram - Pareto Charts Text
HOMEWORK- Histogram - Pareto Charts .html
5. Line Charts - Trendlines Video
bih3s3ff2qij22kstp20.mp4
6. HOMEWORK- Line Charts - Trendlines Text
HOMEWORK- Line Charts - Trendlines.html
7. Area Charts Video
bih3s3imeheka336aa30.mp4
8. HOMEWORK- Area Charts Text
HOMEWORK- Area Charts.html
9. Pies- Donuts - Race Tracks Video
bih3s5ff2qij22kstp2g.mp4
10. HOMEWORK- Pies- Donuts - Race Tracks Text
HOMEWORK- Pies- Donuts - Race Tracks.html
11. Scatter Plots Video
bih3s5qmeheka336aa3g.mp4
12. Bubble Charts Video
bih3s6qmeheka336aa40.mp4
13. HOMEWORK- Scatter Plots - Bubble Charts Text
HOMEWORK- Scatter Plots - Bubble Charts.html
14. Box - Whisker Charts -Office 365-2016-- Video
bih3s7ff2qij22kstp30.mp4
15. HOMEWORK- Box - Whisker Charts Text
HOMEWORK- Box - Whisker Charts.html
16. Tree Maps - Sunburst Charts -Office 365-2016-- Video
bih3s7imeheka336aa4g.mp4
17. HOMEWORK- Tree Maps - Sunburst Charts Text
HOMEWORK- Tree Maps - Sunburst Charts.html
18. Waterfall Charts -Office 365-2016-- Video
bih3s87f2qij22kstp3g.mp4
19. Funnel Charts -Office 365-2016-- Video
bih3s97f2qij22kstp40.mp4
20. HOMEWORK- Waterfall - Funnel Charts Text
HOMEWORK- Waterfall - Funnel Charts.html
21. Radar Charts Video
bih3s9imeheka336aa50.mp4
22. HOMEWORK- Radar Charts Text
HOMEWORK- Radar Charts.html
23. Stock Charts Video
bih3saimeheka336aa5g.mp4
24. HOMEWORK- Stock Charts Text
HOMEWORK- Stock Charts.html
25. Heat Maps Video
bih3sc2meheka336aa60.mp4
26. HOMEWORK- Heat Maps Text
HOMEWORK- Heat Maps.html
27. Surface - Contour Charts Video
bih3sbnf2qij22kstp4g.mp4
28. HOMEWORK- Surface - Contour Charts Text
HOMEWORK- Surface - Contour Charts.html
29. Geo-Spatial Maps with Power Map Video
bih3scameheka336aa6g.mp4
30. HOMEWORK- Power Map Text
HOMEWORK- Power Map.html
31. Basic Combo Charts Video
bih3scvf2qij22kstp50.mp4
32. HOMEWORK- Combo Charts Text
HOMEWORK- Combo Charts.html
33. Sparklines Video
bih3sd2meheka336aa70.mp4
34. HOMEWORK- Sparklines Text
HOMEWORK- Sparklines.html
5. Next-Level Data Visualization Exercises
1. Setting Expectations Video
bih43uvf2qij22kstpe0.mp4
2. DEMO- Custom Image Overlay Charts Video
bm4lsqal9tga33sbd9rg.mp4
3. DEMO- Adding Binary Values to Highlight Date Ranges Video
bih43vimeheka336aadg.mp4
4. DEMO- Automation with OFFSET- COUNTA - Named Ranges Video
bih4402meheka336aae0.mp4
5. DEMO- Adding Scroll - Zoom Functionality with Form Controls Video
bih440nf2qij22kstpf0.mp4
6. DEMO- Animating Changes Over Time Video
bih441imeheka336aaeg.mp4
7. DEMO- Building a Dynamic Dashboard -Part 1- Video
bih442qmeheka336aaf0.mp4
8. DEMO- Building a Dynamic Dashboard -Part 2- Video
bih444nf2qij22kstpfg.mp4
9. DEMO- Value-Based Dynamic Formatting Video
bih445ameheka336aafg.mp4
10. DEMO- Dynamically Highlighting a Data Series Video
bih445qmeheka336aag0.mp4
11. DEMO- Building a Custom Pacing Chart Video
bih446imeheka336aagg.mp4
12. DEMO- Designing a Custom Gauge Chart Video
bih447ameheka336aah0.mp4
13. DEMO- Visualizing a Percentage Using Array Functions Video
bih447vf2qij22kstpg0.mp4
7. Final Assessment - Next Steps
2. Share the love- Text
Share the love-.html
3. Next Steps Text
Next Steps.html
Microsoft Excel- Power Query- Power Pivot - DAX
0. Orientation - Benchmark Assessment
1. Welcome to the Course- Text
Welcome to the Course-.html
1. Course Intro
1. Course Structure - Outline Video
bjcse39ujavq7bbf9gmg.mp4
2. IMPORTANT- Versions - Compatibility Video
bihm9snf2qij22ksu0b0.mp4
3. Introducing the Course Project Video
bihm9tqmeheka336agb0.mp4
4.DOWNLOAD%3a Course Resources
FoodMartCSVFiles-1554821743351.zip
FoodMartDataModelCOMPLETE-1554821750569.xlsx
PowerQuery_PowerPivot__DAX-1560900590898.pdf
5. Setting Expectations Video
bihm9sqmeheka336aga0.mp4
2. Intro to -Power Excel-
1. The -Power Excel- Workflow Video
bihmd27f2qij22ksu0f0.mp4
2. -The Best Thing to Happen to Excel in 20 Years- Video
bihmd1vf2qij22ksu0eg.mp4
3. When to use Power Query - Power Pivot Video
bihmd2imeheka336agd0.mp4
5. HOMEWORK- Intro to -Power Excel- Text
HOMEWORK- Intro to -Power Excel-.html
3. Power Query
1. Introduction Video
bihmdfqmeheka336agfg.mp4
2. Meet Power Query -aka -Get - Transform-- Video
bihmdgff2qij22ksu0hg.mp4
3. The Query Editor Video
bihmdjvf2qij22ksu0j0.mp4
4. Data Loading Options Video
bihmdcimeheka336ageg.mp4
5. IMPORTANT- Updating Locale Settings Text
IMPORTANT- Updating Locale Settings.html
6. Basic Table Transformations Video
bmrhfka9c233ls0jbsm0.mp4
7. Text-Specific Tools Video
binnpflnkrnfm4n3o690.mp4
8. Number-Specific Tools Video
bihmdhimeheka336agh0.mp4
9. Date-Specific Tools Video
binnrmhujavq7bbf10mg.mp4
10. PRO TIP- Creating a Rolling Calendar Video
bihmdivf2qij22ksu0ig.mp4
11. Adding Index - Conditional Columns Video
biqi11tnkrnfm4n3pk0g.mp4
12. Grouping - Aggregating Data Video
bihmdf7f2qij22ksu0gg.mp4
13. Pivoting - Unpivoting Video
bihmdi7f2qij22ksu0i0.mp4
14. Modifying Workbook Queries Video
bihmdh2meheka336aggg.mp4
15. Merging Queries Video
bihmdgqmeheka336agg0.mp4
16. Appending Queries Video
bihmdbimeheka336agdg.mp4
17. Connecting to a Folder of Files Video
bihmde2meheka336agf0.mp4
18. Power Query Best Practices Video
bihmdcff2qij22ksu0fg.mp4
20. HOMEWORK- Power Query Text
HOMEWORK- Power Query.html
4. Data Modeling 101
1. Introduction Video
bihme1ameheka336aglg.mp4
2. Meet Excel-s -Data Model- Video
bihme1imeheka336agm0.mp4
3. Data vs. Diagram View Video
bihmdvvf2qij22ksu0jg.mp4
4. Database Normalization Video
bihme32meheka336agn0.mp4
5. Data Tables vs. Lookup Tables Video
bihme07f2qij22ksu0k0.mp4
6. Relationships vs. Merged Tables Video
bihme3nf2qij22ksu0l0.mp4
7. Creating Table Relationships Video
bihmdvameheka336agjg.mp4
8. Modifying Table Relationships Video
bihme27f2qij22ksu0kg.mp4
9. Active vs. Inactive Relationships Video
bihmdu2meheka336agi0.mp4
10. Relationship Cardinality Video
bihmduqmeheka336agj0.mp4
11. Connecting Multiple Data Tables Video
bihme2imeheka336agmg.mp4
12. Filter Direction Video
bihme0ameheka336agk0.mp4
13. Hiding Fields from Client Tools Video
bihme0qmeheka336agkg.mp4
14. Defining Hierarchies Video
bihme12meheka336agl0.mp4
15. Data Model Best Practices Video
bihmduameheka336agig.mp4
17. HOMEWORK- Data Modeling 101 Text
HOMEWORK- Data Modeling 101.html
5. Power Pivot - DAX 101
1. Introduction Video
bihme8nf2qij22ksu0og.mp4
2. Creating a -Power- PivotTable Video
bihme9ameheka336agp0.mp4
3. Power Pivots vs. -Normal- Pivots Video
bihme6qmeheka336ago0.mp4
4. Intro to Data Analysis Expressions -DAX- Video
bihme6nf2qij22ksu0n0.mp4
5. Calculated Columns Video
bihme62meheka336agng.mp4
6. Intro to DAX Measures Video
bihme8vf2qij22ksu0p0.mp4
7. Creating Implicit Measures Video
bihme8ff2qij22ksu0o0.mp4
8. Creating Explicit Measured -AutoSum- Video
bihme5ff2qij22ksu0lg.mp4
9. Creating Explicit Measures -Power Pivot- Video
bihme7ameheka336agog.mp4
10. Understanding Filter Context Video
bihme7vf2qij22ksu0ng.mp4
11. Step-by-Step Measure Calculation Video
bihmea2meheka336agpg.mp4
12. RECAP- Calculated Columns vs. Measures Video
bihme6ff2qij22ksu0mg.mp4
13. Power Pivot Best Practices Video
bihme5nf2qij22ksu0m0.mp4
15. HOMEWORK- Power Pivot - DAX 101 Text
HOMEWORK- Power Pivot - DAX 101.html
6. Common DAX Functions
1. Introduction Video
bihmel7f2qij22ksu0sg.mp4
2. DAX Formula Syntax - Operators Video
bihmfcqmeheka336agug.mp4
3. Common DAX Function Categories Video
bihmehff2qij22ksu0r0.mp4
4. Basic Math - Stats Functions Video
bihmf7qmeheka336agsg.mp4
5. COUNT- COUNTA- DISTINCTCOUNT - COUNTROWS Video
bihmei2meheka336agq0.mp4
6. HOMEWORK- Math - Stats Functions Text
HOMEWORK- Math - Stats Functions.html
7. Logical Functions -IF-AND-OR- Video
bihmf77f2qij22ksu0u0.mp4
8. SWITCH - SWITCH-TRUE- Video
bihmfcimeheka336agu0.mp4
9. Text Functions Video
bihmfe2meheka336agv0.mp4
10. HOMEWORK- Logical - Text Functions Text
HOMEWORK- Logical - Text Functions.html
11. The CALCULATE Function Video
bihmegvf2qij22ksu0qg.mp4
12. Adding Filter Context with Filter -Part 1- Video
bihmejameheka336agqg.mp4
13. Adding Filter Context with Filter -Part 2- Video
bihmekvf2qij22ksu0s0.mp4
14. Removing Filter Context with ALL Video
bihmefnf2qij22ksu0pg.mp4
15. HOMEWORK- CALCULATE- FILTER - ALL Text
HOMEWORK- CALCULATE- FILTER - ALL.html
16. Joining Data with RELATED Video
bihmf9qmeheka336agt0.mp4
17. Iterator --X-- Functions- SUMX Video
bihmen2meheka336agr0.mp4
18. Iterator --X-- Functions- RANKX Video
bihmf9ff2qij22ksu0v0.mp4
19. HOMEWORK- Iterator Functions Text
HOMEWORK- Iterator Functions.html
20. Basic Date - Time Functions Video
bihmeivf2qij22ksu0rg.mp4
21. Time Intelligence Formulas Video
bihmfeqmeheka336agvg.mp4
22. HOMEWORK- Time Intelligence Text
HOMEWORK- Time Intelligence.html
23. Speed - Performance Considerations Video
bihmfaimeheka336agtg.mp4
24. DAX Best Practices Video
bihmefvf2qij22ksu0q0.mp4
7. Wrapping Up
1. Introduction Video
bihmeoqmeheka336agrg.mp4
2. Data Visualization Options Video
bihmeoff2qij22ksu0t0.mp4
3. Sneak Peek- Power BI Video
bihmepff2qij22ksu0tg.mp4
9. Final Assessment - Next Steps
2. Share the love- Text
Share the love-.html
3. Next Steps Text
Next Steps.html
Microsoft Excel- VBA - Macros
0. Orientation - Benchmark Assessment
1. Welcome to the Course- Text
Welcome to the Course-.html
1. Course Intro
1. Course Structure - Content Video
biuueupujavq7bbf42n0.mp4
2. Important Compatibility - Setup Information Video
biuuf1hujavq7bbf42o0.mp4
3. Getting to Know the Project Files Video
biuuf2tnkrnfm4n3r9og.mp4
4.DOWNLOAD%3a Course Resources
ALL_VBA_Section_Milestone_Files_In_One_Place-191116-215942.zip
Excel_VBA_Course_Slides-1557416329478.pdf
IconSets-1557416339603 (1).xlsx
VBA_Project_Guide-1557416345292.pdf
5. Setting Expectations Video
biuuf4tnkrnfm4n3r9p0.mp4
2. Your First Excel Macro
1. Overview- Macros - Visual Basic Editor -VBE- Video
biuufi9ujavq7bbf42og.mp4
2. Steps to Your First Macro Recording Video
biuufl5nkrnfm4n3r9pg.mp4
3. Visual Basic Editor- What You Need to Know Video
biuufntnkrnfm4n3r9q0.mp4
4. Project- Dynamic Cell Selection -Special Cells- Video
biuufttnkrnfm4n3r9qg.mp4
5. Project- Absolute versus Relative Macro Recording Video
biuug4dnkrnfm4n3r9r0.mp4
6. 7 Ways to Run Macros - VBA code Video
biuug79ujavq7bbf42p0.mp4
7. OFFICE 365 Update- Comments - Notes Text
OFFICE 365 Update- Comments - Notes.html
8. Activity- Record a Macro that Deletes all Comments Text
Activity- Record a Macro that Deletes all Comments.html
9. What-s the Difference Between Macros and VBA- Text
What-s the Difference Between Macros and VBA-.html
3. The Object Model
1. Overview- VBA Object Model Video
biuuh3hujavq7bbf42r0.mp4
2. VBA-s Code Reference Object Library Video
biuuge1ujavq7bbf42pg.mp4
3. VB Color Guidelines - Keyboard Shortcuts Video
biuugh1ujavq7bbf42q0.mp4
4. Excel VBA Object Model Video
biuugjdnkrnfm4n3r9rg.mp4
5. Object Properties Video
biuugldnkrnfm4n3r9s0.mp4
6. Object Methods Video
biuugohujavq7bbf42qg.mp4
7. How to Find the Object- Property - Method Video
biuugs5nkrnfm4n3r9sg.mp4
8. Conclusion- Key Takeaways Video
biuugtdnkrnfm4n3r9t0.mp4
4. Referencing Ranges- Worksheets - Workbooks with VBA
1. Overview- Referencing Ranges- Worksheets - Workbooks Video
biuuhihujavq7bbf42rg.mp4
2. Referring to Ranges - Writing to Cells in VBA Video
biuuhllnkrnfm4n3r9tg.mp4
3. Most Useful Range Properties - Methods Video
biuuhqtnkrnfm4n3r9u0.mp4
4. 4 Methods to Find the Last Row of a Range Video
biuui0dnkrnfm4n3r9ug.mp4
5. Copying - Resizing a Variable Range Video
biuui41ujavq7bbf42s0.mp4
6. Properly Referencing Worksheets Video
biuuiadnkrnfm4n3r9v0.mp4
7. Properly Referencing Workbooks Video
biuuifdnkrnfm4n3r9vg.mp4
8. Activity- Save a Hard-coded Copy of Workbook Text
Activity- Save a Hard-coded Copy of Workbook.html
9. Project- Save Hard-coded Copy - Macro-free version of workbook Video
biuuilpujavq7bbf42sg.mp4
10. Key Takeaways- Referencing Ranges Video
biuuimlnkrnfm4n3ra00.mp4
5. Working with Variables
1. Overview- Role of Assignment - Variables Video
biuuqp1ujavq7bbf430g.mp4
2. Data Types for Better Performance Video
biuuqqtnkrnfm4n3ra6g.mp4
3. Declaring Variables- Arrays - Constants Video
biuuqu1ujavq7bbf4310.mp4
4. Setting Object Variables Video
biuur11ujavq7bbf431g.mp4
5. Scoping Variables Video
biuur3dnkrnfm4n3ra70.mp4
6. Activity- Revisit Hard-coded Workbook Project Text
Activity- Revisit Hard-coded Workbook Project.html
7. Key Takeaways- Working with Variables Video
biuur4dnkrnfm4n3ra7g.mp4
6. Looping through Collections - Making Decisions
1. Overview- Why Collections are a VBA Essential Video
biuur8dnkrnfm4n3ra80.mp4
2. With - End With for Easier Code Writing Video
biuurb5nkrnfm4n3ra8g.mp4
3. For Each to Loop Through Collections Video
biuuri9ujavq7bbf4320.mp4
4. IF Then -Else- ElseIF- for Conditional Outcomes Video
biuurllnkrnfm4n3ra90.mp4
5. Select Case as Alternative for Many IF Statements Video
biuurmpujavq7bbf432g.mp4
6. Goto Statement to Change Program Flow Video
biuurotnkrnfm4n3ra9g.mp4
7. Activity- Get the Number of Formulas in a Worksheet Text
Activity- Get the Number of Formulas in a Worksheet.html
8. Project- Get the Number of Formulas in a Worksheet Video
biuurttnkrnfm4n3raa0.mp4
9. Bonus- Un-hiding All Sheets in One Go -3 Methods- Video
biuus2lnkrnfm4n3rabg.mp4
10. Key Takeaways- Collections - Decision Making in VBA Text
Key Takeaways- Collections - Decision Making in VBA.html
7. Useful Built-in Functions
1. Overview- VBA versus Worksheet Functions Video
biuus1tnkrnfm4n3rab0.mp4
2. Most Useful VBA Functions Video
biuus4tnkrnfm4n3rac0.mp4
3. Message Box Options Video
biuus89ujavq7bbf4330.mp4
4. Input Box -VBA InputBox Function- Video
biuuse1ujavq7bbf4340.mp4
5. Input Box that can Select Ranges Video
biuusjhujavq7bbf434g.mp4
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
7. Project- Show Top 3 Values in a Message box based on Range Video
biuusudnkrnfm4n3raf0.mp4
8. Key Takeaways- Built-in Functions Text
Key Takeaways- Built-in Functions.html
8. Debugging- Error Handling - Procedure Scope
1. Overview- Debugging- Handling Errors - Procedure Scope Video
biuusc1ujavq7bbf433g.mp4
2. Debugging Options- Watch- Locals- Immediate Windows - More Video
biuusldnkrnfm4n3radg.mp4
3. Error Handling- Different Methods Video
biuussdnkrnfm4n3raeg.mp4
4. Faster Code by Suppressing Pop-ups - Flickering Screen Video
biuut15nkrnfm4n3rag0.mp4
5. Procedure Scope - Running one Sub from Another Video
biuut3hujavq7bbf435g.mp4
6. Passing Arguments to Sub Procedures -By Ref- By Val- Video
biuut7tnkrnfm4n3raig.mp4
7. Activity- Number of Formulas -or Comments- Used in a Workbook Text
Activity- Number of Formulas -or Comments- Used in a Workbook.html
8. Project- Number of Formulas -or Comments- Used in a Workbook Video
biuuthlnkrnfm4n3rak0.mp4
9. Key Takeaways- Debugging - Error Handling Video
biuutjdnkrnfm4n3ral0.mp4
9. Main Project -1- Create a Tool to Automate Table of Contents -TOC-
1. Project Overview- Table of Contents -TOC- Video
biuut1dnkrnfm4n3ragg.mp4
2. TOC Project- The Basics Video
biuut9dnkrnfm4n3raj0.mp4
3. TOC Project- Adding Hyperlinks Video
biuut4dnkrnfm4n3rahg.mp4
4. TOC Project- Testing the VBA Code Video
biuusutnkrnfm4n3rafg.mp4
5. TOC Project- Adding Error Handling - More Checks Video
biuuthtnkrnfm4n3rakg.mp4
6. TOC Project- Adding to Personal Macro Workbook Video
biuutk1ujavq7bbf4360.mp4
7. First Milestone Completed- Text
First Milestone Completed-.html
10. Looping in VBA -Controlling the Flow of Code-
1. Overview- Looping in VBA Video
biuuu7dnkrnfm4n3ram0.mp4
2. For Next Counter Loops Video
biuuu9pujavq7bbf4390.mp4
3. For Next Nested Loop Video
biuuug5nkrnfm4n3rang.mp4
4. For Next Reverse Loop -Delete Filtered-Hidden Rows- Video
biuuum9ujavq7bbf439g.mp4
5. Do Until - Do While Loop Video
biuuuptnkrnfm4n3rao0.mp4
6. Practical Example of Do Loop -with Inputbox- Video
biuuur5nkrnfm4n3raog.mp4
7. Find Method for Quicker Lookup Results Video
biuuuv5nkrnfm4n3rap0.mp4
8. Find Method with Do Loop - Multiple Matches Video
biuuv1lnkrnfm4n3rapg.mp4
9. Add a Timer to Test - Speech to Inform Video
biuuv3pujavq7bbf43bg.mp4
10. Activity- Document all Comments in Workbook in a Sheet Text
Activity- Document all Comments in Workbook in a Sheet.html
11. Project- Document all Comments in Workbook in a Sheet Video
biuuu3hujavq7bbf437g.mp4
12. Key Takeaways- Looping in VBA Video
biuuu55nkrnfm4n3ralg.mp4
11. Working with Arrays
1. Overview- Working with Arrays in VBA Video
biuuvstnkrnfm4n3raq0.mp4
2. One Dimensional Arrays Video
biuv00dnkrnfm4n3raqg.mp4
3. Dynamic Arrays Video
biuv02dnkrnfm4n3rar0.mp4
4. Preserving Dynamic Arrays Video
biuv045nkrnfm4n3rarg.mp4
5. Two Dimensional Arrays Video
biuv061ujavq7bbf43c0.mp4
6. Variant Arrays- Quick Method to Write to Cells Video
biuv089ujavq7bbf43cg.mp4
7. Activity- Create a New Worksheet per Company with Specific Information Text
Activity- Create a New Worksheet per Company with Specific Information.html
8. Project- Create a New Worksheet per Company with Specific Information Video
biuv0d9ujavq7bbf43d0.mp4
9. Key Takeaways- Arrays Text
Key Takeaways- Arrays.html
12. Working with Files- Folders - Text Files
1. Overview- Working with Folders - Files Video
biuv0i9ujavq7bbf43eg.mp4
2. DIR Function- Check if Files or Folders Exist Video
biuv0l9ujavq7bbf43f0.mp4
3. GetOpenFileName Method- User Selects a File Video
biuv0o9ujavq7bbf43g0.mp4
4. FileDialog Property- Loop Inside a Folder Video
biuv0stnkrnfm4n3ras0.mp4
5. Create CSV File from Data in Excel Video
biuv0vdnkrnfm4n3rasg.mp4
6. Printing - Writing to Text Files for More Control Video
biuv10lnkrnfm4n3rat0.mp4
7. Activity- Export Data to Text file Text
Activity- Export Data to Text file.html
8. Project- Export Data to Text file Video
biuv185nkrnfm4n3ratg.mp4
9. Key Takeaways- Files - Folders Text
Key Takeaways- Files - Folders.html
13. Excel Tables- Formulas - Pivot Tables
1. Overview- -Pivot- Tables - Formulas Video
biuv1g1ujavq7bbf43gg.mp4
2. Using Excel Formulas in VBA Video
biuv1klnkrnfm4n3raug.mp4
3. Excel Tables- Use the Right Syntax Video
biuv1s5nkrnfm4n3ravg.mp4
4. Pivot Tables - VBA- What you Need to Know Video
biuv24tnkrnfm4n3rb00.mp4
5. Activity- Update Existing Formulas with VBA by Adding IFERROR Text
Activity- Update Existing Formulas with VBA by Adding IFERROR.html
6. Project- Update Existing Formulas with VBA by Adding IFERROR Video
biuv1dtnkrnfm4n3rau0.mp4
7. Key Takeaways- -Pivot- Tables - Formulas Text
Key Takeaways- -Pivot- Tables - Formulas.html
14. Main Project -2- Sales Regional Reporting Tool
1. What You-ll Learn in this Project Video
biuv2a1ujavq7bbf43ig.mp4
2. Project Overview- Regional Sales Reporting Tool Video
biuv2e9ujavq7bbf43j0.mp4
3. Importing Data from Multiple Files using MultiSelect Video
biuv2l9ujavq7bbf43jg.mp4
4. Setting up a Template as the Basis for Different Reports Video
biuv319ujavq7bbf43l0.mp4
5. Exporting Reports as Excel files Video
biuv369ujavq7bbf43m0.mp4
6. Fine-tuning Report Export Procedure Video
biuv39pujavq7bbf43mg.mp4
7. Setting up Automatic Export of Text File Video
biuv3dhujavq7bbf43ng.mp4
8. Track the List of Tasks Completed with VBA Video
biuv3hhujavq7bbf43o0.mp4
9. Final Touches - Creating Interface to Hide Specific Tabs with a Password Video
biuv3l9ujavq7bbf43og.mp4
10. Key Takeaways- VBA-based Excel Tools Video
biuv3n5nkrnfm4n3rb20.mp4
11. Second Milestone Completed- Text
Second Milestone Completed-.html
15. Interacting with Other Applications -Word- PowerPoint etc.-
1. Overview- Interacting with Other Applications Video
biuv3rpujavq7bbf43pg.mp4
2. PDF- Save Specific Sheets as a PDF File Video
biuv3vlnkrnfm4n3rb2g.mp4
3. Email- Automatically Create Personalized Emails with Attachments Video
biuv42dnkrnfm4n3rb3g.mp4
4. Microsoft Word- Create Personalized Letters in Word from Excel Video
biuv46dnkrnfm4n3rb4g.mp4
5. Microsoft PowerPoint- Export Excel Sheets to PowerPoint Presentation Video
biuv4cdnkrnfm4n3rb5g.mp4
6. Key Takeaways- Working with Other Applications Text
Key Takeaways- Working with Other Applications.html
16. Workbook and Worksheet Events
1. Overview- Event Procedures Video
biuv4jpujavq7bbf43r0.mp4
2. Workbook Events- Toggle Full Screen -Activate- Deactivate- Open- Close- Video
biuv4opujavq7bbf43s0.mp4
3. Worksheet Selection Change- Dynamic Font Color of Selected Range Video
biuv4q1ujavq7bbf43sg.mp4
4. Refresh PivotTables Automatically - Concept of Range Intersection Video
biuv4vhujavq7bbf43t0.mp4
5. Resetting a Dependent Drop-down when the first Drop-down is Changed Video
biuv52dnkrnfm4n3rb6g.mp4
6. Activity- Link Page Header to Cell Value -BeforePrint Event- Text
Activity- Link Page Header to Cell Value -BeforePrint Event-.html
7. Project- Link Page Header to Cell Value -BeforePrint Event- Video
biuv571ujavq7bbf43ug.mp4
8. Key Takeaways- Workbook - Worksheet Events Video
biuv589ujavq7bbf43v0.mp4
17. Working with Userforms - ActiveX Controls
1. Overview- UserForms - ActiveX Controls Video
biuv5e5nkrnfm4n3rb70.mp4
2. ActiveX Controls- What you Need to Know Video
biuv5g1ujavq7bbf4400.mp4
3. ActiveX Check Box to Fix Scroll Area - Toggle Screen Settings Video
biuv5ipujavq7bbf440g.mp4
4. ActiveX to Show and Hide Help Video
biuv5l1ujavq7bbf4410.mp4
5. ActiveX Combo Box for Easy Sheet Navigation Video
biuv5ohujavq7bbf4420.mp4
6. ActiveX to Show or Hide Other ActiveX controls Video
biuv5shujavq7bbf442g.mp4
7. UserForm Basics- What You Need to Get Started Video
biuv63dnkrnfm4n3rb7g.mp4
8. UserForm for Data Entry -Input - Check Boxes- Video
biuv685nkrnfm4n3rb8g.mp4
9. Practical UserForm to Document External Links - Comments -Combo Box - Option button- Video
biuv6f9ujavq7bbf4430.mp4
10. BONUS- ListBox to Print Multiple Pages at Once Video
bn8bd4a9c233ls0jkbvg.mp4
11. UserForm Checklist - Course Map Status Text
UserForm Checklist - Course Map Status.html
18. Main Project -3- Invoice Generation Tool
1. Tool Overview- What You Will Learn Video
biuv6thujavq7bbf444g.mp4
2. Setting up an Input UserForm to Collect Master Data Video
biuv73dnkrnfm4n3rb9g.mp4
3. Working with Multi-Column ListBoxes Video
biuv6q5nkrnfm4n3rb90.mp4
4. Edit Master Data with UserForm Video
biuv76hujavq7bbf445g.mp4
5. Searchable ListBox -with Selection Change event- Video
biuv7apujavq7bbf4460.mp4
6. Enhanced Searchable ListBox- Write Selection back to Excel Table Video
biuv7gdnkrnfm4n3rbag.mp4
7. MultiPage UserForm to Create Invoices - Email -Setup- Video
biuv7ntnkrnfm4n3rbb0.mp4
8. Export PDF - Excel Workbook for Each Invoice based on ListBox Selection Video
biuv80hujavq7bbf4470.mp4
9. Create Email in Outlook - Attach PDF Invoice Video
biuv85tnkrnfm4n3rbd0.mp4
10. Final Updates - Debugging Video
biuv8flnkrnfm4n3rbeg.mp4
11. Last Milestone Completed- Text
Last Milestone Completed-.html
19. Create your own Custom Functions
1. Overview- Function Procedures Video
biuv8npujavq7bbf4480.mp4
2. Setting up a Simple Function -including Optional Arguments- Video
biuv8q5nkrnfm4n3rbfg.mp4
3. Function to Calculate Age -Result in Years - Months- Video
biuv8stnkrnfm4n3rbg0.mp4
4. Functions that Split Text and Numbers from Cell Value Video
biuv901ujavq7bbf448g.mp4
5. Using Functions in Sub Procedures Video
biuv92lnkrnfm4n3rbgg.mp4
6. Activity- Function That Sums based on Cell Color Text
Activity- Function That Sums based on Cell Color.html
7. Project- Function That Sums based on Cell Color Video
biuv8mdnkrnfm4n3rbf0.mp4
8. Key Takeaways- Function Procedures in VBA Text
Key Takeaways- Function Procedures in VBA.html
20. Working with Charts
1. Overview- The Chart Object Library Video
biuv9c5nkrnfm4n3rbh0.mp4
2. Create and Modify a Chart with VBA Video
biuv9gtnkrnfm4n3rbhg.mp4
3. Animated Charts- Different Methods Video
biuv9k1ujavq7bbf4490.mp4
4. Show Charts inside UserForms Video
biuv9ppujavq7bbf449g.mp4
5. Key Takeaways- VBA Charts Text
Key Takeaways- VBA Charts.html
22. Final Assessment - Next Steps
2. Share the love- Text
Share the love-.html
3. Next Steps Text
Next Steps.html
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch [Maven Analytics] Excel Courses (2021) [En] Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
