Many small business owners and employees have a working knowledge of Excel, and may have used it to organize events, create schedules, and sort data. However, many may not know the wide range of advance functionality that Excel offers that can automate tasks, guide strategic decisions and even increase sales.
We’ve developed a list of the top comprehensive and free Excel training tools that you and your employees can use to learn and master Excel. Even if you already are familiar with Excel, who couldn’t use a refresher or a deeper level of understanding to master the tool? And if you’re new to Excel, this post is a great place to start!
Microsoft Office Training Center
Microsoft provides extensive customer service for its users, at no extra cost. Microsoft also provides a Resource Hub for all Microsoft applications. No one knows Excel better than Microsoft, so their Excel Training Center is a great place for small business owners and employees to start.
The Excel Training Center includes free tutorials, videos and guides, as well as an Excel Training Roadmap Downloadable PDF. Some of the topics include getting started, designing workbooks, adding and formatting data, creating pivot tables and charts and collaborating with others. These resources are available for all levels so you can find the best fit for you and your employees.
The Spreadsheet Page
The Spreadsheet Page is another excellent resource to gain a deeper understanding of Excel. The site was developed by John Walkenbach, a true Excel expert. He has written 50 published Excel books for all levels, as well as over 200 articles and reviews for well renowned magazines including InfoWord and PC/Computing.
The site is extremely well organized and contains extensive lists of User Tips by Categories. Another very useful aspect of the site is the Downloads page. This contains Excel workbooks and add-ins that users can download for free. These downloads contain valuable techniques and tricks that users can apply to their own work.
Another great Excel resource is the Spreadsheets Section within About.com. Spreadsheets has extensive resources for all levels, but is particularly useful for beginners. There are thousands of instructions and how-to posts, many of which include diagrams and screenshots. In their “Excel 101 – How to Use Excel” section, the site provides useful step-by-step tutorials for beginners on how to use the basic features, including “how to create and use formulas for calculations, entering data, formatting worksheets, printing and creating charts and graphs.”
New content is added to the site regularly, and each piece of content is categorized and easy to find. The site also has a free newsletter which will send you updates on the latest Excel news and tips.
Chandoo.org is a blog and passionate community where experts share excel tips, charting tutorials, visualization ideas and downloadable Excel tutorials. The site has over 500 informative tutorials which provide detailed examples and downloadable workbooks for free.
The site provides Excel Basics that introduces users to the “6 areas that form the core of basic Excel skills.” The site also provides resources to learn more Advanced Excel Skills that address advanced formulas, tables and formatting, advanced charting, pivot tables, VBA and macros, using Excel productively, and more. Like the Spreadsheets Page, Chandoo provides users with downloadable excel and chart templates.
Contextures Inc YouTube Channel
If you learn best by video tutorials, the Contextures Inc. YouTube Channel is for you. The site provides users with an extensive free video database of professional tutorials and training. These include Excel tips, a large collection of Excel sample workbooks, keyboard shortcuts and links.
The channel has nearly 400 videos that will show users how to drastically improve their knowledge about Excel. The videos range from basic to intermediate levels.
With these tools, you’ll be able to master Excel in no time, at zero cost. With so many different types of online resources available, you can learn Excel at your own pace and on your own schedule. If you’re looking for an Internet service to help your business take advantage of these online resources, make sure to consider HughesNet Business Internet.