Skip
##
877 posts tagged with excel.

Posts

##
877 posts tagged with excel.

Displaying 51 through 100 of 877. Subscribe:

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

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

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

## Make me an Excel rockstar!

What are some of the most useful Excel add-ins that you use on a daily basis? [more inside]

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

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

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

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

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

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

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

## iPad iDiot

Help me turn my iPad into a work productivity tool. [more inside]

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

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

## What is proficiency in Excel and Word?

What do you need to know to be "proficient" in Excel and Word? [more inside]

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

## I want to Excel

I need some Excel assistance. [more inside]

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

## There's got to be a way...

Excel functions: OFFSET? LOOKUP? ADDRESS? Unconfuse me, please. [more inside]

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

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