...

Excel Data List Management- One Day (Code: 20150)

Prerequisites

To ensure your success, we recommend you first take the following course (or have
equivalent knowledge): Excel Intermediate Level (Code: 20135)

Course Overview

After taking this course you will be able to organize your data in tables, use various methods to sort and filter your data, analyze your data with PivotTables as well as use database functions.

Instruction will be personalized by version (2016/2019/2021/365).

Excel Data List Management Topics

1. Data List and Excel Table Concepts
2. Using Data Forms
3. Using Lookup Tables
4. Sorting Lists
5. Sorting Concepts
6. Sorting Lists
7. Custom Sort Orders
8. Filtering Lists
9. Filtering Concepts
10.Using AutoFilter
11.Using Advanced Filter
12.Working with Filtered Data
13.Summarizing Data
14.Automatic Subtotals
15.Working with Subtotaled Lists
16.Creating PivotTables
17.Modifying PivotTable Layouts
18.Working with PivotTables
19.Pivot Charts
20.Slicers
21.Getting External Data
22.Importing Query Data from Excel Files
23.Importing Query Data from Text Files

Choose Another Popular Course

Choose Another Course
Share This Post
Have your say!
2 0

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Request a Quote

Request Quote Form

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.

Thanks for Downloading Your Gift

We have sent your quick reference guide for creating Dashboard.

Please check your inbox to receive Your Gift.

Happy Learning !!

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.

Seraphinite AcceleratorOptimized by Seraphinite Accelerator
Turns on site high speed to be attractive for people and search engines.