Filter by Subcategory
Personal Enrichment Courses
Introduction to Excel
with Tina Aldrich
Become more familiar with what Excel can do in this introductory course. Learn how to create an Excel workbook, select and move around in a workseet, format, work with simple formulas and fuctions, create tables and charts, and explore templates
Complete Cuisine: Crafting a Three-Course Feast
with Hakim Salaam
Learn to master the art of crafting a complete three-course meal. From tantalizing starters to delectable desserts, you'll explore essential techniques in preparation, plating, and presentation. Under the guidance of Chef Hakim, discover how to balance flavors, textures, and presentation for a truly unforgettable dining experience. Whether you're a beginner or a seasoned home cook, join us for an evening of culinary creativity.
Advanced Excel-Pivot Tables-Monroe
with Susan Dunphy
With 1,048,576 rows and 16,384 columns, Excel can store a lot of information! Find out how pivot tables and pivot charts can help organize your data and find what you need. Learn how to create pivot tables and pivot charts to help summarize, analyze, and manipulate data in a variety of ways. Utilize pivot tables and pivot charts to create dashboards to display an overview of a workbook showing the vital parts of the data in one worksheet.
Intermediate Excel: Working with More Complex Formulas and Functions-Janesville
with Tina Aldrich
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.
Holiday Dessert Favorites
with Hakim Salaam
Chef Hakim will guide you through essential techniques and festive recipes guaranteed to impress family and friends. Whether you're baking for gifts or gatherings, this course will equip you with the skills and inspiration to spread joy through delicious homemade treats. Get ready to sprinkle some holiday magic into your baking!