You can find the article from Solita’s data related blog site data.solita.fi. Finally I managed to publish my blog post with the topic A Machine […]
Unpivoting columns to rows with Excel PowerQuery. Watch 30 seconds video how to do it without any formulas.
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 Do you have a list of emails that you want to split by first […]
Personally, I use a note app to store ideas, observations, travel tickets and debts that should be quickly accessible.
Toggl is a mobile app for work hour recording and management. Toggl is not great because of the uniqueness but simplicity.
Katso ensimmäinen oppitunti esimerkiksi. Muut oppitunnit löytyvät alta.
Workbook, worksheet, saving, opening and options in Excel.
Change font color, autofit column width, merge cells, use bold text and set borders.
A brief introduction how to compose your first Excel formula.
Copy and paste only values, formulas or formattings in Excel.
Learn different number formats as well as Excel’s date and time system.
How to do absolute and relative references and name ranges.
Sort, filter and summarize easily with Excel table objects.
Excel has a set of powerful text manipulation formulas. In this lecture you will learn to apply SUBSTITUTE(), MID(), FIND() and LEN().
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 […]
It is actually possible to make your living by doing sports betting. This blog is not sponsored – these are my own experiences. Betting – […]
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 solves a traditional problem that exists in every single group of friends – how to split costs easily. Need to split costs? In Splitwise you […]
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 […]
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 […]
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 […]
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 […]
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 […]