We give coins, and most of us think of an exchange rather than a change. Do we really want a change, after all? Or is it all about keeping some people UNCHANGED, UNKNOWN and UNSEEN and as far as possible away from us? #mindstormGR
1) Add products from sheet WORDPRESS to your eShop, with a csv file. 2) Check if products are OK. 3) Now there are again updates (variations) for new and existing products. Compare products between excel sheets WORDPRESS and SAP, and find the new ones from sheet SAP that you need to add again to your eShop. Add any new or existing products with variations (color, size) to your eShop from sheet Comparison, with a second csv file. 4) Check if all variations for new and existing products are OK. Video link: https://youtu.be/bufrzPYGHtg Credit : Trifon Papadopoulos #wordpress #woocommerce #mindstormGR #excel_tips
Use ‘Sheet1’ (data) in excel file: sales_jan_feb_mar_2021_d.xlsx and do the following: 1) Read all columns of the excel file: sales_jan_feb_mar_2021_d.xlsx – 9 columns 2) Read specific columns of the excel file (Month, Actual_Sales, Customer, Salesperson): sales_jan_feb_mar_2021_d.xlsx – 4 columns 3) Create new excel file: Actual_Sales Mean by Salesperson.xlsx 4) Create new excel file: Actual_Sales Mean by Customer.xlsx 5) Create new excel file: Actual_Sales Mean by Month.xlsx 6) Create new tab: ActSalesMean by Salesperson in existing excel file: sales_jan_feb_mar_2021_d.xlsx and find actual sales mean by salesperson 7) Create new tab: ActSalesMean by Customer in existing excel file: sales_jan_feb_mar_2021_d.xlsx and find actual sales mean by customer 8) Create new tab: ActSalesMean by Month in existing excel file: sales_jan_feb_mar_2021_d.xlsx and find actual sales mean by month 9) Plot Actual_Sales Mean for 3, 4 and 5 10) Change styling of columns (font, alignment) for tabs: ‘ActSalesMean by Salesperson’, ‘ActSalesMean by Customer’, ‘ActSalesMean by Month’…
– Be available when your customers want to buy. – Have people and not machines answering the phone. – Have friendly staff. – Identify the reasons your customers are leaving and fix them. – Identify the reasons your customers are buying and enhance them. – Be your own customer. Would you do business with you? #mindstormGR #softexperia
1. No need 2. No money 3. No hurry 4. No desire 5. No trust ~ Zig Ziglar #sale #need #desire #trust #money #hurry #softexperia See also Finding your passion isn’t just about careers and money. It’s about finding your authentic self. The one you’ve buried beneath other people’s needs. ~ Kristin Hannah #mindstormGR
Use of chatGPT and YouTube to become a Data Analyst – Χρήση του chatGPT και του YouTube για να κάνει κάποιος ανάλυση δεδομένων Code file: app.py Folder: C:\PythonPrograms\data_analysis_with_chatGPT 1) Merge multiple excel files – Συγχώνευση πολλών αρχείων excel data1.xlsx data2.xlsx data3.xlsx data4.xlsx 2) Clean data – Καθαρισμός δεδομένων 3) Create two excel reports (Total Revenue, Expenses and Profit by Category) and (Total Revenue, Expenses and Profit by Country) – Δημιουργία δύο αρχείων excel (category_report.xlsx and country_report.xlsx) 4) Add a chart to category_report.xlsx – Προσθήκη γραφήματος στο αρχείο excel category_report.xlsx 5) Add a chart to country_report.xlsx – Προσθήκη γραφήματος στο αρχείο excel country_report.xlsx 6) Build two interactive plots (category_chart.html and country_chart.html) 7) Create a streamlit dashboard with 2 graphs – Δημιουργία ενός πίνακα προβολής και διαχείρισης streamlit με 2 γραφήματα με τη βοήθεια της γλώσσας Python – with Python. Changed code by Trifonas Papadopoulos: #Code starts…
Filter employees by department in columns from mixed data Function for cell A7 =FILTER($G7:$G$33;$H$7:$H$33=A6) Function for cell B7 =FILTER($G7:$G$33;$H$7:$H$33=B6) Music track: A Positive Direction by Aylex Source: https://freetouse.com/music Royalty Free Music for Video (Safe) #mindstormGR #dynamic_filters #excel #educational
I find staircases endlessly inspiring, such a perfect opportunity for building a character in life. They teach you that you have to deal with your ups and downs if you want to make it work. Άνοδος και κάθοδος Με εμπνέουν οι σκάλες. Είναι μια τέλεια ευκαιρία για να γίνεις λίγο καλύτερος. Σε μαθαίνουν ότι πρέπει να αντιμετωπίσεις πρώτα τα δικά σου τα πάνω και τα κάτω. Πρέπει και να ανέβεις και να κατέβεις. Να βρεις τα πατήματά σου και τις ανάσες σου. Διαφορετικά δεν θα βρεις ούτε το σωστό σχέδιο ούτε το σωστό ρυθμό, και έτσι δεν θα μπορέσεις ούτε να δημιουργήσεις κάτι, ούτε να εμπνεύσεις κάποιον σ’ αυτήν τη ζωή. #mindstormGR