How to multiply two cells together in Excel

Ever wanted to multiply two different numbers together in Microsoft Excel?  The great thing about Excel is that you don’t need to use a calculator to do it – Excel can do it for you!  But we need to tell Excel what to do first!

  1. Type the numbers into Excel that you want to “times by”.  Make sure they are in two different cells (a cell is one of those little square boxes you see)
  2. Click on the cell where you want the answer to appear
  3. Start typing the following formula.  Firstly, hit the equals key, then select the first number, then add a “multiply” symbol – which in this case is the star on the 8 key (shift 8), then select the second number and hit enter
  4. Your answer will appear!

If you want to take a look at the formula we just created together, click on the cell where the answer appears.  Look up in the formula bar (just below the ribbon) you will see something like =A1*A2.  Don’t worry if it doesn’t make sense at the moment, the best way to look at it is to read it out loud.  In this case “this cell equals whatever is in cell A1 times whatever is in cell A2″.  Simple!

’till next time!
TNP ;)

Change a number to a percentage (%) in Excel

Have you ever wanted to change a number into a percentage in Excel? The easiest way is to just type the number in and add the % symbol (by holding the shift key and F5), and then hitting enter.  If you want to change a number afterwards into a percentage, here is what you do:

  1. Click on the cell that you want to turn into a percentage
  2. On the home tab, look for the number group about half way across the ribbon, and then click on the percentage symbol

That’s it?  Well not quite.  You may notice that your percentage may now have a few extra zeros on the end!  Hmm that isn’t right.  That is because Excel knows percentages to be a fraction of a single whole number.  For example if your number was 34, and you did the above procedure, the cell would now look like 3400%.  Excel thought that 34 meant 34 times, or 3400%.

To fix it up, click on the cell and delete the two extra zeros from the cell.

To avoid it happening in the future, just remember that you need to use the decimal point when you type numbers in.  For example, 0.34 (which equals 34%), instead of 34 (which equals 3400%).

It may seem a little complex at first, but once you start playing around with percentages in your spreadsheet you will pick it up very quickly!

’till next time!
TNP ;)

Add a black line across a page in Word

Ever wanted to add a simple black line across the page of your Word 2007, 2010 or 2013 document?  Maybe it is to break up some sections, maybe you simply like the look of it?  Either way, adding a line to your document is very easy

  1. Select the paragraph where you want the line to appear (note the line will appear at the end of the paragraph)
  2. On the Home tab, look for the “paragraph” group.  In that group there is a button which is usually in the bottom right hand corner called “borders”.  By default it will have the bottom border option available - simply click on that!

If you want to add lines in other places or directions relative to the paragraph, click on the little drop down arrow beside the “Borders” button.  If you want to remove the line, simply click on that paragraph again and then click on the borders button again – and watch it disappear!

’till next time!
TNP ;

Add two cells together in Excel

Have you ever wanted to figure out what the total would be if you added two cells together in Excel?  There is a really simple way to do it – without your calculator.  Let me explain how….

  1. Make sure you have typed your numbers into Excel in different cells
  2. Select the cell you want to have the total appear in (it may make sense to be below the numbers you just typed in)
  3. Once you have clicked on the cell, type an equals sign, select the first cell, type a plus sign,  then select the second cell, then hit enter
  4. You should now see the total of the two cells!!!

If you click on the cell with the total in it, you will notice something we call a formula.  In this case it might look like “=A1+A2 ”.  The best way to figure out what the formula in the cell is calculating is if you read it out loud.  In this case it says “this cell equals whatever is in A1 plus whatever is in A2″.

So there you have it – the simple way to add two cells together in Excel (and your introduction to formulas!)

’till next time!
TNP ;)

Add a page number in Word 2013

So you want to add a page number to the footer of your document in Word 2013?  Simple!

  1. Click on the “Insert” tab in the ribbon
  2. Look for the “Header & Footer” group (about 2/3 of the way across the menu)
  3. Click on “Page Number”
  4. From the drop down menu, select where you want the page number to appear – either the top of page, bottom of page, page margins, or in the current position
  5. Then select your page number style (there are plenty to choose from – including plain ones which you would be used to from previous versions of Word)

If you search through the styles, if you just want a simple Page X of Y, you will find it there too.

’till next time!
TNP ;)

 

How to Undo in Excel

So… you have been working on that spreadsheet for hours and all of a sudden you deleted the wrong thing.  Now you need to undo what you did in Excel 2013? Here is how to do it:

  1. Look in the top left hand corner of the Excel screen – above the File menu.  You will probably see a few small icons there.  Look for the arrow pointing backwards – that is the undo button.
  2. Click on it to undo what you just did
  3. If you want to undo a few steps, you can click on the little drop down arrow on the button, and you can undo the last 20 or so actions you have done

There you go – your formulas are still safe!

’till next time!
TNP ;)

Bullets in Word 2013

So you want to structure some text in Word 2013 in a nice easy way for your reader to… well… read.

Bullets are a great way of doing just that.  To use bullets simply

  1. Make sure you are on the “Home” tab
  2. Look for the “Paragraph” group
  3. Click on the top button on the left hand side, which looks like some bulleted text
  4. Start typing your bulleted list!

If you want to take some text and turn it into a bulleted list, simply select the text and then follow the process above!

’till next time!
TNP ;)

Create a look up list in Excel 2013

Ever wanted the users of your spreadsheets to fill in cells using only a certain number of options.  Wouldn’t it be fantastic, instead of making people remember the correct names (and spelling) of each… that we could just give them a nice little list of options to pick from to populate the cell?

Well in Excel 2013, that is really easy!  Here is how to go about it.

Using Data Validation to create look up lists in Excel 2013

1) Click on the cell you want the look up / drop down list to appear in

2) Go to the “Data” tab in the Excel 2013 ribbon

3) Look for the “Data Tools” group

4) Click on “Data Validation”… then click on “Data Validation” from the drop down menu

5) In the box that appears, on the “Settings” tab, set the Validation criteria to allow “List”

6) In the “Source” text box, type in the options you want to make available (and remember to separate them with a comma!)

7) Click “OK”

Easy as that!

’till next time!
TNP ;)

Get rid of the annoying backwards P in Word

Don’t you hate it when you can see all those “backwards Ps” all throughout your Word document.  There are probably lots of other marks in your document too… like arrows, dots and more.

These are what we call paragraph marks and formatting symbols – or what others sometimes call “codes”.  You can show or hide these marks, symbols and codes really quickly.  All you need to do is:

  1. Make sure you are on the “Home” tab in the ribbon
  2. Look for the “Paragraph” group
  3. Click on the icon that looks like the “Backwards P”

Or next time you can use the shortcut key which is CTRL+SHIFT+8.

’till next time!
TNP ;)