AE113 GROUP 11 TOP 20 EXCEL FEATURES & FUNCTIONS FOR ACCOUNTANTS
Sorry, only registred users can create playlists.
Description
IT APPLICATION TOOLS IN BUSINESS-Summer 2021
PROJECT DEMONSTRATION VIDEO
PRESENTED BY: GROUP 11
Features:
1. Go to special
2. Automatic Subtotals
3. Number Formatting
4. Formula Auditing
5. Auto Filter
6. Conditional Formatting
7. Flash Fill
8. Remove Duplicates
9. Data Validation
10. Pivot Tables
Functions:
11. Aggregate
12. Round Function
13. OE Month Function
14. E Date
15. Workday
16. 3D Formulas
17. SUMIFS/AVERAGEIFS/COUNTIFS
18. If
19. Vlookup
20. Trim
Comments