Logic Theory and If Functions in Microsoft Excel

Instructor:  Jed Guinto
Course Dates: Open-ended
Enrollment Dates: Enroll Anytime
Who can Enroll: Anyone
Course Language: English
Price:  FREE

About the Course

Logic theory is a whole other subject onto itself and this will also aid those who eventually move on to programming in other languages. Logic theories are everywhere! In fact, your brain does it everyday. For example, you want to buy a new camel (which I know every single one of you has gone through at one point in your life). However, there’s two camel shops and you’re trying to find the cheaper one. Whichever one is cheaper, that’s the one you’re going to buy! That’s basically how the Excel logic functions work. 

What I love about logic functions is that I can create a predesigned template and leave blanks which I can fill in. Essentially I'm designing my very own calculators. In this course I’ll teach you how to get started building your very own!

This is for heavy Excel users who process a lot of intricate information

This course is very detailed and one of my best if I do say so myself! It has a total time that’s just under an hour and contains about 20 videos. 

Advanced users


  • Formula builder
  • AND/OR functions 
  • Absolute Referencing
  • Nested Formulas
  • Combinations
  • Error handling

Course Structure


Jed Guinto
Jed Guinto
Jed Guinto is the Co-Founder of Paperclip Learning. Currently pursuing his Ph.D. in Aerospace Engineering, he is also an avid educator with experience teaching primary students, high school students and undergraduate Aerospace, Civil and Mechanical Engineers. Over 44,000 students from over 170 countries have signed up for his courses.

This entry was posted in . Bookmark the permalink.