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…
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…
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…
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…
Set Excel file read-only MS Teams, OneDrive, or SharePoint
Here is how to set Excel file read-only when using in MS Teams, OneDrive, or SharePoint. Those environments are different in the possibilities…
Difference between DAX and Excel functions that looks the same
If you know Excel functions, it is easier for you in Power BI with DAX. Sometimes it is mentioned as an advantage. It…
Convert TRUE and FALSE values to 1 and 0 in Excel
Here is a simple trick that is not so obvious. By adding two minus signs before calculation, you can convert TRUE, FALSE into…
Clustered and stacked columns in one Excel chart – 5 easy steps
If you want to create an Excel chart that contains clustered columns and stacked columns altogether, this post is for you.
How to close EXCEL.EXE from Windows command line
In the last days, I was running into a problem that even all Excel files are closed bunch of EXCEL.EXE processes still running.…