Intermediate Excel Class Description: Once you’re familiar with Excel, learning the more advanced tools will help you analyze your numbers for solid business decisions. We’ll create pivot tables. We’ll demystify dozens of handy formulas: vlookup, date, text and logic formulas. We’ll sort and filter data tables, name ranges for easy understanding, and protect worksheets to keep them perfect. We’ll also explore more tools that you can use as soon as you get back to work. It doesn’t matter what version of the PC or Mac operating system you’re using. The techniques we will cover work similarly in Excel for PC and Mac. The class will be recorded and saved in “My Class Recordings” for you to review at your convenience! Instructional Level: Intermediate through Advanced Course Length:3 hours. Requirements: Our “Learn Excel in 3 Hours Flat” live class/webinar, or Our udemy.com “Learn Excel in 3 Hours Flat” video course, or Prior knowledge of the features listed in the description above. Microsoft Office 365 or a standalone copy. Who should take this class? Business owners and employees looking to manipulate and analyze Excel spreadsheet data for business decisions.Students and job-seekers looking to boost their employment marketability. Experienced users looking to glean essential nuggets of information to make using Excel easier than before What should you bring? A laptop computer with Excel loaded (any version is fine). What You’ll Learn: AutoFill Handle. Relative and Absolute Cell References. Named ranges. Data Tables for working with Lists. Pivot Tables. IF function. AND/OR/NOT functions Nested functions. VLOOKUP and HLOOKUP DATE functions.TEXT formulas including CONCATENATE and splitting text into columns. Tracing formulas. Protecting worksheets. Plus, you’ll learn valuable tips and tricks to shave time off your daily tasks. Instructor: Alicia Katz Pollock. Attend in Person, via Virtual Class, or Watch Later: If you are planning to attend our class in person, choose “Live” from the dropdown menu. This class will be taught at the Portland English Language Academy. Scroll down for directions! If you live outside the Portland/Vancouver area, or if you don’t want to make the drive, you can attend and participate in our classes via Virtual Class. When you register, choose “Virtual Class” as your ticket type. We’ll email you an access code and instructions for how to connect. Please log in 10 minutes before the start time to connect your audio and video.Our Virtual Classes are just as if you are physically in the classroom with us. This is not just a watch-and-listen webinar: it’s an interactive classroom experience! You can talk and be seen. You can virtually raise your hand when you have questions. It’s truly just like a real class. A recording of the Virtual Class will be available to you in two weeks at https://royalwise.com/my-classes/. Please note that by participating in our Virtual Classes you are granting your consent to be seen and heard by the public, since anyone can purchase these class recordings from our website. If you do not consent, we can make you a listen-only attendee – just let us know! If you are unable to attend on this time & date, select the “Watch Later” option. After class is done, we’ll send you access information so that you can watch the content at your convenience. You are welcome to call us with your individual questions for a free 10-minute Q&A session.