Lubbock - Excel: Managing Data & Data List 8/12/2019

Length

CPE 7 hours (1 day)

Class Time

8:30am - 4:30pm

One-hour break for lunch and a 15-minute morning and afternoon break

Location:

Lubbock Classroom
Melonie Park Meeting Space
3502 74th Street
Lubbock, TX 79423

Course Description

This class is designed for the student who manages lists of data in Excel. Learn not only how to sort alphabetically or numerically, but also how to sort by color, icons and custom list. You will also learn how to take a list of information and narrow the list down to a filtered group. Then work with advanced filters options using AND and OR conditions.

SORTING DATA

Basic Sorts

Sorting by Color

Conditional Sorting – Sorting by Icons

Custom Sorts with Defined List

FILTER

Basic Filters

Filtering using AND and OR Conditions

Advanced Filters

TABLES

How are Tables Different than Filters?

Calculating with Tables

Naming Tables

Removing Tables

PIVOT TABLES

PivotTable Basics

Calculating in PivotTable

Refreshing PivotTables

Changing the Data Source

Working with Slicers and Timelines

Grouping and Ungrouping Data

Calculating in PivotTable

Changing PivotTable Options

Show Report Filter Pages

POWER PIVOT BASICS

Adding Power Pivot to your Ribbon

Importing Tables to the Data Model

Basics of Power Pivot

Who Should Attend

Anyone who wants to learn how to manage lists of data in Excel.

Prerequisites: Basic Excel knowledge

Class Information

Class date: 08/12/19
Class end date: 08/12/19
Seats Remaining: 10
Cut off date: 08/12/19
Individual Price: $169.00
Location: Lubbock Classroom

Group Rate

No Number registrants Rate/Person($)
1 3 149.00
Share this class: