AUTO

https://edusakky-my.sharepoint.com/personal/p91639_edu_sakky_fi/_layouts/15/guestaccess.aspx?guestaccesstoken=Je2oam8%2bDprccTjKABvSeSWwPH%2foYgpVFo4uHh7rcGE%3d&docid=110ad5cdf9fb546979cb51529bb8e9a07

Lomake kauppa

testilomake

Ostoskuitin ALV-laskelmat

https://edusakky-my.sharepoint.com/personal/p91639_edu_sakky_fi/_layouts/15/guestaccess.aspx?guestaccesstoken=KX%2bC3Qs7V9mk%2bkHknxcjz71fK4HBEjRTohQ9IphR4vg%3d&docid=16ebca102e15a4680bc7610e45829a880

OMAT OHJEISTUKSET ja funktioita

1. Kuinka verottomasta hinnasta saadaan verollinen hinta.

- Verottomaan hintaan lisätään ALV ja siitä saadaan verollinen hinta. Veroton hinta + ALV

1. Kuinka verollisesta hinnasta lasketaan arvonlisän määrä?

-  Veron peruste kerrotaan voimassa olevalla verokannalla (eli tuotteen tai palvelun alv-prosentilla).
(verollinen hinta/verokanta + 100%))

1. Miten saadaan tuotteen VEROTON HINTA verollisesta hinnasta?

-  Kaavalla veroton hinta/(verokanta+100%)

________________________________________________

< piikki pistää pienempään :D

Alennus: hinta * alennusprosentti

ALV: alvprosentti * brutto


https://edusakky-my.sharepoint.com/personal/p91639_edu_sakky_fi/_layouts/15/guestaccess.aspx?guestaccesstoken=YjPUNiziW8bBeG59FsD5YfMK0bgUrqPuDBYxqTrmAwE%3d&docid=1ee350eb11dbe44729b6a30e44fd5ad02

Sakky shop viikkoraportti

https://edusakky-my.sharepoint.com/personal/p91639_edu_sakky_fi/_layouts/15/guestaccess.aspx?guestaccesstoken=Dj7RRBzisBWdfG8vXvSaKTW8g3JQs7Yua4S57qoQzBg%3d&docid=179af6fbaf8ca4be59cfd818675d9f636

harjoitustentti

https://edusakky-my.sharepoint.com/personal/p91639_edu_sakky_fi/_layouts/15/guestaccess.aspx?guestaccesstoken=wzxmTSVFiBInl1yzD1yIbECOMGoIq%2fk8br%2bYlxH642I%3d&docid=182194548c28d4aae81399a47c55a09ea

PHAKU -funktio

https://edusakky-my.sharepoint.com/personal/p91639_edu_sakky_fi/_layouts/15/guestaccess.aspx?guestaccesstoken=D8CcsRL8F6FpDPP5FmWe%2b90fNbLnBlyqyQoYqownEsw%3d&docid=1d65d8c6681214df5b199b422287459be

Pivot -taulukko

https://edusakky-my.sharepoint.com/personal/p91639_edu_sakky_fi/_layouts/15/guestaccess.aspx?guestaccesstoken=%2b2DJcazEdWUM%2bP3zTdDTERtHMjmzNHKIco6Z45MiwP4%3d&docid=1d14adafe2a7c47e4a4a35dd57009c7e2

Oma kuukausibudjetti

https://edusakky-my.sharepoint.com/personal/p91639_edu_sakky_fi/_layouts/15/guestaccess.aspx?guestaccesstoken=vc%2bLyoIAi98zr%2f76sFrVE0bT6O8GIQ2omQyPo7ExGNE%3d&docid=196608cf9a8c849bdacded8e8f7ed6b12

Kirjakauppa ja leipomo

https://edusakky-my.sharepoint.com/personal/p91639_edu_sakky_fi/_layouts/15/guestaccess.aspx?guestaccesstoken=YCYhyNMN0uI57D0aj6rrZXV%2bWvZ8TLeIBpN9uEvqT1o%3d&docid=1e1dba00303284553972d69207f575969

Suodatusta

https://edusakky-my.sharepoint.com/personal/p91639_edu_sakky_fi/_layouts/15/guestaccess.aspx?guestaccesstoken=rAV%2f9ehu9iwLpRlmJ%2bdC9bD0BS7%2fPAlqVWUi5wtED8E%3d&docid=18671fb4e8eba4075bd63ca3361b5046b

summa jos

https://edusakky-my.sharepoint.com/personal/p91639_edu_sakky_fi/_layouts/15/guestaccess.aspx?guestaccesstoken=EkoVsaMCDCMdDhvR1RSDjSkfByxV26tcsQs8iOYFmZ8%3d&docid=1f1d6bbd5ab684753832d43f3fa002169

Jossitellaan

https://edusakky-my.sharepoint.com/personal/p91639_edu_sakky_fi/_layouts/15/guestaccess.aspx?guestaccesstoken=J%2fXV0XiwMkAVRCjGYaxoy%2fb%2fPdnRzJO8r9H0rMsfd9Q%3d&docid=196e26fd4340e45e391ef3f8572753419

JOS funktio

https://edusakky-my.sharepoint.com/personal/p91639_edu_sakky_fi/_layouts/15/guestaccess.aspx?guestaccesstoken=bD998rwHgJTsewZ8ewUyw6eu7PAHN2kXef5RjEDM3rs%3d&docid=1b63fa0375e0643faacc5a10483ced033

Kukkia ja pippureita

https://edusakky-my.sharepoint.com/personal/p91639_edu_sakky_fi/_layouts/15/guestaccess.aspx?guestaccesstoken=wDvIUZ63GQRYkXR3Hqv4t2SPTW56cmU3Q5Rr%2f4KNjMg%3d&docid=11dab2c2641604e20b58d4737f2ba476d

Excelin kertausta

https://edusakky-my.sharepoint.com/personal/p91639_edu_sakky_fi/_layouts/15/guestaccess.aspx?guestaccesstoken=QuXVaHXUTxdX2cwO%2f5ag8d9tpBfIdATZfkXW9xolkvs%3d&docid=165ea0cf34e2c4c81a503e2f3624a68de

Tiedoston tallentaminen blogiin

https://edusakky-my.sharepoint.com/personal/p91639_edu_sakky_fi/_layouts/15/guestaccess.aspx?guestaccesstoken=4q7%2fQ%2bWg%2b74uyf55fFxA65kK6GMEagTYYCHwD08qR60%3d&docid=1d5672241186d42d09483afae82f35f96

joku

https://edusakky-my.sharepoint.com/personal/p91639_edu_sakky_fi/_layouts/15/guestaccess.aspx?guestaccesstoken=n5zHM75iL%2fiM9arOooP597HoGoJpjo9vNOSVxZUoKMw%3d&docid=122bbfb5e6d7d4993ba6ed49a0bbbde64