# 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 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.

## 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.

## 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.