COMPUTER AND INFORMATION TECHNOLOGY
MICROSOFT OFFICE ACCESS, INTRODUCTION
Take away the mystery of database design in Access by creating, designing, and editing tables. Learn to create simple queries and filters and develop the skills to design simple forms and reports. $299
Sep 9-Sep 10 MT 9 am-4 pm
Sep 16-Sep 19 MTWTh 6 pm-9 pm ACCESS, INTERMEDIATE
HARBN CEDBS 620 33 HARBN CEDBS 620 85
Learn about database normalization, relationships, referential integrity, and analyzing tables. Explore complex queries with joins, parameters, calculated fields, and summarizing and grouping values. Work with action queries and finding unmatched or duplicate records. Learn to create advanced reports with calculated fields and enhanced control formatting and data bars. $299
Sep 11-Sep 12 WTh 9 am-4 pm
Sep 23-Sep 26 MTWTh 6 pm-9 pm ACCESS, ADVANCED
HARBN CEDBS 623 34 HARBN CEDBS 623 80
Learn more advanced form design with sub-forms, tab pages, and navigation forms. Import, export, and link external data and perform a Word mail merge with Access data. Learn how to have a more turnkey database with macros, VBA programming, and switchboards. Learn about database management topics like dependencies, documenting, compacting, repairing, splitting, security, and converting into ACCDE. $299
Nov 6-Nov 7 WTh 9 am-4 pm
Nov 11-Nov 14 MTWTh 6 pm-9 pm OFFICE PRODUCTIVITY LAB
HARBN CEDBS 624 38 NEAST CEDBS 624 66
Demonstrate your knowledge of office applications by creating documents and spreadsheets using the skills acquired in the program. To receive an Office Administrative Specialist Certificate, you must successfully complete this course. Prerequisites: Word (Introduction and Intermediate), Excel (Introduction and Intermediate), Organizing Computer Files, Outlook (Introduction), Computer Typing for Everyone and Becoming a Customer Service Star). $199
Dec 16 M Dec 17-Dec 18 TW
9 am-4 pm 6 pm-9 pm
POWERPOINT, INTRODUCTION
Your presentations can be showstopping. Create slide shows using PowerPoint's most commonly used features. $299 Dec 2-Dec 3
MT 9 am-4 pm
Dec 9-Dec 12 MTWTh 6 pm-9 pm POWERPOINT, ADVANCED
HARBN CEPDP 629 41 NEAST CEPDP 629 53
Import from other applications, create photo albums, share presentations, and create templates. Use multimedia effects including sound and video to produce professional, effective presentations. $299
Dec 16-Dec 17 MT 9 am-4 pm Dec 16-Dec 19 MTWTh 6 pm-9 pm
NEAST CEPDP 650 21 NEAST CEPDP 650 52
OUTLOOK, INTRODUCTION Make the most of your email communications. Learn to work
NEAST CEMSO 516 11 HARBN CEMSO 516 53
with contacts and distribution lists. Find out how Outlook tasks can help with organization, and use the Outlook calendar to keep up with your busy schedule. $299
Sep 16-Sep 17 MT Sep 30-Oct 9 MW
9 am-4 pm 6 pm-9 pm
HARBN CESCH 708 07 NEAST CESCH 708 65
OUTLOOK, INTRODUCTION – ONLINE
Prerequisite: Basic Computer skills and the ability to navigate the Internet, websites, and email. $299 Oct 2-Oct 10
CEONL OUTLOOK, ADVANCED
Take your Outlook skills to the next level. Learn how to customize Outlook, automate commonly used actions, work with folders, organize Outlook components, and use the Rules Wizard. $299
Nov 7-Nov 8
Th F
Nov 18-Nov 20 MTW
9 am-4 pm 9 am-12 pm 6 pm-9 pm
HARBN CESCH 717 13 HARBN CESCH 717 52
CREATING A SIMPLE EXCEL SPREADSHEET
Learn to create a simple Excel spreadsheet complete with formats and easy formulas. $99 Nov 22
F 9 am-12 pm EXCEL FORMULAS AND FUNCTIONS
Work with basic math formulas and progress to conditional, lookups, date and time, financial, statistical, and conversion examples. Protect and hide your formulas and create user- defined functions. $179
Nov 4 M EXCEL GRAPHS
Graphs are very powerful tools for visually representing your important numeric data. Learn how simple it is to create in Excel. $99
Nov 1 F EXCEL MACROS
Enjoy the efficiency of macros as you learn to record mouse clicks and keystrokes for playback later or to record a sequence of commands you use to perform repetitive tasks in Excel. Get the basics in this class. $99
Oct 25 F EXCEL PIVOT TABLES
Learn to use Pivot Tables to summarize large amounts of data and analyze it in a variety of ways. $99 Sep 20 Nov 15
F F
9 am-12 pm 9 am-12 pm
EXCEL, INTRODUCTION
Learn how to create effective and efficient worksheets using formulas, common functions, formatting and printing. $299 Sep 3-Sep 4 Oct 2-Oct 3
TW WTh
Oct 16-Oct 17 WTh Sep 9-Sep 18 MW
ENROLL @
MIDLANDSTECH.EDU/training | 803.732.0432 | see page 46
9 am-4 pm 9 am-4 pm 9 am-4 pm 6 pm-9 pm
HARBN CESDS 602 40 NEAST CESDS 602 39 NEAST CESDS 602 41 NEAST CESDS 602 62
17
NEAST CESDS 631 34 HARBN CESDS 631 35
9 am-12 pm NEAST CESDS 640 29 9 am-12 pm NEAST CESDS 629 27 9 am-4 pm NEAST CESDS 630 37 NEAST CESDS 628 37 CESCH 721 06I
Page 1 |
Page 2 |
Page 3 |
Page 4 |
Page 5 |
Page 6 |
Page 7 |
Page 8 |
Page 9 |
Page 10 |
Page 11 |
Page 12 |
Page 13 |
Page 14 |
Page 15 |
Page 16 |
Page 17 |
Page 18 |
Page 19 |
Page 20 |
Page 21 |
Page 22 |
Page 23 |
Page 24 |
Page 25 |
Page 26 |
Page 27 |
Page 28 |
Page 29 |
Page 30 |
Page 31 |
Page 32 |
Page 33 |
Page 34 |
Page 35 |
Page 36 |
Page 37 |
Page 38 |
Page 39 |
Page 40 |
Page 41 |
Page 42 |
Page 43 |
Page 44 |
Page 45 |
Page 46 |
Page 47 |
Page 48
