Interested in this College?
Get updates on Eligibility, Admission, Placements Fees Structure

Quick Facts

Medium Of Instructions	Mode Of Learning	Mode Of Delivery
English	Self Study	Video and Text Based

Course Overview

“Everyday Excel, Part 2” is the second part of the famous “Everyday Excel” training programme. Intensifying on the theories studied in the first course the learners will carry on expanding their knowledge in the uses of Excel. Although this training program is intended for intermediate users, advanced users too will benefit from it, in learning new tools and skills in Excel. After finishing this course, the candidates will possess enough skills to take up part 3 of the series Everyday Excel, which is project-based.

This specialisation series, which is divided into three parts aims to teach the candidates basic as well as advanced tools in Excel. This curriculum is intended to be intriguing and enjoyable. It aims to encompass a wide range of learners so that a variety of experiences and abilities come together to teach something new to everyone.

A distinctive characteristic of this course is the compulsion to complete weekly assignments in the application itself, i.e. in Excel, which will push students into hands-on learning.

The Highlights

Flexible deadlines
Project work and modules extending to twenty-two hours
Offered by University of Colorado Boulder

Programme Offerings

Instructor-led Training Programme
Practical Weekly Projects
quizzes
assignments

Courses and Certificate Fees

Certificate Availability	Certificate Providing Authority
yes	Coursera

Everyday Excel Part 2 fee details:

Head	Amount
1 Month	Rs. 4,023
3 Months	Rs. 8,046
6 Months	Rs. 12,069

Eligibility Criteria

Certification Qualifying Details

The participants, who will purchase the certificate insight of this course, will be awarded an accomplishment certificate upon the completion of this course. To get through every section, the candidates will be required to qualify a quiz and do an analytical assessment. A professional e-verified profile that will be shareable on the job providing platforms like LinkedIn will also be provided to the candidates.

What you will learn

Problem Solving AbilityKnowledge of Excel

Post completing this training programme Everyday Excel by the University of Colorado Boulder, the candidates will:

Able to understand and learn to use advanced tools of Excel
Excel in executing financial calculations through excel
Practice the techniques of data management (advanced)
Learn and gain exposure to use the regression tools to formulate predictive mathematical regression models
Become able to operate and solve out “what if” analyses through advanced tools of Excel such as Goal Seek, Solver and Data Tables

Who it is for

Chartered AccountantAccountantData AnalystData ScientistIT EngineerData Engineer

The Everyday Excel, Part 2 training programme is aimed at both beginner and intermediate audiences. The following categories should apply for this course :

Students
Novices of computer operation who wish to acquire a good job
Professionals who want to upgrade their skills

Admission Details

The Everyday Excel, Part 2 admission process is very easy and straightforward. The applicants should keep their billing details and payment method ready.

Step 1: Visit the course page. https://www.coursera.org/learn/everyday-excel-part-2#about

Step 2: In the search bar, search for the Everyday Excel training course offered by the University of Colorado Boulder.

Step 3: Opt for Everyday Excel, Part 2.

Step 4: Login/ Register with your Coursera account.

Step 5: Select if you want to audit the course for free or earn a certificate by purchasing the course.

Step 6: If you have chosen to purchase the course, make the bill payment process and you will get access to the course.

If you have chosen for audit mode, you are already enrolled in the course!

The Syllabus

Videos

How to Switch Sessions of the Course
Week 1 preview
(OPTIONAL): Review of VLOOKUP, MATCH, INDEX, and OFFSET functions
Two-way lookups in Excel
Two-way conditional lookups
Finding the location of a maximum
Conditional drop-down lists (data validation)
Conditional formatting based on formula
Example: Conditional formatting to identify errors
Comparing lists
Example: Who hasn't signed up?
Managing duplicates, Part 1
Managing duplicates, Part 2
Example: Expiry dates
Most frequent text
Assignment 1 preview and instructions
More about the OFFSET function

Readings

The Power of Microsoft Excel
The importance of a Course Certificate and the future of higher education
Auditing the course vs. purchasing a Course Certificate
What version of Excel do you need for this course?
For Mac users
If your computer won't open a macro-enabled workbook
Week 1 Excel files
Quiz 1 solutions and explanations
Assignment 1
Week 2 Excel files

Practice Exercises

Unlock quiz for Week 1 files
Quiz 1
Assignment 1 submission

Videos

Week 2 Preview
Customizing Excel for financial applications
Time value of money
Simple and compound interest, Part 1
Simple and compound interest, Part 2
Amortized loans
Using Excel to create an amortization schedule
Amortization schedule with extra payments
Effective vs. nominal interest rate
Savings accounts with payments and disbursements
Interest-only loans
Lines of credit
Assignment 2 preview and instructions

Readings

Quiz 2 instructions
Quiz 2 solutions and explanations
Assignment 2
Week 3 Excel files

Practice Exercises

Quiz 2
Assignment 2 submission

Videos

Week 3 Preview
Depreciation
Common depreciation methods, Part 1
Common depreciation methods, Part 2
Cash flows and net present value, Part 1
Cash flows and net present value, Part 2
Comparing alternatives
Internal rate of return (IRR)
More about the OFFSET function
Assignment 3 preview and instructions

Readings

Quiz 3 instructions
Quiz 3 solutions and explanations
Assignment 3
Week 4 files

Practice Exercises

Quiz 3
Assignment 3 submission

Videos

Week 4 Preview
Introduction to case studies
One-way Data Tables, Part 1
One-way Data Tables, Part 2
Two-way Data Tables
Example: Two-way Data Table
Goal Seek and Solver for targeting problems, Part 1
Goal Seek and Solver for targeting problems, Part 2
Solver for optimization problems
Using the Solver with constraints, Part 1
Using Solver with constraints, Part 2
Assignment 4 preview and instructions

Readings

Quiz 4 instructions
Quiz 4 solutions and explanations
Assignment 4
Week 5 Excel files

Practice Exercises

Quiz 4
Assignment 4 submission

Videos

Week 5 Preview
Trendlines, Part 1
Trendlines, Part 2
Linear interpolation
Model building, Part 1: Simple linear regression
Model building, Part 2: General linear regression
Model building, Part 3: Multilinear regression
(OPTIONAL) Why use adjusted R-squared and not R-squared?
Introduction to nonlinear regression (logistic regression)
Assignment 5 preview and instructions

Readings

Quiz 5 instructions
Quiz 5 solutions and explanations
Assignment 5
Be on the lookout for Part 3!

Practice Exercises

Quiz 5
Assignment 5 submission

Evaluation process

The candidates of this course are required to submit the weekly quizzes (after each module) and do analytical assessments, on the basis of which they will be graded.

Instructors

CU Boulder Frequently Asked Questions (FAQ's)

1: Will the candidate get University credit with the course?

This course does not provide University credit. However, some universities might consider certificates of training programmes as a credit during admissions. Contact your university for the same.

2: What extra benefits will I get if I purchase the course?

Those candidates who will purchase this course will get access to graded assignments and also earn a professional e-certificate, which will be shareable, upon the completion of this course.

3: I am a beginner in MS Excel. Will this course benefit me in any way?

Yes, the level of this course is intermediate. However, beginners too will have no problem in understanding the concepts as this course is aimed both at the beginners and intermediates. You are advised to take up part 1 of this series first, which is for beginners.

4: Is MS Excel an important skill?

MS Excel is something that is used in all workspaces, be them domestic or big MNCs and corporations. It has become a mandatory skill for most job profiles these days.

5: Is this course worth taking?

Definitely. Nine thousand plus learners have already enrolled for this course and have reported positive outputs and visible benefits like payrise and promotions, in their careers.

6: What kind of assignments will be there at the end of each module?

At the end of each module, mastery quizzes are provided which need to be submitted by the candidates. Problem-solving assessments are also to be done and submitted.

7: Does Coursera provide a job?

No, Coursera provides you with courses and training programmes which make you able and suited for good profile jobs in the industry.

8: What are the prerequisites a candidate needs to fulfill to be able to apply for this course?

There are no defined eligibility parameters for this course. Anybody who wishes to learn Ms. Excel or to upgrade their existing skills to get better placements in the market can apply for this course.

9: Will only meritorious students get the certificate?

No, all the students will get an accomplishment certificate on successful completion of the course.