Take your Microsoft Word skills to the next level in this intermediate course designed for users who are comfortable with the basics and ready to work more efficiently. Participants will explore advanced formatting techniques, styles and themes, tables, headers and footers, and document layout tools. The course will also introduce features such as track changes, comments, basic mail merge, and working with longer documents. Ideal for individuals looking to improve productivity and create more polished, professional documents for work or personal projects.

Refresh your Pediatric Advanced Life Support skills in this recertification course. Review current guidelines, practice essential interventions, and participate in hands-on pediatric emergency scenarios. Successful completion meets PALS renewal requirements.

Develop your understanding of how Excel uses logic with functions like AND, OR, COUNTIF, IF, and Nested IF. Perform calculations with SUMIF, AVERAGEIF, OR COUNTIF when a specific condition is met. Use VLOOKUP and XLOOKUP to search for specific information in a table. Find out how to name cells and ranges, and then use them in formulas. Learn how to link cells within worksheets and workbooks, and how to create 3D formulas across worksheets and workbooks. Locate errors by utilizing Auditing to find precedents and dependents related to a function. Enable the Watch Window to view out of sight cells. Use Data Validation to limit the type of data that can be entered into a cell and to create a drop-down list.

Learn how to use tables, pivot tables, and pivot charts to manage and analayze your data more effectively. Explore different ways to sort, filter, and subtotal data, as well as how to use VLookUp to search for specific information in a table. Learn how to utilize database functions within an Excel table and how to import an Acess database into Excel.

Celebrate the flavors of the season with a delicious lineup of light, bright, and refreshing dishes perfect for warm-weather dining. In this hands-on class, you’ll learn how to prepare a variety of summer-inspired appetizers, crisp salads, and flavorful side dishes that pair beautifully with backyard grilling, family gatherings, or weeknight meals. From fresh, seasonal produce to simple, creative techniques, you’ll leave with recipes and ideas that make summer cooking easy, colorful, and fun.