Excel 2019 Level 2
CLASS DATE(s):
7/2/2020
8/5/2020
9/10/2020
10/6/2020

COURSE LENGTH: 1 Day

COURSE COST: $295

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print
Register for this course
register

COURSE OVERVIEW

Whether you need to crunch numbers for sales, inventory, IT, HR, or other organizational purposes & departments, the ability to get the right info to the right people at the right time can be powerful. After all, the world runs on data more than ever before & that's a trend not likely to change. But with so much data available and being created on a nearly constant basis, the ability to make sense of that data becomes more critical & challenging with every passing day. You already know how to get ExcelŽ to perform simple calculations & how to modify your workbooks & worksheets to make them easier to read, interpret, and present to others. But, Excel is capable of doing so much more. To be truly competitive, you need to be able to extract actionable organizational intelligence from your raw data. In other words, when you have questions about your data, you need to know how to get Excel to provide the answers for you. And that's exactly what this course aims to help you do.

AUDIENCE AND PREREQUISITES

This course is designed for students who already have foundational knowledge and skills in Excel 2019 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.

To ensure success, students should have completed Excel 2019 Level 1 or have the equivalent knowledge and experience.

  

*Course cost listed does not include the cost of courseware or lunch. Course is subject to minimum enrollment. Please contact us at learn@vtec.org or 207-775-0244 for additional pricing information, or if you have any questions.

COURSE TOPICS:


1. Working with Functions
Work with Ranges
Use Specialized Functions
Work with Logical Functions
Work with Date & Time Functions
Work with Text Functions

2. Working with Lists
Sort Data
Filter Data
Query Data with Database Functions
Outline and Subtotal Data

3. Analyzing Data
Create and Modify Tables
Apply Intermediate Conditional Formatting
Apply Advanced Conditional Formatting

4. Visualizing Data with Charts
Create Charts
Modify and Format Charts
Use Advanced Chart Features

5. Using PivotTables and PivotCharts
Create a PivotTable
Analyze PivotTable Data
Present Data with PivotCharts
Filter Data by Using Timelines and Slicers