Computer Skills in the Workplace Level I & Level II Certificate

Word Basics
In this course, you will gain basic proficiency with Microsoft Word. Discover the best and fastest ways to perform everyday tasks. Learn how to create and edit documents, format characters and paragraphs, create and manage tables, control page layout, work with web features, instant message, and much more. You'll be able to practice what you learn in this hands-on course. New users of previous Word versions will also benefit.

Word Intermediate
Topics covered include working with sections and columns, formatting tables, working with Excel data, working with styles, headers and footers, printing labels and envelopes, working with graphics and objects, document templates, and managing document revisions. Pre-requisite: Word Basics or equivalent knowledge.

PowerPoint Basics
PowerPoint is used to create presentations that can combine text, graphics, charts, clip art, and WordArt. These presentations can then be shown at internal business meetings, sales calls, and training events. Additional topics include building new presentations, formatting slides, using drawing tools, working with graphics, using tables and charts, and modifying the proofing presentations. Experience with Windows is recommended.

Outlook Basics
Are you overwhelmed by emails, meetings, and to-do lists? In this course you'll learn how to manage the flood of emails , creating folders and archives, how to keep track of your contacts and how to use Outlook's Calendar and Alert features. Find out how to customize Outlook so it perfectly meets your needs, and discover how to automate your work with rules. Whether you're new to Outlook or you've been using it for years, you're sure to learn something useful in every lesson.

Excel Basics
Work with numbers? Then you need to learn Excel. In this class, you will use Excel and discover dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You'll benefit from hands-on activities covering creating and editing workbooks, modifying worksheets, using calculations, formatting worksheets, and managing large workbooks. Experience with Windows is recommended. New users of previous Excel versions will also benefit.

Access Basics
This course will take you from knowing litle or nothing about databases and Access to a basic level of understanding. Topics include database concepts, databases and tables, fields and records, data entry rules, simple queries, using forms, creating and modifying reports, and much more. You'll practice what you learn in this hand-on course.

Word Advanced
Topics covered in this class include working withforms, working with large documents, creatingmacros, customizing menus and toolbars, usingXML features, and sharing Word documents. Pre-requisite: Word Intermediate or equivalentknowledge.

PowerPoint Intermediate
Learn to deliver presentations across mutilple venues, while keeping information confidential. PowerPoint Intermediate will help you make your presentations interesting, informative and memorable. Given all the variables, it may seem an overwhelming task to deliver your content, on time, to all audiences, and to only those who need to see it. This course will give you a variety of robust tools to help you deliver your content easily, quickly and for any situation.

Excel Intermediate
Continue with your Excel proficiencies by learning the benefits of the more advanced features of Excel. Topics covered include using multiple worksheets and workbooks, customizing Excel, working with functions, list and data analyzing, and management. You will also be working on visualizing data with charts and using PivotTables and PivotCharts.

Excel Advanced
In Excel Advanced, students will discover how to forecast data. Learn the advantages of working with multiple worksheets and workbooks in consolidating data and using lookup functions and formula auditing. This class will not only go through the automating workbook functionality but also give you the know how to share and protect workbooks and create Sparkline and mapping data. Pre-requisite: Excel Intermediate or equivalent knowledge.

Access Intermediate
This course will take you from knowing litle or nothing about databases and Access to a basic level of understanding. Topics include database concepts, databases and tables, fields and records, data entry rules, simple queries, using forms, creating and modifying reports, and much more. You'll practice what you learn in this hand-on course.

Access Advanced
Students will learn how to: query with SQL; use crosstab, parameter, and action queries, create and run macros; import, export, and link database objects; optimize, replicate, and synchronize databases; and maintain database security.