Tutorial na Tashoshin Excel 2003

01 na 10

Tutorial na Tashoshin Excel 2003

Wannan koyaswar yana rufe matakai don ƙirƙirar zane a Excel 2003 ta yin amfani da Wizard na Shafi na Excel.

Cika matakai a cikin batutuwa da ke ƙasa za su samar da sifa mai kama da hoton da ke sama.

Differences na Shafin

Matakan da ke cikin wannan koyasun suna amfani da zabin da aka shimfiɗa a cikin Excel 203. Wadannan sun bambanta daga waɗanda aka samo a farkon fasalin shirin. Yi amfani da hanyoyin da za a bi don biyan darussan layi don wasu sigogin Excel.

02 na 10

Shigar da Kayan Shafin Bayanan

Lura: Domin taimako tare da waɗannan umarnin, duba siffar misali a sama.

Ko da wane nau'i na chart ko hoto kake samarwa, mataki na farko a ƙirƙirar ginshiƙi na Excel shine sau da yawa don shigar da bayanai a cikin takardar aiki.

Lokacin shigar da bayanai, kiyaye waɗannan dokoki a hankali:

1. Kada ku bar layuka marasa launi ko ginshiƙai lokacin shigar da bayanai.
2. Shigar da bayanai a cikin ginshikan.

• A lokacin da ka shimfiɗa takardun ka, ka rubuta sunayen da ke kwatanta bayanai a cikin wani shafi kuma, zuwa dama na wannan, da bayanai kanta.
• Idan akwai jerin jerin bayanai fiye da ɗaya, lissafa su daya bayan daya a ginshiƙai tare da taken don kowane jerin bayanai a saman.

Don wannan koyawa

1. Shigar da bayanai kamar yadda aka gani a cikin hoton da ke cikin sel A3 zuwa B6.

03 na 10

Zaɓin Bayanan Shafin Kira

Lura: Domin taimako tare da waɗannan umarnin, duba siffar misali a sama.

Amfani da linzamin kwamfuta

1. Jawo zaɓi tare da maballin linzamin kwamfuta don haskaka da kwayoyin dauke da bayanan da za a hada a cikin zane.

Yin amfani da keyboard

1. Danna kan hagu na hagu na bayanai.
2. Riƙe maɓallin SHIFT akan keyboard.
3. Yi amfani da maɓallin kibiya a kan keyboard don zaɓar abubuwan da za a haɗa a cikin zane.

Lura: Tabbatar zaɓin kowane shafi da jigogi waɗanda ke so a hada su cikin jadawali.

Don wannan koyawa

1. Gano gunkin sel daga A3 zuwa B6 ta amfani da daya daga cikin hanyoyin da aka sama.

04 na 10

Fara Wizard na Shafin

Lura: Domin taimako tare da waɗannan umarnin, duba siffar misali a sama.

Kuna da zaɓi biyu don fara Wizard na Shafuka na Excel.

1. Danna maɓallin Wizard na Chart a kan kayan aiki mai kyau (duba misalin hoto a sama)
2. Danna kan Saka> Shafuka ... a cikin menus.

Don wannan koyawa

1. Fara Wizard na Chart ta amfani da hanyar da kuka fi so.

05 na 10

Wizard na Shafi na Excel Mataki 1

Nemi Chart a Tabbaccen Tab

Lura: Domin taimako tare da waɗannan umarnin, duba siffar misali a sama.

1. Nemo nau'in Shafin daga sashin hagu.
2. Nemi nau'in sashin shafuka daga kwamiti na dama.

Don wannan koyawa

1. Zaɓi nau'in nau'in nau'in nau'in nau'i a hannun hagu.
2. Zaɓi nau'in tare da nau'i-nau'i-nau'i-nau'i-nau'i-nau'i mai siffa 3-D a hannun dama dama
3. Danna Next.

06 na 10

Wizard na Shafuka na Excel Mataki na 2

Nuna Shafinku

Lura: Domin taimako tare da waɗannan umarnin, duba siffar misali a sama.

• Bayan zabar bayananku kafin fara Wizard na Shafuka na Excel, ya kamata ku ga misali na ginshiƙi ɗinku a saman taga na akwatin maganganu.
• A kan shafukan yanar gizonku , bayanan da aka kunshe a cikin ginshiƙi an kewaye da tururuwa masu tafiya - da iyakokin baki da ke kewaye da bayanan ku.
• A ƙasa da samfurin samfurin shine akwatin da ke dauke da tantanin labaran labaran da ke cikin jerin. Idan ginshiƙi ɗinka bai duba ba daidai ba, duba don tabbatar da zaɓin tarin bayanai na dama a cikin maƙallan.

Don wannan koyawa

1. Danna Next.

07 na 10

Wizard na Shafuka na Excel Mataki na 3

Shafin Zabuka

Lura: Domin taimako tare da waɗannan umarnin, duba siffar misali a sama.

Kodayake akwai zaɓuɓɓuka da dama a ƙarƙashin shafuka shida don gyaran bayyanar sakonka , a cikin wannan mataki, za mu ƙara kawai sunayen sarauta.

Dukkan ɓangaren ginshiƙi na Excel za a iya gyaggyarawa bayan ka kammala Wizard na Shafuka, saboda haka ba lallai ba ne don yin dukkan zaɓin tsarawa a yanzu.

Don wannan koyawa

1. Danna kan shafin Tituka a saman akwatin zane na Shafuka.
2. A cikin Chart title title, rubuta maƙallin: Kayan Cookie Shop 2007 Kasuwanci Revenue .
3. Danna kan shafin Labarin Labarun a saman akwatin zane na Shafuka.
4. A cikin Label Ya ƙunshi ɓangarori, danna kan Zaɓin kashi don zaɓar shi.
5. Lokacin da chart a cikin samfoti taga ya dubi dama, click Next.

Lura: Yayin da kake ƙara take da alamun bayanan bayanai dole a kara su zuwa ga samfurin dubawa zuwa dama.

08 na 10

Wizard na Shafuka na Excel Mataki na 4

Shafin Yanayi

Lura: Domin taimako tare da waɗannan umarnin, duba siffar misali a sama.

Akwai zabi biyu kawai inda kake so ka sanya sakonka:

1. A matsayin sabon takardar (sanya shafukan a kan daban-daban takarda daga littafinku)
   
2. A matsayin abu a cikin takarda 1 (sanya sashin a kan takarda kamar bayaninka a cikin littafin aiki)

Don wannan koyawa

1. Latsa maɓallin rediyo don sanya ginshiƙi a matsayin abu a cikin takarda 1.
2. Danna Ƙarshe.

An halicci sifa mai mahimmanci kuma an sanya shi a kan takardar aikinku. Shafuka masu shafewa suna rufe tsarin tsara wannan ginshiƙi don dacewa da zane-zane da aka nuna a Mataki na 1 na wannan tutorial.

09 na 10

Ƙara Launi zuwa Rubutun Hanya

Lura: Domin taimako tare da waɗannan umarnin, duba siffar misali a sama.

Canja launin launi na chart

1. Dama sau ɗaya sau ɗaya tare da maɓallin linzamin kwamfuta a ko'ina a farar fata na jadawalin don buɗe jerin menu na saukewa.
2. Danna tare da maɓallin linzamin kwamfuta a kan zaɓi na farko a cikin menu: Tsarin Shafin Farko don buɗe akwatin maganganun Shafukan Siffar.
3. Danna kan Alamomin shafin don zaɓar shi.
4. A cikin Yanki yanki, danna kan mai launin launi don zaɓar shi.
5. Don wannan koyo, zaɓi launin launi mai launi a kasa dama na akwatin maganganu.
6. Danna Ya yi.

Canja launin launi / cire iyakar daga labari

1. Dama sau ɗaya sau ɗaya tare da maɓallin linzamin kwamfuta a ko'ina a bayan bayanan jadawali don bude jerin menu na saukewa.
2. Danna tare da maɓallin linzamin kwamfuta a kan zaɓi na farko a cikin menu: Tsarin Legend don buɗe akwatin maganganu na Legend.
3. Danna kan Alamomin shafin don zaɓar shi.
4. A cikin Yankin Ƙauren gefen hagu na maganganun, danna kan Babu wani zaɓi don cire iyakar.
5. A cikin Yanki yanki, danna kan mai launin launi don zaɓar shi.
6. Don wannan koyo, zaɓi launin launi mai launi a kasa dama na akwatin maganganu.
7. Danna Ya yi.

10 na 10

Yin amfani da wani abu na Kayan

Lura: Domin taimako tare da waɗannan umarnin, duba siffar misali a sama.

Don ƙara ƙarfafawa ga wani yanki na kullun zaka iya motsa ko "fashe" wannan yanki daga sauran sashin.

1. Danna tare da maɓallin linzamin kwamfuta a kan tasirin don haskaka shi. Ƙananan tubalan duhu ya kamata a bayyane a gefen waje na kek.
2. Danna sau biyu tare da maɓallin linzamin kwamfuta a kan rawaya (raunin oatmeal) sashi na kek. Wajibi ne a rufe yanzu kawai wannan yanki na kek.
3. Danna kuma ja zuwa hagu tare da maɓallin linzamin kwamfuta a kan rawanin rawaya na kek. Yankin ya kamata ya motsa daga sauran sassan.
4. Don motsa ɓangaren fashewa a koma wurin wurinsa na ainihi sake maimaita matakai 1 da 2 a sama sannan kuma jawo yanki zuwa kullin. Zai dawo ta atomatik zuwa wuri na asali.

Tare da rawanin rawaya ya fashe sashin layinku ya kamata ya dace da zane-zane da aka nuna a Mataki na 1 na wannan tutorial.