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 little 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 with forms, working with large documents, creating macros, customizing menus and toolbars, using XML features, and sharing Word documents. Pre-requisite: Word Intermediate or equivalent knowledge.

PowerPoint Intermediate

Learn to deliver presentations across multiple 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 little 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.