Skip To Content
Image of a desktop computer with keyboard and mouse Excel: Advanced, Part 2 is a Course

Excel: Advanced, Part 2

May 7 - May 7, 2020
0.5 credits

Spots remaining: 10

Enroll

Full course description

Term: Spring 2020
Date: Thursday, May 7, 2020
Time: 8:30 am - 12 pm
Location: North End Center, Room 2460
Instructor: Linda Lester
Presented By: New River Community College Partnership

Description:

This course will help experienced users in Excel 2016, the versatile program that helps you make sense of your data. This course covers applying data validation and working with macros, creating sparklines, mapping data, and forecasting data trends so that you will continue your proficiency and foundational understanding in the world's most popular spreadsheet program.

Workshop Objectives:

Automate workbook functionality

  • Apply data validation
  • Search for invalid data and formulas with errors
  • Work with macros

Create sparklines and map data

  • Create sparklines
  • Map data

Forecast data

  • Determine potential outcomes using data tables
  • Determine potential outcomes using scenarios
  • Use goal seek feature
  • Forecast data trends

Cancellation and No-Show Policy

Cancellations must be received by Human Resources at hr@vt.edu at least three business days prior to the workshop. A $35.00 fee will be assessed to all no-shows and cancellations received less than three business days prior to the workshop.

Sign up for this course today!

Enroll