Information Technology - Courses & Workshops
ACCPAC Accounting System
Learn how to use the ACCPAC Systems Manager, general ledger, accounts payable, accounts receivable and reporting functions in a hands-on learning environment. The course will also cover initial setup, entering transactions, preparing income and balance statements, as well as the daily, monthly and yearly processing routines.
Sage 50 Accounting
You will learn how Quickbooks can handle personal or small-business accounting. Topics covered include cash transactions, accruals, accounts payable, accounts receivable, reports and payroll.
You will discover some of the more advanced functions and capabilities of QuickBooks in this workshop. The curriculum will outline how to create company files and deal with advanced tasks for receivables, payables, inventory and payroll.
This course prepares you to take the assessment exam to qualify for a Professional Scrum Master Certification. If you plan to lead, participate in or support commercial Scrum projects, the session will provide you with an understanding of Scrum processes, roles and how they apply to software development.
14-week course or shorter workshop
This course introduces you to relational database concepts. Topics covered include creating a database; adding, displaying and editing records; data queries; sorting and indexing files; and creating forms and reports using built in "wizards."
Microsoft Access II
With your strong understanding of Access, this advanced course will explore application development using macros and visual basic code. Other course topics include macro versus module, debugging and error handling plus event-driven programming for applications.
Introduction to Microsoft Excel
Microsoft Excel Level II
Microsoft Excel Level III
This advanced Excel workshop aims to increase your productivity. You will collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.
Visual Basic Macro Programming II
If you have completed the Macro Programming course or workshop above, this course’s curriculum will continue the exploration of macro programming using VBA macro language in Microsoft Excel.
Macro Programming Level II
If you have completed the Macro Programming course or workshop above, this course’s curriculum will provide advanced learning in creating custom functions, manipulating workbooks (amalgamating multiple worksheets into one and removing unwanted rows or columns) and creating more advanced forms.
Power Pivot and Power Query
This workshop provides an introduction to the Power Pivot interface and teaches you how to import data from Excel and Access. You will also learn how to use Power Pivot to acquire and format data, translate data for export, and create and manage queries.
Power BI Desktop
In this course, you will learn to import data from multiple sources into the Power BI Desktop platform. From there, you will learn to model the data by creating relationships and how to append and merge that data. You will also learn to visualize the data by creating charts, score cards, dashboards and reports.
Turn your ideas into powerful and convincing presentations. In this course, you will learn to create, format, add graphical elements and prepare and deliver professional presentations.
Microsoft PowerPoint Level II
Create professional quality and customized presentations by learning to design templates, add special effects and use new and enhanced features to create dynamic and visually appealing presentations.
Microsoft Project I
Learn the basic concepts of Microsoft Project. You will create a project plan containing tasks, organize those tasks in a work breakdown structure containing task relationships, create and assign resources, finalize the project to implement the project plan and keep your projects on time and within budget.
Introduction to Microsoft Word
This introductory course covers creating, editing and printing documents using Microsoft Word. Learn how to make format changes; create tables and insert graphics; move and copy text; enhance documents using tabs, indents, page numbering, headers and footers; and explore Word's proofing tools.
Microsoft Word Level II Workshop
After taking the Introduction to Microsoft Word workshop above, this session will build on advanced concepts such as creating and using templates, formatting with styles and themes, mail merge and working with building blocks.
Microsoft Word Level III
Learn the advanced concepts of Microsoft Word such as managing long documents, collaborating with others and working with secure documents. You will also learn how to create forms for data entry, create master documents, work with document versions and other advanced tasks.
Create professional business intelligence dashboards using Tableau software's powerful features. You will learn how to connect to data, set up visuals, work with interactive dashboards and bring your data to life.
Adobe Photoshop Level I
Adobe Photoshop is the industry-leading standard in image-editing software. You will learn to develop workflow techniques that will maximize your creative potential and create powerful images for the web, a brochure or other business purposes.
Adobe Photoshop Level II
Take your Photoshop skills to the next level. In this workshop, you’ll learn advanced image-manipulation techniques and special effects that will increase your productivity and creative potential.
Introduction to Adobe Illustrator
Learn to use Adobe Illustrator to create graphics and fonts in a vector format that can be easily rescaled without the loss of quality. You’ll be instructed on using Illustrator to create graphics for different media such as print, web, interactive and video.
Adobe InDesign I
Explore the various elements of Adobe InDesign’s interface. You will learn to design professional documents such as advertisements, brochures, business cards and more, and prepare files for print and PDF distribution.
Adobe InDesign II
ove on to advanced InDesign techniques that will enhance the look and functionality of your documents. You will learn to manage long documents, handle page elements, work with styles and prepare document for print and PDF distribution.
Getting Started with WordPress
Take advantage of WordPress — a free, open-source tool that can polish your web presence with a fully functional look. This workshop will cover how to use the platform to create your own WordPress site or blog.
Hypertext - Internet
In this introductory workshop, you will learn the basics of how to use HTML and web standards to create modern web pages. This course will form the basis for an understanding of web technologies and enable you to build simple websites by hand.
Expand on your knowledge of websites by creating interactive forms and tables. Further exploration into cascading style sheets will enable you to format the contents of a website with ease and flexibility.
Web Page Design Level III
Learn advanced HTML5 markup and push the boundaries of Cascading Style Sheets (CSS). This workshop focuses on advanced layout with CSS. Attention will be paid to positioning, the box model and creating customizable and reusable styles to enhance your web site.
Web Page Design IV
This course is intended to teach expert-level professional cascading style sheets (CSS) techniques. Topics include complex layout, CSS-driven menus, conditional stylesheets, stylesheets documentation and efficiency/speed considerations. Particular focus will be paid to complex layout techniques including the box mode, floats, clears and browser inconsistencies.
This course will introduce you to the Dreamweaver interface. In the workshop, you will use Dreamweaver to write XHTML, work with Dynamic HTML, format text and create links. Images, tables, frames, forms and site management issues are also covered.
Building Mobile, Responsive Websites
Are your web designs accessible and functional on a variety of devices and browsers? Learn to plan beyond the desktop and build stunning designs that anticipate and respond to your users' needs. This workshop explores how to use HTML5 and CSS3 to create quality experiences no matter how large or small the display.
Search Engine Optimization (SEO) Basics
Take your website’s search engine rankings to the next level. This workshop will explain the algorithms that determine your rank as well as the optimization tactics you can implement to improve how your web pages stack up.
Digital Marketing Using Google AdWords
This course will orient you with the Google AdWords interface so that you can prepare and optimize a basic AdWords campaign. You will also learn to develop a keyword research plan, write effective ads and track and optimize a campaign’s performance.