Join 3,512 readers in helping fund MetaFilter (Hide)

852 posts tagged with excel. (View popular tags)
Displaying 51 through 100 of 852. Subscribe:

Related tags:
+ (196)
+ (90)
+ (68)
+ (51)
+ (48)
+ (45)
+ (45)
+ (35)
+ (31)
+ (30)
+ (25)
+ (25)
+ (22)
+ (22)
+ (21)
+ (21)
+ (20)
+ (18)
+ (17)
+ (16)
+ (15)
+ (15)
+ (15)
+ (15)
+ (14)
+ (14)
+ (14)
+ (14)
+ (14)
+ (13)
+ (13)
+ (13)
+ (13)
+ (12)
+ (12)
+ (12)
+ (12)
+ (12)
+ (11)
+ (11)
+ (10)
+ (10)
+ (10)
+ (10)
+ (10)
+ (9)
+ (9)
+ (8)
+ (8)
+ (8)
+ (8)
+ (8)
+ (8)
+ (8)
+ (8)
+ (7)
+ (7)
+ (7)
+ (7)
+ (7)


Users that often use this tag:
TheBones (6)
malcommc (5)
willnot (4)
Anonymous (4)
zardoz (4)
desjardins (4)
FireStyle (4)
stupidsexyFlanders (3)
goethean (3)
anastasiav (3)
mwhybark (3)
keep it tight (3)
sdis (3)
Mr. Justice (3)
apark (3)
GilloD (3)
foxinthesnow (3)
SirStan (3)
jefficator (3)
corpse (3)
undercoverhuwaaah (3)
jujube (3)
Jackie_Treehorn (3)
skypieces (3)
ttyn (3)
bluejayway (3)
Conrad Cornelius o... (3)
thankyoumuchly (2)
Flunkie (2)
freddymetz (2)
ewiar (2)
bleucube (2)
jestonb (2)
underwater (2)
slavlin (2)
johnstein (2)
beammeup4 (2)
pdb (2)
pantufla (2)
nevercalm (2)
rossination (2)
johngoren (2)
digitalprimate (2)
Classic Diner (2)
bibbit (2)
SheIsMighty (2)
Rock Steady (2)
WCityMike (2)
nickerbocker (2)
panoptican (2)
nooneyouknow (2)
furtive (2)
ObscureReferenceMan (2)
bigmusic (2)
elgilito (2)
wtfwjd? (2)
Bugbread (2)
pwb503 (2)
Jimbob (2)
jessamyn (2)

Excel: parsing seating chart, names - How best to do this?

I have an Excel Workbook with seating charts for our theatre. There are 4 pages, one for each production. Each page contains columns for 9 performance dates and rows for every seat in the theatre (about 300). I need to get this all into one readable sheet that I can use. Read on (tasty screenshots inside.). [more inside]
posted by skypieces on Aug 9, 2013 - 7 answers

Control sheet excel inputs from sql

I am excited by the developments of BI capabilities in excel this year and I want to use the power explorer, view, mapping tools with my sql database. I have two questions really... 1. Can I extract individual calculations and data from the sql/data model rather than always through a pivot 2. If yes, or no, what would be the best way to build a control excel spreadsheet which monitors performance across key criteria (leads per day, orders per day, cancellations, etc) across regions so that I can see where the business is not operating as expected and act accordingly. Thanks Tc
posted by trashcan on Aug 3, 2013 - 6 answers

Rearranging the formula for Compound Annual Growth Rate

How do you rejig the formula for CAGR to get the starting value when you know the other variables? [more inside]
posted by MuffinMan on Aug 1, 2013 - 3 answers

Access Training similar to Excel Everest?

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?
posted by ewiley28 on Jul 25, 2013 - 2 answers

Excel tips - Tracking deadlines

I have an excel spreadsheet that contains a bunch of random information about some work projects. I'm looking for a way to quickly highlight and summarize upcoming deadlines. I'm already using conditional formating to highlight upcoming dates, but I need more than that. [more inside]
posted by Arbac on Jul 23, 2013 - 4 answers

How to Export All Sheets in an Excel File?

I am using Excel 2011 on Mac OS X Lion. I have a workbook created by a colleague with 25 worksheets in it. I would like to export all of these to individual csv files. Is there a way to do it all in one batch? [more inside]
posted by bluefly on Jul 22, 2013 - 2 answers

Professional education/seminars?

My employer has allocated $500/year as a benefit to me for training. I have not used it yet this year - suggestions? Areas I'd like to focus on - accounting, excel, QuickBooks, management training. I'm open to other things if they would be useful. [more inside]
posted by sockpuppetfairy on Jul 18, 2013 - 3 answers

Looking to extract more info from this database

We are storing information about application hits in a database. Sadly my database/excel skills are pretty limited and I'd like some help getting more info out of the information we have. [more inside]
posted by Admira on Jul 17, 2013 - 11 answers

Excel Chart Coloring Issues

I've got three pie charts in excel that show the same cut of information (location of sales) for three time periods: current month, current year YTD, last year YTD, with each chart fed by tables that rank locations by total sales for each time period. I want the color for any given location to be the same in each chart, regardless of its rank for each of the three time periods. How do I do that? [more inside]
posted by undercoverhuwaaah on Jul 17, 2013 - 1 answer

ExcelFilter: Why do my arrow keys select objects instead of nudge?

Excel 2010. Inside a chart. Arrow keys select other objects/elements inside the chart, instead of nudging. In an identical chart in the same worksheet, the arrow keys work fine (they nudge objects/elements). Scroll Lock is not enabled. The "select objects" option in the Find and Select menu does nothing. Google shows nothing. Help!
posted by ArgyleGargoyle on Jul 16, 2013 - 3 answers

First Python script, as a web app, using APIs & Excel. What do I need?

This is a bit of a convoluted problem, but I'll try to keep it brief. I work for a SaaS company that is totally awesome. I love what I do, but I want to develop on my skills at coding to help further my career and give me more interesting work opportunities at said company. In order to do so, I've been learning a bit of Python here and there, hoping to build on my HTML/CSS knowledge for web app development. I have a project in mind that involves writing a Python script that will combine data from Salesforce, a web form, and an Excel spreadsheet into one shiny CSV file/spreadsheet. Bonus points if it can use the Salesforce AND GoToTraining APIs simultaneously, since it'll be combining information from both sources. This will be a slow project, since I'm a bit of a newbie to Python. What libraries should I use, and what resources can help me get there? After I finish some Python courses, where should I go? [more inside]
posted by summerteeth on Jul 8, 2013 - 3 answers

Excel: Is it possible to sort by an arbitrary list?

I have a list of 625 English words, translations in a bunch of languages, and what-not in a giant excel file. We'll call that excel file "the Data." The Data is in alphabetical order. I also have a separate list of those same English words in a different order. Is there a way to sort the Data so that it's in the same order as my new, non-alphabetical list? [more inside]
posted by sdis on Jul 7, 2013 - 6 answers

Find standard deviation in Excel, but first develop a labor-saving trick

Help me with statistics and Excel. Especially help me if you know any labor saving methods. I want the median, mean and standard deviation for the average price of all items sold, but my spreadsheet-full-of-data doesn't tell me the price of each sale -- just the average price per store, and the number sold at that store. Something like this: [more inside]
posted by croutonsupafreak on Jun 21, 2013 - 10 answers

Download Excel on a PC running Vista

Need to get MS Excel on a PC running Windows Vista. Latest Excel versions seem to require Windows 7 or 8. Any help on where I can get a downloadable version of Excel for Vista?
posted by BozoBurgerBonanza on Jun 19, 2013 - 6 answers

What is the Comic Sans of Excel spreadsheets?

For my new position at work, I'll be putting together a large number of Executive Overviews. This is a new area for me and I'd like to avoid unknowingly committing a spreadsheet faux pas. [more inside]
posted by radiosilents on Jun 17, 2013 - 24 answers

Matching two spreadsheets via one matching column

I have two separate marketing lists on spreadsheets, both of which were originally opt-in, but have been residing on different systems - System A for email marketing and System B for SMS marketing. List A has the users' email addresses, cellphone numbers and names. List B just has the users' cellphone numbers (plus a column called "unsubscribed" for those people who. I want to combine the two spreadsheets to create one spreadsheet while keeping the column called "unsubscribed" so I know which people to keep permanently removed. Can you advise me on how to synchronise these two spreadsheets using the cellphone number as the common data? Thanks!
posted by skylar on Jun 3, 2013 - 4 answers

Data overload

I'm designing and managing a very ambitious data visualization app for the arts and culture sector, and am trying to find the best way to organize the data types and attributes. Excel just ain't doin' it anymore. [more inside]
posted by nosila on May 30, 2013 - 6 answers

Rounding dates based on time in Excel

I am looking for a way to take a date and time entry in Excel 2010 and round it up to the next day if the time is after a certain value. [more inside]
posted by oblique red on May 30, 2013 - 4 answers

Excel Tables for a Wordpress Blog

I would like to reproduce my Excel tables as html for a Wordpress blog, but the "save for web" code does not work. [more inside]
posted by fucker on May 27, 2013 - 14 answers

Is there a better type of spreadsheet?

I'd like to make a spreadsheet, which would include not just text but images and sets of tags, and maybe other interesting fields of information. Is there a better spreadsheet out there which is more flexible and more like a database? [more inside]
posted by htid on May 20, 2013 - 17 answers

Simple data analysis in Excel

How can I easily analyse test score data in a spreadsheet with multiple independent and dependent variables in each row? [more inside]
posted by mxc on May 15, 2013 - 8 answers

Adventures in giant-CSV land

Hi, I have a .csv that exceeds the maximum number of rows that Excel can handle, and before I can import it into a geodatabase in ArcGIS, I need to make one small edit – I need to delete the first row. Is there any way to do this and resave the file (preferably in a format other than .csv) in a way that retains the rows unable to be loaded in Excel?
posted by avocet on May 9, 2013 - 20 answers

There's got to be a way...

Excel functions: OFFSET? LOOKUP? ADDRESS? Unconfuse me, please. [more inside]
posted by jon1270 on Apr 23, 2013 - 7 answers

Need a simple database solution (I think)

I'm compiling an Excel spreadsheet full of personal data. What my employer would like to do is add that information to their existing website and make it searchable and filterable, so that researchers can filter out all guys who were born in year X or town Y, search for all guys named Cohen, etc. [more inside]
posted by Palindromedary on Apr 16, 2013 - 6 answers

[Excelfilter] How do I stop Excel from formatting my numbers?

I sat on the phone with Microsoft support and they weren't able to help me. I've scoured the internet trying to find a solution to this problem and I'm just about ready to give up. Can Metafilter rise to the challenge? How do I stop Microsoft Excel from formatting numbers into scientific notation? No matter what I do, Excel keeps doing this. Please make it stop. See the youtube video I made explaining my problem (45 seconds). [more inside]
posted by crios on Apr 16, 2013 - 37 answers

Help me reduce the size of my Excel file based on Sharepoint query.

I need some help with a situation where I have a bit of limited resources. Can you help me minimize the Excel file size while still keeping all data available for reporting use? [more inside]
posted by slavlin on Apr 15, 2013 - 0 answers

MS Word / Excel 2011 for Mac catalog merge mystery

I have a batch of mixed-format data including long-form text fields, hyperlinks, number and plain text in an Excel doc. I have assembled a Word catalog merge file intended to allow me to proof the data manually. There are 42 records. On merge, the output document results in what appears to be the correct number of pages and records. However, records 28-42 do not appear to place any data in the destination document. [more inside]
posted by mwhybark on Apr 15, 2013 - 1 answer

removing links in Excel without losing formulas

I have a pretty large spreadsheet in Excel which I use to combine information from everyone in my department for monthly statistics. They all fill out the same spreadsheet, then I have links from all those to mine, with formulas adding everything up. I want to remove the links to one file while leaving the rest, without losing the formulas that contains the links. [more inside]
posted by timepiece on Apr 1, 2013 - 1 answer

simple excel 2007 question

I need a solution to a pretty simple problem with counting instances of different text phrases in Excel. [more inside]
posted by clockzero on Mar 26, 2013 - 8 answers

No, this isn't about EVE Online.

I need help taming a very long list of numbers into useful tabulated data, in Excel. [more inside]
posted by 256 on Feb 28, 2013 - 10 answers

Using Excel conditional formatting to do a name/ID data check?

I'm hoping there's an easier way to do this than my current manual process: I want to highlight text cells in Excel 2010 that are a duplicate of ONLY the cell below. Specifics inside. [more inside]
posted by bibbit on Feb 25, 2013 - 4 answers

Need help with conditional lists in excel

I'm creating a workout training program in excel, and I want to show a range of data based on certain conditions. Using Excel 2010 More after the jump. [more inside]
posted by FireStyle on Feb 23, 2013 - 9 answers

Another remove duplicates from Excel Q: Find the dupe, remove the ROW

So, Excel 2011 has a handy function for removing duplicates. Neat! Except that when it removes the dupe, it shifts all the cells UP, thereby ruining the relationship between the columns in the row. What I need it to do is this: -Look for dupes -IF it find a dupe, delete the WHOLE ROW that dupe exists in -Profit. [more inside]
posted by GilloD on Feb 20, 2013 - 7 answers

Excel auto-fill form on web page

I have an excel file with a list of phone numbers and someone requested that links be added, so that when you click on one, our text paging web page is opened and the "To" field is auto-populated with the pager number. Is this possible? I have no control over this text paging web page, but the input field for the form does have a name. This is the page: http://www.myairmail.com/ Thanks!
posted by jjbb on Feb 18, 2013 - 4 answers

Excel spreadsheet to pretty clips report?

I have an Excel spreadsheet with couple hundred rows: URLs, a few fields of identifying information (outlet, etc.), for media hits on the organization I work for. I need to make this into a pretty (or at least semi-legible to the computer illiterate) document that I can give to board members, senior staff, etc. What I would like is to use some form of scripting to automate this. Bonus points if the script can somehow open the URL and take a screenshot of the story so that I don't have to. I have a Mac, and both the Adobe and Microsoft suites. How do I not spend tedious hours manually doing this? Especially since I have to do it each month and quarter.
posted by klangklangston on Jan 31, 2013 - 8 answers

Why won't Excel arrange its margins to what I want?

Excel 2007 will sometimes refuse to let me move its margins in print preview mode so that the document prints 1 page wide (despite letting me print that way previously on the document). How do I fix this? [more inside]
posted by lea724 on Jan 29, 2013 - 3 answers

Pinning Excel docs to the taskbar doesn't work with Office upgrade

So I upgraded from Microsoft Office Starter 2010 to Microsoft Office 2010. I uninstalled the Office Starter program. Then things went wrong. Please help! [more inside]
posted by merocet on Jan 26, 2013 - 3 answers

How do I figure out how to divvy out these projects?

I have roughly 20 people who each need a project. I have 27 projects and don't want anyone to share a project. I let the people pick their top five projects and rank them so I know who wants what. What is the best (easiest...) way for me to fairly figure out who should get what project so that the most people get their top choice, or at least one of their top choices? [more inside]
posted by pwb503 on Jan 22, 2013 - 8 answers

Correlating names between two spreadsheets

I need to correlate two spreadsheets which relate to the same group of people. The name data is messy, however, and I'm having a hard time matching the names. [more inside]
posted by mammary16 on Jan 18, 2013 - 8 answers

Spinning, exploding Excel-driven web app: How or should it be?

Sometimes, I am a front-end web developer. Frequently, I meet new people at work who want to turn really complicated Excel documents into dazzlingly interactive web applications. Besides Excel's "Save to Web App" or "Save to SharePoint" features, such people ask if I can tap into an industry to support this -- perhaps scads of agencies and web-based or downloadable tools that make "websites" or at least customizable, interactive reports from Excel spreadsheets, data, and calculations. I'm yet to find this an abundance of examples of this. Are there? If so, what do you call them? [more inside]
posted by metajc on Jan 9, 2013 - 2 answers

How can I get access to readyState 3 with VBA "AJAX"?

I'm writing some VBA code (in Excel) which uses a reference to Microsoft XML, v6.0, and creates a MSXML2.XMLHTTP object. I used the clsXMLHttpMonitor example from this page as a starting-off point. How can I access the response text when readyState = 3? [more inside]
posted by jozxyqk on Jan 8, 2013 - 10 answers

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]
posted by mnemonic on Dec 17, 2012 - 4 answers

Help me EXCEL at my new job. (Yes, I went for the obvious one.)

What books or websites should I look at if I want to master Excel? [more inside]
posted by synecdoche on Dec 16, 2012 - 9 answers

Comma delimited list to multiple lookup values in Access 2010

Is there an easy way of turning a comma-separated list into multiple lookup values in access 2010? [more inside]
posted by monkey closet on Dec 14, 2012 - 1 answer

How do I do this in Excel?

I am new to working with dynamic arrays in Excel. Also, I would like recommendations on books/resources for advanced Excel users. Help! [more inside]
posted by prunes on Dec 13, 2012 - 4 answers

How to jump to another Excel worksheet?

[Excel 2007 filter] Is it possible to input some text into a cell, e.g. "Click here for Worksheet 2" or similar, and create a hyperlink on that cell to open, uh, Worksheet 2? In the same window, not a new instance. Neither a search of AskMe and/or the Excel help-screens has been successful. Thanks in advance.
posted by aqsakal on Dec 12, 2012 - 7 answers

Why can't MS just add a watermark function?

How can I add a watermark to multiple tabs of an Excel spreadsheet, that can be easily updated each time a copy is printed? [more inside]
posted by PercyByssheShelley on Dec 11, 2012 - 3 answers

How can I propagate changes to formulas in Excel automatically?

How can I propagate changes to formulas in Excel automatically? [more inside]
posted by madcaptenor on Nov 29, 2012 - 8 answers

How to get millions from M in Excel?

Can Excel do input filtering or parsing of unit abbreviations? I want to be able to type "400M" and have the result be a number cell of 400000000, not the string "400M"
posted by fightorflight on Nov 29, 2012 - 10 answers

Converting lots of little excel into word?

ExcelFilter: I have a whole bunch of excel files. More than 100 of them. Each file has about one page of print area, but some in portrait and others in landscape. They are mostly text in cells; not a lot of formulas being used. I would like to (1) merge all these files into one Word document; (2) have a page break so that each file (more or less) is one page; and (3) do it with a minimum of cutting and pasting. Opening everything as a PDF and viewing in Preview is also an option, but less optimal since I'll certainly need to adjust some formatting and page breaks. Maybe on publisher? Is anything like this possible? Or do I need to do it page-by-page? What would you do? I'm on a Mac 10.8.2.
posted by RandlePatrickMcMurphy on Nov 19, 2012 - 9 answers

Page: 1 2 3 4 5 6 7 8 ... 18