Buy Now AED 170.99 + VAT

Monthly Subscription Starting at AED 99 + VAT

Everyday Excel, Part 3 (Projects)
  • Level Expert
  • Duration 14 hours
  • Course by University of Colorado Boulder
  • Offered by

About

"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.

Modules

Basic Course Information

    • 2 Videos
    • 12 Readings
    • 1 Discussion
    • 1 Assignment
Show info about module content

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
Show info about module content

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
Show info about module content

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
Show info about module content

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
Show info about module content

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
Show info about module content

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
Show info about module content

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
Show info about module content

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
Show info about module content

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
Show info about module content

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
Show info about module content

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
Show info about module content

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
Show info about module content

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
Show info about module content

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
Show info about module content

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
Show info about module content

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
Show info about module content

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
Show info about module content

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
Show info about module content

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
Instructor

Charlie Nuttelman