Excel 2016 Building a Spreadsheet

Price
$49.00
Duration
 One Hour
Delivery Methods
 VILT

In this course, students will learn how to create spreadsheets that look professional and work properly. This course includes a tour of the Excel interface as well as lessons on the basics of creating new workbooks and working with data and formulas.

 

Upcoming Class Dates and Times

Aug 25, 2021
3:00PM - 4:00PM Central
One Hour
Virtual Instructor Led
 GTR
Sep 24, 2021
10:00AM - 11:00AM Central
One Hour
Virtual Instructor Led
 GTR
Oct 25, 2021
10:00AM - 11:00AM Central
One Hour
Virtual Instructor Led
 GTR
Nov 23, 2021
8:00AM - 9:00AM Central
One Hour
Virtual Instructor Led
 GTR
Dec 27, 2021
8:00AM - 9:00AM Central
One Hour
Virtual Instructor Led
 GTR

Who Should Attend

This course is designed for students who are familiar with the basics but want to continue learning more. However, it is also perfectly suited to beginners, who will receive a more thorough introduction to the fundamentals of Excel. Even more experienced users may find review in these areas, though, so this course is recommended to anyone who wants a better understanding of how spreadsheets work.

Course Objectives

    The goal of this course is to make students more familiar and comfortable working with Excel spreadsheets--from creating them to manipulating data and using formulas. By the end of these lessons, you will have a firm understanding of the basics of Excel and will be ready to start exploring more specialized features.

Agenda

1 - Lessons
  • Getting Started with Excel - Learn about the different features of the Excel and how to navigate through the interface.
  • Creating New Workbooks - Learn how to set options for new workbooks, how to create them from templates, and how to set save options.
  • Working with Data in a Worksheet - Learn how to enter, copy, paste, and autofill data to make creating datasets fast and easy.
  • Working with Basic Excel Formulas - Learn the basics of writing and inserting formulas and functions in Excel.
  • Understanding Cell and Range References - Learn about how formulas reference data and how spreadsheets can be connected.