Hauv txoj kev loj hlob ntawm cov haujlwm loj yog feem ntau tsis txaus lub zog ntawm ib tug neeg ua haujlwm. Txoj hauj lwm no muaj tag nrho cov kws kho mob tshwj xeeb. Lawm, txhua tus ntawm lawv yuav tsum tau nkag mus rau ib daim ntawv uas yog ib qho khoom ua ke ntawm kev sib koom tes. Nyob rau hauv no hais txog, qhov teeb meem ntawm kev muab tib lub sij hawm mus ua ib qho tseem ceeb heev. Excel muaj nws cov cuab yeej pov tseg uas yuav muab tau nws. Wb to taub cov nuances ntawm daim ntawv thov ntawm Excel nyob rau hauv cov kev mob ntawm simultaneous ua hauj lwm ntawm ob peb cov neeg siv nrog ib phau ntawv.
Kev sib koom tes
Excel tsis tsuas yog muab cov ntaub ntawv sib faib, tab sis kuj daws tau lwm cov dej num uas tshwm sim hauv kev sib koom tes nrog ib phau ntawv. Piv txwv, cov cuab yeej cuab yeej tso cai rau koj los saib xyuas cov kev hloov tau los ntawm ntau cov neeg koom nrog, nrog rau kev pom zoo los yog tsis pom zoo. Qhia rau peb paub seb qhov kev zov me nyuam yuav muab tau cov neeg siv li cas nrog rau kev ua haujlwm zoo sib xws.
Sib koom
Tab sis peb yuav pib nrog cov lus nug txog kev muab cov ntaub ntawv qhia tawm li cas. Ua ntej tshaj, kuv yuav tsum hais tias tus txheej txheem rau xa rau hom kev koom tes nrog ib phau ntawv tsis tuaj yeem ua rau ntawm cov neeg rau zaub mov, tab sis tsuas yog hauv lub computer xwb. Yog li, yog cov ntaub ntawv khaws tseg rau tus neeg rau zaub mov, ces, ua ntej ntawm tag nrho, nws yuav tsum tau pauv mus rau hauv koj lub zos hauv zos thiab muaj txhua yam uas tau piav rau hauv qab no yuav tsum tau ua.
- Tom qab phau ntawv tsim, mus rau lub tab "Kev Tshawb Xyuas" thiab nyem rau ntawm lub pob "Mus saib tau phau ntawv"uas yog nyob rau hauv lub cuab yeej thaiv "Hloov".
- Tom qab ntawd, cov ntaub ntawv saib xyuas qhov rai qhib tau qhib. Nws yuav tsum zom cov parameter "Cia ntau tus neeg siv los kho cov phau ntawv tib lub sij hawm". Tom ntej no, nias lub khawm "OK" nyob hauv qab ntawm qhov rais.
- Lub thawv ntawv tshwm tuaj qhib rau koj kom txuag tau cov ntaub ntawv raws li tau hloov. Ndliv lub khawm "OK".
Tom qab cov kauj ruam saum toj no, cov ntaub ntawv sib faib khoom sib txawv thiab hauv cov neeg siv nyiaj sib txawv qhib yuav qhib. Qhov no yog qhia los ntawm qhov tseeb hais tias nyob rau sab nruab nrab ntawm lub qhov rais, tom qab lub npe ntawm phau ntawv, lub npe ntawm cov ntaub ntawv nkag tau tso tawm - "General". Tam sim no cov ntaub ntawv yuav raug xa mus rau tus neeg rau zaub mov dua.
Kev ntsuas qhov chaw
Tsis tas li ntawd, tag nrho cov ntaub ntawv qhib qhov rais, koj tuaj yeem kho qhov chaw rau kev ua haujlwm ib zaug. Qhov no yuav ua tau tam sim ntawd thaum lub hom phiaj sib koom tes muab rau, thiab koj tuaj yeem kho qhov tsis ntev tom qab. Tab sis, qhov tseeb, lawv tuaj yeem raug tswj xyuas los ntawm tus neeg siv khoom loj, leej twg tswj haujlwm tag nrho nrog cov ntaub ntawv.
- Mus rau lub tab "Cov ntsiab lus".
- Ntawm no koj tuaj yeem hais qhia seb yuav khaws cov ntawv hloov, thiab yog tias khaws, lub sij hawm twg (ua ntej, 30 hnub).
Nws kuj qhia tias yuav hloov cov kev hloov li cas: tsuas yog thaum phau ntawv tau txais kev cawmdim (los ntawm kev ua neej) los yog tom qab lub sijhawm teev tseg.
Ib qhov tseem ceeb heev yog qhov khoom. "Rau kev hloov tseem ceeb". Nws qhia tau hais tias qhov kev zov me nyuam yuav tsum coj li cas yog tias ob peb cov neeg siv tib lub sij hawm hloov tib lub xov tooj ntawm tes. Yog lub neej tsis txaus siab, qhov kev thov qhov tsis tu ncua raug teeb tsa, qhov kev nqis tes ua ntawm cov neeg koom nrog koom tes muaj txiaj ntsig. Tab sis koj tuaj yeem xam nrog ib qho mob uas nyob ruaj khov raws li tus uas tau tswj hwm qhov kev hloov ua ntej yuav tau muaj qhov kom zoo dua.
Ntxiv mus, yog tias koj xav tau, koj tuaj yeem tua cov chaw sau ntawv thiab cov ntxaij lim dej tawm ntawm koj tus kheej saib xyuas los ntawm kev tshawb xyuas cov checkboxes.
Tom qab ntawd, tsis txhob hnov qab qhov kev hloov uas tau los ntawm txhaj rau khawm. "OK".
Qhib cov ntaub ntawv
Qhib ib cov ntaub ntawv uas sib koom ua tau muaj qee qhov tshwj xeeb nta.
- Khiav Excel thiab mus rau lub tab "Cov Ntaub Ntawv". Tom ntej no, nias lub khawm "Qhib".
- Qhib cov ntawv qhib qhov rai. Mus rau ntawm cov neeg rau zaub mov directory lossis hard disk ntawm lub PC qhov twg hauv phau ntawv no. Xaiv lub npe thiab nyem rau ntawm lub pob. "Qhib".
- Ib phau ntawv uas tau qhib yuav qhib. Tam sim no, yog tias koj xav tau, peb tuaj yeem hloov lub npe, nyob rau hauv uas peb yuav tau muab tso rau hauv cov ntaub ntawv hloov kev hloov. Mus rau lub tab "Cov Ntaub Ntawv". Tom qab, txav mus rau seem "Kev xaiv".
- Hauv seem "General" muaj ib qho chaw ntawm chaw "Personalization ntawm Microsoft Office". Nov nyob hauv thaj chaw "Lub npe" Koj tuaj yeem hloov lub npe ntawm koj tus account rau lwm tus. Tom qab tag nrho cov chaw ua tiav, nias ntawm lub pob. "OK".
Tam sim no koj tuaj yeem pib ua haujlwm nrog daim ntawv.
Saib cov tswv cuab cov yeeb yam
Kev sib koom tes muab rau kev saib xyuas thiab kev sib koom tes ntawm kev ua ntawm txhua pawg neeg.
- Txhawm rau saib cov haujlwm ua los ntawm ib tus neeg siv thaum nws ua haujlwm hauv phau ntawv, ua tus tab "Kev Tshawb Xyuas" nyem rau ntawm lub pob "Fixes"uas yog nyob rau hauv lub cuab tam pawg "Hloov" ntawm daim kab xev. Hauv daim ntawv qhia tawm, nias ntawm lub pob "Highlight fixes".
- Lub qhov taub qhib lub qhov muag qhib opens. Los ntawm lub neej ua ntej, tom qab phau ntawv tiav dav dav, thaj nrhiav kom tau txais, uas yog qhia los ntawm ib qho cim kos nyob rau hauv pem hauv ntej ntawm cov khoom coj.
Tag nrho cov kev hloov raug kaw tseg, tab sis ntawm qhov kev tshuaj ntsuam los ntawm kev pom tau tias lawv pom tias cov xim cim ntawm cov hlwb nyob rau hauv lawv sab laug ntawm sab laug, tsuas yog txij li lub sij hawm kawg ntawm daim ntawv tau txais kev cawmdim los ntawm ib qho ntawm cov neeg siv. Thiab nqa mus rau hauv tus account lub kho ntawm tag nrho cov neeg siv nyob rau tag nrho ntawm cov ntawv. Cov yeeb yam ntawm txhua tus neeg tuaj koom tau muaj cim txawv xim.
Yog tias koj hla tus cursor ntawm lub cim ntaus cim, ib daim ntawv yuav qhib, qhia tias leej twg thiab thaum twg qhov kev coj ua tau ua tiav.
- Yuav kom hloov cov cai rau kev txhim kho kho, rov qab mus rau qhov chaw nyob ntawm qhov chaw. Hauv teb "Lub sijhawm" Cov kev xaiv nram no muaj rau xaiv lub sijhawm rau saib thaj ua rau thaj chaw:
- tso tawm txij thaum kawg tseg;
- tag nrho cov kev kho nyob rau hauv database;
- cov uas tseem tsis tau tau pom;
- pib los ntawm lub hnub teev tshwj xeeb.
Hauv teb "Tus neeg siv" Koj tuaj yeem xaiv ib tus neeg koom nrog nws cov ntaub ntawv kho kom raug, lossis tso tawm cov yeeb yam ntawm txhua tus neeg siv tsuas yog lawv tus kheej xwb.
Hauv teb "Nyob rau hauv ntau", koj tuaj yeem qhia meej txog ntau yam ntawm daim ntawv, uas yuav coj los rau hauv koj tus account ntawm cov neeg koom tes los tso saib ntawm koj qhov screen.
Tsis tas li ntawd, los ntawm khij lub checkboxes ntawm cov khoom ntawm ib tug neeg, koj tuaj yeem pab cuam lossis tshem tawm thaj khawm ntawm qhov kev tshuaj ntsuam thiab tso cov kev hloov ntawm ib daim ntawv ntxiv. Tom qab tag nrho cov chaw teev, nyem rau ntawm lub pob. "OK".
- Tom qab ntawd, ntawm daim ntawv, cov yeeb yam ntawm cov neeg koom yuav pom tshwm sim rau hauv tus account qhov chaw nkag.
Neeg saib
Tus neeg siv loj muaj lub peev xwm los thov lossis tsis lees paub cov txheej txheem ntawm lwm cov neeg tuaj koom. Qhov no yuav tsum tau ua raws li nram no.
- Nyob hauv tab "Kev Tshawb Xyuas", nyem rau ntawm lub pob "Fixes". Xaiv ib yam khoom "Txais / Txwv Patches".
- Tom ntej no, qhov qhib lub qhov rai qhib opens. Nws yog tsim nyog los ua qhov chaw rau kev xaiv ntawm cov kev hloov uas peb xav pom zoo lossis tsis pom zoo. Kev ua haujlwm hauv lub qhov rai no yog ua raws li tib hom uas peb pom hauv seem dhau los. Tom qab qhov chaw tau ua, nyem rau ntawm lub pob. "OK".
- Qhov thib ob qhov rai qhia tag nrho cov kev kho uas txaus siab rau yav dhau los tsis xaiv. Xaiv ib txoj kev txhim kho nyob rau hauv daim ntawv teev cov kev ua, thiab txhaj qhov khawm lub khawm uas nyob hauv qab ntawm lub qhov rais hauv qab daim ntawv teev npe, koj tuaj yeem txais yam khoom no lossis tawm. Nws tseem muaj cov pawg neeg txais los yog tsis lees paub txog txhua yam kev khiav haujlwm.
Muab neeg siv
Muaj qee zaum thaum tus neeg siv yuav tsum tau muab tshem tawm. Qhov no yuav yog vim muaj qhov tseeb tias nws tawm ntawm qhov kev tsim tawm, thiab yog vim muaj kev tawm tsam, piv txwv, yog tias tus account tau nkag mus tsis yog los yog tus neeg koom tes pib ua haujlwm los ntawm lwm lub tshuab. Nyob rau hauv Excel muaj xws li ib tug tau.
- Mus rau lub tab "Kev Tshawb Xyuas". Hauv kev thaiv "Hloov" nyob rau hauv daim kab xev nyem rau ntawm lub pob "Mus saib tau phau ntawv".
- Cov ntaub ntawv uas twb tau paub txog qhib qhov rais qhib opens. Hauv tab Kho kom raug Nws muaj ib daim ntawv teev tag nrho cov neeg siv ua haujlwm nrog phau ntawv no. Xaiv lub npe ntawm tus neeg koj xav kom tshem, thiab nias rau ntawm lub pob "Rho tawm".
- Tom qab ntawd, qhib lub thawv qhib tawm uas nws tau ceeb toom hais tias yog tias tus neeg koom tes yog tam sim no editing phau ntawv, tag nrho nws cov yeeb yam yuav tsis tau txais kev cawmdim. Yog tias koj muaj kev ntseeg siab rau koj qhov kev txiav txim, ces nyem "OK".
Tus neeg siv yuav muab deleted.
Kev txwv ntawm kev siv phau ntawv no
Hmoov tsis, ua haujlwm ua ke nrog cov ntaub ntawv hauv Excel muaj ntau qhov kev txwv. Nyob rau hauv cov ntaub ntawv dav dav, tsis muaj leej twg ntawm cov neeg siv, nrog rau tus neeg koom tes tseem ceeb, tuaj yeem ua raws li nram no:
- Tsim lossis hloov cov ntawv sau;
- Ua cov rooj;
- Split los sis sib tshuam hlwb;
- Manipulate XML cov ntaub ntawv;
- Tsim cov rooj tshiab;
- Tshem tawm cov ntawv;
- Ua raws cai ua kom haum thiab ntau yam ua.
Raws li koj tau pom, cov kev txwv no muaj ntau heev. Yog tias, piv txwv li, koj tuaj yeem ua ntau yam tsis ua hauj lwm nrog cov ntaub ntawv XML, ces Excel tsis zoo li ua haujlwm txhua thaum tsim cov ntxhuav. Yuav ua li cas yog tias koj xav tsim ib lub rooj tshiab, sib tshuam los sis ua lwm yam los ntawm daim ntawv teev saum toj no? Muaj ib qho kev daws teeb meem, thiab nws yooj yim heev: koj yuav tsum tau muab cov ntaub ntawv sib txuas ib ntus zuj zus, hloov cov kev tsim nyog, thiab ua kom muaj peev xwm ua hauj lwm ua ke dua.
Txiav kev sib koom
Thaum ua haujlwm tiav rau qhov project, lossis, yog tias tsim nyog, hloov cov ntaub ntawv, daim ntawv uas peb tau tham txog hauv tshooj dhau los, koj yuav tsum tau kaw kev sib koom tes.
- Ua ntej tshaj, txhua tus neeg koom yuav tsum khaws cov kev hloov thiab tawm ntawm cov ntaub ntawv. Tsuas yog tus neeg siv lub ntsiab tseem ua haujlwm nrog daim ntawv.
- Yog hais tias koj xav tau kev txuag cov ntawv kaw tom qab tshem txoj kev nkag mus, ces, nyob hauv tab "Kev Tshawb Xyuas", nyem rau ntawm lub pob "Fixes" ntawm daim kab xev. Hauv daim ntawv qhia tawm, xaiv qhov khoom "Highlight fixes ...".
- Lub qhov rai xaiv qhib qhov rai. Chaw nyob ntawm no yuav tsum tau ua raws li nram qab no. Hauv teb "Hauv lub sijhawm" teeb parameter "Tag nrho". Cov npe ntawm cov npe "Tus neeg siv" thiab "Nyob rau hauv ntau" yuav tsum tsis pom. Ib qho kev ua zoo sib xws yuav tsum tau nqa nrog qhov parameter "Highlight thaj ua rau thaj ntxiag". Tab sis rov qab tus parameter "Hloov mus rau lwm daim ntawv"nyob rau ntawm qhov tsis sib xws, ib qho cim kos yuav tsum muab teev cia. Tom qab tag nrho cov saum toj no manipulations tiav, nias ntawm lub pob. "OK".
- Tom qab ntawd, qhov kev zov me nyuam yuav tsim ib daim ntawv tshiab hu ua "Phau ntawv", nyob rau hauv uas tag nrho cov ntaub ntawv ntawm kev kho cov ntaub ntawv no hauv daim ntawv ntawm lub rooj yuav raug ntaus.
- Tam sim no nws tseem tshuav ncaj qha mus lov tes taw. Ua li no, nyob rau hauv tab "Kev Tshawb Xyuas", nias ntawm lub khawm twb paub peb "Mus saib tau phau ntawv".
- Qhov pib sib npaug zos pib qhib. Mus rau lub tab Kho kom raugyog tias qhov rais qhib hauv lwm tab. Txheeb xyuas lub thawv "Cia ntau tus neeg siv los kho cov ntaub ntawv tib lub sijhawm". Txhim kho cov cai hloov ntawm lub pob. "OK".
- Lub thawv diav pauv tawm uas ceeb toom rau koj tias qhov kev ua tiav ntawm qhov kev ua no yuav ua rau nws tsis qhia cov ntaub ntawv. Yog tias koj khov kho hauv qhov kev txiav txim, ces nias lub khawm "Muaj".
Tom qab cov kauj ruam saum toj no, cov ntaub ntawv sib qhia yuav raug muab kaw, thiab lub cav yuav tsum tau muab pov tseg. Cov lus qhia txog cov haujlwm yav dhau los tau tam sim no tau pom hauv ib lub rooj rau ntawm ib daim ntawv. "Phau ntawv", yog tias qhov kev tsim nyog ua rau khaws cia cov ntaub ntawv no tau ua tiav dhau los.
Raws li peb pom, qhov kev pabcuam Excel muab lub peev xwm los pab cov ntaub ntawv sib faib thiab simultaneous ua haujlwm nrog nws. Ntxiv rau, siv cov cuab yeej tshwj xeeb, koj tuaj yeem taug txoj haujlwm ntawm cov tswvcuab ntawm cov neeg ua haujlwm. Cov hom no tseem muaj qee cov kev txwv, uas, tab sis, yuav tau circumvented los ntawm ib ntus xa tawm kev nkag mus thiab ua cov haujlwm tseem ceeb raws li kev khiav hauj lwm hauv kev khiav haujlwm.
