An exceptionally big welcome from Exceptional Excel.

This is the first blog in what will be an amazing journey we take together, to better the world’s Excel skills.

This blog will focus on short tips, tricks and formulas that can quickly improve your Excel skills, making you more productive in your day to day use of this exceptional software.

We have numerous years experience in Microsoft Excel and we have really put it to the test over that time. With everything from complex formulas to analysis tasks… and yes we still love it! It’s our goal to make you feel the same about it and really start to reap the benefits of knowing more about the software.

The website is now up and running at exceptionalexcel.com so take a good look around and please do sign up for the newsletter. Signing up today will ensure you get the latest free stuff direct to your inbox… you won’t want to miss out on some of the great things we have lined up.

Amongst other things, we have some outstanding online video courses coming real soon and others a little further down the line. It’s a really exciting time for Excel users!


First tip

Today I’d like to start you off with one quick tip…

Ever get frustrated repeatedly pasting the same format to multiple cells?

Did you know that the Format Painter button on the Excel Home ribbon can be double clicked in order to paste formats to multiple cells?

  1. Select the cell you wish to replicate the format of.
  2. Double click the Format Painter button.

a) It will go from looking something like this:

Excel Format Painter button

b) to this:

Excel Format Painter selected.

3. Now click on any cells you wish for the formats to be replicated to. The format painter will remain switched on and the cursor will look like this Excel Format Painter cursor.

4. To exit the format painter mode, simply click the button one more time or hit the esc key on your keyboard.

That’s it! Pretty simple and a real time saver.


Thanks for reading, as mentioned previously please sign up below and get more great tips.

 

Want to learn more?

Sign up today to our free newsletter, including useful tips and best practices in creating great Excel Dashboards.