Adding titles and labels to graphs in R using plot() function
Adding titles to plot() graphs in R is quite straight forward. In this post I will explain how to do it. Example 1: The function used here is as follows: plot(cars, main = “Car...
Category: Data Visualization
Summing amounts in Excel depending on multiple conditions using SUMIFS
Do you have a set of data in Excel and you want to sum a certain amount depending on multiple conditions? Then you can use the function SUMIFS. I’ll give you an example to...
Counting items in Excel with multiple conditions using COUNTIFS
Do you have a set of data in Excel and you want to count a certain number of items that comply multiple conditions? Then you can use the function COUNTIFS. I’ll give you an...
Excel IF function with multiple conditions using the OR function
How to use the IF function if you need to pass multiple conditions over different cells. Let’s say we have an online T-shirt shop and we have a spreadsheet with sales data. We want...
How to change your locale settings in Excel 2016
Have you also had this problem where your financial data seems messed up and does not have the correct values? One thing to check are your locale settings when you import your data from...
Add this data to the Data Model check box is greyed out in Excel 2016
A problem I ran into when creating a new query in my freshly installed Microsoft Excel 2016 was that I could not import data to the Data Model. This is set in the ‘Load...
