Skip
##
882 posts tagged with excel.

Posts

##
882 posts tagged with excel.

Displaying 151 through 200 of 882. Subscribe:

## How do I save to a text file in Excel 2011?

I'm on a mac. A colleague sent me an Excel file (.xls) which I looked at in Excel 2011. It looks fine. I would like to save the file in some sort of text format, so that I can open Terminal and look at it in less. I realize that the columns won't align nicely, that's fine. What I don't want are all the weird characters that show up (from differently formatted line endings, etc). I've tried saving as "Tab delimited text," but that has the problem with the line endings. Which format should I use?

## Validating data for data validation.

[ExcelFilter] Can I use one data validation list drop-down menu to specify which values will show up in a separate data validation list drop-down menu? [more inside]

## Help this Mac user learn PC software for job hunt

How can I improve my computer skills for job hunt when I use a Mac and the software is for PC? [more inside]

## Work Pivot Table Magic...

Excel Pivot Table Help - My google-fu and excel-fu have failed me, I'm working on a tracking pivot table that will display total number of attendants in a class (broke out in gender) for each day based on a start and end date. [more inside]

## There's a reason it rhymes with "hell"

Another "please help me find an alternative or a way to do this in Excel" question. [more inside]

## Bringing business cards into 2012

Android/cloud-based note app query. I'm looking for recommendations for an Android app that'll accept the large chunk of csv data I have and keep it synced with my PC. [more inside]

## How to populate PDF form from Excel data?

How to populate PDF form from Excel data: number of copies based on number of rows? [more inside]

## Excel: A job for vlookup?

Excel help? I think this is a job for vlookup but I'm not sure. [more inside]

## Excel crash course

Can anyone recommend a great Excel course? [more inside]

## Info from Silverlight into Excel?

Can I get this information from a site on Microsoft Silverlight into Excel? [more inside]

## Excel Manual

Im writing a manual for an excel tool I wrote. Does anyone know any really nice templates I can use or let myself be inspired by? I just need help on the aesthetic part ;)
It's one of those manuals with pictures and screenshots too :) [more inside]

## What are the best ways to increase Excel skills?

What are the best free and paid resources or training courses for Excel? [more inside]

## Please help me create a calender on Microsoft Excel using dates in the spreadsheet from another tab.

Please help me create a calender on Microsoft Excel as I can't find any help online. [more inside]

## Excel help

I have an easy (hopefully) question regarding time formatting in Excel. [more inside]

## Help me pivot the pivot table back!

How to reformat pivot table data so that it works like any other spreadsheet? Simple instructions needed. [more inside]

## Help me be the best data guy I can be

Part of my current job involves manipulating a large amount of data. I need to learn how to do this more efficiently and on a larger scale. What should I use? What should I learn? What is the best (free) way to teach myself? [more inside]

## html tables are killin' me.

How do I import tables from HTML into Excel when some cells have multiple lines? [more inside]

## Excel copy/paste question

Probably a simple Excel copy/paste issue... [more inside]

## Conditional formatting, with limitations.

How do I set conditional formatting in Excel based on whether a list value has been selected in a range of other cells? [more inside]

## Using formulae when I should be using VBA

Excel 2007 Filter: Is it possible to nest 3

**OR**statements in an Index and Match formula? [more inside]## Is creating a compound line graph possible with this dataset?

Is creating a compound line graph possible with this dataset? If yes, how? If not, how should I set up the data? [more inside]

## And maybe something with dollar signs I don't know

Need help with (possibly?) "indirect" in Excel. [more inside]

## Please help me get my Excel data back.

Earlier this morning, I accidentally deleted some columns of data on an Excel spreadsheet and then saved it. Is there a way to get those columns back? [more inside]

## Condition Excel... And Repeat

Excel Filter: Advanced Conditional Formating, Format based on type of formula used (average, sum, sumproduct etc..) [more inside]

## Excel function for consolidating a bunch of rows of nearly identical data?

I need help sorting out a bunch of data in Excel where the row data is almost identical except for one column that I need to retain. [more inside]

## Method Range of Object Global failed

I'm starting to write some Excel-VBA Macros, but it seems I don't get some basic things. I tried this simple code: [more inside]

## Options for labelling an axis when graphing with Excel

Excel graphing question: Is there a way to change the axis labels to something you are not graphing? [more inside]

## Need VBA help to refresh and save worksheet.

Have Excel 2007. I would like to have a spreadsheet perform the following simple? tasks [more inside]

## Excel keeps unreferring my references

Excel 2010 query using data from MS Access: refreshing the query screws with my cell references. Help me make it stop. [more inside]

## How do I match number IDs from 2 worksheets - when one worksheet is only a subset of ids from the other?

Excel help: How do I match number IDs from 2 worksheets - when one worksheet is only a subset of ids from the other? [more inside]

## How to determine relationship between two dimensions of a 3 x 3 frequency matrix?

Could someone help me to analyze statistical relationship between two dimensions of a frequency matrix - preferably in Excel? [more inside]

## Why can't spreadsheets work like brains?

Former excel magician attempts to use Google spreadsheets, fails. It should be easy to make a function that can tally a monthly total from a column of dates and a column of numbers, right? [more inside]

## Should I turn these simple programs into *apps*?

Dear Chaps, I have two products, an Excel spreadsheet and a Filemaker Pro database. The excel spreadsheet is for sale to mortgage brokers. It's the kind of thing designed for a user to enter figures and get all kinds of graphs and information based on the data entered. The other is a contact manager database, again designed as an easy-to-use program for the end user. Does it make sense to turn these products into iPhone/Android/Cloud-based apps, and what would be the next steps in doing so? In other words, what exactly would I be turning them into, and whom would I outsource this job to, if it makes economical sense?

## Stinky Linky!

Is there a way to define a link by the number of links into the webpage it is? [more inside]

## How do I create an amortization table where my payments change every period?

Is it possible to create an amortization schedule in Excel when the payment amount, the principal amount, and the interest amount each year is unique? [more inside]

## Why don't they teach us how to prep the numbers as well as how to crunch them?

ExcelFilter: How to combine the data from three spreadsheets into one spreadsheet? (But wait, there's more!) [more inside]

## How to get Excel to search multiple files?

How do I get Excel to search through multiple files and extract data into a separate worksheet? [more inside]

## Manage my Finances

Does anyone else manage their finances in excel? How exactly do you do it? I would like to manage my (pretty straight forward) personal finances. Alternatives to excel welcome. [more inside]

## How do I make a dartboard-type chart for the web?

I made an awesome dartboard-type chart in Excel, but now I'm trying to put it on the web. Help!! [more inside]

## Dumb Excel question

Excel-Filter: I am using Excel 2011 (for Mac, if it matters). I want to create a simple X-Y chart of two columns. That's it. Should be simple. But I must be missing something. [more inside]

## EXCEL QUESTION LOL

I have a data set of user activity. It records every time an activity is completed by a user, with the date and user ID attatched. I need to tally up the number of times, by user, the user completes the activity on a unique day. [more inside]

## Need some pointers on creating a simple inventory database

Need help setting up a simple Access database. I'm trying to reconcile a bunch of inventory, which is all recorded in multiple Excel spreadsheets. I want to import all the Excel files into an Access database so I can match them up all at the same time. [more inside]

## Help with Excel formula and table

I need to a formula that will calculate accumulated points based on the number of sales an employee had during a quarter, when there are certain milestones he or she has met. [more inside]

## Can a sortable spreadsheet exist in a PDF?

I have a PDF document and a spreadsheet in XLS format. We want to be able to put the spreadsheet into the PDF and allow users to click on the sheet's column headings to sort the data alphabetically depending on need. Is this possible? If so, what is the best way to do it? [more inside]

## Don't people do this every day?

I want to do something ridiculously simple in Excel that doesn't seem to be possible. Please tell me that's not true. [more inside]

## How can I create a sheet for each row in Excel?

ExcelFilter: Is there a way to create a sheet for every row in Excel? [more inside]

## Comparing Excel Sheets for Sanity and Such Things

ExcelFilter: Compare rows for data changes? I want to find out whether row values are different between two sheets on records that match. [more inside]

## Excel SUMIF function - what condition am I looking for?

ExcelFilter: how do I get SUMIF to work so that if a cell in the reference range is blank, the corresponding cell in the sum range is picked up in the sum? [more inside]

## How can I force Relative Cell References into a Conditional Formatting Forumual in Excel

In Excel I have 2 columns with dates in them. D1:D20 Start Date G1:G20 End Date. I want to highlight the cell in the range G1:G20 if the date is more than 14 days form the date in D1:D20. Obvious answer is conditional formatting, but I can't seem to create a formula with relative cell references. [more inside]

## Mail merge decimal woes

Mail merge woes - how can I get these decimals to display properly? [more inside]