Monday, 27 January 2020

Keyboard shortcuts 5: Copying the formula from the cell above

Here’s another nice formula – particularly good as it saves you having to re-type, or copy-and-paste, a formula to the cell below. A simply CTRL + ‘ will copy the formula from the cell above and put it in the cell you’re on.

Thursday, 16 January 2020

Keyboard shortcuts 4: Closing a workbook

Finished working on an Excel workbook and want to move onto the next thing? Close it quickly and easily with CTRL+W – and if you’ve not saved it yet, Excel will ask you if you want to.

But don’t use the mouse – just press Enter to save!

Thursday, 5 December 2019

Keyboard shortcuts 3: Selecting rows & columns

Following on from the last tip about selecting cells using the keyboard, did you know you can also select entire rows (shift + space) and columns (ctrl + space).

So tell me… are you beginning to think about ditching the mouse yet? Comments below...

Monday, 2 December 2019

Keyboard shortcuts 2: Selecting cells

Here’s another real time-saver as you continue your quest to ditch your mouse in Excel (yes, really, please do that!) - it’s about selecting cells. I guess usually you take the mouse, click in the first cell, drag to the last cell, then release the mouse button. And sometimes you have to do it twice because you don’t aim very well and you either miss or over-shoot.

Well, next time, just hold down the shift key and use the arrow keys to select the cells. Try it 5 times and you’ll find it’s a lot quicker than using the mouse. Why not give it a try now?

Thursday, 7 November 2019

Excel keyboard shortcuts 1: CTRL + Page Up/Down

Continuing our little series on keyboard shortcuts, here’s my favourite – never again do you need to use the mouse to move from one sheet to the next – instead, use CTRL + Page Down or CTRL + Page Up to move through your workbook.

Give it a try, and why not use the comments below to share your favourite keyboard shortcut, and I’ll try to feature it in a future blog post...

Friday, 25 October 2019

Embracing Excel's keyboard shortcuts

As subscribers to my Excel e-tips mailing list will know, I’m a big fan of keyboard shortcuts – they save a lot of time in Excel compared to using the mouse. In fact, there are two types of shortcut:
  • Direct shortcuts
  • Indirect shortcuts
Direct shortcuts
These are accessed by pressing CTRL + another key. For example, press CTRL+X and you’ll cut the info from a cell; CTRL+V will paste.

Indirect shortcuts
These are accessed by a combination of keys pressed in sequence (rather than at the same time). For example, Alt>H>A>C will centre-align the content of a cell.

Over the next few weeks, my challenge to myself is to persuade you to put down the mouse, embrace both types of keyboard shortcut, and make the journey towards working more efficiently in Excel.

To keep up with this series, add your email to the "follow by email" box on the right to subscribe to the blog, or sign up to Naturally Spreadsheets' Excel e-tips mailing list to get the tips delivered straight to your inbox every 2 weeks.

Friday, 25 May 2018

Our favourite Excel training feedback

If you're a customer, or having been reading our blog for a while, you'll probably know that Naturally Spreadsheets is a brand name of Navanter - a specialist communication skills, sales and leadership training company based in London. Naturally Spreadsheets came about a long time ago, when a client asked whether I knew anyone who could do Excel training, and I decided to take on the challenge myself. Since then, our Excel training has gone from strength to strength, and accounts for about 40% of what we do.
Our USP (Unique Selling Point) is that we deliver our training in a soft-skills style, which we find really engages learners in a way that most IT training does not. In today's blog post, we're unashamedly going to blow our own trumpet and show you why you should be using Naturally Spreadsheets for your Excel training - by using some of our favourite feedback quotes from satisfied clients.
"This course was really valuable and taught me new things. Not only new formulas and how to use them but how to use the concept of putting formulas together." Lucy Cooper, The Key Support Services Ltd, London, UK
"Exceptional at explaining Excel simply." Nastassja Beaton, Venture Trust, Edinburgh, UK
"This was by far the best Excel course I have taken, because the pacing was great. I could keep up with everything that was presented and so really learned from and enjoyed the course." Deborah Jeanfavre, Citeline, New York, NY, USA
"Very easy to follow. Walking through the provided examples was really helpful and I liked how the finished examples could be saved for future reference." Michael Haydock, Datamonitor Healthcare, London, UK
"Really made the content come to life, didn’t waffle, was clear and concise and made new concepts easy to understand." Dave Newton, Spectrum Brands, Manchester, UK
"It’s the small 'nuggets' that are absolutely invaluable." Sara Gallagher, Bath Cats & Dogs Home, Bath, UK
"Very clear and comprehensive yet simple enough to not be bombarded with information." Romany Luckcock, IFF, London, UK
"Excellent instructor - one of the main reasons why this class is popular/well-attended/successful." Dominique Fontanilla, Datamonitor Healthcare, London, UK
"This was a fantastic course and I really got on with Neil's clear, logical teaching style. Looking forward to putting this into practice!" Amy Booth, IBI, London, UK
"Managed to establish a classroom vibe although we were all remote." Tamara Makoni, IBI Central, London, UK
 So there you go - don't just take our word for it - try it out for yourself at www.naturallyspreadsheets.com today!