Ireland's Number One Source For Practical Computer Tips
Looking to create a chart/graph in Microsoft Excel 2007 ? Follow the steps below and create your chart in just seconds
1 Create the Chart
1.1 Add data to your sheet
The first thing you must do is to add your data to the spreadsheet like in our example(see Figure 1)
Figure 1 Enter data
1.2 Select the Chart
Select [...]
Have you ever suffered serious frustration and wasted much time adding a table of contents to your Word document? Well help is at hand. Follow the steps in this short guide and from now on you will find adding a Table of Contents to be a piece of cake.
(Please note that this guide uses Word [...]
1. Get the day of the Week from Date
where cell A1 contains the date 01/12/2009 the formula
= Text(A1,”ddd”) will give Tue
= Text(A1,”dddd”) will give Tuesday
2. Count Occurences in a Column
Sometimes you may wish to count the number of occurences of a number or text in a sequence of cells.
Using our example we see that
=CountIf(A1:A10,5)
will give [...]