University of Colorado Boulder - Everyday Excel, Part 1
5.0 /5- Offered byCoursera
Everyday Excel, Part 1 at Coursera Overview
Duration | 24 hours |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Explore Free Course  |
Credential | Certificate |
Everyday Excel, Part 1 at Coursera Highlights
- Shareable Certificate Earn a Certificate upon completion
- 100% online Start instantly and learn at your own schedule.
- Course 1 of 3 in the Everyday Excel Specialization
- Flexible deadlines Reset deadlines in accordance to your schedule.
- Beginner Level A knowledge of algebra will help for some of this course.
- Approx. 24 hours to complete
- English Subtitles: Arabic, French, Portuguese (European), Italian, Vietnamese, German, Russian, English, Spanish
Everyday Excel, Part 1 at Coursera Course details
- "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.
- This course is the first part of a three-part series and Specialization that focuses on teaching introductory through very advanced techniques and tools in Excel. In this course (Part 1), you will: 1) learn how to effectively navigate around the Excel environment; 2) edit and format Excel worksheets; 3) implement basic to advanced Excel functions (including financial, logical, and text functions); 4) learn how to manage data sets (filter, remove duplicates, consolidate data, sort data, and validate data); and 5) learn how to effectively visualize data through scatterplots, column charts, and pie charts.
- New to Excel? That is entirely fine! This course is meant to be fun, thought-provoking, and appeal to a wide audience. No prior knowledge in programming nor advanced math skills are necessary. The course is organized into 5 Weeks (modules).
- To pass each module, you'll need to pass a mastery quiz and complete a problem solving assignment. This course is unique in that the weekly assignments are completed in-application (i.e., on your own computer in Excel), providing you with valuable hands-on training.
Everyday Excel, Part 1 at Coursera Curriculum
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
Assignment 1 submission
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
Other courses offered by Coursera
Everyday Excel, Part 1 at Coursera Students Ratings & Reviews
1 Rating- 4-51
Student Forum
Anything you would want to ask experts?