Excel 2007 and 2010 have a quick way to see basic stats on a list of numbers. If you only need some basic details about a list of numbers, there’s no need to use Excel formulas or the Descriptive Statistics feature. In Excel 2003 you can select two or more cells to see a total […]
What can you do if Office product activation is refused? From time to time we get messages from readers who are having problems activating their copy of Microsoft Office. If you’re not getting what you think you paid for, ask Microsoft to explain. What you see on the screen isn’t the last word on the […]
How to stop typing replacing or overwriting text. Daysha B writes “What I type replaces my existing text. How do I turn this off? Thank you.” As usual with Microsoft Office, nothing is as simple as it first appears. Most people probably know that the immediate answer is ‘Press the Insert key’. Insert (Ins) often […]
A primer on measuring data variance in Excel. by David Goodmanson Let’s continue our look at the basic statistics functions in Excel. In our first article we looked at statistical functions that measured central tendency or averages. Most people understand Average or Mean though Median is often misused. Now lets look at a more difficult […]
It’s too late for Christmas cards but not too late for a simple Xmas Email. We’re the first to admit that sending a Christmas email isn’t the most traditional method but it can be done with good cheer and grace. Here’s just one example from a friend and some tips from the writer and designer […]
