Quick question about using MS ACCESS. Can you direct me to an online tutorial that quickly illustrates how to create or edit/manipulate and an existing report from excel data? I do have an existing report that can probably be modified, but I've never used access before. [more inside]
VBA and Macros and VLookup, Oh My! I might be ending up on a work assignment where they want someone who can create and edit complex Excel templates that interface with Access and Adobe Forms. I've used all these programs extensively, but I've only used advanced features sparingly (either editing someone else's creation or googling for a specific fix for a specific problem.) Difficulty level: I only have a week to cram on this before I would start. Is it possible for a quick learner to get up to speed enough not to crash and burn on a project like this? Can anyone recommend an online course I could binge on before having to take on this project?
I want to be able to open multiple instances of Excel 2010 in Windows 7 on a PC. This is the default for opening Word docs but for some reason Excel limits me to multiple windows inside one instance. Is there a way to do this? Challenge: I do not have the ability to edit the registry on this (work) computer.
Sweet mother of mercy, when did Microsoft decide it wanted me to go bald before graduating? [more inside]
My church is upgrading its computers and the old copies of Office are long since vanished, evidently. (If they ever existed; I kind of suspect the last person who did IT stuff may have pirated it.) So, we're buying new versions. But our office manager is... well, she's not at all computer literate. She's kind of continuing to be employed more on a charity basis than because she's actually very capable. But I need to get her able to actually use the basic features of Word, Excel, and Publisher on the new versions, in the simplest way possible that does not involve my personally sitting with her for days at a time. Help? [more inside]
Is it time to abandon LibreOffice/OpenOffice and go back to MS Office instead? [more inside]
What do you need to know to be "proficient" in Excel and Word? [more inside]
I'm trying to help a friend (via phone) who is unable to view some content on web pages for her chemistry class. From her description, I'm pretty sure that the content is an embedded Powerpoint slide. [more inside]
Seeking recommendations for on-line training on business applications, particularly MS Office. [more inside]
Where can I download a legit installer for MS Office Standard Edition 2003 with volume licensing? [more inside]
I inherited my desktop Mac from my girlfriend last year when she got a new one. We now live together and have our computers on the same network, and now MS Office complains that I don't have a license for this computer. Do I have any options other than buying a whole new MS Office license/package? [more inside]
Need help with (possibly?) "indirect" in Excel. [more inside]
Will I run into any formatting or track changes problems if working on the same documents in MS Office 2007/2010 for PC at work and in MS Office 2011 for Mac at home? [more inside]
How to prevent accepted tracked changes from carrying over into an excel + word + outlook email to 50 people?
Hi everyone, Hoping someone can help me sort this problem ... It's a excel + microsoft word document + mail merge to outlook email to 50 people. I am trying to help someone out - this is is as it just as it was described to me: Track changes were accepted and turned off and the email looked as it should - so off went 50 customized emails. ..unfortunately the sent email then shows that all the emails are sent showing all of the tracked change revision markings! Sorry if this is too vague. Thanks for your efforts :)
Outlook 2010 Filter: When I send an email from a shared inbox (standard exchange server), I need to fill out the "from" field. How do I get that field to display? I can only find a toggle for BCC. Thanks
What Themes and Style Sets to pick in Office 2007? Some design and typography advice please. [more inside]
How best to ensure consistency of output whilst using MS Office? As part of my role as a maths teacher I create (design) worksheets and presentations for my class. I spend a fair bit of time making sure things are consistent (e.g. Space for Name, Class), Header here etc. There must be a better way, using Forms? Templates? Themes? Can you suggest one, and some tutorials in how to best use. Thank you. [more inside]
My small IT services firm is being asked to bid for a contract for an ongoing MS Office training class. What is the going rate for this sort of training? [more inside]
Why is cmd+V bringing up the insert hyperlink dialogue, rather than pasting in Word? [more inside]
Help! My mother's old computer no longer works, and I am helping her set up the new computer. I am trying to retrieve files from the online backup service (Quicken Online Backup) and set up Outlook 2010 on the new machine (Windows 7). [more inside]
Passing an MS Office test with flying colors. [more inside]
Where can I download more attractive funnel chart templates for Excel 2007? [more inside]
Macgyver IT: I want my team to use something like del.icio.us to share links. But since this is ask.metafilter, I can't use the obvious right answer. I need to make something like it myself, using
bubblegum and string the MS Office 2000 suite and my knowledge of VB. What would be my best approach? [more inside]
Trying to get some modified AVERAGE results in Excel. [more inside]
Experiences with StarOffice? [more inside]
MS Word formatting issue: it applies any changes to entire document. How do I make Word only apply formatting changes to the selected text? [more inside]
I need MS Excel and Word to play together nicely. I can do what I need to in Word, and I can do what I need to in Excel; it's the Relationship that's Complicated. Maybe I need workflow advice? Basic knowledge? Please, please keep reading. [more inside]
MS Excel Question: If I have a column with a range of dates in it, is there a formula that will tell me how many years ago that date was from today? [more inside]
Word 2007. Table with cells with lots of text. Need to convert asterisks to bulleted lists. Example inside. [more inside]
Dual-Boot Macbook; OSX (home)/ Windows (work). Need MS Office on both without rebooting. Office 2007 on the Windows partition + Parallels seems to make the most sense. Anything I should know about? [more inside]
I need to do something very specific with Mail Merge (I think thats the best way to do it) but I have no idea how. Basically I want to take info from a spreadsheet and convert it into a variable number of different colored boxes of a constant size in a document. [more inside]
MS Excel filter: I'm editing a huge spreadsheet and Excel doesn't like my zip codes. How can I quickly fix this? more after jump... [more inside]
Word 2003 won't open after double-clicking on a document, and the mouse doesn't work in the document area. [more inside]
Someone gave me iWork '08 as a gift and I already have MS Office for Mac. I have no experience with iWork. Why would I want to use Pages instead of Word? Why would I want to use Keynote instead of PowerPoint? [more inside]
I'm trying to move MS Office Pro. 2003 to a new computer, but I'm having trouble. I've lost the certificate and CD, but can extract the product key... [more inside]
How much work will it take me to change from IE6 to Firefox? Looking at the list of problems in AMF, should a person not highly computer literate make the change? I use XP and have MS office installed and am now learning to write web pages -- CSS, HTML, Java.. Thanks in advance for your advice.
Help me become a Microsoft Vista and Office 2007 pro! [more inside]
MS Office question: How do I stop Powerpoint from using a single window to display all documents? I'd like to be able to look at two powerpoint files side by side and copy/paste between them, but powerpoint insists on opening them in the same window. [more inside]
I can't get a formula in excel to recalculate when copied and pasted to another cell. Help! [more inside]
OfficeApp Filter: How can I seamlessly convert lists of project assignment names and deadlines to a calendar view that can be shared? Or can I? [more inside]
Anyone else using Office 12 Beta? I've recently installed it on my laptop, and I can't find a way to synchronize Outlook 12 with my palm pilot. Anyone know how to do this?
Will I lose files by upgrading my version of MS Office from 2002 to 2003 Professional? [more inside]
Do you find that MS Office for OS X runs faster than MS Office for Mac OS 9...., run on an OS X Mac in Classic mode (or, whatever it's called...) [more inside]
How do I get 1200 people in three different countries upgraded from dumb terminals to PCs and MS Office?
Here's a question from 1992: How do I get 1200 people in the US, Canada, and Mexico up and running with PCs and MS Office from a previous dumb terminal environment? (More inside of course) [more inside]
I have something on my MS Word window I can't get rid of, and I think it's spyware. Pic of offending thing inside. [more inside]
I've been thinking about plunking down the cash to buy a licensed copy of MS Office (or Office XP, or Office 2003, etc.) for my new laptop. Can anyone tell me why I shouldn't just run Openoffice instead? From what I've read, it appears that I can "save as" most MS formats with it. Any firsthand experience?
Does anyone know of a program that will display metadata from Microsoft Office files (such as revisions from Autosave, track changes, etc.)? My searching has documented the range of metadata that is available and I have located numerous programs for removing the data, but nothing that will allow me to retrieve the data easily. I am looking for something a little more advanced than Notepad.