Formula Form rau Kev Teem Sij Hawm Cov Kev Kho Tshiab los ntawm Hnub Ua Haujlwm ntawm Lub Limtiam

Excel - tsim Hootsuite lossis Agorapulse Social Media Import rau Twitter

Ib qho ntawm cov neeg siv khoom uas peb ua haujlwm nrog muaj lub caij nyoog sib luag rau lawv txoj kev lag luam. Vim tias qhov no, peb nyiam teem sijhawm hloov kho xov xwm hauv zej zog ua ntej kom lawv tsis tas txhawj txog ntaus cov hnub thiab sijhawm.

Feem ntau ntawm kev tshaj xov xwm tshaj tawm kev tshaj tawm hauv lub vev xaib muab cov peev xwm tshaj tawm los npaj sijhawm koj qhov social media daim ntawv qhia hnub. Txij li thaum Agorapulse yog ib tug sponsor ntawm Martech Zone, Kuv yuav nrog koj taug lawv cov txheej txheem. Raws li kev soj ntsuam, lawv kuj muab qee qhov yooj me me thaum tso koj lub comma cais tus nqi (CSV) cov ntaub ntawv vim tias koj tuaj yeem ua daim ntawv qhia txhua ntawm koj cov ntaub ntawv es tsis muaj qhov nyuaj.

Thaum peb tsim cov ntaub ntawv CSV, peb tsis xav cia tsuas yog ib txoj kev tweet 7 hnub hauv ib lub lim tiam nyob rau tib lub sijhawm. Peb xav kom teeb tsa CSV rau cov hnub ua haujlwm txhua hnub thiab qee cov sijhawm tuaj yeem txhua tag kis. Hauv qhov ua piv txwv, Kuv yuav sau cov pob ntawv nrog kev tshaj tawm hauv xov xwm rau yav sawv ntxov hnub Monday, Wednesday, thiab Fridays.

Cov Qauv Excel rau Kev Xam Nyiaj Hnub Nruab Hnub

Nco ntsoov pib nrog Excel Spreadsheet, tsis yog daim ntawv CSV, txij li thaum peb mus siv Cov Qauv Excel thiab mam li export cov ntaub ntawv rau ib hom ntawv CSV. Kuv cov kem yooj yim heev: Hnub, Phau ntawv, Thiab URLCov. Hauv ntawm tes A2, kuv tus qauv yog nrhiav thawj hnub Monday tom qab hnub no. Kuv tseem yuav npaj lub sij hawm 8 teev sawv ntxov.

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

Cov mis no dhia rau lwm lub lim tiam thiab tom qab ntawd pom hnub Monday hauv lub lim tiam. Hauv ntawm tes A3, Kuv tsuas yog xav ntxiv 2 hnub rau Hnub Tim nyob rau hauv A2 kom tau txais hnub rau Wednesday:

=A2+2

Tam sim no, hauv cell A4, Kuv yuav ntxiv 4 hnub kom kuv tau txais hnub rau hnub Friday:

=A2+4

Tag lawm tsis tau tiav. Hauv Excel, peb tuaj yeem cia li rub tawm cov kab ntawm cov qib rau Excel los xam cov qauv qauv hauv cov kab tom qab. Peb 3 lub ntxiv tom ntej no tsuas yog mus ntxiv rau ib lub lim tiam rau peb suav teb saum toj no. A5, A6, A7, A8, A9, thiab A10 yog li:

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

Tam sim no, koj yuav cia li luag tus qauv rau ntau hloov tshiab raws li koj xav import.

daim ntawv qhia hnub ua haujlwm zoo tshaj hnub

Times Random hauv Excel

Tam sim no hais tias peb tau txais tag nrho peb cov hnub tau teem tseg, peb yuav tsis xav tshaj tawm thaum lub sijhawm. Yog li, Kuv yuav nkag mus rau kem ib sab ntawm kem A thiab tom qab ntawd hauv kem B, Kuv yuav ntxiv ib qho lej ntawm tsev thiab feeb rau lub sijhawm nyob hauv kab A, tab sis tsis dhau yav tav su:

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

Tam sim no cia li rub tus qauv ntawm B2:

zoo ntxiv sij hawm

Peb mus! Tam sim no peb tau txais kab ntawv rau hnub Monday, Wednesday, thiab hnub Friday nrog sij hawm random ntawm 8 teev sawv ntxov thiab tav su. Nco ntsoov khaws koj qhov Excel Spreadsheet (AS Excel) tam sim no. Tej zaum peb yuav xav rov qab los rau hauv daim ntawv nthuav dav no txhua lub hlis lossis txhua xyoo thaum peb teem sijhawm hloov tshiab tom ntej.

Luam tawm Qhov Tseem Ceeb hauv Excel

xaiv Kho kom raug> Luam los ntawm koj daim ntawv qhia ua zaub mov Excel thiab qhib daim ntawv ua haujlwm Excel tshiab - qhov no yuav yog cov ntawv ua haujlwm peb xa tawm mus rau CSV Tsis txhob tso rau sab. Yog koj ua, cov qauv no yuav dhau los thiab tsis yog qhov tseeb tiag tiag. Hauv daim ntawv ua haujlwm tshiab, Xaiv Kho kom raug> Paste Tshwj Xeeb:

mus zoo luam luam ntawv ntim cov zaub mov tshwj xeeb

Qhov no muab lub qhov rais sib tham uas koj tuaj yeem xaiv qhov tseem ceeb:

zoo luam daim ntawv muab tshuaj tshwj xeeb qhov tseem ceeb

Nws puas tau lo tus lej nrog tus lej? Tsis muaj kev txhawj xeeb - koj tsuas yog yuav tsum tau sau cov kem ua hnub thiab sijhawm.

mus zoo hom ntawv teev hnub nyoog

Thiab tam sim no koj tau txais cov ntaub ntawv koj xav tau! Tam sim no koj tuaj yeem populate cov kev hloov kho tshiab thiab txawm tias ntxiv kev sib txuas. Nkag mus rau Cov Ntaub Ntawv> Tseg Raws Li thiab xaiv Comma Separated Values ​​(.csv) raws li koj Cov Hom Ntaub NtawvCov. Uas yuav yog tus zaws upload cov ntaub ntawv uas koj tuaj yeem tuaj yeem nkag mus rau hauv koj cov kev tshaj tawm kev tshaj xov xwm.

nqaj upload csv

Yog koj siv Agorapulse, tam sim no koj tuaj yeem siv lawv Bulk Upload feature los upload thiab teem sijhawm koj cov kev hloov kho tshiab

Yuav ua li cas Bulk Upload Kev Tshaj Tawm Txog Kev Lom Zem Tshiab Hauv Agorapulse

Tshaj tawm: Kuv yog ib tug Agorapulse Txwm Yaj Fwm.

ib saib

  1. 1

Yuav ua li cas koj xav hais tias?

Qhov Web site no siv Akismet los txo cov kev pabcuam. Kawm li cas koj cov ntaub ntawv tawm tswv yim tiav.