In this video, I have tried to demonstrate the 10 most useful tips and tricks used in the financial world. (Some bonus Tips & tricks also included)
It will benefit everyone, whether you are a student, a financial expert, a banker, or and ordinary excel user.
Rather than following the list, I have tried to build a story along with several other bonus tips & tricks to ensure that everyone can organize and present their data well using only Keyboard shortcuts.
+++++++++++++++++++++++++++++++++++++++++++++++++
Mic used to Record (Amazon Link):
Boya BYM1 Omnidirectional Lavalier: https://amzn.to/3iqdF02
+++++++++++++++++++++++++++++++++++++++++++++++++
1 Alt + = Auto Sum
2 Alt + T + U + T Trace Precedents
3 Alt + T + U + D Trace Dependents
4 Alt + T + U + A Clear Trace All
5 Ctlr + [ Go to Precedent
6 F5 / Ctrl + G Go Back to Dependent
7 F4/ Ctrl + Y Repeat Function
8 Ctrl + Arrows Move to Last
9 Alt + Enter with Alt + H + W Next Line in same cell & wrap text
10 Alt + E + S + … V/ T others Paste Special Values
Watch More:
1. Excel Shortcuts | Part 01 – CTRL-A to CTRL-Z | https://youtu.be/TB4-829-NUc
2. Excel Shortcuts | Part 02 – Function Keys (Fn+) | https://youtu.be/Yv3gNyc7-Fk
3. Excel Shortcuts | Part 03 – Ctrl+ | https://youtu.be/LhhcCiwZNeE
4. Excel Shortcuts | Part 04- Shift + Function Keys | https://youtu.be/-UB1WbaZVuU
5. Excel Shortcuts | Part 05 & 06 – Ctrl + Fn keys & F10 | https://youtu.be/E7VJVCOfoSE
6. Excel Shortcuts | Part 07- 10- Alt + Function Keys & More | https://youtu.be/nj3LAg1Xn54
7. Excel Shortcuts | Part 11- Ctrl + Shift | https://youtu.be/cbK6eKAux4U
8. Excel Shortcuts | Part 12 – Miscellaneous | https://youtu.be/h0hcGkegQk0
11. Excel Shortcuts | 10 Top Most Useful Excel Tips & Tricks | Microsoft Excel | https://youtu.be/WJsRaSncecE
21. Hosting | How to Change Name Servers (Hosting/ DNS) in Godaddy (Hindi) | https://youtu.be/qSO1-xnMDio
22. MS Office | How to get MS Office 365 FREE (in HINDI) | https://youtu.be/qhTveUifY-0
23. MS Office | How to get MS Office 365 FREE (Legal Version) | https://youtu.be/SW1Gr5BvXv4
24. MS Office | Capture Whiteboard Data to MS Word or PDF… Add notes, scribble & more SOLVED | https://youtu.be/BauXJZJYEzc
25. MS Office | FREE Microsoft Office Legal Version | mobile | iPhone | Android | https://youtu.be/6itDwc4ggK8
Intro: (00:00)
AutoSize Column Width: (01:18)
Add All Borders: (02:40)
Freeze Panes: (03:30)
Filter View: (04:15)
Convert to Table: (04:40)
Control + Arrows: (06:36)
Find & Replace in cell: (08:10)
Change to number format: (08:45)
AutoSum: (09:45)
Audit Function: (11:55)
Ctrl + [: (14:37)
Repeat Function (15:45)
Clear All: (16:43)
Insert next line in a Cell: (17:35)
Paste Special: (19:40)
Outro: (22:00)
The amazon link provided above is Amazon Affiliate Link. If you buy using this link you will not pay anything extra but I might get entitled to a few pennies.
Tags
advanced excel, advanced excel tricks, Best Excel Magic Tricks, computer user, excel, Excel Magic, excel magic tricks, excel shortcut keys, excel tips, excel tips 2020, excel tips and tricks, excel tips and tricks 2020, excel tips and tricks you must know, excel tricks, excel tricks 2020, excel tutorial, excel user, learn excel, microsoft excel, microsoft excel software, microsoft excel tips, ms excel, ms office user, solved.co.in, tricks, excel tips and tricks, Ultimate Excel Tips and Tricks for 2020, 10 Advanced Excel Tips and Tricks 2020, Best Excel Magic Tricks 2020
Music: https://www.bensound.com
