I'm the SharePoint admin for a Scientific Affairs department, about thirty people. Half of our people are at our corporate headquarters, half are scattered around the globe. I feel like we have barely scratched the surface of what SharePoint can do, but I don't know how others use it. [more inside]
I am using PowerPoint 2010 on a PC. Normally when you insert an image then crop it, you can click on the image while the crop handles are still live and drag the image around, then reposition it within the crop, before actually applying the crop. But it's not working like that anymore! [more inside]
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]
For some recent while, probably since updating the OS X Mavericks, Microsoft Word for OS X keeps coming to the foreground on its own when I'm doing other things, as long as a document is open in Word. If I click out to the Finder, Word makes itself the frontmost program. If I click into the browser, Word comes forward. [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?
I'm considering a Microsoft Surface (the cheaper one with Windows RT) for basic productivity work, but it's been so maligned that I'm scared of it even though it seems to make sense. [more inside]
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?
I am working with long Word documents with many footnotes and appended documents. Most footnotes contain "See Appendix [#]" and the "#" is manually entered. Is it possible to create a system in which subsequent appendix numbers auto-populate to 'previous # + 1', similar to 'above cell + 1' in Excel? [more inside]
I use WordStarter 2010. I'm editing footnotes in a manuscript for a client, and have discovered to my great dismay that WordStarter 2010 doesn't have footnotes enabled — I can change the wording in existing notes, or delete them, but not add new ones or renumber existing ones. Does anyone have any suggestions for a work around that won't involve my having to buy Microsoft Office?
Microsoft Office forensics: Is there any way to discover the true original creator (or pinpoint a machine or login, maybe) of a Microsoft Office 2007 document after it's been moved around and edited--AND the author field under the document's properties within Office was only listed as "Generic"?
What are the best free and paid resources or training courses for Excel? [more inside]
I'm on Mac OS X, Chrome, Gmail. How do I get MS Word and Excel to play nice with Gmail? Right now, when I go into Word or Excel and click File/Send To/Mail Recipient (as Attachment), a Mac Mail window opens up. Same thing if I happen to click an email link in a Word or Excel doc. I've installed Gmail Notifier, which opens a Gmail window for mailto: links on web pages, but doesn't help with Word or Excel. (In Mail, I've gone into Preferences/Default Email Reader and selected Gmail Notifier (1.10.7) but this makes no diff.) So: how do I make Gmail the default email client for Microsoft Office "send to" and "mail to"?
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]
I've switched over to a MacBook Pro for work and Outlook 2011 is currently driving me batty. I'm used to Outlook 2010 for PC and am getting frustrated with some features that don't seem to be available. I'm looking for solutions to the following... [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.
Is there a way in Word (2007) to highlight a text string and then have the highlighting print out also. [more inside]
n00bfilter: formatting hard drive, need all the help I can get! Specifically with Windows XP. everything inside... [more inside]
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]
I need a suggestion for a video card to create a dual-monitor setup for my assistant. I'm not as concerned with getting too little power in a card as I am paying for much more than I need. [more inside]
A friend of mine is a schoolteacher with the Chicago Public Schools. On his Mac, he uses Office 2004. He was showing me a feature in the Office 2004 version of Word that I really like. It allows you to open up a document in something called "Notebook Layout View" (I think) that simulates a page of ruled notebook paper as if you were writing in a spiral notebook. It even allows you to format a title and heading and other features. Anyone know if there is a Vista equivalent for Office 2007? I tried looking through the templates (both what's included with 2007 and at Microsoft Online) and I can't seem to find anything similar. (and please, no flames or exhortations to "get a Mac!" I'm stuck with I have and there's no changing for the time being) Thanks!
My Win XP laptop came with a trial version of Microsoft *small business* office 2007. Without really thinking about it, I imported a lot of email and Outlook data from my old laptop. Now that the trial is almost over, I bought a retail copy of Outlook 2007 and the Home/student version of Office 2007, and the product keys don't work, since I'm trying to use the product key on the Small Business edition. Can I simply uninstall the trial small biz version, install the Outlook and home/student office, and have my Outlook data intact? Or is there more to be done to accomplish this?
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]
BoringFilter: I have to send out a large group of emails (around 175), and I would love to use mail merge to do it, but there is an annoying twist... [more inside]
How to access information and files embedded in Microsoft Onenote on a Mac? [more inside]
Powerpoint Filter: How can I set the default font size for a chart axis in powerpoint 2007? [more inside]
Excel Experts: Is there a way to apply a custom formatting template to an unformatted worksheet? [more inside]
I'm trying to clean up my act and bought a legitimate copy of Office for my Mac. Problem is, after deleting my (bootlegged) copy, it's still recognizing that copy over th legimitate one. What's up? [more inside]
All of a sudden, my G4 iBook is incredibly unstable. All sorts of programs keep crashing (though not the whole machine). What could be wrong? [more inside]
What is the easiest way to set up Microsoft Office Small Business Accounting 2006 for a simple business? [more inside]
MailMergeFilter: I want to print a large number of uniquely numbered gift certificates for different businesses using Microsoft Office, and I can't seem figure out a good solution. [more inside]
I play with a rather large and multi-layered database. Using the Enter Parameter Value function, is there a way to make that Prompt box into a drop box displaying all the options? [more inside]
I need to have everyone 'on the same page' so to speak. [more inside]
Let's say that I got a new computer without MS Office on it and I install Open Office. Let's also say a person sends me a Word or Excel file via email. Will I be able to read it and edit it in Open Office without messing up the format? If I make any changes to the file and email it back to my friend, will he be able to read it and make further edits to it while using the Microsoft Office applications?
How can I get Microsoft word to paste things as plain text by default? Why would I want the formatting of the website I'm copying
my homework from anyway?
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.
Internationalising email in WinXP. My wife can read emails sent to her in Thai script using Outlook on our Win XP machine, but I can't work out how to configure the machine so that she can type in Thai (using out Thai/ English keyboard) in a non-html email. Outlook help mentions configuring using Microsoft Office Tools from the program manager - but that requires using the XP discs, which we don't have as it was preinstalled by the PC manufacturer. Anyone got any ideas? I don't want to change the language of the whole O/S/ (there's a download from microsoft.com to do that) as I don't read Thai. We're by no means married to Outlook; Moz, Opera etc would be fine. We have Thai fonts.