Intermediate Excel Class

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 http://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.

Directions to PELA (Portland English Language Academy):

The Portland English Language Academy (PELA) is located on the 3rd floor in the northwest corner of the Lloyd Center across from Carrington College. Guests can look for Portland English Language Academy on any of the Lloyd Center directories.

To reach our space from the Lloyd Center MAX Station, enter the Lloyd Center through the large glass doors off of NE Multnomah St. next to Macy’s. Take the circular staircase to the 3rd (top) floor. Turn left and proceed down the corridor. The entrance to our space will be all the way down the corridor on the right (north) side.

Guests who prefer to use an escalator or elevator will find them on the far side of the ice rink that they will see to their right as they enter the large glass doors.

Guests can call 503-226-1656 to reach the PELA office, or call Jamie at 503-504-6392.

For guests who are driving to the Lloyd Center, enter the parking garage at NE Halsey St. & NE 10th Ave. Take the circular ramp in the northwest corner of the parking garage to Floor 3 (the top floor). Enter the Lloyd Center at the entrance that can be seen from the top of the ramp. PELA is located just inside this entrance. Parking is free.

Look for signs to Royalwise’s Classroom!