##
51 posts tagged with excel *and* office.

Displaying 1 through 50 of 51. Subscribe:

## What are some interesting facts about Microsoft Excel?

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]

## Make my task list easier

I need to create a list of tasks that rotate between a number of employees on a monthly basis. I'd like the ability to assign a variable number of tasks to each employee, so one person might receive one task and another two. Previously this had been done manually on an excel sheet; can you think of any way to semi-automate it? [more inside]

## Linking Excel data to Word docs: Portability?

I'm using Excel and Word 2007. Created Excel docs, created Word docs, certain cells in the Excel docs have data that must be embedded in the Word docs. This has been discussed here before, but only the method of creating these links (which was my method) but I'm just checking to see if anybody knows how to make this work when you move the document. All the links appear to be hardcoded absolute links to the Excel doc. Works fine on my PC, breaks on yours. Any way to get this functionality to be portable? [more inside]

## Is it possible to open multiple instances of Excel 2010 in Windows 7?

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.## How to transfer Excel data to Powerpoint easily?

I have a list of names on an Excel file. I'd like to transfer each name (along with other details) to one PowerPoint slide. Is there any way I can do this without having to manually type in each name?

## How big of a security risk is Office 2003 for my limited personal usage?

I am still using Office 2003 for personal use. It meets my limited needs perfectly well, and I want to avoid learning curves and costs associated with alternatives if at all possible.
I understand that Microsoft will no longer be issuing security patches for it soon, so there are potential risks in continuing to use it, but how serious are those risks given my actual pattern of use? And can they be easily mitigated by avoiding various features or behavior? [more inside]

## iPad iDiot

Help me turn my iPad into a work productivity tool. [more inside]

## Automated PDF modification

Is there an automated way of placing elements from one PDF file into another? Open to coding this via Python if a relevant module exists. [more inside]

## Excel colour schemes are making me go blind

How do I permanently change the colour scheme in Excel (2010) so that I don't keep on going blind due to other people's spreadsheets? [more inside]

## What are the dates for the 9th and 20th business day for the rest of this year and all of next year?

I need to quickly figure the 9th and 20th business days of each month for the rest of 2012 and all of 2013. Preferably not in a manual fashion. [more inside]

## Help this Mac user learn PC software for job hunt

How can I improve my computer skills for job hunt when I use a Mac and the software is for PC? [more inside]

## Help me find (and change color of) similar data in Excel!

Excel 2007 issue: I'm trying to have Excel mark matching data in two columns with some kind of color or formatting. [more inside]

## Panning for email addresses

How do I sort the (potentially) real email addresses from the garbage data in Excel 2003? [more inside]

## Good help forum for Office 2010?

Can anyone recommend a good, well-trafficked forum for Microsoft Office (particularly 2010) questions? Seems like this should be eminently Googleable, but maybe because there are so many of them, I'm not finding the one that is

*the*one. Thanks!## Excel hell

Excel 2007 filter: How do you change the dictionary language for specific cells/columns/rows? [more inside]

## Excel 2003 ... is an update making this product non-functional?

Why doesn't excel 2003 work on my computer anymore? [more inside]

## Need to print Excel spreadsheet so it turns out like a vertically-folded half-sheet card.

Need to print Excel spreadsheet so it turns out like a vertically-folded half-sheet card. [more inside]

## Word 2007 formatting question

How do I keep a particular tab in Word2007 from automatically disappearing? And other Word2007 and Excel 2007 questions inside. [more inside]

## MacgyverFilter: link sharing using MS Office

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]

## Looking to up my presentation skills in NYC

I'm looking for a job doing presentation graphics (in law firms, possibly financial firms); this is about 30% of my current job at a law firm. I'm one of very few "experts" at my firm which isn't very technologically advanced in this area, so I'm afraid that my skills won't cut it in the outside world. I need advice on how to upgrade my skills. [more inside]

## How to turn off Excel's 'Snap to Cell' when scrolling?!

Excel 2007 - How do I stop the scrolling function from jumping to the top/bottom of a cell? This happens using the mouse scroll wheel, when clicking the scroll wheel and moving the mouse (free scroll type of thing), and when using the scroll bars onscreen. [more inside]

## Everything looks like a nail!

Asking_for_friendFilter/ExcelFilter: I’ve built a pretty basic calculator in Excel to help people figure out how much to bill for partial months vs. full months. As you can guess, there's... [more inside]

## How can I download only Open Office Writer instead of the whole suite?

Can I download only OpenOffice Writer? [more inside]

## How can I study for the OPAC?

Has anyone taken the Office Proficiency Assessment and Certification (OPAC) test recently, or have documentation on what

*exactly*it tests for in Word and Excel? [more inside]## How do I get Word and Excel to work together?

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]

## Compare and output greater value.

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]

## Mac OS X / Excel problem - recovered file causing endless crashing

Mac OS X / Microsoft Office 2004 (Excel) crash and failed file recovery has left excel in an endless loop of restore and crash. Can anyone help me to find and delete the (unwanted) auto-saved excel sheet that is causing this problem? [more inside]

## Excel date arithmetic problem

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]

## I see you've used Microsoft Word before.

How do I get 'rock hard' Microsoft Office skills? [more inside]

## Stumped by VBA-ising an array formula in Excel

How to do a VBA version of the following array formula in Excel?
The following array formula (entered with ctrl,shift,enter) will produce the string 'Bank statement'!H842, which is the name of a cell I would like to be able to manipulate via VBA:
{="'Bank statement'!H"&MATCH(C1&D$39,'Bank statement'!A:A&'Bank statement'!C:C,0)}
[more inside]

## Automator workflows for Excel

Automator as an antidote to Excel tedium. Can you help me get through repetitive tasks with favorite Automator tricks in Leopard? [more inside]

## Question on converting numbers into formatted text with Excel.

Question on converting numbers into formatted text with Excel. [more inside]

## Excel 2007 issue.

What's wrong with my copy of Excel 2007? [more inside]

## excel macro n00b

I need help writing a macro that will divide a 5000 row table into groups of 30 rows, and find the average of certain columns in each group. [more inside]

## 2 + 46% = ?

I need some really REALLY basic spreadsheet help. I've been given the task of creating a spreadsheet that will work out for us several things - how many orders we need in total and per week, how much revenue this will bring, etc. I've got most of it worked out, but I can't for the life of me how to work out percentages.
Yes, I did Google this before asking. :D [more inside]

## How do I get my table rows to stay clumped in fives?

How do I get a the rows in a table to stay clumped in fives even if I add or change the data?I have a long list of data that I need to arrange in a table, and I want the rows grouped together in fives. I'm currently working in Microsoft Word, and what I've got looks something like this Google Doc. I want the table(s) to stay grouped like this even if I add, delete, or change the data. If I just use the Word tables, adding a new line to a group will just create an extra row. [more inside]

## Spreadsheet Cleanout

Help me remove unwanted spreadsheet info - I want to archive a massive buch of data from years of Excel spreadsheets but, I don't want to save all the extra gumph associated with macros and links in spreadsheets. [more inside]

## Merging Excel Sheets (With a Macro?)

MS Excel help needed. I need to set up some sort of automated merging macro in excel and am having trouble tracking down the best way. The details, and much [more inside]

## My Mac(Book) Sucks

Any advice for my MacBook Word / Excel / Powerpoint woes? [more inside]

## How to highlight cells in excel with a keystroke.

MS Excel XP: What is the keyboard shortcut to highlight a cell? My searches turn up no answers.

## Killing a Phantom Menu in Excel

Elite Tech Support Needed. Where does what's left of this plugin live? This one is elusive.... [more inside]

## PivotTableFilter

PivotTableFilter: Can I have columns by month if I have the full date? [more inside]

## Not Very Excel-lent

Suddenly, when I double click on an Excel document to open it, it won't open the document (specific details inside): can this be fixed without reinstalling Excel or Office? [more inside]

## Office of OS 9 Macros not working too well in OS 10.4

When I try running long complex macros in MS Word for OS X, created in Office for Mac OS 9.2, some of the macros are freezing/crashing. Perhaps even worse, the macros don't seem to be failing at the same point each time I try to run them. [more inside]

## Bibliographies in Excel

I'm working on my MA thesis and so have an enormous jumble of books, articles, and references kicking around. I am looking for an easy way to manage this. [more inside]

## Embedding Excel into Word

Embedding linked Excel 2003 worksheets in a Word 2003 document for portability is giving me pains! [mi!] [more inside]

## Tracking employee schedules with Excel?

Excel formula question. Using Excel as an employee scheduler and need to help trying to create a formula for tracking. [more inside]

## how can I include declinations in an Excel spreadsheet?

How do I format cells in EXCEL to accept numeric values in the form: -26:32 (or +26:32 ... that is, mm.ss but including the pos/neg sign)? I'm trying to compile a simply list of Messier Objects (astronomy) and can't figure out how to include declinations.

## How do I stop Excel from turning email addresses into hyperlinks?

StupidQuestionFilter:

Microsoft Excel 2000 v 9.0 - is there some way to stop excel from automatically turning email addresses into hyperlinks? Not just turning off the 'blue and underlined' format but actually not making them links. I've done it before in other versions of excel but I can't find a way to do it in this version. Thanks!

Microsoft Excel 2000 v 9.0 - is there some way to stop excel from automatically turning email addresses into hyperlinks? Not just turning off the 'blue and underlined' format but actually not making them links. I've done it before in other versions of excel but I can't find a way to do it in this version. Thanks!

## Advanced Excel tutorial suggestions

ExcelFilter: I've got a specific problem in mind [inside for the curious/helpful], but more importantly I'm looking for an advanced tutorial for excel. I'm looking to go from someone who is confident with excel to being a full-on pro. Books are ok, but I'd prefer internet (i.e. free) resources. I am using Office v.X for Mac, but I think most techniques will translate pretty well across platforms. I'm looking for things like recursive formulas, modeling theory, little-known tools/techniques, pivot tables, etc. [more inside]

Page:
1 2