## Lecture 5 – Number formats, dates and time in Excel

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

## Lecture 6 – Cell references and named ranges in Excel

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

## Lecture 7 – Tables, sorting and filtering in Excel

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

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

Creating and Android app has been in my task list a good whil but now I decided to take the pivotal step. How long would it take?

## Sports betting tutorial – Can you make the living?

You can make the living by sports betting. The blog is not sponsored as I’m sharing my own experiences. Read the tutorial.

## 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 is a fresh and simple mobile application to split costs. Read experiences to see whether you should download it too.

## Virus problem – A statistical puzzle

The problem: A virus is spreading across the world – it kills without treatment. Your task is to solve a statistical puzzle.

## Introduction to Excel Power tools

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

## Alice Springs to Darwin by car

The trip from Alice Springs to Darwin was full of adventure. Sand and dust had changed to thermal pools, waterfalls and tropical plants.

## A deadly formula – Uluru, Kata Tjuta and Kings Canyon

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 […]

## Open job application – Hire an IT consultant

Open job application: I’m looking for a job in IT consulting so I swithed recruiting roles. See my awsome application video!

## 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.

## One-way ticket – Traveling around the world

Traveling around the world without a truck load of money and humongous preparations? It is possible.

## Django tutorial – For data oriented web developers

Python based Django web framework offers a great platform to create a data oriented web application for any size of needs.

## Fed Up, Stephanie Siechtig (2014)

The truths that Fed Up documentary revealed were shaking indeed. The food industry is controlling us more than you think.

## Insight 2016: My lesson of leadership and management

Insight 2016 was a speaker event organized under Tampere ES. I got great learnings from project and event management.

## Moneyball, Michael Lewis – Think outside of the box

The big idea of the book is the team management by data and statistics rather than no-sense opinions. This approach revolutionized the game.

## Think Like a Freak, Steven Levitt & Stephen Dubner – A guide to creative thinking

Think Like a Freak – A book review about out-of-the-box thinking. Creative thinking start from an empty table.