Discover Classes. Earn 10% Rewards.

Excel Intermediate 2: Queries, Subtotals & Tables is unfortunately unavailable

Thankfully we have 1 other Tech Class for you to choose from. Check our top choice below or see all classes for more options.

Artificial Intelligence (AI) Business Essentials Certificate Program

American Management Association See all classes by this school @ 25 Burlington Mall Rd, Burlington, MA

Gain a practical foundation in the technologies, applications, and strategic implications of artificial intelligence in today's business environment. This certificate program covers the current AI landscape, key use cases, and the organizational opportunities that AI opens up. A focused and forward-thinking program for professionals ready to lead in an AI-driven world.

(8) All levels 21 and older
$2,795

2 sessions

Attend
Earn 27,950 points
Gift it!
See all Tech classes Los Angeles

Excel Intermediate 2: Queries, Subtotals & Tables

  • Advanced
  • 16 and older
  • Earn 10% back in points
  • Price Lock

    If you find the same class on the same dates for less on another site within 48 hours of booking, send us the link. We match the price as credit or the difference.

  • 200 Pine Ave, Long Beach, CA
  • 3 hours

Start Dates (0) $149/person

No upcoming dates are currently available.

Book a Private Group Event

Booking this class for a group? Find great private group events

Or see all Excel Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

Class Description

Description

In this three-hour session, you will import external data, create simple queries to bring in data from SQL sources. You will sort lists by multiple columns, generate automatic subtotals on sorted data, including multi-level subtotals. Finally, you will convert data into a table, apply automatic formatting and totals and use AutoFilter to show only rows that meet your criteria.

Prerequisites

This class is suited for people who have taken Excel levels 1 and 2 or been using Excel (any version) for a year or more and want to learn Excel's powerful tools for managing and summarizing long lists of data.

Outline

Writing Queries to Import Data
  • importing data from text files
  • writing queries to import data
Summarizing Data with Subtotals
  • sorting tables by one or many fields
  • generating sub- and grand totals
  • outlining to show only sub- and grand totals
  • creating multi-level subtotals
Using Data in Tables
  • importing data from text files
  • converting data into a table
  • applying tables styles and totals row
  • using AutoFilter to find records
  • creating custom AutoFilter criteria

Refund Policy

  • You may cancel or reschedule a class registration at least 8 business days prior to the class without incurring any penalty.
  • After 8 business days, we may charge a penalty of up to 100% of the registration cost.
In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

In the event that an instructor or the school needs to cancel at the last minute, students will receive a refund less a 5% non-refundable registration fee.

Reviews of Classes at Accelerate Computer Training (33)

(4.9-star rating across 33 reviews)

This class: 5.0 out of 5 from 1 review

  • Excel Intermediate 2: Queries, Subtotals & Tables

See reviews for other classes at Accelerate Computer Training
loading...
Hide Reviews

Benefits of Booking Through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • No booking fees. You pay the school's price, with nothing added at checkout.
  • Price Lock. If you find the same class on the same dates for less on another site within 48 hours of booking, send us the link. We match the price as credit or the difference.
  • This class will earn you 1490 points. Earn 10% back in points. 100 points = $1 off a later class.

Accelerate Computer Training

Accelerate Computer Training offers hands-on computer training classes in Long Beach, California. Their experienced trainers provide personalized instruction in a variety of software applications, allowing students to improve their skills and enhance their work efficiency.

View school profile
Accelerate Computer Training
Vetted by CourseHorse

A verified Los Angeles educator.

Loading...