How to learn Excel?
  • The New Excel Learning Curve
Lesson 1. Power Map 3D
  • 1.1. My first 3D map
  • 1.2. Stacked column chart in 3D Map
  • 1.3. Pie chart in 3D Map
  • 1.4. Heatmap in 3D Map
  • 1.5. Filled map in 3D Map
  • 1.6. Show changes over time in 3D Map
  • 1.7. Show distinct count
  • 1.8. Export 3D Map to a presentation
  • 1.9. 3D Map with Power Pivot
  • 1.10. DYI: Power Map 3D
Lesson 2.Working with addresses in 3D Map
  • 2.1. Automatic geocoding
  • 2.2. Manual geocoding
  • 2.3. Batch geocoding using Power Query and Here Maps
  • 2.4. DYI: Working with addresses in 3D Map
Lesson 3. Other ways to create a map in Excel
  • 3.1. Filled map in Excel 365
  • 3.2. Bing Maps for Excel
  • 3.3. Custom shapes in 3D Map on the example of Europe NUTS map
  • 3.4. Maps-for-Excel.com Excel World Map (for free)
  • 3.5. Custom background in 3D Map
  • 3.6. Custom background in Maps-for-Excel.com Map (for free)
  • 3.7. DYI: Other ways to create a map in Excel
Lesson 4. Maps in Power B
  • 4.1. Filled map in Power BI
  • 4.2. Bubble map in Power BI
  • 4.3. Hierarchy on a bubble map in Power BI
  • 4.4. Heatmap in Power BI
  • 4.5. ArcGIS map in Power BI
  • 4.6. DYI: Maps in Power BI
Lesson 5. Examples of map projects in Excel & Power BI
  • 5.1. How to create your custom regional division?
  • 5.2. How to create a map on a custom background in Power BI?
  • 5.3. How to calculate the distance between 2 locations?
  • 5.4. How to find the nearest postcode?
  • 5.5. How to show flows and routes on the map?
  • 5.6. How to combine postcodes (on the example of IQVIA pharma bricks)?