I love Excel as an alternative to Power BI reports, especially now that Excel Online allows you to interact with browser-based Excel reports that use Power BI datasets or the Excel Data Model (aka ...

How to configure an Excel file for use in Power BI Your email has been sent Getting viable data from an Excel workbook into Power BI for data visualization purposes takes some specific preparation.

Helping & empowering business owners for over 15 years, helping them to understand how to protect own interests, build bridges to amplify joint ventures, adapting new business practices and solutions.

Earlier this year a new feature was added to Power Query in Excel and Dataflows that very few people noticed: the abilty to export all the queries in the Power Query Editor to a template file. The ...

Sometimes you need to scan some files for a piece of data like a string, phrase or some number, and one of those files just happens to be an Excel spreadsheet. You could open up the file, launch the ...