Digital Workshop Center Trade School

Microsoft Excel PivotTables 

Level 3 | Target Audience: Advanced | 6 hours

Microsoft Excel PivotTablesIn Microsoft Excel PivotTables classes, you will learn the right ways to easily analyze large amounts of data in just a few clicks.  Instead of wasting valuable time with standard Excel look-up features, PivotTables allow you to do quick, easy grouping, summarizing, and filtering of data.  If you are looking to add high demand career skills to your resume or to improve your Excel productivity, this Excel PivotTables training is right for you.

Microsoft Excel PivotTables Classes

    No classes to show

Not finding what you want? Contact us for more info

Overview

In this Microsoft Excel PivotTables class, you will master both PivotTables and PivotCharts, starting with the basics. You will leave this excel class confident in creating an advanced PivotTable and performing advanced data analysis in a short amount of time. Extend your Excel training to be more productive at work and save time today.

As you work through the sessions of Microsoft Excel PivotTables, each class will be a hands-on and intensive workshop, designed to help make difficult topics easier to understand. Your instructor, a Microsoft expert, will work with you closely to make sure that you avoid common mistakes in Excel PivotTables and apply best practices when possible.

Class Objectives

Upon successful completion of the Microsoft Excel PivotTables class, students will be able to:

  • Analyze large amounts of data using PivotTables and PivotCharts
  • Create a basic Excel PivotTable
  • Group and summarize your data in creative ways
  • Filter and sort your PivotTable
  • Apply Slicers for visual filtering
  • Use advanced features of PivotTables
  • Format PivotTables easily
  • Use conditional formatting within PivotTables

Pre-requisites

  • Basic digital literacy including file management is required.
  • Microsoft Excel Beginners (Level 1) or equivalent knowledge is required.
  • It is required you install the latest Microsoft Office software before starting class.

Talk to a student advisor to ensure you have the right pre-requisites for each class or program.

Alumni Spotlight

Just finished up a great course on Microsoft Excel. The Instructor was incredibly knowledgeable and patient with all of his students. I walked away with a new appreciation and great insight for the time tested software that will help me “excel” in my career.
Google Reviews

Cody Shopfer

Sales Manager, KUNC/105.5 Radio

Inside Our Curriculum

Online Tech Skills Classes

Focus on Real-World Skills

Each of our stand-alone classes is designed to teach how to improve your skills in a real-world setting.  DWC's experiential learning style ensures you will be guided by an expert instructor will performing all of the tasks to help you learn.

The challenges you face in class will mimic what you will need to land a job and improve your daily productivity.

Microsoft Excel PivotTables Class

Related Certificate Programs

Microsoft Excel PivotTables Class

Support & Mentoring

All Microsoft Excel PivotTables classes are offered in an accelerated workshop format.

Your instructor will provide hands-on, experiential style classroom learning for you to learn best practices of applying tech skills in the real-world.

Each class may be eligible credit towards a certification program, which includes career counseling and portfolio projects.

Flexible scheduling options allow you to choose what works best for your time.

Why Digital Workshop Center?

Certificate Programs

82%

of program graduates last year from unemployed to employed.

Financial Aid Programs

$0 Upfront

Pay nothing until you’re hired with the Ignite ISA plan.  Payment plans and financial aid options available.

Vocational School

$19k

average increase in salary of certificate program students

Professional Development Training

1-on-1

career counseling and mentoring services included

Always Live | Hands-On | Small Class Sizes | Expert Instructors | Streaming Online

FAQs

When can I start?

Classes are offered on a rolling enrollment basis throughout the year, typically every 8-12 weeks.

Who teaches these classes?

All classes are taught by industry professionals with 10+ years experience in their field.  Check the specific class offering to learn more about the assigned instructor for each class.

You may also learn more about our team here.

What format are these classes?

Stand-alone classes at DWC are focused skills workshops that teach in a specific area of a high demand career field. 

Often described as a "short course" format, these accelerated workshops can be attended as stand-alone or can be taken as part of a larger certificate program.

Certificate programs offer more comprehensive training to help lead you to empoyment, support & mentoring, portfolio building, and career coaching.

To find out more about DWC's style of training, talk to a student advisor today.

What if the listed schedule doesn't work for me?

Click to request more information on a private class or contact us to discuss your training options.

What's included?

Stand-Alone Classes

Every stand-alone class at DWC includes support and mentoring throughout.

Stand-alone classes within your program also include:

  • Professional Textbook(s) or Reference Packet(s)
  • Lesson files
  • One year for a free re-take (for attended students of public classes only)
  • 30 days of technical support
  • Certificate of Completion

Certificate Programs & Bootcamps

Each Certificate Program & Bootcamp is comprised of several stand-alone classes, plus additional training specific to your career field, portfolio building with a comprehensive Capstone Project, and career coaching workshops.

Support and mentoring a huge part of all of our full length programs.

Talk to a student advisor to learn more about specific details on each class or program.

What career services do you offer?

For full length programs, support and mentoring is included and you will be eligible to work one-on-one with a career counselor. 

Workshops for job search and resume writing are included in the cost of your program.  Our expert career advisors will help you prepare for the next steps of your career path.  Your success is our success.

Talk to a student advisor to discuss career coaching options today.

Payment & financial aid options

DWC offers several flexible financial aid options to help you finance your education.  None of our financial aid tools will require a federal student loan or add severe interest penalties.  

Popular financial aid tools include payment plans and  Ignite Income Share Agreement.

If you are interested in scholarship opportunities, you must first speak with a student advisor and discsuss eligibility requirements.

Click here to learn more about financial aid options.

Terms & conditions

Please read our Terms and Conditions before you register.

Still curious?

If you have more questions, view the full FAQ page or contact us today.

Upcoming Microsoft Excel PivotTables Classes

    No classes to show

Questions?