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:
Advanced Engineering Techniques in 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.
Macros and VBA Training Series
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.
Lookup Formulas Training
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?
On Demand Pivot Table and Dashboard Webinars
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.
ExcelJet Videos
ExcelJet offers Excel training videos to help you upgrade your skills. The videos cover a wide variety of Excel topics from formulas and pivot tables to conditional formatting, shortcuts, and more.
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.
Websites
Below are the websites I come back to over and over again for Excel tips (in no particular order):
MrExcel.com
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.
ExcelCampus
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.
Peltier Tech Blog
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”.
The Spreadsheet Guru
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.
Pearson Software Consulting
Chip Pearson’s site contains over 500 individual Excel topics ranging from Arrays to UserForms and everything in between.
Ron de Bruin Excel Automation
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.
Newton Excel Bach, not (just) an Excel Blog
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.
Learn VBA – A Tutorial for Beginners
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.
ExcelTemplate.net
ExcelTemplate.net has been creating and sharing professionally designed Excel templates since 2005. Their files have been downloaded by millions around the world for work, personal, and educational use. Best of all, every file on their website is free to download and use.