MS Excel Masterclass

Welcome to the course

Course Resources

Excel Basics

Worksheet Basics

Entering values and Formulas

Data Handling Basics – Cut, Copy and Paste

Saving and Printing – Basics

Essential Formulas

Basic Formula Operations

Mathematical Functions

Difference between RANK, RANK.AVG and RANK.EQ

Practice Session 1: Mathematical Functions

Textual Functions

Practice Session 2: Textual Functions

Logical Functions

Practice Session 3: Logical Functions

Date-Time Functions

Practice Session 4: Date-Time Functions

Lookup Functions (V Lookup, Hlookup, Index-Match)

Practice Session 5: Lookup Functions

1 of 3

Previous Lesson

Mathematical Functions

MS Excel Masterclass Mathematical Functions

Previous Lesson

Login

Accessing this course requires a login. Please enter your credentials below!

Username or Email Address

Password

Remember Me

Lost Your Password?

Register

Don't have an account? Register one!

Register an Account

Username

Email

Registration confirmation will be emailed to you.