Skip to content

Content Tagged "excel"

Page 1 of 1

Change Decimal Comma to Dot in Excel Mac

March 3, 2016Categories: IT, Tutorial
TL;DR : There are two things you can do: Change in Language & Region -> Advanced... When converting a text to columns, you can specify the delimiter ( Step 3 of 3 -> Advanced... ) Regional settings The regional settings will affect all applications, not only Excel. Here you can specify the…

Punchcard-ish Graph from Google Analytics Data

March 18, 2015Category: IT
The other day I wanted to see when users are actually using my website. The most obvious way (to me) is to have a github-like punchcard graph. My alternatives were to either write a program or use Excel. To cut a long story short, I chose to use Excel. If you have enough users, Google is enabling…

Excel - Check if item exists in another column

January 20, 2014Category: Software
The other day I had to create a "diff" between two lists in excel. More exactly, I had to verify which emails were missing between two lists of emails. Solutions I could find two solutions to this problem, which are listed below. For both, I'll assume that columns A and B contain the two lists…

All tags