952 posts tagged with Excel.
Displaying 1 through 50 of 952. Subscribe:

FilemakerPro to .CSV to NeonCRM - How to Excel?

Excel experts and fundraising professionals, ho! I work for a small non-profit and we're currently transitioning from a janky FilemakerPro database to NeonCRM. I have all the data spread across three spreadsheets and my brain is collapsing trying to figure out the best way to deal with it. What's the best/most efficient way to compare data between three separate spreadsheets, and manipulate it into the format I need for this import? All the necessary/boring details lie within! [more inside]
posted by adastra on Aug 19, 2016 - 11 answers

App for that, or Excel magic? Grocery inventory w/ recipe matching

I'm looking for an app/program/spreadsheet/whatever that stores a grocery inventory with quantities, and a list of recipes (or just named sets of ingredient quantities). It would rank the recipes by % of ingredients on hand. If any part of this makes you think, "you could do that bit in [program] with/by [method]", I appreciate any pointers! Because I'll make it if I can't find it, but I'm not sure where to start. [more inside]
posted by Baethan on Aug 18, 2016 - 5 answers

How to sorting column with 10,000 rows?

I have a spreadsheet column with 10,000 rows, and I need to sort it. Is there a way to do this automatically, where certain rows with specific attributes are sent to a new column? [more inside]
posted by My Dad on Aug 13, 2016 - 11 answers

Building An Auto-Populating Task Calendar In Excel

I'm looking to create some way that I can track jobs I have coming up, as well as have them populate into available time slots in my scheduled based on anticipated completion time. Can this be done in an Excel sheet, or is there some sort of program that exists that is better suited for my needs? [more inside]
posted by Malleable on Aug 8, 2016 - 3 answers

Excel-Powerpoint Linking-Embedding Charts-Tables

I am trying to create charts in Excel and then copy them into Powerpoint. If I initially paste the charts with linked data, can I subsequently embed that data for sharing with others? Are there other convenient ways of sharing a Powerpoint file together with a linked Excel file? More tiny/related questions and details within. [more inside]
posted by taltalim on Aug 8, 2016 - 6 answers

I have excel and a sense that this is possible

So imagine I have a population of like 100,000 people. And I have goals for them to achieve for which they get money. Now I want to calculate what my budget might be. [more inside]
posted by jander03 on Aug 7, 2016 - 4 answers

Excel reverse conditional formatting

I'd like something like conditional formatting, but that works the other way - a cell's value changes depending upon the colour the cell is filled with. [more inside]
posted by quinndexter on Jul 19, 2016 - 2 answers

How to present and evaluate data relative to weight

I could use some help walking through this: I have Excel data that means more or less depending on where it comes from. When I'm working with it, presenting it, or thinking about it, I want to treat it differently depending on origin. Example within. [more inside]
posted by A Terrible Llama on Jul 19, 2016 - 11 answers

Help with Excel formula to compare 1 column of numbers to other columns.

I have an excel sheet with 4 columns of numbers. The first column is a recent donation amount. The other three columns were the prompts of donation amounts, (the Reach, the Target, and the Anchor). Is there an excel formula that can compare these four columns? [more inside]
posted by andoatnp on Jul 19, 2016 - 8 answers

Excel Formula to Weight Ratings By Number of Ratings?

How do I write an Excel formula to weight a rating by the number of ratings, so that a 4 with tens of thousands of ratings weighs more than a 5 with three ratings? [more inside]
posted by WCityMike on Jul 5, 2016 - 12 answers

Engine in Excel

Now this may be a ridiculous long shot but does anybody remember seeing an Excel workbook circa 1993 which featured an elaborate color drawing of an internal combustion engine? It had shading, many colors, and took a couple of minutes to "render" on the Mac we had at the time. I think it came from a magazine cover disk but I could be wrong. If anyone has this I'd love a copy.
posted by hoverboards don't work on water on Jun 30, 2016 - 0 answers

Manager question: excel formatting

I have a question on how to set standards for an ambiguous process. Part of my job involves having my directs "body-shop" powerpoint/excel charts - i.e. organizing things on the page, making tables look nice, filling in / fleshing out commentary, etc. (I'm in consulting). How can I help them do this better? [more inside]
posted by The Ted on Jun 25, 2016 - 8 answers

How do I make a VBA macro run "silently" in the background?

I have a macro in an excel sheet that successfully displays or hides tabs in the workbook based on the value in a particular cell. I'm pleased with this! There's a problem, though... [more inside]
posted by jefficator on Jun 9, 2016 - 1 answer

Why is Numbers (the spreadsheet app) for ios doing this?

I use a Numbers spreadsheet on my iPhone 5S to keep track of my mileage for work. Sometimes -- but not always -- when I do a calculation, it gives me an almost-accurate but borked up number. [more inside]
posted by kitty teeth on Jun 1, 2016 - 7 answers

Excel VBA filter: Copy/paste using offset

Based on the active cell's position, I need to copy cells in the next column over and paste them a few columns to the left. Help? [more inside]
posted by bologna on wry on May 17, 2016 - 5 answers

excel 2016 training help

When I got Excel 2010, I got a workbook that came with a disk of practice worksheets. It was dummy data, as it were. Now that I have updated to Excel 2016 I can't find anything similar. Every search brings me back to some kind of online video training. All of that is good as far as it goes but I won't retain much unless I can actually implement the lesson, not just watch it. Where can I find either a disk or downloadable dummy worksheets with which to practice? Thanks.
posted by jtexman1 on May 9, 2016 - 3 answers

How to find out where an Excel macro is triggered from

How can I find out if 2 macros in an inherited Excel spreadsheet are actually needed, or if they are 'orphan'? [more inside]
posted by cantthinkofagoodname on May 9, 2016 - 6 answers

Summarizing daily reports in Excel

I get a daily report of activity from a set of items and I want to make a automatically-updating summary sheet (I'm fine doing this in Excel, Google Sheets, or Apple Numbers). [more inside]
posted by primethyme on Apr 30, 2016 - 4 answers

Excel Question

Is it possible in excel to create a formula that says "if a value in this column is in this range of numbers, put label x in a different column." [more inside]
posted by Lutoslawski on Apr 28, 2016 - 4 answers

How can I model the response of a car to a sharp steering input?

I'm doing some work for an engineering company that certifies modifications to cars. One of the tests that they perform is a lane change manoeuvre test. This test simulates an emergency lane change and back to the original lane to prove the stability of the vehicle. Given testing is relatively expensive (as it involves hiring a suitable facility), and involves some risk to the test driver, they have asked me to come up with a spreadsheet or similar that they can use to have a high level of confidence that the test will be safe before they leave the workshop. i don't know how to do that. [more inside]
posted by trialex on Apr 27, 2016 - 9 answers

MS Office Reporting Service

Before writing this from scratch I'd like to know if something already exists. The need is for a server that accepts data, document type and an optional template id, and returns an MS Office doc (powerpoint or excel) containing the data, in the selected template. [more inside]
posted by grubby on Apr 13, 2016 - 1 answer

Excel Wizards, Help Me Make My Dream Calendar

Hi! I an Excel novice surrounded by fellow novices and I need help with what looks like an unexpectedly difficult setup. I make a comprehensive calendar of activities and events for a retirement home every month. This takes most of a month to plan and transcribe, and is tedious and error-prone. I want to make something better. Assume I am smart but have little programming knowledge or power user experience. [more inside]
posted by skookumsaurus rex on Apr 4, 2016 - 7 answers

How should we manage all of these RSVPs for events at our non-profit?

Hello Mefites! I'm seeking some help finding a better method for a very inefficient RSVP process here at the nonprofit where I work. Please help me come up with a better solution! [more inside]
posted by smirkyfodder on Apr 4, 2016 - 9 answers

How might I randomise some spreadsheet rows once I populate it?

I'm developing a training resource for a client and the brief requires me to provide some spreadsheets that summarise employment data for a small fictitious company. The spreadsheets must have one row per employee. I want to populate the rows as if the spreadsheet has already been sorted, for example by grouping employees by age, and then randomise the rows so students are given spreadsheets where there is no row by row pattern to the data, for example as if employees had been entered in alphabetical order. [more inside]
posted by dowcrag on Apr 1, 2016 - 2 answers

Fastest/Best Way to Get Up to Speed with Excel

TL;DR: Computer comfortable/literate, but only an excel lightweight. How do I become a guru (or at least enough to fake it till I make) and start changing my life? [more inside]
posted by VillainProtagonist on Mar 24, 2016 - 10 answers

Excel Question, make chart where each bar is the average of each column

This seems simple to me but can not find the answer on-line. If I have several columns of data, each column is just one variable with several entries. How can I make a chart from this data where each chart column is the average value of each data column. Then add Std. Dev bars to this?
posted by 1inabillionmistake on Mar 10, 2016 - 3 answers

Excel arithmetic glitch explanation

This isn't getting in the way of anything practical, but it's niggling that I don't understand the technicalities. [more inside]
posted by protorp on Feb 29, 2016 - 7 answers

Help me develop complicated spreadsheet

Note: NOT Homework. Real world application here. I have to come up with a spreadsheet based on a formula that allocates dollars to people based upon role and participation. I'm good at Excel but this one is boggling my mind. Details and example inside [more inside]
posted by arniec on Feb 23, 2016 - 11 answers

Excel to HTML Converter

I have a work order built in excel that I want my database to auto-populate some fields instead of my QEs doing it manually. I've found an add on to do this, but if I want to make the new form look at all like the old form I have to do it in HTML. Is there a good converter for this? [more inside]
posted by Caravantea on Feb 21, 2016 - 1 answer

Help me streamline a data gathering workflow?

What started as a screen scraping project has evolved (devolved?) into working with lots of word files with embedded tables. I found and customized an excel macro to extract them on a file by file basis. I'll describe what I'm doing with it inside. Can you give me some pointers on further automating what I'm doing -- or point me to a forum that can? [more inside]
posted by GPF on Feb 15, 2016 - 3 answers

Good Excel/CSV data visualisation tools for Windows desktops?

How can I make Excel datasets look nice without too much mucking about? [more inside]
posted by turbid dahlia on Feb 15, 2016 - 6 answers

I like to solve problems. How do I get paid to do that?

I've flip flopped on what I want to go to school for and/or what kind of career track I want to aim for. Can you help? [more inside]
posted by motioncityshakespeare on Feb 7, 2016 - 13 answers

Writing MS Word macro to convert glossary formatting to Excel table

I need some guidance in writing a macro that will parse a glossary Word document and reformat it into an Excel spreadsheet with the term in one column and the definition in a second column. [more inside]
posted by beammeup4 on Jan 25, 2016 - 5 answers

Excel filter: How do I add only data for a given month?

I have an Excel worksheet that logs hikes. The columns are date, location, miles, notes. The rows are hikes. I have a summary worksheet in the same workbook that I use to track progression. Things like cumulative miles for the year, average miles per month. I'd like to add month by month totals. I want to write a formula that will sum the distance only for a particular month (for example, January). I need a formula that will test if the hike occurred in that month, then add the miles to the sum. What would this formula look like? [more inside]
posted by OrangeDisk on Jan 21, 2016 - 5 answers

Volunteered to add up the votes for my Book Club; No idea how to do it

This year my Book Club decided to vote on the books we'll read all at once instead of month-by-month. There are 17 books choose from in total and I gave each person a sheet with the books in alpha order. I then asked them to order the books by preference – i.e., their first choice is #1, their second #2 etc. [more inside]
posted by Lescha on Jan 18, 2016 - 6 answers

Need help wrangling spreadsheets

Spreadsheets are making me crazy. [more inside]
posted by triggerfinger on Jan 12, 2016 - 11 answers

New Year, new spreadsheet for tracking joint and personal expenses

My partner and I have decided to track more accurately our expenses and this task is on me. We are looking for an Excel spreadsheet template that will allow us to track all our expenses by category (groceries, eating out, etc), making a distinction between personal and joint expenses. On top of that, we would like to be able to see clearly who spent how much on what. [more inside]
posted by lost_lettuce on Jan 12, 2016 - 12 answers

UK business plan financials excel sheet?

I am looking for a straightforward British economic business plan financials calculator for Excel so that I can look serious! I found a similar thing from startupmodels.com but it is really for the USA. Any signposting to something comprehensive with built in calculations?
posted by parmanparman on Dec 20, 2015 - 3 answers

Excel 2013 - I have no explanation for this chart behavior. Do you?

Excel 2013 - I have no explanation for this chart behavior. Do you? [more inside]
posted by radiosilents on Dec 15, 2015 - 6 answers

Non-cloud Google docs

What's a good non-cloud collaborative software alternative to Google docs? [more inside]
posted by Ndwright on Nov 19, 2015 - 7 answers

Excel autopopulating columns from a list

What is the formula to have Excel pull information from a list based on a specific identifier? [more inside]
posted by OnTheLastCastle on Nov 11, 2015 - 7 answers

Need some Excel-Fu!

I have an excel doc with products down the left and people's names across the top. The people have each marked in their column the quantity of each product they would like. How do I make sure everyone gets what they want? [more inside]
posted by magnetsphere on Nov 5, 2015 - 7 answers

Serial dates are the @#$%@ devil

I need Excel to stop reverting my written date into a serial date. It is not cooperating. [more inside]
posted by Serene Empress Dork on Oct 16, 2015 - 8 answers

How do I make a directory from excel or .csv files?

I need to make a directory of members from a .csv file---what is the easiest method? [more inside]
posted by ragtimepiano on Oct 10, 2015 - 4 answers

Mileage in Excel (or in something else)

There has to be a way that I can track my mileage in Excel. [more inside]
posted by aetg on Oct 6, 2015 - 5 answers

Help me escape Excel hell

I need to build a database that's viewable on the web, but for internal use only, among friends. How to do this painlessly? Google spreadsheet is not exactly making it any easier. [more inside]
posted by pleasebekind on Sep 10, 2015 - 9 answers

Recommend a second VBA book?

I'm looking for a book recommendation for someone who's already pretty familiar with vba and wants to go beyond the basics. [more inside]
posted by Proginoskes on Sep 1, 2015 - 6 answers

Spreadsheet - Naming calendar quarters with custom date

I'm struggling to do something in a spreadsheet (I'm using Google Spreadsheets, but could use Mac Excel or Numbers if needed). I want to automatically fill one cell with the name of the calendar quarter (e.g. "Q3-2015") based on a user-entered date in another cell. To make it more complicated, the "quarters" don't begin/end on standard dates. [more inside]
posted by primethyme on Aug 29, 2015 - 4 answers

Best resources to help improve/maintain old code

What are some resources (books preferred, but other resources are good, too) that I can use to help me improve/maintain some old vba models in my workplace. [more inside]
posted by Proginoskes on Aug 24, 2015 - 4 answers

Generating a graph from excel

I have an excel file with two columns that I'd like to somehow (in the easiest way possible) turn into a graph (in the graph theory sense - with nodes and edges). [more inside]
posted by Proginoskes on Aug 14, 2015 - 4 answers

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