I-Excel Formula Yokuhlela Ukubuyekezwa Komphakathi ngosuku lweviki

I-Excel - dala i-Hootsuite noma i-Agorapulse Social Media Import ye-Twitter

Elinye lamakhasimende esisebenza nalo linesikhathi sonyaka esifanelekile ebhizinisini labo. Ngenxa yalokhu, sithanda ukuhlela ukubuyekezwa kwemithombo yezokuxhumana kude kakhulu nesikhathi ukuze kungadingeki bakhathazeke ngokushaya lezo zinsuku nezikhathi ezithile.

Iningi lamapulatifomu wokushicilela ezokuxhum ahlinzeka ngamandla okulayisha ngobuningi ukuhlela ikhalenda lakho lezokuxhumana. Kusukela I-Agorapulse ungumxhasi we Martech Zone, Ngizokuhamba ngenqubo yabo. Njengokubheka, baphinde banikele ngokuguquguquka okuncane lapho ulayisha ifayili lakho elihlukaniswe ngokhefana (CSV) ngoba empeleni ungabeka imephu kukholamu lefayela lakho kunokuba ube namakhodi aqinile.

Lapho sakha ifayili le-CSV, asifuni ukumane nje sibambe i-tweet izinsuku eziyi-7 ngeviki ngesikhathi esifanayo. Sifuna ukusetha i-CSV ngezinsuku ezithile zamaviki nakwezinye izikhathi ezingahleliwe njalo ekuseni. Kulesi sibonelo, ngizogcwalisa ispredishithi ngezibuyekezo zokuxhumana nomphakathi ekuseni ngoMsombuluko, ngoLwesithathu nangoLwesihlanu.

Amafomula we-Excel Wokubala Usuku Lweviki

Qiniseka ukuthi uqala ngeSpredishithi se-Excel, hhayi ifayela le-CSV, ngoba sizosebenzisa Amafomula we-Excel bese uthumela ifayela kufomethi ye-CSV. Amakholomu ami alula kakhulu: Usuku, Umbhalo, Futhi I-URL. Esitokisini A2, ifomula lami ukuthola uMsombuluko wokuqala ngemuva kwanamuhla. Ngizobeka nesikhathi kuze kube ngu-8 ekuseni.

=TODAY()+7-WEEKDAY(TODAY()+7-2)+TIME(8,0,0)

Le fomula igxumela esontweni elizayo bese ithola uMsombuluko esontweni. Esitokisini A3, ngidinga nje ukwengeza izinsuku ezi-2 kuDethi ku-A2 ukuthola usuku lwangoLwesithathu:

=A2+2

Manje, esitokisini A4, ngizofaka izinsuku ezi-4 ukuze ngithole usuku lwangoLwesihlanu:

=A2+4

Asikaqedi okwamanje. Ku-Excel, singahudula ngokuzenzakalela uchungechunge lwamaseli we-Excel ukubala ngokuzenzakalela amafomula emigqeni elandelayo. Imigqa yethu emithathu elandelayo izokwengeza isonto ezinkambeni zethu ezibaliwe ngenhla. A3, A5, A6, A7, A8, no-A9 ngokulandelana:

=A2+7
=A3+7
=A4+7
=A5+7
=A6+7
=A7+7

Manje, ungavele uhudule ifomula lezibuyekezo eziningi ongathanda ukuzingenisa.

ukugqama amafomula waphakathi nesonto

Izikhathi Ezingahleliwe ku-Excel

Manje njengoba sesinazo zonke izinsuku zethu ezibekiwe, kungenzeka singafuni ukushicilela ngesikhathi esifanele. Ngakho-ke, ngizofaka ikholomu eceleni kwekholomu A bese kukholamu B, ngizofaka inombolo engahleliwe yendlu nemizuzu nesikhathi kukholamu A, kepha ungadluli emini:

=A2+TIME(RANDBETWEEN(0,3),RANDBETWEEN(0,59),0)

Manje vele uhudule ifomula phansi usuke ku-B2:

yenza kahle isikhathi sokungeza

Lapho siya khona! Manje sesinekholamu yezinsuku zangoMsombuluko, uLwesithathu, nangoLwesihlanu ezinezikhathi ezingahleliwe phakathi kuka-8 ekuseni kuya emini. Qiniseka ukuthi ugcine i-Excel Spreadsheet (AS Excel) yakho manje. Singafuna ukubuyela kulesi sipredishithi ikota ngayinye noma unyaka ngamunye njengoba sihlela izibuyekezo zomphakathi ezilandelayo.

Ikopisha Amanani ku-Excel

Khetha Hlela> Kopisha kusuka kwimenyu yakho ye-Excel bese uvula i-Excel Worksheet entsha - leli kuzoba ishidi lokusebenza esilithumela ku-CSV. Unganamathiseli ikholomu okwamanje. Uma wenza kanjalo, amafomula azonamathiselwa hhayi amanani wangempela. Kwiphepha lokusebenzela elisha, Khetha Hlela> Namathisela Okukhethekile:

excel copy unamathisela imenyu ekhethekile

Lokhu kunikeza iwindi lengxoxo lapho ungakhetha khona amanani:

excel copy unamathisela amanani akhethekile

Ngabe kunamathiselwe inombolo enedesimali? Akunazinkathazo - kufanele nje ufomethe ikholomu njengosuku nesikhathi.

ukugqama amafomethi weseli isikhathi

Futhi manje usunedatha oyidingayo! Manje usungagcwalisa izibuyekezo zomphakathi futhi ungeze izixhumanisi. Zulazulela ku- Ifayela> Gcina Njenge Bese ukhetha Amanani Ahlukaniswe Ngukhefana (.csv) njengakho Ifayela Ifomethi. Lokho kuzoba yi ukulayishwa kwenqwaba fayela ongalingenisa ohlelweni lwakho lokushicilela imidiya yokuxhumana nabantu.

ukulayishwa kwenqwaba csv

Uma usebenzisa I-Agorapulse, manje usungasebenzisa isici sabo sokulayisha ubuningi ukuze ulayishe futhi uhlele izibuyekezo zakho zenhlalo

Ungakufaka Kanjani Ukuvuselelwa Kwezenhlalo ku-Agorapulse

Ukudalulwa: Ngingu-an I-Agorapulse Inxusa.

One comment

  1. 1

UCABANGANI?

Le sayithi isebenzisa i-Akismet ukunciphisa ugaxekile. Funda ukuthi idatha yakho yokuphawula isetshenziswa kanjani.