He Aratohu Maahi-Maahi-Tapu ki te Whakauru i te Puka Raraunga Nama i Excel

01 o te 02

Te Whakaritea i te Puka ki te Whakaritea i te Haerenga Raraunga

Tāpiri Pukapuka i Excel. © Ted French

Ka tohatohahia e te Tatau Whakatau Neti te moni tangohanga a te kaimahi i tohua i roto i te waahanga o mua mai i te utu a Gross Salary o te kaimahi .

02 o 02

Tātaihia he Hipanga Tutorial Tuturu

Hei awhina i enei mahi, titiro ki te ahua o runga.

  1. Ki te tika, whakatuwhera i te tuhinga mahi i roto i te taahiraa o mua o te akoranga.
  2. Patohia te waea F8 - te taatai ​​e hiahia ana kia puta mai te whakautu o te tauira.
  3. Patohia he tohu whaitake ( = ) kia mohio a Excel kei te hangaia he ture.
  4. Patohia te D8 ki te whakauru i taua tohutoro pūtau ki te ture.
  5. Patohia he tohu iti ( - ), mai i te mea kei te tangohia e matou nga moni e rua.
  6. Patohia te waea E8 ki te whakauru i taua tohutoro pūtau ki roto i te ture.
  7. Patohia teENTER i te papapātuhi hei whakaoti i te ture.
  8. Me puta te whakautu 47345.83 i roto i te pūtau D8.
  9. A, no te piri i runga i te D8, ka kitea te ture = D8 - E8 i roto i te paerewa ture i runga i te pepa mahi .
  10. Tiakihia to tuhinga.