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:
Engineers use Excel in unique ways, and my free video series will help you accelerate your learning curve in Excel so you can be more efficient, increase your accuracy, and solve challenging engineering problems. Ultimately, these skills will make you a better engineer and help you advance in your career.
In the video series, I tackle a complex engineering problem in Excel, and show you how to:
- Simplify cell formulas to make them easier to read and write
- Quickly convert units in Excel without any external tools
- Easily solve a complex system of equations through numerical iteration
- Prevent critical mistakes by using automation in your spreadsheet
If you are using Excel to perform engineering calculations, then this training will help you take those skills to the next level, so sign up 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.