You might also be interested in
Replies (26)
Please login or register to join the discussion.
Outlook is the worst offender
Very amusing article thank you but the notification bubble in Outlook has been proved to cost British business the equivalent of the GDP of Bolivia and for good reason. Every time Outlook announces that you have received a spam message you are distracted for 1/2 a second, lose your train of thought for maybe 10 seconds, more if it is not spam, with no gain whatsoever. For some reason people like it. Every few weeks I go round the office furtively changing people's settings but they usuallychange them back again. If someone could show me how to set up a GPO in server essentials I would be very grateful.
BCC is bad but reply to all is far worse. I appreciate that etiquette requires you to copy in those people that the original sender felt would be interested in the subject, but once a two way conversation has been established reply to all simply increases the number of useless notifications and doubles the time you spend replying, thinking about the other, non-interested parties who may receive the email. If someone is copying the world in to cover their [***] then let them forward replies to their boss if they must.
Finally,why is it that people will delete an email but somehow cannot reach closure by emptying their deleted items folder when they exit Outlook?
Excel
Honest to God, I've seen this happen THREE times in my 24-year professional career:
Some user uses Excel (or Lotus 123, Quattro Pro or any other spreadsheet) to lay out a table of data -- then MANUALLY adds up the rows/columns and enters the totals as raw values in the total cells (instead of a SUM formula). Would be bad enough for one-time tables but these were on-going templates that were constantly being updated (and re-totalled manually!).
And I echo max.lee's comments -- a particular sin of accountants -- always using Excel when a proper database application would be the better choice.
Excel
Honest to God, I've seen this happen THREE times in my 24-year professional career:
Some user uses Excel (or Lotus 123, Quattro Pro or any other spreadsheet) to lay out a table of data -- then MANUALLY adds up the rows/columns and enters the totals as raw values in the total cells (instead of a SUM formula). Would be bad enough for one-time tables but these were on-going templates that were constantly being updated (and re-totalled manually!).
And I echo max.lee's comments -- a particular sin of accountants -- always using Excel when a proper database application would be the better choice.
I once saw a colleague using a calculator while starring at an Excel spreadsheet. I found out that he did not know you could multiply and divide in Excel. His reaction was amazing when I showed him how to do it properly in Excel. We had several courses from beginner to advanced level that the staff could book and go on but this person was too embarrassed to go so carried on for a few years with very little skills!
Excel is a calculator.
Honest to God, I've seen this happen THREE times in my 24-year professional career:
Some user uses Excel (or Lotus 123, Quattro Pro or any other spreadsheet) to lay out a table of data -- then MANUALLY adds up the rows/columns and enters the totals as raw values in the total cells (instead of a SUM formula). Would be bad enough for one-time tables but these were on-going templates that were constantly being updated (and re-totalled manually!).
And I echo max.lee's comments -- a particular sin of accountants -- always using Excel when a proper database application would be the better choice.
I once saw a colleague using a calculator while starring at an Excel spreadsheet. I found out that he did not know you could multiply and divide in Excel. His reaction was amazing when I showed him how to do it properly in Excel. We had several courses from beginner to advanced level that the staff could book and go on but this person was too embarrassed to go so carried on for a few years with very little skills!
Funny enough!
I see this everyday.
I have not used a calculator for over 15 years whilst I am in front of PC. I always open a new book, use it as calculator, but I do not save the file and forget it by the end of the working day.
Can anybody explain how to stop Excel turning some of my figures/calculations into some sort of code, usually beginning with E.
Thanks
G
@Georgia, I expect someone can. And. Training.
Try an excel forum, or the help.
The only formal course of Excel I ever took was an advanced one (Excel 2003 at the time, though it was probably about 2007). It didn't cover PIVOT tables, matrix operations, solver, the stats functions, getting and linking to external data, even simple macros or named ranges all of which I had been using (external data, PIVOT's, names and macros everyday... and always) for years. So, it didn't seem all that advanced to me. I'd learnt from the help system and bought a book or two.
Only thing I recall it introducing to me which I wasn't already aware of was the watch window and error checking, which I now use occasionally.
Word styles. Now, that I can totally echo. However, my experience is that it is generally senior, not junior, members of staff whose ignorance of Office causes the worst productivity misses and so often causes lower levels to dumb down their work. For example they might ask you to update, say, an Accounting Procedures Manual, of which there are multiple copies and no clear master, and which you discover has been written entirely without the use of styles (which have been available at since the early 90's). They then wonder why it takes so long to update and hence, why it gets updated so rarely in huge efforts rather than in an ongoing fashion and incrementally. They don't understand what you are trying to communicate to them in saying that it is worth the investment to rewrite it with styles. Just an example. Of course that never happened to me.
Emailed spreadsheets, even network stored spreadsheets versus sharepoint, Don't get me started there....
Still for all my IT skills, my experience is that to get on, at least the places I've been, it's much better to be socially adept and technically useless than technically able (assuming you aren't a complete rain man) unless you are young in which case senior staff don't feel threatened by you.
Languages (real one's not IT ones) are similar, we're always being told how valuable they are, but, even with them, for the most part I've found that it's social connections that count more.
I guess I'm a glass half-full guy....
This might as simple as increasing the width of the columns
More likely it's the number format...
Right click on the cell and choose Format cell and change the format from general to number with a
zero number (or whatever number you want) of decimal places.
Scientific Notation
Gorgia,
What you're seeing is a numeric value being expressed in scientific notation format. Easiest way to explain it is through example:
235,100,000 = 2.351 X 10^8 = 2.351E+8 (where "E" means "base 10 to Exponent of ___" ("8" in this case)).
99 out of 100 times in Excel, scientific notation is used when there's a very TINY value being presented -- usually when performing calculations where you rounding is needed. so, 102.00000000004 would be expressed as 1.02E+2 (Excel is "smart" enough to realize that the very small decimal portion is irrelevant but, it will tend to express the number in scientific notation anyway - a hint to you that the value isn't exactly 102).
How to fix:
- use the ROUND(x) series of formulae in the cell in question
- use cell formatting to control the outcome presentation (this is probably the most common approach used)
Hope this helps!
Great article, we find the more powerful systems we upgrade to over the years, the more Microsoft do a great job of ensuring their latest MS Office suite completely uses approximately 100% of your CPU usage. It's absurd.
We made the business decision of switching away from Microsoft a few years ago now although there's frustratingly always the need to revisit Word and Excel occasionally.
Microsoft aren't alone in being the biggest thieves of time in the world of software either!
MS Project - now they've made it all whizzy bang
I'm sure the original MS Project software was simpler. Ok it didn't do so much but neither did it 'recalculate' (ie delete) loads of your work without asking or offering an undo option.I think in giving it more 'functionality' MS have made it harder to use and understand, and still it can't seem to look across projects to see that person A is working on 5 projects in week x, and can't be in those 5 places at once!
Is anyone doing a retro version?
funny :-)
Funny article, but so far from the truth. I've been consulting on spreadsheets, primarily Excel, and Microsoft Office for almost 20 years. Although I've come across one or two "hohos" they are few and far between.
The issues described here are mainly TRAINING issues, easily overcome with a quick helping hand.
Whatever you do, don't think of this article as being indicative of the majority of users. It's a fun article and no more than that.
Changes to the user interface
It’s not just people missing useful features or doing something in an inappropriate tool, but the way Microsoft like to ‘enhance’ the product by changing the user interface (UI). Personally I deliberately kept away from Office 2007 and then moved from 2003 to 2010, but that was painful as pretty much everything had moved location…I could find nothing and had to relearn the new locations of often-used features.
It wasn’t as if the organisation was actually better, there were (are) still inconsistencies, it’s just it was now inconsistent in an entirely different way. I do wonder what the UI designers at Microsoft might think if they took their car in for a service, only to find when they collected it, some well-intentioned mechanic had entirely changed all the controls around ‘for enhanced ergonomics’, but which meant they could no longer find any control.
At the time of my migration to Office 2010 I saw a wonderful ‘rant’ by someone doing a little maths based on the number of people in their Corporation each spending just 10 mins finding where some often-used function had moved to. I certainly used a lot more than 10 mins finding numerous functions in different parts of Office. By multiplying things through they easily got to a cost of $10M for the change between Office 2003 and 2010 and wondered if Mr Balmer would like to credit them for their loss in productivity.
Personally, I think a big part of the issue is Office is getting to the point of VCRs which seemed to come out with more and more unused functions to entice people to upgrade machine, when all they needed was record, play, rewind and eject. Office is in a similar position as it does more than enough for most people, yet Microsoft needs a way to ‘add value’ to keep up revenues which is why they’re now so keen to move people to a subscription basis and Office 365. My view is much of the ‘UI tweaking’ is as much to do with their revenue targets as it is really adding to the product…all IMHO of course :-)
Totally agree
I was 'out of the office' (working with my hands, not in prison!) when this change happened, when I came back I had to virtually relearn how to use excel!
Not a criticism of Office...
Thanks for all the comments so far. I'd just like to point out that the article was not intended as a criticism of the software itself, but rather to emphasise how useful training can be in avoiding wasted time and effort. But then, as someone who earns their living by training on the Office products, I would say that wouldn't I?
E - scientific notation
Hi Gorgia - this is Excel's 'scientific notation' number format. It is often applied automatically if a column is too narrow to display a large number. First thing to try would be to make the column wider. If that fails, check the number format and if it is set to scientific, try a more 'normal' format - possibly with a wider column as well.
Format it as text
Hi Gorgia - this is Excel's 'scientific notation' number format. It is often applied automatically if a column is too narrow to display a large number. First thing to try would be to make the column wider. If that fails, check the number format and if it is set to scientific, try a more 'normal' format - possibly with a wider column as well.
Simon,
Another way would be to first format the column(cell) as text in a new blank column(cell), then copy the data with sci format in to the newly formatted column. Now, you should be able to see the entire column. It may not work if you try to format it on the original(existing) data.
Scientific format
Hi Cantona1
Unless I've misunderstood your suggestion, I think at a particular point (E+11, E-10?) the format will switch to scientific notation even when formatted as text.
Hi Simon,
No, so long as the copied data are pasted on the same formatted cells.
Let' say, you have your sci data in column A. Let's also assume column B is blank. Format column B as text (Entire column). Then copy column A in to column B and see the result. The data are now read by excel as text.
Yes, if you paste the sci data in to column or cell which are not formatted as text, it will revert to sci format.
Happy Christmas
Hi Cantona1
It didn't seem to work for me with values over a certain level. On the plus side it did seem to generate a passable imitation of a Christmas tree...
Back to the point of the article
I think we might have collectively found another way of wasting vast amounts of time using Excel, discussing number formatting...
It was probably just as well no one took the bait on the fishing diversion. Not even any sole practitioners...
Excel - there is always another solution out there
I'm think I'm pretty good at excel now - I learned the hard way!!
Many moons ago I had to get an expenses excel form out to staff and I a looking for a grid outline- either in a table or a sheet. (Mind this was pre google)
I tried and tried - couldn't find it in help - the more I tried the more I could not see it. In desperation I found a rather long winded solution - I outlined every single box on the sheet one at a time (around 200+) - I got it done and it did work.
In taught me the importance of searching for a better solution if its taking too long.
Office has become bloated
I would certainly agree with the comments so far noting that Office now contains far more functionality than anyone will need, in the interests of making it (a) universally applicable, and (b) a reason for a new version therefore requiring upgrade and driving revenues. My personal bête noir is the Themes facility, which is not much use to most users who only need one or two templates, is unfathomable to the user who has no desire to go through a lengthy learning and familiarisation process, and obscures the styles which is all most users are interested in.
There's lots of useful 'under the bonnet' stuff in recent releases, I know, but in terms of the actual user interface, I think Word peaked several years ago.
Forget word ect the internets the killer.
Its the same for all Computer Software, keep everything as simple as you can.
Word is fine, up to a point, Excel is great, but do not over reach yourself, - ignore bullshit upgrades its the same thing they try to sell you twice or thrice .......
Outlook and emails are a waste of time, its just a way of covering your back.
Oh yes the internet is the best thing ever whilst also being biggest waste of time ever.... dont ask.