Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The Foundation
Introduction
Introduction (0:51)
What you'll learn from this module (0:48)
How to practice (1:52)
Basic use of Excel
Important Excel terms (0:59)
Important menus/toolbars (2:18)
Inserting and deleting columns and rows (0:59)
Copy and Paste (2:58)
Calculation with Excel
Formulas (2:03)
References (4:08)
References to other sheets and workbooks (2:39)
Functions (1:26)
Adding numbers with the SUM function (1:58)
How to use all functions in Excel (2:21)
Formatting
General formatting (1:47)
Colors (1:42)
Borders (2:31)
Text manipulation (1:44)
Charts
Choosing and inserting charts (2:39)
Modifying charts (2:46)
Working with large amounts of data
Find and Replace (2:01)
Freeze panes (0:46)
Filters (2:16)
Comments (1:33)
Tables (3:15)
Printing and protecting
Making the data fit the paper (2:47)
Protecting your work in Excel (2:08)
Wrapping up
Certificate (0:47)
What now? (0:58)
Bonus
Assignments (0:42)
Important menus/toolbars
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock