Categories & Number Of Functions In Each Category of Excel 2010

 

Recommended Excercises

1. Database Functions (12)

2. Date and Time Functions (20)

3. Engineering Functions (39)

4. Financial Functions (53)

5. Information Functions (17)

6. Logical Functions (6)

7. Lookup and Reference Functions (18)

8. Math and Trigonometry Functions (59)

9. Statistical Functions (80)

10. Text Functions (27)

11. External Functions (2)

 

English to German quick converter

 

 

 

Common Commands used by Accountants to Clean Data

 

1. Import

2. Text to Columns

3. Remove Duplicates

4. Find & Replace

5. Spell Check

6. =UPPER

7. =LOWER

8. =PROPER

9. =FIND

10. =SEARCH

11. =LEN

12. =SUBSTITUTE

13. =REPLACE

14. =LEFT

15. =MID

16. =RIGHT

17. =VALUE

18. =CONCATENATE

19. =TEXT

20. =TRIM

21. =CLEAN

22. =FIXED

23. =DOLLAR

24. =CODE

25. Macros