Find out what a word means (or how it sounds) in Word 2013

Sick and tired or switching back and forward between your dictionary, thesaurus or encyclopedia when you are not quite sure what a word means when you are reading a document in Microsoft Word?  Maybe you are writing a document and you want to make sure what a word means before you publish your document?

Then the new Define tool in Word 2013 is a great tool that will help you be more accurate.

To use the Define tool:

  1. Select and highlight the word that you want to dive deeper on and get a definition of
  2. Go to the “Review” tab in the ribbon
  3. Look for the “Proofing” group on the left hand side of the ribbon
  4. Click on the “Define” button

On the right hand side of the screen you will see a new task pane appear.  This will show the definition of the word you were looking for from the Bing Dictionary.

As a bonus you can also hear how a word sounds like by clicking on the speaker beside the word in the task pane.  Perfect if you are going to talk to someone about your document in the future!

’til next time!
TNP ;)

Change the case of a sentence in Word 2013

Ever wanted to change the text in your Word document to ALL CAPS or UPPERCASE… what about all lowercase?  Maybe sentence case?  Capitalize Each Word? oR sWITCH tHE cASE aLTOGETHER?

The good news is that you don’t need to retype that sentence, paragraph or (heaven forbid if you wrote a document in all caps) the entire document.  There is a quick and easy way to change the case of text in Word 2013.

  1. Highlight the text you want to change the case of
  2. On the “Home” tab, in the “Font” group, look for the button that looks like “Aa” (it should be a few buttons to the right of where you set the font and font size).  That is the “Change Case” button.  Click on the button
  3. Select the option you prefer from the menu that appears:
    Sentence case.
    lowercase
    UPPERCASE
    Capitalize Each Word
    tOGGLE eACH cASE

And as soon as you click – the case has changed!

’till next time!
TNP ;)

Calculate the number of work days between two dates in Excel

Ever wondered how many work days there are between two dates?  Maybe you are counting down the number of days you have left in the office before your big holiday?  Maybe you just need to know how many days you have until that project is due?  Whatever the reason, using Excel you can calculate the number of business days between two dates.

To do so, we will use the NETWORKDAYS formula.

  1. Type the two dates you want to calculate the number of days betwen into Excel – in one cell type the date you want to calculate from, and the other cell the date you want to calculate to
  2. In another cell, type =NETWORKDAYS(
  3. Select the first cell – if you typed the first date in A1 the formula will now look like =NETWORKDAYS(A1
  4. type a comma
  5. Select the second cell – if you typed the second date in B1 the formular will now look like =NEWWORKDAYS(A1,B1
  6. Type the closing bracket to complete the formula – it will now look like =NETWORKDAYS(A1,B1)
  7. Hit enter!

There you have it, the number of days you need to wait until you go away, or the number of days to countdown until that deadline!

’till next time!
TNP ;)

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 ;)

How to print in Word 2013

So your masterpiece is complete and you want to print it to share with the world?  It is easy to print your document, poster or other Word 2013 creation.

  1. Click on the “File” menu
  2. Click on “Print”
  3. Take a look at the print preview and make sure it looks ok, and if it does…
  4. Click on the big “Print” button

’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 ;)