Advanced Excel Formulas Course

Don't learn Excel formulas by trial and error. This course teaches you functions that are going to give you the biggest efficiency gains at work. Covering the fundamentals for each function, and less obvious uses for them. It's these more advanced techniques that will really set you apart from the crowd. 
M.Treacy ·September 21, 2020


Course Details

Course Overview 

Mastering Excel formulas can take years by trial and error, picking up tips from colleagues or help you might find on the web. It’s a slow process with inconsistent results.

I’ve designed this course to get you quickly up to speed with the functions that are going to give you the biggest efficiency gains. Many of the functions are considered advanced, but when you’ve finished the course, you’ll know like I do, that everything is easy once you know how.

I’ve broken the course into logical groups of topics with real world examples taught in short videos (on average 7 minutes long).

I cover the fundamentals for each function as well as some less obvious uses for them. It’s these more advanced techniques that will really set you apart from the crowd.

Course Syllabus – 5 hours

Advanced Excel Formula Course - Conditional FunctionsConditional Function – Including IF, Nested IFs, IF(OR, IF(AND, IFS, SWITCH, SUMIF/S, AVERAGEIF/IS, COUNTIF/IFS, MINIFS and MAXIFS.
Advanced Excel Formula Course - Lookup FunctionsLookup Functions – Including VLOOKUP, HLOOKUP, MATCH, INDEX, COLUMN/S, ROW/S, OFFSET, INDIRECT and CHOOSE.
Advanced Excel Formula Course - Formula ErrorsFormula Errors – Debugging and troubleshooting formula errors, and handling errors with IFERROR.
Advanced Excel Formula Course - Text FunctionsText Functions – Including LEFT, RIGHT, MID, SEARCH, FIND, LEN, SUBSTITUTE, REPLACE, UPPER, LOWER, PROPER, TRIM, CLEAN, CHAR, CODE, UNICHAR, TEXT and TEXTJOIN.
Advanced Excel Formula Course - Math FunctionsMath Functions – Including SUBTOTAL, AGGREGATE and SUMPRODUCT.
Advanced Excel Formula Course - Array FormulasArray Formulas – Including an introduction to arrays, single and multi-cell array formulas, array constants, operations, Boolean values and coercion.
Advanced Excel Formula Course - Dynamic ArraysDynamic Arrays (Office 365 Only) – Including UNIQUE, SORT, SORTBY, FILTER, RANDARRAY, SEQUENCE and SINGLE.
Advanced Excel Formula Course - Named RangesNamed Ranges – Including creating and managing names, named constants, named formulas, dynamic named ranges and relative named ranges.
Advanced Excel Formula Course - Practice Questions – Solidify your understanding by completing the practice questions after each lesson.
Excel Table course certificate of completionAnd when you’re finished we’ll send you a Certificate of Completion to add to your résumé.



Who Is Teaching The Course

M.Treacy, a Microsoft Excel MVP.

I have been working with Excel since 1995 and teaching since 2010 (not including teaching many colleagues over the years), and I’m excited to be able to share what I have learned with you.

Back when I started using Excel I was lucky, in that you weren’t expected to know how to use it! As you’d know, that’s not the case these days.

Once you’ve completed the course and practiced what you learn you’ll be able to confidently tackle difficult formula challenges and create robust formulas that have your colleagues in awe.

Prerequisite

  • This course is for every Excel user who needs to expand their function and formula knowledge, whether it be for efficiency gains or improved employment opportunities.
  • Requires Excel 2007 or later. The course was filmed in Excel 2019/Office 365. Some functions covered in the course are only available in the latest versions of Excel.

10% off

Be The First

to Know

For Your next purchase when sign up.

Great News ?

  • This Discount Offer is exclusively available only to clients coming from Pro-education Academy website.

100 % Guarantee

Notes

  1. Videos will be available for download after the 30 day Money Back Guarantee period ends. You can watch the videos online in the meantime.
  2. Membership and access to the training materials is for one person only. Logons are not to be used by multiple people.
  3. Downloaded videos are to be used only by the registered member, they are not to be transferred/shared amongst other people.
  4. You can request a refund provided that no more than 30% of the course videos have been watched.

Choose Your Membership Level

Currency

cart images

Advanced Excel Formulas Online

$69.00

12 Months Online


Online Only Access To Course


Advanced Excel Formulas Course Videos 5hrs 4mins


One Payment for 12 Months Access


Unlimited 24/7 access


Pause, rewind, replay


Download Workbooks and Practice Data


30 Day Money Back Guarantee

Notes

  • Videos will be available for download after the 30 day Money Back Guarantee period ends. You can watch the videos online in the meantime.
  • Membership and access to the training materials is for one person only. Logons are not to be used by multiple people.
  • Downloaded videos are to be used only by the registered member, they are not to be transferred/shared amongst other people.
  • You can request a refund provided that no more than 30% of the course videos have been watched.

 

 

 

cart images

Advanced Excel Formulas Online + Download

$138.00

12 Months Online + Download


Online Access + Download & Keep Course Videos


Advanced Excel Formulas Course Videos 5hrs 4mins


One Payment for 12 Months Access


Unlimited 24/7 access


Pause, rewind, replay


Download Workbooks and Practice Data


30 Day Money Back Guarantee

Notes

  • Videos will be available for download after the 30 day Money Back Guarantee period ends. You can watch the videos online in the meantime.
  • Membership and access to the training materials is for one person only. Logons are not to be used by multiple people.
  • Downloaded videos are to be used only by the registered member, they are not to be transferred/shared amongst other people.
  • You can request a refund provided that no more than 30% of the course videos have been watched.

Our Business Excel Course Collection

                Why Not Discover, More Courses Below! 

Excel 
Charts
Formulas
PivotTables 
Online Training
Dashboard
 Shortcuts 
 VBA
01 / 05

PROFESSIONAL TRAINING

Course Delivery – Live online sessions
Course Duration – 8 Weeks (Three hours every weekend)
Why Learn with Us?
Interactive Learning: You’ll learn with a team of ambitious professionals.
Lifetime Access: It will allow you to revisit the course every time you need it.
Certification: Completion Certificate provided to back your learnings.
IIBA Certified Trainer: You’ll learn from certified industry experts.

So whatever job you are in, let us hold your hand and show you our innovative approach to success using one of our courses. You won’t find a more committed team.
Studying a Business Analyst Course, you can rely on our skillful team of Consultants to build your Business Analyst career even with no experience. Taking this course you’ll find only the most cutting-edge classes designed by Industry Experts. The instructors you’ll meet know SDLC, AGILE and HYBRID project methodologies inside out. Setting you for the highest level of success as a Business Analyst.
These courses are aligned to IIBA and designed to provide you with the core and job ready Business Analysis experience and certification so that you are set on the right growth track in Australia and globe.

02 / 05
Lara Madrigal
DESIGNER

Lara has over 10 years’ experience in the design industry. During this time, she has developed skills across many areas including branding, illustration, UI design, print and web design. She loves to be challenged and to enhance her skillset.

“Being a member of such a talented team is constantly inspiring. We each bring our passion to the studio to make our company a very special creative hive.”
03 / 05
Deborah Barbosa
BRAND STRATEGIST

Deborah describes brand strategy as her perfect blend of critical thinking and collaborative research, one that encourages her natural love of questions and genuine interest in people.

“We are fortunate enough to get to work with many internationally recognised brands, on interesting projects, which makes working at our company an exciting place to be.”
04 / 05
Martijn Dragonjer
PARTNER

Martijn joined the team in early 2015, after ten years working in the film industry. With a strong background for sales and marketing, Will was excited to bring a new perspective to the team.

“There is a constant buzz here, everyone is driven and focused on producing the best work possible for clients. It is a very rewarding place to work with fantastic clients .”
05 / 05
Dominik Doudny
DEVELOPER

Dominik has a passion for developing sites with clean, beautiful code. Dominik’s love for full-stack web development makes him a great asset that can take on back-end code and front-end UI needs if necessary.

“What makes a good company enjoyable? Working with enthusiastic members of well-structured teams of engaging characters.”
previous arrownext arrow
Slider

Still Not too Sure ?

No problem at all, you can book an appointment to speak to one of our subject experts, please, click in Get Support button below.

About Instructor

M.Treacy

4 Courses

+181 enrolled
Open Registration
Skip to content