Instructions
Thank you for participating in Excel Virtually Global. Here you can download the handouts for the presentations.
Cheating with Charts - Jon Peltier
| File Name | File Type | Size |
|---|---|---|
| Cheating with Charts | .xlsx | 613 KB |
Plebs vs Pros: How to Look Like You Use Excel for a Living - Tim Heng
| File Name | File Type | Size |
|---|---|---|
| Pleb vs Pros - model start | .xlsx | 13 KB |
Mind-blowing PowerPoint for Effective Visual Storytelling - Richard Goring
| File Name | File Type | Size |
|---|---|---|
| Mind-blowing PowerPoint Summary | 1.3 MB |
The Sultry Six: An Affair with all 6 Joins in Power Query - Oz du Soleil
| File Name | File Type | Size |
|---|---|---|
| 00 Sultry Six | 4.7 MB | |
| 01 All 6 Joins | .xlsx | 2.1 MB |
| 02 XLOOKUP vs Outer Join | .xlsx | 2.1 MB |
| 03 Joins - 2 Criteria | .xlsx | 2.1 MB |
| 04 Reference Table | .xlsx | 2.2 MB |
| 05 Challenge - Who Has No Car | .xlsx | 2.1 MB |
| 06 Challenge - Reimbursements | .xlsx | 2.1 MB |
Mapping Data with Excel - Bill Jelen
| File Name | File Type | Size |
|---|---|---|
| 01-Mapping Data | .xlsm | 5 MB |
| 02-3DMapsNavigating | .xlsm | 612 KB |
| 04-MapTypes | .xlsm | 590 KB |
| 06-FlightData | .xlsm | 206 KB |
| 07-HomeData | .xlsm | 1.8 MB |
| 08-CustomMap | .xlsm | 488 KB |
| 09-CreatingATour | .xlsm | 681 KB |
| MappingDataWithExcel | .pptx | 4.1 MB |
Building Excel Chart Worksheet Templates - Dave Paradi
| File Name | File Type | Size |
|---|---|---|
| Additional Resources for Creating Excel Chart Worksheet Templates | 215 KB |
Building Faster Excel Solutions - Charles Williams
| File Name | File Type | Size |
|---|---|---|
| Building Faster Excel Solutions | .pptx | 3.9 MB |
| Match_Find_Variant2 | .xlsm | 4.7 MB |
| VBA_1 | .xlsm | 705 KB |
| VBAProfile | .xlsx | 25 KB |
| VLinterp | .xlsb | 255 KB |
The Magic of Data Validation - Nabil Mourad
| File Name | File Type | Size |
|---|---|---|
| The Magic of Data Validation | .xlsx | 64 KB |
| The Magic of Data Validation - eBook | 2.4 MB |
Most Comprehensive Excel Example. Ever. - Liam Bastick
| File Name | File Type | Size |
|---|---|---|
| Best Excel Example Ever | 1.8 MB | |
| Dynamic Lables | 1.5 MB | |
| Examples of Chart Stuff | .xlsx | 45 KB |
| SP Dynamic Data Validation | .xlsm | 221 KB |
| SP Formatted Chart Data Labels | .xlsx | 63 KB |
| SP OFFSET Examples - Editable | .xlsx | 113 KB |
| SP OFFSET Examples | .xls | 286 KB |
Creating the Ultimate Dynamic Crosstab Report with Array Formulae - Roger Govier
| File Name | File Type | Size |
|---|---|---|
| Ultimate Dynamic Crosstab Report | .pptx | 2.8 MB |
| Building Blocks | .xlsx | 246 KB |
| Ultimate Dynamic Crosstab Report | .xlsx | 549 KB |
Smart Macro Recording - Jan Karel Pieterse
| File Name | File Type | Size |
|---|---|---|
| Smart Macro Recording | .pptx | 3 MB |
| Smart Macro Recording Blank | .xlsm | 30 KB |
| Smart Macro Recording Result | .xlsm | 39 KB |
| Smart Macro Recording Result Edited | .xlsm | 41 KB |
Office Scripts - Sudhi Ramamurthy
| File Name | File Type | Size |
|---|---|---|
| Office Script - Virtually Global | .pptx | 11.6 MB |
