Discover Classes. Earn Rewards.

Microsoft Excel 2016: Level 3 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 2019: Level 1

Colorado Free University @ 7653 E 1st Pl, Denver, CO

Master Microsoft Excel in this comprehensive course designed to help you analyze, manage, and share data effectively. From creating and editing spreadsheets to performing calculations, this course equips you with tools to organize and interpret data with ease. Gain an edge in your organization by unlocking Excel's powerful functionality and transforming raw data into valuable insights.

(17) Beginner 18 and older

Microsoft Excel 2019: Level 2

Colorado Free University @ 7653 E 1st Pl, Denver, CO

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.

(17) Intermediate 18 and older
See all Excel classes Denver

Microsoft Excel 2016: Level 3

  • Advanced
  • 18 and older
  • $184
  • 7653 E 1st Pl, Denver, CO
  • 7 hours

Start Dates (0)

  • $184
  • CompuSkills LOWRY @ 7653 E 1st Pl, Denver, CO 80230
  • 7 hours
Showing 10 of 0

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. The Level 3 class includes topics in advanced data entry functions and capabilities as well as task automation, data analysis and worksheet collaboration. 

Overview
Your previous experience with Microsoft Excel has given you a solid foundation in working with this software. You can use Excel efficiently and effectively to solve problems for your business. In this course, you will learn about some of the more advanced features of Excel, including automating common tasks, auditing workbooks to avoid errors, sharing your data with other people, analyzing data, and using Excel data in other applications.

Beyond the basic features, Excel offers many advanced features that will help you create better, more accurate workbooks. There are also tools that allow you to share your work with other people.
 
Course Objectives
In this course you will explore the functionality of Microsoft Excel. You will: 
  • Automate worksheet functions.
  • Audit worksheets. 
  • Analyze data. 
  • Work with multiple workbooks. 
  • Import and export data. 
Target Student
This course is intended for the student who has experience working with Excel and would like to learn more about creating macros, working with shared documents, analyzing data, and auditing worksheets. 

Prerequisites
  • Excel Level 2 or equivalent knowledge
To ensure your success, you will need to have a comfort level with the basic skills of Excel like entering data, working with data, using functions, and working with formulas. 

Course Content 
Lesson 1: Automating Worksheet Functionality 

  • Topic A: Update Workbook Properties 
  • Topic B: Create and Edit a Macro 
  • Topic C: Apply Conditional Formatting 
  • Topic D: Add Data Validation Criteria 
Lesson 2: Auditing Worksheets 
  • Topic A: Trace Cells 
  • Topic B: Troubleshoot Invalid Data and Formula Errors 
  • Topic C: Watch and Evaluate Formulas 
  • Topic D: Create a Data List Outline 
Lesson 3: Analyzing and Presenting Data 
  • Topic A: Create Sparklines 
  • Topic B: Create Scenarios 
  • Topic C: Perform a What-If Analysis 
  • Topic D: Perform a Statistical Analysis with the Analysis ToolPak 
  • Topic E: Create Interactive Data with Power View 
Lesson 4: Working with Multiple Workbooks 
  • Topic A: Consolidate Data 
  • Topic B: Link Cells in Different Workbooks 
  • Topic C: Merge Workbooks 
Lesson 5: Exporting Excel Data 
  • Topic A: Export Excel Data 
  • Topic B: Import a Delimited Text File 
  • Topic C: Integrate Excel Data with the Web 
  • Topic D: Create a Web Query

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)

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 1840 points. Points give you money off your next class!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

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