Category: Excel
Pac-Man (two slice pie) chart in Excel, rotate Excel pie chart slice
If your data contains two categories, don’t miss a chance to create a Pac-Man chart in Excel. It might not work all the time, but if one category is between 15-25%, then your two slice pie chart might be looking similar to famous gaming hero Pac-Man. There might be several creations in the process of…
How to connect to Power BI dataset with Excel
Here is one of the easiest ways to connect to the Power BI dataset with Excel to use it in PivotTable. First of all, you or other users should have access to the dataset. If you are the owner of the dataset, then that is not a problem but might be necessary for others.
How to calculate ISO week number and ISO year in Excel
Excel is one of the most popular tools to work with data with more than 400 different functions. Some of them are great to calculate ISO week number in Excel, but ISO year is not so easy.
Day of the week number in R
There is R base function like weekdays that can return the name of the weekday. But what if you want to get the day of the week number in R to do calculations? Here is how to do that by using one of the most popular R packages.
How to connect to PostgreSQL database with Excel or Power BI
Here is how to connect to the PostgreSQL database with Excel or Power BI using the ODBC data source.
How to copy Excel chart format
Here is a time-saving tip on how to copy an Excel chart format. It is not so easy as Format Painter that can quickly copy necessary cell formatting, but faster than starting from scratch.
Grouped and ungrouped PivotTable column problem in Excel file
If you are using multiple PivotTables from the same data source, then there might be a problem (ungrouped PivotTable problem). The same column doesn’t work in a grouped and ungrouped state. At the moment, you are ungrouping grouped columns in other PivotTable, the same happening in other PivotTable. Here is how to change grouping in…
Calculate weighted AVERAGE in Excel
If you are looking for a weighted AVERAGE in Excel, I think you already know why. Here is an example of how to calculate it.
Start every string with a capital letter in R
If you want to start every string with a capital letter in R, you should know a reliable function that works in every situation. Same as the PROPER function in Excel. Of course, it is possible to write your R functions, but sometimes it is not worth the effort.
