I wanted to know a list of all radio stations within my state because I used to use a belkin fm transmitter to listen to my ipod. When travelling I find that the clarity of the signal gets a bit noisy some times. So searching the web, I found a list of all the radio…
Read More
Excel Worksheet Tips: Average Without Zeros
Excel Worksheet Tips: Average Without Zeros Have you got a collection of data that you wish to take the average of, but do not want to include zeros? By including them, it will alter the average you are looking for. Excel 2003 =SUM(A1:A10)/COUNTIF(A1:A10,”<>0″) Excel 2007 & 2010 =AVERAGEIF(A1:A10,”<>0″,A1:A10) This is the quick way to use…
Read More
Excel Worksheet Tips: Hiding Buttons When Printing
Excel Worksheet Tips: Hiding Buttons When Printing You may have a sheet that contains buttons, which when pressed, perform an action. When printing an active sheet, these buttons will be displayed on the printout. This may not be desired, as it doesn’t look professional. To remove these from printing: 1. Ensure you are in design…
Read More
Excel VBA Tips: Selecting the Default Printer in VBA
Excel VBA Tips: Selecting the Default Printer in VBA I had created a document that is to be printed by multiple people in different locations. However, when pressing the print button that I created on the worksheet, I needed to ensure that the default printer for each location was selected. This can be done with…
Read More
Excel VBA tips: How to Run Macros When a Workbook or Worksheet is Protected
Excel VBA tips: How to Run Macros When a Workbook or Worksheet is Protected Have you created a workbook which contains macros, but you wish to protect the sheet? When you protect the sheet, it stops the macros from running, which is really annoying. However, there is a way around this. 1. Open up VBA…
Read More
IT Tips – Clearing clipboard in Word and Excel 2007
IT Tips – Clearing clipboard in Word and Excel 2007 I was wondering where that option had disappeared to. After some searching, I discovered how to clear the clipboard. 1. In the office application, click the home tab. 2. On the left hand side of the bar, there will be the clipboard. Click on the…
Read More
Excel Chart Tips: Plotting With a Dynamic Range
Excel Chart Tips: Plotting With a Dynamic Range Another tip that I learnt today. When plotting a graph, the data that is to be plotted must be linked to the graph. What happens when the range of the data changes in length? You need to be able to plot using a dynamic range. 1. Specify…
Read More
Excel Worksheet Tips: Adding ticks and crosses
Excel Worksheet Tips: Adding ticks and crosses Have you created a list and you want to tick off an item? 1. Select the cell you wish to add the tick to. 2. Change the font to “webdings” 3. To enter a tick – enter the letter a. To enter a cross – enter the letter…
Read More
Excel VBA Tips: Running macros using hyperlinks
Excel VBA Tips: Running macros using hyperlinks At work today I had to create a workbook that provided links between different sheets within a workbook and turned on a filter. However, I didn’t want to use buttons, as it would be become extremely cluttered. I discovered that you can run macros using hyperlinks, so commandbuttons…
Read More
Excel Worksheet Tips: Table from PDF to Excel
Excel Worksheet Tips: Table from PDF to Excel At work today, I was asked if there was a way to extract the data from a table in a PDF in Adobe Reader and paste it into an excel workbook. You can, if you have the expensive adobe acrobat version; however, for the rest of us,…
Read More
SUBMEG 