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
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...
85,640 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,384 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,553 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,808 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,833 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,125 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,020 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,053 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,677 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,339 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,487 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...
38,384 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,087 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,088 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,620 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,005 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,649 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,309 views
Best Keyboard shortcuts for PowerPoint
Using keyboard shortcuts is a major step towards becoming a PowerPoint power user. Below is the list of most keyboard shortcuts. Take a...
3,817 views
bottom of page