Working in Microsoft Excel
The task 1.1 .Create the "Rest (in quantity and amount) turnover" in MS Excel, based on the tables 1-4.2ndApply data verification (the check of input values).ThreeUse the mathematical function of SUMMESLI in forming final values in the circulatory knowledge.Table 1 - Data for filling in the first three lists of the MS Excel bookSuppliersCustomersContact pointsOECD "Milk Factory"I.P. Shyriyev B.D.Store 1OOO “Milk and Cheese” IP Shketkin A.A.Magazin 2OOO “Pticefabrika” IP Yakovlev N.The store 2
Table 2 - Data for filling the fourth list of the MS Excel bookName PriceEdd.ism.QuantityMilk whole55l1Milk normalized45l2Kefir de-fated32l2Create 5%120kg.1Egg chicken49up.2
Table 3 - Data for filling in the fifth list of the MS Excel Book Name Date No. Additional Supplier Account Point Ed.ism.Col-in Price Price Milk Total 24.04.2021 269 LLC "Milk Factory" Store 1 l 5 55 275 Milk Total 24.04.2021 65 LLC "Milk and Cheese" Store 2 l 6 55 330 Milk Normalized 24.04.2021 147 LLC "Milk Factory" Store 2 l 8 45 360 Milk Normalized 24.04.2021 234 LLC "Milk and Cheese" Store 2 l 8 45 360 Producer 5% 24.04.2021 102 LLC "Milk and Cheese" Store 1 kg 5 120 600 Eggs 24.04.2021 110 LLC "Pty Factory" Store 3 ups 10 49 90
Table 4 - Data for filling in the sixth list of the MS Excel Book Name Date Number of the Buyer Account Point Ed.ism.Col-vo Price Price Milk Total 24.04.2021 78 IP Breadths B.by D.Store 1 l 5 65 325 Milk whole 25.04.2021 79 IP Shketkin A.and A.Store 2 l 6 65 390 Milk normalized 25.04.2021 80 IP Shyriyev V.by D.Shop 2 l 7 52 364 Milk normalized 25.04.2021 81 IP Yakovlev N.by G.Shop 2 l 7 52 364 Tvorog 5% 24.04.2021 82 IP Shiryaev V.by D.Store 1 kg 4 130 520 Eggs 24.04.2021 83 IP Yakovlev N.by G.Shop 3 UPS 5 52 260
Applications 2
-
421 13 0 Welcome to!
I work with Excel and Google tables.
Ready to help with a formula or macro (scripts).
I will be happy to cooperate.
-
613 7 1 I know Excel perfectly.
I wrote in a comment on another project about 1C.
If you choose me as an executive in both projects, we can agree.
Price for one hour of work.
-
5395 221 1 1 Hello to you.
Ready to start work today.
I will be happy with cooperation.
-
2157 75 0 Good day ! I am happy to complete your task, ready tomorrow at 9:00 to give the result.
-
130 Good day
The beginner freelancer.
I will work for you at a minimum price and reward.
-
373 22 0 Good day . Interested in the task. I will be happy to cooperate. Turn to
-
1677 43 0 Good day !
I am pleased to fulfill your task, ready to give up your task tonight or tomorrow until 12:00
-
3628 113 7 1 Good day
I have done such a task, there is a solution.
Ready to implement the project.
Current freelance projects in the category Technical Documentation
Creation of an Excel file for uploading products to the website.It is necessary to create an Excel file and fill it with the data we provide, making the file such that it can be uploaded to the website. Similar to Rozetka, WordPress, Prom, and so on. About 100 items. Data Processing, Technical Documentation ∙ 7 hours 33 minutes back ∙ 26 proposals |
Convert Word to LaTeXIt is necessary to convert the attached file to LaTeX. The article is of a scientific nature. The format is simple without unnecessary load in the form of formulas/figures. Please specify the deadlines and rates. Thank you. Data Parsing, Technical Documentation ∙ 11 days 3 hours back ∙ 14 proposals |