Find an Online Tutor Now

311 Answered Questions for the topic Microsoft Excel

Microsoft Excel Excel

26d

How can I learn 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.
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
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
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
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
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.
Microsoft Excel Math 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
Microsoft Excel Microsoft Word Gantt Graph

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?
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
Microsoft Excel Accounting Economics

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
Microsoft Excel Accounting Economics

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
Microsoft Excel Accounting Economics

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
Microsoft Excel Accounting Economics

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
Microsoft Excel Accounting Economics

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

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

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
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
Microsoft Excel

11/05/19

Online or in person

Is this in person or online. I entered Tempe zip code
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
Microsoft Excel English Biology

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
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
Microsoft Excel Statistics Excel

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
Microsoft Excel Vba Macros

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