Skip

19 posts tagged with msexcel.
Displaying 1 through 19 of 19. Subscribe:

Data Base Administrators: Please lend a hand to a new assistant DBA

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]
posted by snsranch on Oct 21, 2014 - 4 answers

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.
posted by Wretch729 on Apr 22, 2014 - 12 answers

What is proficiency in Excel and Word?

What do you need to know to be "proficient" in Excel and Word? [more inside]
posted by ichomp on Jan 19, 2014 - 14 answers

Excel to Word mail merge for envelopes. Should be super-simple. ISN'T.

Whoever is formatting this excel sheet sucks. I need to find a way to fix it that doesn't entail me retyping the whole thing each week. [more inside]
posted by A neighbourhood park all covered with cheese on Aug 23, 2013 - 34 answers

Data sort help

Is there an off-the-shelf MSExcel function or 2.0 tool that will allow me to "return" a US City/State based on 5-digit US postal codes. I have 160 postal code queries to perform. The postal code data is in MSExcel. Something like this. I do not have MSAccess and I am a Mac user.
posted by jeffmac on Jul 4, 2012 - 9 answers

And maybe something with dollar signs I don't know

Need help with (possibly?) "indirect" in Excel. [more inside]
posted by phunniemee on May 16, 2012 - 21 answers

help me excel at excel

Excel-filter: Is there a way to copy a formula from a cell on one sheet (e.g., page 4) to a different cell on a different sheet (page 1), where the total from page 4 is carried over to page 1? [more inside]
posted by headnsouth on Oct 13, 2011 - 16 answers

Help me Excel at Excel(tm)

Recommendations for an online Excel refresher course, preferably free, that will make me an Excel God Master Wizard user compentant enough not to embarrass myself in 72 hours? [more inside]
posted by Mitheral on Sep 29, 2011 - 7 answers

Need Excel macro assistance.

MS Excel gurus: I am looking for a way to export the data from a spreadsheet so that it can be displayed in a Word document as text, with the column-headers as lead-ins for each cell of data. Basically I want to turn this into this. [more inside]
posted by Ike_Arumba on Apr 6, 2010 - 8 answers

Funnel Charts for Excel 2007?

Where can I download more attractive funnel chart templates for Excel 2007? [more inside]
posted by thankyoumuchly on Apr 1, 2010 - 2 answers

Excel solver macro help.

I have a column of around 100 equations that can only be solved with solver in Excel. Is there any way to create a macro for this purpose. The layout of the spreadsheet given below. [more inside]
posted by Lucubrator on Nov 1, 2009 - 3 answers

How can I filter out all but the latest entry in Excel?

MS Excel Problem: How can I filter out all but the latest entry for each unique ID? [more inside]
posted by Serial Killer Slumber Party on Jun 9, 2009 - 4 answers

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]
posted by cheeken on Feb 5, 2009 - 14 answers

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]
posted by Rock Steady on Nov 14, 2008 - 13 answers

Detect bold text in MS Excel

I have a very large MS Excel spreadsheet in Mac Office 2008 (yuk). I want to find every cell that contains bold text and append an asterisk to it -- i.e. "bold cell text" becomes "bold cell text*". I can probably find a Windows machine if necessary. How can this be done automatically?
posted by beniamino on Nov 2, 2008 - 4 answers

I know there is a way to do this! There HAS to be!

MS Excel question: Creating a master spreadsheet that dynamically updates when information is updated from any one of six other spreadsheets. Possible? [more inside]
posted by Diskeater on Jan 13, 2008 - 6 answers

ExcelFilter: I don't see an easy one-function way to get the initial letters of a text string in Excel. Is there such a beast?

ExcelFilter: I don't see an easy one-function way to get the initial letters of a text string in Excel. Is there such a beast? [=Text(MI)] [more inside]
posted by mwhybark on Sep 29, 2004 - 8 answers

Teach Me Excel

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

Searching in Excel

ExcelFilter: I want to determine if a given value is in a range of cells. A simple true/false evaluation would be sufficient, though returning a reference to the cell might be nice.
posted by namespan on Jun 3, 2004 - 4 answers

Page: 1
Posts