Amathuluzi OkukhangisaI-Social Media & Influencer Marketing

I-Excel: Amafomula Wokuhlela Ukubuyekezwa Kwemidiya Yokuxhumana NgoSuku Lweviki Nezikhathi Ezingahleliwe

Elinye lamakhasimende esisebenza nawo linesizini elingana kahle ebhizinisini lalo. Ngenxa yalokhu, sithanda ukuhlela izibuyekezo zenkundla yezokuxhumana kusenesikhathi.

Iningi lamapulatifomu wokushicilela ezokuxhum ahlinzeka ngamandla okulayisha ngobuningi ukuhlela ikhalenda lakho lezokuxhumana. Kusukela I-Agorapulse ungumlingani we Martech Zone, ngizokuhambisa ngenqubo yabo. Njengokuqaphela, futhi zinikeza ukuguquguquka kancane lapho ulayisha inani lakho elihlukaniswe ngokhefana (CSV) ifayela ngoba ungakwazi ukumepha amakholomu efayela lakho kunokuba abe namakhodi aqinile.

Uma sakha ifayela le-CSV, asifuni ukuvele sishaye i-tweet izinsuku ezingu-7 ngeviki ngesikhathi esifanayo. Sifuna ukusetha i-CSV ezinsukwini ezithile zeviki kanye nezikhathi ezithile ezingahleliwe njalo ekuseni. Kulesi sibonelo, ngizogcwalisa isipredishithi ngezibuyekezo zenkundla yezokuxhumana 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 evikini elilandelayo bese ithola uMsombuluko evikini. Kuseli A3, ngidinga nje ukwengeza izinsuku ezi-2 Kudethi ku-A2 ukuze ngithole idethi yangoLwesithathu:

=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 ungasebenzisa isici sabo Sokulayisha Ngenqwaba ukuze ulayishe futhi uhlele izibuyekezo zakho zokuxhumana nabantu.

Douglas Karr

Douglas Karr i-CMO ye VulaINSIGHTS kanye nomsunguli we Martech Zone. UDouglas usize inqwaba yeziqalo eziphumelelayo ze-MarTech, uye wasiza ekukhuthaleni okungaphezu kuka-$5 bil ekuthengeni nasekutshalweni kwe-Martech, futhi uyaqhubeka nokusiza izinkampani ekusebenziseni nasekuzenzeleni amasu azo okuthengisa nokumaketha. UDouglas uyingcweti yokuguqula idijithali eyaziwa emhlabeni wonke kanye nesikhulumi se-MarTech. UDouglas futhi ungumbhali oshicilelwe wencwadi kaDummie kanye nencwadi yobuholi bebhizinisi.

Izihloko ezihlobene Nalesi

Buyela emuva kunkinobho phezulu
Close

I-Adblock itholiwe

Martech Zone iyakwazi ukukunikeza lokhu okuqukethwe ngaphandle kwenkokhiso ngoba senza imali ngesayithi yethu ngemali engenayo yezikhangiso, izixhumanisi ezingaphansi, noxhaso. Singajabula uma ungasusa i-ad blocker yakho njengoba ubuka isayithi lethu.