Yadda za a yi da kuma shimfiɗa ginshiƙi a cikin Excel 2010

01 na 06

Matakai don yin Shafin Kwance a Excel 2010

Matakai don ƙirƙirar ginshiƙi na asali a Excel 2010 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 sashin da ake so;

Shafin rubutu, marar daidaituwa - wanda ke nuna kawai jerin jerin bayanai, da labari, da lambobin axes - za a kara su zuwa aikin aiki na yanzu.

Bambancin Shafin cikin Excel

Matakan da ke cikin wannan koyaswa suna amfani da samfurin tsarawa da shimfidawa da aka samo a cikin Excel 2010 da 2007. Wadannan sun bambanta da waɗanda aka samu a farkon da kuma daga baya versions na wannan shirin. Yi amfani da hanyoyin da za a bi don biyan darussan shafi don wasu sigogin Excel.

• Koyarwa ta Tashoshi na Excel 2013
• 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. Idan haka ne, kawai zabi launuka zuwa ƙaunarka kamar maye da ci gaba.

• Ta yaya dubawa da canza halin jarraba na yanzu

02 na 06

Ƙirƙirar Shafin Shafi a Excel

Shigar da Zaɓin Bayanan Tutorial

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.

Mataki na farko a ƙirƙirar ginshiƙi yana shigar da bayanan chart - ko da wane nau'i na chart an halicce su.

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

Lokacin da zaɓin bayanan, ana sanya jeri na jere da na shafi a cikin zaɓin, amma take a saman bayanan da aka ba da shi ba. Dole ne a kara lakabi a cikin sakon da hannu.

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

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 Ƙungiyar Clustered Column na 3-D , danna kan Clustered Column - don ƙara wannan maƙasudin ma'auni zuwa takardar aiki

03 na 06

Ra'ayoyin Shafuka na Excel da Ana cire Rukunin Grid

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.

Share Shafin Grid daga Yanayin Ramin

Shafin jeri na yau da kullum ya haɗa da jerin grid da ke gudana a fili a fadin filin fili domin ya sauƙaƙe don karanta dabi'u don ƙayyadaddun bayanai - musamman ma a cikin sigogi dauke da yawancin bayanai.

Tunda akwai kawai jerin jerin bayanai guda uku a cikin wannan tasirin, bayanan bayanan na da sauki sauƙi don karantawa, saboda haka za'a iya ƙarancin ɗakunan grid.

1. A cikin zane, danna sau ɗaya a kan tashar jirgin sama na $ 60,000 da ke gudana ta hanyar tsakiyar jadawali don nuna alama ga dukkanin jerin grid - kananan kwakwalwa masu launin shuɗi za a gani a ƙarshen kowane gridline
2. Latsa Maɓallin sharewa a kan maɓallin kewayawa don cire fayilolin grid

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

04 na 06

Canza Shafin Rubutun

Shafukan Kayan Shafin Zabuka

Lokacin da aka kirkiro wani nau'i a cikin Excel 2007 ko 2010, ko kuma duk lokacin da aka zaba maɓallin da aka rigaya ta danna kan shi, ana ƙara ƙarin shafuka guda uku a rubutun kamar yadda aka nuna a hoton da ke sama.

Wadannan shafukan Rubutun Shafuka - Zane, Layout, da Tsarin - sun ƙunshi tsarawa da shimfida tsarin musamman don sigogi, kuma za'a amfani da su a matakai na gaba don ƙara lakabi zuwa ginshiƙi da kuma canza launuka.

Ƙara da Editing Shafin Title

A cikin Excel 2007 da 2010, sigogi na asali ba su haɗa sunayen sunayen layi ba. Wadannan dole ne a kara da su ta daban ta hanyar amfani da Zaɓin Lissafi wanda aka samo akan Layout tab kuma sannan an shirya don nuna alamar da ake so.

1. Danna sau ɗaya a kan zane don zaɓar shi, idan ya cancanta, don ƙara rubutun kayan aikin shafe zuwa rubutun
2. Danna kan Layout tab
3. Danna kan Zaɓin Lissafin Zaɓin don buɗe jerin jerin zaɓuɓɓuka
4. Zaɓi Hanya mafi girma daga lissafi don sanya tsoffin akwatin shafuka a cikin ginshiƙi a saman ginshiƙan bayanai
5. Danna sau ɗaya a cikin akwatin taken don gyara rubutun taken tsoho
6. Share da rubutun tsoho kuma shigar da maɓallin lambar - Kayan Kayan Kayan Kayan Kayan Kayan Kayan Kayan Kayan Kayan Kayan Kayan Kayan Kayan Kayan Kayan Kayan Kayan Kuki 2013 - cikin akwatin taken
7. 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

Canza Font Type

Canja nau'in alamar da aka saba amfani dashi don duk rubutun a cikin zane ba kawai zai inganta bayyanar chart ɗin ba, amma zai sa ya fi sauƙi a karanta labaran da sunayen da kuma dabi'u.

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 nema kuma danna lakabi Arial Black a cikin jerin don canza take zuwa wannan layi

Canza Labarin da Rubutun Axes

1. Maimaita matakan da ke sama don sauya rubutun a cikin zane na labari da kuma X da Y zuwa ga Arial Black

05 na 06

Canje-canje Canjin a cikin Takaddun Shafin

Canza Launi na Fasa da Ƙungiya

Wannan matakai a cikin koyo shine ya canza launin launi na bangon da bangon gefe zuwa baki kamar yadda aka gani a cikin hoto a sama.

• Taswirar shimfidawa shine kusurwar kwalliya a kwance a ƙarƙashin ginshiƙan bayanai a cikin yanki.
• Ƙungiyar gefen gefen gefen hagu na yanki tsakanin ginshiƙan bayanai da kuma alamomin Y (a tsaye).

Dukkan abubuwa za a zaɓa ta amfani da jerin abubuwan da aka saukar da jerin ginshiƙi a gefen hagu na Layout tab na rubutun.

1. Danna kan chart baya don zaɓar dukan ginshiƙi idan ya cancanta
2. Danna maɓallin Layout na rubutun
3. Tare da dukan sashin da aka zaɓa, jerin abubuwan da aka tsara za su nuna sunan Shared Area a cikin hagu na hagu na rubutun.
4. Danna maɓallin ƙusa kusa da zaɓin zaɓi na zane don buɗe jerin ɓangaren sassa
5. Zaɓi Fasa daga lissafin sassan sassa don nuna haskaka gidan bene
6. Danna kan Rubutun shafin na kintinkiri
7. Danna kan Zaɓin Ƙarin Shafi don buɗe Ƙungiyar Fill ta saukar da panel
8. Zaɓi Black, Rubutun 1 daga sashin Launuka na Launin don canja launi na launi zuwa baki
9. Yi maimaita matakai 2 zuwa 6 a sama don canza launi na gefen Wall na baki

Idan ka bi duk matakai a cikin koyawa, a wannan batu, sakonka ya dace da wanda aka gani a cikin hoto a sama.

06 na 06

Canza Launin Lissafi da Matsar da Shafin

Canja launi na Taswirar Yanayin Shafin

Wannan mataki a cikin koyawa na canza yanayin bayyanar ginshiƙai ta hanyar canza launuka, ƙara wani digiri, da kuma ƙara wani zane ga kowane shafi.

Za'a yi amfani da siffar kuma za a yi amfani da zaɓin siffofi na siffofi , wanda yake a kan shafin Tab ɗin don shafi waɗannan canje-canje. Sakamakon zai daidaita da ginshiƙan da aka gani a hoton da ke sama.

Canza Lissafin Kuɗi Tarin Kuɗi

1. Danna sau ɗaya akan daya daga cikin ginshiƙan Tarin Kuɗi na Ƙarin Turare a cikin zane don zaɓar kowane ginshiƙan ginshiƙan guda uku
2. Danna kan Rubutun shafin na kintinkin idan ya cancanta
3. Danna kan Zaɓin Ƙarin Shafi don buɗe Ƙungiyar Fill ta saukar da panel
4. Zabi Dark Dark, Rubutu 2, Sauke 60% daga Sashin Launi na Launin don canza ginshiƙan 'launi zuwa haske mai haske

Ƙara Mashahurin

1. Tare da ginshiƙan Kudin Kudin Kuɗi Duk da haka aka zaɓa, danna kan Zaɓin Shafukan Zaɓuɓɓuka a karo na biyu don buɗe Fill Lines ya sauke menu
2. Gyara maɓallin linzamin kwamfuta a kan zaɓi na Gradient a kusa da kasan jerin don buɗe ɗayan Gudun
3. A cikin Ƙarin Bayani ɓangaren ɓangaren panel, danna kan layin Layin dama don ƙara ƙwararren da ke samun haske daga hagu zuwa dama a fadin shafi

Ƙara Maɓallin Shafi

1. Tare da ginshiƙan Kudin Kudin Kuɗi Duk da haka an zaba, danna kan Zaɓin Shafin Zaɓuɓɓuka don buɗe Shafin Kayan Shafin Shafi
2. A cikin Yanayin Launuka na Ƙungiyoyi , zaɓi Dark Blue don ƙara wani zane mai duhu a cikin kowane shafi
3. Danna maɓallin Shafin Shafi a karo na biyu
4. Danna kan zaɓi Tsarin a cikin menu don buɗe menu na menu na zaɓuɓɓuka
5. Zaɓi 1 1/2 pt. don ƙara ɗaukakar ginshiƙan ginshiƙan

Shirya Ƙarin Kudin Kudin

Yi maimaita matakai da aka yi amfani da su don tsara ginshiƙan Ƙarin Haraji , ta amfani da tsarin da suka biyo baya:

• Maɓallin Shafi Kasa Launi: Jagoran Red 2, Darker 50%
• Matsayi mai sauƙi: Saukewar haske , Linear dama
• Shafin Maɓallin Shafi: Red Accent 2, Darker 50%
• Jerin Lissafin Lissafi: 1 1/2 pt.

Tsarin samfurori na Lissafi / Loss

Yi maimaita matakai da aka yi amfani da su don tsara ginshiƙan Ƙarin Haraji , ta amfani da tsarin da suka biyo baya:

• Launi ta cika Launi: Tsaren Kore na Olive 3, Darker 25%
• Matsayi mai sauƙi: Saukewar haske , Linear dama
• Shafin Maɓallin Shafi: Girman Gishiri na Olive 3, Darker 50%
• Jerin Lissafin Lissafi: 1 1/2 pt.

A wannan lokaci, idan duk matakan tsarawa sun biyo baya, mahaɗin shafi ya kamata kama da ginshiƙi da aka gani a hoton da ke sama.

Matsar da Shafin zuwa Sassin Takardar

Ƙarshen mataki a cikin koyawa na motsa ginshiƙi zuwa takarda daban a cikin ɗawainiyar ta amfani da akwatin maganganu na Move Chart.

Matsar da ginshiƙi zuwa takarda daban ya sa ya fi sauƙi don buga sutura kuma yana iya taimakawa kwantar da hankali a cikin babban ɗigun gadi da ke cike da bayanai.

1. Danna kan bayanan chart don zaɓar dukan ginshiƙi
2. Danna kan Shafin zane na kintinkiri
3. Danna kan madaurin Shagon icon ɗin a kan gefen dama na kintinkiri don buɗe akwatin maganganun Move Chart
4. Kamar yadda aka nuna a cikin hoton da ke sama, danna kan sabon saitin takarda a cikin akwatin maganganu kuma - in ba haka ba - ba da takardar suna, kamar Cookie Shop 2013 Abinda ke ciki
5. Danna Ya yi don rufe akwatin maganganu - ya kamata a kafa ginshiƙi a kan takarda daban tare da sabon sunan da ake gani a kan takardar shafi a kasa na allon.