Excel Pivot Tables and Dashboards

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