bhaveshchandarana.com

5. Introduction to data formatting tools

6. Understanding data freezing tool

7. Understanding of sorting tools

8. Quick data formatting using alternate colours

9. Collaborating of Google Sheets with multiple users

10. Sharing Google Sheets publicly

11. Understanding the row/column protection and sheet protection

12. How to print, download and mail Google Sheets

13. Removing duplicate records

14. How to split data

15. Understanding edit history

16. Adding hyperlinks

17. Understanding Filter tool

18. Useful keyboard shortcuts in Google Sheets

20. Understanding data validation tool

21. Understanding Conditional formatting

22. How to add images in Google Sheets?

23. How to add comments and send Email from Google Sheets using commenting tool?

24. Changing of Google Sheets location within Google Drive

25. Publishing Google Sheets as web page

26. Google Sheets backup and restore

27. How to use find and replace tool

28. Location and calculations setting in Google Sheets

29. Addition of Prefix and Suffix to Numbers

32. Average Function

33. How to make changes in a formula using find and replace tool

34. Google translate Function

35. TODAY Function

36. TRANSPOSE Function

37. LEFT/RIGHT Function

38. MERGE Function

39. UPPER/LOWER Function

40. SORT Function

41. COUNT & COUNTA Function

42. UNIQUE Function

43. ROUND/ROUNDUP/ROUNDDOWN Function

44. IF Function

45. SUMIF Function

46. VLOOKUP Function

47. Array Formula