Join on 25th and 26th November for Excel training open workshop program in Noida.
Here is the complete coverage of the topics Excel
- Using Custom & Conditional Formats
- Logical Functions : IF,SUMIF,COUNTIF
- Sumifs,Countifs
- Working with Date and Time Functions
- Vlookup() and Hlookup Function
- Iferror with Vlookup
- Vlookup with Array
- Working with Advanced Charts
- Working with Advance Pivot Tables
- Data Validation
- Text to columns
- What if Analysis
- Overview of Macros
- Practice Assignment
- Shortcut Keys