Advance Features Of Excel

Advance Features Of Excel-2007 1. Sorting 2. Filtering a. Auto filters b. Advance filters 3. Text to columns 4. Remove duplicates 5. Data validation a. Data validation b. Circle invalid data c. Clear validation circle 6. Consolidate 7. What if analysis a. Scenario manager b. Goal seek c. Data table 8. Grouping the data 9. Subtotals 10. Getting external data a. From text file b. From access file c. From web page d. From external source such as XML document 11. Creating macros 12. Formatting the cells 13. Formula auditing 14. Creating Charts 15. Pivot table and chart 16. Custom lists 17. Protecting Excel file 18. Print options 19. Cell reference a. Relative reference b. Absolute reference 20. Creating Templates