Mastering Excel Formulas: IFERROR & XOR | Syed Raza | Skillshare

# Mastering Excel Formulas: IFERROR & XOR

#### Syed Raza, Web Developer | Entrepreneur-CEO www.claydesk.com

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

2:04
• Logical IFERROR and XOR formula

12:23

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

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

60

Students

--

Projects

• --
• Beginner
• Intermediate
• All Levels
• Beg/Int

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

#### Syed Raza

Web Developer | Entrepreneur-CEO www.claydesk.com

Why are 135,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

Report class