Lately I’ve started getting questions from the online forum Quora in my inbox. Maybe because I’ve answered a question or two, they think they’ve found a new source.
Mostly I ignore these questions, because who has time. But recently, I answered the question, How can I have multiple scatter plots and one trendline for all of them combined in Excel. Then I decided it was worth turning my answer into a blog post, Add One Trendline for Multiple Series.
A few of the questions have been interesting. I thought I’d share them here and see how you readers might answer them. You can answer in the comments, or if you’re ambitious, you can click on the questions and answer them in Quora.
I have tracked a lot of random stuff in Excel worksheets, and I don’t think I can even remember the most random things. I’ve been tracking my weight almost every day since mid-2006.
I’ve been tracking traffic to my blog and sales of my software products for nearly as long. I guess website statistics, business performance, and even personal health metrics aren’t very unusual.
What random things do you track in Excel?
There are a lot of long-winded answers to this question. My answer went like this:
What I’ve heard is that everyone only uses 10% of the features. But the 10% I use probably overlaps with only half of the 10% you use. Of course some features are used by everyone, and some are used by hardly anyone. But I doubt there are very many features that nobody uses.
Nowadays, Microsoft wouldn’t even consider designing a new feature that users weren’t already clamoring for.
Are you serious? Employers want to know if you can already work with these important tools. If you can’t, why not, and how long will it take to get you up to speed?
That’s actually an interesting question. I guess the motivation is that you can install on a flash drive, then carry the flash drive around with you and use Office on any computer you plug it into.
Of course, the program files go in one place, and all the registry information goes another.
Never mind that it’s becoming harder with Office 365 to install Office into a custom path. And I suspect there is a check that the installation path is on a hard drive and not some removable medium.
My pet peeve in Excel varies from day to day, or minute to minute, depending on what just ticked me off. Usually it’s a shortcoming in the VBA Object Model, though there have been some formatting issues that can irritate me (how about that Office color theme system?)
I’m sure everyone has their own answer to this one: what’s yours?