I’d rather be making macarons, but my Microsoft training can help you achieve your dreams.

Okay so I have a confession to make…It is not my lifelong dream to be a computer trainer. Don’t get me wrong, I really love my job and I am passionate about helping the people I train but in all honesty I would rather be choreographing sweet dance moves for Beyoncé or trying to construct the perfect macaron for a Parisian patisserie. My job however, enables me to have flexibility in my life, which in turn allows me to spend time on the things that really matter to me.

Do you have your DREAM job? Maybe not. Maybe your dream job doesn’t involve formatting a word document or creating a chart in Excel. But maybe your current job is helping you to achieve the other goals or dreams that you have in life. So why not be as good as you possibly can at your current job and save the frustrations that come from not having the skills you need to fulfil your role. Get Microsoft Word, Excel or PowerPoint Savvy with Savvy Training. Contact me for a free demonstration of how the training works via Skype: savvytraining@live.com.au

Save time in Windows 7 with Aero Snap

A couple of weeks ago we discussed the fabulous Aero Flip 3D feature that allowed us to scroll quickly through our open windows in Windows 7. Now I want to show you how to use the Aero Snap feature.

This feature is extremely handy because it allows you to quickly position two windows on-screen at once. Instead of having to manually adjust and position each window Aero Snap quickly places that window into half the screen size. You can be on two different websites:

AeroSnap3.JPG

Or work in Microsoft Word and Excel at the same time:

AeroSnap2.JPG

You can do this with any two windows and it is very simple. First make sure you have an Aero Theme Applied: right-click on your desktop - select Personalize - then choose an Aero Theme from the gallery.

Click on the top of your window and drag as far as you can to the right or the left of the screen. When you let go the window will automatically snap to that side of the screen.

AeroSnap4.JPG

Hope this saves you a bit of time and hassle.

Don't forget to hit 'like' if you found this helpful. Until next time... peace out.

Best shortcut in Microsoft Excel - the secret is out!

I'm about to give away a secret... nerds all over the world are not going to be happy about me empowering the common folk with their secrets but here it goes.

Cells in Microsoft Excel naturally display the result of the formula instead of the formula itself. At times however you need to check your formulas, this means clicking on every single cell and looking at the formula bar. To view all formulas in your spreadsheet use the shortcut CTRL+` this will display all the formulas in the workbook at once. It is what nerds would call a toggle key - this means that you can keep clicking the shortcut to turn the view on and off.

(Notice in the picture the spreadsheet displays all of the formulas instead of the formula result. This is how it appears after using the CTRL+` shortcut.)

Formula View.JPG

This is not only useful for checking formulas but can also be handy if you would like to print your formulas. We've all seen it happen, a smarty pants in the office creates a spreadsheet with all these mysterious formulas, then they leave. The poor remaining office folk do not know how they appeared there and before long the formulas are lost forever. If you use the magical CTRL+` shortcut then print your spreadsheet you have record of the formulas that can be filed for future record.


It's about time everybody knew these tricks. So that's what I'm doing - empowering all of you with these simple tricks. They wont change your life but they will save you a load of time and embarrassment.

Adios for now, Letitia