excel resources

Looking to freshen up in Microsoft Excel or learn it from scratch? Well, then you are in the right place. As we have previously noted, knowledge of Excel translates to higher salaries and there are many challenging yet high paying jobs that require heavy usage of Excel. Learning Excel is a huge business on the internet and we spent weeks sifting though the chaff to bring you the very best Excel resources from guru blog sites and tutorials to templates, add-ins, and online courses. It’s a doosey so make sure you have a strong cup of coffee before proceeding!

[Editor's Note: Throughout this piece we have tagged resources as PC or Mac and the edition of the software. For basic Excel use the standard functions are essentially the same. The major differences between Mac and PC are keyboard shortcuts. Thus for learning resources Mac users can still learn a lot from "PC" resources. Excel templates seem to have the most compatibility between versions but there may be minor issues between some versions. However, PC add-ins and apps will not work on Macs unless your Mac is also running windows.]

Gurus

There are a handful of experts out there that are so good at Excel that they are recognized by Microsoft with the Most Valued Professional Certification. There are only 94 of these individuals worldwide. Many of them are doing some very advanced data analysis and programming in Excel, so we’ve highlighted ones with their own websites/blogs that are useful for begginners and intermediates.

Excel tutorials Chandoo

Excel guru, Chandoo, runs Excel tutorial site Chandoo.org.

Beginners

  1. Purna “Chandoo” Duggirala runs Chandoo.org, an Excel tutorial site. It has a ton of free information for all levels of excel users, including a lot of great dashboards. Those who want to take it up a notch can purchase templates or enroll in a paid course.
  2. Bill “Mr. Excel” Jelen is the man behind MrExcel.com. Similar to Chandoo the Mr. Excel site has a lot of free how-to material as well as DVD tutorials for purchase. He runs an Excel book publishing company and co-publishes books on Excel with many of the other Excel MVP’s. He also has a podcast blog with excel tips that gets updated every month.

Intermediate & Up

  1. John Walkenbach runs the The Spreadsheet Page and has written many books on Excel. His is a good starting point for intermediate users of Excel.
  2. Debra Dalgleish is an MVP, author of three books on PivotTables, and operator of Contextures. It has some Excel tips for beginners but is another good blog for intermediate users of Excel.
  3. Charley Kyd is another prolific Excel guru. He runs the Excel User, a good starting point for intermediate excel users especially those interested in dashboards. The site is visually crowded with content, some of which is for sale, so make sure to go straight to the “Excel Help” section.

**For more information about these gurus check out our Learn Excel from Excel Experts article. For more information about gurus who specialized in advanced Excel and VBA check or summary of 40+ advanced Excel resources.

Knowledge of Microsoft Excel is statistically proven to lead to higher salaries.

Free Excel Online Tutorials

There are a ton of online training and tutorials available on the web. A google search will return a whopping 17.5 million results and a Youtube search returns an impressive 146,000 videos. However, many of the websites are spammy content farms trying to bank on advertising and many of the good Youtube videos are hard to find.

Excel Exposure Excel Tutorials

Excel Exposure is an Excel course that is used at University of Reddit.

Excel Tutorial Sites

  1. University of Reddit Excel 2010 (powered by Excel Exposure) is a good no frills Excel course. PC, 2010.
  2. Another no frills options is Excel Central which seems to be a pay site but stil has a fair amount of free videos, ebooks, and excel file downloads. PC, 2007/10.
  3. Many EDU sites have their own excel tutorials. There is a lot of either specialty content (for physics or business) and outdated content. We found some excel wiki’s from 1995! However, Duke’s Fuqua School of Business Excel wiki is top notch! PC, Multiple Editions.
  4. The Barnard Library site is another EDU site with good tutorial content. Mac 2011, PC 2010.
  5. ExcelTutorial.com, PC Multiple Editions.

General How-To Sites With Excel Good Content

  1. GCFLearnfree.org, PC, Multiple Editions.
  2. Free-Training-Tutorials.com. PC, 2007.
  3. Howcast’s How to Use Microsoft Excel. PC, 2010.

Youtube Channels

  1. The Mr. Excel Youtube Channel has an extensive series of Excel video content worth checking out. PC, 2007/10
Excel Is Fun Youtube Channel Excel Tutorials

The “Excel Is Fun” Youtube channel was created by Bill Jelen and Michael Girvin.

  1. Excel Is Fun Youtube Channel. PC, 2010.
  2. Learn Excel Functions Youtube Channel. PC, 2013.

From Microsoft

  1. Training videos for Excel from Microsoft, PC, 2010.
  2. Excel Skill Builder from Microsoft. PC, 2010.
Microsoft Excel 2010 Skill Builder excel tutorials

Microsoft has a developed the “skill builder” series to train Excel newbies.

  1. Microsoft’s Getting Started with Excel for Mac 2011. Mac, 2011.
  2. Basic tasks in the Excel Web App. Office 365.

**For even more free tutorials check out this of summary of 40 free Excel tutorials.

There are many challenging and high paying jobs that require daily use of Microsoft Excel.

Excel Reference, Tips, & Recommendations

Similar to tutorials there is a bounty of sites offering excel “how-to” content, so much to the point that it can be overwhelming. Here are a few of our favorites.

Excel-Easy Excel Tutorials

Excel Easy has quality no frills how-to content.

Excel Reference Guides

  1. Excel Function Dictionary. Mac/PC, Multiple Editions.
  2. Excel Easy is a simple excel reference worth checking out. PC, Multiple Editions
  3. Exceljet is the goto place to learn about keyboard shortcuts. Mac/PC, Multiple Editions.

Excel Tips & Recommendations

  1. Allan Wyatts Excel Tips (subsite of Tips.net). PC, 2007.
  2. ExcelTip.com. PC, 2007.
  3. Work Faster in Excel” from TechHive.
  4. “5 Excel Nightmares and How To Fix Them” from PC World.
  5. “Use Microsoft Excel for Everything from PC World.
  6. The Excel Tip of the Month blog is from Isaac Gottlieb, professor and author. It provides many great examples of Excel in action. As of September 2012 this has moved to the Temple Fox School of Business website, PC/Mac, Multiple Editions.
Excel Tips Excel Tutorial Isaac Gottlieb Excel Tip of the Month

The “Excel Tip of the Month” website from Professor Isaac Gottlieb was a strong following.

  1. Practical applications of Excel from AccountingWEB. PC, Multiple Editions.

From Microsoft

  1. Microsoft’s Excel Blog. PC/Mac, Multiple Editions.
  2. Excel Support from Microsoft. PC, Multiple Editions.
  3. Excel for Mac Support. Mac, Multiple Editions.
  4. Excel Keyboard Shortcuts from Microsoft. PC, 2013.
  5. Common Functions from Microsoft. PC, Multiple Editions.

Office 365

  1. Office 365 Infographic. No how-to but contains detailed features information.
  2. “A Look At Microsoft Office 365: Excel” review from TechNorms.

Excel Forums

  1. Mr. Excel Forum
  2. PC Review Excel Forum
  3. OzGrids Forum
Excel Forum

Forums are a great place to get quick answers to one-off questions.

  1. ExcelForum.com
  2. Get on the Excel Listserve
  3. Excel Google Group
  4. AllExperts has 25 Excel experts waiting to answer your questions, including 3 Excel MVP’s and the author of Excel for Dummies.

**For even more free tutorials check out this summary of 40 free Excel tutorials.

There are a bounty of excel reference sites online and we sifted through the chaff to find the best.

Best Excel Templates

A lot of the grunt work in Excel is coming up with a template that can be reused over and over again. Thankfully, there are many fancy looking and highly function excel templates available online for free. On the high end of templates are dashboards which take your data and push them into cool looking charts and gauges that help measure progress.

Microsoft Investment Portfolio Template

Templates are a great ways to take the grunt work out of Excel spreadsheets.

Personal Finance

  1. Personal Budget. PC, 2003.
  2. Home Loan Comparison. PC, 2013.
  3. Mutual Fund Tracker. PC, 2003.
  4. Investment Portfolio. PC, 2013
  5. Portfolio Slicer – a special custom portfoliok workbook with special scripts that constantly updates stock prices. PC, 2010.

General Business

  1. Simple Invoice. PC, 2007.
  2. Balance Sheet. PC 2013.
  3. Regional Sales Chart. PC, 2013.
  4. Project Planner. PC, 2007.
  5. Key Performance Indicator dashboard from Chandoo. PC, 2007.

Presentation

  1. Calendar Creator. PC, 2007.
  2. Flow Charts. PC, 2013.

Specialty Templates

  1. Marketing templates from Demand Centric. PC, 2010.
DemandCentric Marketing Excel Templates

DemandCentric has some excellent free marketing templates.

  1. Project Management dashboards from Chandoo. PC, 2007.
  2. Google Ranking Tracker. PC, 2010.

More Template Resources

  1. Templates for Mac from Microsoft. Mac, 2011.
  2. Even more templates are available from the Microsoft Template Store, Vertex42, Spreadsheet Zone, Mr. Dashboard, and Dashboard Spy.

**For even more free Excel templates check out this summary of 50+ free Excel templates.

[Editors Note: While templates are tagged for certain versions. Older templates work in the most current versions of Excel. Newer templates may not work as well in older versions of Excel. However, some 2013 templates were also spot checked in Mac 2011 and seem to work fine.]

Templates take the grunt work out of Excel.

Best Excel Add-ins

Excel out of the box is great, but there are many plug-ins that enhance the fuctionality of Excel and allow you to do more advanced data analysis and presentation.

ModelSheet Excel Model Creator

Add-Ins extend the functionality of the standard Excel software.

Test Your Excel Skills

Powered by Interact

Organization

  1. Bookmark your favorite workbooks. PC, Multiple Editions.
  2. Add-in Manager. PC, Multiple Editions.
  3. Simple and easy emailing from Excel with RDBMail. (Mac version available), 2007 and later editions.

Data Analysis

  1. One of the classic add-ins for Excel is the Analysis Toolpak. Mac/PC, Multiple Editions.
  2. The PowerPivot turns excel into a business intelligence tool. PC, 2010/13.
  3. Data Explorer is the newest data analysis tool and the preview is now available for download. PC, 2013.
  4. Excel Model Creator. PC, 2013.
  5. Mr. Excel’s Easy-XL data analysis and manipulation tool kit  ($89, free trial available). PC, 2010.

Presentation

  1. Make some cool visual maps with the Heat Map add-in. PC, 2013.
Microsoft Heat Map Excel Add-in

The Heat Map Excel Add-in allows users to visual data on a map.

  1. Add a gauge display to your dashboard. PC, 2013.
  2. Display data bubbles with the Bubbles add-in. PC, 2013.
  3. Enter dates quicker with the Calendar entry add-in. PC, 2013.
  4. Get Federal Reserve data with the FRED add-in. PC/Mac, Multiple Editions.

Utilities & Productivity Tools

Excel 2010 with ASAP Utilities toolbar

Some add-ins add new features to the toolbar also known as the Ribbon.

  1. AbleBits Utility Pack ($99, free trial available). PC, Multiple Editions.
  2. Macabus Productivity Tools ($9.95, freeware version available). PC, Multiple Editions.
  3. ASAP Utilities ($49, free trial available). PC, Multiple Editions.
  4. Free productivity tools from Tyrant Ventures. PC, 2013.
  5. Power Pack for Mac 2011.

Digital Marketing

  1. Show context related tweets with ExTweet. PC, 2013.
  2. Google Analytics add-in, PC, 2013.
  3. SEO Gadget has add-ins for the Adwords API, Mozscape API, and Link Categorization. PC, Multiple Editions.
  4. More SEO Tools for Excel. PC, Multiple Editions.

Personal

  1. Checkbook AssistantPC, Multiple Editions.
  2. Flash Card Generator. PC, Multiple Editions.

Other

  1. Unit ConverterPC, 2013.
  2. Merriam Webster DictionaryPC, 2013.
  3. Even more add-ins are available from the Microsfot App Store, Add-Ins.com ($), and OzGrids ($).

**For even more add-ins, check this summary of 50+ Excel add-ins.

Add-ins can dramatically enhance the functionality of Excel.

Best Excel Apps

Apps are slightly different from add-ins in that they are more about integration with Excel and opposed to native plug-ins that become an extension of the product.

cloudon excel ipad

The CloudOn iOS app allows you to edit Excel workbooks from your iPad or iPhone.

Integration Apps

  1. Microsoft Excel Viewer allows you to view files without Excel loaded to your computer. PC, 2007.
  2. For iPad integration check out the following: Numbers ($9.99), Google Drive , and the Dropbox/CloudOn combo. External iOS Apps.
  3. Convert PDF’s to numeric data to Excel workbooks with Able2Extrac ($97, free trial available). PC/Mac Multiple Editions.
  4. Convert Excel to PDF without losing your hyperlinks with the Cogniview PDF Converter ($99.95, free trial available). PC, Multiple Editions.

Business Apps

  1. Excel Invoice Manager (Starts at $39). PC, Multiple Editions.
  2. Excel Tax Assistant (Personal Version $15.95). PC, Multiple Editions.

Web Apps

  1. Convert Excel file to an online relational database with Team Desk (Starts at $49/month).
  2. Build an online map with Excel data using Topoly ($20, lite version free).
  3. Create a Social Media Analytics Dashboard with Simply Measured (Enterprise version starts at $500/month, personal reports free).
Simply Measured Excel spreadsheet

Simply Measured takes your social media profile data and pushes it into sleek looking Excel templates

Help Me! Apps

  1. Watch video tutorials with the GCFLearnfree.org app for iOS and Android. PC, 2010.
  2. Always forgetting keyboard shortcuts? Use Keyrocket ($29, free trial available) to get shortcut suggestions based on your actions. PC, Multiple Editions.
  3. Recover lost passwords with Password Lastic ($29.95). PC, Multiple Editions.
  4. Compare workbooks and find subtle differences with DiffEngineX (Starts at $55). PC, Multiple Editions.

Best Excel Books

Excel is a huge business, so it’s no surprise that there a lot of books on the subject in circulation. Excel MVP’s, Bill Jelen and John Walkenbach have written many of the books on this list. In fact, Bill Jelen has his own Excel book publishing company and has worked with many Excel experts on creating various excel specialty guides.

Excel 2013 Bible Book John Walkenbach

The Excel Bible by Microsoft Excel MVP is the ultimate reference guide book for Excel.

Excel Reference Books

  1. Excel 2013 Bible ($27.77) by John Walkenbach (2010 and 2007 also available)
  2. Excel 2013 Charts & Graphs ($30.14) by Bill Jelen (2010 and 2007 also available)
  3. Excel Dashboards & Reports ($24.08) by Michael Alexander & Bill Jelen (2013 preorder)
  4. Excel 2013 Tips & Tricks ($19.89) by John Walkenbach (2010 and 2007 also available)
  5. Excel 2013 Pivot Table Data Crunching ($22.58) by Michael Alexander & Bill Jelen 2010 and 2007 also available)
  6. Slaying Excel Dragons ($20.06) by Michael Girvin & Bill Jelen, PC, 2010
  7. Office 2011 for Mac: The Missing Manual ($19.52) by Chris Grover (2008 edition)

Speciality Books

Excel For Chemists book E. Joseph Billo

There are many Excel books for specialty subjects.

  1. Modeling in Excel for Analysts & MBA’s’s ($69.15) by Isaac Gottlieb
  2. Excel University ($26.96) by Jeff Lenning (Accounting/Finance focus) PC, Multiple Editions
  3. Business Analysis: Microsoft Excel 2010 ($25.97) by Conrad Carlberg
  4. Statistical Analysis: Microsoft Excel 2010 ($23.88) by Conrad Carlberg
  5. Excel for Chemists ($43.98) by E. Joseph Billo, PC, Multiple Editions
  6. Excel for Scientists & Engineers ($50.67) by E. Joseph Billo, PC, Multiple Editions
  7. For even more books, check out the Amazon Best Seller list for Excel. Mac users should conduct a separate Amazon search for Excel for Mac.
If you prefer to learn via books, there are many great books on the subject of Excel.

Paid Excel Training

Theres no question there is a ton of free stuff out there to help you learn excel, but do you have what it takes to do all the leg work and learn it all on your own? If you don’t and prefer to have all of your excel training organized and served up to you in a neat looking package than you will be happy to know there are some solid paid courses that can give you exactly that.

Excel With Business Online Course

Excel With Business is a high quality online course with over 100 hours of content.

Online Courses

  1. Our personal favorite is Excel With Business ($99 with special discount only available to Skilledup readers!). It is the “Cadillac” of online Excel courses. For starters, it uses adaptive testing to find out your Excel IQ and comes up with a custom curriculum tailored to your exact needs! It includes 100 hours of video, audio, and PDF content for all types of learners and has an extensive series of excel exercises that are embedded into Excel spreadsheets to help you enforce what you need to learn. It also covers Mac and PC versions of Excel starting from Excel 2003. Excel With Business can take someone with zero knowledge of Excel up to the level required for an Investment Banker. Check out our in-depth review for more details. Mac/PC, Multiple Editions.
  2. For someone who needs to know just the basics, check out Vodeclic (Starts at ($9.90/month, free trial available). It has about 20 hours of content which should give a good foundation. PC,2010/13.
  3. Udemy’s Excel 2010 Beginner and Advanced Excel courses ($99/course) are the courses that put Udemy on the map in the eLearning world. Over 60 thousand people have enrolled in these two classes. For those looking to get into VB Udemy also has a Visual Basic For Excel course. PC, 2010.
  4. Chandoo, the excel guru, also runs his own Excel School (Starts at $97) with focuses on dashboards, financial modeling, and project management. PC, Multiple Editions.
  5. Lynda.com (Starts at $25/month) the mother of online learning offers almost 50 different full length training courses as part of its monthly subscribption program. Mac/PC, Multiple Editions.

Courses Embedded into Excel Workbook

  1. Excel Everest ($39.99, free trial available) is a cool option where the whole course takes place in an Excel spreadsheet. Mac/PC, Multiple Editions.
  2. ExcelNow! ($49) is another neat option that embedded in Excel as a macro and installs a special tab for its learning content. PC, Multiple Editions.

**For more details about these online Excel courses check out our 8 Places To Learn Excel.

A course in a Excel is great for those prefer a curriculum based learning style.

Best Places to Test Your Excel Knowledge

So you mastered Excel or at least you think you did! The missing link in learning a new subject online is being able to prove your mastery of the subject both to yourself and others. The following are places where you can test your skills.

Certiport Microsoft Excel Specialist Certification

The official Microsoft Excel Specialist certification is offered exclusively through Certiport

The Official Microsoft Certification

  1. Certiport is the official test provider to get a Microsoft Excel Specialist certification ($120) from Microsoft.
  2. This test is not just limited to adults. In fact there is a student Excel Championship that was won by a 15 year old girl in 2011.

Just For Freelancers

  1. Plan on doing some freelance Excel work? Take a short ExpertRating test at Elance. Similar tests are available at oDesk, Guru, and Freelancer. (Free at Elance/Odesk, $5 at Guru/Freelancer)

Test & Share

  1. Smarterer is a new skill testing platform where you can take skills tests in different areas and share the results via email or social media. The test mechanism uses adaptive test taking techniques that can accurately assess skill levels within minutes. It also utilizes a huge bank of crowdsourced questions which prevents cheating.

Do It Yourself

  1. Excel certifications are not very popular nor are they highly valued among employers. If Excel is required for a job, it is highly likely your prospective employer will use a platform like Prove-it or EmployTest to test you when you least expect it, so your best bet is to know your Excel spreadsheet functions. A good way to do that is start making spreadsheets on your own. While you are doing that you can also create an online portfolio that you can show to prospective employers.
The best way to prove yourself in Excel is to setup a portfolio of Excel workbooks that demonstrate your knowledge of the software.

Excel Fun

While Excel is primarily a business and analysis tool, there are actually people out there that are having fun in Excel besides data analysis geeks. There are some extremely creative people that have made games, animations, and art.

Excel Art  Fun Music Video

Believe it or not, there are artists practicing their craft with Excel.

  1. ExcelGames.com has both educational (including a few Excel training games) and for fun games.
  2. Complex RPG in Excel
  3. More games in Excel including classics like Pac-Man and Super Mario!
  4. Crazy Illustration in Excel
  5. More Excel Art
  6. Excel Music Video
  7. The History of Microsoft Excel (not necessarily “fun” content but nevertheless an interesting story!)
If you found this list overwhelming than consider taking the Excel With Business online course. It organizes and presents exactly what you need to know, when you need to know it.

Happy Hunting!

For all you self-learners out there we hope you enjoyed our list. If you did please share with your friends. This list is a work-in-progress so please bookmark us and come back to visit every now again to see the latest and greatest developments with Microsoft Excel. For those who found this list overwhelming but still want to learn Excel, we suggest you check out our review for Excel With Business. They really do a great job organizing and presenting everything you need to know to land a job that requires using Excel on a daily basis. Whether you plan to go at it alone with the resources above or with an online course, we wish you the best of luck learning Excel!