44 posts tagged with microsoft and excel. (View popular tags)
Displaying 1 through 44 of 44. Subscribe:
How do I keep a particular tab in Word2007 from automatically disappearing? And other Word2007 and Excel 2007 questions inside. [more inside]
posted by jujube
on Dec 17, 2009 -
15 answers
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]
posted by kenzi23
on Sep 30, 2009 -
2 answers
How can I count certain things in a range of cells in Excel that fall between two dates? [more inside]
posted by SansPoint
on Sep 2, 2009 -
5 answers
I need to make a template for an in-print events calendar, and I'm not sure what the best way to approach this project is. Advice please! [more inside]
posted by soviet sleepover
on May 5, 2009 -
2 answers
I need a custom number format for Excel that only gives me a decimal when I need it. [more inside]
posted by lou
on Apr 26, 2009 -
5 answers
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]
posted by cheeken
on Feb 5, 2009 -
14 answers
How can I close DDE connections? [more inside]
posted by slavlin
on Dec 18, 2008 -
1 answer
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]
posted by urban greeting
on Dec 4, 2008 -
3 answers
How do I get 'rock hard' Microsoft Office skills? [more inside]
posted by greytape
on Oct 29, 2008 -
8 answers
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]
posted by Mokusatsu
on Oct 17, 2008 -
3 answers
I want to build a web app based on an Excel spreadsheet using VBA and some Excel Solve functionality. Should I try to build my own online spreadsheet? Or is Microsoft about to release some nifty online development components compatible with Excel and VBA? [more inside]
posted by Mokusatsu
on Sep 12, 2008 -
2 answers
Can I use Excel to loop through lists of names and sum up numbers for each name, without having to define the cell ranges that correspond to each name? [more inside]
posted by korres
on Feb 5, 2008 -
4 answers
How can I conditionally format an entire row in Excel 2007 based upon the contents of a particular column in that row? [more inside]
posted by ChasFile
on Feb 1, 2008 -
8 answers
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]
posted by beammeup4
on Jul 2, 2007 -
10 answers
How do I add a 4,000 name MS Excel file to an existing MS Access database? [more inside]
posted by 2bucksplus
on Jul 2, 2007 -
3 answers
How do I cut/paste a project in MS Excel and not have my formula cells change with the movement of my cells? [more inside]
posted by mi6op
on Feb 5, 2007 -
4 answers
Excel question: How to define a range so that it always adds up to a constant value. [more inside]
posted by corpse
on Jan 16, 2007 -
20 answers
Why is Excel not opening? [more inside]
posted by thetenthstory
on Jan 13, 2007 -
7 answers
My girlfriend is going for an interview where she will be tested on Microsoft Word and Excel. Is there an online tutorial where she can take some sample tests or run through some applications? We've googled a few, but they seem to stop at beginner levels and to be rather cumbersome. Just wondered if anyone had some first hand knowledge of a site to head to.
Regards/p &k
posted by patrickje
on Nov 16, 2006 -
5 answers
I've got an Excel spreadsheet with numbers ranging from 2,000 to 600,000. I want Excel to look at each cell and essentially categorize all of those into five categories in a new column. If the value is less than 10,000, I want Excel to give it a 1, if the value is between 10,000 and 50,000 I want it to be 2, if the value is between 50,000 and 100,000, I want it to return 3, if it's between 100,000 and 500,000, I want a 4, and if it's above 500,000, I want a 5.
I tried the IF function, but I can't figure out how to a) make it recognize multiple variables, and b) I don't know how to tell it to look for numbers within a range. The Excel help section about arrays and lookups is fairly mystifying. Anyone got an idea?
(I know I could sort the data and do this manually, but I'd like to learn how to do this Excel's way.) Thank you!
posted by stonefruit
on Nov 9, 2006 -
14 answers
Some colleagues are trying to export a MS Access report to Excel. Here's the error they get: [more inside]
posted by ao4047
on Nov 6, 2006 -
4 answers
It's very clear in Microsoft Excel how to calculate formulas using external references, but what isn't clear is how, in several worksheets, to have the same data in certain columns. How do I do this? [more inside]
posted by arimathea
on Aug 8, 2006 -
9 answers
MS Excel XP: What is the keyboard shortcut to highlight a cell? My searches turn up no answers.
posted by bigmusic
on Jul 8, 2006 -
8 answers
A friend has a large list of address labels in column format which were created in Excel, then exported to Word. He no longer has the original Excel file. [more inside]
posted by empyrean
on Jun 6, 2006 -
6 answers
ExcelFilter: I need help creating a pie chart as a separate worksheet in Excel that counts how often values appear in a column and creates a pie graph based on that data. I'm stumped, I'm not using the right Google terms, and my company's help desk couldn't guide me through the process, either. (That sounds awkward, so I describe it more comprehensibly inside.) [more inside]
posted by WCityMike
on May 19, 2006 -
9 answers
MS Excel: How do I convert a number representing seconds into minutes:seconds? [more inside]
posted by contessa
on Apr 3, 2006 -
13 answers
Elite Tech Support Needed. Where does what's left of this plugin live? This one is elusive.... [more inside]
posted by tiamat
on Feb 22, 2006 -
6 answers
ExcelFilter: How do I convert a column of names formatted Smith, John into John Smith. Feasible?
posted by furtive
on Feb 9, 2006 -
8 answers
I've got two columns in MS Excel. They each share 200 numbers. However, one of the columns has an additional 700 numbers. I want the column with 900 sorted in ascending order, with like numbers from the column of 200 beside those in the column of 900. How do I do that?
posted by panoptican
on Feb 8, 2006 -
18 answers
Basic Microsoft Excel question. How do I join two databases together when they share elements but are not coextensively equal? (More) [more inside]
posted by Mr. Justice
on Jan 22, 2006 -
8 answers
Microsoft Excel help needed. [more inside]
posted by teem
on Jan 11, 2006 -
11 answers
I'm looking for advice on teaching basic Excel skills to adults in a classroom setting. [more inside]
posted by jessamyn
on Oct 10, 2005 -
17 answers
I used to think I was good at Excel. I could add, subtract, multiply and even use PivotTables! But I have a big problem with Excel: Why does it jump to cell 65,000 occasionally when you try to copy and paste? [more inside]
posted by Happydaz
on Jul 4, 2005 -
6 answers
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]
posted by anastasiav
on Jun 16, 2005 -
4 answers
Is there some way to link an Excel spreadsheet and Word document such that a portion of the Word document will update automatically from changes in the Excel file? [more inside]
posted by nelleish
on May 30, 2005 -
6 answers
Embedding linked Excel 2003 worksheets in a Word 2003 document for portability is giving me pains! [mi!] [more inside]
posted by hominid211
on Feb 4, 2005 -
3 answers
Excel formula question. Using Excel as an employee scheduler and need to help trying to create a formula for tracking. [more inside]
posted by cyniczny
on Feb 1, 2005 -
3 answers
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.
posted by RavinDave
on Sep 14, 2004 -
13 answers
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!
posted by anastasiav
on Jul 16, 2004 -
4 answers
I'm looking for a good, but very basic Excel tutorial. I'm somewhat familar with computers at large, but suddenly faced with an office productivity application my eyes are rolling up in my head and I'm drooling liberally. [more inside]
posted by elwoodwiles
on Jul 10, 2004 -
2 answers
RE: Excel: I have an Excel spreadsheet where one column is filled with dates — but the dates aren't showing up properly in the spreadsheet. Instead of looking like a date, they are flat numbers (02/29/2004 is rendered "36584" in the display) — even though the proper date is revealed in the FORMULA BAR as I select each cell. I've set the text type to DATE in the FORMAT dialog... I've even tried setting the text type to PLAIN TEXT. No go. Strangely, the numbers increment with the date (03/07/2004 is "36591"), so I'm guessing there's some equation going on. Suggestions on getting the dates to render properly would be appreciated.
posted by silusGROK
on Jun 25, 2004 -
10 answers
Is there a way to cut'n'paste charts from Excel into Word, without generating huge Word files? I've tried varieties of paste, 'paste special,' and so on, and I can't figure out why an Excel file of charts that's several hundred KB, always turns into a Word file that's at least several MB. I guess I'm missing something obvious, but have no idea what it is.
posted by carter
on Jun 24, 2004 -
8 answers
Mostly an Excel question (though maybe crossover to PDF). [more inside]
posted by dobbs
on Jun 15, 2004 -
3 answers
MS Excel appends a 1 to the name of every file I open. How do I get rid of this? [more inside] [more inside]
posted by trillion
on Feb 20, 2004 -
9 answers