Everyday Excel, Part 1
Join the Everyday Excel, Part 1 online course by Coursera to acquire a thorough understanding of the various provisions and functionalities offered by excel.
Beginner
Online
3 Weeks
Free 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 |
Fee for 1-month | Rs. 1,676 |
Fee for 3-month | Rs. 3,369 |
Fee for 6-month | Rs. 5,029 |
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
- Course Updates and Accessibility Support
- Microsoft 365 is Required for This Course
- The Power of Microsoft Excel
Assignments
- Module 1 Quiz
programming assignments
- Conditional Formatting
- Mixed Cell References
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
Assignments
- Module 2 Quiz
programming assignments
- Conditional Logic and Data Summaries•60 minutes
- Lookup and Reference Functions
Videos
- Making Named Ranges Dynamic
- Excel Tables
- Structured References
- Data Validation
- Example: Data Validation to Prevent Duplicates
- Drop-Down Lists (Data Validation)
- Example: Employee Time Sheets
- Conditional Formatting Using a Formula
- Example: Conditional Formatting for Financial Reconciliation
- Checkboxes in Excel
- Example: Key Performance Indicators
- Example: Orders
- Module 4 Preview
Assignments
- Quiz 3
programming assignments
- Assignment 3 discussion
Videos
- Advanced Logical Functions
- Determining if an Item is on a List
- Example: Credit Card Lookup
- Example: Room Reservation Sign-Up
- Flash Fill: Advantages and Disadvantages
- Text Functions in Excel (Part 1)
- Text Functions in Excel (Part 2)
- Example: Using the SEARCH Function
- The TEXT Function
- Introduction to Excel's Financial Functions
- Date and Time Functions
- Module 5 Preview
Assignments
- Quiz 4
programming assignments
- Assignment 4 discussion
Videos
- The Find and Select Tool
- Applying a Filter
- Removing Blanks
- Example: Applying a Filter
- Cleaning Your Data
- Identifying Duplicates
- Removing Duplicates
- Consolidating Data
- Sorting Data
- Sorting by a List
- Example: Sorting to Remove Duplicates
- Example: Sorting by Columns
Assignments
- Quiz 5
Discussion Prompt
- Assignment 5 discussion
videos
- Line Graphs
- Scatter Plots
- Column and Pie Charts
- Target Charts
- Progress Charts
- Sparklines
- For Fun: Importing Geographic Information
- Example: Phone Number Map
- Dynamic Charts
- Slicers
- Using Slicers for Dynamic Charts
- Introduction to Pivot Tables and Pivot Charts
- Example: Slicer for Multiple Series
- Example: Using a Timeline with a Pivot Chart
- Sharing Worksheets and Charts in Word and PowerPoint
- Printing Excel Worksheets and Workbooks
- Example: Sales Invoice as PDF File
assignment
- Module 6 Quiz
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.