Excel Spreadsheets: Advanced Functions & Features
SUNY Broome
Course Details
The Excel Spreadsheets: Advanced Functions and Features course covers advanced concepts and applications of spreadsheets in business, health sciences, and service industries. Students will use Excel to explore the principles of cost-volume-profit analysis, create one and two variable data tables, create and apply scenarios with Scenario Manager, use Solver to calculate optimal solutions, work with financial functions, and analyze data with business intelligence tools.
Students who complete this course with satisfactory scores on assessments will be eligible for the Spreadsheets: Advanced Functions and Features badge. Students must have a strong background in Excel before taking this course. Excel Spreadsheets: Fundamentals and Excel Spreadsheets: Tables, Pivots, and Data Management are highly recommended as prerequisites
Software: Windows version of Excel 365/Excel 2019/Excel 2021
Textbook: TBA
After This Course, You Will Be Able ToWork with financial tools and functions Perform cost-volume-profit analysis and what-if analysis Find optimal solutions using Solver Work with the basic concepts of business intelligence including PowerPivot and mapsSkills you will learn
Knowledge Outcomes and Experience
Eligibility
Students must have a strong background in Excel before taking this course. Excel Spreadsheets: Fundamentals and Excel Spreadsheets: Tables, Pivots, and Data Management are highly recommended as prerequisites.
