'Be prepared to be amazed' - Microsoft's Excel tips

At a recent IRIS user conference in London, Microsoft Office presenter Simona Millham wowed the crowd with a half-hour session on some of the less well known features in Microsoft Excel. This article presents some of the highlights.

Some of Millham's tips have already been documented by AccountingWEB members in our Excel navigation tips Expert Guide, but she still came up with a few new tricks that will delight regular users.

Continued...

» Register now

The full article is available to registered AccountingWEB members only. To read the rest of this article you’ll need to login or register.

Registration is FREE and allows you to view all content, ask questions, comment and much more.

Comments

some readers are nervous

David Carter | | Permalink

Stephen, don't want to sound bad-tempered etc, but in a recent thread a lady has said she is a bit scared of asking a question on Any Answers because she is worried she might be "getting flamed".
We don't want to put people off from asking simple questions because they feel it will make them look stupid.

David, I totally agree with you!

stephen.smith.r... | | Permalink

My issue with the article was that it was entitled "Be prepared to be amazed". I honestly don't think many users of Excel would be amazed. They would be amazed when they see a pivot table for the first time but not when they see a keyboard shortcut (in my opinion). The headline drew me into reading the article and I was disappointed with the content.

I don't think my comment would put off anybody from asking a question. Apologies if it did!

It's all useful stuff

David Carter | | Permalink

Whenever AW publish something like this, we always got a lot of testosterone-filled males jumping in and saying "Cor, don't you even know that!" or the like.

The fact is, however, that most of us have to learn Excel from others as we go along. When people share their knowledge like this there is almost always at least one new tip you didn't know, and that makes it worth while. David Carter [IT consultant editor]

dahowlett's picture

Are you serious about this?

dahowlett | | Permalink

It's good to see 1000+ readers are sufficiently curious to see how Microsoft can 'amaze' the author. I got bored real quick with reading about stuff I thought most people knew.

Microsoft hasn't had an original idea in its collective brain since Bill Gates did the licesning deal of the last century and consigned IBM to a miserable existence when it comes to dekstop and laptop machines. But apart from that, isn't it about time practitioners thought about amazing their clients?

Totally agree with Alan!

stephen.smith.r... | | Permalink

Can't believe many people would be amazed by these tips. They are mostly pretty basic.

amazed!!

Alan Davies | | Permalink

I'm amazed that most people aren't already using most of these - if people actually were amazed may I suggest a little training may be required.

I am not entirely convinced by keyboard shortcuts either - its usually far easier to use the mouse as this is what you hand is normally on anyway. This may just be my preference though.

download

AnonymousUser | | Permalink

my download does not work either

Broken link?

a.nesbitt.forre... | | Permalink

The link to the Word download is not working on my computer. Is this me or you?