Everyday Excel, Part 1
"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.
Buy Now AED 170.99 + VAT
Monthly Subscription Starting at AED 99 + VAT
- Level Foundation
- Duration 24 hours
- Course by University of Colorado Boulder
-
Offered by
About
"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.Modules
WELCOME!
-
3
Videos
-
9
Readings
-
1
Discussion
-
1
Assignment
1
Assignment
- Unlock quiz for Week 1 files
1
Discussions
- What about you?
3
Videos
- Welcome to Everyday Excel!
- What will I learn in the course?
- How to switch sessions of the course
9
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
- Opening macro-enabled workbooks
- If an Assignment is not showing up for you
- How to get help
- Week 1 Excel files
Screencasts
-
17
Videos
-
1
Readings
17
Videos
- 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
1
Readings
- Excel shortcuts on a Mac
Quiz 1 and Assignment 1
-
1
Videos
-
2
Readings
-
1
Discussion
-
2
Assignment
2
Assignment
- Quiz 1
- Assignment 1 submission
1
Discussions
- Assignment 1 discussion
1
Videos
- Assignment 1 preview and instructions
2
Readings
- Assignment 1
- Week 2 Excel files
Screencasts
-
11
Videos
11
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)
Quiz 2 and Assignment 2
-
1
Videos
-
2
Readings
-
1
Discussion
-
2
Assignment
2
Assignment
- Quiz 2
- Assignment 2 submission
1
Discussions
- Assignment 2 discussion
1
Videos
- Assignment 2 preview and instructions
2
Readings
- Assignment 2
- Week 3 Excel files
Screencasts
-
11
Videos
11
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
Quiz 3 and Assignment 3
-
1
Videos
-
2
Readings
-
1
Discussion
-
2
Assignment
2
Assignment
- Quiz 3
- Assignment 3 submission
1
Discussions
- Assignment 3 discussion
1
Videos
- Assignment 3 preview and instructions
2
Readings
- Assignment 3
- Week 4 Excel files
Screencasts
-
14
Videos
14
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
Quiz 4 and Assignment 4
-
1
Videos
-
2
Readings
-
1
Discussion
-
2
Assignment
2
Assignment
- Quiz 4
- Assignment 4 submission
1
Discussions
- Assignment 4 discussion
1
Videos
- Assignment 4 preview and instructions
2
Readings
- Assignment 4
- Week 5 Excel files
Screencasts
-
12
Videos
12
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
Quiz 5 and Assignment 5
-
1
Videos
-
2
Readings
-
1
Discussion
-
2
Assignment
2
Assignment
- Quiz 5
- Assignment 5 submission
1
Discussions
- Assignment 5 discussion
1
Videos
- Assignment 5 preview and instructions
2
Readings
- Assignment 5
- Have you considered learning VBA?
Auto Summary
"Everyday Excel, Part 1" is a beginner-friendly course designed for those new to Excel, offering foundational to advanced skills. Over 5 weeks, learners will navigate Excel, edit and format worksheets, use various functions, manage data sets, and visualize data through charts. The course includes hands-on assignments for practical experience. Ideal for a wide audience, it requires no prior programming or advanced math skills. Available on Coursera, with subscription options including Starter, Professional, and Paid, and taught by expert instructors, it's perfect for personal development.
Charlie Nuttelman