What are the Tips & Tricks you know about excel or calc , and If you use macros please explain some of there usage ?

excel contains a punch of tricks the best trick is doing  the large stuff that takes so many time by others in just less than few seconds by using some formulas and equations

with Macros specially VB Macros you can create Data Entry Form or even user login form.

Excel is a king of Tricks and Calculations. you can have any kind of calculation at what ever level and whatever extent.

Yes, I'm using Visual Basics macros and writing codes at the same sheet, link it with another sheet, trick like change field color, set a sound ... etc