Excel Shortcut Keys

Hi to all my loyal readers.

There have been a few addional updates to the the list of shortcuts for Office 2007. As many are not familiar with some of the new shortcuts I thought I would post the list on the blog. Click on Read the rest of this entry below to view the list.  If you would like shortcuts for other programs please drop me a comment or an email. Read the rest of this entry »

Microsoft Excel Training on Cell References

Cell referencing is a usual challenge to beginners of Excel. On my training courses I often draw the analogey to learning how to drive with gears. At first you have to think carefully and concentrate, but it soon becomes instinctive. I beleive the same is true for realtive and absolute formulas.

Read the rest of this entry »

Page Break Preview in Office 2007

During many of the training sessions I give, a common question has been where the “Page Break Preview” option has been hidden in Office 2007.

Many people used to access it from the button on the top of the print preview screen (Excel 2003 and prior). It is longer there.

It can now be found in one of two places.

Read the rest of this entry »