Office Applications

This continuing education course is designed for business professionals and office support staff pursuing professional development training in business technology and provides instruction on using Microsoft Excel 2019. Topics include the Excel interface, exploring shortcuts for efficiency, creating worksheets, charts and graphs, utilizing functions to determine formulas and statistics, and using macros. 1.8 CEUs.

Learn to create, edit, and modify spreadsheets. Basic formulas and functions will be introduced.  Prerequisite: Microsoft Windows. .6 CEUs.

Learn how to use advanced features of Excel including creating tables and charts, sorting and filtering advanced formulas, and analysis tools including pivot tables and charts. Prerequisite: Microsoft Excel in a Day. six hours. .6 CEUs. 

Learn how to work with multiple worksheets and workbooks; use lookup functions and formula auditing, apply data validation, create macros, data tables, and use What-If analysis. Prerequisite: Microsoft Excel Level 2. 12 hrs. 1.2 CEUs.

This course is intended for advanced Microsoft Excel professionals who need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA). Prerequisite: Excel Level 3. .6 CEUs.

Learn to create, edit, modify, and format documents; create tables and lists; and incorporate graphics. Prerequisite: Microsoft Windows. .6 CEUs.

In just a day, work with advanced tables, add graphics, and manipulate text and styles to enhance the design and layout of any project. Mail merge is not covered in this class. Prerequisite: Microsoft Word in a Day. .6 CEUs.

Learn advanced techniques for working with Word such as mail merge, creating forms, and writing simple macros. Use features associated with long documents such as table of contents, index, captions, table of figures, and cross references. Prerequisite: Microsoft Word Level 2. 6 hours .6 CEUs.

Create and modify presentation slides that combine text, clip art drawings, tables, charts, and graphs. Learn to run a basic PowerPoint presentation. Prerequisites: Microsoft Windows experience and basic knowledge of Microsoft Word. .6 CEUs.

Learn to build your own design template, create slides with special effects, apply audio and video files, and include hyperlinks on slides. Prerequisite: Introduction to PowerPoint or equivalent. .6 CEUs.