Excel Archives - Data Cornering

by Janis Sturis October 11, 2021 Comments0

Add custom button with a shortcut to Excel file in Power BI report

When the Power BI report is not enough, here is how to add an interactive button as a shortcut to the Excel file…

by Janis Sturis September 21, 2021 Comments0

Excel

For me, the most annoying thing about Excel charts are is the inability to resize elements automatically. Usually, it happens after mild corrections…

by Janis Sturis September 6, 2021 Comments0

At this moment, there is no built-in color picker in Power BI or Excel, but here is how to use eyedropper PowerPoint. Eyedropper…

by Janis Sturis August 25, 2021 Comments0

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…

by Janis Sturis August 20, 2021 Comments0

Excel

Here is how to stop text overflow to the next Excel columns in 3 easy steps. The problem usually appears if you have…

by Janis Sturis July 8, 2021 Comments0

Here is one of the easiest ways to connect to the Power BI dataset with Excel to use it in PivotTable. First of…

by Janis Sturis June 14, 2021 Comments0

Excel

Excel is one of the most popular tools to work with data with more than 400 different functions. Some of them are great…

by Janis Sturis February 22, 2021 Comments0

There is R base function like weekdays that can return the name of the weekday. But what if you want to get the…

by Janis Sturis January 15, 2021 Comments0

Here is how to connect to the PostgreSQL database with Excel or Power BI using the ODBC data source.

by Janis Sturis December 21, 2020 Comments0

Excel

Here is a time-saving tip on how to copy an Excel chart format. It is not so easy as Format Painter that can…