Spreadsheets: Advanced Functions and Features* Microcredential
Learn advanced concepts and applications of spreadsheets in business, health sciences, and service industries. In this on-demand, online course, 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.
Software: Windows version of Excel 365/Excel 2019/Excel 2021
Textbook: New Perspectives Excel 2021 ebook and homework platform (MindTap, ISBN 9780357671993) — $49.99 for five weeks of access or four full months for $124.99 (more economical if you plan to take the whole Spreadsheet series).
* Microcredentials marked with an asterisk are eligible for part-time TAP financial aid.
Credit or Non-Credit
Who is Eligible
Must have earned Spreadsheets: Tables, Pivots and Data Management badge or have approval from instructor
Time to complete
Business and Professional Studies
Skills You’ll Acquire
- Business Intelligence
- Cost-volume-profit analysis and what-if analysis
- Data Analysis
- Financial Functions
- Scenario Manager
- Using Solver for optimal solutions
Stackable to Credits
Individuals who complete all three non-credit microcredentials in the spreadsheet series (Spreadsheets: Fundamentals; Spreadsheets: Tables, Pivots, and Data Management; and Spreadsheets: Advanced Functions and Features) are eligible to receive course credit for:
- Complete Spreadsheets: Advanced Functions and Features with a grade of 75 or higher on comprehensive case study on advanced spreadsheet skills
Ready to find out more?
Get started by filling out the inquiry form below. A member from our Continuing Education team will promptly get in touch with you with instructions on how to register and help answer any questions you may have.