Discover Classes. Earn Rewards.

Microsoft Excel 2019: Level 2

Expand your data analysis skills with our advanced Microsoft Excel course. Learn to create advanced formulas, organize data into tables, and analyze data using PivotTables and PivotCharts. Enhance your spreadsheets with templates, charts, graphics, and more.

  • Intermediate
  • 18 and older
  • $179
  • 7653 E 1st Pl, Denver, CO
  • 7 hours

Start Dates (1)

  • $179
  • CompuSkills LOWRY @ 7653 E 1st Pl, Denver, CO 80230
  • 7 hours
3 seats left
Book
Showing 11 of 1

Class Description

Description

What you'll learn in this excel class:

Analyze, manage, and share data of all kinds, from personal and professional budgeting to scheduling. In Level 2 learn to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

Learn how to create advanced formulas and organize your data into tables. Discover the power of PivotTables and PivotCharts and how slicers can make data filtering as easy as clicking a few buttons.

In this course, you will gain an understanding of the more advanced functionality in Excel 2016.

You will:

  • Create advanced formulas.
  • Analyze data with logical and lookup functions.
  • Organize worksheet data with tables.
  • Visualize data by using charts.
  • Analyze data with PivotTables, slicers, and PivotCharts.
  • Insert graphic objects.
  • Enhance workbooks.

Target Student: This course is designed for individuals who already have foundational knowledge and skills in Excel 2016 and are ready to advance their data analysis skills and abilities through the application of advanced Excel 2016 functionality, such as advanced formula creation, tables, charts, PivotTables and PivotCharts.

Prerequisite: Excel Level 1 or equivalent knowledge

Course Outline

Lesson 1: Working with Functions

  • Topic A: Work with Ranges
  • Topic B: Use Specialized Functions
  • Topic C: Work with Logical Functions
  • Topic D: Work with Date & Time Functions
  • Topic E: Work with Text Functions

Lesson 2: Working with Lists

  • Topic A: Sort Data
  • Topic B: Filter Data
  • Topic C: Query Data with Database Functions
  • Topic D: Outline and Subtotal Data

Lesson 3: Analyzing Data

  • Topic A: Create and Modify Tables
  • Topic B: Apply Intermediate Conditional Formatting
  • Topic C: Apply Advanced Conditional Formatting

Lesson 4: Visualizing Data with Charts

  • Topic A: Create Charts
  • Topic B: Modify and Format Charts
  • Topic C: Use Advanced Chart Features

Lesson 5: Using PivotTables and PivotCharts

  • Topic A: Create a PivotTable
  • Topic B: Analyze PivotTable Data
  • Topic C: Present Data with PivotCharts
  • Topic D: Filter Data by Using Timelines and Slicers

Refund Policy

Refunds:

  • Refunds are given ONLY if the school cancels a class.

Class Credits & Transfers:

  • If you cannot attend a class you must contact CourseHorse at least 4 business days prior to your first class meeting. With 4 business days notice we can transfer you to another available class or give you a credit voucher to use towards another class in the future (credits are good for one year from date of issue and cannot be redeemed for cash). There will be a $7 transaction fee for dropping or transferring out of the original class.
  • With less than 4 business days notice a credit voucher for half of the class’s tuition will be issued to your account.
  • There are no credits issued for cancellations under 4 business days notice.

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.

Reviews of Classes at Colorado Free University (17)

Benefits of Booking Through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • Lowest price guaranteed. Classes on CourseHorse are never marked up.
  • This class will earn you 1790 points. Points give you money off your next class!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Similar Classes

Colorado Free University

Colorado Free University is a life long learning center offering a wide array of skill-based and enrichment courses. More of a learning network than a traditional school, CFU draws its teachers from the community and all teachers are independent contractors. Classes are designed for busy adults who...

Read more about Colorado Free University

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Denver educator.

Colorado Free University

Colorado Free University

All classes at this location

Google Map

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a 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.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...