Article Results (Showing 1 - 10 of 66) RSS Alert
-
What's in a name?
Excel yourself: NEALE BLACKWOOD, INTHEBLACK'S MOST POPULAR AUTHOR ACCORDING TO THE LATEST READERSHIP SURVEY, OFFERS A TWO-PART EXCEL YOURSELF...
Intheblack, 09/01/09 by Blackwood, Neale · More from publication -
Excel Yourself
NEALE BLACKWOOD JUGGLES EXCELS DEFAULT TEMPLATES. Q: I use a lot of custom formats and custom colours in my spreadsheets. I have to recreate them...
Intheblack, 09/01/09 by Blackwood, Neale · More from publication -
Excel Yourself
NEALE BLACKWOOD GETS PAST GO TO. Q: I copy data into Excel from our system but the data isn't complete. One column has an entry followed by blank...
Intheblack, 08/01/09 by Blackwood, Neale · More from publication -
Excel Yourself
NEALE BLACKWOOD GIVES SOME RANDOM ADVICE. Q: Is it possible to generate random numbers in Excel? A: Yes. Often it is useful, when setting up a...
Intheblack, 07/01/09 by Blackwood, Neale · More from publication -
Excel Yourself
NEALE BLACKWOOD SOLVES A MULTI-LINE VLOOKUP. Q: I have a database that has five separate rows for each item. I can use VLOOKUP to find the first...
Intheblack, 06/01/09 by Blackwood, Neale · More from publication -
Excel Yourself
NEALE BLACKWOOD SOLVES A LEADING ZERO PROBLEM. Q: I use Excel to create a .csv file. When I reopen the .csv file in Excel I lose all the leading...
Intheblack, 04/01/09 by Blackwood, Neale · More from publication -
Excel Yourself
NEALE BLACKWOOD OFFERS SOME PRINT MACRO TIPS. Q: I have recorded a macro that changes print settings and then prints various sheets. The problem...
Intheblack, 03/01/09 by Blackwood, Neale · More from publication -
Excel Yourself
NEALE BLACKWOOD DEMONSTRATES CHECKBOXES Q: I've seen a checkbox used in a sheet. How do they work? A: Excel has a number of controls that can be...
Intheblack, 02/01/09 by Blackwood, Neale · More from publication -
Excel Yourself
NEALE BLACKWOOD TAKES THE IF OUT Q: I use an IF function to compare two values to confirm they balance and put a 1 if they don't balance and a 0...
Intheblack, 12/01/08 by Blackwood, Neale · More from publication -
Excel Yourself
NEALE BLACKWOOD ON GETTING RID OF THE ERROR MESSAGE Q: I have a formula that returns an error message. Can I get It to display a blank cell...
Intheblack, 11/01/08 by Blackwood, Neale · More from publication
