Hi Friends,
I hope you all are doing well and enjoy the learning by watching the videos and sharing it with your friends and family members.

I am sharing one question below please try to answer this.

Question:-
What is the Pivot table function?

Waiting for more replies!

Question: - What is “Paste Special in Excel?
Answer: - “Paste Special” is same as “Paste” which is available in M.S. Office. “Paste Special” will help to copy or cut and paste the content from one location to another location with different formatting.
As options given in below picture which will discuss one by one in coming days: -

➡️Question: -
Shortcut key for “Paste Special”.
➡️Answer: -
Ctrl + Alt + V
Alt + E + S

❗️Note: - This “Paste Special” only works if you have copied or cut some data.

Topic :- Pivot Table 💡


🚥Pivot table is one of the Excel's most powerful feature. It help in interactive way to quickly summarize large amounts of data.

You can use a Pivot Table to analyze numerical data in detail and extract the significance from a large, detailed data set.

You can find Pivot table in Insert Tab.

Go to Insert Tab > Select any data set > Click on PivotTable

Shortcut Keys

Ctrl+A - Select All
Ctrl+B - Bold
Ctrl+C - Copy
Ctrl+D - Fill Down
Ctrl+F - Find
Ctrl+G - Goto
Ctrl+H - Replace
Ctrl+I - Italic
Ctrl+K - Insert Hyperlink
Ctrl+N - New Workbook
Ctrl+O - Open
Ctrl+P - Print
Ctrl+R - Fill Right
Ctrl+S - Save
Ctrl+U - Underline
Ctrl+V - Paste
Ctrl W - Close
Ctrl+X - Cut
Ctrl+Y - Repeat
Ctrl+Z - Undo

Shortcut Keys with use of Function keys.

F1 - Help
F2 - Edit
F3 - Paste Name
F4 - Repeat the last action
F4 - While typing a formula, switch between absolute/relative reference
F5 - Goto
F6 - Next Pane
F7 - Spell check
F8 - Extend mode
F9 - Recalculate all workbooks
F10 - Activate Menu bar
F11 - New Chart
F12 - Save As