How to add rule lines or grid lines to your OneNote page

Out of the box by default your OneNote notebook will have lots of blank pages. But if you are using a stylus or pen to take notes with your tablet using OneNote, and you are a messy writer like me… chances are you would prefer to have some lined paper in your OneNote notebook. Not only does it make it easier for you to write neater, it also will help others to read your (horrible) writing!

To add some lines to your paper in OneNote all you need to do is:

  1. Click on the “View” tab in the ribbon
  2. Look for the “Page Setup” group
  3. Click on “Rule Lines” then select your preferred line option

One you are happy with your selection and want to save yourself the hassle of adding rule lines to every page you create… simply repeat the process, but select “Always Create Pages with Rule Lines”

So there you have it – the quick and easy way to add lines to your OneNote notebook!

’till next time!
TNP ;)

Rename your sheet in Excel

Do you have multiple sheets in your Excel workbook? Want to have something more descriptive than “Sheet 1″, “Sheet 2″, or “Sheet 3″ so you can keep track of all the work in your spreadsheet, model, or budget? It is quick and easy to rename your sheets in Excel 2007, Excel 2010 or Excel 2013.

  1. Right click on the tab for the sheet you want to rename
  2. Click “Rename”
  3. Type your new name in… and then hit enter!

 

 

Simple as that – now you can keep track of all those sheets in your workbook with ease.

’till next time!
TNP ;)

Letter sized presentation? Change the size of your PowerPoint slides

Ever wanted to create a presentation which you or your audience could print out perfectly on Letter sized (8.5x11in) paper?

Well you can really easily in PowerPoint 2007, PowerPoint 2010, or PowerPoint 2013. What we will do is change the size of the slide to match the size of the paper you want to print or present the presentation on.  Let’s see how to do it…

 

  1. Click on the Design Tab in the Ribbon
  2. Look for the “Customize” group at the far right hand end of the ribbon

  3. Click on “Slide Size”
  4. Click on “Custom Slide Size”

  5. In the “Slide Size” dialog box that appears, select your preferred slide size from the drop down box. In this case select “Letter Paper (8.5x11in).

  6. If you want the slides to be in portrait orientation – so they print out as you would read them naturally on Letter paper… make sure you select “Portrait” in the Slide Orientation section

There you have it – your Letter Sized Presentation!

’till next time!
TNP ;)

10 Things every manager needs to know about Office

Recently Paul Woods (the alter ego of The New Paperclip) was a guest on the Chandoo.org Excel podcast – one of the most popular Office related podcasts online today. During the interview he shared his top ten (non-excel related) Microsoft Office tips that every manager or analyst should know.

If you haven’t had a chance to listen to the podcast yet – make sure you read more about it, and listen here:

Podcast: my top 10 non excel Microsoft office tips on paul-woods.com or

CP017: Top 10 non-Excel MS Office tips for you – Interview with Paul Woods – Office MVP & Blogger on Chandoo.org

’till next time!
TNP ;)

Add, subtract or average time in Excel

If you are like me and you want to do some kind of calculation or duration in hours, minutes and seconds – I am sure you have been very frustrated with Excel totally ignoring what you want to achieve! Well did you know that it isn’t as hard as Excel makes it out to be! You can very quickly do calculations like adding two times together, subtracting times from each other, or seeing what the average time is of a range. They key is to ensure that your cells or formatted correctly first. Here is how you do it!

  1. Select the cells that you want to add your times to
  2. Right click, and then select “format cells” from the menu that appears
  3. In the “format cells” dialog box that appears, make sure you are on the “Number” tab
  4. In the category box, select “custom”
  5. Look for a Type in the list which looks like [h]:mm:ss and select it
  6. Click Ok

Now that your numbers are formatted correctly as times, you can start doing your calculations. Simply add, subtract or average like you normally would in excel using formulas like =SUM(), and =AVERAGE()

’till next time!
TNP ;)

Select difficult to get to objects in Word using the Selection Pane

Have you ever worked on a document with a lot of shapes, diagrams, pictures or text boxes?  Don’t you hate it when they overlap or are on top of each other and it is near on impossible to select the right object!  You may be like me and move the objects on top to get to the ones below … but did you know that there is an easier, much better way?  There is – using the Selection Pane.

The selection pane enables you to select the object by its name, irrespective of where the object is in your document.   Not only that, you can make an object invisible for a short amount of time so you can see everything else underneath it!

To turn on the selection pane in Word:

  1. On the “Home” tab, look for  the “Editing” group on the right hand side of the screen
  2. Click on the little arrow beside “Select”
  3. Select “Selection Pane”

The selection pane will appear as a task pane on the right hand side of your Word screen.  To select an object in your document, simply click on the name of the one you are after.  You can make an object invisible by simply clicking on the “eye”.  To bring it back, click on the “closed eye”.

’till next time!
TNP ;)

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