Computer Courses
Beginning in January, a new billing procedure will be instituted for the Computer Challenge courses. If you register for a Computer Challenge course, you will receive an invoice one week prior to the session date. You must complete the invoice and fax it to the Office of Human Resource Services (352-392-5495) prior to the session date.
Please note that the invoice must include the appropriate ChartField information to be used to complete an Expense to Revenue (E2R) transaction. Additionally, because the funding is coming from your department/unit, you are now required to obtain your immediate supervisor’s signature on the invoice.
If you have questions about this new procedure, please contact Training and Organizational Development at training@ufl.edu or 352-392-4626.
CCH060 Microsoft Excel Basic ($75)
Thursday, January 28, 8:30 a.m. to 4:30 p.m., HRS Building, Room 119
Thursday, April 1, 8:30 a.m. to 4:30 p.m., HRS Building, Room 119
This course is designed for persons who already have knowledge of the Microsoft Office Windows 98 (or above) operating system, and who want to gain the skills necessary to create, edit, format, and print basic Microsoft Excel 2007 worksheets. It is also for those preparing for certification as a Microsoft Office Specialist in Excel.
Pre-requisite(s):
Introduction to Computers or comfort using Windows operating system
CCH061 Microsoft Excel Intermediate ($75)
Thursday, February 11, 8:30 a.m. to 4:30 p.m., HRS Building, Room 119
Thursday, April 22, 8:30 a.m. to 4:30 p.m., HRS Building, Room 119
In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.
This course is for persons who want to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the Web. In addition, this course helps prepare those working toward the Microsoft Office Specialist exam in Excel or Module 2 and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.
Pre-requisite(s):
Excel 2007 - Basic or equivalent knowledge
CCH062 Microsoft Excel Advanced ($75)
Thursday, January 14, 8:30 a.m. to 4:30 p.m., HRS Building, Room 119
Thursday, March 11, 8:30 a.m. to 4:30 p.m., HRS Building, Room 119
In this course, you will learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.
This course is for persons who want to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources, and import and export data. In addition, the course is also for students preparing for the Microsoft Office Specialist exam in Excel 2007 or Module 2-Key Applications of the Internet and Computing Core Certification (IC3) exam, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.
Pre-requisite(s):
Excel 2007 - Basic or equivalent knowledge
Excel 2007 - Intermediate or equivalent knowledge
CCH050 Microsoft Access Basic ($150)
Thursday, February 18, and Friday, February 19, 8:30 a.m. to 4:30 p.m., HRS Building, Room 119
(2 full days of instruction)
In this course, you will be introduced to the concept of the relational database and the Microsoft Office Access 2007 relational database application, and information management tools. Also, you will learn how to design and create a new Access database.
This course is designed for persons who wish to learn the basic and intermediate-level operations of the Microsoft Access Database program to perform their day to day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes.
Day One addresses job responsibilities that include working with tables to create and maintain records, locate records, and produce reports based on the information in the database. It also provides the fundamental knowledge and techniques needed to advance to more technical Access responsibilities, such as creating and maintaining new databases and using programming techniques that enhance Access applications.
Day Two addresses job responsibilities that include creating new databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces integrating Access data with other Microsoft applications.
Pre-requisite(s):
Introduction to Computers or comfort using Windows operating system
CCH051 Microsoft Access Advanced ($75)
Friday, March 19, 8:30 a.m. to 4:30 p.m., HRS Building, Room 119
In this course, you will extend your knowledge into some of the more specialized and advanced capabilities.
This course is designed for persons who wish to learn intermediate and advanced operations of the Microsoft Access Database program. This course is for those whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for students pursuing the Microsoft MOS Certification for Access 2007, and it is a prerequisite to taking more advanced courses in Access 2007.
Pre-requisite(s):
Access 2007 - Basic or equivalent knowledge