Course Highlights
  • 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).
Curriculum

38 Topics
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
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
Excel shortcuts on a Mac
Assignment 1
Week 2 Excel files
Unlock quiz for Week 1 files
Quiz 1
Assignment 1 submission
What about you?
Assignment 1 discussion

17 Topics
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
Assignment 2
Week 3 Excel files
Quiz 2
Assignment 2 submission
Assignment 2 discussion

17 Topics
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
Assignment 3
Week 4 Excel files
Quiz 3
Assignment 3 submission
Assignment 3 discussion

20 Topics
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
Assignment 4
Week 5 Excel files
Quiz 4
Assignment 4 submission
Assignment 4 discussion

18 Topics
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
Assignment 5
Have you considered learning VBA?
Quiz 5
Assignment 5 submission
Assignment 5 discussion

  Write a Review

Everyday Excel, Part 1

Go to Free Course