Division of Information Technology Services

Advanced Non-Credit Course Listings

PDF icon Complete Course Brochure

Access 2010: Level II Aug 26, 27, 28 & 29
9:00am-12:00n 280.00 ACCII10 Register 

This 4 half-day 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 Aug 19 & 20 9:00am-12:00n 150.00 LCD Register 

In this two half-day 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
July 15, 16, 17
1:00pm-4:00pm 220.00 EXII10-D Register 

This three half-day Excel 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
Aug 12, 13, 14
1:00pm-4:00pm 220.00 EXII10-F Register 

This three half-day Excel Level II 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: Macros Sept 2/3 (AM) & 9/10 (PM)
AM/PM 250.00 EXIII10 Register 

This four half-day Level III course 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