Register now or log in to join your professional community.
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