COM4121 - Microsoft 365 Excel: Part 3

Kauai Community College - Continuing Education

Validation error

You must correct the following errors to continue:

The current information for the selected course has expired. To see the latest information, please search for this course again, then proceed with your enrollment.

Course Description

This is the third part of our Microsoft 365 Excel courseware -Excel is Microsoft’s powerful and easy-to-use spreadsheet program. This new version of Excel incorporates some new features and connectivity to make collaboration and production as easy as possible. This course is intended to help all users get up to speed quickly on the advanced features of Excel. We will cover: • Using Excel Online • Worksheet Automation • Auditing and Error Checking • Data Analysis and Presentation • Working with Multiple Workbooks • Exporting and Sorting Data

Course Outline

Lesson 1: Excel Online

Lesson 2: Worksheet Automation

Lesson 3: Auditing and Error Checking

Lesson 4: Data Analysis and Presentation

Lesson 5: Working with Multiple Workbooks

Lesson 6: Exporting and Sourcing Data

Learner Outcomes

By the end of this course, users should be comfortable in both the online and desktop environments, using automating functions, analyzing and presenting data, auditing and error checking your work, working in multiple workbooks, and accessing and distributing data.

Notes

Kaua‘i Community College is committed to ensuring the health and safety of our faculty, staff, and students. UH’s COVID-19 policies apply to Kauai Community College’s Office of Continuing Education and Training students.

As of January 3, 2022, all students who plan to be on campus must be fully vaccinated OR have an approved medical or religious exemption. All students attending IN-PERSON classes must check in to the UH LumiSight App each time they come to campus. Students who are not vaccinated must be approved for an exemption from the COVID-19 vaccination; exemption requests must be submitted at least 10 business days prior to the first day of class. Students with approved exemptions must also test weekly and submit those results via the UH LumiSight App.

More information can be found on the University of Hawai’i, COVID-19 Vaccination Requirement for Students FAQs page.

EXEMPTION REQUESTS:

OVPCC Academic Affairs created a new form and workflow for noncredit students requesting a COVID vaccination exemption request. Students may submit a request prior to or after registration. However, the request must be submitted 10 days prior to the first day of class. OVPCC Academic Affairs will evaluate the requests within 3-5 days. Students will be notified of the outcome of their request. Campuses will receive a notification when a student has been approved for an exemption.

Students who have an approved exemption must submit weekly COVID test results to UH via the UH LumiSight App. Students are responsible for their own testing.

Kaua'i Community College is committed to providing all students with equitable access to its programs and services. For disability accommodations, contact our Disabilities Services Coordinator at (808) 245-8314. Individuals with disabilities are encouraged to contact our Disabilities Services Coordinator well before the registration deadline to provide ample time to review and verify requests.

Prerequisites

Registration assumes the user has completed, or has an understanding of the materials covered, in the first and second parts of the Microsoft Office Excel 365 courseware, including: • Excel basics • Working with data • Modifying worksheets • Printing workbook contents • Managing large workbooks • Customizing the Excel environment • Creating advanced formulas • Analyzing data with logical and lookup functions • Organizing worksheets data with tables • Visualizing data with charts • Analyzing data with PivotTables, slicers, and PivotCharts • Working with graphical objects • Enhancing workbooks

Recommendations

Course Prerequisites Registration assumes the user has completed or has an understanding of the materials covered, in the first and second parts of the Microsoft Office Excel 365 courseware, including: • Excel basics • Working with data • Modifying worksheets • Printing workbook contents • Managing large workbooks • Customizing the Excel environment • Creating advanced formulas • Analyzing data with logical and lookup functions • Organizing worksheets data with tables • Visualizing data with charts • Analyzing data with PivotTables, slicers, and PivotCharts • Working with graphical objects • Enhancing workbooks