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

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...
34,414 views

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...
212,062 views

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...
86,252 views

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...
29,477 views

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...
8,574 views

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...
15,911 views

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...
8,866 views


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...
102,586 views

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...
20,142 views


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
94,225 views


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...
66,917 views


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...
172,579 views


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...
5,520 views

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...
40,619 views

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,...
66,421 views

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...
80,473 views

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 &...
22,652 views

PowerPoint costs more to the economy than World War II
Could there be anything more catastrophic to the global economy than World War II? With millions of people quitting their job to take...
1,007 views

On the road to great PowerPoint presentations: the 4 rules to keep in mind
1. Less is more A good speaker does not fear silences nor pauses: it only enhances what follows. The same goes with PowerPoint: you...
5,679 views

What's new with PowerPoint 2016?
Making your presentation visually attractive is the secret to create an impactful and compelling pitch in front of your clients. For...
2,310 views
bottom of page