Formula for Cell C11 ( Month 8 ) =FORECAST.LINEAR(A11;$B$4:$B$14;$A$4:$A$14) FB Tags : #softexperia #excel_tips
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
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
Υπολογισμός επιτοκίου δανείου (ανατοκισμός) 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.
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
“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
Δεν έχει τόσο σημασία πόσο σου πήρε να πάρεις ένα πτυχίο. Κάθε πτυχίο είναι ένα πτυχίο. Δεν έχουν τόσο σημασία οι σχέσεις που χάλασες για να βρεις την αγάπη αλλά η αγάπη που κατάφερες τελικά να βρεις. Το να αγοράσεις σπίτι στα 65 είναι και αυτό ένα επίτευγμα. Μην αφήνεις τους άλλους ανθρώπους να σε εκφοβίζουν με το χρονοδιάγραμμα των δικών επιτυχιών τους. FB Tags : #mindstormGR
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
Safety said : I ‘ve got my eyes on you people, 24/7. It’s for your own protection. Freedom answered : That means that I cannot serve you people any more. Trust added : I trust now that you people are safe not to feel free. We are living in a wonderful world. Don’ t you think so? FB Tags : #reality #mindstormGR #trust #safety #freedom
Visiting a country is not only what you see. It is what you feel, what you smell and what you taste. This is the real thing. Ask for nothing less. Or just visit Greece and find it all around you. FB Tags : #greece #taste #experience #food #greek_products #ελλάδα #hellas #greek_islands / Follow us on facebook fb : Hellenic-Land.com
Open the door, get out and enjoy the view. But not just any view. The view that you will always remember. The one and only. The sea view that made Santorini famous. And stay there till late to enjoy the sunset. Or wake up early to enjoy the sunrise. Different hours, 24/7 pleasure. Photo credit : Fernand Goncalves FB Tags: #santorini #greece #santorini_sea_view #sunset #hellenicland
Αν θέλετε μια λίστα υπηρεσιών (Service List) ή μια πιο σύνθετη λίστα απολύτως προσαρμοσμένη στις δικές σας δραστηριότητες, επικοινωνήστε μαζί μας. Είμαστε σίγουροι ότι η σωστή παρακολούθηση των εργασιών σας θα βοηθήσει στην ανάπτυξη των δραστηριοτήτων σας. Columns / Στήλες ID Domain Name Service Title Description Notes Customer Priority Status % Complete Assigned To Transaction Amount Category Start Date Due Date Completed Date * Η λίστα παρέχεται στην ελληνική, αγγλική και ιταλική γλώσσα κατόπιν σχετικής συμφωνίας. Στη φωτογραφία βλέπετε την αγγλική έκδοση. Mobile : 6945 849400 Email : info@softexperia.com FB Tags : #taskmanagement #customsoftware #softexperia / fb : Softexperia.com / www.softexperia.com
To get to his or her Disneyland. And sometimes they ask for your help so they can get there. If you feel like it, give them a ride from time to time. It will make both you and them feel good. You will understand eventually that the magic is in giving more to the ones who need it the most. #mindstormGR / www.mindstorm.gr