How to add legend title in Excel chart
At this moment, there is no default and easy way how to add a legend title in an Excel chart. The good news…
How to create a glowing line chart in Excel
Besides creating a glowing line chart in Excel, here is a possible solution how to deal with seemingly too many series in one…
3 ways how to copy from R to Excel or from Excel to R
There might be useful to copy from R to Excel or vice versa, and here is how to do that. Of course, Excel…
7 tips on how to speed up filtering in Excel
In large Excel spreadsheets, auto filters might work slowly and periodically crash. Here are 7 tips on how to speed up filtering in…
Calculate weighted average in Excel PivotTable in 2 ways
Here are a few methods on how to calculate the weighted average in Excel PivotTable or DAX. It is not so simple as…
How to connect to the Salesforce data with Power Query, Power BI, Excel
Here is how to connect to the Salesforce data with Power Query in Excel or Power BI. For the Salesforce CRM data exploration,…
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…
How to reset Excel chart plot area formatting
For me, the most annoying thing about Excel charts are is the inability to resize elements automatically. Usually, it happens after mild corrections…
Color picker for Power BI or Excel
At this moment, there is no built-in color picker in Power BI or Excel, but here is how to use eyedropper PowerPoint. Eyedropper…
