HOW TO USE

GOOGLE SHEETS?

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

Click the Google Chrome icon in your desktop

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

Type google.com

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

Press ENTER

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

Click Sign in

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

Enter your Google Email address

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

Enter your Gmail Password

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

Click Sign In

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

Click the

icon

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

Click More

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

10

Click Even more from Google

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

11

Click Sheets

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

12

You will be directed to Google Sheets Page

Sheet File Name

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

13

CREATING NEW SPREADSHEET

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

14

Click

at the lower right side corner

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

15

New and untitled spreadsheet will open

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

16

Click Untitled Spreadsheet

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

17

Rename to Sample_Spreadsheet_Tutorial

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

18

Click OK

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

19

New name of Spreadsheet is displayed

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

20

SHARING SPREADSHEET
TO TEAM MEMBERS

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

21

Click

at upper right corner

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

22

Enter email address of team member

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

23

Choose access type

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

24

ACCESS TYPES

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

25

SHARING SPREADSHEET
THROUGH FACEBOOK

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

26

Click Advanced

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

27

Click the Facebook logo

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

28

Click On-Anyone with the Link

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

29

Choose Can View

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

30

Choose Share to Facebook

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

31

Say something about the post

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

32

Click Share Link

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

33

SHARING SPREADSHEET
THROUGH TWITTER

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

34

Click the Twitter logo

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

35

Click the Tweet

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

36

SHARING SPREADSHEET
THROUGH GOOGLE+

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

37

Click the Google+ logo

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

38

Add your comments

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

39

Click Share

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

40

SHARING SPREADSHEET
THROUGH GOOGLE MAIL

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

41

Click the Google Mail logo

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

42

Enter email address of recipient

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

43

Enter subject of email

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

44

Click Sent

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

45

ADDING SHEETS

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

46

Click

at the lower left corner

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

47

RENAMING SHEETS

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

48

Click beside the Sheet Title Bar

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

49

Click Rename

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

50

Type name of sheet

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

51

ENTERING DATA

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

52

Click on the cell

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

53

Type data you want to put

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

54

INSERTING LINKS

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

55

Copy link of destination website

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

56

Click on the cell

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

57

Click the Insert Link icon

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

58

Right Click on the Link Box

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

59

Click Paste

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

60

Click on Text Box

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

61

Type text to be displayed

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

62

Click Apply

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

63

Blue text will appear on the cell

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

64

USING FUNCTIONS FOR

GOOGLE SHEETS

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

65

Click the target Cell

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

66

Click on Function Box

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

67

Type equal sign (=)

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

68

Type Function name

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

69

Highlight cells included in Function

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

70

Complete Function syntax

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

71

Press Enter

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

72

ACCESSING ALL FUNCTIONS OF

GOOGLE SHEETS

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

73

Click Help

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

74

Click Function List

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

75

Google spreadsheets function list will open

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

76

CHANGING FONTS AND

FONT SIZE

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

77

Highlight Cells

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

78

Click Font List

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

79

Select font type

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

80

Click Font Size list

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

81

Select desired size

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

82

MERGING CELLS

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

83

Highlight Cells

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

84

Click Format

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

85

Click Merge Cells

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

86

Select Merging Type

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

87

Highlighted Cells will merge

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

88

PROTECTING SHEETS

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

89

Click the arrow beside Sheet name

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

90

Click Protect Sheet

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

91

Click Enter a Description box

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

92

Enter description

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

93

Click Set permissions

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

94

Select access permission of team members

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

95

Click Save Changes

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

96

Click Done

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

97

Click Done

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

98

Protected Sheet will appear in the list

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

99

Protected Sheet will have padlock icon

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

100

Close protected sheets and ranges menu

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

101

DOWNLOADING
GOOGLE SHEETS AS
MICROSOFT EXCEL FILE

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

102

Click File

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

103

Click Download as

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

104

Select Microsoft Excel (.xlsx)

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

105

Wait until download is complete

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

106

Click the file

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

107

The file will be opened in Excel format

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

108

THERE YOU GO!!

NOW YOU CAN USE
GOOGLE SHEETS AND
EXPERIENCE ITS GREAT
CAPABILITIES!

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

109

Wrong Decision at the Wrong Time=Disaster

The Wrong Decision at the Right Time=Mistake
The Right Decision at the Wrong Time= Unacceptance
The Right Decision at the Right Time=SUCCESS!
John Maxwell

2014 fastandsavvymike.wordpress.com- Google Sheets Tutorial

110