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…
Here is how to stop text overflow to the next Excel columns in 3 easy steps. The problem usually appears if you have a table that contains lengthy text and the column on the right contains empty cells. The result looks poorly formatted.
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.
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.
Here is how to connect to the PostgreSQL database with Excel or Power BI using the ODBC data source.
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.
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.
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.