COM4110 - Microsoft 365 Excel: Part 2

Course Description

This version of Excel incorporates some new features and connectivity options in effort to make collaboration and production as easy as possible.

This course is intended to help all users become familiar with the more advanced selection of features of Excel. We will cover how to create and use advanced formulas, analyze data, organize worksheet data with tables, visualize data with charts, work with graphical objects, and enhance workbooks.

Course Outline

This course is intended to help all users become familiar with the more advanced selection of features of Excel. We will cover how to create and use advanced formulas, analyze data, organize worksheet data with tables, visualize data with charts, work with graphical objects, and enhance workbooks.Creating Advanced Formulas-In this lesson, students will learn how to use range names in formulas and functions, as well as how to use specialized functions.

• Analyzing Data with Logical and Lookup functions-Next, students will learn how to analyze data by using text, logical, lookup, date and financial functions.
• Organizing Worksheet Data with Tables-This lesson covers how to create, format, and modify tables. We also cover using structured references, as well as the subtotal and database functions.
• Visualizing Data with Charts-Students will learn how to create charts, as well as how to modify and format existing charts. They will also learn how to create a trendline and advanced charts.
• Analyzing Data with PivotTables, Slicers, and PivotCharts-Creating a PivotTable, filtering data using slicers and, analyzing data using PivotCharts will be covered in this lesson.
• Working with Graphical Objects 
• Next, students will learn how to insert, modify, layer, and group graphical objects. We will also take a look at how to incorporate SmartArt into workbooks.
• Enhancing Workbooks-In this final lesson, students will learn how to customize workbooks, manage themes, protect files and, prepare a workbook for multiple audiences.

Learner Outcomes

By the end of this course users should be comfortable in creating advanced formulas, analyzing data with functions, analyzing data using functions and PivotTables, working with tables, visualizing data with charts, working with graphical objects, and enhancing workbooks.

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.