I work extensively with Microsoft Excel, and I'm putting together a list of little known facts about Excel for a presentation. I haven't found much on the interwebs that's exceptionally interesting. Does anyone have any facts they can share that come from off the beaten path? [more inside]
posted by scottso17
on Jun 25, 2014 -
So, I just got promoted to a new position at my company (Yay!). Unfortunately, the new requirements involve scheduling a ridiculous number of people. It turns out my predecessor has just been doing dozens of iterations manually until one kind of worked, but every slight change puts a bunch of other things out of wack.
I feel like Excel could probably be capable of doing it, but I have no idea how I would go about designing such a spread sheet. [more inside]
posted by cacofonie
on Jun 19, 2014 -
I will soon be starting a project/new job that requires better Microsoft Office skills than I currently have. I've used Outlook, Word and Excel in a fairly basic way for years, but need to come to grips with some of the more sophisticated elements of those programs. Plus, I need to learn how to use Powerpoint and Visio, which I've never touched. Yikes.
Can you recommend some good online tutorials? I am also considering doing a paid course (online or otherwise) if I can find one based in London that's not too expensive or a rip-off. Can you help?
posted by handclaps
on Apr 25, 2014 -
Is there a good Access training option where you learn it by working in the program interactively rather than just watching videos or reading text?
posted by ewiley28
on Jul 25, 2013 -
Is there any way to save a query in MS Office 2011's Query Builder that isn't tied to a specific spreadsheet? [more inside]
posted by mph
on Feb 1, 2011 -
Microsoft Office 2007 filter: Can you recommend a program/plugin (or the like) which will replace the "ribbon" interface with a traditional menu interface? Free is ideal, but for-pay is okay, too. Running Windows XP. Thanks.
posted by Conrad Cornelius o'Donald o'Dell
on Nov 7, 2010 -
Spreadsheet question: Display Greater Value? I know this is one of those "you-either-know-it-or-you-don't" situations, and I just don't know. [more inside]
posted by guptaxpn
on Feb 5, 2009 -
Microsoft Excel VBA question: Converting decimal degrees to degrees-minutes-seconds (DMS), with rounding customization. [more inside]
posted by dondiego87
on Jun 10, 2008 -
Excel Experts: Is there a way to apply a custom formatting template to an unformatted worksheet? [more inside]
posted by kmtiszen
on Dec 12, 2007 -
How much should an Advanced Excel (PivotTable, lookups, etc.) hombre in Manhattan be getting paid? I've been temping in this hole of an office for a few months and almost all spreadsheetery has become my responsibility. I think some sort of raise is in order, but I'm not sure what my target should be.
posted by skryche
on May 27, 2004 -