What you will learn

Learn how to create and analyse maps in many different ways – in Excel and Power BI

If you are new to maps, there are full videos at your disposal where I go through the different charts and options step by step.

I also talk a lot about pitfalls and problems that are not lacking in working with maps.

Maps are not free from problems and errors (e.g. in the process of geocoding). In the course you will learn what to watch out for.

Description

Free course for Excel and Power BI users interested in map reports. If you’re new to maps, there are full-length videos that give you a step-by-step overview of how different charts and options work. I also talk a lot about pitfalls and problems that are not lacking in working with maps.

7 reasons why you should take the course

  1. Lots of tools – In the course, I show all the options related to maps in Excel and Power BI.

  2. The practical nature of the tasks – Most of the scenarios created life – customers and readers asked about it.

  3. Full downloads – Below you will find a full set of downloadable materials that you can use however you want. Moreover, there are some extra tools to make your job easier.

  4. Tool traps – Maps are not free from problems and errors (e.g. in the geocoding process). In the course you will learn what to watch out for.

  5. Excel 365 news – I recorded the course in 2020 and used new charts such as the Kartogram. Moreover, the course will be constantly updated with what’s new in Excel.

  6. Examples of projects – In the course, I share examples of projects completed for various clients.

  7. Only proven and practical advice – Tasks for self-completion

Who is the course for?


Get Instant Notification of New Courses on our Telegram channel.


  • The course is aimed at both beginners and advanced users of Excel. Anyone interested in maps and Excel will find something for themselves here.

  • From my experience, the course will be especially useful in the following departments: sales, logistics, controlling, finance, planning, analysis, production (plant and product maps) and many others.

  • If you are interested in a particular tool, you can only find the lessons that are relevant to it.

English
language

Content

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)?