Yadda za a yi Shafin Girman Kasuwanci mai Saurin Girma a Excel

01 na 07

Rajista Kasuwanci na Excel Overview

Lura: Abin da yawancin mu ke kira jadawali ana kiransa a cikin Excel a matsayin ginshiƙi .

Hoto mai Girma-Low-Girgi yana nuna farashin yau da kullum, ƙananan, da kuma rufewa don ajiya akan lokaci da aka ba.

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

Matakan farko sun samar da ma'auni na asali kuma ɗayan na ƙarshe suna amfani da siffofin tsarawa da dama a ƙarƙashin Design , Layout , da Tsarin shafukan rubutun .

Tutorial Topics

1. Shigar da Shafin Bayanan
2. Zaɓi Bayanin Shafin
3. Ƙirƙirar Shafin Kasuwanci na Kasuwanci
4. Tsarin Chart na Zane - Zaɓi Yanayin
5. Tsarin Chart na Zane - Zaɓi Tsarin Shafi
6. Tsarin Chart na Zane - Ƙara wani suna zuwa Shafin Shafin

02 na 07

Shigar da Bayanin Shafin

Mataki na farko a cikin ƙirƙirar ma'auni na kasuwa mai ƙananan-ƙasa shine shigar da bayanai a cikin takardun aiki .

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

• A duk lokacin da ya yiwu, shigar da bayananka cikin ginshikan kamar yadda aka nuna a hoton da ke sama
• Sanya kayan aikinku tare da take don kowane jerin bayanai a saman shafin da bayanai a cikin kwayoyin da ke ƙasa
• Kada ku bar layuka marar launi ko ginshiƙai lokacin shigar da bayananku saboda wannan zai haifar da yankunan da ba a san a cikin shafuka ba

Lura: Koyarwar ba ta haɗa da matakai don tsara tsarin aiki ba kamar yadda aka nuna a hoton da ke sama. Bayani game da zaɓuɓɓukan tsara aikin aiki yana samuwa a cikin wannan mahimmancin koyo na Excel .

Tutorial Steps

Shigar da bayanai kamar yadda aka gani a cikin hoton da ke cikin sel A1 zuwa D6.

03 of 07

Zaɓin Bayanan Shafin

Biyu Zɓk. Don Zaɓin Bayanan Shafin

Domin taimako tare da waɗannan umarnin, duba samfurin misali a sama.

Yin amfani da linzamin kwamfuta

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

Yin amfani da maɓallin rubutu

1. Danna kan hagu na hagu na bayanan chart.
2. Riƙe maɓallin SHIFT akan keyboard.
3. Yi amfani da maɓallin arrow a kan keyboard don zaɓin bayanan da za a haɗa a cikin zane-zane.

Lura: Tabbatar zaɓin kowane lakabi da layi da kake so a hada da su a cikin zane.

Tutorial Steps

1. Gano gunkin sel daga A2 zuwa D6, wanda ya haɗa da rubutun shafi da jigogi jeri amma ba take ba, ta amfani da ɗayan hanyoyin da aka sama.

04 of 07

Ƙirƙirar Shafin Kasuwanci na Kasuwanci

Domin taimako tare da waɗannan umarnin, duba samfurin misali a sama.

1. Danna kan Saka shafin ribbon.
   
2. Danna kan sashen layi don buɗe jerin jerin sauƙaƙe na samfuri iri
   
   (Yin amfani da maɓallin linzamin ka a kan nau'i na chart zai kawo bayanin siffin).
   
3. Danna kan nau'in sidi don zaɓar shi.

Tutorial Steps

1. Idan kuna amfani da Excel 2007 ko Excel 2010, danna kan Saka> Sauran Shafuka> Ƙari> Ƙararrawa-Ƙananan-Low-Close a cikin kintinkiri
2. Idan kana amfani da Excel 2013, danna kan Saka> Sanya Stock, Surface ko Radar Shafuka> Kasuwanci> Ƙararrawa-Ƙananan-Ƙananan-kusa a cikin kintinkiri
3. An ƙirƙiri mahimman ƙananan haɗin kasuwancin kasuwa da aka sanya a kan takardar aikinku. Shafukan da ke biyo baya suna rufe tsarin tsara wannan ginshiƙi don daidaita siffar da aka nuna a farkon mataki na wannan koyawa.

05 of 07

Zaɓi Yanayin

Domin taimako tare da waɗannan umarnin, duba samfurin misali a sama.

A yayin da ka danna kan tashoshi, ana amfani da shafuka uku - Zane, Layout, da Tsarin shafukan zuwa rubutun karkashin rubutun kayan aikin Chart .

Zaɓin Ɗauki na Gundumar Kasuwanci

1. Danna kan maɓallin zane.
2. Danna kan Shafin zane .
3. Danna kan Ƙarƙashin Ƙarƙashin ƙasa a kusurwar dama na kusurwar kwamiti na Chart Styles don nuna duk hanyoyin da aka samo.
4. Zaɓi Style 39.

06 of 07

Zaɓin Tsarin Shafi

Domin taimako tare da waɗannan umarnin, duba samfurin misali a sama.

A yayin da ka danna kan tashoshi, ana amfani da shafuka uku - Zane, Layout, da Tsarin shafukan zuwa rubutun karkashin rubutun kayan aikin Chart .

Tutorial Steps

1. Danna kan chart baya.
2. Danna kan Shafin shafin.
3. Danna kan Ƙarƙashin Ƙarƙashin ƙasa a kusurwar dama na kusurwar kwamiti na Chart Styles don nuna duk hanyoyin da aka samo.
4. Zabi Ƙananan Ɗawuwar - Haɗin 3.

07 of 07

Ƙara wani suna zuwa Shafin Shafin

Domin taimako tare da waɗannan umarnin, duba samfurin misali a sama.

A yayin da ka danna kan tashoshi, ana amfani da shafuka uku - Zane, Layout, da Tsarin shafukan zuwa rubutun karkashin rubutun kayan aikin Chart .

Tutorial Steps

1. Danna kan Layout tab.
   
2. Danna maɓallin Chart a ƙarƙashin ɓangaren Labels .
   
3. Zaži zaɓi na uku - Shafi na sama .
   
4. Rubuta a cikin taken "Kayan Kayan Kayan Kuki na Kukis" akan layi biyu.

A wannan batu, sakonku ya kamata ya dace da zane-zane da aka nuna a farkon mataki na wannan koyawa.