Embedded Files
Course Overview
Course Overview
From teaching how to create an IF function to recording and running macros, Spreadsheets II focuses on advancing the skills and concepts learned previously and expands them, making use of more complex functions and formulas. In understanding the more advanced and mathematical functions of a spreadsheet, you can create a working database that can forecast and store information for businesses or other organizations, and run programs that protect the privacy of any records entered into them.
Learning Outcomes
Learning Outcomes
Design and construct professional worksheets and be able to generate and run reports from multiple workbooks.
Demonstrate an understanding of how to manage information and data with data tools.
Demonstrate an understanding of Pivot Tables and Charts and be able to summarize data using them.
Demonstrate an understanding of the use of forecasting and what-if scenarios for exploring future business options and opportunities.
Demonstrate and understanding of and ability to utilize macros to perform functions and scenarios in various applications.
Learning Outcomes courtesy of the Nova Scotia Community College Spreadsheets II Course Outline.
Page updated
Google Sites
Report abuse