• Skip to primary navigation
  • Skip to main content
  • Skip to footer
EngineerExcel

EngineerExcel

FREE EBOOK
  • About
  • Course
  • Free Training
  • Resources
  • Login

Top Excel Resources

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

excel-campus-macros-vba-training

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

lookups-video-series-logo-257x266

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

dashboard_webinar_pq_pp

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

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:

ExcelOffTheGrid.com

The goal of Excel Off The Grid is to be a resource that will actually make a difference in your life by saving you time through better use of Excel.

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.

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.

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.

About Me: Charlie Young, P.E.

I’m a licensed professional engineer with a degree in Mechanical Engineering and over a decade of practical experience building engineering applications in Excel. My goal is to help you learn how to turn Excel into a powerful engineering tool.

If you’re interested in learning more, click the button below to receive an update whenever I have a new tip to share. I’ll also send you a copy of my free eBook “10 Smarter Ways to Use Excel for Engineering”.


Subscribe Now

Footer

SOCIAL

Keep up with EngineerExcel:
  • Email
  • RSS
  • YouTube
EngineerExcel

Free Course

Navigation

  • Home
  • About
  • Free Course
  • Excel Tips
  • Resources
  • Coupon
  • Login

Support

  • Support
  • Terms
  • Privacy

Copyright © 2021 EngineerExcel.com · Log in