Warm-Up Lesson
Lesson Type: Video Instruction Attachment: Warm-up Exercises Time: 1:31
Lessons
Lesson 7: More Excel Formulas You Need to Know As A Beginner
Lesson Type: Video Instruction Attachment: Lesson 7 – Beginner File Time: 12:19
Lesson 6: AutoSUM & SUM Functions
Lesson Type: Video Instruction Attachment: Lesson 6 – Beginner File Time: 9:14
Lesson 5: Introduction to Excel Formulas
Lesson Type: Video Instruction Attachment: Lesson 5 – Beginner File Time: 11:41
Lesson 4: More Excel Functions Every Beginner Should Know
Lesson Type: Video Instruction Attachment: Lesson 4 – Beginner File Time: 11:47
Lesson 3: Editing, Sorting & Filtering Your Tables
Lesson Type: Video Instruction Attachment: Lesson 3- Beginners File Time: 22:35
Lesson 2: Updating, Changing & Duplicating the Format and Content of Your Tables
Lesson Type: Video Instruction Attachment: Lesson 2 – Beginner File Time: 21:51
Lesson 1: Basic Navigation & Terminology
Lesson Type: Video Instruction Attachment: None Time: 17:04
Certification for Excel Beginners
Final Project & Final Test In order for you to complete this class and receive your certificate of completion you must meet the following two criteria: You must complete, submit and receive approval for your Final Project. You must complete the Final Test with a passing score of at least 80%. After you complete your …
Day 5 – More Basic Formulas
More Basic Formulas for Beginners Description: In this lecture you will continue to learn and work with basic formulas that all Beginners should know. In this lesson, you will learn: How to structure, write and use the AVERAGE formula How to structure, write and use the COUNT formula How to structure, write and use the …
Day 4 – Introduction to Basic Formulas
NOTE: This is a live webinar. When it is time to join, please enter your name, email address associated with your account and the password that will be provided to you via email. Click on the button to access the live class. Basic Formulas Description: In this live lesson, your instructor will introduce you to basic Excel …
Day 3 – More Excel Functions for Beginners
Basic Functions Beginners Should Know Description: In this lecture we will explore other Excel functionalities that will help you develop your Excel skills as a beginner. In this lesson, you will learn: How to insert a Header & Footer How to group columns & rows instead of hiding them How to remove duplicate values from …
Day 2 – The Cells Group & the Editing Group
Basic Commands in the Cells Group & Editing Group Description: In this lecture we will continue to explore the Home Tab ribbon and practice using the commands specifically located in the Cells group and Editing group. You will learn: How to insert, delete, hide & unhide columns How to insert, delete, hide & unhide sheets …
Day 1 – Getting Familiar with the Home Tab
NOTE: This is a live webinar. When it is time to join, please enter your name, email address associated with your account and the password that will be provided to you via email. Click on the button to access the live class. The Home Tab Description: In this live lesson, your instructor will walk you …
Pre-Work Lecture
Excel Terminology & How To Enter Data Description: This lecture was designed to help you get acquainted with basic Excel terminology and navigation. During this Pre-Work lecture, you’ll learn: Basic Excel terminology How to navigate through a workbook How to navigate a spreadsheet The ways to select, override, edit and enter data How to modify …
Lesson 36: How to lock the Format Painter
Lesson Type: Video Instruction Time: 2:47 In this lesson, you’ll learn how to lock the format painter.
Lesson 35: Applying the Format Painter to large areas
Lesson Type: Video Instruction Time: 2:10 In this lesson, you’ll learn how to apply the format painter to large areas.