Please note javascript is required for full website functionality.

Excel Virtually Global - Presentation Handouts

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 .pdf 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 .pdf 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

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 .pdf 2.4 MB

Most Comprehensive Excel Example. Ever. - Liam Bastick

File Name File Type Size
Best Excel Example Ever .pdf 1.8 MB
Dynamic Lables .pdf 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

Newsletter