Spreadsheet Phobia

Upon commencement of a new unit a student asked me WHY SPREADSHEETS?

It took me a moment to understand that there are people who do not use spreadsheets EVERYDAY and has not spent their entire professional life growing up with spreadsheets seeing them evolve into this amazing phenomenon.

YES! I love spreadsheets

They are no longer this convoluted scary mess of gridlines and complex formulars that you cant remember when you need them the most. If you have not visited your spreadsheet program on your PC or laptop for a while, do so, you will be pleasantly surprised.

There are now a million (and I am not joking) templates for you to chose from should you not want to create one from Scratch. Simply open your program, Click File (Top Left Corner) then NEW and select TEMPLATES. You will probably have a Search box where you can enter what you are searching for or simply browse what is available.

There is a spreadsheet for everything from planning, organising and executing. The graphs and colours are amazing and should you remember what we were thought all those years ago, you will be able to modify the templates to suit.

Some of the favorites in class are:

  • Household Budgets
  • Holiday Planners
  • Christmas Present Shopping List/Budget tracker
  • To Do tracker
  • House Chores Roster

Don’t be afraid anymore, go visit your Spreadsheets and see how friendly they have become.

 

 

Advertisements

Monday Madness

Mad Monday Microsoft Shortcuts

C5Shortcuts are all about minimising the amount of clicks required when working on our computers by not taking our hands of the keyboard to locate and grab the mouse to activate a command making our efforts more efficient.

We are aware that they exist, we all know and use a few and know how great they can be but no one knows them all or even a vast range because unless they are used regularly of course we will forget them.

Every Monday I will post a short cut with an explanation on Why and How to use it. Print it out and stick it up on your wall and try it for a few days. If you are still using it on Friday you can be guaranteed that you need this particular shortcut.

Like our Facebook Page and/or follow our Blog and receive the Mad Monday Posts every week, you never know, you might find a shortcut or two that you did not know about and that is of use to you

Control (Ctrl) P

You guessed it!

Ctrl P open the Print window which allows you to make specific print selections or simply Click Enter to send to printer this saves you taking your eyes of the monitor and fingers off the keyboard to grab the mouse and Click on FILE – PRINT with the mouse and saves

Monday Madness

Mad Monday Microsoft Shortcuts

C2
Classic Coffee Cup

Shortcuts are all about minimising the amount of clicks required when working on our computers by not taking our hands of the keyboard to locate and grab the mouse to activate a command making our efforts more efficient.

We are aware that they exist, we all know and use a few and know how great they can be but no one knows them all or even a vast range because unless they are used regularly of course we will forget them.

Every Monday I will post a short cut with an explanation on Why and How to use it. Print it out and stick it up on your wall and try it for a few days. If you are still using it on Friday you can be guaranteed that you need this particular shortcut.

Like our Facebook Page and/or follow our Blog and receive the Mad Monday Posts every week, you never know, you might find a shortcut or two that you did not know about and that is of use to you

Control (Ctrl) P

You guessed it!

Ctrl P open the Print window which allows you to make specific print selections or simply Click Enter to send to printer this saves you taking your eyes of the monitor and fingers off the keyboard to grab the mouse and Click on FILE – PRINT with the mouse and saves

Monday Madness

Mad Monday Microsoft Shortcuts

C8

Shortcuts are all about minimising the amount of clicks required when working on our computers by not taking our hands of the keyboard to locate and grab the mouse to activate a command making our efforts more efficient.

We are aware that they exist, we all know and use a few and know how great they can be but no one knows them all or even a vast range because unless they are used regularly of course we will forget them.

Every Monday I will post a short cut with an explanation on Why and How to use it. Print it out and stick it up on your wall and try it for a few days. If you are still using it on Friday you can be guaranteed that you need this particular shortcut.

Like our Facebook Page and/or follow our Blog and receive the Mad Monday Posts every week, you never know, you might find a shortcut or two that you did not know about and that is of use to you

Control (Ctrl) N

Whatever Microsoft program you are in Ctrl N will open a NEW, a NEW worksheet in Word, a NEW Spreadsheet in Excell, A NEW email, Appointment, Task or Contact in Outlook.

This may not seem like a great time saver but coupled with others such as the Save As or Send or Print you can save a lot of time not having to use the mouse and take your hands and eyes of the Monitor.

 

Monday Madness

Mad Monday Microsoft Shortcuts

C4

Shortcuts are all about minimising the amount of clicks required when working on our computers by not taking our hands of the keyboard to locate and grab the mouse to activate a command making our efforts more efficient.

We are aware that they exist, we all know and use a few and know how great they can be but no one knows them all or even a vast range because unless they are used regularly of course we will forget them.

Every Monday I will post a short cut with an explanation on Why and How to use it. Print it out and stick it up on your wall and try it for a few days. If you are still using it on Friday you can be guaranteed that you need this particular shortcut.

Like our Facebook Page and/or follow our Blog and receive the Mad Monday Posts every week, you never know, you might find a shortcut or two that you did not know about and that is of use to you.

Control (Ctrl) B / (Ctrl) I / (Ctrl) U

The Functions in the FONT sections of the Home Tab can be accessed via shortcuts and the most used are BOLD ITALICS and Underlined. This works in all Microsoft Suite programs, Word Excel, Outlook etc.

Ctrl B – BOLD

Ctrl I – Italics

Ctrl U- Underlined

Try using these shortcuts as you type to prevent the need to go back to high light and then activate the function. Just prior to typing the word or sentence that you want in bold hold down the Ctrl key and hit B, continue typing and when you have finished the word or sentence repeat to go back to normal print.

NOTE – To highlight without the mouse – Use the arrow key to get to the beginning of the block hold down the Shift Key and use the arrows to highlight.

Monday Madness

Mad Monday Microsoft ShortcutsC6

 

Shortcuts are all about minimising the amount of clicks required when working on our computers by not taking our hands of the keyboard to locate and grab the mouse to activate a command making our efforts more efficient.

 

We are aware that they exist, we all know and use a few and know how great they can be but no one knows them all or even a vast range because unless they are used regularly of course we will forget them.

 

Every Monday I will post a short cut with an explanation on Why and How to use it. Print it out and stick it up on your wall and try it for a few days. If you are still using it on Friday you can be guaranteed that you need this particular shortcut.

 

Like our Facebook Page and/or follow our Blog and receive the Mad Monday Posts every week, you never know, you might find a shortcut or two that you did not know about and that is of use to you.

 

 Ctrl C & Ctrl V

 

2 in one week, I know it is supposed to be One but there is no point learning one without the other, this shortcut works in ALL Microsoft Office Suite programs, Word, Excel Outlook etc

 

Copy & Paste can be achieved by both Right Clicking on your mouse and in the FONT section in the Home Tab but that means that you will have to take your hands off the keyboard and grab the mouse to complete this function.

 

HOW – High light the words you want to copy either by mouse or with the arrow keys,(hold down Shift and arrows will highlight) Then Ctrl C to Copy, arrow or Enter tot eh location you want to paste to and Ctrl V.

Monday Madness

C7

Mad Monday Microsoft Shortcuts

 

Shortcuts are all about minimising the amount of clicks required when working on our computers by not taking our hands of the keyboard to locate and grab the mouse to activate a command making our efforts more efficient.

 

We are aware that they exist, we all know and use a few and know how great they can be but no one knows them all or even a vast range because unless they are used regularly of course we will forget them.

 

Every Monday I will post a short cut with an explanation on Why and How to use it. Print it out and stick it up on your wall and try it for a few days. If you are still using it on Friday you can be guaranteed that you need this particular shortcut.

 

Like our Facebook Page and/or follow our Blog and receive the Mad Monday Posts every week, you never know, you might find a shortcut or two that you did not know about and that is of use to you.

 

Control (Ctrl) Z

 

I can guarantee you that this Shortcut will become your best friend even more so than last week’s Ctrl Backspace. This shortcut works in ALL Microsoft Office Suite programs, Word, Excel Outlook etc

 

Image result for microsoft undo iconCtrl Z is the shortcut for UNDO, that little (backwards Arrow) in the top left hand corner.

 

WHY – instead of taking your hands of the keyboard to grab the mouse and locate the icon in the top left hand corner to click and replace your hands on the keyboard.

 

HOW –  A simple Ctrl Z and you have completed the UNDO function.