The unknown want fame while the famous just want privacy. The young want to grow old while the old wish they could turn back time. The poor want to become rich while the rich wish for the peace they lost chasing their wealth. The truth is, no one has it all. But everyone has enough… If only they stopped and took a moment to see it. #thoughts
Phil Knight’s Manifesto for Nike – 1980 1. Our business is change. 2. We ‘re on offense. All the time. 3. Perfect results count — Not a perfect process. Break the rules: fight the law. 4 .This is as much battle as about business. 5. Assume nothing Make sure people keep their promises. Push yourselves push others. Stretch the possible. 6. Live off the land. 7. Your job isn’t done until the job is done. 8. Dangers Bureaucracy Personal ambition Energy takers vs. energy givers Knowing our weaknesses Don’t get too many things on the platter 9. It won’t be pretty 10. If we do the right things we’ll make money damn near automatic. … #motivational #mindstormGR
There are two ways to see things. One is to see what isn’t true. The other is to refuse to see what is true. So, try harder to see what is really there. Teach yourself and your kids to observe and to question everything. To understand why the right eye is open and the left is closed. Is it your choice or someone else’s choice to be like that? Υπάρχουν δύο τρόποι να βλέπεις τα πράγματα. Ο ένας είναι να επιλέγεις να βλέπεις αυτό που δεν ανταποκρίνεται στην πραγματικότητα. Ο άλλος να επιλέγεις να μην βλέπεις αυτό που ανταποκρίνεται στην πραγματικότητα. Προσπάθησε λίγο περισσότερο να δεις ποια είναι η πραγματικότητα. Μάθε και δίδαξε και τα παιδιά σου να παρατηρούν και να αμφισβητούν τα πάντα. Να καταλάβεις εσύ και τα παιδιά σου γιατί το δεξί μάτι είναι ανοιχτό και το αριστερό κλειστό. Να αντιληφθείτε αν αυτή είναι και η δική σας…
EN – Sales Data Processing & Analysis with SQLite and Excel – Automated Sales Insights This Python script processes an Excel sales dataset (sales_data.xlsx) and generates an enhanced output file (sales_data_output_with_SQL.xlsx) with filtered data, SQL-powered queries, and dynamic visual insights using SQLite and Pandas. Key Features: 1. Reads & Cleans Data: – Loads the Sheet1 data from sales_data.xlsx into a Pandas DataFrame. – Normalizes column names (replacing spaces with underscores for SQL compatibility). 2. Stores Data in SQLite Database: – Uses an in-memory SQLite database (sqlite://) to store the data for efficient querying. 3. Filters & Extracts Key Sales Data using SQL Queries: – Creates 4 filtered data sheets based on SQL queries: – Chocolate Chip Sales – Filters rows where Product=Chocolate Chip. – Vanilla Cookie Sales – Filters rows where Product=Vanilla Cookie. – High Quantity Sales – Retrieves sales with Units_Sold > 100. – Recent Orders – Displays the…
How to syntax and use Top 16 Excel Functions Watch the video on YouTube Syntax 1. =SUM(F8:F13) 2. =AVERAGE(F8:F13) 3. =ROUND(F8,2) 4. =MIN(F8:F13) 5. =MAX(F8:F13) 6. =COUNT(F8:F13) 7. =INDEX(I8:J13,3,2) 8. =MATCH(H8,I8:I13,0) 9. =VLOOKUP(H8,I8:J13,2,FALSE) 10. =HLOOKUP(H8,N7:S8,2,0) 11. =XLOOKUP(H8,I8:I13,J8:J13) 12.=COUNTIF(F8:F13,”>5″) 13. =COUNTA(F8:F13) 14. =SUMIF(F8:F13,”>5″) 15. Example 1 =IF(SUM(F8:F13)>10,”Sum is greater than 10″) 15. Example 2 =IF(SUM(F8:F13)>10, IF(SUM(F8:F13)<25, “Sum is greater than 10 and smaller than 25”, “”), “”) 16. =AVERAGEIF(F8:F13,”>5″) Excel and Video credit: Tryfon Papadopoulos
ΕΝ – Use Case: Automating Image Uploads to WordPress and Tracking in Excel Use Case Overview This use case describes a Python-based automated system for processing and uploading images to a WordPress website, ensuring that all uploaded images are properly resized, optimized, and documented in an Excel report. Goal The primary goal is to streamline the process of managing image uploads to a WordPress site while ensuring: Image consistency through standardized resizing. Automated uploading to WordPress via API. Proper documentation in an Excel file with image thumbnails. Actors Primary Actor Content Manager / Website Administrator Responsible for uploading and managing images on WordPress. Uses this automation tool to speed up the process. Supporting Systems WordPress Media Library (via REST API) Local Storage (Folders for Processed Images & Excel File) YouTube Workflow (Main Use Case Scenario) Step 1: Prepare Images The user places images in a designated folder (folder1). The script…
How to run multiple versions of a “Convert Images” python script in Excel EN – This script, **`batch_image_converter_ver4.py`**, is a Python-based GUI application for batch image conversion. Here’s what it does: 1. **Graphical User Interface (GUI):** – It provides a user-friendly interface using the `tkinter` library, allowing users to interact without needing to write code. 2. **File Selection:** – Users can select multiple image files of various formats (e.g., `.webp`, `.jpg`, `.png`, `.bmp`, `.tiff`, `.gif`) using a file dialog. 3. **Output Format Selection:** – A dropdown menu allows users to choose the desired output image format (e.g., PNG, JPEG, BMP, TIFF, GIF). 4. **Batch Conversion:** – The script processes all selected files and converts them into the chosen format. – It preserves the original file names but updates their extensions based on the selected output format. 5. **Output Folder Selection:** – Users can specify a folder where the converted images…
EN – This VBA script [Import Pictures from folder and subfolders, Retail Price and Product ID] automates the process of matching image files listed in a worksheet with their associated data from another worksheet. It also extracts and populates additional information about the files, such as their size and last modification date. Here’s a detailed breakdown of what this script does (excel filename => import_images.xlsm) : Purpose of the Script Purpose of the script in Greek The script [Import Pictures from folder and subfolders, Retail Price and Product ID] performs the following tasks: Matches image file paths in a worksheet with corresponding data (Retail Price and Product ID) from a “Price List” worksheet. Retrieves and displays additional file properties: Date Modified: The date the file was last changed. Size in KB: The size of the file, converted from bytes to kilobytes. Populates the retrieved data into specific columns in the…
Quantitative Research Types Quantitative research is a systematic investigation that primarily focuses on quantifying relationships, behaviors, phenomena, and variables through statistical, mathematical, or computational techniques. This document explores the various types of quantitative research methodologies, highlighting their characteristics, applications, and significance in the field of research. Descriptive Research Descriptive research aims to provide a detailed account of a phenomenon or population without manipulating any variables. It often involves the collection of data through surveys, observations, or existing records. The primary goal is to describe the characteristics of the subject being studied. Characteristics: Non-experimental in nature Utilizes statistical tools to summarize data Provides a snapshot of the current state of affairs Applications: Market research Demographic studies Health assessments Correlational Research Correlational research examines the relationship between two or more variables to determine if a change in one variable corresponds with a change in another. This type of research does…
Fyodor Dostoevsky, the renowned Russian novelist, left us with profound insights into the human condition through his works. Here are three memorable quotes from Dostoevsky: From Crime and Punishment: “Pain and suffering are always inevitable for a large intelligence and a deep heart. The really great men must, I think, have great sadness on earth.” From The Brothers Karamazov: “What is hell? I maintain that it is the suffering of being unable to love.” From Notes from Underground: “Man only likes to count his troubles; he doesn’t calculate his happiness.” These quotes capture Dostoevsky’s recurring themes of suffering, love, and the complexities of human existence. Send me an email if you’d like more context or discussion about his works!
Introduction to Accounting for Management Decisions Accounting is often called the “language of business,” and for good reason—it provides essential information that helps managers make informed decisions. Accounting for management decisions focuses on using accounting data to guide business operations, improve efficiency, and achieve organizational goals. Unlike financial accounting, which targets external stakeholders like investors and creditors, management accounting is inward-facing and tailored to meet the specific needs of a company’s management team. In this beginner’s article, we’ll explore the fundamentals of accounting for management decisions, its importance, and the tools and techniques commonly used. What is Accounting for Management Decisions? Accounting for management decisions, also known as managerial accounting, involves the preparation, analysis, and communication of financial information that helps managers plan, control, and make strategic decisions. It focuses on providing actionable insights rather than adhering strictly to standardized accounting principles. For example: A manager at a manufacturing plant…
Master Sales Analysis with Pivot Tables and ChatGPT – Excel Made Easy! Hey everyone! I’ m Trifonas Papadopoulos. Welcome back to my channel! Today, I’m going to show you how to perform a powerful sales analysis using Excel Pivot Tables and ChatGPT. Whether you’re a data newbie or an Excel pro, this step-by-step tutorial will help you uncover insights from your data like never before! Step 1 We’ll start with a raw sales dataset, and I’ll guide you through setting up a Pivot Table for analysis. Then, I’ll show you how ChatGPT can help you understand trends, generate insights, and even suggest formulas you might need for deeper analysis. Let’s dive in!” First, let’s see first our sales data. Make sure your dataset has columns like Date, Product, Country or Region, Sales or Revenue Amount, and Quantity or Units Sold. Step 2 Now, let’s create a Pivot Table. Go to…
Fill Alphabet or Roman Numerals Sure, Excel can fill January, February, March, but what about A,B,C or I,II,III? softexperia.com Drag down E7 = CHAR(ROW(65:65) Drag down F7 = ROMAN(ROW(1:1)) Number Character Roman 1 A I 2 B II 3 C III 4 D IV 5 E V 6 F VI 7 G VII 8 H VIII 9 I IX 10 J X 11 K XI 12 L XII 13 M XIII 14 N XIV 15 O XV 16 P XVI 17 Q XVII 18 R XVIII 19 S XIX 20 T XX 21 U XXI 22 V XXII 23 W XXIII 24 X XXIV For the upper case alphabet, use a formula of =CHAR(ROW(65:65)) and copy down. For the lower case alphabet, use =CHAR(ROW(97:97)) For upper case Roman numerals: =ROMAN(ROW(1:1)) For lower case Roman numerals =LOWER(ROMAN(ROW(1:1))) YouTube Link: https://youtu.be/5LaZA3rHPSs #excel_tips_softexperia #excel_tips #softexperia
Understanding Types of Management Introduction Management is the process of organizing and leading people to achieve goals effectively. It plays a vital role in businesses, organizations, schools, and even in our daily lives. Good management helps teams stay organized, work together, and reach their objectives successfully. Understanding different types of management is important for leadership development because it helps individuals choose the best approach for various situations. Types of Management Autocratic Management Definition: Autocratic management is when a leader makes decisions without consulting the team. Characteristics: The leader has complete control. Little to no input from team members. Clear instructions and strict rules. Advantages: Decisions are made quickly. Clear roles and expectations. Disadvantages: Team members may feel undervalued. Creativity and teamwork are limited. Best for: Emergency situations or when tasks need quick decisions. Democratic Management Definition: Democratic management involves team members in decision-making. Characteristics: Open communication. Collaboration and group…
Belief is not a voluntary act. If I offered you a hundred dollars to believe that snow is blue you couldn’t No way to collect that money. You could pretend… Beliefs are established by our experience and by our interactions with the world. And they can be hard to dislodge and it takes a lot of effort to examine and reconsider and particularly to abandon opinions convictions that you’ve had when you learned that there is alternatives and one of the hardest tasks the human mind can face is reserving judgement about a conviction that has always seemed to you obvious and thinking about how maybe that might not be right. Daniel Dennett https://www.facebook.com/reel/635034348951478 #beliefs #thoughts #mindstormGR
