Shin kayan aikin kyauta ne?

Eh. Ƙirƙira da sauke samfura kyauta ne kuma yana gudana a cikin burauzarku ba tare da asusu ba.

Shin samfura suna aiki a Google Sheets?

Eh. Formuloli na al'ada ne (SUM, COUNTIF, da makamantansu). Ku ɗora zuwa Google Drive, sannan ku buɗe da Google Sheets.

Menene bambanci tsakanin Basic da Pro?

Basic shafi ɗaya ne mai dabarun asali. Pro yana ƙara taƙaitawa, allunan KPI, kuma sau da yawa zane-zane tare da tsara bisa sharadi.

Kuna iya ƙirƙirar samfurin fanko mai shafuka da ginshiƙai na musamman?

I. Ku zaɓi “Samfurin fanko” kuma ku saita adadin shafuka, layuka, da ginshiƙai kafin ƙirƙira.

Wane harshe ne samfurin zai kasance a ciki?

Samfurin yana bin harshen da kuke burauza da shi a shafin: kanun ginshiƙai, sunayen shafuka, da bayanan misali duk ana ƙirƙira su a wannan harshe. Samfuran Larabci da Farisa suna buɗewa daga dama zuwa hagu (RTL); sauran harsuna daga hagu zuwa dama ne.

Samfuran Excel

Ku zaɓi samfurin da aka shirya don halarta, kuɗaɗen kashewa, rajistan kira, ko jadawalin lokutan aiki, ku daidaita layuka da ginshiƙai, sannan ku sauke XLSX da ke aiki a Excel da Google Sheets. Ana ƙirƙirar samfurin a harshen shafin. Kyauta, babu rajista.

Me wannan kayan aikin samfuran Excel ke yi?

Ku zaɓi takarda da aka shirya (tebur mai sauƙi ko kasafin kuɗi), ku saita layuka da ginshiƙai, sannan ku fitar da fayil ɗin Excel maimakon zana jadawali daga tushe. Ku buɗe fayil ɗin a Excel ko manhaja irinta.

Ku zaɓi samfuri daga jadawali, ku cika zaɓuɓɓukan bangaren gefe, sannan ku fitar. Samfura wurin farawa ne; ku ƙara fomula na ku idan ana buƙata. Don fakitin biyan kuɗi da ke shirye don buga, mai gina fakitin biyan kuɗi na iya dacewa fiye.

Ana gina fayiloli don zaman fitarwa. Ku duba lambobi bayan kun buɗe littafin aiki.

Yaushe kuke buƙatar samfuran Excel?

Jadawalin halarta na mako da sauri.
Sauƙaƙƙen kasafin kuɗi na wata don gida ko aiki.
Jadawalin kayan ajiya kafin ƙidaya ta zahiri.

Ginshikai

Shafuka

Sunayen ginshikai

Haka kuma kuna iya danna kan ginshiki a duban farko, sannan ku sake masa suna kai tsaye.

Lakabin layuka (na zaɓi)

Ana rubuta kowane layi a ginshikin farko a matsayin lakabin layi. Ku bar shi fanko idan ba a buƙata ba.

Nau'in ƙungiya

Wata

Shekara

Lambobin halarta

Tsallake Jumma'a da Asabar Shekara gaba ɗaya (shafi ɗaya a kowane wata) Nuna ginshikin sashen / aji

Duban farko na samfuri

Duban farko mai sauƙi. Fayil ɗin ƙarshe ya ƙunshi dabaru, tsarin da ya dogara da sharaɗi, da taƙaitawa don samfurin da aka zaɓa.

Samfuran Excel

Samfurin fanko

Halarta — Na asali

Halarta — Pro

Mai bin diddigin kuɗaɗe — Na asali

Mai bin diddigin kuɗaɗe — Pro

Rajistar kira da tuntuɓa

Jadawalin lokutan aiki na ma'aikata

Rajistar ayyukan kullum

Mai bin diddigin aiki (Kanban)

Rijistar shari'o'in lauya

Rajistar abokan ciniki

Jadawalin sauraron shari'a a kotu

Rijistar takardun shari'a

Mai bin diddigin kuɗin aikin abokin ciniki

Takardar maki na ɗalibai

Jadawalin aji na mako

Mai bin diddigin ayyuka

Mai tsara jarrabawa

Littafin maki na malami

Mai tsara darasi

Rajistar majiyyatan asibiti

Lokutan ganawa a asibiti

Rijistar takardun magani

Lissafin asibiti

Kayan kantin magani

Rajistar ma'aikata na HR

Buƙatun hutu

Takardar albashi

Masu sha'awar saye

Jerin yarjejeniyoyin sayarwa

Ziyarar sayarwa

Kayan ɗakin ajiya

Rijistar sayayya

Odar sayarwa

Jerin dukiyoyi

Abokan cinikin ƙasa da gidaje

Ayyukan mai aiki da kansa

Mai bin diddigin lokaci

Kasafin kuɗi na wata

Rijistar motsa jiki

Jerin karatu

Mai tsara taron

Jerin abubuwan aure

Mai tsara tafiya

Jerin lambobin tuntuɓa

Jerin lissafin kuɗi

Mai bin diddigin takardun kuɗi

Odar gidan abinci

Kayan gini

Sakamakon gwaje-gwajen dakin gwaje-gwaje

Rijistar alamun lafiya

Rubutun taron

Rundunar motoci

Rajistar gudummawa

Arin ɗakin karatu

Aikace-aikacen aiki

Binciken injiniya

Mai bin diddigin biyan kuɗi na lokaci

Jerin sayayya

Mai bin diddigin al'adu na mako

Ranakun ƙarewa na shari'a

Rijistar mu'amalar alkalin takardu

Halartar ɗalibai ta yau da kullum

Shirin karatu

Majiyyatan asibitin haƙori

Jadawalin allura

Takardar maki na tambayoyin aiki

Rajistar horo

Bin diddigin masu fafatawa

Jerin farashi

Canja wurin ɗakunan ajiya

Gyaran dukiya

Karɓar haya

Kalandar abun ciki

Ra'ayin abokin ciniki

Mai tsara abinci na mako

Biyan lissafin gida

Jerin kayan tafiya

Kwararar kuɗi