Santa Clara University

summer-web

Class Resources

All handouts and class files for Technology Training classes are found here. Use the categories and tags on the right to browse for training material by software application (Excel, Photoshop, etc.) or by subject (PC Replacement, forms and PDFs, etc.)

  • Use the Categories to browse by software application.
  • Use the Tags to browse by subject.
class availability

 

Back to Blog

Topics for MBA Finance Connexion

Are you ready to take your Excel skills to the next level? Do you need to know how to use the extremely powerful data analysis tools to help facilitate business decisions? Then this class is for you!
 

  • Use Advanced IF Functions, COUNTIF, AVERAGEIF, SUMIF
  • Use OR and AND Functions
  • Use VLOOKUP Functions
  • Format using Conditional Formatting
  • Create Data Validation Rules
  • Create Pivot tables
  • Create Charts
  • Learn how to work with Multiple Worksheets/Workbooks

 
Handout

Class Files

Printer-friendly format