"Everyday Excel, Part 3 (Projects)" is a continuation of "Everyday Excel, Parts 1 and Parts 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 two easy projects (chosen from four), two intermediate projects (chosen from 4), and three main (more difficult) projects (chosen from 7).
Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.
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 damatically reinforce the application of Excel tools, techniques, and functions to real-world projects.
What You Will Learn
- In this course, you'll apply Excel functions and tools to solving broad, somewhat open-ended problems through a wide variety of "guided" projects.
Course 3 of 3 in the Everyday Excel Specialization.
Syllabus
WEEK 1
Introduction and General Course Information
This module contains introductory information regarding the course requirements, how to obtain a Course Certificate, and information for Mac users.
WEEK 2
Warm-Up Projects (Choose Two)
For the Warm-Up Projects, you must select two of four projects to complete. If you are more math-inclined, you might appreciate the "Nearest Eighth of an Inch" and "Ladder Around the Corner" projects. If you are not so math-inclined, you will gravitate towards the "World Bank Lookup" and the "Dynamic Amortization Schedule" projects.
WEEK 3
Intermediate Projects (Choose Two)
Now that you're warmed up, let's transition to some more challenging projects! There are four possible projects for you to choose from for the Intermediate Projects, and you must complete two of them. The Sensitivity Analysis and Historical Weather Lookup (Part A) projects are perhaps the easier projects of the bunch, but the Dynamic Data Cleaning is not far behind. The Friday the 13th project is interesting but possibly a tad bit more challenging. Have fun!
WEEK 4
Main Projects (Choose Three)
Now for the heart of the course - the Main Projects! You'll implement many of the techniques and tools that you've learned in Parts 1 and 2 of "Everyday Excel". These projects are more involved than the intermediate projects. However, in many cases I provide significant hints and suggestions (mainly through screencasts). Therefore, I "guide" you through these projects. You'll be left with a proud, well-earned sense of accomplishment after having done these projects! There are 5 projects to choose from, and you need to complete 3 of them. Good luck!
WEEK 5
For Honors!
Are you chomping at the bit to apply more of your vast Excel knowledge to some more challenging problems?! If so, the Honors Certificate is for you! For Honors distinction on your Course Certificate, complete both projects. The Historical Weather Lookup (Part B) is a continuation of the Historical Weather Lookup (Part A), and Francesca's French Bakery is a tough one. Far less hints and tips are provided for these projects, so it is up to you to utilize what you've learned in these courses to solve these open-ended problems!
