Excel - Simple Formulas First

Price
$49.00
Duration
 One Hour
Delivery Methods
 VILT
Skip to Class Dates
Request More Information

This course focuses on working with worksheets and workbooks, using linking techniques. Learn efficient and effective methods for analyzing multiple worksheets and workbooks.

 

Upcoming Class Dates and Times

Aug 15, 2022
10:00AM - 11:00AM Central
One Hour
Virtual Instructor Led
 GTR
Buy Now
Sep 29, 2022
8:00AM - 9:00AM Central
One Hour
Virtual Instructor Led
 GTR
Buy Now
Nov 11, 2022
3:00PM - 4:00PM Central
One Hour
Virtual Instructor Led
 GTR
Buy Now
Dec 29, 2022
3:00PM - 4:00PM Central
One Hour
Virtual Instructor Led
 GTR
Buy Now

This class is also part of our LearnNow Pass. Click here for more details.

Agenda

1 - Outline
  • Use the autofill with data and adjust options
  • Learn the quick analysis tools
  • Use flash fill to build basic formulas with various arithmetic operators
  • Work with the Autosum feature to create basic functions that summarize data
  • Learn to write basic functions directly in each cell and by using the function arguments box
  • Learn range and cell relative, absolute, and mixed cell references