Discussion on:

16
Comments

Join the conversation!

Follow via:
RSS
Email Alert
1 Vote
+ -
Thanks a lot for sharing such valuable information with examples. I think such articles may help to develop advanced skills of MS Office and any other application.
Many thanks for this informative piece. It gave me added knowledge on how to make my excel more presentable. I will share these techniques to my friends... Thanks a lot and more power!
0 Votes
+ -
Contributr
I'm glad you found the tips useful -- it's always good to hear what you guys really need!
0 Votes
+ -
to our accounting folks. I hope for less boring spreadsheets soon!
0 Votes
+ -
Valuable!
rjdbnet 8th Mar
I appreciate your hard work.
In the article "10 advanced formatting tricks for Excel users", which was very informative, I have one point to raise.
Churchill said that the USA and the UK were two nations divided by a common tongue.
Item 4 says "The pound sign combined with the two comma characters displays a character in the millions position, if one exists." In the UK the pound sign is our currency symbol, which, if used as per the example, would not work. We prefer to call that symbol the hash sign.
I once worked on a system that was to be hosted on two main-frames, one on each side of the Atlantic. When I spoke of "scrubbing" data, i.e. cleaning it up to get commonality across the "pond", my American colleagues promptly deleted it.
0 Votes
+ -
They were wrong
DT2 11th Mar
Actually, the American team that deleted the data should not have. "Scrubbing" means the same thing here as it does in the UK - at least in my office.
0 Votes
+ -
. . . they did. And we were all working for a US multi-national!!
0 Votes
+ -
Contributr
I'm glad you shared that. You might have helped a lot of British readers! Thank you!
Love your work, Susan. Always get some really practical tips from your articles. Many thanks.
0 Votes
+ -
Ryk
Ryk 12th Mar
Wow -- several formatting tricks in this article that I'd never heard of. Great job, Susan! Now, if only I can remember them...
0 Votes
+ -
Contributr
I just run a search on the keywords, add my name and site:techrepublic.com, and BAM! There it is! happy

Thank you -- I'm glad you found the tips useful!
Brits put a spare tire in the boot...we put our foot in our boot (and sometimes in our mouths) LOL Wonderful place to visit in the summer but the winters are brutal.

Thanks for the Excel tips.
0 Votes
+ -
Tires
stn564@... 12th Mar
Correction....Brits put a spare tyre in the boot. (this might tire them happy
@pugwash LoL, quite interesting article and comment,
0 Votes
+ -
Here are some more funny but interesting tricks in Excel.
Keyboard Shortcuts:
Prev
Next
Toggle
Join the conversation
Formatting +
BB Codes - Note: HTML is not supported in forums
  • [b] Bold [/b]
  • [i] Italic [/i]
  • [u] Underline [/u]
  • [s] Strikethrough [/s]
  • [q] "Quote" [/q]
  • [ol][*] 1. Ordered List [/ol]
  • [ul][*] · Unordered List [/ul]
  • [pre] Preformat [/pre]
  • [quote] "Blockquote" [/quote]

Join the TechRepublic Community and join the conversation! Signing-up is free and quick, Do it now, we want to hear your opinion.