Why Every Finance Professional Should Learn Power BI (not just Excel)
Discover how Power BI helps Finance professionals automate reports, boost efficiency and uncover deeper business insights beyond Excel
Tag Efficiency
Power BI Solves the Business Continuity Problem
The business continuity problem is what happens when key spreadsheets that drive business critical reports are maintained by individual employees and then the issues that follow when those employees are out of the business. Power BI can solve this problem!
How to use Date.IsInNextMonth in PowerQuery
The easiest way to dynamically identify dates that are in the following month in Power Query is to use the function Date.IsInNextMonth. We learn how to use the function in this post.
How to Find White Text in Excel
How to find White text in Excel files My SUM formula doesn’t match the total value of the cells. I can’t find some of the values in a formula. I’m a reviewer or auditor and I need to check there’s…
Trace Precedents and Trace Dependents
Trace Precedents and Trace Dependents If I change the value of this cell, how do I know which cells it will affect in my workbook? I’m in the formula bar and I want to quickly find the cells that make…
What’s the big advantage in using the Sharepoint Folder connector in Power BI?
1 BIG reason to use the Sharepoint Folder connection in Power BI What’s the main advantage to using the Sharepoint Folder connector in Power BI? BUSINESS CONTINUITY. The ability for essential reporting to carry on in a business while key…
Tips to move quickly round your Excel spreadsheet
Use Control to move quickly round your Excel spreadsheet When it comes to Excel, every little helps in saving time. A really easy and very effective way to save time and be more efficient is by using keyboard shortcuts and…
You must be logged in to post a comment.