Blog

Welcome to the Power-user blog. Here you will find resources, tips and tricks, tutorials, shortcuts, ideas and inspiration to bring your productivity, presentation skills and Excel expertise to the next level.

Customizing keyboard shortcuts in Microsoft Office can drastically speed up your workflow. But while Word offers built-in support for...

Whether you want to analyze profitability, show a P&L, track budget performance or compare M&A acquisition targets, choosing the right...

In the high-stakes world of investment banking, financial modeling is an essential skill that underpins strategic decision-making....

Table of contents Introduction Create a speedometer chart in Excel Overview Step 1 : Create the color scale Step 2 : Insert the value...

Introduction Understanding Excel's default page layout The problems of not customizing Excel styles What are the default themes in Excel?...

Table of contents Introduction How to convert data from a PDF to an Excel table The problem: PDF data won't come formatted as a table...

Table of contents Intro What are the PivotBy and GroupBy functions about? What are array formulas? How to use the PivotBy function in...

Table of contents Introduction PowerPoint toolbars developed by major consulting firms: the secret weapon Bain Toolbox for PowerPoint...

Table of content Introduction What is Copilot? How does Microsoft 365 Copilot work? How does Copilot ensure data protection and privacy?...

Table of contents Introduction Default charts Vs advanced chart types Default chart types in PowerPoint or Excel How to create advanced...

If you've ever found yourself wrestling with inconsistent fonts, muddled color schemes, and unruly slide layouts while crafting a...

Who said Excel couldn't be fun? Although Microsoft's software is mostly known for boring financial spreadsheets, it can also be so much...

As an Excel user, you're likely familiar with the lookup functions like VLOOKUP, INDEX/MATCH and XLOOKUP and their ability to retrieve a...

Presentations are almost always designed as linear. You start from Slide 1 and then move to Slide 2, then Slide 3, etc. in this fixed...

Excel is a wonderful toolbox to compute, analyse, compare and crunch data but it can also lead to some unexpected errors. In this post,...

in 2022, Microsoft revealed no less than 14 new Excel functions. These functions are probably one of the biggest game-changer of the...

Microsoft recently revealed not one, not two, but 14 new Excel functions, and more precisely new text and array functions for Excel 365....

A PowerPoint presentation is probably the most widespread training format in the world. Yet, such presentations are not highly effective...

Creating org charts is a classic need virtually every PowerPoint user has faced at some point. An org chart can give a lot of information...

Linking Excel and PowerPoint is a powerful solution to automate reports and a major time-saver. In this post, we will lay out the pros...