Excel Basics & Shortcuts

In this class, I will cover the following modules.

1. Data Entry & Formatting - I will be explaining about how to enter data in different cells, setting data types, horizontal & vertical alignments. This will be followed by setting up borders and preparing reports. Also, I will be explaining how to use filters, how to sort data, and freezing rows / columns.

2. Basic Formulae & Functions - All mathematical formalae & functions that are available in Excel. String & cell related functions will also be included in the module.

3. Pivot Table - What is a Pivot table ? How is it created ? How to use a Pivot table ?

4. Vlookup & Hlookup -  What are these fumctions and how they are useful ? How to use these functions ?

5. Keyboards shortcuts for various functions im Excel. How you can work faster using shortcuts.

6. Charts - There are lots of different charts available in Excel. How to create charts using the data in excel.

Examples will be provided in all cases.