Online Certification program on Training in Advance Microsoft Excel
![](https://www.thecareercouncil.com/media/feature_img/1632116109AdvancedMicrosoftExceljpg.jpg )
Tools You’ll Master
![](https://www.thecareercouncil.com/uploads/tools_logo/1632120895vlookup.png )
![](https://www.thecareercouncil.com/uploads/tools_logo/1632120895thumb@520_2017-10-index-and-match.png )
![](https://www.thecareercouncil.com/uploads/tools_logo/1632120895png-clipart-pivot-table-computer-icons-microsoft-excel-pivot-animator-table-angle-furniture.png )
![](https://www.thecareercouncil.com/uploads/tools_logo/1632120895filter_and_sort.png )
What you will learn in this course?
- Shortcut Keys
- Use of GoTo and extensive use of Paste Special Dialog Box
- Referencing-Absolute,Relative Mixed
- Text Functions- Left,Right,Mid,Concatenate,Substitute,TRIM
- Date Function- Days, Months,Year,Datedif,Edate,E month, Countif,Sumif,Countifs,Sumifs
- Lookup-VLookUp, Index and Match
- IF Function- IF , Nested IF,AND,OR
- Conditional Formatting
- Data Text to Columns
- Data Tools-Sort and Advance filter
- Data Subtotal-Single level and also Multiple level
- Data Consolidation
- Pivot Table-In details