Division of Information Technology Services

Advanced Non-Credit Course Listings

PDF icon Course Brochure (PDF) to print

Access 2010: Level II 4 half-days
Registration Form 

This Level II course is designed for users who can create simple applications with Access and now want to explore some of the intermediate to advanced skill sets. Participants will start by designing a database with a more complex relational model, then set table properties and relationships to further improve data quality, create forms with subforms and create grouped reports. Users will learn to create advanced queries such as those based on other queries, queries to manipulate data, and queries to summarize data. Finally, participants will learn to use macros to create event-driven programming to automate routine processes and incorporate these into the application.
Who Should Attend: People who are familiar with Windows and have taken the Access 2010 - Level I course, or have equivalent experience.

Acrobat LiveCycle Designer 2 half-days
Registration Form 

In this course, users learn how to design a fillable form using the LiveCycle Designer included in Adobe Acrobat Professional to create interactive PDF forms to distribute, fill out, and then submit electronically. Participants will also learn how to organize the collected data in a spreadsheet.
Who Should Attend: People who are familiar with Windows, Adobe Acrobat Pro and Microsoft Office applications, such as Word and Excel.

Excel 2010 - Level II:
Data Analysis and Presentation
3 half-days
Registration Form 

This Level II course introduces participants to tools for analyzing data using features such as sorting, filtering, importing and sharing data. Users will be introduced to various methods for presenting data in report format using Pivot Tables and Charts. Additional topics include conditional and customized formatting.
Who Should Attend: People who are familiar with Windows and have taken the Excel 2010 - Level I course, or have equivalent experience.

Excel 2010 - Level II:
Formulas and Functions
3 half-days
Registration Form 

This course introduces advanced Excel formulas using functions for conditional, logical, financial and date calculations. Participants will learn how to create formulas to look up and manipulate data when working with lists of data. Techniques for auditing and troubleshooting formulas will also be discussed.
Who Should Attend: People who are familiar with Windows and have taken the Excel 2010 - Level I course, or have equivalent experience.

Excel 2010 - Level III:
Advanced Formulas**
2 half-days
Registration Form 

This Advanced Level III course uses a combination of many functions to create formulas for summarizing, extracting and formatting data.  Conditional, logical, duplicate and date types of calculations will be analyzed.
**Who Should Attend: For this advanced formulas course, users must have completed the Level II: Functions & Formulas course or have equivalent experience.

Excel 2010 - Level III: Macros** 4 half-days
Registration Form 

This Advanced Level III provides techniques to automate common repetitive tasks that are used in the Excel workbook development. Participants will learn how to use the Excel built in macro recorder to create basic macros and the Visual Basic for Applications (VBA) Editor to enhance, customize and create methods of deployment. This course is run over two weeks so participants can review and practice more between sessions.
**Who Should Attend: People that have taken Excel 2010 - Level II course, or have equivalent experience.


Last updated on and Powered by Cascade Server