Using excel to analyse information is an important skill to possess in this dispensation. Lots of business organisations are out in search for unique individuals who own such skill. Excel is perceived simple but that is in disguise as it very complex than it appears to the eye. From the mathematical to financial and statistical calculations, Excel brags about lots of formulas which is why some writers have nicknamed it as the Unicorn of all Spreadsheet.
Inputting formulas can be very tricky and preparing spreadsheets for mail merge can be a meticulous task to achieve. Bringing in ideas like conditional formatting and macros might just make those not familiar with the application yell and walk off to bed at night.
Keep calm, you won’t be the first to be in such shoes as lots of professionals have once been in the same situation at a point in their lives. There is a way to learn this application without visiting the conventional school or computer centres to learn about the efficient use of Excel.
There are numerous free resources available that ensures that you learn the application from the comfort of your workstation or house. Sit back relax and explore the 10 sites I have for you to learn Excel from.
1. Microsoft Excel Help Center
This site which has been created by Microsoft itself is to make sure that users and learners of Excel Spreadsheet possess the right skill to navigate and utilize the application. The site has step by step videos and images that will aid your learning towards becoming a professional.
Some of the featured topic dealt with in the website are:
- Move or copy worksheets or worksheet data
- Save a workbook in another file format
- Dropdown list
- Freeze panes to lock rows and columns
- Calculate the difference between two dates
- List of all Excel functions available
- How to avoid broken formulas
- IF function
- Access support for excel
- VLOOKUP function
- SUM function
Visit Here for more information
Chandoo prides as an Excel School which has structured and comprehensive online programs teaching Excel to intending learners. Chandoo has 10459 students till date and it gives step by step instruction, 20hours + video content, more than 50 Example workbooks, secure classroom, 30days money back guarantee.
Though some of the contents on this website is free but there are advanced options that must be purchased to get the best out of your learning.
Visit the site for more information
In Contextures, you will find everything to become an Excel Master (Debra Dalgleish, Owner & Lead at Contextures), whatever your learning style is, it has been taken care of by Contexture. They have got excel tips, step-by-step lessons, sample files and videos.
Learn more by visiting Contextures
4. Excel Central
This site allows you to learn the basics for free and choice can be made between the four versions of the program to ensure learning happens in a way that is convenient and valuable.
5. Excel Hero
This site brags about containing detailed and fascinating videos, fairly advanced excel information and up to hundred free downloadable workbooks. With Excel Hero you can learn about animated business charts, excel optical illusions and the power of XML inside excel just to mention a few.
Learn more to be an Excel Hero
6. Mr Excel
This site contains tips and tricks that you can use to master the application at your finger tips. It has a forum where you can discuss with other members of the forum and enhance your skill, save time create accurate and useful reports on Excel. It also contains some products that must be purchased from their store.
Click to meet Mr Excel
7. Improve your Excel
With this site, you could watch videos about everything you need to know about excel from shortcuts to pivot table to hyperlinks to Excel Macro. This is a free source that will really help improve your excel skills if you are a visual learner and also loves demonstration.
Click here to Improve your Excel
8. Excel Easy
This is an excellent website which all of its learning areas have simple and clear explanation to follow. The videos are very clear, uncluttered and non-offensive to the eye. The sections have been clearly divided into Introduction, Basic, Functions, Data analysis and VBA.
click here to Excel Easily
9. Excel Jet
With Excel Jet, there are free resources that can be harnessed for improving skills in Excel, such as the 200 excel shortcuts which can be downloaded here. With the use of this shortcut, you can be rest assured that you can control the screen with your keypads alone.
For more information, go through the page of Excel Jet
10. GCF Learnfree.org
GFCLearnFree.org offers access to a staggering 29 tutorials and five extras. You can learn Excel basics from creating and saving workbooks to conditional formatting and more. The information is highly accessible, and you can even take a quiz at the end to see how much you’ve learned.
Learn more at GCF