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

847 posts tagged with excel. (View popular tags)
Displaying 1 through 50 of 847. Subscribe:

Related tags:
+ (193)
+ (88)
+ (68)
+ (51)
+ (48)
+ (45)
+ (45)
+ (35)
+ (30)
+ (30)
+ (25)
+ (24)
+ (22)
+ (22)
+ (21)
+ (20)
+ (20)
+ (18)
+ (17)
+ (16)
+ (15)
+ (15)
+ (15)
+ (14)
+ (14)
+ (14)
+ (14)
+ (14)
+ (14)
+ (13)
+ (13)
+ (13)
+ (13)
+ (12)
+ (12)
+ (12)
+ (12)
+ (12)
+ (11)
+ (10)
+ (10)
+ (10)
+ (10)
+ (10)
+ (9)
+ (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)
Anonymous (4)
willnot (4)
FireStyle (4)
desjardins (4)
zardoz (4)
SirStan (3)
Jackie_Treehorn (3)
jujube (3)
goethean (3)
skypieces (3)
jefficator (3)
bluejayway (3)
mwhybark (3)
anastasiav (3)
Conrad Cornelius o... (3)
undercoverhuwaaah (3)
stupidsexyFlanders (3)
sdis (3)
foxinthesnow (3)
Mr. Justice (3)
ttyn (3)
corpse (3)
GilloD (3)
keep it tight (3)
apark (3)
Carialle (2)
bluefly (2)
demagogue (2)
bibbit (2)
Irontom (2)
Seeba (2)
Rad_Boy (2)
skryche (2)
thankyoumuchly (2)
synecdoche (2)
Lentrohamsanin (2)
digiFramph (2)
Jimbob (2)
rippersid (2)
furtive (2)
monocultured (2)
jestonb (2)
lea724 (2)
beammeup4 (2)
xedrik (2)
sockpim (2)
pwb503 (2)
nickerbocker (2)
ObscureReferenceMan (2)
crapmatic (2)
pantufla (2)
rorycberger (2)
prunes (2)
ParisParamus (2)
WCityMike (2)
dmd (2)
ewiar (2)
squorch (2)

Inserting symbols before and after some other text in Excel (macros?)

Is it possible to do this in Excel or Word or some other program?: I want to paste a sentence into the a text field, highlight a word or several words in that sentence, hit a keyboard shortcut, and have certain symbols inserted before and after that word or phrase. For example, in the sentence "Metafilter is the best website in the whole wide world," I might highlight "website," press the shortcut, and have it transform into the following: "Metafilter is the best {{c1::website}} in the whole wide world." I'm using OSX and Microsoft Office 2011, but I'm comfortable doing this in a webapp or Google Drive or whatever you suggest! I also have the aText text expansion software, but I can't figure out how to make it insert text at both ends of a highlighted phrase. [more inside]
posted by lizzicide on Jul 25, 2014 - 7 answers

File woes

I grabbed a bunch of posts off of a vBulletin forum to analyze for a research project (with permission, of course, from the forums and the users and my IRB), and I've got it all cleaned up and ready to go. I've got thousands of files in .xls (Microsoft Excel 97-2003) format. So far, so good. Now how do I get these files into a format that my analysis software will play with nicely? [more inside]
posted by sockermom on Jul 18, 2014 - 14 answers

How to create an Excel histogram showing distribution of timestamps

I have a spreadsheet containing timestamps, that I want to display as a histogram [more inside]
posted by jedro on Jul 17, 2014 - 1 answer

Labeling data points in an Excel chart

Help me figure out how to get the labels I need on the data points in a fairly simple Y vs. X chart. [more inside]
posted by ocherdraco on Jul 8, 2014 - 15 answers

How to get Excel to play nice?

I am trying to generate an excel graph that will give me a date/time overview, and I can't quite crack how to set up my table and chart :( Any help will be greatly appreciated. [more inside]
posted by alchemist on Jul 4, 2014 - 6 answers

Turning a giant spreadsheet of order info into "Here's your order info!"

I have a giant excel spreadsheet with ~2200 customers worth of order details for a Kickstarter. The details are complex; I have around 60 products I'm delivering, and I'd like to send everyone an email with their individual orders before I start shipping them out. How do I do this? I'm planning on outsourcing this job, but I'd like to know a bit more about who I'm trying to hire (An excel expert? A mailing list person? Some other platform I don't know about?)
posted by sdis on Jun 26, 2014 - 8 answers

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]
posted by scottso17 on Jun 25, 2014 - 52 answers

Help me use Excel to save my job

So, I just got promoted to a new position at my company (Yay!). Unfortunately, the new requirements involve scheduling a ridiculous number of people. It turns out my predecessor has just been doing dozens of iterations manually until one kind of worked, but every slight change puts a bunch of other things out of wack. I feel like Excel could probably be capable of doing it, but I have no idea how I would go about designing such a spread sheet. [more inside]
posted by cacofonie on Jun 19, 2014 - 17 answers

Merging Duplicate rows in Excel or Access

I have a table with duplicate values in one column. Some of the other columns have a value, some don't. I want to have one row for each record, with all of the colums values in one row (NOT CONCATENATED). I can use Excel or Access for this. [more inside]
posted by desjardins on Jun 19, 2014 - 18 answers

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]
posted by selfnoise on Jun 5, 2014 - 2 answers

excel numbering questin

In excel, I want to increase a number in sequential rows by one every three numbers. Is there a way to do this quickly, for about 5000 rows? [more inside]
posted by SpacemanStix on May 22, 2014 - 7 answers

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]
posted by stupidsexyFlanders on May 22, 2014 - 3 answers

Looking for an advanced Excel/Access crash course

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?
posted by firechicago on May 19, 2014 - 2 answers

Making Excel do stuff for me, automagically!

Where can I find snippets of vba macros that I can use/reuse? What are your favorite macros that you use and can't do without? [more inside]
posted by rippersid on May 18, 2014 - 3 answers

Random Numbers In Excel, Without Duplicates, Based On Weighted Value

I need a way to generate a random set of numbers in excel, with some numbers having a more likely chance to be selected based on a weighted value associated with that number. But without the number being duplicated. [more inside]
posted by ndillon on May 8, 2014 - 10 answers

Unusual Excel-to-Word merge. Is this possible?

Have Excel spreadsheet with a list of contacts with the name of the organization they belong to. Need a series of Word documents for each organization that includes the names and info of each contact. Read on for more detail. [more inside]
posted by that's candlepin on May 6, 2014 - 4 answers

How much to ask for informal consulting?

A coworker of mine asked me to help his friend out with some excel problems she is having. I am good with excel, so I agreed. We've talked and are all set to go, but I have no idea how much to ask for. [more inside]
posted by Hactar on May 1, 2014 - 6 answers

Need help with getting things to sort correctly in Excel

I have a spreadsheet with items that I am trying to organize by part numbers made up of both letters and numbers. When I sort them, though, "HMDL32000" comes ahead of "HMDL3700", even though 32000 is a bigger number. In the warehouse, HMDL32000 is behind HMDL3700 and it seems unintuitive to have it appear first on the spreadsheet. How can I get Excel to organize first by the alphabetical portion of the part number, and then in the correct numeric order?
posted by BuddhaInABucket on Apr 29, 2014 - 3 answers

Please help me gain Microsoft Office skills!

I will soon be starting a project/new job that requires better Microsoft Office skills than I currently have. I've used Outlook, Word and Excel in a fairly basic way for years, but need to come to grips with some of the more sophisticated elements of those programs. Plus, I need to learn how to use Powerpoint and Visio, which I've never touched. Yikes. Can you recommend some good online tutorials? I am also considering doing a paid course (online or otherwise) if I can find one based in London that's not too expensive or a rip-off. Can you help?
posted by handclaps on Apr 25, 2014 - 8 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

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?
posted by AngryTypingGuy on Apr 18, 2014 - 12 answers

Excel question: VLOOKUP what's already been VLOOKUPed?

Is there a way to look up items in Excel that are not included in a total that has been calculated using multiple vlookups? [more inside]
posted by natteringnabob on Apr 14, 2014 - 7 answers

How can I add straight "limit" lines to simple Excel X/Y graphs?

I'm using Excel 2010 and I'm making several x/y scatter graphs to plot QA results. I want to show on the graphs an upper and lower allowed limit for the data. [more inside]
posted by Rad_Boy on Apr 14, 2014 - 6 answers

Make me an Excel rockstar!

What are some of the most useful Excel add-ins that you use on a daily basis? [more inside]
posted by rippersid on Apr 11, 2014 - 9 answers

Getting crazy duplicate charts in Excel spreadsheets using Save to Web

So, I have a series of worksheets in an Excel file that I routinely save to web (single web page format) so that colleagues can access the information on an intranet. Since our company upgraded to Office 2010 these worksheets have begun accumulating multiple copies of any charts located on these sheets (superimposed on the original) - these duplications are in both chart and image form. [more inside]
posted by aught on Apr 3, 2014 - 1 answer

Creating simple bar graph in Excel 2007

Hey guys, what I'm trying to do is very simple I just never really use Excel. I have two unrelated fields, categories, or columns, that I'd like to depict in a bar graph showing the amount of records that have been completed out of the total. The data are values, in my case "Yes", not numbers. I used the countif() formula to count every cell that has "yes". But I'm not really sure what I have to do next. Do I need to create another row showing what percentage this number is from the total amount of records, 136/633? And then create a bar graph from just that cell? When I just highlight all the cells for both columns and click bar graph it doesn't even fully show me a graph so I'm obviously not doing it right. Ideally, I'd like the y-axis to just show 0-100% and the total number of records(633) with marks maybe at 25% intervals. The x-axis to have my two column names and then the bars showing the percentage of records that have "yes" for these columns out of the total with a count included also. If anyone could help me out that would be great. Thanks a ton in advance.
posted by mr.coffee on Mar 28, 2014 - 6 answers

How to add multiple images at a time in Excel

I unpacked a bunch of boxes, took photos of what was inside, and then packed them back up. I would like to create a simple inventory of the boxes with columns for box #, a photo of the contents, and a description of the contents. Here is sort of an idea of what I am trying to accomplish. [more inside]
posted by thebrokenmuse on Mar 25, 2014 - 1 answer

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]
posted by philipy on Mar 21, 2014 - 8 answers

Excel formula that hides results

I am drowning in Google results! Looking for help making a formula that will only show a value once data is entered into another cell. [more inside]
posted by ellieBOA on Mar 6, 2014 - 10 answers

Excel sum question with if and operators

Spread sheet contains 4 columns. Submitals, interviews, jobs and a total sum column of the prior three cells mentioned. The trick is, a submital is worth 1 point, a intrerview 3 points, a job 5 points. But the value must be 1 each in its respective column, and the sum column must contain the total number of points. How would you format a sheet to achieve this.
posted by cheechman85 on Feb 26, 2014 - 2 answers

Conditional Excel formula to identify right-most column with a value?

I'm grappling with an Excel formula. Given a bunch of columns, I'd like to to (a) identify the right-most column that contains a value, then (b) fill a cell with that value and the value in the column heading. [more inside]
posted by obiwanwasabi on Feb 25, 2014 - 10 answers

iPad iDiot

Help me turn my iPad into a work productivity tool. [more inside]
posted by sardonyx on Feb 17, 2014 - 10 answers

Excel, Creating text with a colored rectangle

Could anyone provide me guidance with a subroutine that would paste text within a colored rectangle within an Excel document? Thanks, Ken
posted by estudioken on Feb 2, 2014 - 2 answers

Using Excel's regression tools to determine the 95% confidence interval

MS Excel's regression tools provide 95% lower/upper confidence results but how does one properly interpret and then express those as a single ± (plus/minus) figure? [more inside]
posted by kartguy on Jan 26, 2014 - 4 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

ISO: 21st Century - information wants out of 3 ring binders

We have a number of (internal) groups providing information about (external) clients. Help me figure out the best way to track this information for easy report generation. [more inside]
posted by TravellingCari on Jan 10, 2014 - 5 answers

I want to Excel

I need some Excel assistance. [more inside]
posted by pullayup on Dec 16, 2013 - 8 answers

Why is SUMIF function not working when data is formatted as a table?

I am developing a sales lead sheet. I have on the B column a drop down list for the sales status (complete, no sale, and follow up). On the A column I have a dollar amount for the sales lead. Originally, I used the SUMIF function to add only the "follow up" figures referenced from Column B to track the dollar amount of outstanding leads. I then thought to convert my sheet into a table to make sorting easier, but now the SUMIF function is returning a value of zero. What did I miss? Thanks much!
posted by FireStyle on Dec 7, 2013 - 2 answers

Convert rich text field in Access or Excel into plain text

I have thousands of rich text message message fields currently formatted in RTF (rich text format) that need to be stripped of their formatting and converted to plain text. Currently the field is in a Microsoft Access database. But if needed, the database could be sent to Excel if that would ease the conversion of the RTF to plain text. [more inside]
posted by Jackie_Treehorn on Nov 12, 2013 - 16 answers

How can I turn my Google inbox into an excel document and process it?

Over the last year, I've had a contact form on my website with a checkbox for "Notify me when your book is done." My book is done and I'd like to email them. Around 1200 people used my contact form, and ~800 people clicked that checkbox; how do I get all of their email addresses into an excel spreadsheet? [more inside]
posted by sdis on Nov 11, 2013 - 15 answers

Extra-applicational extraction of Excel form

I have an MS Excel spreadsheet which uses drop-down menus which affect the content in multiple fields. It's used for buying inventory, so you'd change the "category" menu to "paperware," upon which the fields "account number" "responsible admin" etc. would all populate depending on what I've chosen in "paperware." Now we're redoing the form and I'm tasked with mapping all available functions and how they are related [more inside]
posted by monocultured on Oct 29, 2013 - 5 answers

How can I get Excel to create multiple averages from a single table?

I have a table of data that I need to average, but I need to come up with averages using multiple different rows. For example average A=row 1, row 2, row 4: Average B= row 1, row 2, row 3: Average C= row 2, row 3. I would like to add a column that has the names of each average I need, (A, B, C) and then let excel average them based on which set they belong to. I have been looking around at other excel related forums, but I am not sure what this process is called, so I don't know how to find it. Right now I have been copying rows for each time they show up in a set I need averaged. It would be nicer to have column that says, this row belongs to set A and C, next one belongs to set A, B, and C.
posted by djpuddings on Oct 24, 2013 - 11 answers

Changing manual timetabling to electronic

I receive timetabling data in Excel spreadsheets and want to map it out automatically, rather than working out the timetable/grid by hand every time because the data changes, and I'd also like to filter it to show certain groups - teacher for example. [more inside]
posted by b33j on Oct 14, 2013 - 5 answers

Excel imported my dates as day-month instead of year-month. How to fix?

How do I fix this? I "imported" a table from a PDF (big mistake). In the pdf, the dates were formatted as AA-BB, where AA was the month and BB was the year. Excel interpreted that as AA is the month and BB is the day, and gave them all 2013 as the year. So now the date reads as 11-Jan instead of Jan 2011. I no longer have access to the original dataset because I only just noticed the mistake. I am using Excel 2010 on Windows.
posted by rebent on Aug 26, 2013 - 6 answers

Excel 2007 Scroll-bar going to end of sheet

I have an excel 2007 spreadsheet in which the vertical scrollbar covers the whole 1,000,000 rows i.e pressing ctrl - end takes me to row 1,048,576. I would like it to only scroll to the end of my data. [more inside]
posted by mataboy on Aug 25, 2013 - 9 answers

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

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