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
Top 12 Most Annoying PowerPoint Presentation Mistakes
Using PowerPoint presentations in your life is a fine art. Back in the day, people used to simply chuck all their content onto a handful...
How to Create a Data-Backed Presentation Using Simple Infographics
Infographics are more useful than ever. With the primary aim to visualize often complex concepts in a simple and engaging way, let’s do a...
Best 11 Tricks You Need to Know to Make Professional PowerPoint Presentations
In 2017 PowerPoint managed to make an epic coming out. Nobody was expecting to see this, but TA-DA! PowerPoint templates have managed to...
Infographics: how to choose the best chart type to visualize your data
If you are frequently working with data, using charts to make it visual it is obviously an absolute necessity. You can spend weeks...
The 10 best websites for beautiful PowerPoint templates and designs
PowerPoint is really time-consuming. So why create from scratch every new slide you need when there are already thousands of slides...
12 reasons why you should use Excel Tables
TABLE OF CONTENT About Excel tables What is an Excel table and how to create it? How do I recognize an Excel Table? How to create a Table...
How to paste charts from Excel to PowerPoint with automatically the correct size and position
Pasting charts from Excel to PowerPoint is one of the classic nightmares of an analyst. First, you build some charts in Excel that are...
Excel Text to Columns: how to split data into multiple columns
On many occasions in Excel, you have data in one column that you would like to separate into multiple ones. A few examples are: When you...
Why you should name ranges in Excel, and how to do it
Why name ranges in Excel? Naming ranges in Excel can help you bring a lot of flexibility into your workbooks. First, named ranges have an...
Use Morph to create professional animations for PowerPoint in seconds
If you have PowerPoint 2016 and an Office 365 subscription, learn how to use the new Morph transition—you’ll be surprised at how often it...
Make your EXCEL VLOOKUP run a hundred times faster with the double-VLOOKUP trick
If you are a frequent user of Excel, you most certainly know the VLOOKUP function. If not you can read this tutorial to learn this...
How a smart use of color themes can save you hours on PowerPoint
Most people don't know how color themes work in PowerPoint. And that they are actually a very powerful thing that can save you hours if...
How to create impressive Excel dashboards
This post will teach you all the secret tricks you need to build impressive dynamic dashboards that update in seconds
60+ of the best add-ins, plugins and apps for Microsoft 365 Word, free or not
Microsoft Word is without a doubt among the most used software in the entire world, used to write simple letters, create contracts, write...
40+ of the best add-ins, plugins and apps for Microsoft 365 PowerPoint, free or not
With around a billion users, PowerPoint is the most used presentation software in the world. While ppt presentations are an essential...
The Excel formula error that initiated austerity policies after the crisis
Carmen Reinhart and Kenneth Rogoff are two economists from Harvard University who published a major paper called Growth in a Time of Debt...
Best Keyboard shortcuts for Excel
Using keyboard shortcuts is a major step towards becoming an Excel power user. Below is the list of most keyboard shortcuts. Take a...
Add, load or remove add-ins for PowerPoint, Excel or Word
Add-ins (or add-ons) are programs that add extra features to Microsoft Office applications. There are 3 sorts of add-ins: VBA add-ins,...
Give a brilliant structure to your presentations with the Pyramid Principle
Structure is the backbone for any presentation: never neglect it Structure, structure and structure again. This is how you can get people...
PowerPoint tips & tricks you didn't know
Most users believe they know everything about PowerPoint. Really? I bet you are going to learn something reading this post. Those tips &...
bottom of page