650+ tips on Excel, PowerPoint, Outlook. This is a collection of more than 650 tips to make you better at all the Windows and Microsoft Office tools. Shortcuts, tips, tutorials from Karen Roem
Waterfall Charts are one of the best way to visualize variances between 2 reporting periods or between figures budgeted and actuals. Get this free template here!
Microsoft compiled 50 time-savings Excel Shortcuts (for Windows) I find the shortcuts for formatting cells pretty useful. For example, I am using the "Ctrl + Shift + %" every time I am calculating percentages in Excel and I want to apply the percentage format instead of the standard format. Bonus: Get a free course to … Continue reading 50 time-savings Excel Shortcuts
Get the tutorial Excel file by clicking here: 10 tips for Excel charts and start training yourself to improve making charts in Excel! Today I found a simple but excellent tutorial from Microsoft. You get 10 tips to make charts in a faster and simpler way. I particularly like the tips number 4 and 9.
Here is one of the best post where he presents a compilation of the best Excel tips and tricks ranging from beginner to pro that will save you time and make you more productive
Here is a great To Do List by Jon Macdougall, the Excel MVP.
Use it for yourself, for your team, for your meetings or for project management with other people.
Tailor this template and take the habit of using it instead of redoing the design of your To Do List each time you create a new one.
After my 7 years as an auditor, I thought that I knew most of the important functions from Excel... until I saw the Slicer function !!! If you are working with Pivot Table, if you are filtering tables to create reports, if you need to build a dynamic dashboard, you will love this function. You … Continue reading The best Excel trick when working with Dashboard and Pivot Table !