Google Sheets For Business People

Google Drive Service offers several Google products online such as Google Docs, Google Slides, Google Forms, and Google Sheets. Introduced in 2006, Google Sheets is an amazing online spreadsheet application. It is free to use, customizable, and a cloud-based application, which can be accessed anytime and from any device. This application is compatible with Android, macOS, Windows, ChromeOS, and blackberry.

Google Sheets functions like any other spreadsheet tool, but with more advanced features. It is often compared with MS Excel, the time-hallowed giant of the spreadsheet world. However, Excel is primarily an offline program, and Google Sheets being an online and cloud-based application, can be incorporated very well with the other online Google Services.

Table of Contents

• Introduction 10
• Why Use Google Sheets 10
• Cloud-based 10
• Auto-save 11
• Collaboration in real-time 11
• Editing 11
• Offline editing 11
• Comment 12
• Share 12
• Explore 12
• Personalize your Google Sheets 12
• Add-ons 12
• Basic Google Sheets Terms 13
• Cell 13
• Rows 13
• Columns 13
• Range 14
• Array 14
• Function 14
• Formula 15
• Worksheet 15
• Spreadsheet 15
• How to use Google Sheets 17
• Creating a new Google Sheets Spreadsheet 17
• The Google Sheet Editing Window 18
• Understanding Toolbar Icons 19
• Undo 19
• Redo 19
• Print 19
• Paint format 19
• Zoom 19
• Format (as currency $ or percentage %) 20
• Format (decimal position) 20
• Font and font size 20
• Bold, Italics, Underline 20
• Text Colour 21
• Fill Colour 21
• Borders 21
• Merge cells 21
• Align 21
• Vertical Align 21
• Text Wrapping 21
• Text Rotation 22
• Insert link 22
• Insert comment 22
• Insert Chart 22
• Create Filter 22
• Functions 22
• Adding data to Google Sheets spreadsheet 23
• How to add columns in Google Sheets 23
• How to add columns and rows at the end 23
• Adding multiple sheets 24
• How to rename or delete a sheet 25
• Adding data via Copy and Paste 25
• How to Import a file 26
• Dragging to copy a cell value 26
• Converting Excel to Google Sheets 27
• Protecting and sharing data 27
• Sharing data steps 28
• Protecting data steps 28
• Organizing data in Google Sheets 29
• How to hide data 29
• How to unhide data 30
• Sorting data on Google Sheets 30
• Sorting Range 30
• Sorting Sheets 30
• How to freeze data on Google Sheets 31
• How to filter data on Google Sheets 31
• How to format data on Google Sheets 32
• How to remove formatting 32
• How to merge Google Sheets 33
• How to use Google Sheets offline 33
• Functions in Google Sheets 34
• ARRAY_CONSTRAIN 34
• FREQUENCY 35
• MDETERM 35
• MINVERSE 36
• MMULT 37
• SUMPRODUCT 37
• SUMX2MY2 38
• SUMX2PY2 39
• SUMXMY2 40
• TRANSPOSE 40
• DATE 40
• DATEDIF 42
• DATEVALUE 43
• DAY 43
• DAYS 44
• EDATE 45
• HOUR 45
• MINUTE 46
• TIME 46
• TIMEVALUE 47
• BIN2DEC 48
• BIN2HEX 48
• BIN2OCT 49
• DEC2BIN 50
• DEC2HEX 50
• COMPLEX 51
• DELTA 51
• IMAGINARY 52
• IMDIV 52
• IMPRODUCT 53
• IMREAL 53
• IMSUB 54
• IMSUM 54
• OCT2BIN 55
• FILTER 56
• SORT 56
• UNIQUE 57
• DETECTLANGUAGE 58
• GOOGLETRANSLATE 59
• IMAGE 60
• SPARKLINE 60
• ISBLANK 61
• ISDATE 61
• ISMAIL 62
• ISERROR 62
• ISFORMULA 62
• ISNONTEXT 63
• ISNUMBER 63
• ISTEXT 64
• CELL 64
• FALSE 65
• OR 65
• TRUE 65
• CHOOSE 66
• COLUMN 67
• ROWS 67
• ABS 67
• EVEN 68
• GCD 68
• IMPOWER 69
• IMSQRT 70
• ISEVEN 70
• LOG 70
• GETPIVOTDATA 71
• VLOOKUP 72
• COUNTIF 73
• SKEW 73
• CLEAN 75
• UMINUS 75
• REGEXEXTRACT 75
• UNICODE 76
• IMPORTDATA 76
• IMPORTFEED 77
• IMPORTRANGE 77
• IMPORTHTML 78
• IMPORTXML 78
• CONCATENATE 79
• GROWTH 79
• SUBSTITUTE 80
• NORMDIST 80
• LOWER 81
• JOIN 81
• FORECAST 82
• PERMUT 82
• TRIM 83
• FACTDOUBLE 83
• COUPDAYS 84
• DB 84
• HARMEAN 85
• COMBINA 86
• INTRATE 87
• INTERCEPT 88
• FV 88
• Final Word 89