This course provides instruction for five basic topics in Excel. The following topics are addressed in the training program: 1) Conditional formatting, 2) Removing duplicates, 3) Find and replace, 4) Grouping cells, 5) Absolute/relative references. The instructional workbook covers a variety of topics from beginner to intermediate, and provides an explanation of each topic with an exercise for practice. The training will also provide examples of business application for each topic.
Prerequisites
No advanced preparation or prerequisites are required for this course.
Learning Objective
- Discover the structure, function, and inputs of 1) Conditional formatting, 2) Removing duplicates, 3) Find and replace, 4) Grouping cells, 5) Absolute/relative references
- Recognize how to incorporate Excel functions in appropriate use case scenarios
- Identify the location of basic functions in Excel
- Discover basic shortcuts for the functions covered in the video
Last updated/reviewed: March 16, 2024
(12) Reviews
(16 rating)
I appreciate all of the practice. Lot's of problems help to develop proficiency at speed.
Easy to understand and follow. Basic concepts with real world examples.
Great course, was easy to follow and understand, with good examples.
Do not want to go into upper management.
Great information but moves to quickly through examples sometimes.
would be nice to have a downloadable copy to practice on
was able to easily follow the examples
For a true beginner like myself, the material was perfect.
great overview.
Nicely done unpacking the essentials in an easy to understand format.
Great course - finally feel like I have a firm grasp on basic accounting principals and a "talking knowledge" of basic accounting.
Parts were very hard to hear.
Lesson Questions and Answers0 Questions
INTRODUCTION AND OVERVIEW
- Introduction to Basic Excel Training: Conditional Formatting 7:07
- Removing Duplicates 3:26
- Find and Replace 7:20
- Grouping Cells 2:43
- Absolute & Relative Referencing 4:58
Continuous Play
REVIEW & TEST
- REVIEW QUESTIONS quiz
- FINAL EXAM exam
Ask the instructor a question about this lesson