Upper Menu

Loading Events

« All Events

  • This event has passed.

Excel Pivot Tables and Dashboards

December 5 @ 1:30 pm - 3:30 pm PST

$39

Tickets

Excel Pivot Tables and Dashboards Class Description:

Understand your Excel data instantly by turning endless rows & columns of numbers into stunning visuals. We’ll manipulate vast amounts of data, by creating Pivot Tables, Pivot Charts, and Dashboards. We’ll even format everything from the shape to the color. Numbers never looked so pretty! A must for anyone who uses Excel.

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:

2 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
  • Pivot Charts
  • 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 Greater Vancouver Chamber of Commerce — 1101 Broadway St # 100,  Vancouver, WA 98660.

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 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.

Details

Date:
December 5
Time:
1:30 pm - 3:30 pm
Cost:
$39
Event Category:

Venue

Greater Vancouver Chamber of Commerce
1101 Broadway
Vancouver, WA 98660
+ Google Map

Organizer

Royalwise Solutions, Inc.

Take our classes in 3 different ways:

  • Live in person. Bring your own computer for hands-on learning.
  • Virtual Class. Attend from home or the office in an interactive classroom experience! You can even raise your hand when you have questions.
  • 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