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.”
Have you taken this course or an equivalent course? Contact the Credit Transfer Office.
Not all courses are offered each term.
Fall 2024 registration opens July 22, 2024. Winter 2025 registration opens November 4, 2024.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