Why set SMART goals Goals give you direction. It allows you to stay mentally and physically focused on the road to where you want to go. Specific Measurable Achievable Relevant Time-bound Οι στόχοι βοηθούν στην επίτευξη του σκοπού όταν είναι…
Excel Task Create a vertical calendar for 2024 till 2028. Show all the dates for the year selected from a drop-down list. Set the background color for weekdays Saturday and Sunday to blue. Set the background color for non-working days…
List of files in Excel and preview of images – VBA Code – Excel 1) Is it possible to have a list of the images found in a folder and its subfolders in Excel? 2) Is it possible to see…
How to quickly hide unused cells, rows and columns in Excel – Scroll area with VBA A1:E50 The Sub below is assigned with macro to button Limit Scroll to existing rows and columns for ‘Sheet1‘ Watch video on YouTube Sub…
How to calculate discount, sale price and profit margin after discount? 1) Find the original price (for example 90€) 2) Get the discount percentage (for example 20%) 3) Calculate the savings: 20% of 90€ = 18€. 4) Subtract the savings…
Don’t quit When things go wrong, as they will sometimes will;
Hide and Show the Excel Interface Here you can see the code to hide and show the Excel Interface. Watch the video on YouTube : https://youtu.be/DUawostxMsc #mindstormGR #vbacode #excel / www.mindstorm.gr
Calculate loan amount and monthly payment / Υπολογισμός ποσού δανείου και μηνιαίας δόσης για 5 διαφορετικά ετήσια επιτόκια YouTube Video & VBA code credit : Trifon Papadopoulos #mindstormGR / www.mindstorm.gr
How to freeze and Unfreeze given columns and rows in Excel with VBA code (in english) Video credit : Trifon Papadopoulos VBA Code #mindstormGR / www.mindstorm.gr
Debt’s vicious cycle / Ο φαύλος κύκλος του χρέους Need cash -> Take loan -> Pay interest -> Reduced cashflow -> Need cash -> Increase loan -> Pay interest Let’s suppose that you need cash 100€, succeed in taking a…
