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…
Do not forget to click on “Data” > “Refresh All” every time you add a new row to your table with fields product, number and price. Download excel file “sort_and_drop_down_excel_c.xlsx” : View this video on youtube : https://lnkd.in/d8e_Aduu #excel_tips #softexperia…
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…
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…
View the table / Δείτε τον πίνακα [table id=2 /] View large image : https://lnkd.in/dHyranSb #softexperia #mindstormGR
Formula for Cell C11 ( Month 8 ) =FORECAST.LINEAR(A11;$B$4:$B$14;$A$4:$A$14) FB Tags : #softexperia #excel_tips
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
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…
Ποιοι είναι οι λόγοι που μιλάμε και γράφουμε; Η ομιλία όπως και η γραφή είναι τρόποι επικοινωνίας. Και είναι τόσο απαραίτητο να επικοινωνούμε; Η επικοινωνία είναι κάτι σαν την αγάπη. Είναι αυτή που κάνει ζευγάρια, ομάδες, κοινωνίες, κράτη να προχωρούν…
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…
© 2021, Sassico. All Rights Reserved.
Made with by 
XpeedStudio
