Microsoft lub Excel qhov kev pab cuam yog zoo-deservedly nrov. Nrog nws cov kev pab, koj tuaj yeem tsis tsuas yog tsim cov ntxhuav, tab sis kuj ua daim duab lossis saib xyuas koj cov nyiaj hauv tsev. Nws yog feem ntau tsim nyog los ua piv txwv ntawm Excel cov ntaub ntawv siv cov duab, thiab tom qab ntawd koj yuav tsum ntxig ib yees duab rau hauv daim ntawv nthuav tawm.
Nws yog qhov tsim nyog
- - ib daim duab tsis tsim nyog hauv cov ntaub ntawv hauv computer lossis hauv Is Taws Nem;
- - Ntxig duab add-on ntsia rau hauv lub computer.
Cov Lus Qhia
Kauj ruam 1
Qhib cov ntaub ntawv nthuav dav (Excel ntawv). Txhawm rau tso duab rau hauv ib pawg sib koom ua ke, ntawm MS Excel 2003-2007 toolbar, nyem rau ntawm "Ntxig" tab thiab tom qab ntawd "Duab". Hauv MS Excel 2003, ntxiv rau, xaiv "Los ntawm Cov Ntaub Ntawv". Tshawb cov duab koj xav tau thiab nyem "Ntxig". Hloov kho qhov duab ntxig thiab txav nws yog tsim nyog.
Kauj ruam 2
Ntxig ib feem ntawm daim duab siv txhua tus saib thiab kho ntawv xws li IrfanView lossis Photoshop. Qhib cov yees duab koj xav tau ntxig ib feem ntawm. Xaiv qhov koj xav tau thiab nyem "Luam" rau ntawm toolbar lossis Ctrl + C.
Kauj ruam 3
Tom qab ntawd qhib lub Excel ntawv thiab nias Ctrl + V lossis nyem rau ntawm lub xovtooj ntawm thiab xaiv "Paste". Nyem ntawm daim duab nrog sab xis nas thiab xaiv "Hom Duab". Tom ntej no, nyem rau ntawm "Cov Khoom" thiab muab cov cim kos rau ntawm cov khoom "Txav mus thiab kho cov khoom nrog rau hauv lub hlwb."
Kauj ruam 4
Teem lub yees duab raws li keeb kwm ntawm lub hlwb. Txhawm rau ua qhov no, nias ntawm daim duab thiab xaiv "Hom Duab" thiab tom qab ntawd "Cov Khoom". Kos rau lub thawv tom ntej no "Txav thiab hloov qhov loj nrog cov khoom" lossis "Tsiv mus, tsis txhob xaiv qhov loj"
Kauj ruam 5
Yog tias koj paub yuav siv CorelDraw, tom qab ntawd qhib qhov program. Tsim cov ntaub thaiv tshiab nrog Ctrl + N thiab rov ua qhov loj me. Tom qab ntawd siv Ctrl + Kuv mus import lub yees duab rau cov canvas. Kho kom raug lossis hloov nws yog tias tsim nyog. Qhib cov ntaub ntawv Excel. Nyem rau ntawm qhov khoom (duab) ib zaug - nws yuav tsum tau ntsia. Tuav lub khawm laug nas thiab cab tus ntawv mus rau hauv cov ntaub ntawv. Los ntawm cov ntawv qhia zaub mov uas tshwm, xaiv Luam Ua Li CorelDRAW. Daim duab yuav muab tso rau hauv cov ntawv.
Kauj Ruam 6
Ntxig ib daig duab ntawm Is Taws Nem. Txoj cai-nias ntawm daim duab thiab xaiv "Copy Image Address". Thov nco ntsoov tias qhov chaw nyob yuav tsum xaus rau ntawm daim duab nraaj -.jpg,.png,.
Kauj Ruam 7
Siv cov duab tshwj xeeb txuas rau Cov Duab. Rub tawm lub archive ("InsertPictures Add-in …") thiab rho tawm cov ntaub ntawv los ntawm nws. Qhib lub.xls ntawv, uas yuav thauj khoom Excel daim ntawv. Pom zoo yuav qhib tau macros yog tias tsim nyog.
Kauj ruam 8
Tom qab ntawd, qhib cov ntawv nrog cov npe ntawm daim duab, piv txwv li, file_for_processing.xls. Nias Ctrl + Shift + L yuam sij nyob rau tib lub sijhawm hauv Excel ntawv. Hauv daim foos uas tshwm, xaiv txoj hauv kev mus rau nplaub tshev uas muaj cov duab. Teev tus xov tooj ntawm qhov ntau thiab tsawg koj xav tau thiab xaiv thawj lub xov tooj ntawm nplooj ntawv nrog cov npe ntim. Qhia tus lej kem los ntxig rau daim duab. Nias lub khawm ntsuab. Daim duab yuav tsum ntxiv.
