Njira zowononga zakupha Microsoft Excel
Excel ndi pulojekiti ya spreadsheet.
Pulogalamu yamakina apakompyuta ndi pulogalamu ya pakompyuta yomwe imagwiritsidwa ntchito kusungirako, kukonzekera ndi kusunga deta .
Kodi Pulogalamu Yotani Imagwiritsidwa Ntchito
Ndondomeko zamakalata zamakono zogwiritsidwa ntchito polemba mapepala zimagwiritsidwa ntchito polemba mapepala. Momwemonso, chiyambi cha makalata apakompyuta ndi ofanana ndi mapepala. Deta yowonjezereka imasungidwa pa matebulo - omwe ndi mndandanda wa timabuku ting'onoting'ono ting'onoting'ono ting'onoting'ono ting'onoting'ono ting'onoting'ono ting'onoting'ono ting'onoting'ono ting'onoting'ono ting'onoting'ono.
Zamakono za Excel ndi mapulogalamu ena a spreadsheet akhoza kusunga masamba ambiri a spreadsheet mu fayilo imodzi yamakompyuta.
Fayilo yamakono yopulumutsidwa imatchulidwa ngati bukhuli ndipo tsamba lirilonse mu bukhuli ndi lolemba limodzi.
Zotsatira za Excel
Mapulogalamu ena omwe alipo pakali pano omwe akupezeka kuti agwiritsidwe ntchito ndi awa:
Mapepala a Google (kapena Google Spreadsheets) - pulogalamu ya spreadsheet yaulere, ya webusaiti;
Excel Online - gawo laulere, lotsekedwa, lotsekedwa pa webusaiti ya Excel;
Open Office Calc - pulogalamu yapadalati yaulere, yomasulidwa.
Maselo a Spreadet ndi Ma References
Pamene muyang'ana mawonekedwe a Excel - kapena chithunzi china chilichonse chapachikapiritsi - mumapanga tebulo kapena timipukutu timzere ndi mizere , monga momwe taonera pa chithunzi pamwambapa.
Mu ma Excel atsopano, tsamba lililonse lili ndi mizere yokwana miliyoni ndi zoposa 16,000 zikhomo, zomwe zikutanthauza dongosolo lokulankhulana kuti lidziwe kumene deta ili.
Mizere yopanda malire imadziwika ndi manambala (1, 2, 3) ndi mazenera ofanana ndi zilembo za alfabeti (A, B, C). Kwa zigawo zopitirira 26, zipilala zimadziwika ndi zilembo ziwiri kapena zambiri monga AA, AB, AC kapena AAA, AAB, ndi zina.
Pakati pa ndime ndi mzere, monga tafotokozera, ndi bokosi laling'ono laling'ono lotchedwa selo.
Selo ndilo gawo lalikulu lokusungiramo deta muzenera, ndipo chifukwa tsamba lililonse lili ndi mamiliyoni a maselo awa, aliyense amadziwika ndi selo yake.
Mndandanda wa selo ndi kuphatikiza kalata ya mzere ndi mzere wolemba monga A3, B6, ndi AA345. Muzokambirana za maselo, kalata yam'mbali nthawi zonse imatchulidwa.
Ma Deta, Mafomu, ndi Ntchito
Mitundu ya deta yomwe selo lingakhoze kugwira ndi:
- Numeri;
- Malemba;
- Nthawi ndi nthawi;
- Zofunika za Boolean ;
- Mafomu .
Mafomu amagwiritsidwa ntchito powerengera - nthawi zambiri kuphatikizapo deta yomwe ili m'maselo ena. Maselo amenewa, angakhale ali pamabuku osiyana kapena mabuku osiyanasiyana.
Kupanga ndondomeko kumayambira mwa kulowa chizindikiro chofanana mu selo komwe mukufuna yankho. Mafomu angaphatikizepo mafotokozedwe a selo kumalo a deta ndi ntchito imodzi kapena masiperesi.
Ntchito mu Excel ndi ma fayilo ena apakompyuta amamangidwa mwazimene zimapangidwa kuti zikhale zosavuta kupanga zowerengera zosiyanasiyana - kuchokera kuntchito zofanana monga kulowa tsiku kapena nthawi ku zovuta zambiri monga kupeza chidziwitso chomwe chili m'matawuni akuluakulu a deta .
Excel ndi Financial Data
Mafadala amagwiritsidwa ntchito kusunga deta zachuma. Mafomu ndi ntchito zomwe zimagwiritsidwa ntchito pa deta ili ndi izi:
- Kupanga machitidwe oyambirira a masamu monga kuphatikiza ndemanga kapena mizere ya manambala .
- Kupeza mfundo monga phindu kapena kutaya.
- Kuwerengera mapulani obwezera ngongole kapena ngongole.
- Kupeza chiwerengero, chiwerengero, chiwerengero chochepa ndi chiwerengero china cha chiwerengero mu deta yambiri.
- Kufufuza -Kodi kusanthula pa deta - komwe kusintha kumasinthidwa kamodzi panthawi kuona momwe kusinthaku kumawonongera deta zina - monga ndalama ndi phindu.
Zochita Zina za Excel
Zochitika zina zomwe zimachitika kuti Excel zingagwiritsidwe ntchito monga:
- Zithunzi zojambulajambula kapena zojambula kuti zithandize ogwiritsa ntchito kuzindikira zizindikiro za deta.
- Kupanga deta kuti apange deta yofunika kwambiri kupeza ndi kumvetsa.
- Kusindikiza deta ndi makadi kuti zigwiritsidwe ntchito mu malipoti.
- Kusankha ndi kusanthula deta kuti mudziwe zambiri.
- Kugwirizanitsa deta ndi ma chart pakagwiritsidwe ntchito muzinthu zina monga Microsoft PowerPoint ndi Word.
- Kulowetsa deta kuchokera kumapulogalamu a mndandanda kuti awunike.
Mapepala anali oyambirira ' mapulogalamu opha' a makompyuta awo chifukwa cha kuthekera kwawo kusonkhanitsa ndi kumveka bwino. Mapulogalamu oyambirira a spreadsheet monga VisiCalc ndi Lotus 1-2-3 makamaka ndiwo amachititsa kukula kwa makompyuta monga Apple II ndi IBM PC monga bizinesi.