306 Answered Questions for the topic Microsoft Excel

12/22/19

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?

12/04/19

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

11/09/19

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

11/09/19

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

11/05/19

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

11/05/19

Online or in person

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

09/17/19

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

09/17/19

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

09/12/19

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

08/14/19

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

08/04/19

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

08/04/19

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

08/03/19

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

08/02/19

How can you use bullets effectively in Excel?

08/02/19

Can I change the color of Excel comments?

07/31/19

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

07/31/19

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

07/30/19

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?

07/30/19

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.

OR

Find an Online Tutor Now

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