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
Λίστα πραγμάτων που πρέπει να κάνετε – To do list – Excel Εδώ βλέπετε τη δημιουργία μιας λίστας πραγμάτων που πρέπει να κάνετε. Video – How it works Η λίστα δημιουργήθηκε με κώδικα VBA και τα δεδομένα καταχωρούνται τόσο στο…
How to automatically send customized emails with attachments using excel macros via Outlook #officeautomation #outlook #excel #email_reminders #customized_emails #excel_tips www.mindstorm.gr
EXAMPLE OF PIVOT TABLE 1. Select any cell in the data dump > Select Insert > Select Table Then, create a PivotTable from that table: 2. In the Insert tab, select Recommended PivotTables Choose from one of Excel’s Recommended PivotTables.…
The AutoSum shortcut, ALT+= (ALT and = at the same time), allows you to automatically sum rows and/or columns. Select Region Before AutoSum If the current cell is in the column you want to sum i.e. B5, press CTRL+A to…
This is a result of vba code. You can see the table Calendar on Sheet1 and how it is when you copy the HTML created code to a wordpress post. The table will adjust well both on desktop and mobile…
Task to Complete Excel Table > XML file > Microsoft Access Table 1) Create an XML file from Simple Data Table found in sheet ‘data’ in your excel file and name it “ExtendedDataTableToXMLwithDataRow6.xml”. 2) Create an appropriate database schema for…
Find Discount % and Discount Value for Actual Sales that are higher or equal to Target Sales given by your Suppliers. Use functions IF and VLOOKUP. Formula for cell H4 (Discount %) =IF(E4>=G4;”Discount “&VLOOKUP(F4;$M$4:$O$13;3;FALSE)*100&”%”;”No Discount”) Formula for cell I4 (Discount…
- 239 E 5th St, New York NY 10003, USA
Important Links.
Instagram Feed.
User id is not set yet! Please go to settings and set the user id.
© 2021, Sassico. All Rights Reserved.
Made with by 
XpeedStudio