##
958 posts tagged with Excel.

Displaying 1 through 50 of 958. Subscribe:

## Need spreadsheet with pivot tables, but can't really use Excel or Sheets

We have a very large Excel spreadsheet with a lot of raw sales data. I'm then creating pivot tables to look at the info in various ways to help our sales team. However, we're bumping into some severe limitations with regards security, sharing, and user-friendliness of the UI and trying to figure out if there are alternatives. [more inside]

## Vlookup Personal Projects

I am looking for an every day project to up my Excel Vlookup game. Any ideas would be useful. [more inside]

## Best practices for Excel workbooks?

What are your best practices for error checking when creating and maintaining Excel workbooks? [more inside]

## ISBN to HTML in Excel

Last year I found instructions for turning a list of ISBNs into hyperlinks to our library computer using Excel. I am at a new library and have lost the file. I'll give more details below. [more inside]

## Excel Question: how do I paste some hyperlinks?

This seems like a simple question, but I can't figure out the answer. How do I paste a bunch of hyperlinks? [more inside]

## Calling all Excel PivotTable Gurus

How do I construct this PivotTable to show what I need? [more inside]

## 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]

## 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]

## 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]

## 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]

## 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]

## 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]

## 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]

## 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]

## 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]

## 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]

## 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.

## 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]

## 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]

## 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]

## 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]

## 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.

## 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]

## 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]

## 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]

## 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]

## 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]

## 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]

## 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]

## 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]

## 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]

## 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?

## 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]

## 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]

## 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]

## 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]

## Good Excel/CSV data visualisation tools for Windows desktops?

How can I make Excel datasets look nice without too much mucking about? [more inside]

## 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]

## 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]

## 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]

## 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]

## Need help wrangling spreadsheets

Spreadsheets are making me crazy. [more inside]

## 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]

## 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?

## 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]

## Non-cloud Google docs

What's a good non-cloud collaborative software alternative to Google docs? [more inside]

## 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]

## 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]

## Serial dates are the @#$%@ devil

I need Excel to stop reverting my written date into a serial date. It is not cooperating. [more inside]

## 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]