To perform a task more quickly than by using a mouse or other input device.
 |
| 'F5' is the shortcut key for go to specific cell |
 |
| 'Ctrl + 1' is the shortcut key for format cells |
 |
| 'Ctrl + space' is the shortcut key for select entire row |
 |
| 'Shift + space' is the shortcut key for select entire column |
 |
| 'Shift + F3' is the shortcut key for open excel formula window |
 |
| 'F11' is the shortcut key create chart from selected data |
 |
| 'F4' is the shortcut key repeat the first action |
 |
| Shortcut key |
Formulas
SUM
Add the numbers.
1. =SUM(E3:E17) --- Means count E3 to E17 cells values.
2. =SUM(E3, E17) ----Means count E3 and E17 cells values
Shortcut method for sum
MAX
Find the maximum number.1. =MAX(E3:E17) --- Means compare E3 to E17 cells values.
Shortcut method for getting max value
MIN
Find the minimum number.1. =Min(E3:E17) ---Means compare E3 to E17 cells values.
Shortcut method for getting min value
AVERAGE
Find the average value
1. =AVERAGE(E3:E17) ----Means count E3 to E17 cells values.
2. =AVARAGE(E3,E17) ----Means count E3 and E17 cells values.
Shortcut method for getting average value
PRODUCT
Find the product of the numbers.
1. =PRODUCT(E3:E17) ----Means multify E3 to E17 cells values.
1. =PRODUCT(E3:E17) ----Means multify E3 to E17 cells values.
2. =PRODUCT(E3,E17) ----Means multify E3 and E17 cells values.
Shortcut method for getting product value
COUNT
Count the number cells.
1. =COUNT(D3:D17) -----Means count E3 to E17 cells.
1. =COUNT(D3:D17) -----Means count E3 to E17 cells.
2. =COUNTA(D3:D17) ----- Means count E3 to E17 cells.
Shortcut method for getting count value
COUNTBLANK
Count the blank cells.
1. =COUNTBLANK(D3:D17) ------Means count E3 to E17 cells.
1. =COUNTBLANK(D3:D17) ------Means count E3 to E17 cells.
Shortcut method for getting countblank value
Vlookup & Hlookup
When the Vlookup function is called, excel searches for a lookup value in the leftmost column of the section of your spreadsheet called the table array. The V in Vlookup stands for vertical search (in a single column), while the H in Hlookup stands for horizontal search (within a single row).
Vlookup
Select table and save one name
Step 2
=Vlookup (lookup_value, table_array, index_column_number,approximate match value takes '1' and exact value match takes '0')
=Vlookup(A9, guru1, 4, 0)
Step 3
Output
Hlookup
The H in Hlookup stands for horizontal search. It is used to find the particular data in spreadsheet.
Step 1
Select table and save one name
Step 2
=Hlookup (lookup_value, table_array, index_column_number,approximate match value takes '1' and exact value match takes '0')
=Hlookup(D3, guru3, 9 or A11, 0)
Step 3
Output
Mail merge using spread sheet data
Step 1
Create data in excel spread sheet and save it.
Step 2
Create wishes letter in word
Step 3
1. Go to mailings
2. Go to select recipients
3. Click use an existing list and insert the saved excel spread sheet.
Macros
A macro is an automatic input sequence that imitates keystrokes. a macro is typically used to replace a repetitive series of keyboard and mouse actions.
Step 1
1. Open excel spread sheet.
2. Enter some details
Step 2
1. Click on the view
2. Go to macros
3. Click use relative reference for view macro in required place.
Step 3
1. Go to macros
2. Click the record macro
3. Open the record macro window
4. Give the macro name
5. Click OK.
Step 4
Record the details
Step 5
1. Go to macros
2. Click the stop recording.
Step 6
1. Go to new spread sheet
2. Enter some details
3. Select the cell
4. Go to macros
5. Click view macros
6. Select the macro name
7. Click Run.
Step 7
Output
Font files - Download and install
Font files contains one or more fonts that can be approach through the operating system.
Step 1
Go to internet and download the helvetica regular font
Step 2
Copy the downloaded helvetica regular font.
Step 3
Go to windows settings and search the fonts.
Step 4
Paste the halvetica regular font in windows 10 font files.
Step 5
Helvetica regular font added the windows 10 fonts.
Step 6
Automatically helvetica font adding the excel.
Format cells
We change the appearance of number without changing the number itself. We can apply a format (0.8, $0.8, 80%, etc) or other formatting (alignment, font, border, etc).
Date formats
Currency formats
COUNTIF
Find the salary ranges.
1. =COUNTIF(D3:D17, ">300") --------Means count E3 to E17 cells.
Shortcut method for find ">300" daily wages workman1. =COUNTIF(D3:D17, ">300") --------Means count E3 to E17 cells.
Vlookup & Hlookup
When the Vlookup function is called, excel searches for a lookup value in the leftmost column of the section of your spreadsheet called the table array. The V in Vlookup stands for vertical search (in a single column), while the H in Hlookup stands for horizontal search (within a single row).
Vlookup
The V in Vlookup stands for vertical search. It is used to find the particular data in spreadsheet.
Step 1Select table and save one name
Step 2
=Vlookup (lookup_value, table_array, index_column_number,approximate match value takes '1' and exact value match takes '0')
=Vlookup(A9, guru1, 4, 0)
Output
Hlookup
The H in Hlookup stands for horizontal search. It is used to find the particular data in spreadsheet.
Step 1
Select table and save one name
Step 2
=Hlookup (lookup_value, table_array, index_column_number,approximate match value takes '1' and exact value match takes '0')
=Hlookup(D3, guru3, 9 or A11, 0)
Output
Mail merge using spread sheet data
Step 1
Create data in excel spread sheet and save it.
Step 2
Create wishes letter in word
Step 3
1. Go to mailings
2. Go to select recipients
3. Click use an existing list and insert the saved excel spread sheet.
Step 4
1. Go to insert merge field
2. Then opened the columns, to insert the correct column fields in letter.
Step 5
1. Go to finish & merge.
2. Click the edit individual documents.
Step 6
Then opened the three letter with excel spread sheet data.
 |
| First letter |
 |
| Second letter |
 |
| Third letter |
Macros
A macro is an automatic input sequence that imitates keystrokes. a macro is typically used to replace a repetitive series of keyboard and mouse actions.
Step 1
1. Open excel spread sheet.
2. Enter some details
Step 2
1. Click on the view
2. Go to macros
3. Click use relative reference for view macro in required place.
Step 3
1. Go to macros
2. Click the record macro
3. Open the record macro window
4. Give the macro name
5. Click OK.
Record the details
Step 5
1. Go to macros
2. Click the stop recording.
Step 6
1. Go to new spread sheet
2. Enter some details
3. Select the cell
4. Go to macros
5. Click view macros
6. Select the macro name
7. Click Run.
Output
Font files - Download and install
Font files contains one or more fonts that can be approach through the operating system.
Step 1
Go to internet and download the helvetica regular font
Copy the downloaded helvetica regular font.
Step 3
Go to windows settings and search the fonts.
Paste the halvetica regular font in windows 10 font files.
Step 5
Helvetica regular font added the windows 10 fonts.
Step 6
Automatically helvetica font adding the excel.
Format cells
We change the appearance of number without changing the number itself. We can apply a format (0.8, $0.8, 80%, etc) or other formatting (alignment, font, border, etc).
Date formats
Time formats
Currency formats
Percentage format
Excel
Reviewed by Unknown
on
October 13, 2017
Rating:
Reviewed by Unknown
on
October 13, 2017
Rating:
New comments are not allowed.