mikaelahonen.com website has been renewed! Read more.
EN FI SV
Excel Power Map is designed to visualize spatial data. Watch the demo video about visualizing annual asylum seeker data.

Excel Power Map - Spatial data visualization as a time series

Excel Power Map is designed to visualize spatial data. The tool is also known as Excel 3D Map. Watch my Power Map demo video from Solita’s blog here .

Unpivoting columns to rows with Excel PowerQuery. Watch 30 seconds video how to do it without any formulas.

Unpivot columns to rows with Excel PowerQuery

A while ago I got asked what is the easiest way to transform columns to rows in Excel. An example of this problem is shown in the picture above.

NaN

Parsing first name, last name and company from email in Excel - Download Excel template

Parsing first name, last name and company from email in Excel Do you have a list of emails that you want to split by first name, last name and company domain?

The free Excel course. Compact video lectures with exercise materials for training. The lectures have an optimal order for learning.

The Free Excel Course Online

The free Excel course - Introduction Watch the first lecture as an example. Other lectures can be found below. Excel course lectures Lecture 8 - String functions and advanced formulas in Excel Lecture 7 - Tables, sorting and filtering in Excel Lecture 6 - Cell references and named ranges in Excel Lecture 5 - Number formats, dates and time in Excel Lecture 4 - Copy and paste in Excel Lecture 3 - The Basics of Excel Formulas Lecture 2 - Formatting Cells in Excel Lecture 1 - Introduction to Excel The free Excel course benefits Training videos: High quality training videos Training materials: Download the training materials for each lecture Learning: The order of lectures has been optimized by an Excel expert Is the Excel course really free?

Introduction to Microsoft Excel. What is workbook and worksheet? How to add and delete worksheets? Where to save and open Excel files?

Lecture 1 - Introduction to Excel

Back to Excel course main page Introduction to Excel Quick glance to the Microsoft Excel software. What is workbook and worksheet?

Learn how formatting cells in Excel works. Change font color, autofit column width, merge cells and use bold text and bordered cells.

Lecture 2 - Formatting Cells in Excel

Back to Excel course main page Formatting cells in Excel Learn how to formatting cell in Excel works. Change font color, autofit column width, merge cells and use bold text and bordered cells to enhance the final result.

In the Excel formula basics lecture we'll first mix numbers and text to create generic sentences and then we use SUM and IF.

Lecture 3 - The Basics of Excel Formulas

Back to Excel course main page The Basics of Excel Formulas In the basics of Excel formulas lecture we’ll first mix numbers and text to create generic sentences from the observations and try simple mathematical operations.

It's possible to paste only specific components of you data such as formulas, values or formattings. Make you workbook great again.

Lecture 4 - Copy and paste in Excel

Back to Excel course main page Copy and paste in Excel Contrary to what you might think copy and paste functionality is one of the key skills in your Excel toolbox.

Number formats allow you to preserve the original cell value while displaying it as percentage, currency, date or time format.

Lecture 5 - Number formats, dates and time in Excel

Back to Excel course main page Number formats, date and time in Excel Number formats allow you to preserve the original cell value while displaying it in another format such as percentage, currency, date or time format.

Excel cell references are important part of formulas. Learn the difference between the absolute and relative reference.

Lecture 6 - Cell references and named ranges in Excel

Back to Excel course main page Cell references and named ranges in Excel Relative and absolute cell references are needed when you copy and paste formulas.

In Excel's table object you can sort, filter and summarize data effortlessly as well as select the formatting that fits your needs.

Lecture 7 - Tables, sorting and filtering in Excel

Back to Excel course main page Tables, sorting and filtering in Excel Table objects have a few essential advanteges compared to normal cells.

Excel has a set of powerful text manipulation formulas. In this lecture you will learn to apply SUBSTITUTE(), MID(), FIND() and LEN().

Lecture 8 - String functions and advanced formulas in Excel

Back to Excel course main page String functions and advanced formulas Excel has a set of powerful text manipulation formulas.

Excel Power BI lisäosien perheeseen kuuluvat Power Query, Power Pivot, Power Map ja Power View nopeassa esittelyssä.

Introduction to Excel Power tools

Next I will introduxe briefly how Power tools in Microsoft Excel Power BI family are related to each other. That way you quickly realize whether they fit in your needs or not.