Course Summary
Learn how to use Excel for everyday tasks with this beginner-friendly course. From formatting to functions, this course covers the essentials of Excel in a practical way.Key Learning Points
- Learn Excel basics such as formatting, navigating, and entering data
- Discover how to use formulas and functions to perform calculations
- Practice creating charts and graphs to visualize data
Job Positions & Salaries of people who have taken this course might have
- USA: $28,000 - $41,000
- India: ₹180,000 - ₹500,000
- Spain: €15,000 - €22,000
- USA: $28,000 - $41,000
- India: ₹180,000 - ₹500,000
- Spain: €15,000 - €22,000
- USA: $30,000 - $50,000
- India: ₹180,000 - ₹550,000
- Spain: €16,000 - €25,000
- USA: $28,000 - $41,000
- India: ₹180,000 - ₹500,000
- Spain: €15,000 - €22,000
- USA: $30,000 - $50,000
- India: ₹180,000 - ₹550,000
- Spain: €16,000 - €25,000
- USA: $50,000 - $87,000
- India: ₹360,000 - ₹1,200,000
- Spain: €22,000 - €40,000
Related Topics for further study
Learning Outcomes
- Master Excel basics such as formatting and navigating
- Learn how to perform calculations with formulas and functions
- Create charts and graphs to easily visualize data
Prerequisites or good to have knowledge before taking this course
- Access to Microsoft Excel
- Basic computer skills
Course Difficulty Level
BeginnerCourse Format
- Self-paced
- Video lectures
- Practice exercises
Similar Courses
- Excel Skills for Business Essentials
- Data Analysis with Excel
Related Education Paths
Notable People in This Field
- Chandoo
- Mike Girvin
Related Books
Description
"Everyday Excel, Part 1" is aimed at learners who are seeking to learn Excel from the ground up. No experience with Excel is necessary. While this course is meant for beginners of Excel, advanced users will undoubtedly pick up new skills and tools.
Knowledge
- Navigating Excel, editing the worksheet (including inserting/deleting cells, columns, and rows), and cell formatting.
- Expression entry and common Excel formulas (including logical functions, text functions, and financial functions).
- Data management (sorting, filtering, consolidating, removing duplicates, data validation, and one-way lookups).
- Data visualization (scatter plots, column charts, pie charts, Slicers, Sparklines, and Pivot Tables).
Outline
- Navigating Excel
- 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
- 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
- For Mac users
- If an Assignment is not showing up for you
- Week 1 Excel files
- Quiz 1 solutions and explanations
- Assignment 1
- Week 2 Excel files
- Unlock quiz for Week 1 files
- Quiz 1
- Expression Entry and Common Excel Functions
- 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
- Quiz 2 solutions and explanations
- Assignment 2
- Week 3 Excel files
- Quiz 2
- Assignment 2 submission
- More Excel functions
- 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
- Quiz 3 solutions and explanations
- Assignment 3
- Week 4 Excel files
- Quiz 3
- Assignment 3 submission
- Managing Data
- 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
- Quiz 4 solutions and explanations
- Assignment 4
- Week 5 Excel files
- Quiz 4
- Assignment 4 submission
- Plotting, Importing Data, and Converting to Other File Types
- 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
- Quiz 5 solutions and explanations
- Assignment 5
- Quiz 5
- Assignment 5 submission
Summary of User Reviews
The Everyday Excel Part 1 course on Coursera has received positive reviews from users. Many found it to be a great introduction to Excel, with clear explanations and helpful examples. The course has an overall rating of highly recommended by users.Key Aspect Users Liked About This Course
The course provides a great introduction to Excel with clear explanations and helpful examples.Pros from User Reviews
- Clear explanations and examples
- Great introduction to Excel
- Instructor is knowledgeable and engaging
- Assignments are relevant and practical
- Easy to follow along with
Cons from User Reviews
- Some users found the course to be too basic
- Course material can be repetitive
- Limited coverage of advanced Excel functions
- No interaction with other students
- No certificate of completion offered
Charlie NuttelmanTop Instructor
4.7 Raiting
Microsoft Power BI Masterclass - Expand Excellence
- 4.7
-
![]()
![]()
![]()
![]()
![]()
achieve the next Level of Business Intelligence with Microsoft Power BI Desktop. How to master Power BI Desktop Microsoft Power BI in 4 hours - Expand Excellence ...
Advance Stock Trading (Short term, Swing and Long term)
- 2.8
-
![]()
![]()
![]()
![]()
![]()
Discover and Master Chart Language. The Secret to How to Earn Big in The Market Revealed! Are you searching for highly successful techniques in the market?...
Statistik & Data Science Bootcamp in Excel: Von 0 auf 100!
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Vom Excel-Anfänger zum gefragten Data-Science-Experten 2021: Der Komplettkurs für statistische Analysen & Prognosen! "Sehr gut!" (★★★★★, Christian Adjei) Statistik Bootcamp in Excel 2021: Von 0 auf 100 zum Excel Profi!...
Foundations of User Experience (UX) Design
- 4.8
-
![]()
![]()
![]()
![]()
![]()
UX designers focus on the interactions that people have with products like websites, mobile apps, and physical objects. UX designers make those everyday interactions usable, enjoyable, and accessible....
