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...
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
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...
412 views0 comments
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...
1,077 views0 comments
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,...
250 views0 comments
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...
1,749 views0 comments
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....
1,455 views0 comments
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,237 views0 comments
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...
4,597 views0 comments
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...
71,768 views0 comments
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,654 views0 comments
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...
20,266 views0 comments
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...
135,805 views0 comments
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...
11,019 views0 comments
7 websites to download vector icons for PowerPoint - free and premium
Icons have become an essantial design aspect for every Powerpoint designer. A few icons can make any slide look professional and...
118,455 views0 comments
How to Animate Texts, Objects, and Videos in Microsoft PowerPoint
By means of PowerPoint animation effects, you can add smooth transitions between different states of your presentations by moving objects...
2,906 views0 comments
5 Tips For Better Typography In Your Slides
There is a lot of software for creating impressive presentations. Most of them are packed with tools and features that help...
997 views0 comments
2 Accessibility Features and 1 “Off Label’ Use for PowerPoint
Screen readers are tremendously helpful for people with visual disabilities. They are used to read the screen. PowerPoint uses this...
222 views0 comments
Are You Ready For These 5 Project Management Trends? Let's Find Out
In this article, we take a closer look at five project management trends you should be ready for now and in the future. The project...
393 views0 comments
The Importance of Color in Data Visualization
Colors speak a language louder than words and communicate with us on an emotional level. The challenge is to use the power of color...
3,377 views0 comments
How to Create Striking Text Effects in PowerPoint
There is no doubt in the fact that PowerPoint is the most popular and well-established software to create awesome presentations. It’s...
9,103 views0 comments
bottom of page