Grouping column by its values – and getting an accurate count (or sum)
Select the Column
Click the Data tab (or press Alt-A on keyboard)
Click Subtotal icon (or press B on keyboard)
To NOT show the wrapped text as ############ in excel
The cell formatting is set to text as it should be. Change it to SPECIAL.. That fixes it.
Do not place a bid – wait till the last 10 seconds of the auction.
Think of your MAX bid – a lot higher than the current bid. This is because – in the last few seconds – everyone will try … Continue reading
“Insert” from the top menu of PowerPoint
“Symbol” from the set of options.
Find “Wingdings” from the “Font” drop-down menu.
The check mark symbol is towards the end of the list of wingdings font symbols.
That’s it – pick the check mark … Continue reading
Outlook’s default color scheme is far too bright and hurts the eyes. Fortunately, some other themes are built into the product. To get to these options, navigate from the File menu
File-> Options-> General
And change the color scheme as shown below:
… Continue reading
For some reason, I prefer the inserts to be in the body as opposed to attachments. They are easier to get to (by the recipient) and they can be placed inside tables etc.- making the message more readable.
By default, Outlook … Continue reading
In Excel (2007 and above), place each list of values in its own column. Now,
Select cells in first list, then hold CTRL key and then select the second
Go to Conditional Formatting > Highlight Cells Rules > Duplicate Values. At this … Continue reading
How do you sync multiple devices to one iTunes?
In general, one iTunes instance = one device – try and change devices and you have a nightmare on your hands. However, I came across a method where I could at … Continue reading
From a DOS prompt, type echo %USERNAME% /domain . This should return your username as registered in the current domain.
Full Domain Name
I can never remember the full domain name – an easy way to look it up is to type … Continue reading