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.