194 Answered Questions for the topic Excel

Excel

05/16/18

How do you create a pivot table in Excel?
Follows • 2
Expert Answers •1
Excel

05/16/18

I want to learn and master Excel in a month or two. What would you recommend?
Follows • 2
Expert Answers •1
Excel

05/16/18

How do you color code in MS Excel?
Follows • 2
Expert Answers •1
Excel

05/16/18

What are the must-know Excel tips and tricks?
Follows • 2
Expert Answers •1
Excel

05/16/18

How do I drag a formula without changing the reference cells?
Follows • 2
Expert Answers •1
Excel

05/16/18

Why do management consulting companies continue to use Microsoft Excel when Google Sheets is just as good if not better and free?
Follows • 2
Expert Answers •1
Excel

05/16/18

What is a pivot table?
Follows • 2
Expert Answers •1
Excel

05/07/18

excel problem
i have some names that are repeated often i want to use a function that uses persons names and nth time repetition of it as arguments to give me the row which indicate the person name and nth... more
Follows • 1
Expert Answers •1
Excel

02/22/18

Excel Formula to subtract the value in Cell B3 from the value i n Cell A2
 Excel Digital information Tech. 
Follows • 4
Expert Answers •4
Excel

02/02/18

how to convert this to excel 52-30%-10%-10%=29.48
how to convert this to excel 52-30%-10%-10%=29.48
Follows • 2
Expert Answers •1

10/02/17

Excel question
Enter an IF function to determine if the Trans_Qty in C11 is less than zero. If the Trans_Qty is less than zero, then return the absolute value of the Trans_Qty, or else the cell is left blank.... more
Follows • 2
Expert Answers •1

01/28/17

I need to create a furmela for a business commission
 Dear heros,   i would like to create a exel formula for commercial commissions which will start from 5% if the deal is =<500,000  then it would be decreased till reach to 2.5% when it equals... more
Follows • 2
Expert Answers •1
Excel

01/04/17

How do I adjust the right portion of the custom header in Excel?
Making rt border = to lt border does not fix custom hdr rt portion problem. I have a folder which contains (31) different files containing from (1) to (8) pages each. They are all on 11" x 14" size... more
Follows • 2
Expert Answers •1

12/13/16

=IF(M7<12,5,IF(M7<13,3,IF(M7<14,1,IF(M7>14,0)))) where would you add the word boy in this formula to identify that this is specifically for boys
this is urgent
Follows • 2
Expert Answers •1
Excel

10/06/16

How do I adjust custom borders in Excel?
In creating a custom header for a file, there is an option for aligning the left & right sections of the header w/ the page side borders; if selected, the left section is properly placed but... more
Follows • 2
Expert Answers •1
Excel

07/16/16

Excel help?
Arrange the expenditures by date in the appropriate category in excel?
Follows • 2
Expert Answers •1
Excel

02/03/16

How do you edit and rename files in MS Excel?
(1) HOW TO RENAME A FILE  (2) HOW TO OBTAIN A BLANK RIBBON FOR EDITING TEXT NEAR THE TOP OF THE SCREEN AS MOST OF MY (31) FILES IN TOY TRAIN INVENTORY DON'T HAVE IT
Follows • 2
Expert Answers •1
Excel

05/21/15

IF function formula exceeding criteria limit
=IF(P5=0.00,"0.05",IF(P5=10,000.00,"0.10",IF(P5=30,000.00,"0.15",IF(P5=70,000.00,"0.20",IF(P5=140,000.00,"0.25",IF(P5=250,000.00,"0.30",IF(P5=500,000.00,"0.32"))))Excel wont accept it because it... more
Follows • 4
Expert Answers •3
Excel

02/26/15

Microsoft excel help
You have been tasked with analyzing an extremely large amount of data and to ultimately produce a report to share with the Board of Directors. The data is currently in a text file and has over two... more
Follows • 3
Expert Answers •2

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.