Beginner's Guide to Microsoft Excel Online Training Course

Welcome to the Beginner's Guide to Microsoft Excel Online Training Course!

Are you a beginner in Microsoft Excel? If yes, then you've come to the right place. 

I used to be lousy in Microsoft Excel. I practically hated it, but my job required me to learn it or else I'm toast. I met a friend who was a master at it and he taught me seven (7) basic principles that changed my view and eventually my skill in Microsoft Excel. I'm going to share those same seven principles to you in this Beginner's Guide.

Here goes:

7 BASIC PRINCIPLES  IN MICROSOFT EXCEL FOR BEGINNERS

1ST PRINCIPLE : THE F1 KEY IS YOUR FRIEND -  The F1 Key is that key on the upper left side of your keyboard. In all Microsoft Office applications, it does one thing. It opens up your Help Menu. If you are beginning excel, I suggest you use this often as Microsoft has put together a very extensive how-to guide to help you if you get stuck in a ditch or if you want to learn a new command in excel. We all went through this one way or the other. If you are really new to computers, then this might not be helpful for you yet.

2ND PRINCIPLE : MASTER YOUR TOOL BARS / RIBBONS - Regardless of what MS Excel you're using mastery of how the application is key and most commands in MS Excel are accessible via the tool bars (2003 version or earlier), or Ribbons (2007 onwards) which if used correctly would drastically cut your working time in half.


3RD PRINCIPLE: ALWAYS AUTOMATE YOUR ROUTINE TASKS - Whether its adding a column of figures, calculating averages , finding the maximum or minimum number on the list and a whole lot more, one key principle I learned is that for routine tasks it is always best to automate. You may choose to record macros or add formulas. If unsure of how to input the syntax or execute the functions, go back and do Principle 1.


4TH PRINCIPLE : DARE TO EXPERIMENT - Much of the skills I learned in MS Excel, were born purely out of experimentation. I trained myself to simulate and discover how a formula or command is used.


5TH PRINCIPLE : READ THE FREAKIN' MANUAL - MS Excel has a built in help guide (Press F1) which contains everything you need to know about MS Excel. Read it or better yet master it.


6TH PRINCIPLE : RESEARCH TIPS AND TRICKS ON THE NET - The internet has a treasure trove of tips and tricks, resources, templates, even video tutorials and online tutorials that could make you MS Excel gurus in no time. I still do this till now because I don't really see myself as a guru yet.

7th PRINCIPLE : TEACH OTHERS TO LEARN - One of the best things I learned from my friend is the value of teaching others so they may learn. I realized that I could learn most from teaching others because I'm a kinesthetic learner.(I learn best by doing the action or skill myself first.) Thus when I teach others I redo the actions myself for me to prepare how I'm going to teach others.

There you have it. The 7 basic principles in Microsoft Excel. I hope you would benefit from them as I did. Stay tuned to this blog for our next topic: Baby Steps in learning Microsoft Excel.