Excel Archives - Page 4 of 6

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… Continue reading Pac-Man (two slice pie) chart in Excel, rotate Excel pie chart slice

Stop text overflow into next Excel columns

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.

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… Continue reading Grouped and ungrouped PivotTable column problem in Excel file

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.