MS Excel Conditional Tools: IF functions, Data Validation,  (VIRTUAL CLASS)

American Job Center in Wheeling

Learn how to use IF and other logical functions to add conditions to Excel tasks

Add power and complexity to your Excel spreadsheets! In this 90-minute webinar we'll talk about about one of the most powerful functions in Excel - the IF function. We'll also talk about other logical functions like AND/OR as well as functions like SUMIF and AVERAGEIF. Many tools in Excel are condition-based. So what is a condition??? We'll look at several areas of Excel that serve different purposes, but use the same underlying concept of condition. Understanding how conditions are used in Excel not only extends your knowledge of different tools in Excel, but adds to your overall understanding of Excel.Registration ends by 5pm the day prior to the Webinar. Once you register on Eventbrite, you will receive an email from the instructor through GoToWebinar with the link to join this class.<ul><li>If you need to cancel, please cancel 48 hours prior so someone else on the waiting list can use your seat.</li></ul><ul><li>PLEASE do not register and then no show.</li></ul>For an optimal webinar experience when registering and attending these virtual workshop, the following is recommended:<ul><li>USE the following email accounts-Gmail (google.com) or Outlook (outlook.com)</li><li>Register and attend the workshop with either browser-Google Chrome or Microsoft Edge</li><li>If you don’t receive the emails in your inbox, please check your JUNK/SPAM Folder</li><li>Sessions are CST</li><li>Sign in 10 minutes prior to the webinar</li></ul>You’ll receive the following emails. Last two have Join Webinar/LINK to attend<ol><li>Eventbrite: Email Confirmation from Eventbrite which is ONLY your E-Ticket Summary</li><li>GoToWebinar: Email Registration Confirmation of Computer Webinar from instructor to Click JOIN WEBINAR (LINK)</li><li>GoToWebinar: Email Reminder ONE DAY PRIOR to Computer Webinar from instructor to Click JOIN WEBINAR (LINK)</li></ol>Note: There’s NO access code, you’ll receive JOIN WEBINAR/LINK in your 2nd&amp; 3rd emails.Information/Cancel workshop-send email to webinar.organizer6@gmail.comYou can also send a note via Eventbrite website in the ticket order email section.The American Job Center is committed to providing all customers with quality, professional services as well as a safe and comfortable learning environment. The use of our resources implies acceptance of our Customer Code of Conduct, which is based on the principle of respect for all customers and staff. READ: <a href="https://www.northcookjobcenter.com/wp-content/uploads/2020/08/Customer-Code-of-Conduct-handout.pdf" title="https://www.northcookjobcenter.com/wp-content/uploads/2020/08/Customer-Code-of-Conduct-handout.pdf" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer">https://www.northcookjobcenter.com/wp-content/uploads/2020/08/Customer-Code-of-Conduct-handout.pdf</a>QUESTIONS? EMAIL: contact@bcsillinois.orgSubject to change without notice.

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}