Πως να προσθέσετε πληροφορίες (νέες στήλες όπως ημερομηνία ή κωδικό πελάτη) σε ένα νέο πίνακα από τους πίνακες παραγγελιών Order table, Customer table και Saleperson table. To join or merge tables that have a common id, you can use the INDEX and MATCH functions. Download excel file “join_tables_with_index_and_match_mindstormGR_3.xlsx” . . .Explanation Type the order_id and these formulas will pull the date, customer_id and the amount from the order table, the customer name (field : name) and the salesperson_id from the customer table, the salesperson name (field : name) from the salesperson table into the new table. The MATCH function is used to locate the right date, customer_id, amount, customer name, salesperson_id and the salesperson name and the INDEX function is used to retrieve the data. FB Tags : #tables #data #excel_tips #softexperia #mindstormGR / www.softexperia.com

Αν θέλετε να ελέγξετε/συγκρίνετε ποσό δανείου, χρόνο αποπληρωμής, δόση δανείου και επιτόκιο δανείου, τότε αυτό το αρχείο excel μπορεί να σας φανεί χρήσιμο. If you want to check/compare interest rate, years of loan, monthly payment and loan amount, then you might find this excel file useful. For example, if you take a 30000 euro loan for 10 years with an interent rate of 3% (payment due : end of period), your monthly payment will be 289,68 euro. Πατήστε εδώ για να κατεβάσετε αυτό το αρχείο excel… / Click here to download this excel file… Mobile : 6945 849400 Email : info@softexperia.com FB Tags : #excel_tips #calculations #loan_and_interest #loan_analysis_worksheet #σύγκριση_όρων_δανείου / fb : Softexperia.com / www.softexperia.com

Use Excel to calculate the hours worked for any shift / Υπολογισμός ωρών εργασίας με το Excel / #softexperia Steps 1. In A1, enter Time In. 2. In B1, enter Time Out. 3. In C1, enter Hours Worked. 4. Select A2 and B2, and press [Ctrl]1 to open the Format Cells dialog box. 5. On the Number tab, select Time from the Category list box, choose 1:30 PM from the Type list box, and click OK. 6. Right-click C2, and select Format Cells. 7. On the Number tab, select Time from the Category list box, choose 13:30 from the Type list box, and click OK. 8. In C2, enter the following formula: =IF(B2<A2;B2+1;B2)-A2 If you enter 11:00 PM as the Time In and enter 7:00 AM as the Time Out, Excel will display 8, the correct number of hours worked. — Βήματα 1. Στο κελί A1, εισάγετε Time In (Ώρα…

Pin It