Power BI Slicers add interactivity to your reports. Managers love to slice and dice. But which Power BI slicers are available? Which should you choose? This tutorial will make you a master in Power BI slicers.
Excel's What-if Analysis Data Table allows you to quickly create simulations. This tutorial takes you through a simple example of how you can create a Data Table from scratch. If you've never used this feature, you need to check it out. It's like magic.
What do you do when you're presenting a chart to the higher-ups and someone asks: "Show me the Details behind that?" If you've embedded your Power BI report in PowerPoint, you'll be like: "Let me show you!". Drill-through in Power BI is super easy to implement. You just need the right start. This tutorial shows you how.
What is Power BI? What is Power BI used for? You see, there is a reason why companies are investing more and more in Power BI projects. Actually there are 4 reasons why Power BI is preferred to the competition. This tutorial explains it all in plain English.
Learn to properly use the Excel TEXTBEFORE and TEXTAFTER functions. There is a cool trick you can use with these functions to get the outcome you want. Check out the post for more.
With the think-cell add-in for PowerPoint, you can create beautiful charts with just a few clicks. Some of my favorites are Gantt charts, Mekko charts and adding automatics totals to stacked columns or bars.
Excel comes with default settings and options. You can easily change these by going to File / Options. Why should you? To support your workflow and be more productive. This post has my list of options you need to review.
Power BI Reports in PowerPoint Building a super-cool Power BI dashboard with full interactivity (slicers, bookmarks, drill-through, etc.) can be quite satisfying. But what do you do if you need to present this interactive dashboard in a meeting where PowerPoint is your
Use this button you already have in Excel to bulk combine and import PDF files to Excel. Forget copy-paste, manually typing values or using 3rd party tools. Get it dynamic too so you just need to drop a new PDF in a folder and the PDF data is immediately imported to Excel.
Organizational data types allow you to create your own rich custom data types in the Excel Ribbon. Technically you‘d create them in Power BI and have them show up in the Excel Menu of your team members. This tutorial show you what organizational data types are and you can set them up from scratch.