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.
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
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: bensound. com
