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,115 |
Fee for 3-month | Rs. 8,230 |
Fee for 6-month | Rs. 12,345 |
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
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
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)
Candidates need to purchase the course completion certificate after successful completion. They can pay any time throughout the training course.
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.
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.
Yes, every course module has MCQ practice exercises towards the end with listed FAQs related to the Everyday Excel, Part 1 programme.
The University of Colorado, Boulder offers the Everyday Excel, Part 1 online course.