Description

Microsoft Excel Level-3 – Advanced Classes

How to book: Choose a date from the calendar above > click “Book now” > click on “View Cart” > at the bottom of the screen click “Proceed to checkout” > Fill the form > Click on PayPal and you can pay with PayPal account or a credit card. You can go through the same process if you wish to book other levels.

Class Time:  9:00 am to 5:30 pm

Break: 11:50 am for 20 minutes

Lunch: 1:00 pm to 1:30 pm

Break: 3:30 pm to 20 minutes

Syllabus

Level 3 – Advanced

Transpose

Autoformat, Page Break

Add and Edit Comments

Loan Payment Function

If Statement

Defined Names, Circular Reference

Average function

Absolute Cell Addresses

Password Protect Files

Symbols

Create, Edit, Apply Style

Pivot Tables

Index, Match, Sumproduct Functions

Vlookup and Lookup

Protecting Cell Data

Dropdown Menu