Excel is used all over the world, in many different locations, for a whole variety of purposes. What is the best way to learn Excel? You might use Excel to maintain a simple to-do list, or at the other extreme you could use Excel to model complex financial simulations. Behind Excel’s simple exterior lies a very capable platform for data crunching. Once you learn the basics of Excel there are many ways to advance your skills and knowledge, from instructor-led training courses to “hands-on” teach yourself Excel books.
In this post, we look at four ways to learn Excel. Ultimately the best way for you depends on how much you already know, how you personally learn best, and what you seek to achieve with Excel.
(One instructor to many students, fixed pace)
You will probably find yourself on a training course if your company or workplace has arranged the training for you. Going on a training course to learn Excel can have certain benefits and works well if you like to have material presented to you at a fixed pace in a linear way. If you like the instructor’s approach you may find yourself learning well from the class. The instructor can lead you through material and show you all manner of Excel’s capabilities, as well as answer any questions you have as you proceed. You’ll also get to interact with other students which can be good for networking.
Unfortunately a traditional classroom setting is not the best way of helping you build the day-to-day skills you need to use Excel effectively. Certainly you can learn a lot about principles and concepts in a classroom, but it’s much harder to master the procedural skills in a classroom. If you watch someone who is familiar with Excel, you will see them use mouse and keyboard shortcuts as they craft a spreadsheet just the way they want. Much like learning to touch type, if you want to use Excel effectively you need to have its commands at your fingertips.
(One instructor to one student, tailored pace)
Now, a big drawback of most traditional training courses is the inability to rewind or repeat. The instructor must follow some kind of schedule, which forces you as an individual learner to keep pace with the whole class. Contrast this with an “up-side-down” classroom such as the Khan Academy, where each student can learn at their own pace, and rewind or repeat each lesson as many times as they want. If you are interested in learning “stuff” and haven’t tried the Khan Academy, I recommend you give it a try. It’s totally free to use and (as of April 2011) offers more than 2,000 online videos spanning topics from statistics to finance to cosmology.
The benefits of online tutorials are that you can go at your own pace, repeat and rewind when you want, as many times as you want, and choose the time and days that most suit you. The internet has enabled some great online learning content for Excel. If you find yourself learning better in the morning, you can watch material in the morning. And if you find yourself preferring the evening, you can watch material in the evening. Or you might take a half-hour break during the work day to put your headphones on and follow an online lesson.
Many online Excel tutorials offer forums or comments sections where students can discuss problems online with other students and with the instructor. Sometimes there are downloadable spreadsheet examples to go with the lessons. The fast changing nature of the internet means you should look at the latest offerings and compare them to find one which suits your needs.
A potential drawback to online tutorials is that they don’t serve as good reference material. If you need to quickly remind yourself how to change a pivot table layout it’s probably faster to look it up in a book than trying to search for the exact time stamp in a video tutorial. And if you skim through a book’s pages you can visually explore the contents of the book very fast, in a way that video tutorials don’t allow you to do.
Two popular types of computer books are the “teach-yourself” manual and the reference “bible”. The “teach-yourself” type may be accompanied by online practice material. If you enjoy reading books, you can definitely learn a substantial amount by reading “teach-yourself” guides and of course you can follow your own pace. But you must remember to practise what you read or you will find yourself forgetting it soon.
Reference books are well suited to learning more about Excel once you have a grasp of the basics. Having physical books on your desk is great for reference. There are several well-respected Excel authors whose books receive strong reviews on online bookstores.
Check out my list of recommended Excel books in the Excel Bookstore.
(Exploratory learning, new idea feeds)
In the days before the internet took off, a good strategy for exploratory learning would be to head down to a public library and browse through its catalog looking for books on Excel. The equivalent today is to open up a browser and visit your favorite Excel blog.
There are many blogs to read from, and the advantage of blogs is that fresh material can be posted online far faster than in print. If you subscribe to a blog’s RSS feed you can get your regular “fix” of new Excel ideas delivered straight to your favorite RSS reader.
However if you want to do some focused learning it can be hard to navigate blog archives to find relevant learning material. Some of my favorite blogs for expanding my Excel horizons are Chandoo, Excel Hero and BaconBits. If you want a more comprehensive list of great Excel blogs head over to John Walkenbach’s spreadsheet page.
Browse through more articles from Launch Excel by clicking here. And let me know what you think about the different ways of learning Excel – do you have a favorite method that I haven’t covered?
If you’re interested in receiving updates about future articles from Launch Excel, take this chance to sign up for my RSS feed by clicking on the orange RSS icon to the right. You can find me on Twitter here. And please share this article with your colleagues and friends using the share buttons below.
Victor expertly teaches Microsoft Excel to people all over the world. He has millions of views of his popular Excel explainer videos on YouTube. These show time-saving shortcuts and real-world applications explained with easy-to-follow visuals.
Victor has over 20 years of experience using Excel as a professional for Big 4 Audit Firm Deloitte and two global tech companies. He knows firsthand that being more productive with Excel can lead to greater job satisfaction and career growth.
Discover the PROVEN Blueprint for transforming your Excel skills, supercharging your productivity, and standing out in your career! My course helps you to learn Excel VBA and save hours of time even if you have zero prior experience with programming.
Solve tricky Excel problems and take your work to the next level! Get customized solutions for your unique needs. Save time and gain insights with truly expert Excel solutions from only $97 per task.
Get a clear overview of your project progress using the Excel project timeline. Use it to communicate the big picture, track task progress, and stay on top of your project goals. Stay organized with our project timeline!
Our cheat sheets provide quick and easy reference to commonly used Excel VBA concepts and code snippets.
Unlock new levels of productivity and efficiency with our cheat sheets, and write VBA code like a pro in no time.
Are you looking to upskill and stay ahead of the curve? Excel is a powerful tool that keeps growing in demand. We round up the best online courses for learning Excel.
Are you looking to up your spreadsheet game? Excel is an invaluable tool that can help you stay organized and save time. From data analysis to budgets, Excel can do it all!
Today, having Excel skills is more critical than ever. Those who know how to use Excel are more likely to find higher-paying jobs. And get promoted faster.