Newest Excel Questions | Wyzant Ask An Expert

205 Answered Questions for the topic Excel

03/15/19

Excel - Formula is guessing wrong in Fill Down command?

I know this should be simple but I can't work it out. I have a column that is calculated with the sum of the 3 columns to the left of it. E.g. SUM(C1-C3). When I fill that down, each cell... more

Follows • 1

Answers •2

Excel Microsoft Excel

03/15/19

How do I convert XLSX to CSV?

Follows • 1

Answers •1

Excel Microsoft Excel

03/15/19

How can I record a cell value in Excel to another sheet each time it is changed by a user?

Follows • 1

Answers •1

Excel Microsoft Excel

03/15/19

How do you get a percentage on Excel?

Follows • 1

Answers •1

Excel Microsoft Excel

03/15/19

How do I find the top 3 values in Excel?

Follows • 1

Answers •1

Excel Microsoft Excel

03/15/19

How do you alternate column colors in Excel?

Follows • 1

Answers •1

Excel Microsoft Excel

03/15/19

How do you auto Add in Excel?

Follows • 1

Answers •1

Excel Microsoft Excel

03/15/19

How do I change case in Excel 2010?

Follows • 1

Answers •1

Excel Microsoft Excel

03/15/19

What is the difference between Excel XLSX and XLSM?

Follows • 1

Answers •1

Excel Microsoft Excel

03/15/19

How do I enter the round function when there is already a formula in the cell?

Follows • 1

Answers •1

Excel Microsoft Excel

03/15/19

How do I automatically color cells in Excel?

Follows • 1

Answers •1

Excel Microsoft Excel

03/15/19

How do you make a spreadsheet in Excel where the data points correspond to the product of the x and y axis without having to manually type in the formula for every cell?

Follows • 1

Answers •1

Excel Microsoft Excel

03/15/19

Can an Excel formula calculate a student’s marks?

Follows • 1

Answers •1

Excel Microsoft Excel

03/15/19

How do I keep the existing value in a cell constant while adding the formula in excel?

Follows • 1

Answers •1

Excel Microsoft Excel

03/14/19

How do I put numbers in order on Excel?

Follows • 1

Answers •1

Excel Microsoft Excel

03/14/19

How do you get top 5 values in Excel?

Follows • 1

Answers •1

Excel Microsoft Excel

03/14/19

How do you rank in Excel?

Follows • 1

Answers •1

Excel Microsoft Excel

03/14/19

How do I get Excel to automatically add dollar signs?

Follows • 1

Answers •1

Excel Microsoft Excel

03/14/19

How do you use the lookup function in Excel?

Follows • 1

Answers •2

Excel Microsoft Excel

03/14/19

What is IF function in Excel?

Follows • 1

Answers •1

Excel Microsoft Excel Accounting Excel Formula

03/14/19

Use records as keys to populate data in Excel?

I have two sheets in Excel. One with record ID and the other with record ID and numerical value. However, the records are not (and will never be) in the same order. How can I tell excel "Match the... more

Follows • 1

Answers •1

Excel Microsoft Excel

03/14/19