Power BI for the Excel Analyst (2022)
If you want to start using Power BI and you are an Excel user then this is great book to start with.
It will give you the basics plus it explains lots of “gotcha” issues you can avoid when starting out.
Power BI is powerful but it is also complex and always evolving. This book will get you started. Highly recommend.
Wow – if you right click the Taskbar (bottom of the Windows screen) you can access the Task Manager.
No more Ctrl + Alt + Del – woohoo!
I wrote a post in 2016 about using INDEX and MATCH to create a hyperlink based on a search result. I thought I would update the technique using XLOOKUP.
There was a recent discussion of this topic on LinkedIn. When you are in the Power Query window you can’t save the query. If you Close and Load and Excel crashes, you could lose your work. If you have spent some time working on a query this can be frustrating. Here’s how you can capture the query before using Close & Load.
The formula to return a cell reference is quite long. This makes it an ideal candidate for a custom function.
In a browser you can open a link in a new tab by middle clicking – (mouse wheel click) – the link.
Woohoo!
Text alignment in Excel is versatile. If the column isn’t wide enough to display the text, it will display over the next cell. Date and number alignments are not so forgiving. If the column isn’t wide enough the cell with display the ### symbols or the scientific format. Here is a function technique to get around the limitation.
When you link to a cell that has a number format you may be surprised to learn that as well as the value that is linked, the format also is updated based on the cell you linked to.