Skip to content Skip to site navigation Skip to service navigation

Excel: Essential Skills and Tools to Manage Financial Data

Class Sessions

Date Delivery Method Cost
  • Tue Nov 29, 9:00 am to 12:00 pm
  • Thu Dec 1, 9:00 am to 12:00 pm
Live Online - 2 sessions $450

Class Code

ITS-1234

Class Description

Effective immediately in response to COVID-19, most Technology Training classes will be delivered online until further notice.

In advance of each session, Tech Training will provide you with a Zoom link to your class, along with any required class materials.
 



This class provides you with the essential skills and tools to manage financial data in Excel.

Topics covered in this session include basic financial functions, shortcuts and time-saving techniques, and best practices for forecasting data.


Prerequisites: Intermediate Excel knowledge


Goal: To become better acquainted with the financial capabilities of Excel

Objectives:

  • To identify and understand the basic financial functions within Excel
  • To increase fluency with shortcuts and time-saving techniques when using Excel
  • To accurately forecast data in Excel using various methods
  • To create dynamic, financial models

Topics:

  • Navigation (shortcuts)
  • Formula Writing
  • Mixed references (cell locking)
  • Goal Seek
  • Data Tables
  • Scenario Manager
  • Present Value/Future Value
  • Net Present Value
  • Internal Rate of Return
  • Date functions
  • IFS, AND, OR functions
  • Forecasting
  • Moving Average
  • Icon sets
  • Sparklines
  • Correlation
  • Regression
  • Financial Modeling



University IT Technology Training classes are only available to Stanford University staff, faculty, students and Stanford Hospitals & Clinics employees. A valid SUNet ID is needed in order to enroll in a class.