How to Eliminate VLOOKUP using Relationships in Power BI
VLOOKUP is one of the most commonly used functions in Excel. However, it comes with its own set of problems: It increases the file size It consumes lots of processing
VLOOKUP is one of the most commonly used functions in Excel. However, it comes with its own set of problems: It increases the file size It consumes lots of processing
Quick Calc in Power BI (Desktop as well as Portal) is a handy feature. Similar to Show Values As in Pivot Tables. How to use Quick Calc in Power BI
Here is the next installment in the Office 365 Worst Practices series. Office 365 contains many components. For regular users most of these components are new, except one – Office.
The Amazing Mouse eBook Learn 300+ powerful ways to use the mouse efficiently with MS Office. Save at least 10 minutes & reduce the risk of arthritis! Free Download PDF
Here is a sneak preview of Chapter 1: When NOT to use the mouse. Trust me, knowing when NOT to use the mouse is just as important as knowing WHEN
Yes. This feature has been requested for years. There were many workarounds. But no direct solution. Now we can Highlight text in PowerPoint just as we can in Word. Simple
The need If you are doing serious and important work, you must use mouse. Yes, I know that there are lots of alternatives. Pros like keyboard shortcuts, newer generation likes
I posted this quiz couple of days back. Here is our quiz winner! Chayse Newman Congratulations. Please send me your email address on nitin@maxoffice.biz I will send the Amazon Voucher immediately.
Although Power View and Power BI reports are similar, Microsoft is focusing on the later. Power BI platform is being separated out from Excel for many reasons. One of the
Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
