Upper Menu

Loading Events

« All Events

Intermediate Excel Class

February 8 @ 10:00 am - 1:00 pm

$59.00
Advanced Excel Class in Portland, OR

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

Course Credits:

3 CPE, Certificate of Completion

Requirements:

  • Our “Learn Excel in 3 Hours Flat” live class/webinar, or
  • Our 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

Details

Date:
February 8
Time:
10:00 am - 1:00 pm
Cost:
$59.00
Event Category:

Venue

CityMac
12310 NE Whitaker Way
Portland,OR97230United States
+ Google Map

Tickets

Intermediate Excel Class - LIVE @ CITYMAC - 2017-02-08$59.0012310 NE Whitaker Way, Portland OR 97230
Intermediate Excel Class - Webinar - 2017-02-08$59.00We will send you the link
Intermediate Excel Class - Watch Later - 2017-02-08$59.00Class recording will be available within two weeks

Take our classes in 3 different ways:

  • Live in person. Bring your own computer for hands-on learning.
  • Online via webinar. Attend from home or the office. You’ll be able to join in the conversation!
  • Watch later. All our classes are recorded, and this option allows you forever access…plus a 10-minute phone call to ask questions.

Click here to download our entire Course Guide. Don’t see the class you want on the schedule? Jamie and Alicia are also available for individual instruction and support. Contact us at 503-406-6550 or fill in this form and we’ll be happy to help.

Please subscribe to our newsletter to receive our monthly computer class schedule in your inbox.

All classes are eligible for CPE credit!

css.php