DATA ANALYSIS - Jobspace

January 12, 2025 ALL, AUTOMATE WORKFLOW EVERYWHERE, DATA ANALYSIS, ENGLISH ARTICLES, MICROSOFT EXCEL TIPS, MY PROJECTS

Master Sales Analysis with Pivot Tables and ChatGPT – Excel Made Easy!

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…

August 29, 2024 ALL, BUSINESS, DATA ANALYSIS, MARKETING, ΕΠΙΚΟΙΝΩΝΙΑ

Επιβεβαίωση και ξεπεπιβεβαίωση

Επιβεβαίωση και ξεπεπιβεβαίωση Όλα τα zoogles είναι boogles. Μόλις είδατε ένα boogle, είναι zoogle; Όχι αναγκαστικά δεδομένου ότι όλα τα τα boogles δεν είναι zoogles. Όσοι έφηβοι κάνουν λάθος όταν απαντούν σε αυτό το είδος ερωτήσεων στο SAT (Scholastic Aptitude…

November 12, 2023 ALL, BUSINESS, DATA ANALYSIS, ENGLISH ARTICLES, MICROSOFT EXCEL TIPS

Creation of SKU QR Codes, SKU Barcodes and SKU Product URL QR Codes with VBA

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’…

November 12, 2023 ALL, BUSINESS, DATA ANALYSIS, ENGLISH ARTICLES, MICROSOFT EXCEL TIPS

Comparison of two different sheets in Excel with VBA

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…

October 28, 2023 ALL, BUSINESS, DATA ANALYSIS, ENGLISH ARTICLES, MICROSOFT EXCEL TIPS

Create 5 Pivot Tables with a button (VBA)

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…

September 29, 2023 ALL, BUSINESS, ENGLISH ARTICLES, MICROSOFT EXCEL TIPS, PYTHON

Sales Analysis with Python and Excel

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)…

August 14, 2023 ALL, BUSINESS, DATA ANALYSIS, ENGLISH ARTICLES, MICROSOFT EXCEL TIPS, PYTHON

Use of chatGPT and YouTube to become a Data Analyst

Use of chatGPT and YouTube to become a Data Analyst – Χρήση του chatGPT και του YouTube για να κάνει κάποιος ανάλυση δεδομένων Code file: app.py Folder: C:PythonProgramsdata_analysis_with_chatGPT 1) Merge multiple excel files – Συγχώνευση πολλών αρχείων excel data1.xlsx data2.xlsx…

July 3, 2023 ALL, BUSINESS, ENGLISH ARTICLES, MICROSOFT EXCEL TIPS, PYTHON

How to Create an Excel Data Entry Form in 10 Minutes Using Python (No VBA) | Easy & Simple

Did you know you can use Python code to create an Excel Data Entry Form and avoid duplicate records? Πως να δημιουργήσετε μια φόρμα εισαγωγής δεδομένων σε 10 λεπτά με τη γλώσσα προγραμματισμού PYTHON (No VBA) Πως να διασφαλίσετε ότι…

October 4, 2022 ALL, BUSINESS, DATA ANALYSIS, PYTHON

How to select rows and columns in pandas (Python)

Πως να επιλέγετε γραμμές και στήλες με τη βιβλιοθήκη pandas της γλώσσας προγραμματισμού Python See below the data and the code for the result shown on image . . . How to select rows and columns in pandas # Credit…