Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
2 Videos (14m)
    • Introduction

      2:04
    • Logical IFERROR and XOR formula

      12:23

About This Class

The old 80/20 rule for software—that 80% of a program’s users use only 20% of a program’s features—doesn’t apply to Microsoft Excel. Instead, this program probably operates under what could be called the 95/5 rule: Ninety-five percent of Excel users use a mere 5% of the program’s power!

On the other hand, most people know that they could be getting more out of Excel if they could only get a leg up on building formulas and using functions. Unfortunately, this side of Excel appears complex and intimidating to the uninitiated, shrouded as it is in the mysteries of mathematics, finance, and impenetrable spreadsheet jargon.

Here's the good news!

I have designed this practical course to give you the ability to master the excel formulas in this series!

In this tutorial, you will be able to learn important functions such as:

  • Financial
  • Logical
  • Text
  • Lookup & Reference, and many more

About the Class:

We will take a look at two important formulas in this class:

1. IFERROR

2. XOR

Trap and handle errors using the IFERROR function. It basically returns a value you specify if a formula evaluates to an error; otherwise, returns the result of theformula. Use the IFERROR function to trap and handle errors in a formula.

The XOR returns a logical Exclusive Or of all arguments.

So, let's jump right in and see these formulas in action!

See you in class.

Happy learning!

Syed

4 of 4 students recommendSee All

Great class! I enjoyed it.
A precise class! Just to my liking. Thanks.

54

Students

--

Projects

Syed Raza

Web Developer | Entrepreneur-CEO www.claydesk.com

Why are 85,000+ students (and counting) enrolled in my online courses?

1) I teach with passion and purpose! Every course is delivered with my students in mind.

2) My courses will help you gain real world skills and knowledge and change your life today!

3) My dedication to the teaching profession and teaching online. Udemy has named me one of its top instructors.

? Try enrolling in a course with me and see for yourself! ?

_____________________________________...

See full profile