Discover Classes. Earn 10% Rewards.

Microsoft Excel 2016: Level 2 is unfortunately unavailable

Thankfully we have 2 other Excel Classes for you to choose from. Check our top choices below or see all classes for more options.

Microsoft Excel: Level 1

Colorado Free University See all classes by this school @ 7653 E 1st Pl, Denver, CO

Build a solid foundation in data management with Microsoft Excel 2019: Level 1. From organizing budgets to scheduling tasks, this course teaches you to create, edit, and analyze spreadsheets with confidence. Compatible with both Excel 2019 and Microsoft 365, it is the ideal starting point for new and developing Excel users.

(20) Beginner 18 and older
$179
Attend
+1790 pts
Gift it!

Microsoft Excel: Level 2

Colorado Free University See all classes by this school @ 7653 E 1st Pl, Denver, CO

Build broader data analysis skill in our advanced Excel course. You'll write complex formulas, organize data into tables, and analyze information with PivotTables and PivotCharts. The class also covers templates, charts, and graphics, for better spreadsheets.

(20) Intermediate 18 and older
$179
Attend
+1790 pts
Gift it!
See all Excel classes Denver

Microsoft Excel 2016: Level 2

  • Intermediate
  • 18 and older
  • Earn 10% Rewards
  • Price Lock

    Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!

  • 7653 E 1st Pl, Denver, CO
  • 7 hours

Start Dates (0) $179/person

No upcoming dates are currently available.

Book a Private 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.

Class Description

Description

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.


Overview: 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.

Course Objectives: 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 Content

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 are given ONLY if CFU cancels a class.

If you cannot attend a class you must contact CourseHorse at least 96 hours prior to your first class meeting. With 96 hours 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.

There are no credits issued for cancellations under 96 hours 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 (20)

(4.6-star rating across 20 reviews)

This class: 4.0 out of 5 from 2 reviews

  • Microsoft Excel 2016: Level 2

    It was a very clear presentation, and every question was answered!
  • Microsoft Excel 2016: Level 2

See reviews for other classes at Colorado Free University
loading...
Hide Reviews

Similar Classes

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. Earn 10% back in reward points!

Colorado Free University

Colorado Free University is a lifelong learning center that offers a diverse range of skill-based and enrichment courses taught by independent contractors from the community. With a mission to provide accessible education and foster community connections, CFU is a unique and valuable resource for busy adults seeking to gain knowledge and develop new skills.

View school profile
Colorado Free University
Vetted by CourseHorse

A verified Denver educator.

Loading...