## Who else wants to know the secret to Excel Formulas?

Invest in yourself in 2015 and reduce your frustration with formulas in Excel for just $19.95 - Click here to enroll todaySo you are a hotshot who doesn’t need to use a mouse! Fair enough, viagra 40mg power users tend to find they can do tasks quicker by using shortcut keys. Shortcut keys are combinations of keystrokes on your keyboard that can make the program do a certain task.

The new Ribbon UI in Word 2007, Excel 2007, and PowerPoint 2007 is easier to use with a mouse, but if you want to use your keyboard shortcuts, there is a quick, easy, and *visual* way to find out what you need to press.

**All you need to do, is hit the “Alt” key**. Simple as that. By pressing the “Alt” button in Word 2007, the keyboard shortcuts appear on top of all the different sections of the Ribbon.

For example, (looking at the screenshot), to open the file menu, all I need to do is hit “ALT+F”. If I want to save my file, which happens to be one of the Quick Access Toolbar buttons, I could hit “Alt+1”. To change to the Insert Tab in the Word 2007 ribbon, I could hit “Alt+N”

As soon as you go to another tab in the ribbon, if you hit “Alt” again, you can see all the shortcuts for each piece of functionality on that tab.

So there you have it – all you need to do is remember “Alt” is your shortcut to keyboard shortcuts in Word 2007! (and Excel 2007, PowerPoint 2007 etc etc).

**Want to master the key shortcuts in Word 2007?**

TheNewPaperclip.com has put together a 5 day audio course that will help you remember and confidently use the key keyboard shortcuts in Word 2007 in just 15 minutes a day. You can find out more over at www.shortcutcourse.com, or you can enrol in the course now.

’till next time!

TNP 😉

Office 2007, Shortcuts, Tips, Tutorial, Word 2007

Hey everyone… welcome to October! (OMG almost Christmas!)

I am sure almost everyone who is reading this post has Excel installed on their computer at work or at university. But how many of you really know what Excel is really capable of?

This month I am going to focus on Excel 2007 content. One Excel 2007 tutorial each day for the entire month… 31 posts that will help you master Excel (and not the other way around!)

So are you ready to excel at Excel? (sorry, viagra sale had to do it!) Stay tuned!

‘till next time!

TNP 😉

Are you working with numbers in Excel 2007, advice

Excel 2010 or Excel 2013 that include decimal points?

Did you know you can quickly increase or decrease the precision… or the number of digits to the right of the decimal point.

For example:

- Reduce the number of decimal point places in 56.923 to 56.9
- Increase the number of decimal point places in 23.4 to 23.4256

To change the number of decimal places your numbers have simply:

1) Select the cells you want to work with

2) On the Home tab of the Ribbon in Excel 2007, look for the “Number” group

3) Click on either “Increase Decimal”, or “Decrease Decimal”. They are the buttons which have all the zero’s on them with the left and right arrows.

Simple as that!

‘till next time!

TNP 😉

Are you working with numbers in Excel 2007, global burden of disease

Excel 2010 or Excel 2013 that include decimal points?

Did you know you can quickly increase or decrease the precision… or the number of digits to the right of the decimal point.

For example:

- Reduce the number of decimal point places in 56.923 to 56.9
- Increase the number of decimal point places in 23.4 to 23.4256

To change the number of decimal places your numbers have simply:

1) Select the cells you want to work with

2) On the Home tab of the Ribbon in Excel 2007, look for the “Number” group

3) Click on either “Increase Decimal”, or “Decrease Decimal”. They are the buttons which have all the zero’s on them with the left and right arrows.

Simple as that!

‘till next time!

TNP 😉

Are you working with numbers in Excel 2007 that include decimal points?

Did you know you can quickly increase or decrease the precision… or the number of digits to the right of the decimal point.

For example:

- Reduce the number of decimal point places in 56.923 to 56.9
- Increase the number of decimal point places in 23.4 to 23.4256

To change the number of decimal places your numbers have simply:

1) Select the cells you want to work with

2) On the Home tab of the Ribbon in Excel 2007, help

look for the “Number” group

3) Click on either “Increase Decimal”, or “Decrease Decimal”. They are the buttons which have all the zero’s on them with the left and right arrows.

Simple as that!

‘till next time!

TNP 😉

So you have upgraded to Word 2010! If you have made the leap from Office 2003 or earlier, sale

you might have a few challenges finding some of the features you use regularly. One of those great features is Undo! (I think Undo is the feature I use the most!)

To undo in Word 2010, you can either do it using your mouse, or using some shortcut keys.

**To undo using your mouse in Word 2010:**

- Look towards the top left hand corner of your Word 2010 window. Just above the office button you will see a number of small icons along the top of the screen (by the way – that is called the “Quick Access Toolbar”). Click on the one that looks like an arrow that points backwards – that is the undo button.
- If you want to undo more than one
~~mistake~~action – click on the little down arrow beside that button, and it will give you a list of actions you can undo!

**To undo using shortcut keys in Word 2010:**

- Simply hold down the “CTRL” key, and press “z” (CTRL+Z)
- To undo more than once, just keep pressing CTRL+Z

So there you have it – the easy way to get rid of your mistakes in Word 2010! 🙂

‘till next time!

TNP 😉

*(PS. try this article if you are looking to **undo in Word 2007**)*

Are you building a spreadsheet and would like to know how many black cells you have in a given range in an Excel 2007, oncologist

Excel 2010 or Excel 2013 workbook?

There is a great function in Excel that you can use to do exactly that – count the number of BLANK cells in a range.

Simply type…

**=COUNTBLANK( range)**

(replace *range* with the range of cells you want to limit your count to).

Note that there is one particular thing that might slip you up with this function. When using =COUNTBLANK(), buy cialis

Excel is only searching for blank, empty cells. If you have a space in a cell for example – it might look empty to you, but Excel can see that there is a space – which means it will not think it is blank, and not count it.

‘till next time!

TNP 😉