University of Colorado Boulder - Everyday Excel, Part 3 (Projects)
- Offered byCoursera
Everyday Excel, Part 3 (Projects) at Coursera Overview
Duration | 14 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Advanced |
Official Website | Explore Free Course  |
Credential | Certificate |
Everyday Excel, Part 3 (Projects) at Coursera Highlights
- Shareable Certificate Earn a Certificate upon completion
- 100% online Start instantly and learn at your own schedule.
- Course 3 of 3 in the Everyday Excel Specialization
- Flexible deadlines Reset deadlines in accordance to your schedule.
- Advanced Level A working knowledge of Excel is required, including dynamic array functions (Office 365). It is recommended to take Parts 1 and 2 of Everyday Excel.
- Approx. 14 hours to complete
- English Subtitles: English
Everyday Excel, Part 3 (Projects) at Coursera Course details
- "Everyday Excel, Part 3 (Projects)" is a continuation of "Everyday Excel, Parts 1 and 2". It is a capstone, projects-based course in which you will apply what you've learned previously to more complex, somewhat open-ended projects (open-ended with respect to the fact that they can be solved in multiple ways).
- Each learner must complete 3"warm-up" projects (chosen from 3), 3 intermediate projects (chosen from 6), and 3 main (more difficult) projects (chosen from 5). The projects have been created to span a wide range of interests and topic areas and are anticipated to appeal to diverse learner backgrounds.
- It is hoped that this project-based courses will dramatically reinforce the application of Excel tools, techniques, and functions to real-world projects.
Everyday Excel, Part 3 (Projects) at Coursera Curriculum
Introduction and General Course Information
Course Overview and Introduction
How to Switch Sessions of the Course
Is This Course For You?
Office 365 is Required For This Course!
Take Your Time!
For Mac Users
The Importance of a Course Certificate and the Future of Higher Education
Auditing the Course vs. Purchasing a Course Certificate
If you enjoy Excel... you'll love VBA!
How to Unlock the Course Files
Course Files
Unlock Quiz for Course Files
WARM-UP PROJECTS (Choose Three)
Nearest Eighth of an Inch Preview
World Bank Lookup Preview
Dynamic Amortization Schedule Hints and Preview
Introduction to Dynamic Array Functions
Longest Ladder Around the Corner Preview
Dynamic Temperature Lookup Preview
Introduction to Dynamic Array Functions
Nearest Eighth of an Inch Problem Statement
World Bank Lookup Problem Statement
Dynamic Amortization Schedule Problem Statement
Longest Ladder Around the Corner Problem Statement
Dynamic Temperature Lookup Problem Statement
Nearest Eighth of an Inch Submission Quiz
World Bank Lookup Submission Quiz
Dynamic Amortization Schedule Submission Quiz
Longest Ladder Around the Corner Submission Quiz
Dynamic Temperature Lookup Submission Quiz
INTERMEDIATE PROJECTS (Choose Three)
How to Perform a Sensitivity Analysis
Sensitivity Analysis Hints and Preview
Friday the 13th Preview
Dynamic Data Cleaning Preview and Hints
Introduction to Dynamic Array Functions
Filtering for Multiple Criteria
Historical Weather Lookup (Part A) Preview
Bakery Shopping List Preview
Dinner Sign-Up preview
An Introduction to Dynamic Array Functions
Sensitivity Analysis Problem Statement
Friday the 13th Problem Statement
Dynamic Data Cleaning Problem Statement
Historical Weather Lookup (Part A) Problem Statement
Bakery Shopping List Problem Statement
Dinner Sign-Up Problem Statement
Sensitivity Analysis Submission Quiz
Friday the 13th Submission Quiz
Dynamic Data Cleaning Submission Quiz
Historical Weather Lookup (Part A) Submission Quiz
Bakery Shopping List Submission Quiz
Dinner Sign-Up Submission Quiz
MAIN PROJECTS (Choose Three)
Distance Calculator Preview
Dealing with Multiple Table Lookups
How to Reset Conditional Drop-Down Lists
Rental Center Inventory Preview
An Introduction to Dynamic Array Functions
Dynamic Filtering for Multiple Constraints
How to Reset Conditional Drop-Down Lists
Matrix Approach to Regression, Part 1
Matrix Approach to Regression, Part 2
Real-Time Regression Preview
Dynamic Array Hints for Real-Time Regression
How to Calculate Standard Error and Adjusted R-Squared
Amortization Schedule with Extra Payments, Part 1
Amortization Schedule with Extra Payments, Part 2
Amortization Schedule with Extra Payments Preview
Historical Weather Lookup (Part B) Preview
To Get You Pumped Up for VBA (Preview for My Specialization "Excel/VBA for Creative Problem Solving")
Distance Calculator Problem Statement
Rental Center Inventory Problem Statement
Real-Time Regression Problem Statement
Amortization Schedule with Extra Payments Problem Statement
Historical Weather Lookup (Part B) Problem Statement
Distance Calculator Submission Quiz
Rental Center Inventory Submission Quiz
Real-Time Regression Submission Quiz
Amortization Schedule with Extra Payments Submission Quiz
Historical Weather Lookup (Part B) Submission Quiz
For Honors!
Francesca's French Bakery Preview
Top Hat Consolidator Preview
How to Calculate Column Averages of Dynamic Arrays
How to Earn an Honors Certificate
Francesca's French Bakery Problem Statement
Top Hat Consolidator Problem Statement
Honors Submission Quiz
Everyday Excel, Part 3 (Projects) at Coursera Admission Process
Important Dates
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?