##
69 posts tagged with microsoft *and* excel.

Displaying 1 through 50 of 69. Subscribe:

## Excel is being mean to me.

I need to have two Microsoft Excel documents open side by side, on my monitor, at the same time.
However each time I open a second document, the first one disappears and turns into the second, so only one of the two documents shows on my screen. [more inside]

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

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

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

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

## Pinning Excel docs to the taskbar doesn't work with Office upgrade

So I upgraded from Microsoft Office Starter 2010 to Microsoft Office 2010. I uninstalled the Office Starter program. Then things went wrong. Please help! [more inside]

## Info from Silverlight into Excel?

Can I get this information from a site on Microsoft Silverlight into Excel? [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]

## Don't select what I selected, select what YOU think you should select!

Help me understand how to make a macro do what I want it to do - automatically select the relevant area instead of a previously recorded cell range. [more inside]

## Excel is the death of me!

I have about 200 separate Excel spreadsheets that I need to change one field in. There is a date in G4 that needs to be the same in each sheet. Is there way way to do this without opening, editing, and saving each sheet one at a time?

## Excel for People who don't know anything

Excel issue. Tried looking on the internet, had no success. Can y'all help? Selecting and deleting multiple nonadjacent rows. [more inside]

## How can I find the average of multiple columns in excel without selecting each individual row that I want averaged?

How can I find the average of multiple columns in excel without selecting each individual row that I want averaged? [more inside]

## Excel Formula for First Instance of Something in Row, Then Top Value in That Column?

Excel question (debt management/budgeting): what formula gets me the first instance of something in a row, and then how I can pull the date from the top of that column? More inside. [more inside]

## Good help forum for Office 2010?

Can anyone recommend a good, well-trafficked forum for Microsoft Office (particularly 2010) questions? Seems like this should be eminently Googleable, but maybe because there are so many of them, I'm not finding the one that is

*the*one. Thanks!## stymied by excel

There has to be an answer for this, but I just can't figure it out. In Excel, I've got 5 columns (A-E). I need to return a list of values from column A if either column B or C equals 'foo', *and* if either column D or E equals 'bar'. What's the magical formula (or whathaveyou) that will make this happen? For bonus points, results need to appear on a separate tab than the source data.
asking on behalf of mrs spinturtle, I personally have no idea what I'm talking about.

## How to sort data WITHIN a cell in Microsoft Excel 2007 on Windows?

How to sort data WITHIN a cell in Microsoft Excel 2007 on Windows? [more inside]

## Excel 2003 Page Break/Print Area Q

Microsoft Excel 2003 Question: Can I manually set the Page Breaks in Page Break Preview, and THEN print the document so that each manually set page will fill the entire printed sheet of paper? [more inside]

## Excel hell

Excel 2007 filter: How do you change the dictionary language for specific cells/columns/rows? [more inside]

## Excel 2003 ... is an update making this product non-functional?

Why doesn't excel 2003 work on my computer anymore? [more inside]

## Have paragraphs. Want just the hyperlinks. In Excel.

Need list of trade publications. Found huge one on Ulrich's web. How can I remove all information except for the (hyperlinked) titles, ideally in a way that keeps the titles on separate lines so I can then paste them into Excel? [more inside]

## Can you reccomend me a good Excel 2007 Book?

Can you reccomend me a good Excel 2007 Book?
I'm currently studying a foundation degree in Renwable Energy in the UK, and am struggling with Excel 2007. A general book would be handy, but the main topic I'm really struggling with is 'visual basic', so it would need to include detailed information on how to use that and the coding system of Excel.
Can anyone reccomend a good book to get that would include information relative to that?

## Need to print Excel spreadsheet so it turns out like a vertically-folded half-sheet card.

Need to print Excel spreadsheet so it turns out like a vertically-folded half-sheet card. [more inside]

## Word 2007 formatting question

How do I keep a particular tab in Word2007 from automatically disappearing? And other Word2007 and Excel 2007 questions inside. [more inside]

## Looking to up my presentation skills in NYC

I'm looking for a job doing presentation graphics (in law firms, possibly financial firms); this is about 30% of my current job at a law firm. I'm one of very few "experts" at my firm which isn't very technologically advanced in this area, so I'm afraid that my skills won't cut it in the outside world. I need advice on how to upgrade my skills. [more inside]

## ExcelFilter: Between Day 1 and Day 90, I had how many of which?

How can I count certain things in a range of cells in Excel that fall between two dates? [more inside]

## Making a monthly events calendar using seat-of-the-pants design!

I need to make a template for an in-print events calendar, and I'm not sure what the best way to approach this project is. Advice please! [more inside]

## #,###

I need a custom number format for Excel that only gives me a decimal when I need it. [more inside]

## How do I get Word and Excel to work together?

I need MS Excel and Word to play together nicely. I can do what I need to in Word, and I can do what I need to in Excel; it's the Relationship that's Complicated. Maybe I need workflow advice? Basic knowledge? Please, please keep reading. [more inside]

## How can I make a DDE connection close in Windows XP?

How can I close DDE connections? [more inside]

## Mac OS X / Excel problem - recovered file causing endless crashing

Mac OS X / Microsoft Office 2004 (Excel) crash and failed file recovery has left excel in an endless loop of restore and crash. Can anyone help me to find and delete the (unwanted) auto-saved excel sheet that is causing this problem? [more inside]

## I see you've used Microsoft Word before.

How do I get 'rock hard' Microsoft Office skills? [more inside]

## Stumped by VBA-ising an array formula in Excel

How to do a VBA version of the following array formula in Excel?
The following array formula (entered with ctrl,shift,enter) will produce the string 'Bank statement'!H842, which is the name of a cell I would like to be able to manipulate via VBA:
{="'Bank statement'!H"&MATCH(C1&D$39,'Bank statement'!A:A&'Bank statement'!C:C,0)}
[more inside]

## Turning a complex Excel spreadsheet with VBA functions into an online app

I want to build a web app based on an Excel spreadsheet using VBA and some Excel Solve functionality. Should I try to build my own online spreadsheet? Or is Microsoft about to release some nifty online development components compatible with Excel and VBA? [more inside]

## Using conditional formulas to sum up data in Microsoft Excel

Can I use Excel to loop through lists of names and sum up numbers for each name, without having to define the cell ranges that correspond to each name? [more inside]

## How can I conditionally format an entire row in Excel based upon the data in one of the columns in that row?

How can I conditionally format an entire row in Excel 2007 based upon the contents of a particular column in that row? [more inside]

## excel macro n00b

I need help writing a macro that will divide a 5000 row table into groups of 30 rows, and find the average of certain columns in each group. [more inside]

## Help me merge Excel with Access:

How do I add a 4,000 name MS Excel file to an existing MS Access database? [more inside]

## Microsoft Formula Help

How do I cut/paste a project in MS Excel and not have my formula cells change with the movement of my cells? [more inside]

## Excel formula question

Excel question: How to define a range so that it always adds up to a constant value. [more inside]

## I miss my speadsheets!

Why is Excel not opening? [more inside]

## excel/word online tutorial

My girlfriend is going for an interview where she will be tested on Microsoft Word and Excel. Is there an online tutorial where she can take some sample tests or run through some applications? We've googled a few, but they seem to stop at beginner levels and to be rather cumbersome. Just wondered if anyone had some first hand knowledge of a site to head to.
Regards/p &k

## Finding the right Microsoft Excel formula

I've got an Excel spreadsheet with numbers ranging from 2,000 to 600,000. I want Excel to look at each cell and essentially categorize all of those into five categories in a new column. If the value is less than 10,000, I want Excel to give it a 1, if the value is between 10,000 and 50,000 I want it to be 2, if the value is between 50,000 and 100,000, I want it to return 3, if it's between 100,000 and 500,000, I want a 4, and if it's above 500,000, I want a 5.
I tried the IF function, but I can't figure out how to a) make it recognize multiple variables, and b) I don't know how to tell it to look for numbers within a range. The Excel help section about arrays and lookups is fairly mystifying. Anyone got an idea?
(I know I could sort the data and do this manually, but I'd like to learn how to do this Excel's way.) Thank you!

## Error When Exporting Access Report to Excel

Some colleagues are trying to export a MS Access report to Excel. Here's the error they get: [more inside]

## Understanding external references in Microsoft Excel?

It's very clear in Microsoft Excel how to calculate formulas using external references, but what isn't clear is how, in several worksheets, to have the same data in certain columns. How do I do this? [more inside]

## How to highlight cells in excel with a keystroke.

MS Excel XP: What is the keyboard shortcut to highlight a cell? My searches turn up no answers.

## How to correctly export columnar labels from Word into Excel?

A friend has a large list of address labels in column format which were created in Excel, then exported to Word. He no longer has the original Excel file. [more inside]

## Excel Help for Pie Graph of Frequency of Appearance of Values in a Column?

ExcelFilter: I need help creating a pie chart as a separate worksheet in Excel that counts how often values appear in a column and creates a pie graph based on that data. I'm stumped, I'm not using the right Google terms, and my company's help desk couldn't guide me through the process, either. (That sounds awkward, so I describe it more comprehensibly inside.) [more inside]

Page:
1 2