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
The following postings have been filtered by category Excel. clear filter
  •  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

  •  Excel 2010: Pivot Tables

    In this class you will learn how to manipulate large quantities of data by summarizing and evaluating the data with Microsoft Excel 2010 Pivot Tables.

  •  Up and Running with Excel 2004

    This class is designed for Mac users of Microsoft Office Excel 2004. Get up to speed with the basics of Excel to create and format spreadsheets, compute data, and print your work.

Printer-friendly format