Learn Excel Formulas Online at Formula School

Are you looking for an online Excel course that helps you understand how to use functions and formulas? Formula School recently launched their Formulas 101 online course which will help everyone come to grips with how to use formulas in Excel.

The interactive course which combines video, text, image and screencast content with an Excel based student workbook, covers everything you need to know about formulas and functions like SUM, AVERAGE, MIN, MAX and COUNT. There are units focused on working with text in formulas, and understanding and resolving Excel errors, as well as a key Excel concepts unit for those who need a refresher on the basics.

The thing I like about the course is that it includes quizzes and assessment along the way, and if you pass it all you can get your Certificate of Completion!

For anyone interested in reducing their frustration with Microsoft Excel, Formula School’s Formulas 101 course is for you.


’til next time!

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!

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!

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!

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.
    Capitalize Each Word

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

’till next time!

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!

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!

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!

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!

Change line spacing in Word 2013

So you want to space out (or shrink) the amount of space between your lines in Word 2013 (or Word 2010, because it is the same!).  Well here is how:

  1. Make sure you select the text you want to change the line spacing of (if you want to change it for the whole document, press CTRL+A to select everything)
  2. Make sure you are on the “Home” tab in the ribbon menu
  3. Look for the “Paragraph” group (its the third one along)
  4. On the bottom row you will see a button which has an up and a down arrow beside what looks like a paragraph.  If you hover your mouse over it, a little pop up will appear that says the button is “Line and Paragraph Spacing”.  Click on that button
  5. You will have a number of different options to choose from – 1.0 (Single line spacing), 1.15 (the default line spacing), 1.5 (one and a half line spacing), 2.0 (double line spacing), 2.5, and 3.0.
  6. If those options don’t suit you, click on “Line Spacing Options” to access fine grained control over your line spacing

’till next time!