Category

ENGLISH ARTICLES

Category

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

We check time. We ask for more time. We loose time. We argue about time. But do we appreciate time? Make time to understand what is important and what is not. And do it before there is no time to do anything. #time #χρόνος #mindstormGR

Blogging is a way of expressing yourself. Of presenting who you really are. Try it and you will see that it will help you see things clearer. It will make you better as a person and as a professional. My Blog : www.mindstorm.gr #mindstormGR

Steps to import multiple posts to Wordpress with the use of Excel, Word and Ultimate CSV Importer Free Step 1 Find the content you would like to upload from your social media profile or anywhere else. Step 2 Use Microsoft Word, open existing word file : ‘word_to_html_source.docx’, delete previous content (if any), copy and edit your new content (paragraphs, spaces, bold or italic words) and save the file. Step 3 Open excel file ‘wordpress_database_schema.xlsm’ and press the button ‘Add <div> to word file’. This will create a new file : ‘word_to_html_target.docx’. Open it and copy the content of the file into the ‘post_content’ column. Step 3 is important if you want to keep the styling of the content. Step 4 Go to sheet ‘field_values’, find table with column names ‘post_title’ and ‘post_name’ and type your content accordingly. Return to sheet ‘wp_posts’ and complete the necessary columns. Begin with selecting from…

– Houston, I think we have multiple problems. There are so many “NO SIGNAL” signs on. No signal of normal growth, no signal of steady income, no signal of peace, no signal of respect to human life, no signal of respect to free will, no signal of seeing each other, no signal of talking to each other, no signal of touching each other, no signal of kissing each other, no signal of hugging each other, no signal of thinking straight, no signal of breathing, no signal of dreaming, no signal of planning ahead, no signal of living normally. – Don’t worry. Stay inside till further notice! Εκινήθης. Γιατί εκινήθης χωρίς οδηγίες εκ των άνωθεν; #reality #mindstormGR

1) Creation of SKU QR Codes in Excel with a button (VBA) 2) Creation of Product URL QR Codes in Excel with a button (VBA) 3) Creation of SKU Barcodes in Excel with a button (VBA) 4) Update of ‘Product’ Column with SKU, Name, Attribute 1 value(s), Attribute 2 value(s), Type and Regular Price with a button (VBA) – two versions 5) Creation of a word file with SKU Barcode Labels based on quantity with a button (VBA) – SKU can be scanned on labels – 3 labels per row, 15 labels per page 6) Creation of a word file with SKU Barcode Labels based on quantity with a button (VBA) – SKU cannot be scanned on labels – 3 labels per row, 15 labels per page YouTube

Sheet ‘Jan’ is the Product List of Supplier A for January. Sheet ‘Feb’ is the Product List of Supplier A for February. Compare them and do the following: 1) Add columns ‘Status’ and ‘Previous Price’ 2) Highlight new SKUs with yellow color with a button (VBA) 3) Highlight existing SKUs with different price with green color (VBA) and update columns ‘Status’ and ‘Previous Price’ 4) Clear Row highlights with a button (VBA) 5) Delete columns ‘Status’ and ‘Previous Price’ YouTube #mindstormGR #excel_tips / www.mindstorm.gr

Sales Data Analysis Tasks 1) Get New Sales Raw Data (table) 2) Change sorting for Sales Raw Data using field ‘Value’ DESC (descending order) and then field ‘Country’ ASC (ascending order) 3) Create 5 Pivot Tables Total Sales by Country Total Sales by Salesperson Total Sales by Customer Total Sales by Product Category Total Sales by Product Description 4) Change sorting to all 5 Pivot Tables Total Sales by Country DESC Total Sales by Salesperson DESC Total Sales by Customer DESC Total Sales by Product Category DESC Total Sales by Product Description DESC YouTube video:  Create 5 Pivot Tables with a button (VBA) FB Tags: #vba #data_analysis #excel_tips #mindstormGR

Pin It

By continuing to use the site, you agree to the use of cookies. / Συνεχίζοντας να χρησιμοποιείτε την ιστοσελίδα, συμφωνείτε με τη χρήση των cookies. more information / περισσότερες πληροφορίες

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close