Skip to content Skip to site navigation Skip to service navigation

Excel Techniques (Live Online)

New session times will be displayed below upon confirmation.

Prerequisite: Basic Excel experience

Learn powerful techniques in Excel. Topics include demonstrations of data manipulation, validation rules, conditional formatting, templates, styles, and PivotTables.

Topics Include:

  • Data manipulation: Managing budgets and projections, as well as handling large lists of data. Basic and advanced formulas, 3-D ranges, sorting and filtering techniques, database functions, and several other features are covered.
  • Data presentation: Using the powerful analysis and reporting tools, such as PivotTables to extract important information, and present it appropriately to various audiences.
  • Data entry and validation: Using Excel's ability to gather and validate data when applicable. This includes validation rules and conditional formatting.
  • Collaboration: Enabling multiple users to review and edit workbooks by sharing them on the network or via e-mail. Protecting sheets or cells within a sheet to ensure data integrity and confidentiality. Tracking changes, reviewing changes, and accepting changes.
  • Efficiency: Using templates and styles to reuse worksheets, and to set standards and ensure consistency. This also includes dozens of shortcuts and tips that can be applied on a daily basis.

 

What will you be able to do as a result of taking this live online class?

  • Save significant time in creating and managing your workbooks
  • Discover new ways in which you can use Excel to help you achieve your objectives
  • Analyze and present your data to better serve your audiences
  • Collaborate with others by sharing workbooks and tracking changes
  • Apply dozens of shortcuts and techniques in your everyday work
     

Note: After registering for this class, you will receive instructions from GotoWebinar directly. (Make sure the emails you receive from them do not end up in your SPAM filter).


 

University IT Technology Training classes are only available to Stanford University staff, faculty, or students. 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


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.