Alamu a cikin Photoshop: ka'idar, halitta, amfani

Microsoft Excel shi ne mafi mashahuri mai sarrafa kwamfutarka tsakanin masu amfani. Aikace-aikacen yana ɗaukar wannan wurin da ya cancanta, saboda yana da babban kayan aiki, amma aikin da ke ciki yana da sauki kuma mai mahimmanci. Excel zai iya magance matsaloli a yawancin sassan kimiyya da aikin sana'a: ilimin lissafi, kididdiga, tattalin arziki, lissafi, injiniya da sauransu. Bugu da ƙari, ana iya amfani da wannan shirin a cikin bukatun gida.

Amma, yin amfani da Excel akwai nau'i daya, wanda masu amfani da yawa sun kasance hasara. Gaskiyar ita ce, wannan shirin an haɗa shi a cikin aikace-aikacen Microsoft Office na aikace-aikace, inda ba tare da shi an haɗa shi da mai sarrafa kalmar ba, mai sadarwa don aiki tare da email na Outlook, shirin don ƙirƙirar gabatarwar PowerPoint, da sauransu. A lokaci guda, kunshin Microsoft Office, biya, da kuma la'akari da yawan shirye-shiryen da aka haɗa a ciki, yawan kudin da aka yi yana da yawa. Saboda haka, masu amfani da yawa sun kafa sassan Excel kyauta. Bari mu dubi mafi girma da kuma mashahuri.

Duba kuma: Analogs na Microsoft Word

Mai sarrafawa kyauta

An kirkiro Microsoft Excel da shirye-shiryen irin wannan masu amfani da na'ura masu launi. Sun bambanta da masu sauƙi na tebur tare da ayyuka masu mahimmanci da fasali. Bari mu juya ga bita na masu fafatawa a cikin Excel.

OpenOffice Calc

Abinda aka fi sani da Excel shine aikace-aikacen OpenOffice Calc, wanda aka haɗa shi a cikin ɗakin ɗakin na Apache OpenOffice. Wannan kunshin shi ne dandamali (ciki har da Windows), yana goyan bayan harshen Rasha kuma ya ƙunshi kusan dukkanin analogues na aikace-aikacen da Microsoft Office ke da shi, amma yana ɗaukar ƙananan sarari akan kwamfutar kuma yana aiki da sauri. Kodayake waɗannan ƙayyadaddun tsari ne, za a iya rubuta su a cikin dukiya na aikace-aikacen Calc.

Idan muka yi Magana game da Calc, to wannan aikace-aikace na iya yin kusan duk abin da Excel yayi:

  • kirkiro Tables;
  • gina graphics;
  • yin lissafi;
  • Tsarin halitta da jeri;
  • aiki tare da siffofi kuma mafi.

Calc yana da sauƙi, ƙwaƙwalwar ƙwaƙwalwa wanda ya fi kama da Excel 2003 a cikin ƙungiyarsa fiye da baya. Bugu da ƙari, Calc yana da ayyuka masu ƙarfi waɗanda ba su da mahimmanci ga ƙwararrun ƙwararrun dangin Microsoft, har ma ya wuce shi a wasu ka'idoji. Alal misali, yana da tsarin da ta tsara ta atomatik jerin sigogi bisa ga bayanan mai amfani, kuma yana da ƙwararren spell mai ciki, wanda Excel ba shi da. Bugu da kari, Calc zai iya fitarwa daftarin aiki zuwa PDF. Shirin ba kawai yana tallafawa aikin tare da ayyuka da macros ba, amma har ya ba ka damar haifar da su. Don aiki tare da ayyuka, zaka iya amfani da musamman Maigidanwanda zai taimaka wajen aiki tare da su. Gaskiya, sunayen dukkan ayyuka a Maigidan a cikin Turanci.

Tsarin fasalin fasalin shi ne ODS, amma zai iya aiki tare da wasu samfurori da dama, ciki har da XML, CSV da Excel XLS. Shirin zai iya bude dukkan fayiloli tare da kari wanda Excel zai iya ajiyewa.

Babban hasara na Calc shi ne cewa ko da yake zai iya buɗewa da kuma aiki tare da fasalin XelSX na zamani na Excel, bai riga ya iya adana bayanai a ciki ba. Saboda haka, bayan gyara fayil ɗin, dole ne ka ajiye shi a cikin wani tsari daban. Duk da haka, Open Office Kalk za a iya la'akari da kyauta mai kyauta kyauta ga Excel.

Sauke OpenOffice Calc

Free Calf

Shirin 'yanci na FreeOffice yana kunshe ne a cikin ofishin' yanci kyauta LibreOffice, wanda, a gaskiya, shine ƙwararren tsofaffin masu gabatarwa OpenOffice. Sabili da haka, ba abin mamaki bane cewa wadannan kunshe-kunshe suna cikin hanyoyi da dama kamar haka, kuma sunayen masu sarrafa kwamfutar suna da kama. Bugu da} ari, LibreOffice ba ta da daraja a cikin tsohuwar ɗan'uwansa. Har ila yau yana ɗaukan sararin samfurin PC.

Kwamfuta na Ofishin Tsaro yana da kama sosai a cikin aiki zuwa OpenOffice Calc. Ya san yadda za a yi kusan abu ɗaya: daga halittar Tables, zuwa tsara gine-gine da lissafin lissafi. Har ila yau, ƙirarsa tana ɗaukar Microsoft Office 2003 a matsayin asali. Kamar OpenOffice, LibreOffice yana da ODS a matsayin babban tsari, amma shirin zai iya aiki tare da duk siffofin da Excel ta goyan baya. Amma ba kamar OpenOffice ba, Kira ba zai iya buɗe takardun kawai a cikin tsarin XLSX ba, amma kuma ya adana su. Gaskiya, aikin ceto a cikin XLSX an iyakance, wanda aka bayyana, alal misali, a gaskiya cewa ba dukkanin abubuwa masu tsarawa waɗanda aka kashe a Kalk za a iya rubuta su zuwa wannan fayil ba.

Calc zai iya aiki tare da ayyuka, dukansu kai tsaye da ta hanyar Wizard aikin. Ba kamar layin OpenOffice ba, samfurin LibreOffice yana da sunayen ayyukan da aka rusa. Shirin yana goyon bayan harsuna da yawa don samar da macros.

Daga cikin rashin kuskure na Libre Office Kalk za'a iya kiransa da wasu kananan siffofin da suke cikin Excel. Amma a gaba ɗaya, aikace-aikacen ya fi aiki fiye da OpenOffice Calc.

Sauke Ƙaddamarwa na FreeOffice

PlanMaker

Mai sarrafawa na zamani shine PlanMaker, wanda aka haɗa a cikin SoftMaker Office Office. Har ila yau, bincikensa yana kama da ƙirar Excel 2003.

PlanMaker yana da damar da zai iya aiki tare da tebur da tsara su, yana iya aiki tare da tsari da ayyuka. Kayan aiki "Saka aiki" Analog ne Ma'aikata masu aiki Excel, amma yana da ayyuka mafi girma. Maimakon macros, wannan shirin yana amfani da rubutun a cikin tsarin BASIC. Babban tsarin da shirin da aka yi don adana takardun shine tsari na PlanMaker tare da ƙaramin PMDX. A lokaci guda, aikace-aikacen yana goyon bayan aiki tare da siffofin Excel (XLS da XLSX).

Babban hasara na wannan aikace-aikacen shine gaskiyar cewa cikakken aiki a cikin free version yana samuwa ne kawai don kwanaki 30. Wasu ƙuntatawa sun fara, alal misali, PlanMaker yana dakatar da goyon bayan tsarin XLSX.

Download PlanMaker

Rubutun Bayanin Symphony

Wani mawallafi mai mahimmanci, wadda za a iya la'akari da shi mai cancanta ga Excel, shine Symphony Spreadsheet, wani ɓangare na kamfanin IBM Lotus Symphony. Ƙirarta tana kama da ƙirar shirye-shirye na uku na baya, amma a lokaci guda ya bambanta da su a cikin asali. Symphony Launin rubutu yana iya magance matsalolin da suka bambanta da wuya lokacin aiki tare da tebur. Wannan shirin yana da kayan aiki masu kyau, ciki har da ci gaba Wizard aikin da kuma damar yin aiki tare da macros. Akwai alamar rubutun kalmomi wanda Excel ba shi da.

Ta hanyar tsoho, Symphony Spreadsheet yana adana takardun a cikin tsarin ODS, amma yana goyan bayan takardun ajiya a cikin XLS, SXC da wasu matakan. Za a iya bude fayiloli tare da tsawo na XLSX na Excel, amma, rashin alheri, ba zai iya ajiye Tables a cikin wannan tsari ba.

Daga cikin zane, yana yiwuwa a nuna cewa kodayake Symphony Spreadsheet kyauta ne kyauta, kana buƙatar shiga ta hanyar yin rajistar a shafin yanar gizon yanar gizon don sauke nauyin IBM Lotus Symphony.

Sauke Symphony Labarai

Wread Spreadsheets WPS

A ƙarshe, wani mashigin maɓallin lissafi mai mahimmanci shine WPS Spreadsheets, wanda aka haɗa a cikin kyawun WPS Office suite. Yana da ci gaban kamfanin Kingsoft.

Fayil ɗin Shafukan yanar gizo, ba kamar shirye-shirye na baya ba, ba a kan Excel 2003 ba, amma a kan Excel 2013. Ana kuma sanya kayan aiki a ciki akan rubutun, kuma sunayen shafukan suna kusan kamar sunaye a Excel 2013.

Babban tsari na shirin shine tsayinsa, wanda ake kira ET. A lokaci guda kuma, Shafukan Wallafi zasu iya aiki da adana bayanai a cikin takardun Excel (XLS da XLSX), da kuma sarrafa fayilolin tare da wasu kari (DBF, TXT, HTML, da dai sauransu). Za'a iya samun ikon fitar da tebur a cikin tsarin PDF. Tsarin ayyukan tsarawa, samar da Tables, aiki tare da ayyuka suna kusan kamar Excel. Bugu da ƙari, akwai yiwuwar ajiyar iska na fayiloli, da kuma ginin da aka gina Binciken Google.

Babban bita na shirin shine cewa ko da yake za'a iya amfani dashi kyauta, amma don wasu ayyuka (buga takardu, ajiyewa a cikin tsarin PDF, da dai sauransu), dole ne ka kalli bidiyon tallace-tallace guda daya a kowane rabin sa'a.

Sauke fayilolin WPS

Kamar yadda kake gani, akwai aikace-aikacen kyauta masu yawa waɗanda zasu iya gasa tare da Microsoft Excel. Kowannensu yana da kwarewa da rashin amfani, wanda aka tsara a taƙaice. Bisa ga wannan bayanin, mai amfani zai iya ƙara ra'ayi na gaba game da shirye-shiryen da aka nuna don ya zabi mafi dacewa da manufofi da bukatunsa.