Expertise Will answer all types of questions from beginners to advanced plus a little bit of VBA.
Experience Owner of Computer Training Solutions training company in the UK, Microsoft certified Master Instructor and qualified IT teacher with several years teaching and training experience, plus several years of statistical analysis.
Education/Credentials Qualified teacher (post graduate degree), main degree in Maths, Stats and computers.
Q: Would you mind to show me how to draw a vertical line? I clicked on VIEW => TOOLBAR => DRAWING, ... A: From the drawing toolbar you need to choose the line tool which looks like a line and says "line" if ...
Q: Is there a way in Excel to ensure a name or number does NOT repeat itself in a column? We are ... A: there may be a way using VBA to prevent this, however it's beyond my expertise. I would use ...
Q: Is it possible to have excel set the color of a number based on whether the number is positive or ... A: You can do this through conditional formatting, which can be found under Format - Conditional ...
Q: I would like to use a value from one worksheet to automatically be used in a different ... A: Do you mean you would like to add values from different worksheets together? You can do this by ...
Q: i have a simple question, i want to add numbers to the beginning of each row, like it is already ... A: Apologies for the late reply, the questions had been going into my junk email folder and I only just ...
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
