Yadda za a ƙirƙirar Shafin Shafin a Excel

01 na 06

Yadda za a ƙirƙirar Shafin Shafin a Excel

Matakai don ƙirƙirar ginshiƙi na asali a Excel sune:

1. Bayyana bayanin da za a hada a cikin sakon - hada da jigogi da kuma rubutun shafi amma ba maƙamin don lissafi ba;
2. Danna kan Saka shafin shafin rubutun ;
3. A cikin akwatin Sharuɗɗan rubutun, danna kan Saka Shafin Shafin Labaran don buɗe jerin jerin abubuwan da aka samo;
4. Sauke maƙalin linzamin ka a kan wani nau'i na chart don karanta bayanin siffin;
5. Danna kan hoton da ake so;

Wani sassauki, marar daidaituwa - wanda ya nuna kawai ginshiƙan wakiltar jerin jerin bayanai , wani maɓallin ginshiƙi, labari, da lambobin axes - za a kara zuwa ga aikin aiki na yanzu.

Bambancin Shafin cikin Excel

Matakan da ke cikin wannan koyo suna amfani da samfurori da layout da aka samo a cikin Excel 2013. Wadannan sun bambanta da waɗanda aka samo a farkon fasalin shirin. Yi amfani da hanyoyin da za a bi don biyan darussan shafi don wasu sigogin Excel.

• Shafin Farko na Shafuka na Excel 2010
• Excel 2003 (da kuma tsohuwar wallafe) Jagora na Yankin Shafi

A Note a kan Excel ta Theme Colors

Excel, kamar duk shirye-shiryen Microsoft Office, yana amfani da jigogi don saita samfurin takardunsa.

Batun da aka yi amfani dashi don wannan koyo shine tsoho shafin.

Idan ka yi amfani da wani batu yayin bin wannan koyawa, launuka da aka lakafta a cikin matakai na ƙila bazai samuwa a cikin taken kake amfani ba. In bahaka ba, kawai zaɓi launuka zuwa ga ƙauna kamar maye gurbin kuma ci gaba.

02 na 06

Shigar da Bayanin Tashoshin Hanya da Ƙirƙirar Shafin Shafi

Lura: Idan ba ka da bayanai a hannunka don amfani da wannan koyawa, matakai a cikin wannan koyaswa suna amfani da bayanan da aka nuna a hoton da ke sama.

Shigar da bayanan shafukan shine koyaushe mataki na farko a ƙirƙirar ginshiƙi - ko da wane irin nau'i na chart an halicce su.

Mataki na biyu yana nuna bayanin da za a yi amfani dashi wajen samar da ginshiƙi.

1. Shigar da bayanai da aka nuna a cikin hoton da ke sama zuwa cikin takardun aiki na daidai
2. Da zarar ya shiga, nuna hasashen Kwayoyin daga A2 zuwa D5 - wannan ita ce kewayon bayanan da za a wakilta ta ginshiƙi

Ƙirƙirar Shafin Shafin Basic

Matakan da ke ƙasa zasu haifar da sashin layi na asali - a cikin layi, marar ma'auni - wanda ke nuna jerin jerin bayanai guda uku, labari, da kuma maɓallin shafuka.

Bayan haka, kamar yadda aka ambata, tutorial ya kallafa yadda zakuyi amfani da wasu siffofi na al'ada, waɗanda, idan sun biyo baya, zasu canza fasali na musamman don daidaitawa da aka nuna a saman wannan tutorial.

1. Danna kan Saka shafin rubutun
2. A cikin akwatin Sharuɗɗan rubutun, danna kan Saka Shafin Shafin Labaran don buɗe jerin jerin abubuwan da aka samo.
3. Sauke maƙarƙircin linzaminka a kan nau'i na sutura don karanta bayanin siffin
4. A cikin ɓangaren shafi na 2-D na jeri, danna kan Clustered Column - don ƙara wannan maƙasudin ma'auni zuwa takarda aiki

03 na 06

Ƙara Rubutun Shafi

Shirya tsoho Chart Title ta danna sau biyu - amma kada ka danna sau biyu

1. Danna sau ɗaya a kan tsohuwar lambar layin don zaɓar shi - akwatin ya kamata ya bayyana a cikin kalmomin Chart Title
2. Latsa sau na biyu don saka Excel a yanayin gyare-gyare , wanda ke sanya siginan kwamfuta cikin akwatin take
3. Share da rubutun tsoho ta amfani da maɓallin Delete / Backspace akan keyboard
4. Shigar da maɓallin lissafin - Kayan Kayan Kayan Kayan Kayan Kayan Kayan Kayan Kayan Kayan Kayan Kayan Kayan Kayan Kayan Kayan Kayan Kayan Kuki 2013 - cikin akwatin taken
5. Sanya siginan kwamfuta tsakanin Shop da 2013 a cikin take kuma latsa maɓallin shigarwa a kan keyboard don raba take a kan layi biyu

A wannan batu, sakonku ya kamata ya kasance kama da misali da aka nuna a hoton da ke sama.

Danna kan ɓangaren ɓangare na Chart

Akwai sassa daban-daban zuwa ginshiƙi a Excel - irin su yanki na fili wanda ya ƙunshi ginshiƙi wanda yake wakiltar jerin bayanan da aka zaɓa, da labari, da kuma maɓallin ginshiƙi.

Duk waɗannan sassa suna dauke da abubuwa daban-daban ta hanyar shirin, kuma, saboda haka, kowanne zai iya tsara shi daban. Kuna gaya Excel wanda sashi na ginshiƙi da kake son tsara ta danna kan shi tare da maɓallin linzamin kwamfuta.

A cikin matakan da suka biyo baya, idan sakamakonku ba su da kama da waɗanda aka jera a cikin koyawa, yana da wataƙila ba ku da wani ɓangaren ɓangaren sashin da aka zaɓa lokacin da kuka ƙara wani zaɓi na tsarawa.

Kuskuren mafi kuskure yana danna kan filin da ke tsakiyar kaya lokacin da niyyar zaɓar dukan sigin.

Hanyar da ta fi dacewa don zaɓar kowane ginshiƙi shine danna a saman hagu ko kusurwar dama daga maɓallin ginshiƙi.

Idan an yi kuskure, za'a iya gyara ta hanyar amfani da Excel ta gyara fasalin don gyara kuskuren. Bayan haka, danna kan ɓangaren dama na chart kuma sake gwadawa.

04 na 06

Canza Yanayin Girman Yanayin da Launuka

Shafukan Kayan Shafin Zabuka

Lokacin da aka kirkiro wani nau'i a Excel, ko kuma duk lokacin da aka zaɓi wani zaɓi wanda aka zaba ta danna kan shi, ana ƙara ƙarin shafuka guda biyu a rubutun kamar yadda aka nuna a cikin hoto a sama.

Wadannan shafuka na Shafuka - zane da kuma tsari - sun ƙunshi tsarawa da shimfidawa musamman don sigogi, kuma za a yi amfani dasu a matakai na gaba don tsara tsarin shafi.

Canza yanayin Chart

Shirye-shiryen shafuka sune haɗakarwar haɓaka da zaɓuɓɓukan tsarawa waɗanda za a iya amfani dasu don tsara fasali ta hanyar amfani da nau'ukan da dama.

Ko kuma, kamar yadda yake cikin wannan koyawa, ana iya amfani da su azaman farawa don tsarawa tare da ƙarin canje-canjen da aka yi wa zaɓin da aka zaɓa.

1. Danna maɓallin bayanan don zaɓar dukan ginshiƙi
2. Danna kan Shafin zane na kintinkiri
3. Danna maɓallin Yanki na 3 a cikin sashen Shafin Yankin Rubutun na rubutun
4. Duk ginshiƙan da ke cikin sashi suna da gajere, fararen, layi da aka kwance ta hanyar su kuma labari ya kamata ya koma saman sashin karkashin ƙarƙashin taken

Canza Launin Lissafin

1. Danna kan chart baya don zaɓar dukan ginshiƙi idan ya cancanta
2. Danna maɓallin Launin Canji wanda aka saita a gefen hagu na Shafin zane na ribbon don buɗe jerin jerin layi na zabi launi
3. Sauke maɓallin linzamin ka a kowane layi na launuka don ganin sunan zaɓi
4. Danna kan zaɓi na Launi 3 a cikin jerin - na uku a cikin sashin layi na jerin
5. Shafin launuka don kowace jerin ya kamata ya canza zuwa orange, rawaya, da kore, amma layin fararen ya kamata a kasance a kowane shafi

Canza layin Tushen Shafin

Wannan mataki yana canza bayanan ginshiƙi zuwa launin toka mai launin toka ta amfani da Zaɓin Ƙarin Shafi wanda aka samo a kan Rubutun shafin shafin rubutun da aka gano a cikin hoto a sama.

1. Danna kan bayanan don zaɓar dukan ginshiƙi kuma don nuna shafuka na Shafuka akan rubutun
2. Danna kan Shafin shafin
3. Danna kan Zaɓin Ƙarin Shafi don buɗe Ƙungiyar Fill ta saukar da panel
4. Zaɓi Grey -50%, Haɗakar 3, Sauƙi 40% daga Yanayin Launuka na La'idar don canza launin launi na chart zuwa launin fari

05 na 06

Canza Shafin Rubutun

Canza Labarin Launi

Yanzu cewa bayanan launin toka ne, tsoho rubutu baƙar fata ba a bayyane yake ba. Wannan sashe na gaba ya canza launi na duk rubutun a cikin ginshiƙi zuwa kore don inganta bambanci tsakanin su biyu ta amfani da Zaɓin Rubutun Rubutun .

Wannan zaɓi yana samuwa a kan Siffar shafin shafin rubutun da aka gano a hoton a shafi na baya na koyawa.

1. Danna kan bayanan gefe don zaɓar dukan ginshiƙi, idan ya cancanta
2. Danna kan Rubutun shafin na kintinkiri
3. Danna kan Zaɓin Rubutun Rubutun don buɗe Rubutun Launin Rubutun Labaran
4. Zabi Green, Hawan 6, Darker 25% daga Sashin Launuka na jeri
5. Duk rubutun a cikin taken, axes, da labari ya kamata ya canza zuwa kore

Canza Nau'in Rubutun, Girma, da Ɗaukakawa

Canja girman da kuma irin nau'ikan da aka yi amfani da duk rubutun a cikin shafuka, ba kawai zai kasance inganta a kan matakan da aka yi amfani da su ba, amma zai sa ya fi sauƙi a karanta labaran da sunayen da kuma dabi'u a cikin shafuka. Za a kuma kara daftarin rubutun ga rubutun don a sa shi ya fi dacewa da baya.

Wadannan canje-canje za a yi ta amfani da zaɓuɓɓukan da aka samo a cikin ɓangaren sassan na shafin shafin shafin rubutun.

Lura : Girman layin yana auna a maki - sau da yawa ya ragu zuwa pt .
72 pt. rubutu daidai yake da ɗaya inch - 2.5 cm - a cikin girman.

Canza Rubutun Rubutun Shafi

1. Danna sau ɗaya a kan maɓallin ginshiƙi don zaɓar shi
2. Danna kan shafin shafin shafin rubutun
3. A cikin sashin layi na rubutun, danna kan akwatin Font don buɗe jerin jerin sauƙaƙe na fonutun da aka samo
4. Gungura don nemo kuma danna lakabin Leelawadee cikin jerin don canza sunan zuwa wannan jigon
5. A cikin Font Size akwatin kusa da akwatin jigilar, saita matakan lakabi zuwa 16 pt.
6. Danna kan gunkin Bold (wasika B ) a ƙarƙashin akwatin Font don ƙara girman matakan zuwa take

Canza Labarin da Rubutun Axes

1. Danna sau ɗaya a kan shafukan X (a kwance) a cikin ginshiƙi don zaɓar sunayen kuki
2. Yin amfani da matakan da aka jera a sama domin canza rubutun take, saita waɗannan alamomin a kan lakabi zuwa 10 pt Leelawadee, m
3. Danna sau ɗaya a kan tashoshin Y (na tsaye) a cikin ginshiƙi domin zaɓin kudin da aka haɓaka a gefen hagu na ginshiƙi
4. Amfani da matakan da ke sama, saita waɗannan takardun azuzu zuwa 10 pt Leelawadee, m
5. Danna sau ɗaya a kan rubutun chart don zaɓar shi
6. Amfani da matakan da ke sama, saita rubutun labari zuwa 10 pt Leelawadee, m

Duk rubutun a cikin zane ya kamata yanzu zama layin Leelawadee da duhu kore a launi. A wannan batu, shafukanku ya kamata su yi kama da ginshiƙi a cikin hoto a sama.

06 na 06

Ƙara Rukunin Grid da Canza Launiyarsu

Kodayake alamun grid na kwance sun kasance da farko tare da sakon layi na baya, ba su cikin bangare na sabon zane wanda aka zaba a mataki na 3, kuma, saboda haka, an cire.

Wannan mataki zai ƙara gridunan zuwa cikin yanki na filin.

Idan babu takardun bayanan bayanan da ke nuna ainihin darajar kowanne shafi, jerin grid ya sa ya fi sauƙi don karanta ƙididdigar ƙididdiga daga kudin da aka lissafa a kan iyakar Y (a tsaye).

Ana ƙara ƙididdigan grid ta amfani da Zaɓin Zaɓuɓɓukan Ƙara Shafin Zaɓuɓɓuka a kan Shafin zane na kundin.

1. Danna sau ɗaya a ɗaya daga cikin yanki na filin don zaɓi shi
2. Danna kan Shafin zane na ribbon idan ya cancanta
3. Danna kan Zaɓin Zaɓin Ƙaƙwalwar Zaɓuɓɓuka a gefen hagu na ribbon don buɗe jerin menu da aka sauke
4. A cikin menu mai sauƙaƙan , danna kan Gridunan> Na'urar Aiki na Gida Mai Girma don ƙara rashin ƙarfi, fararen, gridunan zuwa yanki na yanki na chart

Yin gyare-gyaren gyare-gyaren Amfani da Magana Ɗawainiyar Ɗawainiya

Matakai na gaba na koyawa suna yin amfani da nau'in aikin ɗawainiya , wanda ya ƙunshi mafi yawan zaɓuɓɓukan tsarawa don sigogi.

A Excel 2013, lokacin da aka kunna, aikin yana bayyana a gefen dama na allo na Excel kamar yadda aka nuna a hoton da ke sama. Rubutun da zaɓuɓɓukan da suke bayyana a cikin sauye-sauyen ayyuka sun danganta kan yankin da aka zaba.

Mataki na farko zai canza launin layin grid kamar yadda aka ƙara a sama daga farar fata zuwa orange domin ya nuna su a bayyane game da launin toka a ƙasa na yanki na filin.

Canza layin Grid 'Launi

1. A cikin jadawali, danna sau ɗaya a kan madaidaicin madaidaicin $ 60,000 wanda ke gudana ta tsakiyar hoto - dukkanin jerin grid ya kamata a hankalta (launin shuɗi da fari a ƙarshen kowane gridline)
2. Danna kan Rubutun shafin na kintinkin idan ya cancanta
3. Danna kan Zaɓin Zaɓin Zaɓi a gefen hagu na haƙƙin rubutun don buɗe Maɓallin Taswirar Ɗawainiya - batu a sama da aikin ya kamata a yi Magana da manyan Gridlines
4. A cikin aikin, saita samfurin layi zuwa layi mai tsabta
5. Saita launin layin waya zuwa Orange, Accent 2, Darker 25%
6. Dukkanin grid a cikin yanki ya kamata ya canza zuwa duhu orange a launi

Shirya Layin X X

Layin X ɗin yana samuwa a sama da alamomin X (sunayen kuki), amma, kamar layin grid, yana da wuya a gani saboda launin asalin launin fata. Wannan mataki zai canza launin launi da launi madaidaicin don daidaitawa da ƙididdigar grid.

1. Danna kan rubutattun X axis don haskaka layin X
2. A cikin tsarin tsara tsarin, kamar yadda aka nuna a cikin hoton da ke sama, saita nau'in layi zuwa layin daidaitacce
3. Saita layin layi zuwa Orange, Accent 2, Darker 25%
4. Sanya layin layi zuwa 0.75 pt.
5. Layin X ɗin ya kamata ya dace da layin grid na layi

Idan ka bi duk matakai a cikin wannan koyo, sashin shafukanka ya dace ya dace da misali da aka nuna a saman wannan shafi.