Yadda za a ƙirƙiri List List a Excel 2003

01 na 08

Gudanar da Bayanai a Excel

Samar da jerin sunayen a Excel. © Ted Faransanci

A wasu lokuta, muna bukatar mu ci gaba da lura da bayanai. Zai iya zama lissafin lambobi na lambobin waya, jerin lambobi don mambobin kungiyar ko ƙungiya, ko tarin tsabar kudi, katunan, ko littattafai.

Kowace bayanan da kake da shi, ɗakunan rubutu , kamar Excel, wuri ne mai kyau don adana shi. Excel ta gina kayan aiki don taimaka maka kiyaye bayanin bayanai da kuma samun bayanan bayani idan kana so. Bugu da ƙari, tare da daruruwan ginshiƙai da dubban layuka, ɗakin lissafin Excel zai iya ɗaukar adadin bayanai .

Excel ya fi sauƙi a yi amfani da shi fiye da tsarin saitin gaba ɗaya kamar Microsoft Access. Za a iya shigar da bayanai cikin sauƙi a cikin maƙunsar, kuma, tare da ƙananan hanyoyi na linzamin kwamfuta za ka iya raba ta bayananka kuma ka sami abin da kake so.

02 na 08

Samar da Tables da Lists

Tebur na bayanan a Excel. © Ted Faransanci

Mahimman tsari na adana bayanai a Excel shine tebur. A teburin, an shigar da bayanai a layuka. Kowane jere an san shi a matsayin rikodin .

Da zarar an halicci tebur, ana iya amfani da kayayyakin aikin na Excel don bincika, raba, da kuma tace fayilolin don samun bayani na musamman.

Kodayake akwai hanyoyi da dama da zaka iya amfani da waɗannan kayan aikin kayan aiki a Excel, hanya mafi sauki ta yin haka shine, don ƙirƙirar abin da aka sani da jerin daga bayanai a tebur.

03 na 08

Shiga Data Daidai

Shigar da bayanai daidai don jerin. © Ted Faransanci

Mataki na farko a ƙirƙirar tebur shine shigar da bayanai. Lokacin yin haka, yana da muhimmanci a tabbatar da an shigar da shi daidai.

Kuskuren bayanai, lalacewa ta hanyar shigar da bayanai ba daidai ba, sune tushen matsala masu yawa dangane da gudanar da bayanai. Idan an shigar da bayanai daidai a farkon, shirin zai iya ba ku sakamakon da kuke so.

04 na 08

Rows Are Records

Bayanin bayanan bayanai a cikin tebur na Excel. © Ted Faransanci

Kamar yadda aka ambata, layuka na bayanai ana san su ne asali. Lokacin shigar da rubuce-rubucen kiyaye waɗannan sharuɗɗa a tuna:

05 na 08

Gumomin Yankuna ne

Sunaye sunaye a cikin tebur na Excel. © Ted Faransanci

Yayinda layuka a teburin ana kiranta su, litattafan suna da alamun filin . Kowace shafi yana buƙatar wata don gano bayanan da ya ƙunshi. Wadannan maƙallan suna kiransa sunayen filin.

06 na 08

Samar da Jerin

Amfani da akwatin rubutun Create List a Excel. © Ted Faransanci

Da zarar an shigar da bayanai a cikin tebur, za'a iya canza shi zuwa jerin . Don yin haka:

  1. Zaɓi kowane salula a cikin tebur.
  2. Zabi Jerin> Ƙirƙirar Lissafi daga menu don bude akwatin maganganun Creat List .
  3. Maganin maganganun na nuna jeri na sel don a haɗa su cikin jerin. Idan aka kirkiro tebur da kyau, Excel zai zaɓi zaɓin daidai.
  4. Idan zaɓi na zaɓi yana daidai, danna Ya yi .

07 na 08

Idan Range Jerin Ba daidai ba ne

Samar da jerin sunayen a Excel. © Ted Faransanci

Idan, ta wani dama, zangon da aka nuna a cikin akwatin zane na Creative ba daidai bane ba za ka buƙaci zaɓan jeri na jinsunan don amfani dashi cikin jerin.

Don yin haka:

  1. Danna maɓallin dawowa a cikin akwatin zane na Creature don komawa zuwa aikin aiki.
  2. Akwatin da aka tsara ta Halitta ya shiga wani akwati da kewayon kullun yana iya gani akan takardun aiki wanda kewaye da tururuwa masu tafiya.
  3. Jawo zaɓi tare da linzamin kwamfuta don zaɓar madaidaicin madadin Kwayoyin.
  4. Danna maɓallin sake dawowa a cikin akwatin zane na Ƙirƙiri na Ƙirƙiri don komawa zuwa al'ada na al'ada.
  5. Danna Ya yi don kammala jerin.

08 na 08

Jerin

Ayyukan bayanai a cikin jerin Excel. © Ted Faransanci

Da zarar an halitta,