Combining machine learning and business – Practical example
Finally I managed to publish my blog post with the topic A Machine Learning Example For Business. I had noticed that there’s huge demand […]
Unpivot columns to rows with Excel PowerQuery
Unpivoting columns to rows with Excel PowerQuery. Watch 30 seconds video how to do it without any formulas.
Csv headers to list using Python
Python code to automatically list header fields of multiple CSV files. The original use case was related to data warehouse documentation.
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 […]
A nation that seized the time – Lesotho – Around the world trip days 23.1.2017 – 29.1.2017
Lesotho is a nation that time feels to be seized in. As the Grande finale of my trip I did a real grand old man of all hikes.
Robberies in South Africa – Around the World Trip Days 9.1.2017 – 21.1.2016
This article is part of the series about around the world trip. Click to see all blogs from the around the world trip. You can […]
Google Keep vs Evernote – Requirements for your note app
Personally, I use a note app to store ideas, observations, travel tickets and debts that should be quickly accessible.
Cape Town – Around the World Trip Days 31.12.2016 – 8.1.2017
The top attraction of Cape Town were beautiful Table Mountain and the Cape of Good Hope. The society has it problems, though.
From the Edge of the World to the Devil’s throat – South America – Around the World Trip Days 14.12.2016 – 29.12.2016
Second part from South America. The nature pics are worth seeing! I also made a bus ticket seller so angry that I got in trouble.
Toggl – Recording work hours to log has never been such enjoyable
Toggl is a mobile app for work hour recording and management. Toggl is not great because of the uniqueness but simplicity.
Traveling through Patagonia – Around the world trip days 30.11.2016 – 14.12.2016
This time I was totally alone. Once again I had no plans prepared and the plane would land in a few hours to Buenos Aires, Argentina.
Hidden brain – Shankar Vedantam, NPR – When you want to know how the world works
Podcast about society. Examples of topics: climate change, crime, women in leading positions and how is it like being rich?
Does it make sense anymore to buy Christmas presents?
Christmas is the festival of joy but buying presents is not so easy. Purchasing presents has became a social compulsion.
Freakonomics Radio, Stephen Dubner – Exploring the hidden side of everything
The best podcast series on my opinion. The podcasts last typically from 30 to 60 minutes and during that time they try to find an […]
A place like a story book – New Zealand – Days 19.11.2016 – 30.11.2016
The whole country was like a painting. Let’s start with a mellow video of the jump to chilly mountain stream in New Zealand.
This is how I make my every second productive
Power methods for knowledge workers to get your productivity to the next level: Technology, Ergonomy, Work habits and Task automation.
Happiness Tips, Chris Croft, LinkedIn Learning
I didn’t have high expectations for this happiness video course based on my previous experiences. But this video course happily surprised me!
Work stress that shouldn’t exist – Newcastle, Australia -Around the World Trip Days 11.10.2016 – 18.11.2016
11.10.2016-11.11.2016. Work stress. If I would be planning a torture chamber to a medieval castle I would contact Tiger Air company for sure.
Hated by everybody Trump got the second highest number of votes and became the President of USA – This is out of the box thinking
Sometimes pure logic leads to better results than the actual ideology. What is out of the box thinking and how does it relate to Donald Trump’s victory?
The Free Excel Course Online
Katso ensimmäinen oppitunti esimerkiksi. Muut oppitunnit löytyvät alta.
Lecture 1 – Introduction to Excel
Workbook, worksheet, saving, opening and options in Excel.
Lecture 2 – Formatting Cells in Excel
Change font color, autofit column width, merge cells, use bold text and set borders.
Lecture 3 – The Basics of Excel Formulas
A brief introduction how to compose your first Excel formula.
Lecture 4 – Copy and paste in Excel
Copy and paste only values, formulas or formattings in Excel.
Lecture 5 – Number formats, dates and time in Excel
Learn different number formats as well as Excel’s date and time system.
Lecture 6 – Cell references and named ranges in Excel
How to do absolute and relative references and name ranges.
Lecture 7 – Tables, sorting and filtering in Excel
Sort, filter and summarize easily with Excel table objects.
Lecture 8 – String functions and advanced formulas in Excel
Excel has a set of powerful text manipulation formulas. In this lecture you will learn to apply SUBSTITUTE(), MID(), FIND() and LEN().
Creating my first Android app – How long it takes?
Yes. It’s me in the picture. It was Halloween. Creating and Android app has been in my task list a good while but now I […]
Sports betting tutorial – Can you make the living?
It is actually possible to make your living by doing sports betting. This blog is not sponsored – these are my own experiences. Betting – […]
Visualization and clustering of eartquake dataset
The built-in dataset quakes in RStudio had 1000 records of earthquakes nearby Fiji. The first year of observations is 1964 but the last year remains […]
Splitwise – Split costs easily
Splitwise solves a traditional problem that exists in every single group of friends – how to split costs easily. Need to split costs? In Splitwise you […]
Wunderlist – Simple and reliable task list
After testing multiple todo list I dare to announce Wunderlist as the simplest one with just right amount of features. You can categorize tasks to folders and […]
Virus problem – A statistical puzzle
This imaginary problem does not rely on any real situation. A virus is spreading across the world – it kills without treatment. A medicine does exist […]
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 […]
Alice Springs to Darwin by car – Around the World Trip Days 30.9.2016 – 10.10.2016
The story is part of the around the world blog series. Click to see all posts from the around the world trip. 30 Sep 2016 – […]
A deadly formula – Uluru, Kata Tjuta and Kings Canyon – Around the World Trip Days 27.9.2016 – 29.9.2016
The story is part of the around the world blog series. Click to see all posts from the around the world trip. Routinely I pull my […]
Open job application – Hire an IT consultant
Open job application This open job application is valid until 31.12.2016. Contact me to arrange a meeting: LinkedIn or mikael.ahonen@hotmail.com. I have already been in a […]
Data science and business intelligence – Definitions
It’s easy to spot these hype terms like data science, big data in LinkedIn or exhibition posters. I summarized the definitions of most frequently used […]
One-way ticket – Traveling around the world
The story is part of the around the world blog series. Click to see all posts from the around the world trip. What would you do […]
Django tutorial – For data oriented web developers
Django is a web framework for Python programming language which in practise means well designed folder structure and pre-made class modules for most common functionalities in […]
Fed Up, Stephanie Siechtig (2014)
Even the movie poster says it: decision makers and food industry are totally of the track when it comes to healthy nutrition. Money talks. Fed Up […]
Insight 2016: My lesson of leadership and management
February 2015. After a successful Excel training for students I got an idea for a new event concept. I’m encouraged by other student-organized lectures that relate […]
Moneyball, Michael Lewis – Think outside of the box
The book is about a baseball player Billy Beane who didn’t fulfill the exceptions as a MLB player but later became the general manager of […]
Think Like a Freak, Steven Levitt & Stephen Dubner – A guide to creative thinking
Even though the book doesn’t define itself with these words the most important theme is so called out of the box thinking. So how […]