Search Results

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.

The reason most people fail at understanding financial analysis is that they fail to understand the fundamental concepts. Concepts such as debits and credits, journal entries, trial balance and how these connect to the income statement, balance sheet and cash flow.

There are many ways you can lock cells in Excel to protect others from overwriting your formulas and your data. I’ll show you an easy way in this quick tutorial.

Excel’s TEXTSPLIT function can split words into separate cells. You can have multiple delimiters, you just have to know how to define these properly. You can also do amazing things like splitting into columns and rows and internally sorting words.

Excel recently released a set of new functions like VSTACK, TEXTSPLIT and TOCOL that will have you looking forward to working with complex files and data because your life just got more exciting (at least mine did!).

In Power BI or Power Pivot, you often need to create reports that go from the many side of the relationship to the one side. How can you do that without expanding your data model by adding more columns to your table? There is an easy trick you can use to solve this with a single DAX formula. Of course, the formula uses the CALCULATE function.

The new Microsoft Excel Advanced Formula Add-in makes it easy to write and manage LAMBDAs in Excel.
It’s a “new” version of Name Manager and hopefully it could replace Name Manager in the future.