Help, Tips, Tricks, and Tutorials for Word, Excel, Outlook, Office 365 and more

Main menu

Category Archives: * Level 300 – Advanced

Have you ever wanted to quickly know what cells are impacted on when you change a value of a cell in Excel 2007, tadalafil Excel 2010 or Excel 2013.

By using the “Trace Dependents” feature, you can very quickly understand exactly the influence a cell has in your spreadsheet. The best part of this feature is, that you will see big arrows that enable you to visually see the relationship, so you don’t have to decipher formulas and cell names to make sense of it all.

To turn on Trace Dependents:

1) Select the cell you want to see the dependents of

2) Make sure you are on the “Formulas” tab of the ribbon

3) Look for the “Formula Auditing” group (about 3/4 of the way along the ribbon)

Is there a section of text in your document (or your whole document!) that isn’t “English (United States)” or another language. Well to make sure that your spelling and grammar checks in Word 2007 work well, ampoule you need to make sure that text is marked as the right language.

Have you ever built an awesome slide with lots of different objects? Well then I am sure you will understand how frustrating it can be when you need to select an object that is behind 3 or 4 other ones!

Did you know there is a great tool you can use called the “Selection Pane”, recipe that will help you select those pesky, click hard to get to objects?

Selection Pane simply lists all the objects that are on a slide, sovaldi sale in a simple to use task pane to the right hand side of your PowerPoint 2007 screen. Using Selection pan you can quickly select any object, not matter how far to the back of the slide it is.

To turn on the selection pane:

1) Make sure you are on the “Home” tab of the ribbon

2) Look for the “Editing” Group – you will find it on the far right hand side of the ribbon

Are you building a spreadsheet and would like to know how many black cells you have in a given range in an Excel 2007, seek 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(), healing 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.

One of my favourite resources for fun facts like that is Jensen Harris. Those of you who have dug a little deeper into Office 2007 would recognise that name – he is the guy responsible for the new Ribbon user interface.

Only around 50% of users use the Ctrl+C shortcut to copy (which means 50% of folk use the menu!)

Only around 27% of users use the Ctrl+S shortcut to save (which means 73% use the menu!)

Only around 2% of users use the Ctrl+O shortcut to open documents (which means around 97% of users don’t!)

Anyone thinking what I am thinking? There is a huge opportunity here to increase productivity of Office users across the board, simply by working with users to identify what shortcut keys have the biggest impact, and helping them to master them.

Now there are two ways to go about that. The first is probably the most pervasive already – lists of shortcut keys. You can find them anywhere, simply by Googling (or Bing’ing) “Word Shortcut Keys”. People download them, print them out, and put them on their desk beside their computer.

But what happens when you have a list of shortcut keys?

1) You don’t learn them, you just refer to them

2) You don’t actually work through the shortcut keys to understand what they are capable of

3) You are probably less productive when you take into account the time it takes to look up the shortcut key every time you use one!

The second way is to work through a learning program which helps you understand the impact of, remember, and give you confidence to use key shortcut key combinations when you need to.

How many learning programs like that exist? None.

Well until now…

I have put together a audio course called “Five days to Word 2007 shortcut mastery”. Now this isn’t for everyone. If you are comfortable with your list of shortcuts that you refer to all the time – then great! If it works for you then there is no reason to even think about enrolling in this course.

On the other hand, if you still struggle with remembering, or understanding what shortcut keys are available in Word 2007, then this course is exactly what you are looking for.

Before you ask… no, it isn’t free. But this is the kind of specialist training that you can’t really find anywhere else at the moment, and it has the potential to help you save hundreds or even thousands of dollars in lost productivity yourself.