Excel Advanced Features and Functions

The Game Changer Course - Learn how to use some of the most important advanced Excel functions.

Hi there.

My name is Kornilios, and I am part of the TEST4U team.

In this course we will teach how to use some of Excel’s advanced features and functions.

So, the tools we will use to achieve our learning goals are:

1. Detailed lectures for each function with at least 2 examples. The Excel files of each lecture will be available for download as supplementary resources.

2. Assignments for each function with a video solution for each one.

We should note here that some basic knowledge of Excel and its basic functions is required to complete this course. So if you are not familiar with basic Excel functionality you may face some difficulties.

In the first part we will deal with some advanced general knowledge along with some good to know excel features.

Next, we will go on a quest to find the best and most versatile lookup function.

Then we have two chapters, one financial and one statistical. We explain how Excel helps us make our lives easier in both those fields.

Finally, we will proceed into data analysis where we will introduce you to power pivot and pivot tables.

Feel free to check our bio to learn more about us.

We hope you will enjoy this.

Welcome to the TEST4U Team.

Let’s begin.