IPT Excel School
+91 8802579388
+91 8826828093
Advanced Excel Training with Sujeet Sir
                                             
  Google Sheet Tutorial with Sujeet Sir
Google Sheets is a free online spreadsheet application developed by Google. It allows users to create, edit, and share spreadsheets in real-time with others over the internet. Google Sheets offers a variety of tools and features to help users organize and analyze data, create charts and graphs, and collaborate with others on the same document.
There are many ways to learn Google Sheets. Here are a few options:
1. Online tutorials: There are many free and paid tutorials available online that can help you learn Google Sheets. You can find these tutorials on websites like YouTube, Udemy, Coursera, and LinkedIn Learning.
2. Google Help Center: Google provides a comprehensive Help Center for Google Sheets, which includes step-by-step guides and video tutorials to help you get started.
3. Practice: The best way to learn Google Sheets is by practicing. Create a sample spreadsheet, experiment with formulas and functions, and explore the various features available in Google Sheets.
4. Community forums: Joining Google Sheets user groups or online forums can also be a great way to learn from other users and get answers to your questions.
5. Courses: Consider taking a formal course in Google Sheets through an educational institution or an online learning platform like Udemy or Coursera.
https://play.google.com/store/apps/details?id=co.hodor.jqijz
Download APP and Complete Videos
In Google Sheets, there are different ways to select data in a spreadsheet. Here are some common methods:
1. Click and drag: To select a range of cells, click on the first cell and drag the cursor to the last cell in the range.
2. Shift + click: To select a range of cells that are not next to each other, click on the first cell, hold down the Shift key, and then click on the last cell in the range.
3. Ctrl or Command + click: To select non-adjacent cells or ranges, hold down the Ctrl or Command key on your keyboard and click on the cells or ranges you want to select.
4. Select all: To select all cells in a sheet, you can click on the top left corner of the sheet, where the rows and columns intersect, or use the keyboard shortcut Ctrl+A (Windows) or Command+A (Mac).
5. Using data range inputs: You can also select data by entering the range in the formula bar at the top of the screen. For example, if you want to select cells A1 to C10, you can type "A1:C10" in the formula bar.
These selection methods can be combined to select complex ranges or non-adjacent cells in a sheet.
Here are some of the most commonly used shortcuts for data selection in Google Sheets:
1. Shift + Spacebar: Select an entire row.
2. Ctrl + Spacebar: Select an entire column.
3. Shift + Ctrl + Spacebar: Select the entire sheet.
4. Shift + click: Select a range of cells that are next to each other.
5. Ctrl or Command + click: Select non-adjacent cells or ranges.
6. Ctrl + A (Windows) or Command + A (Mac): Select all cells in the sheet.
7. Ctrl + Shift + Arrow keys: Select a range of cells in the direction of the arrow keys.
Using these shortcuts can help you select data more quickly and efficiently in Google Sheets.
Common actions
Select column Ctrl + Space
Select row Shift + Space
Select all Ctrl + a
Ctrl + Shift + Space
Undo Ctrl + z
Redo Ctrl + y
Ctrl + Shift + z
F4
Find Ctrl + f
Find and replace Ctrl + h
Fill range Ctrl + Enter
Fill down Ctrl + d
Fill right Ctrl + r
Save Ctrl + s
(every change is saved automatically in Drive)
Open Ctrl + o
Print Ctrl + p
Copy Ctrl + c
Cut Ctrl + x
Paste Ctrl + v
Paste values only Ctrl + Shift + v
Show common keyboard shortcuts Ctrl + /
Insert new sheet Shift + F11
Compact controls Ctrl + Shift + f
Input tools on/off Ctrl + Shift + k
(available in spreadsheets in non-Latin languages)
Select input tools Ctrl + Alt + Shift + k
Search the menus Alt + /
Format cells
Bold Ctrl + b
Underline Ctrl + u
Italic Ctrl + i
Strikethrough Alt + Shift + 5
Center align Ctrl + Shift + e
Left align Ctrl + Shift + l
Right align Ctrl + Shift + r
Apply top border Alt + Shift + 1
Apply right border Alt + Shift + 2
Apply bottom border Alt + Shift + 3
Apply left border Alt + Shift + 4
Remove borders Alt + Shift + 6
Apply outer border Alt + Shift + 7
 
Ctrl + Shift + 7
Insert link Ctrl + k
Insert time Ctrl + Shift + ;
Insert date Ctrl + ;
Insert date and time Ctrl + Alt + Shift + ;
Format as decimal Ctrl + Shift + 1
Format as time Ctrl + Shift + 2
Format as date Ctrl + Shift + 3
Format as currency Ctrl + Shift + 4
Format as percentage Ctrl + Shift + 5
Format as exponent Ctrl + Shift + 6
Clear formatting Ctrl + \
Navigate spreadsheet
Move to beginning of row Home
Move to beginning of sheet Ctrl + Home
Move to end of row End
Move to end of sheet Ctrl + End
Scroll to active cell Ctrl + Backspace
Move to next sheet Alt + Down Arrow
Move to previous sheet Alt + Up Arrow
Display list of sheets Alt + Shift + k
Open hyperlink Alt + Enter
Open Explore Alt + Shift + x
Go to side panel Ctrl + Alt + .
Ctrl + Alt + ,
Move focus out of spreadsheet Ctrl + Alt + Shift + m
Move to quicksum Alt + Shift + q
(when a range of cells is selected)
Move focus to popup holding Ctrl + Alt, press e then p
(for links, bookmarks, and images)
Open drop-down menu on filtered cell Ctrl + Alt + r
Open revision history Ctrl + Alt + Shift + h
Close drawing editor Shift + Esc
Edit notes and comments
Insert/edit note Shift + F2
Insert/edit comment Ctrl + Alt + m
Open comment discussion thread Ctrl + Alt + Shift + a
Enter current comment holding Ctrl + Alt, press e then c
Move to next comment holding Ctrl + Alt, press n then c
Move to previous comment holding Ctrl + Alt, press p then c
Use keyboard shortcuts on selected comments
Reply to current comment R
Move to next comment J
Move to previous comment K
Resolve current comment E
Exit current comment U
Open a menu
File menu in Google Chrome: Alt + f
other browsers: Alt + Shift + f
Edit menu in Google Chrome: Alt + e
other browsers: Alt + Shift + e
View menu in Google Chrome: Alt + v
other browsers: Alt + Shift + v
Insert menu in Google Chrome: Alt + i
other browsers: Alt + Shift + i
Format menu in Google Chrome: Alt + o
other browsers: Alt + Shift + o
Data menu in Google Chrome: Alt + d
other browsers: Alt + Shift + d
Tools menu in Google Chrome: Alt + t
other browsers: Alt + Shift + t
Open insert menu Ctrl + Alt + Shift + = 
Ctrl + Alt + = 
(with cells selected)
Open delete menu Ctrl + Alt + - (with cells selected)
Form menu in Google Chrome: Alt + m
(present when the spreadsheet is connected to a form) other browsers: Alt + Shift + m
Add-ons menu in Google Chrome: Alt + n
other browsers: Alt + Shift + n
Help menu in Google Chrome: Alt + h
other browsers: Alt + Shift + h
Accessibility menu in Google Chrome: Alt + a
(present when screen reader support is enabled) other browsers: Alt + Shift + a
Sheet menu Alt + Shift + s
(copy, delete, and other sheet actions)
Context menu Ctrl + Shift + \
Shift + F10
Add or change rows and columns
Insert rows above Ctrl + Alt + Shift + =
Ctrl + Alt + =
(with rows selected)
 
in Google Chrome: Alt + i, then r
other browsers: Alt + Shift + i, then r
Insert rows below in Google Chrome: Alt + i, then w
other browsers: Alt + Shift + i, then w
Insert columns to the left Ctrl + Alt + Shift + = 
Ctrl + Alt + = 
(with columns selected)
 
in Google Chrome: Alt + i, then c
other browsers: Alt + Shift + i, then c
Insert columns to the right in Google Chrome: Alt + i, then o
other browsers: Alt + Shift + i, then o
Delete rows Ctrl + Alt + - (with rows selected)
 
in Google Chrome: Alt + e, then d
other browsers: Alt + Shift + e, then d
Delete columns Ctrl + Alt + - (with columns selected)
 
in Google Chrome: Alt + e, then e
other browsers: Alt + Shift + e, then e
Hide row Ctrl + Alt + 9
Unhide row Ctrl + Shift + 9
Hide column Ctrl + Alt + 0
Unhide column Ctrl + Shift + 0
Group rows or columns Alt + Shift + Right Arrow
Ungroup rows or columns Alt + Shift + Left Arrow
Expand grouped rows or columns Alt + Shift + Down Arrow
Collapse grouped rows or columns Alt + Shift + Up Arrow
Use formulas
Show all formulas Ctrl + ~
Insert array formula Ctrl + Shift + Enter
Collapse an expanded array formula Ctrl + e
Show/hide formula help Shift + F1
(when entering a formula)
Full/compact formula help F1
(when entering a formula)
Absolute/relative references F4
(when entering a formula)
Toggle formula result previews F9
(when entering a formula)
Resize formula bar Ctrl + Up / Ctrl + Down
(move up or down)
Help for screen readers
Turn on screen reader support Ctrl + Alt + z
 
Enable braille support Ctrl + Alt + h
Read column Ctrl + Alt + Shift + c
Read row Ctrl + Alt + Shift + r