Everyday Excel Part 2
Master Microsoft Excel, through this course by University of Colorado Boulder, USA, on Coursera.
Intermediate
Online
2 Weeks
1,914 INR 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 |
Fee | Rs. 1914/Month |
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
- Welcome to Part 2 of Everyday Excel!
- What Is an Array in Excel?
- What Are Dynamic Array Functions?
- Dynamic Array Formulas Don’t Work Inside Excel Tables
- SORT and SORTBY
- The SORT/UNIQUE Combination
- Randomizing a List
- Sorting by a List
- The FILTER Function
- Example: Who Earned a Bonus?
- Example: A Filtered Checklist
- Example: Filtering for Snowy Days
Readings
- Course Updates and Accessibility Support
- Microsoft 365 is Required for This Course
- The Power of Microsoft Excel
Assignments
- Module 1 Quiz
programming assignments
- Filtering and Sorting Area Codes
- Filtering and Sorting Error Codes
Videos
- The SEQUENCE and RANDARRAY Functions
- The HSTACK and VSTACK Functions
- The DROP and TAKE Functions
- The CHOOSECOLS and CHOOSEROWS Functions
- Examples: The CHOOSECOLS Function
- The TOCOL and TOROW Functions
- The WRAPCOLS and WRAPROWS Functions
- The BYCOL and BYROW Functions
- Example: Copy Machine Sales
- Example: Averaging Grades by Category
Assignments
- Module 2 Quiz
programming assignments
- Team Builder
- Bookstore Orders
Videos
- Review of Lookup Functions
- Using the FILTER Function for Multiple Matches
- Referencing an Entire Row or Column of an Array
- Two-Way Forward Lookups, Part 1
- Two-Way Forward Lookups, Part 2
- Top 3 or Bottom 3
- Example: Top 5 Hottest and Coldest Days
- Reverse Lookups
- Example: Max Sales Lookup
- Two-Way Reverse Lookups, Part 1
- Two-Way Reverse Lookups, Part 2
- Example: Yearly Max and Top 5 Using TOCOL
- Example: Yearly Max and Top 5 Using Power Query
programming assignments
- Order ID and Customer Lookup
- Cheese Consumption
Assignments
- Module 3 Quiz
Videos
- Filtering for Multiple Criteria
- Example: Filtering Company Transactions
- Example: Filtering Job Applicants for Multiple Criteria
- Example: Identifying Temperature Excursions
- Conditional Counting or Summing in the Same Column
- Conditional Formatting for Two-Way Lookups
- Conditional Drop-Down Lists (Data Validation)
- Example: Dinner Sign-Up
- Comparing Lists
- Who Hasn't Signed Up?
- Randomizing: Repeats Allowed
- Randomizing: Repeats Not Allowed
- Repeating Arrays and Sequences
- Randomizing Blocks of Similar Items
- Example: Randomized Schedule Maker
- Bike Inventory Assignment Preview and Hints
Assignments
- Module 4 Quiz
programming assignments
- Bike Inventory
- Transaction Audit
Videos
- Introduction to the World Development Indicators Dashboard
- Step 1: Data Retrieval
- Step 2: Data Processing
- Step 3: Electricity Data vs. Time
- Step 4: Electricity and Energy Breakdown for a Specific Year
- Step 5: Top 5 Electric Power Consumption and Energy Use
Readings
- Web Link to World Development Indicators Data
Assignments
- Module 5 Quiz
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.