Pivot tables allow you to quickly organize and summarize information from large data groups. One of the important features of excel pivot tables is that it helps to create reports easily and efficiently. This can save you hours of hard work creating reports manually. Information from pivot tables can be used in various ways to…
This CETL session will cover the basics of accessibility in your online courses and documents that are provided to learners. This session will cover accessibility options in commonly used applications such as Microsoft Word, PowerPoint, and best practices to use when delivering your content. This presentation will have a small “hands on” segment that you…
In this CETL session, we will utilize basic Excel functions to create meaningful reports. We will walk through three basic projects using various Excel functions to format a student roster, analyze a gradebook, and construct a basic budget workbook. Define an Excel Worksheet VS Workbook Define a CSV File Identify the proper functions to create…
Unlock the power of mail merge in this hands-on Excel session. Discover how to effortlessly merge Excel data into Word documents to create personalized letters, address labels, certificates, invitations, and more. Whether you're a business professional, educator, or just want to streamline your personal communications, this session will equip you with the skills to save…
