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

 
RSS
  •  Excel 2010: Data Analysis

    In this class we will cover filtering data, pivot tables, subtotals, and advanced formulas and functions.

  •  Excel 2010: Charting

    In this course you will learn how to create professional looking charts with ease, edit and format charts, and import charts into other Microsoft programs.

  •  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
    • Format using Conditional Formatting
    • Create Data Validation Rules
    • Create Pivot tables
    • Create Charts
    • Learn how to work with Multiple Worksheets/Workbooks

     
    Handout

    Class Files

  •  Preparing for PC Replacement - Backing up your PC

    This class is for anyone concerned with protecting their data by backing it up. If you are replacing your computer, or scheduled for PC replacement and you don't want to lose any of your data, then this one hour class will prepare you with the tools you need.

Printer-friendly format