Mindstorm
Category

ENGLISH ARTICLES

Category
Profit margin
ALL

Profit Margin / Περιθώριο Κέρδους

Profit margin is the difference between the total cost to run your business and the total revenue it brings in. The higher your profit margin, the more money your business gets to keep. Profit margin is calculated with selling price (or revenue) taken as base times 100. It is the percentage of selling price that is turned into profit, whereas “profit percentage” or “markup” is the percentage of cost price that one gets as profit on top of cost price. While selling something one should know what percentage of profit one will get on a particular investment, so companies calculate profit percentage to find the ratio of profit to cost. Profit margin = ((Sell Price – Buy Price) / Sell Price)*100 Profit Percentage or Markup = ((Sell Price – Buy Price) / Buy Price)*100

Read More
Outlook 2016 and 2019
ALL

Make Important Email Standout in Outlook with Color Coding

Make Important Email Standout in Outlook with Color Coding / Πως να κάνετε σημαντικά ηλεκτρονικά μηνύματα να ξεχωρίζουν στο Outlook με τη χρήση χρωμάτων To make sure emails from important contacts stand out and do not go unnoticed, you can set up a rule that makes the email appear in a specific color or a specific size and type of font. For example, you can make emails from your boss appear in a larger font or have emails from family members all appear in red. To set up the way emails are displayed for: / Για να μπορείτε να ξεχωρίζετε τα ηλεκτρονικά μηνύματα από σημαντικές επαφές, θα πρέπει να φτιάξετε έναν κανόνα που θα παρουσιάζει το μήνυμα με ένα συγκεκριμένο χρώμα ή ένα συγκεκριμένο μέγεθος ή μια συγκεκριμένη γραμματοσειρά : For Outlook 2019 and Outlook 2016: Go to the View tab / Πηγαίνετε στο μενού View Select View Settings /…

Read More
ALL

Data Analysis of Bugdet and Actual Sales with Python

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 creation of a new one : sales_jan_feb_mar_2021_d.xlsx – Download : https://lnkd.in/d-PTEPtv with three different sheets : sales_data month_productivity salesperson_productivity We did a comparison between Budget and Actual Sales. The reason we did this is to know the month productivity and the salesperson productivity for months Jan, Feb and Mar 2021. All sheets, data, graphs and styling in file : sales_jan_feb_mar_2021_d.xlsx have been created automatically with python coding. Tools used : Excel, Python #programming #coding #python #productivity #data_analysis #mindstormGR / www.mindstorm.gr Code for this project from ctypes.wintypes import WORD import pandas as pd import numpy as np import matplotlib.pyplot as plt importopenpyxl from openpyxl.styles import PatternFill, Border, Side, colors, Alignment, Protection,…

Read More
ALL

Message & Conditional formatting for Column ‘Sales Comments’

Formula for Cell D3 =IF(C3>B3;”Above budget”;”Below budget”) Email : info@softexperia.com Mobile : 6945 849400 #excel_tips #softexperia / fb : Softexperia.com / www.softexperia.com Download excel file : sales_january_2021_a.xlsx Δείτε τον πίνακα του αρχείου excel  / View the table for excel file Download excel file : sales_january_2021_b.xlsx

Read More
ALL

Creation of 2 dashboards (pivot table and graph) in excel

Dataset : Data Science Job Salaries and Sales Number of Sheets : 3 1) data (dataset) – View large image : https://lnkd.in/dzxPbsDw 2) dashboard (pivot table and graph) – View large image : https://lnkd.in/dM8ZPPUM 3) dashboard 2 (pivot table and graph) – View large image : https://lnkd.in/dkt7V4uG Download excel file : https://lnkd.in/dfSC9JKT #dashboard #excel #graphs #softexperia / Linkedin : Softexperia / www.softexperia.com

Read More
Wingdings Symbols on Excel
ALL

Wingdings Symbols on Excel

Wingdings Symbols on Excel – Χρήση συμβόλων στο Excel Formula for Column B (B4 & B5) B4=CHAR(40) B5=CHAR(49) FB Tags : #softexperia #excel_tips #symbols / fb : Softexperia.com / www.softexperia.com

Read More
future value
ALL

Computing Future Value for a Specified Period

You wish to save some money for renovating your house in 5 years. You deposit 2,000 EUR to your saving account at an interest rate of 3% compounded quarterly. Furthermore, you are going to add 100 EUR at the beginning of each month. How much money will there be in your saving account in 5 years? Formula for Cell B11 (Future Value) =FV(B7/B5;B6*B5;B9;B8;B10) According to Excel FV calculator – around 4.487,61 EUR. FB Tags : #excel_tips #calculations #future_value #softexperia / fb : Softexperia.com / www.softexperia.com Read also Data Analysis Αν θέλετε να κάνετε κάποια συλλογή/ανάλυση δεδομένων για να βελτιώσετε τις δραστηριότητες σας, μπορούμε να σας βοηθήσουμε. Μην διστάσετε να επικοινωνήσετε μαζί μας. Email : info@softexperia.com Mobile : 6945 849400 www.softexperia.com Follow us on Linkedin : Softexperia #softexperia #data_analysis #python #excel_tips #decision_making #dataanalysis #dataanalytics

Read More
formulas you should know
ALL

Excel formulas you should know

Download video : Formulas you should know Download excel file : Formulas you should know SUMIF =SUMIF($A$5:$A$14;C5;$B$5:$B$14) SUM =SUM($C$5:$C$14) CONCATENATE =CONCATENATE(A7;”, “;B7;”, “;D7) VLOOKUP =VLOOKUP(G8;$A$4:$E$14;2;FALSE) UPPER =UPPER(A9) REPT (font MT Extra) ||| =REPT(“|”;D10/50) IF =IF((SUM($C$5:$C$14)>$E$11);”Pass”;”Fail”) AVERAGE =AVERAGE($D$5:$D$14) LEN =LEN(A13) COUNT =COUNT(D4:D14) #functions_excel #excel_tips #criteria #softexperia

Read More
ALL

Compound Interest Rate Calculator

Υπολογισμός επιτοκίου δανείου (ανατοκισμός) Compound interest is the interest calculated on the initial principal and also on the accumulated interest from previous periods. Essentially, it’s “interest on interest” and helps investments or savings grow at a faster rate compared to simple interest, where interest is only calculated on the principal amount. The formula for compound interest is: [ A = P \left(1 + \frac{r}{n}\right)^{nt} ] Where: ( A ) is the amount of money accumulated after n years, including interest. ( P ) is the principal amount (initial investment). ( r ) is the annual interest rate (in decimal form). ( n ) is the number of times that interest is compounded per year. ( t ) is the time the money is invested or borrowed for, in years. Compound interest can significantly increase the growth of your savings or investments over time.

Read More
Excel tips
ALL

How to put three columns (A,B,C) together

All 3 columns (A,B,C) together with space between them D3=A3&” “&B3&” “&C3 All 3 columns (A,B,C) together without space between them E3=A3&B3&C3 All 3 columns (A,B,C) together with “-” removed in column A and without space between them F3=TRIM(SUBSTITUTE(A3;”-“;””))&B3&C3 Click here to download excel example #excel_tips #softexperia

Read More
ALL

You write for youself

“Finally, ultimately, you write… for yourself. I mean, I need a public, I need people to play, I need everything else. I’m not working in isolation. But finally the man…is alone. And I have to respond to those criteria which are almost like inner needs or inner responses.” FB Tags : #writing #mindstormGR

Read More
Thoughts
ALL

Σκέψεις – Thoughts

Δεν έχει τόσο σημασία πόσο σου πήρε να πάρεις ένα πτυχίο. Κάθε πτυχίο είναι ένα πτυχίο. Δεν έχουν τόσο σημασία οι σχέσεις που χάλασες για να βρεις την αγάπη αλλά η αγάπη που κατάφερες τελικά να βρεις. Το να αγοράσεις σπίτι στα 65 είναι και αυτό ένα επίτευγμα. Μην αφήνεις τους άλλους ανθρώπους να σε εκφοβίζουν με το χρονοδιάγραμμα των δικών επιτυχιών τους. FB Tags : #mindstormGR

Read More
Excel tips
ALL

Keyboard excel shortcuts

CTRL+SHIFT+& Applies the outline border to the selected cells CTRL+SHIFT+! Applies the general number format with 2 decimal places CTRL+SHIFT+$ Applies the currency format with two decimal places CTRL+SHIFT+% Applies the percentage format FB Tags : #softexperia #excel_tips_softexperia

Read More
Excel Tips
ALL

Three columns together in one – Excel

EN – How to put A Column1, B Column2 and C Column3 together in one column D with space and in one column E without space GR – Πώς να βάλετε το περιεχόμενο τριών στηλών A,B,C σε μια στήλη D με κενό ανάμεσα τους και σε μια στήλη E χωρίς κενό ανάμεσα τους. D3=A3&” “&B3&” “&C3 E3=A3&B3&C3 Download our example / Κατεβάστε το παράδειγμα μας (τύπος αρχείου .xlsx) File / Αρχείο : three columns in one column in excel – example – softexperia #excel_tips #softexperia

Read More
Pin It