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 | CU BoulderCoursera |
Everyday Excel Part 2 fee details:
Head | Amount |
1 Month | Rs. 4,115 |
3 Months | Rs. 8,230 |
6 Months | Rs. 12,345 |
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
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
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
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.
Or
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
Assignments
- Unlock quiz for Week 1 files
- Quiz 1
- Assignment 1 submission
Discussion Prompts
- What about you?
- Assignment 1 discussion
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
Assignments
- Quiz 2
- Assignment 2 submission
Discussion Prompt
- Assignment 2 discussion
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
Assignments
- Quiz 3
- Assignment 3 submission
Discussion Prompt
- Assignment 3 discussion
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
Assignments
- Quiz 4
- Assignment 4 submission
Discussion Prompt
- Assignment 4 discussion
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!
Assignments
- Quiz 5
- Assignment 5 submission
Discussion Prompt
- Assignment 5 discussion
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)
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.
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.
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.
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.
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.
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.
No, Coursera provides you with courses and training programmes which make you able and suited for good profile jobs in the industry.
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.
No, all the students will get an accomplishment certificate on successful completion of the course.