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’…
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…
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…
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…
#excel_tips #transpose #softexperia
Scenario for using Python and Excel Request 1 Take the following 3 excel files: sales_jan_2022.xlsx sales_feb_2022.xlsx sales_mar_2022.xlsx and create a new excel: sales.xlsx and a new csv file: sales.csv with all the records from these 3 excel files. Request 2…
Πως να επιλέγετε γραμμές και στήλες με τη βιβλιοθήκη pandas της γλώσσας προγραμματισμού Python See below the data and the code for the result shown on image . . . How to select rows and columns in pandas # Credit…
Let’s assume that you have 2 excel files : product_data_excel.xlsx (99 rows x 5 columns, A2: E100) product_data_excel_2.xlsx (107 rows x 5 columns, A2:E108) The 5 columns of the two excel files are : product_id, product_description, quantity, regular_price and category.product_data_excel.xlsx…
Let’s assume that you got three csv files from the sales department : “_sales_january_2021_d.csv” “_sales_feb_2021_d.csv”“_sales_mar_2021_d.csv” and you want : to join them in one new csv file : “sales_jan_feb_mar_2021_d.csv” to find actual sales sum per month, actual sales sum (quantity)…
Excel file 1 : sales_january_2021_d.xlsx – Download : https://lnkd.in/dyT6zrCX Excel file 2 : sales_feb_2021_d.xlsx – Download : https://lnkd.in/d5aaNWiq Excel file 3 : sales_march_2021_d.xlsx – Download : https://lnkd.in/d-G2hNiM Task Collection of data from the above mentioned three different excel files and…
- 239 E 5th St, New York NY 10003, USA
Important Links.
Instagram Feed.
User id is not set yet! Please go to settings and set the user id.
© 2021, Sassico. All Rights Reserved.
Made with by 
XpeedStudio