Functions UPPER, LOWER, TRIM & PROPER See Columns Customer Before and Customer After / Δείτε τις στήλες Customer Before και Customer After View large image : https://lnkd.in/d6qV-GqD Download excel file “sales_feb_2021_a_functions.xlsx” : https://lnkd.in/dkYSGJjy #excel_tips #excel_calculations #softexperia / www.softexperia.com
Mini Calendar and Date Picker – Excel Tips Add a mini monthly calendar to your spreadsheet and use it to insert dates or the current time. Embed a small monthly calendar into your spreadsheet for reference and entering dates. This app for Excel is particularly useful for working with time sheets, schedules, project plans, logs, and ledgers where you frequently need to refer to a calendar. The date picking function makes it easy to enter dates or the current time into the currently selected cell. You can highlight dates in the calendar by selecting a range of dates in your spreadsheet. You can also toggle the size of the calendar, show week numbers, change the calendar system (U.S. or ISO), and choose a different theme (blue, green, etc.). Music track: A Positive Direction by Aylex Source: https://freetouse.com/music Royalty Free Music for Video (Safe) Facebook link: https://www.facebook.com/reel/546852667568094 #excel_tips #calendar #mindstormGR #productivity
This table and explanation provide a breakdown of invoices and customers based on specific conditions like date range, status, and city. Here’s the detailed explanation: Input Conditions Start Date: January 3, 2022 End Date: February 14, 2022 Status: Paid City: Athens These conditions filter the data to only include invoices and customers: Within the date range from 1/3/2022 to 2/14/2022. Having the status “Paid.” (For customers) belonging to Athens city. Metrics Calculated Count of Invoices (Start Date, End Date, Status): 3 Formula: =SUM((Date>=C3)*(Date<=D3)*(Status=E3)) Filters rows where the Date is between 1/3/2022 and 2/14/2022 and Status = Paid. From the table: Reese Withpoon (1/24/2022, Paid) Clint Eastwood (2/14/2022, Paid) Kanye East (1/18/2022, Paid — excluded from “City: Athens” but counted here). Sum of Invoices (Start Date, End Date, Status): 934 Formula: =SUM((Date>=C3)*(Date<=D3)*(Status=E3)*Amount) Sums the Amount for invoices where the conditions above are true. Breakdown: Reese Withpoon: 279 Clint Eastwood: 231 Kanye…
The table provided explains how to use INDEX and MATCH functions to retrieve specific values based on a selected Product ID. Here’s a breakdown of the setup: Table Layout Columns: Product ID, Product Sales Value, Product Category, Product Description, and Sales Person. User Input: The user selects a Product ID (e.g., 7 in cell H8). Goal: Display the corresponding data (Sales Value, Category, Description, and Sales Person) in separate cells based on the selected Product ID. Explanation of the Formulas Each formula retrieves data from a specific column of the table using a combination of INDEX and MATCH. Formula for Product Sales Value (I8) =INDEX($F$8:$F$14;MATCH(H8;$A$8:$A$14;0)) $F$8:$F$14: The range containing the Product Sales Value. MATCH(H8;$A$8:$A$14;0): H8 contains the selected Product ID (e.g., 7). $A$8:$A$14 is the range of Product IDs. MATCH finds the row where H8 matches a value in $A$8:$A$14. INDEX uses the row number from MATCH to return the…
Common Marketing Problems in the Food Industry Customer Awareness and Brand Recognition: Many food brands struggle with building customer awareness and brand recognition, especially in highly competitive markets. Challenge: How to differentiate the brand and make it stand out among competitors. Possible Scenario: Low customer engagement, low social media interaction, and low brand recall. Pricing Strategy: Determining the right pricing strategy can be tricky, especially with the fluctuating costs of ingredients and the pressure from competitors. Challenge: Balancing between competitive pricing and maintaining profit margins. Possible Scenario: Competitor price drops, increases in production costs, or demand sensitivity to pricing. Product Distribution and Reach: Ensuring that products reach the target market efficiently is crucial, and many companies face issues with distribution logistics. Challenge: Expanding distribution channels while managing logistics costs and maintaining product quality. Possible Scenario: Limited shelf space, issues with supply chain efficiency, or new market entry. Changing Consumer Preferences:…
List of files in Excel and preview of images – VBA Code – Excel 1) Is it possible to have a list of the images found in a folder and its subfolders in Excel? 2) Is it possible to see the images as I move from one row to another? 3) Is it possible to see the actual image, its name and other info as I scroll down? 4) Is it possible to rename images in source folder according to a rule such as Last Subfolder & ID & FileName, and then copy all renamed images to another folder (target folder)? 5) Is it possible to have all images as they were in the source folder? Yes, it is. Check this video on YouTube and watch it happening. VBA Code credit : Trifon Papadopoulos #mindstormGR #list_of_images_in_excel Δείτε επίσης Import of multiple posts to WordPress with the use of Excel, Word…
Calculate the days of work between two dates with the NETWORKDAYS function Start Date: 15/5/2020 End Date: 28/1/2021 Holiday 1: 26/8/2020 Holiday 2: 18/11/2020 Holiday 3: 15/1/2021 Calculate the days between two dates with the NETWORKDAYS function excluding Holiday 1, Holiday 2 and Holiday 3. Saturday and Sunday are omitted. Result Number of days between the two dates: 182 — This image demonstrates how to calculate the number of working days between two dates in Excel using the NETWORKDAYS function. It excludes weekends (Saturday and Sunday) and specific holidays listed. The formula shown, =NETWORKDAYS(C3, C4, C5:C7), returns 182 working days between May 15, 2020 and January 28, 2021, excluding three holidays. Αυτή η εικόνα δείχνει πώς να υπολογίσετε τον αριθμό των εργάσιμων ημερών μεταξύ δύο ημερομηνιών στο Excel, χρησιμοποιώντας τη συνάρτηση NETWORKDAYS. Η συνάρτηση εξαιρεί τα Σαββατοκύριακα (Σάββατο και Κυριακή) και συγκεκριμένες αργίες που καταχωρούνται χωριστά. Ο τύπος =NETWORKDAYS(C3;…
Steps to import multiple posts to Wordpress with the use of Excel, Word and Ultimate CSV Importer Free Step 1 Find the content you would like to upload from your social media profile or anywhere else. Step 2 Use Microsoft Word, open existing word file : ‘word_to_html_source.docx’, delete previous content (if any), copy and edit your new content (paragraphs, spaces, bold or italic words) and save the file. Step 3 Open excel file ‘wordpress_database_schema.xlsm’ and press the button ‘Add <div> to word file’. This will create a new file : ‘word_to_html_target.docx’. Open it and copy the content of the file into the ‘post_content’ column. Step 3 is important if you want to keep the styling of the content. Step 4 Go to sheet ‘field_values’, find table with column names ‘post_title’ and ‘post_name’ and type your content accordingly. Return to sheet ‘wp_posts’ and complete the necessary columns. Begin with selecting from…
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’ Column with SKU, Name, Attribute 1 value(s), Attribute 2 value(s), Type and Regular Price with a button (VBA) – two versions 5) Creation of a word file with SKU Barcode Labels based on quantity with a button (VBA) – SKU can be scanned on labels – 3 labels per row, 15 labels per page 6) Creation of a word file with SKU Barcode Labels based on quantity with a button (VBA) – SKU cannot be scanned on labels – 3 labels per row, 15 labels per page YouTube
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 yellow color with a button (VBA) 3) Highlight existing SKUs with different price with green color (VBA) and update columns ‘Status’ and ‘Previous Price’ 4) Clear Row highlights with a button (VBA) 5) Delete columns ‘Status’ and ‘Previous Price’ YouTube #mindstormGR #excel_tips / www.mindstorm.gr
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’…
EN VBA Code to view the picture (if available) of a product on a worksheet – Excel Insert picture in a shape Pictures of products: C://code_photos GR Κώδικας VBA για την προβολή φωτογραφίας (εφόσον υπάρχει) προϊόντος σε ένα φύλλο εργασίας – Excel Οι φωτογραφίες των προϊόντων βρίσκονται στον φάκελο C://code_photos YouTube : https://www.youtube.com/watch?v=GuN4y2jV6-A #mindstormGR #vba #excel_tips #excel #insert_picture_in_shape Buy me a coffee
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…
