How to Use Power BI

Get started with Power BI now by creating your first dashboard. Download the free files, follow along and in 20 minutes you'll have setup your interactive dashboard which you've published to the web!

Excel – Interactive Dashboard Trick

With Pivot Charts in Microsoft Excel you can add slicers to add interactive functionality to your dashboards. But what about adding even more interactivity? You could give the user the ability to change the relevant KPI in the chart from the slicer.

How to Use Checkboxes in Excel

Quickly learn how to create a checkbox in Excel. You can also easily create multiple checkboxes. It's important to learn how to use the outcome of the checkbox in formulas and conditional formatting - for example to get a strikethrough effect. Find out in this comprehensive tutorial.

Excel Dashboards with Radio Buttons

Quickly learn how to add option buttons (radio buttons) to your files to create interactive Excel Dashboards and dynamic charts. It's really easy once you learn this one trick: How to control the results based on the radio button selection.

Excel LAMBDA Function Explained

With the new Excel Lambda function you can create your own custom functions that you can reuse. The best thing about Excel Lambdas is you can create a function that loops through many cells. You can do this with ZERO coding!

Excel Hidden Dashboard Tips

You can spend a lot of time on design and formatting when you create dashboards in Excel. Discover 4 hidden tips that will make the process a lot easier.

Understanding and Creating Barcodes in Excel

Find out how you can generate UPC barcodes in Excel that work! I tested it with a scanner and the Excel barcodes could be scanned. The solution uses a combination of Excel VBA, formulas and conditional formatting.

Excel Calendar with Holidays and Appointments

Excel Calendar with Holidays and Appointments This week’s post is a special post because it comes directly from the super-brain of one of our XelPlus community members, Adam Weaver. Adam holds both a PMP certification (Project Management Professional) and an RMP certification

Practical Excel Dashboard (Excel Hash 2019)

A Dashboard with 4 Strange Features (Excel Hash 2019) Welcome back to another edition of Excel Hash! Last year (that’s right, I said “last year”), myself and several other prominent Excel MVP online personalities participated in a challenge where we are given