Fom na Excel don tsara Sabuntawa na Zamani ta Ranar Mako

Excel - ƙirƙirar Hootsuite ko Agorapulse Social Media Import don Twitter

Ofaya daga cikin abokan cinikin da muke aiki tare yana da daidaito na zamani ga kasuwancin su. Saboda wannan, muna son tsara abubuwan sabunta kafofin watsa labarun da wuri kafin lokaci don kada su damu da buga waɗannan takamaiman ranakun da lokutan.

Yawancin dandamali na watsa labarun kafofin watsa labarun suna ba da damar ɗora hannu mai yawa don tsara jadawalin kalandar kafofin sada zumunta. Tun Agorapulse shine mai daukar nauyin Martech Zone, Zan bi ka cikin tsarin su. A matsayin abin dubawa, suma suna ba da ɗan sassauci yayin loda fayil ɗinku na waƙa (CSV) fayil saboda za ku iya zahiri iya tsara ginshiƙan fayil ɗinku maimakon samun su a cikin lambobin wahala.

Lokacin da muke gina fayil ɗin CSV, ba za mu so kawai mu shafa tweet kwanaki 7 a mako a daidai lokaci ɗaya ba. Muna son saita CSV zuwa takamaiman ranakun mako da wasu lokutan bazuwar kowace safiya. A wannan misalin, zan cika falle tare da sabunta kafofin watsa labarun na safiyar Litinin, Laraba, da Juma'a.

Ka'idojin Excel don Lissafin Ranar Mako

Tabbatar farawa tare da Maƙunsar Bayani, ba fayil ɗin CSV ba, tunda za mu yi amfani da shi Ka'idojin Excel sannan a fitar da fayil ɗin zuwa tsarin CSV. Ginshiƙan na masu sauki ne: Rana, Text, Da kuma URL. A cikin sel A2, dabarata ita ce nemo Litinin ta farko bayan yau. Zan kuma saita lokacin zuwa 8 na safe.

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

Wannan dabara ta tsallake zuwa mako mai zuwa sannan ta samo Litinin a cikin mako. A cikin sel A3, kawai ina buƙatar ƙara kwana 2 zuwa Kwanan cikin A2 don samun kwanan wata Laraba:

=A2+2

Yanzu, a cikin sel A4, zan ƙara kwana 4 don in sami kwanan wata Juma'a:

=A2+4

Ba mu gama ba tukuna. A cikin Excel, zamu iya jan jerin ƙwayoyin atomatik ta atomatik don ƙididdigar ƙididdiga ta atomatik a cikin layuka na gaba. Layinmu na 3 na gaba masu zuwa kawai zasu ƙara sati guda zuwa ga filayen da muka lissafa a sama. A5, A6, A7, A8, A9, da A10 sune bi da bi:

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

Yanzu, zaku iya jan tsarin kawai don ɗaukakawa da yawa kamar yadda kuke son shigowa.

Mafi kyawun tsarin aiki na mako

Random Times a cikin Excel

Yanzu da yake mun sami dukkan kwanakinmu, watakila ba za mu so bugawa a daidai lokacin ba. Don haka, zan saka shafi kusa da shafi A sannan kuma a cikin shafi na B, zan ƙara adadin bazuwar gida da minti zuwa lokaci a cikin shafi na A, amma ba zan wuce tsakar rana ba:

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

Yanzu kawai jawo dabara a ƙasa daga B2:

Excel ƙara lokaci

Can za mu tafi! Yanzu mun sami shafi na Litinin, Laraba, da Juma'a tare da bazuwar lokuta tsakanin 8 na safe zuwa tsakar rana. Tabbatar adana Maƙunsar Fayil ɗinka na Excel (AS Excel) a yanzu. Muna iya so mu dawo wannan takaddun kowane kwata ko kowace shekara yayin da muke tsara abubuwan sabuntawa na gaba.

Kwafin Darajoji a cikin Excel

Select Shirya> Kwafa daga menu na Excel ka bude sabon takardar aiki na Excel - wannan zai zama takardar aiki da muke fitarwa zuwa CSV. Kar a manna shafi tukuna, kodayake. Idan kayi haka, za a liƙa maɓallan ba ainihin ƙimomin ba. A cikin sabon takardar aiki, Zaɓi Shirya> Manna Musamman:

Excel kwafi liƙa menu na musamman

Wannan yana ba da taga magana inda zaka iya zaɓar ƙimomi:

Excel kwafi manna ƙimomi na musamman

Shin ta liƙa lamba tare da adadi? Babu damuwa - kawai kuna tsara tsarin azaman kwanan wata da lokaci.

mafi kyawun tsarin tsarin kwanan wata

Kuma yanzu kun sami bayanan da kuke buƙata! Yanzu zaku iya cike abubuwan sabuntawar zamantakewar har ma da ƙara hanyoyin haɗi. Kewaya zuwa Fayil> Ajiye Kamar yadda kuma zaži Sepididdigar Keɓaɓɓiyar wakafi (.csv) kamar yadda ka file Format. Wannan zai zama girma upload fayil ɗin da zaku iya shigo da su cikin tsarin bugawa na kafofin watsa labarun.

girma upload csv

Idan kana amfani Agorapulse, yanzu zaku iya amfani da fasalin Girman Bulk ɗin su don lodawa da tsara abubuwan sabuntawar zamantakewar ku

Yadda ake girka Updaukaka Sabunta Jama'a a Agorapulse

Bayyanawa: Ni am Agorapulse Ambasada.

daya comment

  1. 1

Me kuke tunani?

Wannan shafin yana amfani da Akismet don rage spam. Koyi yadda aka sarrafa bayanan bayaninka.