How do you create an Excel formula that will automatically discount a number by 5% if it is over 100? 

by on June 7, 2013

Q: hey when using exel how do you create a formula that will take 5% off automatically if the number is greater then 100

 
 

Can I add an adobe illustrator page as a tab to an excel book? 

by on May 16, 2013

Q: Can I add an adobe illustrator page as a tab to an excel book?

 
 

How can I combine or merge 3 ordered lists? 

by on April 12, 2013

Q: i have 3 lists
some items are on all lists, most are not.

i want to create a single list that will:

has all items on the list in the order that they are given in the seperate lists

for example.

list 1 is

M
B
A
D

list 2 is

C
F
M
Z

and list 3 is

F
D
Z
N

the final list should have these items sorted where they go based on their positions in the previous lists

so

C
F
M
B
A
D
Z
N

i’m using excel and its hard trying to copy these one at a time when the lists are bigger than the example.

if theres a website that i can input the data from the lists in and get the final product i would appreciate it.

 
 

How can I handle 5k lines of sources and authors? 

by on March 12, 2013

Q: I have more than 100 spreadsheets filled with bullet points of text that total over 5,000 lines. They are on disparate subjects, from many sources and authors. I have not been able to find software that can handle this kind of ‘lines of text’. Not documents full of text. Guidance on software that could handle such would be appreciated.

 
 

How can I compare the part numbers on one excel sheet to the inventory on another? 

by on November 28, 2012

Q: I have two excel spreadsheets I need to compare, one is a list of part numbers, and the other is a list of inventory. I need to find out if the list of part numbers corresponds with the inventory list and mark what in the inventory list was on the list of part numbers. There are over 4000 rows so it needs to be something done quickly and easily.

 
 

How do I make my Excel spreadsheet automatically calculate for the next invoice date in 20 days? 

by on November 28, 2012

Q: I have a spreadsheet in Excel, how do I get it to automatically calculate for next invoice date in 28 days?

 
 

How do you setup double a numbering system in Excel? 

by on October 18, 2012

Q: How to set up double numbering system in excel (example : 0001, 0001, 0002, 0002 all the way to 3500, 3500)?

 
 

Is it possible to make changes to one excel sheet and have the other excel sheet display the same changes? 

by on October 7, 2012

Q: How do I link formatting in an Excel document? I have two sheets within an excel document. The data is linked between the two sheets. That data is identical except that sheet 1 is alphabetized and sheet two is in a random order. But I would like to link the formatting for the cells as well. If I change the color of a cell in sheet two, I want it to automatically match the corresponding cell in sheet 1 that it’s data is already linked to.

 
 

Why does my computers color quality switch to 8-bit when I open Excel but stays 32-bit with all other applications? 

by on August 21, 2012

Q: My Dell computer ‘s color quality switches to 8-bit when starting Excel every time I start it. “Word” doesn’t have this p[roblem. How can I keep the quality at 32-bit?

 
 

How can I convert a PDF to an Excel document? 

by on May 31, 2012

Q: how can i convert a pdf that has been scanned in using OCR into a excel document