Issue link: http://howardcc.uberflip.com/i/1140073
20 Fall 2019 443-518-1700 howardcc.edu/ConEd Microsoft ® Excel Level 2 in a Day Learn how to use advanced features of Excel including sort- ing and filtering advanced formulas, and analysis tools in- cluding pivot tables and charts. Prerequisite: Microso Excel Level 1 in a Day. 6 hrs. .6 CEUs. $130 (includes $80 in fees*) Wed 9am-4pm, Oct 23 XA-865 8134 #5136 Gateway Campus Lab C Fri 9am-4pm, Nov 15 XA-865 8135 #5137 Gateway Campus Lab C Microsoft ® Excel Level 3 Learn how to work with multiple worksheets and work- books; use lookup functions and formula auditing, apply data validation, create macros, data tables, and use What-If analysis. Prerequisite: Microso Excel Level 2. 12 hrs. 1.2 CEUs. Tuition: $230 (includes $115 in fees*) Mon, Wed 9am-4pm, Dec 2-Dec 4 XA-877 8136 #5671 Gateway Campus Lab C 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*) Wed 9am-4pm, Dec 11 XA-880 8137 #5138 Gateway Campus Lab C 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*) Wed 9am-4pm, Oct 2 XA-786 8138 #5139 Gateway Campus Lab C Fri 9am-4pm, Nov 1 XA-786 8139 #5140 Gateway Campus Lab C 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*) Fri 9am-4pm, Dec 6 XA-787 8140 #5141 Gateway Campus Lab C 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*) Tue,Thu 9am-4pm, Oct 1-Oct 3 XA-874 8143 #5144 Gateway Campus Lab C 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*) Tue,Thu 9am-4pm, Oct 22-Oct 24 XA-875 8144 #5145 Gateway Campus Lab C 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 2. .6 CEUs. $195 (includes $140 in fees*) Thu 9am-4pm, Nov 7 XA-879 8145 #5146 Gateway Campus Lab C Linking Access with SQL Learn how to link your Access database with the SQL Server for data sharing. Create a data file, link and manipulate the data in the Access application. You should have a working knowledge of Access and/or SQL. Prerequisite SQL Essen- tials, and /or Access Level 2. $99** (fee based, no waivers) Thu 9am-12pm, Nov 21 XE-428 8148 #5149 Gateway Campus Lab E Introduction to Tableau is course is designed for the beginner Tableau user. It will help you understand and use the basic techniques for creat- ing stylish visualizations and combining them in interactive dashboards that explain complexity with clarity. You will also learn effective data storytelling to transform how your busi- ness uses ideas and makes decisions. is class will explore all the new features in Tableau 10 and start to redefine what business analytics means to your organization. Prerequisite: Microso Excel. 1.2 CEUs. $495 (includes $355 in fees*) Wed,Fri 9am-4pm, Oct 16-Oct 18 XA-422 8164 #5165 Gateway Campus Lab A SQL Basics This SQL Basics course teaches this powerful database language in easy to understand instruction. You will be able to create unique tables as well as perform selects, inserts, updates, deletes, and drops on your tables. e basics of each SQL command will be covered in this introductory tutorial. is course is designed for all levels of users who need to learn SQL. Windows basic skills are required. 1.2 CEUs. $295 (includes $125 in fees*) Tue,Thu 9am-4pm, Nov 12-Nov 14 XA-803 8146 #5147 Gateway Campus Lab C Computers & Information Technology