Return to Search page:

Instructor-led Training Overview

Name: Excel Advanced

Overall Rating:

4.9 out of 5 (12 ratings)

Category: All Learners

Duration: 4.00 hour(s)

Individual Fee: $75.00

Reviewed - This development activity has been approved for value and appropriateness

Overview

Learn the advanced functions of Microsoft Excel including Sorting and Filtering, creating Subtotals, and generating PivotTables to summarize and analyze your data.

Course will be taught using Excel 2016 but applicable to older versions which may not have some of the newer features.

Register for Learning

This Development Activity has not been scheduled.

Provider Information

College of Lake County
19351 West Washington Street
Building E, Suite E186
Grayslake, IL 60030
United States

Contact: Eric Pfligler
847-543-2990
CorporateTraining@clcillinois.edu
https://calendly.com/tadmeeting/tad-employer-demo

Objectives

Do and Show: Important tasks or skills you will be able to perform and demonstrate to others.

Sort and Filter Data
Use Excel Tables to Organize Data
Use Subtotals
Summarize Data with PivotTables

Course Outline

Topics

Sorting and Filtering Data

Sorting a single column
Sorting multiple columns
Filtering for specific data
Advanced filtering
Sort and filter by color

Using Tables

Creating and modifying tables
Formatting tables
Calculating tables
Calculating data in a table
Convert the table to a normal range of data

Subtotals

Creating subtotals
Adjusting views with subtotals
Removing Subtotals

Summarizing Data with PivotTables

Creating a PivotTable report
Rearranging, sorting, filtering, and formatting a PivotTable
Changing a PivotTable Calculation
Show values as Percentages
Refreshing Data in a PivotTable
Grouping dates
Showing/hiding PivotTable tools
Changing PivotTable style
Change the layout and format of a PivotTable report
Creating Pivot Chart
Filtering PivotChart

Impacted Skills

Skill	Prerequisite	Expected Outcome
Excel	1 - Beginner	Not specified
Excel Advanced	1 - Beginner	Not specified

Subject Matter Experts

Cathy Horwitz

Costs

Class Costs
Class Value	No Charge
Individual Fee	$75.00
Private Class Fee	$0.00

Reviews

1 2 3 4 5	4.9 out of 5 (12 ratings)

1 2 3 4 5	Excellent Information Wed, Mar 27, 2024
Thank you for teaching this class. It will help me a lot with my job responsibilities and make things easier and more efficient. I am interested in taking more classes in the future.

1 2 3 4 5	Excel advanced Thu, Dec 14, 2023
This was the first class I've taken on Excel (self-taught) and I received a lot of information that I can put to use in my job. Great Class - Thank you!!

1 2 3 4 5	Tons of useful information Fri, Sep 22, 2023
I learned a lot that I plan to put to good use, particularly about table functionality within Excel and the capabilities of PivotTables.

[See all User Reviews…]

Return to Search page: