Video Lesson: Logical Functions and Formulas

This Excel video lesson is about Logical Functions and Formulas in Excel.  Here are the formulas that I go through in the video lesson:

Logical formulas are extremely useful in more advanced Excel spreadsheets/methods and they are a great tool to have at your disposal.

Make sure to download the most recent Master Excel Workbook so that you can follow along. The spreadsheet I’m reviewing is in the Function Examples sheet in that Excel file.

The formulas covered in this video lesson are:

IF – IFERROR – AND – OR – TRUE – FALSE – NOT

Thanks for watching and feel free to leave any questions or comments in the comment box below!

Excel Course: Book and Website Recommendations

I wanted to suggest a few books that I’ve used in the past which are extremely helpful in learning Excel.  I’d recommend checking any one of these books out as they have lots of useful information and examples for how to get the most out of Excel:

Excel for Dummies 2010 (All-in-One)

Excel 2010 Bible

Excel 2010: The Missing Manual

Excel 2010: Power Programming with VBA

The last book is specifically related to Macros and involves programming with VBA (Visual Basic for Applications).  I would recommend any of these as self-teaching tools for doing additional learning outside of my lessons.  Many of these have earlier 2007/2003 counterparts which would be good if you have that version of Excel.

Additional Excel Online Training Resources

– Educational: Chandoo

– Educational: OZgrid

– Educational: Chip Pearson

– Educational: Mr. Excel

Educational: Excel Easy

– Help: Microsoft Online Answers Site

– Excel Templates: Vertex42’s list of free Excel templates, spreadsheets, and calculators.

Non-Excel Related Websites

Orlando – Web Design and WordPress Support.

Excel Training Lesson Plan Posted

I just updated the site with a proposed lesson plan to give everyone an idea of the topics that I plan on covering throughout the course.

I may jump around between topics depending on what makes more sense and what people are interested in, but I will update the Lesson Plan page to reflect any new posts.

Welcome to Excel Exposure!

I’ve created this site as part of the University of Reddit course (this information is posted here as well). The goal is to expose the world to the amazing functionality of Microsoft Excel. I hope to make this site an easy reference for Excel users of all skill levels so that they can refine their skills, become more efficient, and get the most out of this amazing piece of software.

Excel Exposure Training Course – General Overview

This course will be a complete lesson / teaching tool related to Microsoft Excel. It will have sections and information applicable to all experience levels. It will be updated regularly with additional lessons, tips, and demonstrations of how you can get the most out of Excel.

This course will be taught using Microsoft Excel 2010, but most of the functionality can be found in Excel 2007/2003 (although it may be in a different location). I will not be focusing on the Mac version of the product as I do not have it.

Prerequisites

General knowledge of Microsoft Excel is recommended, but there will be sections of the site for complete beginners.

These will likely be updated last because the main purpose is to improve the knowledge-base of those already familiar with Excel. I will try to make sure it is clear what the experience level should be for each lesson.

Syllabus

The course will be hosted on this website.  I will be posting a new video lesson from the Lesson Plan weekly on Sunday nights (as well as quick tips and other informative links sporadically throughout the course).

The general outline of the syllabus will evolve as the lessons are created/posted.  Always check the Lesson Plans for updates to the course schedule.

Teacher qualifications

Masters of Business Administration (MBA) with concentration in Accounting

Bachelor’s Degree in Accounting

Over 8 years of experience pushing Excel to the limit and improving my abilities.

Questions?

Feel free to reach out to me with any questions, comments or feedback:  ben@excelexposure.com