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

The Everyday Excel, Part 1 programme is highly suitable for candidates who want to understand and learn the functionalities of excel. While the certification course is primarily designed for first-timer learners, advanced excel users can surely learn some new skills and tools. Moreover, the Everyday Excel, Part 1 online course is the first part of a three-course structure.

The Everyday Excel, Part 1 training course is a 5-week programme, in which candidates learn a wide variety of tools and techniques of an advanced level, which will help you navigate around the Excel system efficiently. You will learn how to edit and format excel worksheets and implement essential, as well as advanced excel functions, such as financial, text, and logical functions.

Moreover, Charlie Nuttleman instructs the Coursera Everyday Excel, Part 1 programme, while the University of Colorado Boulder, which is known for its superior academic quality, offers the course. Finally, once candidates finish the training course successfully, they receive a course completion certificate from Coursera.

The Highlights

Beginner level course
Readings for every module
Self-paced learning
Hands-on training
Shareable certificate by Coursera
Financial assistance
Flexible assignment deadlines
English subtitles
Practice exercises
Quizzes
Tangible Career Benefits

Programme Offerings

Practice Exercises
Flexible Deadlines
Introductory Excel Course
video transcript
100% online course
Self-paced learning
Course completion certificate
Weekly Assignments

Courses and Certificate Fees

Certificate Availability	Certificate Providing Authority
yes	Coursera

The Everyday Excel, Part 1 certification fee is decided based on the number of hours, of course, opted for by the participants.

Everyday Excel, Part 1 Fees Structure

Description	Amount in INR
Fee for 1-month	Rs. 4,001
Fee for 3-month	Rs. 8,003
Fee for 6-month	Rs. 12,004

Eligibility Criteria

Because the Everyday Excel, Part 1 programme is a beginner’s level course, candidates need not have any prior knowledge about Excel. They only require a computer or laptop with a good internet connection to complete the certification course.

What you will learn

Knowledge of Data VisualizationKnowledge of Excel

The Everyday Excel, Part 1 online training provides in-depth knowledge about the following:

Learn to navigate the Excel environment efficiently
How to understand and apply the various functionalities offered by excel
Be able to efficiently manage data with the use of multiple data analysis tools in Excel
Use complex Excel functions to perform calculations easily
Create spreadsheets and build great charts if you are a business user

Who it is for

Research AssociateMarket Research Analyst

The Everyday Excel, Part 1 training course is suitable for anyone who wishes to learn about the various functionalities provided by excel.

Admission Details

Candidates who want to enrol for the Everyday Excel, Part 1 course by Coursera may follow the steps mentioned below to apply:

Go to the Coursera webpage.
You can find the course by typing in the course name “Everyday Excel, Part 1” in the search bar at the top of the course page.
Click on the “Join for Free” button.
Finally, create an account on Coursera or login using your Google, Facebook, or Apple id. If you have already registered, simply log in and enrol for the course.

Application Details

There is no application form to apply for the Everyday Excel, Part 1 online course. You can simply join for free by signing up using your existing Google or Facebook account to access the learning material.

The Syllabus

Videos

Welcome to Everyday Excel
What will I learn in the course?
How to Switch Sessions of the Course
Week 1 preview
Basic features of Excel
Saving and opening files
Sheets, cells, rows and columns: Part 1
Sheets, cells, rows and columns: Part 2
Moving around the worksheet
Editing the worksheet
Cell formatting and conditional formatting
Auto Fill and Fill Series
OPTIONAL Example: Gantt Chart
Formats for numbers, dates, and times
Cell addressing modes
Naming cells and cell ranges
Introduction to VBA macros
Excel is smart! (Quick Analysis tool and Ideas tool)
Setting preferences in Excel
Customizing Excel to English formats
Assignment 1 preview and instructions

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 an Assignment is not showing up for you
How to get help
Opening macro-enabled workbooks
If the GRADE button is not showing up
Week 1 Excel files
Excel shortcuts on a Mac
Assignment
Week 2 Excel files

Practice Exercises

Unlock quiz for Week 1 files
Quiz 1
Assignment 1 submission

Videos

Week 2 Preview
Excel syntax and order of operations
Troubleshooting Excel formulas
Introduction to functions in Excel
Counting, summing, and averaging in Excel, Part 1
Counting, summing, and averaging in Excel, Part 2
Rounding and remainders
Examples: Rounding and remainders
Random numbers, combinations, and permutations
The CHOOSE function
OPTIONAL: The CONVERT function (for engineers and scientists)
Assignment 2 preview and instructions

Readings

Assignment 2
Week 3 Excel files

Practice Exercises

Quiz 2
Assignment 2 submission

Videos

Week 3 Preview
Making named ranges dynamic
Previewing compatibility with earlier versions
IF, AND, and OR
Advanced logical functions in Excel
Flash Fill: Advantages and disadvantages
Text functions in Excel, Part 1
Text functions in Excel, Part 2
Excel's financial functions
Introduction to array formulas
Introduction to VBA user-defined functions
Assignment 3 preview and instructions

Readings

Assignment 3
Week 4 Excel files

Practice Exercises

Quiz 3
Assignment 3 submission

Videos

Week 4 Preview
Applying a filter
Using the FILTER function (Office 365)
Creating an Excel Table
Data validation and drop-down lists
Sorting data in Excel
The SORT and SORTBY functions (Office 365)
Example: Sorting by columns
Cleaning your data
Removing duplicates
Consolidating data
One-way lookup functions, Part 1
One-way lookup functions, Part 2
The XLOOKUP function
Assignment 4 preview and instructions

Readings

Assignment 4
Week 5 Excel files

Practice Exercises

Quiz 42
Assignment 4 submission

Videos

Week 5 Preview
Scatter plots in Excel, Part 1
Scatter plots in Excel, Part 2
Column and pie charts in Excel
Dynamic charts
Introduction to Pivot Tables
Slicers
Sparklines
Sharing worksheets and charts in Word and PowerPoint
Printing Excel worksheets
Example: Sales invoice as PDF file
For Fun: Importing Geographic information
Assignment 5 preview and instructions

Readings

Assignment 5
Have you considered learning VBA?

Practice Exercises

Quiz 5
Assignment 5 submission

Instructors

CU Boulder Frequently Asked Questions (FAQ's)

1: When do we receive the certificate?

Candidates need to purchase the course completion certificate after successful completion. They can pay any time throughout the training course.

2: What makes this course stand out?

Apart from a comprehensive curriculum that will help you understand all the aspects of excel effortlessly, the Everyday Excel, Part 1 online course will help you apply Excel to solve real-life projects. You will receive practice exercises and weekly assignments to enhance your experience. Best of all, the training course is fully self-paced for your convenience.

3: Will I be able to access the lectures and assignments?

The type of enrolment you choose confirms whether you have access to your lectures and assignments or not. The audit mode provides access to most of the course material for free, but to access your certificate and graded assignments, you need to purchase the certificate.

4: Are there any practice tests in the course?

Yes, every course module has MCQ practice exercises towards the end with listed FAQs related to the Everyday Excel, Part 1 programme.

5: Who provides the Everyday Excel, Part 1 course?

The University of Colorado, Boulder offers the Everyday Excel, Part 1 online course.