Excel Guru: The Only Excel Formulas Course You’ll Ever Need

Microsoft Excel: Master Excel Formulas by Solving 100s of Problems in Excel. Can Use Excel 2003 - Excel 2016 (Excel)

Created by: Jarrod Tanton
Founder XLEssentials.com / CEO ReAppDev, Inc.

What Will I Learn?

• Become an Excel formula master who is proficient in reading and writing even the most complex formulas in Excel.
• Understand the majority of Excel’s built in functions and how to use them to efficiently solve a wide range of problems with Excel.
• Creatively write formulas in Excel to address complex practical problems by combining Excel's functions together.
• Save time by learning Excel tips, tricks, and traps to look out for as I share advice that I’ve acquired from using Excel over the years.

Requirements

• Students will need to have access to Microsoft Excel. The course is taught in Excel 2010. For the best experience students should have Excel 2010 or later. However, many of the concepts taught in this course are related to the core functions in Excel, which have not changed much since Excel 2003. Therefore, if you only have access to Excel 2003, you will still be able to follow along and will get quite a bit of value from the course.

Target audience

• This course is for individuals who have a desire to be phenomenal at writing formulas and problem solving in Microsoft Excel. The people that will benefit from this course the most are recent or soon to be college grads, individuals working in analyst, consulting, management, or supervisory roles, individuals looking to gain a tangible skill on their resume, or individuals who currently use Excel in their daily job and would like to better understand how they can leverage Excel to help them with their work.
• This course is not for casual students who are looking to learn just the basics of Excel. Also, because this course focuses on how to process and transform data using Excel’s built-in functions in depth, it does not cover pivot tables or the visualization of data (charting). These topics are covered separately in their own course. If you already know how to use Excel’s reference functions, can write your own array formulas to aggregate data conditionally, and have plenty of experience working with strings, dates, and times, this course is probably not for you.
• As a bonus, this course has an entire module that is dedicated to covering the Excel basics needed to get newbies up to speed so that they can benefit from this course as well.