Nicolas Boucher Excel, Skills, Tips

650+ tips on Excel, PowerPoint, Outlook & Windows

I just discovered this immense catalog of tips made by Karen Roem.

This is a collection of more than 650 tips (654 tips at the date of this post) to make you better at all the Windows and Microsoft Office tools.

Here are my favourite 3 tips from Karen:

1) Top 10 Microsoft Outlook shortcuts

  1. CTRL + 1 and CTRL + 2 – Toggle between Mail and Calendar – tip_259.php
  2. CTRL + F – Forward a mail message 
  3. CTRL + G – Go to a specific date – tip_485.php
  4. CTRL + K – Check names in address fields and resolve them against the Address Book – tip_211.html
  5. CTRL + K – Insert Hyperlink – tip_431.php
  6. CTRL + SHIFT + 8 – Show/Hide paragraph marks and other hidden formatting symbols – tip_394.php
  7. F3 – AutoComplete Quick Parts – tip_335.php
  8. F4 – Find text in an email message – tip_108.html
  9. SHIFT + F1 – Reveal Formatting – tip_498.php
  10. SHIFT + F3 – Toggle between UPPER CASE, lower case and Sentence Case 

2) Create a bulleted list in Excel

  1. Select the cell where the list is to appear.
  2. Press ALT + 7 on the numeric keypad.
  3. Type your text.
  4. Press ALT + ENTER if you want to insert another bullet in the same cell.
  5. Repeat steps 2 – 4.

3) Shortcuts in Windows

WIN + D can be used as a toggle to minimize and maximize all windows? But what if you just want to have a quick peek at something on your desktop? Check out the preview shortcut! 

Here’s how: 

  1. Press and hold down the WIN key (the one next to your spacebar) and press the spacebar.
  2. Release the WIN key to return to your last used window.

If you like this post, check the 50 time saving Excel Shortcuts.

Nicolas Boucher Excel, FP&A, Tips

How to make a Waterfall Chart in Excel? Easy with this free template!

Waterfall Chart Gif

 

Waterfall Charts (also called bridge analysis) are one of the best way to visualize variances between 2 reporting periods or between figures budgeted and actuals.

However, it is tricky to build them in Excel.

This is why have prepared a free and easy ready to use Excel template for you.

This template includes instructions, an illustrative example and a blank table ready to use. Save time and use this template for your next Waterfall!

Download the free template here: Waterfall Chart Template

And if you need more detailed instructions, here is a great video tutorial.

You liked this template? Share it around and don’t forget to subscribe to get more templates from me.

Bonus: I found a free course to learn Power Query. Check the link below:

Click here to get a free course to get the most out of the new Excel function: Power Query

👉Get the free course.

Nicolas Boucher Excel, Finance, Skills, Tips

10 tips for Excel charts to make your life easier! 📈

👉 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.

This tutorial trains you with the following tips:

1. Quickly make a chart with ALT+F1 shortcut

2. Select specific columns, before creating a chart to show only what you need

3. Expand graph automatically as you add additional columns/row

4. Quickly filter data from a chart.

5. Use PivotCharts when your data isn’t summarized.

6. Create multi-level labels

7. Use a secondary axis to create a combo chart.

8. Hook up a chart title to a cell.

9. Split off slices into a second pie

10. Hover over Chart Elements to get a preview.

Share your other tips in the comment section!

👉 Get the tutorial Excel file by clicking here: 10 tips for Excel charts

 

Power Query Academy
Nicolas Boucher Uncategorized

Learn new Excel tricks and tips

Even if you think that you master Excel, I recommend you to visit the website of John Macdougall “How to Excel” where you will certainly learn something which will help your productivity (and will give you the possibility to impress your colleagues thanks to your new Excel skills).

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: Amazing Excel Tips and Tricks

Here is just one new trick that I learn today:Excel tricks and tips

If you right click and drag a range instead of the usual left click, then you’ll able to do more than just cut and paste. A whole menu of advanced options is available.

  • Move Here – This will cut and paste the selection to the new location.
  • Copy Here – This will copy and paste the selection to the new location.
  • Copy Here as Values Only – This will copy and paste only the values to the new location.
  • Copy Here as Formats Only – This will copy and paste only the formatting to the new location.
  • Link Here – This will create a simple cell reference formula to the old location in the new location.
  • Create Hyperlink Here – This will create a hyperlinked cell reference to the old location in the new location.
  • Shift Down and Copy – This will copy and paste the selection to the new location and shift down any previous data in the new location.
  • Shift Right and Copy – This will copy and paste the selection to the new location and shift right any previous data in the new location.
  • Shift Down and Move – This will cut and paste the selection to the new location and shift down any previous data in the new location.
  • Shift Right and Move – This will cut and paste the selection to the new location and shift right any previous data in the new location
  • Cancel – This will cancel the action.
Nicolas Boucher Uncategorized

The best Excel trick when working with Dashboard and Pivot Table !

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 will find below examples and tutorial to learn how to integrate slicers. Believe me, it is really easy!

Résultat de recherche d'images pour "slicer excel"

Here are some links to learn more about the Slicer function:

If you liked this post it will mean a lot to me if you share it around. You can also leave a comment below to contribute with your ideas.