Office Applications

This course is designed for the beginner Tableau user. It will help you understand and use the basic techniques for creating stylish visualizations and combining them in interactive dashboards that explain complexity with clarity. You will also learn effective data storytelling to transform how your business uses ideas and makes decisions. This class will explore all the new features in Tableau 10 and start to redefine what business analytics means to your organization. Prerequisite: Microsoft Excel. 1.2 CEUs.

Learn to create, edit, and modify spreadsheets. Basic formulas and functions will be introduced. This class moves at a quicker pace than our two-day classes. Prerequisite: Microsoft Windows. .6 CEUs.

Learn how to use advanced features of Excel including creating tables and charts, sorting and filtering advanced formulas; analysis tools including pivot tables. This class moves at a quicker pace than our two-day classes. Prerequisite: Microsoft Excel Level 1 in a Day. .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.