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 the images as I move from one row to another? 3) Is it possible to see the actual image, its name and other info as I scroll down? 4) Is it possible to rename images in source folder according to a rule such as Last Subfolder & ID & FileName, and then copy all renamed images to another folder (target folder)? 5) Is it possible to have all images as they were in the source folder? Yes, it is. Check this video on YouTube and watch it happening. VBA Code credit : Trifon Papadopoulos #mindstormGR #list_of_images_in_excel Δείτε επίσης Import of multiple posts to WordPress with the use of Excel, Word…
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 UnhideAndUnscrollSheet() ‘Button <<Limit Scroll to existing rows and columns for ‘Sheet1’>> Dim ws As Worksheet Dim lastRow As Long Set ws = ThisWorkbook.Sheets(“Sheet1”) ‘ Unhide all rows and columns ws.Rows.Hidden = False ws.Columns.Hidden = False ‘ Set cell B1 to bold ws.Range(“B1”).Font.Bold = True ‘ Set headers in row 3 to bold ws.Rows(3).Font.Bold = True ‘ Set all columns to font size 13 ws.Cells.Font.Size = 13 ‘ Set cell B1 to font size 16 ws.Range(“B1”).Font.Size = 16 ‘ Set all rows and columns to a reasonable height and width ws.Rows.RowHeight = 15 ‘ You can adjust this value as needed ws.Columns.ColumnWidth = 20 ‘ You can adjust this value as…
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 from the original price to get the sale price: 90€ – 18€ = 72€. 5) Subtract Buy Price from the Sale Price and divide it by Sale Price to get the Profit margin after discount: (72€ – 50€)/72€=30,56% You’re all set! #softexperia #mindstormGR #excel_skills
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 loan 100€ and pay an interest of 2,5 % periodically. Let’s see where you stand now : Need cash 100€ -> Take loan 100€ -> Pay interest 100 – (100 × 2,5%) = 2,5€ -> Reduced cashflow 100 – 2,5 = 97,5€ -> Need cash again 100€ -> Increase loan 100 + 2,5 = 102,5€ -> Pay interest 102,5 × 2,5% = 2,56€ (rounded) -> Reduced cashflow 102,5 – (102,5 × 2,5%) = 99,94€ That is why financial organizations ask periodically for your turnover, profit margin and cashflow + guarantee. They want to know if everything works fine for them in any given period. If not, they will need to…
Καλά, γρήγορα ή φτηνά | Good, fast or cheap: Διαλέξτε δύο από τα τρία. Η γεωμετρία ενός τριγώνου είναι τέτοια, ώστε οι πλευρές του να είναι αλληλοεξαρτώμενες. Δεν είναι δυνατή η τροποποίηση μιας πλευράς χωρίς να επηρεαστεί το τρίγωνο. Το τρίγωνο ποιότητας-χρόνου-κόστους (good-fast-cheap) δείχνει ότι, εάν κάποιος θέλει εργασία υψηλής ποιότητας-good (πρώτη πλευρά) και γρήγορα-fast (δεύτερη πλευρά), πρέπει να εκχωρήσει μέρος του ελέγχου της τρίτης πλευράς-cheap και να πληρώσει μεγαλύτερο τίμημα. Ανάλογα με την προτεραιότητα, αλλάζει και η γεωμετρία. Εσείς ποια δύο απο τα τρία χαρακτηριστικά ενός προϊόντος/υπηρεσίας, (ποιότητα-χρόνος-κόστος) θα διαλέγατε; 1. Χρόνος (fast) 2. Ποιότητα (good) 3. Τιμή (cheap) Μπορείτε να διαλέξετε 2 από τα 3 χαρακτηριστικά. Ποια θα διαλέγατε; #επιλογή #προϊόντα #υπηρεσίες #mindstormGR #softexperia
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. In this example, we have chosen to summarize Sum of Sales (in thousands) by Region, Month and Product. If you change your data dump, choose Analyze and then Refresh All, to refresh data in pivot table. #softexperia #excel_tips_softexperia #pivot_tables_softexperia
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 select all of the numbers in the columns, then press ALT = OR Use your mouse to select the columns and rows – A5:E18 – you want to sum, making sure the last column and row are empty as this is where the autosum will go. #excel_tips_softexperia #softexperia #excel_functions.
The ‘must haves’ in business today / Τι πρέπει να έχει και να κάνει ένας επιχειρηματίας σήμερα; – Can you read and do you read? Μπορείς να διαβάζεις και πόσο διαβάζεις; – Can you write and do you write? Μπορείς να γράφεις και πόσο γράφεις; – Can you add up? Μπορείς να συνοψίζεις; – Can you think fast? Μπορείς να σκέφτεσαι γρήγορα; – Can you perform simple tasks consistently well? Μπορείς να κάνεις σωστά απλές συστημικές εργασίες; – Can you show initiative? Μπορείς να παίρνεις πρωτοβουλίες; – Can you do what you are told? Μπορείς να κάνεις ότι σου λένε; – Can you present well yourself and your thoughts? Μπορείς να παρουσιάζεις καλά τον ευατό σου και τις σκέψεις σου; #mindstormGR #business #skills #reality #πραγματικότητα #matchmeGR
