Contextures

Debra's Top Excel Picks

Here are my top picks for Excel courses, add-ins, books, and Excel tools. See how to raise yuor skills to expert level, and get tools that will save you time.

For Excel products that I created, go to the Contextures Products page.

Excel Courses

You can learn Excel on your own, by reading, watching YouTube videos, and experimenting with your own Excel workbooks. That can take a long time though, and you might not know which topics are important, or in which order it's best to learn things.

If you want to learn quickly and efficiently, check out these Excel courses that I recommend. Led by Excel experts, this list has training for different skill levels. There are courses for absolute beginners in Excel, and courses that take you to an intermediate or advanced level. There are also courses that focus on Excel's Power BI tools, or other special features.

General Excel Skills

Beginner: Mynda Treacy's Excel Skills course covers all the basics in Excel, and will get you up and running quickly.

Intermediate: After you've mastered the basics in Excel, enroll in Mynda Treacy's Excel Expert course. The lessons in this course will take you from Intermediate level, to Expert skills.

Special Topics

Pivot Tables: John Michaloudis leads the Xtreme Pivot Table Course -- with 200+ video tutorials, it covers everthing you need to know about pivot tables, and more!

Dashboards: Learn new skills that could help you advance at work. Mynda Treacy leads a highly-rated Excel Dashboard Course, and registration opens a few times each year. Sign up to be notified, the next time the course is available.

Error Checking: In his new course, Ken Puls shows how to build an error checking system in your workbooks. Be confident that everything is calculating correctly, even if you haven't looked at the workbook in months! See how to create an error checking section on each worksheet, and a global check point for the entire workbook. The system even checks the pivot tables, to see if they've been updated -- that can prevent serious problems! Follow the course online, or download to watch offline too.

Macros: Learn how to automate Excel, and save time! Sign up for the new one-hour free Macros & VBA Webinar from John Michaloudis. See how to record a macro, and set up a button to run it. Learn how to save and share your macros. Offered a few times each year, so sign up to be notified when the course opens.

Macros for Beginners: Allen Wyatt, from the Excel Tips website, has 4 free videos that give you a basic introduction to macros, and show how they can help you work more efficiently. Allen's full course is open a few times each year.

Power BI Courses

Power Query: Expand your Excel skills -- learn Power Query at your own pace, in this online course from experts Ken Puls and Miguel Escobar. The course starts with the Power Query basics, and gradually builds up to advanced techniques. There are 15 modules, broken into 55 videos (over 12 hours of content). See all the course details and sign up now.

power query academy

Excel Add-ins and Tools

Charts - Create complex charts easily, with Jon Peltier's Chart Utilities.

Programming - To save time while programming in Excel, use the AET VBE Tools from Andrew Engwirds. It has tools to compare code between different procedures, copy code between projects, insert code snippers, add or delete line numbers, and much more.

Speed: Improve workbook speed and performance with the help of FastExcel, by Charles Williams..

Excel Books

For more suggestions, see the Excel Books page

More Links

How to Install an Add-in

Sheet Navigator Add-in

Tools for Managing Workbooks

Don't Miss Our Excel Tips

Don't miss my latest Excel tips and videos! Click OK, to get my weekly newsletter with Excel tips, and links to other Excel news and resources.

Get weekly Excel tips from Debra

Debra's Top Excel Picks

 

Last updated: June 16, 2021 11:47 AM
Contextures RSS Feed