475 Answered Questions for the topic Microsoft Excel

Microsoft Excel

08/09/20

If formula error
Why is my If formula not copying down? It’s giving me a false error, I’ve tried adding absolutes as well.
Follows • 2
Expert Answers •3
Microsoft Excel Power Bi

07/16/20

Create a summary table using power BI
Hello, Join multiple tables to create a summary table i.e picking one or two columns from 7 to 10 tables/spreadsheets to create a summary table. Summary table will have one record per subject. I am... more
Follows • 1
Expert Answers •1
Microsoft Excel

06/22/20

Excel Lookup Functions
You have a data table and need to find data points in relation to other data in the table. The data you are looking for are to the left of (or above) the column (row) with the reference data, so... more
Follows • 1
Expert Answers •2
Microsoft Excel

05/16/20

Copy a column in excel to another area of a sheet that matches a field in the top
I have some data trying to organize using excel functions, one of the question i have is below.I have 2 tables in one sheet (those can be in two sheet/tabs also). In table 1, the data in Apr-2020... more
Follows • 1
Expert Answers •2
Microsoft Excel Excel

05/13/20

help with excel

I can’t figure out how to make this happen. i have a user form created in excel. i have radio buttons, drop down lists and a text box on the userform. for example: if in the drop down list I choose... more
Follows • 1
Expert Answers •2
Microsoft Excel

04/01/20

Excel formula help
10. In cell D21, enter a formula without using a function that multiplies the value of cell D22 by 2.83 and then adds the value of cell D19 to the result.
Follows • 0
Expert Answers •2
Microsoft Excel Math Science Physical Science

02/20/20

What is lagging effect?
I have no idea what this question is about. I have the graph plotted but stuck at lagging effect? 'Does this plot support the theory that lead in the environment (and hence taken up by children) is... more
Follows • 1
Expert Answers •1

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?
Follows • 1
Expert Answers •1
Microsoft Excel

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
Follows • 1
Expert Answers •2

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
Follows • 1
Expert Answers •1

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
Follows • 2
Expert Answers •1

11/09/19

Excel Financial Functions
Time to learn some new functions! Depreciation is the process by which a company spreads the expense ofan asset over its useful life. Even though a company may actually pay for the asset... more
Follows • 2
Expert Answers •1

11/09/19

Excel Financtial Functions
Calculate the total monthly payment: You want to buy a house that costs $250,000, you have $25,000 for adown payment, loan rate interest is 3.5% a year compounded monthly and you plan to get a... more
Follows • 1
Expert Answers •1

11/09/19

Excel Financial Functions
Assume the same data as provided in question #4. How much would you have to pay each month to pay offthe loan in 10 years?Data from question #4: Time for a new problem. You want to borrow $200,000... more
Follows • 1
Expert Answers •1

11/09/19

Excel Financial Functions
Time for a new problem. You want to borrow $200,000 at 4% interest compounded monthly. If you canafford to make monthly payments of only $1200/month, how many months (cell J14 on the sample... more
Follows • 2
Expert Answers •1

11/09/19

Financial Functions Excel
The casino threw in a new twist. In addition to the previous offer (options 1 and 2):1) $30,000 five years from now, or2) $25,000 todayThey are offering to pay you an annuity (option 3):3) $9,000... more
Follows • 1
Expert Answers •1
Microsoft Excel

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
Follows • 5
Expert Answers •1
Microsoft Excel

11/05/19

Online or in person
Is this in person or online. I entered Tempe zip code
Follows • 1
Expert Answers •1
Microsoft Excel

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
Follows • 1
Expert Answers •1
Microsoft Excel English Biology Chemistry

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
Follows • 1
Expert Answers •2
Microsoft Excel

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
Follows • 5
Expert Answers •3

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
Follows • 1
Expert Answers •1
Microsoft Excel Vba Macros Microsoft Excel 2010

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
Follows • 2
Expert Answers •1
Microsoft Excel Copy Paste

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
Follows • 2
Expert Answers •2

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
Follows • 1
Expert Answers •1

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.