Free Excel Training Videos
There’s probably no better way to learn a new technique in Excel than by watching someone else do it, and then practicing yourself. The following free videos will help you get more out of Excel:
In this brand new limited-time video series, I’m going to show you how to gain advanced techniques for performing engineering calculations and analysis in Excel. The training is based on the exact proven process that I used to go from basic Excel skills to building advanced, award-winning engineering models in Excel.
The training starts with Video #1: 5 Simple Techniques to Take Your Engineering Spreadsheets to the Next Level. Click here to watch it now.
VBA, or Visual Basic for Applications, allows you to automate your spreadsheets and really unlock the full potential of Excel. My good friend Jon Acampora’s VBA Pro Course is probably the best Excel Macros and VBA training on the market today.
To help you get started with Macros and VBA, he’s put together a free 3-part series of training videos. Through the videos you’ll learn how to:
- Write your first macro
- Automate tasks in Excel to save time
- Create a Userform for a professional interface
Jon does a great job of clearly explaining how the Excel object model works. I know you’ll gain a lot of valuable knowledge from these free videos.
I rely on lookup formulas a lot for extracting engineering data from tables into calculations in Excel. For simple lookups I use VLOOKUP, but when things get complex (as they often do) I resort to the INDEX and MATCH functions. There are a lot of pitfalls with either of these methods, but this free video training series (also from Jon Acampora at ExcelCampus) will help you avoid some of them.
In Jon’s three-part video series he will teach you:
- The 5 Essentials to Getting Started with VLOOKUP
- How to Prevent & Handle Lookup Formula Errors
- How to Use INDEX & MATCH Instead of VLOOKUP, and Why?
If you’re using Pivot Tables and Dashboards to analyze data and communicate information in Excel, the Pivot Table and Dashboard webinars from MyOnlineTrainingHub will really improve your skills with these powerful Excel tools.
The training is delivered as multiple one-hour on demand webinars. You can sign up for all of them, or just the one that interests you the most.
The videos are designed to get you the information you need quickly so that you can get back to building awesome spreadsheets as quickly as possible.
Below are the websites I come back to over and over again for Excel tips (in no particular order):
MrExcel.com is probably best known on the internet for its active Excel forum. However the site owner, Bill Jelen, is also an author of over 40 books on Excel and offers live Excel training.
The ExcelCampus blog by Jon Acampora is packed full of great information that you can learn from to become a better Excel user. He also offers two Excel courses: The VBA Pro Course and Ultimate Lookup Formulas.
Jon Peltier’s blog is a wealth of information focusing on Excel charting for power users. He has also graciously offered his services to humanity by using Excel to address the ongoing “human-velociraptor conflict”.
Chris Newman’s site is geared toward financial analysts, but many of the tips he shares can be applied by engineers working with data of any kind. He writes many articles about using VBA and his site also features an extensive VBA code vault, where you can find many of the VBA scripts he has written.
Chip Pearson’s site contains over 500 individual Excel topics ranging from Arrays to UserForms and everything in between.
Ron’s site contains VBA tips and add-ins for Excel. He also links to the articles he writes for MSDN (Microsoft Developers Network). I’ve applied countless tips from Ron’s site over the years, so check it out.
Doug Jenkins is the author of this site, described as “an Excel blog for engineers and scientists, and an engineering and science blog for Excel users.” He always has useful and interesting content related to using Microsoft Excel for engineering, so check it out.
Steve Rynearson at AutomateExcel.com has created an amazing, fully interactive online VBA tutorial. The step-by-step guide will lead you through the fundamentals of VBA up through more complex topics. And best of all, you can get started absolutely free. Head here to check it out and get started learning VBA.