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
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 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
Which language is used to calculate calculated/column field in Power Pivot?
Why aren’t absolute references in excel named constant references instead, and relative references named variable references?
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?