To be or not to be? Να ζω ή να μη ζω; To think or not to think? Να σκέφτομαι ή να μη σκέφτομαι; To lead or not to lead? Να προπορεύομαι ή να μην προπορεύομαι; To lie or not to lie? Να ψεύδομαι ή να μην ψεύδομαι; To dream or not to dream? Να ονειρεύομαι ή να μην ονειρεύομαι; To share or not to share? Να μοιράζομαι γνώσεις και εμπειρίες ή να μη μοιράζομαι; These are the questions! Ιδού οι απορίες! #mindstormGR
Simple data analysis of sales with filters, pivot table and charts Filters: ->Filter Electronics ->Filter Clothing ->Filter Quantity Sold<70 ->Filter Price>50 ->No filters Pivot table : ->Revenue per Category Charts : ->Revenue per Product Name ->Quantity sold per Product Name ->Revenue per Category Filename: simple_data_analysis.xlsm View Facebook post Download simple_data_analysis.zip (includes simple_data_analysis.xlsm)
Excel to Google Sheets Filename : C:\PythonPrograms\excel_to_google_sheets_with_python\demo_data_from_eshop_sales.xlsm Python script # copy_excel_to_googlesheets.py import pandas as pd from googleapiclient.discovery import build from google.oauth2.service_account import Credentials # ——————— # CONFIG # ——————— excel_file = “demo_data_from_eshop_sales.xlsm” sheet_name = “eshop_sales_data” google_sheet_id = “GOOGLE SHEET ID” credentials_file = “service_account.json” # ——————— # LOAD EXCEL (reads only used rows) # ——————— print(” Loading Excel file…”) df = pd.read_excel(excel_file, sheet_name=sheet_name) # Remove completely empty rows (just in case) df.dropna(how=”all”, inplace=True) # Replace NaN with empty strings (Google API requirement) df = df.fillna(“”) print(” Authenticating with Google…”) # ——————— # AUTHENTICATE # ——————— creds = Credentials.from_service_account_file( credentials_file, scopes=[“https://www.googleapis.com/auth/spreadsheets”] ) service = build(“sheets”, “v4″, credentials=creds) print(” Preparing data for upload…”) # ——————— # PREPARE DATA FOR GOOGLE SHEETS # ——————— values = [df.columns.tolist()] + df.astype(str).values.tolist() print(” Clearing existing Google Sheet data…”) # ——————— # CLEAR SHEET # ——————— service.spreadsheets().values().clear( spreadsheetId=google_sheet_id, range=”A1:Z15000″ ).execute()…
✅ Understanding Profit Margin, Markup, and Selling Price (With Example Table) When you run a business, knowing how to correctly price your products is essential. Two of the most common pricing metrics are profit margin and markup. Although people often mix them up, they are not the same thing. Let’s break it down using the example above, where every product has a €40.00 buy cost. ✅ 1. Profit Margin % Profit margin shows how much profit you earn as a percentage of the selling price. Example: Buy Price: €40.00 Profit Margin: 25% Sell Price becomes €53.33 Profit earned: €13.33 Formula: Sell Price = Buy Price / (1 − Profit Margin) ✅ 2. Sell Price This is the final price you charge the customer after applying the profit margin. You can see how the selling price increases as the margin goes up. Example: 10% margin → €44.44 selling price 40% margin…
24 ACCOUNTING BASICS THAT EVERYBODY NEEDS TO KNOW 1. ASSETS Resources owned by a business that have economic value. 2. LIABILITIES Obligations or debts owed by a business. 3. EQUITY The owner’s interest in the business. 4. REVENUE Income earned from normal business operations. 5. EXPENSES Costs incurred in the process of earning revenue. 6. PROFIT Financial gain after deducting expenses from revenue. 7. LOSS Occurs when expenses exceed revenue. 8. CASH FLOW The movement of money in and out of a business. 9. GROSS MARGIN Revenue minus the cost of goods sold. 10. NET INCOME Total revenue minus total expenses. 11. BALANCE SHEET Financial statement showing assets, liabilities, and equity. 12. INCOME STATEMENT Financial statement showing revenue, expenses, and profit over time. 13. CASHFLOW STATEMENTS Financial statement showing cash inflows and outflows. 14. DEBITS AND CREDITS Entries used to record transactions in double-entry accounting. 15. JOURNAL ENTRIES Records of…
Most Excel users rely on the Paste Special dialog box for one thing: pasting values. But there are many Paste Special options that can work Excel magic if you know how to use them. In this post, I’ll share one of my favourite shortcuts to transform messy data into clean, well-organized spreadsheets while speeding up your workflow. EN – Increase Values with Multiplication Another powerful use of Paste Special is to increase values by a specific percentage. For example, you can quickly create a sales forecast by increasing current sales by 7%. Just type 1.07 in a cell, copy it, Select the sales values, Open Paste Special (CTRL+ALT+V), choose Multiply, Rename the column to reflect the new forecasted values. GR – Αύξηση Τιμών με Πολλαπλασιασμό Μια ακόμη ισχυρή χρήση του Paste Special είναι να αυξήσετε τιμές κατά ένα συγκεκριμένο ποσοστό. Για παράδειγμα, μπορείτε γρήγορα να δημιουργήσετε μια πρόβλεψη πωλήσεων αυξάνοντας…
Business Ownership, Base Rates, Debt & Credit Ratings 1. Business Ownership – Importance Business ownership affects control, liability, taxes, profit sharing, ability to grow, and access to finance. 2. Types of Business Ownership A. Sole Trader – Owned by one person, simple to set up, full control. – Unlimited liability, harder to raise finance. B. Partnership – 2–20 owners, shared workload and skills. – Profit sharing, potential disputes, liability depends on type. C. Limited Company (Ltd) – Separate legal identity, limited liability, can raise more funds. – More regulation and administration. D. Public Limited Company (PLC) – Shares can be publicly traded, raises large finance. – High regulation, shareholder pressure. 3. Base Rate – Interest rate set by central banks. – High base rate: borrowing expensive, inflation falls. – Low base rate: borrowing cheap, economy grows. 4. Debt – Borrowed money to be repaid with interest. Personal debts: student loans,…
An easy trick to get more “Yes’s” – Negotiation Mastery I never ask an important question that I am looking for “yes”. I am always looking for “no”. Instead of saying “Have you got a few minutes to talk?”, “Is now a bad time to talk?” Instead of saying “Do you mind if I propose an idea?” I say “Are you against me sharing an idea?” It’s really simple. “Do you agree?” becomes Do you “disagree?” “Is this a good idea?” becomes “Is this a bad idea?” Take your question where you are looking for “yes” and just switch it to a “no”.
Addicted to story – Εθισμένοι στην ιστορία We are as a species, addicted to story. Even when the body goes to sleep, the mind stays up all night, telling itself stories. ~ Τζόναθαν Γκότσχολ (Jonathan Gottschall) Συγγραφέας – Writer Ως είδος, είμαστε εθισμένοι στην ιστορία. Ακόμα και όταν το σώμα μας πάει για ύπνο, το μυαλό μας μένει ξύπνιο και φτιάχνει τις δικές του ή τις δικές μας ιστορίες.
Only great pain, the long, slow pain that takes its time… compels us to descend to our ultimate depths… I doubt that such pain makes us “better”; but I know it makes us more profound… From such abysses, from such severe sickness, one returns newborn, having shed one’s skin… with merrier senses, with a second dangerous innocence in joy, more childlike and yet a hundred times subtler than one has ever been before. Quote by Friedrich Nietzsche Ελεύθερη μετάφραση στα ελληνικά Μόνο ο μεγάλος πόνος, ο μακρύς, αργός πόνος που παίρνει τον χρόνο του… μας αναγκάζει να κατέβουμε στα έσχατα βάθη μας… Αμφιβάλλω αν αυτός ο πόνος μας κάνει «καλύτερους» – αλλά ξέρω ότι μας κάνει να ψάξουμε βαθύτερα μέσα μας… Από τέτοιες αβύσσους, από τέτοια βαριά αρρώστια, επιστρέφει κανείς αναγεννημένος, έχοντας αποτινάξει το δέρμα του… με πιο χαρούμενες αισθήσεις, με μια δεύτερη επικίνδυνη αθωότητα στη χαρά, πιο παιδική και…
Self-discipline is the ability to make yourself do, what you should do, when you do it, whether you feel like it or not. You see, anybody can do it, if they feel like it. It is when you don’t feel like it, and you do it anyway, that you eventually develop the self-discipline that makes everything else possible. Brian Tracy Μετάφραση στα ελληνικά Αυτοπειθαρχία είναι η ικανότητα που έχεις για να κάνεις αυτό που πρέπει να κάνεις, όταν το κάνεις, είτε έχεις όρεξη είτε όχι. Βλέπεις, ο καθένας μπορεί να το κάνει, όταν έχει όρεξη. #mindstormGR
