Explore

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

16.5 hours on-demand video

$ 18.99

Save Course

Go to Course

Brief Introduction

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

Description

This course is focused on transforming students into Excel Wizards to give them a distinct competitive advantage over their peers. It is centered on teaching students how to master the art and science of problem solving with formulas in Excel.

The course takes a unique approach that is rooted in solving real world problems. This gives students an apprenticeship experience as opposed to a traditional lecture approach. By the end of the course, students will have worked nearly 170 examples and will have learned how to leverage Excel to solve just about any problem they might face in practice. Students will cover just under 100 functions in the course and will be proficient in reading and writing even the most complex formulas in Excel.

The course is broken down into two modules. The first module provides an introduction to Excel. This module is intended to get everyone on the same page, so even those who have never used Excel can feel comfortable starting with this course.

The second module teaches students how to become formula masters and expert problem solvers with Excel. This module is broken down into seven sections that are mapped to functional areas, once again putting an emphasis on how Excel is used in the real world.

This course offers students:

Over 16 hours of valuable video instruction that is uniquely structured to share the lessons learned from over a decade of professional experience
Over 125 quiz questions strategically placed throughout the course to help test your understanding and reinforce what you’ve learned
A Practical Application Workbook and solution manual for each section
An Excel Wizard’s Guide to Critical Skills
A Comprehensive Data Aggregation Reference Sheet

This course is intended for individuals who have a desire to become phenomenal at writing formulas in Excel. This includes:

Recent or soon to be college graduates
Individuals who work in analyst, consulting, management, or supervisory roles
Individuals looking to gain a tangible skill on their resume
Individuals looking to gain a competitive advantage over their peers

Recent studies show it pays to know Excel. Get started today!

Requirements

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.

Recommended for you

Bond Valuation Mastery - Learn To Value Bonds From Scratch.

Become A PRO At Valuing One Of The Most Important Fixed Income Securities | Finance Fundamentals | Valuation Series Do this manually, and on Excel® and Google Sheets....

Save Course

Excel Pivot Tables Data Analysis Master Class

Excel at Excel Pivot Tables. Learn to create pivot-table and pivot-chart reports using Excel for data analysis. Greetings!      Nothing comes close....

Save Course

Google Sheets - The Comprehensive Masterclass

Learn Google Sheets in 2021! Solve Complex Data Analysis Problems. Become an Expert: Learn Pivot Tables, QUERY & more From data collection, automation, to proper data analysis and visualization....

Save Course