Course description

Students will use Microsoft Excel as a data analytics tool to create workbooks that use advanced functions in to analyze financial and non-financial data. This includes the retrieval, synthesis, and analysis of large datasets. Understanding end-user requirements will be a primary consideration to ensure the objectives of analysis are satisfied while using best practices regarding data management to ensure data integrity. Students will have an opportunity to prepare financial statements, perform trend analysis, use pivot tables, chart financial data, use business intelligence tools, and develop an Excel application. The material covered in this course, including macro creation, will enhance the ability of the student to create and streamline accounting workbooks for optimal control, ease of use, and report design. As part of this course students will have covered all topics for the Microsoft Office Specialist Exam: “Excel Expert: Interpreting data for Insights.”

Course details

Hours: 56
Credits: 4
Prerequisites: ACCT1345
Corequisites: None

Build courses into a credential

This course is part of the following program(s):


Credit transfer

Have you taken this course or an equivalent course? Contact the Credit Transfer Office.

Registration dates

Not all courses are offered each term.

Fall 2024 registration opens July 22, 2024. Winter 2025 registration opens November 4, 2024.

Delivery options

In person: classes held in person on a campus/site in a classroom/lab/shop/studio for the course duration

Online - Asynchronous: ​100% online delivery, no scheduled day or time course requirements with the instructor, assigned due dates

Online - Synchronous: 100% online delivery, scheduled day and time course requirements with the instructor, assigned due dates

Hybrid: any combination of in person, timetabled, on campus, online, and hyflex delivery