Search Results

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.

Stay ahead of the game in 2023.
Get access to our best-selling Power BI course now and become a highly sought-after Power BI professional.
This course gets you started in Power BI – Fast!

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.

Learn time-saving hacks to work smarter in Excel. Our members also consistently report a newfound enthusiasm for using Excel after taking our course.

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 change these to support your workflow and be more productive. This post covers my list of options to review.

With the new Power BI integration for PowerPoint, you get to embed your live Power BI dashboard in your PowerPoint presentation. The process is smooth. Check it out in this complete tutorial.

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 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 shows you what organizational data types are and you can set them up from scratch.

This is a real-life example of Excel’s VSTACK function. Quickly stack data from multiple sheets (even as many as 15 sheets!), filter out blank cells and even sort the summary table.

Handling dates in Excel Pivot Tables can get tricky. How can you quickly ungroup the dates? Or get your own custom grouping for fiscal periods? How can you show all the dates including the ones with no values? This tutorial covers it all!

The lookup function is the simplest function in Excel. It can return exact or approximate matches and it’s super easy to write. Yet many people prefer VLOOKUP because it’s easier to understand. In this tutorial, I’ll explain the LOOKUP function by using a simple, followed by a more complex example.