Everyday Excel, Part 3 (Projects)
"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).
Buy Now AED 170.99 + VAT
Monthly Subscription Starting at AED 99 + VAT
- Level Expert
- المدة 14 ساعات hours
- الطبع بواسطة University of Colorado Boulder
-
Offered by
عن
"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.الوحدات
Basic Course Information
-
2
Videos
-
12
Readings
-
1
Discussion
-
1
Assignment
1
Assignment
- Unlock Quiz for Course Files
1
Discussions
- (OPTIONAL) What about you?
2
Videos
- Course Overview and Introduction
- How to Switch Sessions of the Course
12
Readings
- Is This Course For You?
- Subscribe to "Everyday Excel VBA" YouTube Channel!
- 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
- How to get help
- If you enjoy Excel... you'll love VBA!
- How to Unlock the Course Files
- Opening macro-enabled workbooks
- Course Files
Nearest Eighth of an Inch
-
1
Videos
-
1
Readings
-
1
Discussion
-
1
Assignment
1
Assignment
- Nearest Eighth of an Inch Submission Quiz
1
Discussions
- Nearest Eighth of an Inch
1
Videos
- Nearest Eighth of an Inch Preview
1
Readings
- Nearest Eighth of an Inch Problem Statement
World Bank Lookup
-
1
Videos
-
1
Readings
-
1
Discussion
-
1
Assignment
1
Assignment
- World Bank Lookup Submission Quiz
1
Discussions
- World Bank Lookup
1
Videos
- World Bank Lookup Preview
1
Readings
- World Bank Lookup Problem Statement
Dynamic Amortization Schedule
-
2
Videos
-
1
Readings
-
1
Discussion
-
1
Assignment
1
Assignment
- Dynamic Amortization Schedule Submission Quiz
1
Discussions
- Dynamic Amortization Schedule
2
Videos
- Dynamic Amortization Schedule Hints and Preview
- Introduction to Dynamic Array Functions
1
Readings
- Dynamic Amortization Schedule Problem Statement
Longest Ladder Around the Corner
-
1
Videos
-
1
Readings
-
1
Discussion
-
1
Assignment
1
Assignment
- Longest Ladder Around the Corner Submission Quiz
1
Discussions
- Longest Ladder Around the Corner
1
Videos
- Longest Ladder Around the Corner Preview
1
Readings
- Longest Ladder Around the Corner Problem Statement
Dynamic Temperature Lookup
-
2
Videos
-
1
Readings
-
1
Assignment
1
Assignment
- Dynamic Temperature Lookup Submission Quiz
2
Videos
- Dynamic Temperature Lookup Preview
- Introduction to Dynamic Array Functions
1
Readings
- Dynamic Temperature Lookup Problem Statement
Sensitivity Analysis
-
2
Videos
-
1
Readings
-
1
Discussion
-
1
Assignment
1
Assignment
- Sensitivity Analysis Submission Quiz
1
Discussions
- Sensitivity Analysis
2
Videos
- How to Perform a Sensitivity Analysis
- Sensitivity Analysis Hints and Preview
1
Readings
- Sensitivity Analysis Problem Statement
Friday the 13th
-
1
Videos
-
1
Readings
-
1
Discussion
-
1
Assignment
1
Assignment
- Friday the 13th Submission Quiz
1
Discussions
- Friday the 13th
1
Videos
- Friday the 13th Preview
1
Readings
- Friday the 13th Problem Statement
Dynamic Data Cleaning
-
2
Videos
-
1
Readings
-
1
Discussion
-
1
Assignment
1
Assignment
- Dynamic Data Cleaning Submission Quiz
1
Discussions
- Dynamic Data Cleaning
2
Videos
- Dynamic Data Cleaning Preview and Hints
- Introduction to Dynamic Array Functions
1
Readings
- Dynamic Data Cleaning Problem Statement
Historical Weather Lookup (Part A)
-
2
Videos
-
1
Readings
-
1
Discussion
-
1
Assignment
1
Assignment
- Historical Weather Lookup (Part A) Submission Quiz
1
Discussions
- Historical Weather Lookup (Part A)
2
Videos
- Filtering for Multiple Criteria
- Historical Weather Lookup (Part A) Preview
1
Readings
- Historical Weather Lookup (Part A) Problem Statement
Bakery Shopping List
-
1
Videos
-
1
Readings
-
1
Assignment
1
Assignment
- Bakery Shopping List Submission Quiz
1
Videos
- Bakery Shopping List Preview
1
Readings
- Bakery Shopping List Problem Statement
Dinner Sign-Up
-
2
Videos
-
1
Readings
-
1
Discussion
-
1
Assignment
1
Assignment
- Dinner Sign-Up Submission Quiz
1
Discussions
- Dinner Sign-Up
2
Videos
- Dinner Sign-Up preview
- An Introduction to Dynamic Array Functions
1
Readings
- Dinner Sign-Up Problem Statement
Distance Calculator
-
3
Videos
-
1
Readings
-
1
Discussion
-
1
Assignment
1
Assignment
- Distance Calculator Submission Quiz
1
Discussions
- Distance Calculator
3
Videos
- Distance Calculator Preview
- Dealing with Multiple Table Lookups
- How to Reset Conditional Drop-Down Lists
1
Readings
- Distance Calculator Problem Statement
Rental Center Inventory
-
4
Videos
-
1
Readings
-
1
Discussion
-
1
Assignment
1
Assignment
- Rental Center Inventory Submission Quiz
1
Discussions
- Rental Center Inventory
4
Videos
- Rental Center Inventory Preview
- An Introduction to Dynamic Array Functions
- Dynamic Filtering for Multiple Constraints
- How to Reset Conditional Drop-Down Lists
1
Readings
- Rental Center Inventory Problem Statement
Real-Time Regression
-
5
Videos
-
1
Readings
-
1
Discussion
-
1
Assignment
1
Assignment
- Real-Time Regression Submission Quiz
1
Discussions
- Real-Time Regression
5
Videos
- 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
1
Readings
- Real-Time Regression Problem Statement
Amortization Schedule with Extra Payments
-
3
Videos
-
1
Readings
-
1
Discussion
-
1
Assignment
1
Assignment
- Amortization Schedule with Extra Payments Submission Quiz
1
Discussions
- Amortization Schedule with Extra Payments
3
Videos
- Amortization Schedule with Extra Payments, Part 1
- Amortization Schedule with Extra Payments, Part 2
- Amortization Schedule with Extra Payments Preview
1
Readings
- Amortization Schedule with Extra Payments Problem Statement
Historical Weather Lookup (Part B)
-
1
Videos
-
1
Readings
-
1
Discussion
-
1
Assignment
1
Assignment
- Historical Weather Lookup (Part B) Submission Quiz
1
Discussions
- Historical Weather Lookup (Part B)
1
Videos
- Historical Weather Lookup (Part B) Preview
1
Readings
- Historical Weather Lookup (Part B) Problem Statement
Expand your repertoire of Excel skills with VBA!
-
1
Videos
1
Videos
- To Get You Pumped Up for VBA (Preview for My Specialization "Excel/VBA for Creative Problem Solving")
For Honors
-
3
Videos
-
3
Readings
-
2
Discussion
-
1
Assignment
1
Assignment
- Honors Submission Quiz
2
Discussions
- Francesca's French Bakery
- Top Hat Consolidator
3
Videos
- Francesca's French Bakery Preview
- Top Hat Consolidator Preview
- How to Calculate Column Averages of Dynamic Arrays
3
Readings
- How to Earn an Honors Certificate
- Francesca's French Bakery Problem Statement
- Top Hat Consolidator Problem Statement
Auto Summary
"Everyday Excel, Part 3 (Projects)" is an expert-level course in IT & Computer Science offered by Coursera. It focuses on applying Excel tools and techniques to real-world, complex projects. Learners will complete nine projects, ranging from warm-up to advanced, across diverse topics. The course spans 840 minutes and offers Starter, Professional, and Paid subscription options, ideal for those seeking hands-on Excel experience.
Charlie Nuttelman