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...
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
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,550 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,716 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...
100,558 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...
19,533 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
93,523 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...
65,719 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...
171,759 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,419 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...
32,200 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,...
65,074 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...
78,947 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,517 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,004 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,532 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,306 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,733 views
bottom of page