ARCHIVED Bulletin: Fall Quarter Excel Training Classes (Posted October 16, 2008)

Sharpen up your Excel skills by attending one of the Fall Quarter classes offered by IT Services Technology Training. To view a complete list of courses offered by IT Services, visit IT Technology Training Services web site.

The Fall Quarter Class Schedule includes:

 

Excel 2007 for Finance Level 1 (ITS-1133)


Date / Time:  Thursday, November 13, 9:00 - 4:00
Location:  POST (Redwood Hall, Room G6)
Fee:  $325
Instructor:  Shane Devenshire (Microsoft MVP)

This is the first of two, 1-day courses, designed specifically for financial applications of Excel and is intended for intermediate to advanced users. The class will be taught using Excel 2003.

Topics include:

  • Employing Range Names
  • Building Formulas & Using Functions
  • Filtering Data with the Auto Filter
  • Lookup Functions
  • Advanced Charting
  • Tools for Managing Data
  • The IF Function and Its Uses
  • Timesaving Strategies and Shortcuts
back to top

Excel 2007 for Finance Level 2 (ITS-1134)


Date / Time:  Wednesday, December 10, 9:00 - 4:00
Location:  POST (Redwood Hall, Room G6)
Fee:  $325
Instructor:  Shane Devenshire (Microsoft MVP)
Pre-requisite:  Excel for Finance Level 1 or equivalent experience

This is the second of two, 1-day courses, designed to focus on the use of Excel in financial applications and is intended for intermediate to advanced users. Although the first class is not a prerequisite, it is strongly recommended. The class will be taught using Excel 2003.

Topics include:

  • Database Functions
  • Techniques for Cleaning Up Incoming Data
  • Miscellaneous Techniques for Analyzing Data
  • Using Advanced Filter & Lists
  • Pivot Tables
  • Linear Regression
  • Creating Functions Using VBA
back to top

Excel 2007: Seven Essential Time-Saving Skills for Effective Excel Use (ITS-1146)


Date / Time:  Monday, October 27, 9:00 - 4:00
Location:  POST (Redwood Hall, Room G6)
Fee:  $325
Instructor:  Shane Devenshire (Microsoft MVP)
Pre-requisite:  Excel Level 2 or equivalent experience

This full-day class is designed for the experienced Excel user. It reveals numerous time-saving tools and features that will significantly enhance a user's productivity.

Topics include:

  • Multi-function Menus
  • File Open Options
  • Working With Windows
  • Paste Special Commands
  • Entering a Formula in a Range
  • Introduction to Array Formulas
  • Manipulating Sheets
  • Examining Tools Options
  • Moving Around and Selecting with the Keyboard and the Mouse
  • Working With Columns and Rows
  • Splitting Data
  • SUMIF and COUNTIF Functions
  • Status Bar Functionality
  • Using the Fill Handle
  • Exploring Toolbars
  • Discovering Hidden Secrets
back to top

Excel Transition from 2003 to 2007 (ITS-1137)


Date / Time:  Thursday, November 6, 8:30 - 12:00
Location:  PHIL (Polya Hall, Room 170B)
Fee:  $195
Pre-requisite:  Excel Level 1 (any version) or equivalent experience

Using Excel, but need to make the transition to version 2007 quickly? Learn how to use the new interface and new features, and to share files with users of older versions.

Topics include:

  • Introducing the new Excel user interface
  • Create, Sort and Filter a Table
  • Create a Chart
  • Work with Functions and Formulas
  • Format a Report for Printing
  • Apply Conditional Formatting to a Table
back to top

Excel 2007: PivotTables (ITS-1147)


Date / Time:  Wednesday, November 19, 9:00 - 4:00
Location:  POST (Redwood Hall, Room G6)
Fee:  $325
Instructor:  Shane Devenshire (Microsoft MVP)
Pre-requisite:  Excel Level 2 or equivalent experience

Learn the basics of Pivot Tables, Excel's powerful tool that allows you to create interactive reports that quickly combine and compare large amounts of data.

Topics include:

  • PivotTable Fundamentals
  • Creating a PivotTable
  • Customizing Fields in a PivotTable
  • Formatting a PivotTable
  • Controlling What's Viewed in a PivotTable
  • Using Calculations in a PivotTable
  • Using Disparate Data Sources in a PivotTable
  • Creating and Using Pivot Charts
back to top

Excel 2007: Getting Started with Macros (ITS-1145)


Date / Time:  Monday, November 3, 9:00 - 4:00
Location:  PHIL (Polya Hall, Room 170B)
Fee:  $325
Instructor:  Shane Devenshire (Microsoft MVP)
Pre-requisite:  Excel Level 2 or equivalent experience

Create and edit macros to do repetitive tasks, simple to complex. Use this powerful tool to increase your productivity.

This class is designed for the experienced Excel user who needs to go beyond the basics with a special focus on automating Excel tasks with Macros. Participants will learn the fundamentals of macro security and will be introduced to Microsoft's Visual Basic Editor at the entry level.

Topics include:

  • Introduction to Macros
  • Recording a Command Macro
  • Using the Visual Basic Editor
  • Running a Command Macro
  • Recording More Command Macros
  • Creating Macros for Printing
  • Assigning Macros to Buttons and Menus
  • Using the Personal Macro Workbook
  • Debugging and Editing a Macro
  • Creating and Using a Function Macro Using Dialog Box Controls
  • VBA Programming from Scratch
back to top

Excel 2007: What You Don't Know Excel Yet? (Level 1) (ITS-1141)


Date / Time:  Friday, October 24, 9:00 - 4:00
Location:  POST (Redwood Hall, Room G6)
Fee:  $325

Create simple spreadsheets, then learn how to copy, move, insert, and delete data. Insert functions, use basic formulas, and create simple charts.

Topics include:

  • Getting Started
  • Creating a New Workbook
  • Entering Values
  • Entering Formulas and Functions
  • Formatting a Worksheet
  • Editing Worksheets
  • AutoFilling a Series
  • Creating a Custom Series
  • Relative vs. Absolute references
  • Preparing to Print
  • Charting Basics
back to top

Excel 2007: Tables, Functions, and Linking (Level 2) (ITS-1142)


Date / Time:  Thursday, December 4, 9:00 - 4:00
Location:  POST (Redwood Hall, Room G6)
Fee:  $325
Pre-requisite:  Excel Level 1 or equivalent experience

Expand your spreadsheet skills by using powerful functions. Link multiple worksheets, use range names, and create lists.

Topics include:

  • Customizing Excel
  • Working with Dates
  • Working with Cell Ranges
  • Working with Tables
  • Outlining and Grouping
  • Worksheet Functions
  • Linking
  • Using Database Functions with Tables
back to top

How to Register

To register for this class and pay with STAP Funds:

  1. Go to the Axess portal and log in.
  2. Click on the Training tab.

    Note:  If the Training tab is not present on your page, click the My Home link instead.

  3. Click on Search Catalog.
  4. Type the name of the class in the Title field, then click Search.
  5. From the results, click on the course title or Enroll to bring up course details.
  6. Follow the instructions to enroll.

    Note:  Add to Plan does NOT enroll you.

To register using University Department, Hospital Tuition Assistance or Personal Funds:

  1. Download and fill out the paper registration form
  2. Fax it to IT Technology Training Services at 650-725-0995

If you have questions, call IT Technology Training Services at 650-723-4391.

back to top