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]
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]
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?
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?
What are the best free and paid resources or training courses for Excel? [more inside]
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]
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.
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]
Microsoft Excel VBA question: Converting decimal degrees to degrees-minutes-seconds (DMS), with rounding customization. [more inside]
Excel 2007 - Is there a way to remove ONLY a duplicate row leaving the first unique entry? [more inside]
Excel Experts: Is there a way to apply a custom formatting template to an unformatted worksheet? [more inside]
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.