A bayyane yake cewa ilimin artificial Yana jujjuya duniyarmu gaba ɗaya, musamman duk abin da ke da alaƙa da fasaha da na'urorin dijital. Gaskiya ne cewa an fara amfani da basirar wucin gadi tuntuni, tun daga 1956, amma har zuwa lokacin da ba a daɗe da saninsa ba ko kuma, aƙalla, ba mu san yuwuwar sa ba kamar yadda muke a yanzu. Wannan shi ne yafi saboda bayyanar Taɗi GPT, kayan aiki ne mai cike da cece-kuce wanda ya kashe duk wata sanarwa game da hankali na wucin gadi daidai saboda sa. m damar Kuma shine mafi karfin hankali har zuwa yau.
Wannan hankali yana iya yi dubunnan ayyuka, bincike da sarrafa su cikin ƴan daƙiƙa kaɗan, amfani da wannan a hadaddun tsarin algorithm, don ba da amsa mai tasiri ga a zahiri duk abin da muka tambaya. Don amfani da wannan kayan aiki, a cikin wannan labarin za mu yi magana game da yadda za ku iya ƙirƙiri darussan Excel ta amfani da ChatGPTWato, ko da ba ku da babban ci gaba a cikin Excel, kuna iya amfani da dabaru masu rikitarwa ta amfani da hankali na wucin gadi. Idan kuna sha'awar wannan batu, ku kasance tare da mu don koyo mataki-mataki kuma ku sami mafi kyawun maƙunsar bayanan ku.
Yadda ChatGPT ke aiki
ChatGPT hadadden tsarin leken asiri ne wanda ke da hankali matakin 4, wato, matsakaicin da aka samu ya zuwa yanzu. Ayyukansa ga jama'a abu ne mai sauqi qwarai, za mu yi kawai yi a cikin taɗi tambayoyin da muke son warwarewa, ko kuma rubuta sigogin da ya kamata ku bi domin ku sami cikakkiyar amsa. Duk da haka, aikin cikin gida na AI wani abu ne mai rikitarwa wanda 'yan kaɗan zasu iya fahimta sosai.
Wannan hankali yana aiki ta amfani da babban rumbun adana bayanai wanda ke tsarawa daban-daban tsari don sauƙaƙe na gaba la'anta lokacin da ake buƙatar aiki. Lokacin amfani da hira, hankali yana amfani da jerin hadaddun algorithms da ƙirar lissafi para aiwatar da dukkan bayanai dangane da batun da ya taso kuma zai iya samar da amsa mai dacewa. Bugu da ƙari kuma, wannan tsarin yana da wani ci gaba da tsokaci da koyo, wato, ana gyara shi kamar yadda ake amfani da shi ta yadda zai zama na'ura mafi inganci kowane lokaci, ta amfani da feedback daga chat zuwa rage kurakurai da samun ingantattun amsoshi.
Yadda ake amfani da ChatGPT don ƙirƙirar dabarun Excel
Da zarar mun san yadda ake amfani da ChatGPT don warware shakkunmu, za mu mai da hankali kan yadda ake samun mafi kyawun sa don ƙirƙirar dabarun aiki a cikin maƙunsar rubutu na Excel. Daya daga cikin fa'idodin wannan AI idan aka kwatanta da na baya shine, baya ga ba ku amsa, yana ba ku bayani don sauƙaƙe aikinku kuma, ko da ba ku fahimce shi ba, kuna iya tambayarsa ya fayyace shi. daki-daki. Wato, ba za ku sami matsala wajen fahimtarsa ba, ChatGPT za ta kasance kamar malami wanda za ku iya neman bayani akan kowane batu.
Amfani da tsarin aiki
Akwai hanyoyi da yawa don ƙirƙirar dabarun Excel daga ChatGPT. Daya daga cikinsu ya kunshi tambayi tsarin aiki kai tsaye abin da kuke so ku yi. Misali, idan kuna so ninka ginshiƙai ɗaya ko fiye a cikin maƙunsar bayanan ku, dole ne ku rubuta a cikin taɗi: Menene dabara don ninka ginshiƙai a cikin Excel? Ganin wannan, AI zai samar da dabarar kuma ya ba ku bayani tare da misalai don haka za ku iya amfani da shi kai tsaye da sauƙi. Wani misali zai kasance yana tambayar ku tsarin don samun matsakaita na duk ƙimar jere da/ko ginshiƙi yana faɗin Yadda za a lissafta matsakaicin ƙimar a cikin shafi a cikin Excel? Kamar a cikin misalin da ya gabata, ChatGPT zai ba ku duk kayan aikin da kuke buƙata don cimma wannan.
Amfani da tsarin maƙunsar bayanai
Wata hanyar da zaku iya amfani da ita don taimaka muku da hankali na wucin gadi a cikin ayyukan ku na Excel shine bayyana tsarin maƙunsar ku kuma nemi aikin Me kuke so kuyi don ChatGPT rubuta daidai tsarin da dole ne ka shigar don samun shi. Wannan shari'ar ya fi sauƙi tunda mu kawai za ku yi kwafa da liƙa tsarinDuk da haka, wani lokacin yana da wuya a kwatanta dalla-dalla da layuka da ginshiƙan da kuke son yin aiki da su, musamman idan babban maƙunsar rubutu ne.
Misali, a ce kuna da ƙimar lambobi a duk layuka daga 2 zuwa 100, kuma kuna so. lissafta ma'anar duk waɗannan dabi'u a cikin cell A1. Dole ne ku rubuta a cikin hira "Ina da dabi'u a cikin layuka 2 zuwa 100 kuma ina so in san dabarar don ƙididdige matsakaicin duk lambobi a cikin tantanin halitta A1." Hankalin wucin gadi zai yi sauran, sake gina rubutun kamar takardar Excel kuma yana ba ku tsarin da kuke buƙata, tare da bayani don haka za ku iya koyo da amfani da shi a wasu lokuta. Bugu da ƙari, maɓalli zai bayyana a cikin dabara don kwafa kai tsaye kuma a liƙa shi daga baya a cikin maƙunsar bayanan ku.
Ana kwafin layuka da ginshiƙai
Wannan hanya ta uku da muke gabatar muku don ƙirƙirar ƙirar Excel bazai yi muku aiki a kowane yanayi ba, musamman idan ayyukan suna da rikitarwa, amma zai kasance da amfani sosai a gare mu. masu amfani ga ayyuka inda akwai ƴan layuka ko ginshiƙan da abin ya shafa kuma tsarin na kowa. Wani nau'i ne na haɗuwa tsakanin nau'i biyu na baya, tare da tsarin takarda da tsarin Excel.
A wannan yanayin dole ne ku kwafi layuka da/ko ginshiƙai da abin da kuke so ku yi aiki da kuma manna su a cikin ChatGPT tare da aikin da kake son yi. Wato, maimakon bayyana sel, muna kwafi su kai tsaye don AI ta iya aiki. Misali, muna da ƙima a cikin layuka uku na farko na ginshiƙai biyu na farko kuma muna so mu ninka layuka ta ginshiƙai kuma mu bayyana shi a shafi na C. Za mu kwafa da liƙa sel kuma mu rubuta a cikin hira. "Ina so in ninka layuka ta ginshiƙai kuma in bayyana shi a shafi na C." El ChatGPT zai yi aikin, bayanin dabara da zai baka damar kwafi sakamakon kai tsaye don haka za ku iya sanya shi a cikin maƙunsar ku.