And it’s not just the whiz kids down in finance and accounting who have to be conversant with Microsoft Excel, either. Doesn’t really matter which department it is, in fact, you have got to know your rows, columns and function to be able to, well, function. If writing is in Word and pitching is in PowerPoint, then number crunching is in Excel. Although you’d be barking up the wrong tree if you thought Excel was just about the numbers. Charts, spark lines, heat maps, SmartArt are all relatively non-numeric things that Excel is rather good at as well. And we haven’t even started with all the hidden goodies that Excel keeps in store. The Developer ribbon, for example – that relatively little known store of Excel goodness. All of these things are applicable in all departments, all over the company.
Take human resources, for example. Want a neat little database of who’s working in your company, and where they were previously, and what their phone number is, and who they report to, and on and on and on? You’re thinking, at the very least, a nice little pivot table in Excel, and knowing database functions wouldn’t hurt either. Plus, no matter which department you’re in, you will, sooner or later, raise an invoice. Use one of those nice pre-formatted ones that Excel makes available – and if you don’t know what I’m talking about, well, that’s what online courses are for! Computing offer sheets, calculating severance pay, figuring out how to divvy out bonus pools across departments – ask Excel, and it shall deliver.
What about marketing, you might think by way of response. Surely those guys don’t have to be familiar with Microsoft Excel? Au contraire, my friend. Keeping a list of prospective, current and past clients handy, and figuring out how your billing has changed over time, and linking customer tables with products purchased will require intimate familiarity with the magic spell that is VLOOKUP,
Excel Everest is pleased to announce a strategic partnership with Acuity Training to offer high quality Microsoft Excel training to clients of Exceleverest.com who are looking for classroom-based training in the UK.
While online Excel training works well for many people it isn’t always the correct solution for everyone. Some people prefer classroom-based learning and so to meet this need Excel Everest has partnered up with Acuity Training in the UK.
Acuity Training is a specialist IT training business exclusively focused on classroom-based IT training courses. Acuity is one of the UK’s leading Excel training providers, with training clients including Exxon, GE, Lockheed Martin, Deutsche Bank, Johnson & Johnson and Novartis. It consistently gets outstanding feedback from its delegates, which is publishes publicly here. It offers scheduled Microsoft excel courses in London and Guildford as well as onsite training . This link gives full details of Acuity Training’s scheduled excel courses.
Ben Richardson, CEO of Acuity Training “I’m delighted to announce this partnership. Excel Everest’s offering is fantastic but doesn’t work well for everyone, just as classroom-based training doesn’t work well for everyone. We don’t all learn best in the same way. This partnership allows us to work with a similarly quality-focused Excel training organization to offer our clients outstanding training results through whichever form of training will work best for them as an individual.”
The always awesome Chandoo comes up with a tip that needs to shared as widely as possible, more about which in just a second.
Have you ever needed to enter numbers in a sheet where for whatever reason, they need to be entered as 001, rather than 1?
Of course you have, who hasn’t? Well, in that case, you have also obviously suffered from the bang-my-head-against-the-wall syndrome, because Excel is, in this case, more stubborn than an obdurate mule.
If you don’t know what I’m talking about, simply fire up an Excel sheet and enter “001″ without the inverted commas in any cell
… and hit Enter
Slightly frustrating, isn’t it? You want Excel to show the leading zeros, but Excel couldn’t care less.
There are a couple of workarounds to this, which are mentioned in Chandoo’s blog post linked to above, but there’s one that is even simpler than the solutions he has mentioned… simply append a leading ‘ to the number you wish to enter.
Once you press enter, the leading zero’s don’t disappear!
The only thing is that Excel gently reminds you that what you’ve entered as text really seems to be a number:
And the number, since it has been formatted as text, is left-aligned. But it is a pretty quick workaround all the same!
You might think this post to be a little offbeat, a little off the beaten path – and we wouldn’t argue with you.
What we have done in this Microsoft Excel tutorial is looked through Excel’s capacious archives to come up with five formulas that won’t be used all that often. Sure, there’ll be people over the world who use these day in and day out, and thank heavens for the very existence of these formulas – but there won’t be mroe than ten of them, I’m sure.
All right, that’s an exaggeration, maybe – but seriously: how many of you knew about the “Roman” formula, for example?
a) The Roman:
The Roman formula does what the Roman formula promises. It returns the Roman value of an Arabic integer. Arabic integers are the good old numbers that we always end up using. 543, for example. But I bet you a rather sizeable sum you can’t come up with the Roman numeral equivalent. Well, Excel can.
It’s DXLIII, for what it’s worth. It may be a neat party trick, or it may be of great help if you are in academics. But it’s a useful thing to know, the Roman formula – that’s for sure.
In how many ways can you choose 2 objects out of, say, 50? Brings back horrific memories of math in the sixth grade or thereabouts? Are you about to break out into hives at the mere thought of that accursed blackboard and those dreaded sums?
Fret not, want not. Fire up Microsoft Excel, and enter “=combin(50,2)” in any cell and hit enter. Learn that there are 1225(!) ways of choosing 2 objects out of 50. Who would have thought?
We couldn’t resist putting this one in for it’s immense, well, coolness. Any formula called “Now” deserves to get in simply because it is called “Now”. Still, it does what you think it would. It simply returns today’s date and time as of… wait for it… now.
This is Bart Simpson’s dream come true. If only the blacboard was a spreadsheet!
The rept formula takes a text string as an input, and spews it out as many times as you like.
Every now and then, our sojours on the Internet seas lead us to places where not too many people have trodden before.
These virgin, unexplored islands are often that-a-ways for a reason; they’re poorly designed, perhaps, or maybe the content is not too useful. We just heave resigned sighs and set sail from them, in search of better lands.
Every now and then, though, we just luck out, plain and simple. And the link that we’re going to share with you today is one such internet treasure.
The unimaginatively titled “Site Map | Microsoft Office” – I mean, c’mon! – is actually a repository of link related to Microsoft Office products. And when I say repository, I mean every single link one could ever hope to keep in one’s bookmarks and when I say Microsoft Office products, I mean every single last one of ‘em.
Just insaney good stuff, this.
Just scroll down from the rather drab SmartArt-ish graphic at the top of the page…
… and immerse yourself in the Excel links section.
We’ve previously talked about Excel’s own help section, and it is pretty darn good. But if ever you need to forage through the big bad world wide web… well, this is as good a place as any to start.