top of page
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.
Search
How to extract data from a PDF or picture into 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...
125 views
How to use the new PivotBy and GroupBy functions in Excel
Table of contents Intro What are the PivotBy and GroupBy functions about? What are array formulas? How to use the PivotBy function in...
173 views
Missing your consulting PowerPoint toolbar? We've got your back!
Table of contents Introduction PowerPoint toolbars developed by major consulting firms: the secret weapon Bain Toolbox for PowerPoint...
527 views
Beyond the hype: what can you really do with Copilot in Microsoft 365?
Table of content Introduction What is Copilot? How does Microsoft 365 Copilot work? How does Copilot ensure data protection and privacy?...
841 views
Advanced chart types actually possible in PowerPoint & Excel
Table of contents Introduction Default charts Vs advanced chart types Default chart types in PowerPoint or Excel How to create advanced...
3,058 views
Unlock productivity with the Slide Master in PowerPoint
If you've ever found yourself wrestling with inconsistent fonts, muddled color schemes, and unruly slide layouts while crafting a...
2,354 views
10 legendary games created by Excel geniuses
Who said Excel couldn't be fun? Although Microsoft's software is mostly known for boring financial spreadsheets, it can also be so much...
25,363 views
Excel lookup functions with multiple criteria or multiple results
As an Excel user, you're likely familiar with the lookup functions like VLOOKUP, INDEX/MATCH and XLOOKUP and their ability to retrieve a...
81,668 views
How to link PowerPoint slides in a presentation
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...
3,373 views
How to fix Excel errors: #VALUE!, #REF!, #DIV/0!, #N/A, #NUM! and #SPILL!
Excel is a wonderful toolbox to compute, analyse, compare and crunch data but it can also lead to some unexpected errors. In this post,...
372 views
How to use the new VSTACK and HSTACK Excel functions
in 2022, Microsoft revealed no less than 14 new Excel functions. These functions are probably one of the biggest game-changer of the...
8,207 views
How to use the new TEXTSPLIT, TEXTBEFORE and TEXTAFTER Excel functions
Microsoft recently revealed not one, not two, but 14 new Excel functions, and more precisely new text and array functions for Excel 365....
6,969 views
How to Create Pro-Level eLearning Content in PowerPoint
A PowerPoint presentation is probably the most widespread training format in the world. Yet, such presentations are not highly effective...
1,399 views
How to create Org charts in PowerPoint the smart way
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...
11,755 views
How to create links between Excel and PowerPoint (or Word) for your charts, tables and texts
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...
113,657 views
Gorgeous PowerPoint Presentations You Have To See
Presentations have always been an important part of any business because they are meant to convey the essence of a project proposal or...
2,839 views
How to Reduce File Size in Excel or PowerPoint
TABLE OF CONTENTS How to reduce the size of files in Excel 1. Get rid of unnecessary or duplicate data 2. Get rid of unnecessary formulas...
28,273 views
XLOOKUP just killed VLOOKUP: everything to know about this major new Excel function
Microsoft recently announced the upcoming release of a new function called XLOOKUP. This function will be replacing the widely used...
168,287 views
5 websites to download high-quality pictures for a presentation
A picture is worth a thousand words, and there is nothing like a well-chosen image to make an impression during a presentation, wether...
17,128 views
7 websites to download vector icons for PowerPoint - free and premium
Icons have become an essential design aspect for every Powerpoint designer. A few icons can make any slide look professional and...
132,731 views
bottom of page