306 Answered Questions for the topic Microsoft Excel


Import Gantt chart from excel to word 2010

helloi have inserted the diagram and link it with the excelbut i want to have only the word filehow i can embed the chart without needing the external excel file?


Using Countif in Conditional Formatting with Sequential Cells

Hello,I have an excel sheet which I need to highlight rows based on value from another cell. If this particular cell is part of a set of certain numbers, the entire row gets highlighted. Easy... more


Excel Financtial Functions

You are considering making an investment. The initial payment for the investment is $1000. In the secondyear, you will receive $3500, in the third year you will have to pay $2000, in the fourth... more


Excel Financtial Functions

The IRR (Internal Rate of Return) is another very useful function. Internal rate of return (IRR) is a metricused in capital budgeting to measure the profitability of potential investments. Internal... more


Single average of entries per day

I maintain a trouble ticket report... each ticket has it's own row and contains the date opened, the ticket type, and ultimately a date closed (blank means its still open).I'm trying to create a ... more


Online or in person

Is this in person or online. I entered Tempe zip code


Is my distribution skewed or normal?

So my mean, median and mode are all 88, but on the histogram it looks skewed. I was using the score of 200 test scores. It doesn’t look symmetrical at all but the mean, median and mode are all the... more


Find the next two terms of sequence

U0 = 1U1 =3And Un is defined by Un+2 = 2 * Un+1 + 3 * UnFind the next two terms


Microsoft Excel question.

Create a formula without a function using absolute references that subtracts the values of cells B5 and B7 from B6 and then multiples the result by cell B8. Separate formula Create a formula... more


Help with analyzing Rank Data with Weighted Responses

I'm working in Excel on data related to hotels. Responses need to be weighted based the percent of total rooms in the sample. (E.g. Hotel A has 12 rooms, sample is 100 rooms spread over x hotels.... more


Copy Excel worksheet and maintain relative cell reference in formulas?

Another copy problem in Excel: How can I copy a Worksheet from WorkbookA.xlsx into WorkbookB.xlsx without the copied Worksheet still referencing WorkbookA.xlsx e.g. the formula `=B!23` becomes... more


Copy comma delimited values into two excel cells?

I have comma delimited values that look like : 17 ab 2880662,2880663 15 ab 2877244,2877247 21 ab 2874201 21 ab 2873876When I copy this to Excel it should split the comma-delimited... more


Prevent Excel from clearing copied data for pasting, after certain operations, without Office clipboard?

Whenever you copy a cell or a range of cells in Excel (my version is 2010 on Windows 7), and then do something else like insert new sheet row or simply edit another cell, Excel removes the... more


How can you use bullets effectively in Excel?


Can I change the color of Excel comments?


How can I stop Excel from opening a second blank window when opening a file from Explorer?

When I open an Excel file from Windows Explorer, I always get a second Excel window as well. Annoyingly, when I close it, it doesn't close, but the other window does!This seems to be a common... more


Excel hyperlink not redirecting properly (bug?)?

I have an Excel hyperlink problem: I click on, let's say `A1`, copy the link in it (`http://www.godaddy.com/domains/searchresults.aspx?ci=54814`), right click on hyperlink and copy that SAME URL as... more


How do I get the day name into a cell in Excel?

Given a date, how do I get the day of the week (e.g. "Monday") into a cell in Excel?


How can I spellcheck in Microsoft Excel?

1 3 4 5 6 7 13

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.


Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.