People will remember / Οι άνθρωποι θυμούνται How you made them feel / Πως τους έκανες να αισθανθούν The time you spent with them / Το χρόνο που τους αφιέρωσες If you kept your word / Αν κράτησες το λόγο σου If they could count on you / Αν μπορούν να βασιστούν πάνω σου #mindstormGR
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
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 devices. Excel to HTML Responsive table Excel table HTML table Period Weekly Options Booked May 12 – May 19 2000 Row 1, Col 1 Row 1, Col 2 2 Text2_2 3 Text3_2 4 5 – – – – – metavliti – – – – – – – HTML created code <style>table { width: 100%; table-layout: fixed;}th, td { padding: 5px; text-align: center; overflow-wrap: break-word; word-wrap: break-word; hyphens: auto;}@media only screen and (max-width: 600px) { th, td { width: auto !important; }}</style><table border=’1′ cellspacing=’0′ cellpadding=’5′><tr><td>Period</td><td>Weekly</td><td>Options</td><td>Booked</td></tr><tr><td>May 12 – May 19</td><td>2000</td><td>Row 1, Col 1</td><td>Row 1, Col 2</td></tr><tr><td>2</td><td></td><td></td><td>Text2_2</td></tr><tr><td>3</td><td></td><td></td><td>Text3_2</td></tr><tr><td>4</td><td></td><td></td><td></td></tr><tr><td>5</td><td></td><td></td><td></td></tr><tr><td>-</td><td></td><td></td><td></td></tr><tr><td>-</td><td></td><td></td><td></td></tr><tr><td>-</td><td></td><td></td><td></td></tr><tr><td>-</td><td></td><td></td><td></td></tr><tr><td>-</td><td></td><td></td><td></td></tr><tr><td>metavliti</td><td></td><td></td><td></td></tr><tr><td>-</td><td></td><td></td><td></td></tr><tr><td>-</td><td></td><td></td><td></td></tr><tr><td>-</td><td></td><td></td><td></td></tr><tr><td>-</td><td></td><td></td><td></td></tr><tr><td>-</td><td></td><td></td><td></td></tr><tr><td>-</td><td></td><td></td><td></td></tr><tr><td>-</td><td></td><td></td><td></td></tr></table>
We can’t feed the poor but we can fund a war. / Δεν μπορούμε να ταΐσουμε τους φτωχούς αλλά μπορούμε να χρηματοδοτήσουμε έναν πόλεμο. Accordingly / Αντιστοίχως =>We can’t fund adequately the public hospitals but we can ask funds to invest more on private hospitals. / Δεν μπορούμε να χρηματοδοτήσουμε επαρκώς τα δημόσια νοσοκομεία αλλά μπορούμε να ζητήσουμε από funds να χρηματοδοτήσουν τα ιδιωτικά. =>We can’t fund adequately the public academic institutions but we can ask funds to invest more on private academic institutions. / Δεν μπορούμε να χρηματοδοτήσουμε επαρκώς τα δημόσια Πανεπιστήμια αλλά μπορούμε να ζητήσουμε από funds να χρηματοδοτήσουν τα ιδιωτικά. =>We can’t fund adequately the different sex family to raise kids but we can ask the same sex family to invest more on raising kids. / Δεν μπορούμε να χρηματοδοτήσουμε επαρκώς δύο ανθρώπους διαφορετικού φύλου να δημιουργήσουν οικογένεια αλλά μπορούμε να θεσμοθετήσουμε και να ζητήσουμε από ανθρώπους…
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 each field (Product_Name, Category, Price, Quantity_Sold, Revenue) and name it “table1.xsd”. 3) Import data found in “ExtendedDataTableToXMLwithDataRow6.xml” file using database schema : “table1.xsd”, to table : ‘Table1″ in MICROSOFT ACCESS. 4) Check that imported data to MICROSOFT ACCESS Table : “Table1” are the same with Simple Data Table found in sheet ‘data’ in your excel file. #mindstormGR #excel #vba #xml_files #databases #microsoft_access / www.mindstorm.gr
CMS stands for Content Management System. It is a software application or set of related programs that are used to create and manage digital content. CMS platforms allow users to easily create, edit, organize, and publish content on websites without requiring technical knowledge of coding or programming languages. Some common features of CMS include: Content creation and editing: Users can create, edit, and format content using a simple interface similar to word processing software. Content storage and organization: Content is stored in a structured manner, often using a database, making it easy to organize and retrieve. User management: CMS allows for different user roles and permissions, enabling multiple users to collaborate on content creation and management. Version control: CMS typically provides version control features, allowing users to track changes made to content and revert to previous versions if needed. Publishing: CMS platforms often include publishing tools that allow users to…
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 Value) =IF(E4>=G4;VLOOKUP(F4;$M$4:$O$13;3;FALSE)*E4;”No Discount”) YouTube video #mindstormGR #discount
Calculate the days of work between two dates with the NETWORKDAYS function Start Date: 15/5/2020 End Date: 28/1/2021 Holiday 1: 26/8/2020 Holiday 2: 18/11/2020 Holiday 3: 15/1/2021 Calculate the days between two dates with the NETWORKDAYS function excluding Holiday 1, Holiday 2 and Holiday 3. Saturday and Sunday are omitted. Result Number of days between the two dates: 182 #softexperia #excel_tips
Fixing Europe, fixing Greece, fixing our lifes, fixing our mistakes, fixing our work, fixing our relationships. One small problem, though. You have to have people that breath and live normally to fix things. To fix life. To prosper. But this last decade is different. According to economic and social figures, a lot of our people are no longer out there. And many of those that are still hanging out there, they act as zombies. Looking forward to see what will happen in the future. #mindstormGR