Excel - Simple Formulas First

Price
$49.00
Duration
 One Hour
Delivery Methods
 VILT

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
Sep 29, 2022
8:00AM - 9:00AM Central
One Hour
Virtual Instructor Led
 GTR
Nov 11, 2022
3:00PM - 4:00PM Central
One Hour
Virtual Instructor Led
 GTR
Dec 29, 2022
3:00PM - 4:00PM Central
One Hour
Virtual Instructor Led
 GTR

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