Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
16 Hour(s) 18 Minute(s)
Language
English
Taught by
Jarrod Tanton
Rating
Course Overview
Microsoft Excel: Master Excel Formulas by Solving 100s of Problems in Excel. Can Use Excel 2003 - Excel 2016 (Excel)
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!
Course Content
- 10 section(s)
- 181 lecture(s)
- Section 1 Module 1: Introduction to Excel
- Section 2 1.1 The What, Why, and How of Excel
- Section 3 1.2 Excel Components and User Interface
- Section 4 1.3 Introduction to Formulas and Functions
- Section 5 1.4 Overview of Cell References
- Section 6 Module 2: Process and Transform Data
- Section 7 2.1 Performing Data Aggregation
- Section 8 2.2 Performing Logical Operations
- Section 9 2.3 Mastering Lookups and References
- Section 10 2.4 Working with Informationals
What You’ll 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.
Skills covered in this course
Reviews
-
SSahadev
very interesting topic & power full
-
VVijay Singh
Tutors teaching style is lucid. Highly Recommended.
-
AAnurag Chumble
Course is very good. I think this is the best course on Excel & would recommend this course to others as well.
-
MMarcia Healy
Loved this course! I had never worked with array formulas and knowing these exist was brilliant. Need so much more practice with using them but great to be aware of them and their power. I found this course really interesting and knowledge gained will be highly beneficial.
