Course Summary
In this course, you will learn how to make the most of Excel features as a student. Throughout this course, you will delve into various features, including using Themes, Basic Pivot Table, Charts, Flash Fill, and Absolute Cell Referencing.
This course will explore the flashfill feature, where you can fill in your data automatically when it recognises a pattern. You will also discover how to use Absolute Cell Referencing, which ensures that the column and row coordinates don't change when you copy a formula from one cell to another.
This course will give a live demonstration of how to use and apply each feature. It will help you practice the features effectively and enhance your skills.
General Purpose
Upon finishing the course, the student will have the ability to incorporate a range of fundamental Excel features into their daily activities, making their tasks more efficient and productive.
Specific Purpose
-
Ability to understand and apply Excel's themes feature.
-
Ability to understand and apply Basic Pivot Table in Excel.
-
Ability to understand and make Charts in Excel.
-
Ability to understand and apply Excel's FlashFill feature.
-
Ability to understand and apply Absolute Cell Referencing in Excel