Skip to main content

Excel for Managing Budgets and Financial Data - Part I

Before each live online session, Tech Training will provide a Zoom link for live online classes, along with any required class materials.

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.
 

 
Do you have trouble managing budgets and financial data in Excel? Would you like to become more proficient in it? This class provides you with the essential skills and tools to manage financial data in Excel. 

This is the first of two, 1/2-day classes for finance professionals who want to get better in Excel.
 
 
Abstract
  • Learning Objectives:
  • Develop a deeper understanding of Excel's tools, crucial for financial data management.
  • Develop the essential Excel skills required for preparing and tracking budgets and for working with financial data.
  • Become more productive and efficient when working with Excel.
 
 
Topics:
  • Financial functions category in Excel.
  • Numbers and number formatting in Excel.
  • Best practices for efficient formula building.
  • How to use named ranges and named constants and why.
  • Working with Excel tables
  • The secrets of sorting and filtering data.
  • The techniques for using lookup functions.
     


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.

Custom training workshops are available for this program

Technology training sessions structured around individual or group learning objectives. Learn more about custom training.

Special Group Rates

For groups of 5 or more, special rates are available. Please contact techtraining@stanford.edu for more details.

University IT Technology Training sessions are available to a wide range of participants, including Stanford University staff, faculty, students, and employees of Stanford Hospitals & Clinics, such as Stanford Health Care, Stanford Health Care Tri-Valley, Stanford Medicine Partners, and Stanford Medicine Children's Health.

Additionally, some of these programs are open to interested individuals not affiliated with Stanford, allowing for broader community engagement and learning opportunities.