Issue link: http://howardcc.uberflip.com/i/893098
16 Winter 2018 443-518-1700 howardcc.edu/ConEd Microsoft ® Excel in a Day Learn to create, edit, and modify spreadsheets. Basic formu- las and functions will be introduced. is class moves at a quicker pace than our regular two-day classes. Prerequisite: Microso Windows. Six hrs. .6 CEUs. $130 (includes $80 in fees*) Tue 9am-4pm, Jan 16 XA-784 8223 #4522 Gateway Campus Lab B Wed 9am-4pm, Feb 14 XA-784 8224 #4523 Gateway Campus Lab B Microsoft ® Excel Level 2 Learn about functions, display multiple workbooks, sort and filter lists using autofilter and outline data. You will also learn to create charts. Prerequisite: Microso Excel Level 1 or equivalent. 12 hrs. 1.2 CEUs. $215 (includes $120 in fees*) Wed,Fri 9am-4pm, Jan 31-Feb 2 XA-873 8219 #4517 Gateway Campus Lab B Tue,Thu 9am-4pm, Feb 27-Mar 1 XA-873 8220 #4518 Gateway Campus Lab B Microsoft ® Excel Level 2 in a Day Learn how to use advanced features of Excel including creating tables and charts, sorting and filtering advanced formulas; analysis tools including pivot tables. is class moves at a quicker pace than our regular two-day classes. Prerequisite: Microso Excel Level 1 in a Day. Six hrs. .6 CEUs. $130 (includes $80 in fees*) Thu 9am-4pm, Mar 8 XA-865 8225 #4524 Gateway Campus Lab B Microsoft ® Excel Level 3 Learn how to import and export data. Work with advanced formulas as well as lookup functions such as VLOOKUP. Find out about data validation and database functions such as DSUM. Also, explore the analytical features of Excel such as goal seek and solver, and conditional formatting with graphics. Prerequisite: Microso Excel Level 2. 12 hrs. 1.2 CEUs. $230 (includes $115 in fees*) Mon,Wed 9am-4pm, Mar 26-Mar 28 XA-877 8221 #4519 Gateway Campus Lab B Microsoft ® Excel Level 4 is course is intended for advanced Microso Excel profes- sionals who need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA). Prerequisite: Excel Level 3. .6 CEUs. $195 (includes $140 in fees*) Thu 9am-4pm, Mar 29 XA-880 8222 #4520 Gateway Campus Lab B PowerPoint Presentations Create and modify presentation slides that combine text, clip art drawings, tables, charts, and graphs. Learn to run a basic PowerPoint presentation. Prerequisites: Microso Windows experience and basic knowledge of Microso Word. .6 CEUs. $130 (includes $80 in fees*) Thu 9am-4pm, Feb 1 XA-786 8226 #4525 Gateway Campus Lab B Tue 9am-4pm, Mar 6 XA-786 8227 #4526 Gateway Campus Lab B PowerPoint Presentations Level 2 Learn to build your own design template, create slides with special effects, apply audio and video files, and include hy- perlinks on slides. Prerequisite: Introduction to PowerPoint or equivalent. Six hrs. .6 CEUs. $130 (includes $80 in fees*) Wed 9am-4pm, Mar 21 XA-787 8228 #4527 Gateway Campus Lab B Databases Microsoft ® Access Level 1 Learn the fundamentals of database processing. Learn to cre- ate a database structure using Access and to edit and use the tools for data retrieval such as queries, forms, reports, and labels. Prerequisite: Working with Windows or equivalent. 1.2 CEUs. $215 (includes $120 in fees*) Mon,Wed 9am-4pm, Jan 22-Jan 24 XA-874 8229 #4528 Gateway Campus Lab B Mon,Wed 9am-4pm, Feb 5-Feb 7 XA-874 8230 #4529 Gateway Campus Lab B Microsoft ® Access Level 2 Learn intermediate Access skills including how to enhance your database designs by using the principles of table relationships and lookup fields, integrate data with other applications, modify a table design to control data entry, find data with filters and queries, customize forms and reports, and create data access pages. Prerequisite: Microso Access Level 1. 1.2 CEUs. $215 (includes $120 in fees*) Mon,Wed 9am-4pm, Feb 12-Feb 14 XA-875 8231 #4530 Gateway Campus Lab D Microsoft ® Access Level 3 Learn how to design database applications, use the perfor- mance analyzer and subform controls. Also create macro groups, dialog boxes to filter records, create switchboards and control tips. Finally, learn to protect databases with passwords, assign user permissions and replicate databases. Prerequisite: Microso Access Level 2. 12 hrs. 1.2 CEUs. $230 (includes $115 in fees*) Mon,Wed 9am-4pm, Feb 26-Feb 28 XA-876 8232 #4531 Gateway Campus Lab D Mon,Wed 9am-4pm, Feb 26-Feb 28 **$207 XA-876 8233 #4532 Gateway Campus Lab D (To register for this section, you must have registered for Microsoft ® Access Level 1 XA-874 and Microsoft ® Access Level 2 XA-875.) Mastering Access Macros Learn about various types of macros and how to best use them including a review of macros learned in the advanced access class. Learn to create automated programs. Global macros, embedded macros, data entry macros and auto- mated macros will be covered. Prerequisite: Access Level 3. .6 CEUs. $195 (includes $140 in fees*) Mon 9am-4pm, Mar 5 XA-879 8234 #4534 Gateway Campus Lab B Computers & Information Technology Access Database Professional Series Take all three courses below to receive a certificate of completion and a 10% discount on the third course. Call 443-518-4680 to find out more.