Yuav ua li cas paub yuav ua li cas ua hauj lwm hauv Excel koj tus kheej: qhov kev qhia, cov tswv yim thiab tawm tswv yim

Txhua tus neeg uas siv lub koos pis tawj rau hauv lawv cov haujlwm txhua hnub, ib txoj kev los sis lwm tus tau ntsib ib daim ntawv teev npe Excel, nrog rau cov txheej txheem ntawm Microsoft Office. Nws muaj nyob rau hauv ib qho version ntawm lub pob. Thiab feem ntau, pib cov kev taw qhia rau qhov kev zov me nyuam, ntau cov neeg siv tau xav paub yuav ua li cas kawm ua hauj lwm hauv Excel koj tus kheej?

Excel yog dab tsi?

Ua ntej, cia peb txhais seb Excel yog dab tsi, thiab daim ntawv thov no yog dab tsi rau. Tej zaum, ntau tus tau hnov tias qhov kev zov me nyuam yog ib lub rooj ntawv xov xwm, tab sis cov ntsiab cai ntawm nws txoj hauj lwm yog fundamentally sib txawv ntawm tib lub rooj uas tau tsim nyob rau hauv Lo Lus.

Yog hais tias lo lus rooj ua dua caij uas qhia txog cov ntawv nyeem thiab graphical ntxiv, ua rau cov nplooj rooj Excel - yog, nyob rau hauv qhov tseeb, ib tug unified zauv tshuab, uas muaj peev xwm sawv ntawm qhov uas ua ib tug ntau yam ntawm suav rau lub hauv paus ntawm txhais hom ntawm cov ntaub ntawv thiab cov qauv, uas yuav tsum tau rau ib tug Los yog lwm qhov kev ua lej los sis kev ua haujlwm algebra.

Yuav ua li cas paub yuav ua li cas ua hauj lwm hauv Excel koj tus kheej thiab tau nws ua tiav?

Raws li tus heroine ntawm cov zaj duab xis "Chaw ua hauj lwm Romance" hais tias, koj tuaj yeem qhia ib lub hawv rau haus luam yeeb. Hauv txoj ntsiab cai, tsis muaj dab tsi uas ua tsis tau. Cia peb sim nkag siab txog cov hauv paus ntsiab lus ntawm kev ua haujlwm ntawm qhov kev thov thiab nyob ntawm kev nkag siab txog nws cov peev xwm.

Cov lus qhia ntawm cov neeg uas nkag siab txog cov ntsiab lus ntawm daim ntawv thov, hais tias koj tuaj yeem, download, download tau qee cov kev qhia rau tus kheej hauv Excel, tiam sis, raws li kev qhia thiab tshwj xeeb tshaj yog cov lus ntawm cov neeg siv cov neeg siv, xws li cov ntaub ntawv raug muab tso rau hauv daim ntawv abstruse, thiab Yuav kom nkag siab qhov nyuaj heev.

Nws zoo nkaus li qhov kev kawm zoo tshaj plaws rau txoj kev kawm yog kawm txog yam tseem ceeb ntawm qhov kev pab cuam, thiab mam li siv lawv, yog li ntawd hais, "txoj kev ua kev tshawb fawb." Tsis tas yuav hais, koj yuav tsum xub xav txog cov ntsiab lus ntawm Microsoft Excel (cov lus qhia ntawm qhov kev qhia no qhia tau tseeb raws li qhov no), kom ua tiav cov duab ntawm cov qauv hauv kev ua haujlwm.

Lub ntsiab tseem ceeb los saib

Qhov tseem ceeb tshaj plaws uas tus neeg siv them nyiaj rau thaum pib ib daim ntawv thov yog ib daim ntawv rau hauv daim ntawv ntawm lub rooj uas cov zauv ntawm cov zauv nyob hauv ntau txoj kev, nyob ntawm seb daim ntawv thov ntawm nws tus kheej. Hauv cov kab lus ua ntej, cov kab raug muab los ntawm cov tsiaj ntawv, thiab cov kab ntawv tau muab qhia los ntawm cov lej thiab cov zauv. Hauv lwm cov ntaub ntawv tawm, tag nrho cov cim yog tshwj xeeb tshaj tawm hauv cov qauv.

Nws yog dab tsi? Tau, tsuas yog yuav tsum tau txiav txim siab tus xovtooj ntawm tus lej rau qhov qhia meej txog qee qhov kev xam ua haujlwm los ntawm hom kev tswj xyuas li cas hauv cov txheej txheem ob sab rau ib qho. Tom qab ntawd nws yuav paub tseeb ua haujlwm nrog lawv.

Ib qho tseem ceeb tivthaiv - cov mis bar - ib tug tshwj xeeb teb, muaj tshuav «f _x» icon. Nws nyob ntawm no hais tias tag nrho cov haujlwm raug teeb tsa. Qhov no, qhov kev ua lej ua rau lawv tus kheej raug qhia tib yam nkaus li raug txais nyob rau hauv kev thoob ntiaj teb (kev sib npaug sib luag "=", sib npaug "*" cais "/" etc.). Trigonometric qhov tseem ceeb kuj sib txawv rau cov kev xaiv tsa thoob ntiaj teb (kev txhaum, cos, tg, thiab lwm yam). Tab sis qhov no yog qhov nyuaj. Nws tsis yooj yim rau kev khiav lag luam nrog kev pabcuam lossis cov qauv ua piv txwv, vim tias qee cov qauv yuav saib xyuas qhov tshwj xeeb (exponential, logarithmic, tensor, matrix, thiab lwm yam).

Tshaj siab, xws li hauv lwm qhov chaw pabcuam, nws muaj lub rooj sibtham loj thiab cov ntawv qhia zaub mov tseem ceeb nrog cov haujlwm tseem ceeb thiab cov nyees khawm kom nkag tau yooj yim.

Hom ntawm cov ntaub ntawv thiab tej yam yooj yim ua hauj lwm nrog lawv

Kev saib xyuas ntawm yuav ua li cas mus ua hauj lwm nyob rau hauv Excel-kev pab cuam, nws yog tsis yooj yim sua yam uas tsis tau to taub txog qhov tseem ceeb ntawm cov ntaub ntawv hom nkag mus rau hauv lub rooj hlwb. Nyuam qhuav nco ntsoov tias tom qab koj sau qee cov ntaub ntawv xov xwm, koj tuaj yeem nias lub khawm nkag, Esc qhov tseem ceeb los sis txav mus rau ntawm qhov xav tau ntawm lwm lub xov tooj - cov ntaub ntawv yuav raug cawm dim. Kev kho ib lub xov tooj yog hu los ntawm ob npaug nias los yog nias lub F2 qhov tseem ceeb, thiab thaum twg cov ntaub ntawv nkag teb tiav lawm, kev txuag ua tiav thaum sau tus yuam sij nias.

Tam sim no ob peb lo lus hais txog dab tsi koj tuaj yeem nkag rau hauv txhua lub cell. Cov ntawv qhia zaub mov raug hu los ntawm txoj cai nias ntawm lub xovtooj ntawm tes. Ntawm sab laug muaj ib kem tshwj xeeb qhia txog hom ntaub ntawv (ntau, naj npawb, sau ntawv, feem pua, hnub tim, thiab lwm yam). Yog tias hom kev xaiv raug xaiv, qhov kev zov me nyuam, hais lus, nws txiav txim siab seb qhov nqi nkag ntawd zoo li cas (piv txwv, yog tias koj nkag rau 01/01/16, hnub tim yuav raug lees paub rau Lub Ib Hlis 1, 2016).

Thaum nkag mus rau tus nab npawb, koj tuaj yeem siv qhov qhia zauv ntawm cov zauv (piv txwv li, ib tus ua cim tso tawm kom pom, txawm tias thaum koj nkag mus ob, qhov kev zov me nyuam tsuas rub tawm cov nqi pom, txawm tias qhov tseeb tsis hloov).

Yog tias koj siv, hais, ib hom ntawv nyeem raws li, txawm tias tus neeg nkag tuaj rau hauv, nws yuav tsum muab tso tawm raws nraim li ntaus rau ntawm cov keyboard, unchanged.

Ntawm no yog qhov tseemceeb: Yog tias koj tsiv mus rau tus cursor mus rau lub xovtooj ntawm xaiv, tus ntoo khaub lig tshwm nyob rau hauv kaum sab xis, rub nws nrog cov laug nas khawm clamped, koj tuaj yeem luam cov ntaub ntawv mus ntxiv rau lub hlwb yam xav tau. Tab sis cov ntaub ntawv yuav hloov. Yog tias peb ua tib tug qauv nrog ib hnub, tus nqi tom ntej yuav raug muab qhia rau Lub Ib Hlis 2, thiab lwm yam. Xws li kev luam ntawv yog qhov tseem ceeb thaum qhia txog tib hom mis rau lwm lub hlwb (qee zaus txawm nrog kev sib tw).

Yog tias peb tham txog cov qauv, peb siv tau ob txoj ncauj lus kom yooj yim rau kev ua haujlwm. Piv txwv, rau qhov sib npaug ntawm lub hlwb A1 thiab B1, uas yuav tsum tau ua nyob rau hauv cell C1, koj yuav tsum muab tus duab plaub rau hauv lub tshav pob ntawm C1 thiab qhia kom paub ua tus qauv "= A1 + B1". Koj tau ua lwm yam los ntawm qhov kev sib luag ntawm kev sib luag "= SUM (A1: B1)" (qhov no yog siv rau qhov loj ntawm cov hlwb, txawm tias koj tuaj yeem siv cov kev ua haujlwm tsis tiav, nrog rau cov lus Askiv ntawm SUM zaum tag).

Excel program: yuav ua hauj lwm nrog kev ua ntawv Excel

Thaum ua hauj lwm nrog cov ntawv txheeb, koj tuaj yeem ua ntau yam: ntxiv cov ntawv txheeb, hloov lawv lub npe, tshem tawm cov tsis tseem ceeb, thiab lwm yam. Tab sis qhov tseem ceeb tshaj plaws yog tias cov hlwb nyob rau cov nplooj ntawv sib txawv tuaj yeem cuam tshuam los ntawm cov qauv (tshwj xeeb tshaj yog thaum cov arrays ntawm cov ntaub ntawv ntawm ntau hom yog nkag).

Yuav ua li cas kom paub yuav ua li cas mus ua hauj lwm nyob rau hauv Excel koj tus kheej nyob rau hauv kev siv ntawm tus ntoo khaub lig-ua tim khawv thiab suav? Ntawm no, tsis yog txhua yam yoojyim. Raws li cov lus tawm los ntawm cov neeg siv ib zaug mas cov kab lus no nthuav tawm, nws yuav nyuaj heev ua qhov no tsis muaj kev pab. Koj yuav tsum tau nyeem tsawg kawg yog qhov kev pabcuam ntawm qhov kev pab cuam nws tus kheej. Txoj kev yooj yim yog sau cov hlwb hauv tib lub mis los ntawm kev xaiv lawv (koj tuaj yeem ua li no rau ntawm ib daim ntawv thiab ntawm cov khoom sib txawv.) Ntxiv dua thiab, yog tias koj nkag mus rau ntau qhov chaw, koj tuaj yeem sau "= SUM", thiab tom qab ntawd ces cia li hloov nrog Ctrl key Tab sis qhov no yog qhov piv txwv ntau tshaj plaws.

Ntxiv nta

Tab sis nyob rau hauv qhov kev pab cuam koj tsis tau tsuas yog tsim cov ntxhuav nrog ntau hom ntaub ntawv. Nyob ntawm lawv lub hauv paus rau ob peb feeb, koj tuaj yeem tsim txhua hom duab thiab kos duab los ntawm qhov chaw xaiv ntau yam ntawm cov hlwb kom tau tsim, los yog qhia kom meej hauv hom kev ceev thaum koj nkag rau hauv cov ntawv qhia tsim nyog.

Tsis tas li ntawd, qhov kev zov me nyuam muaj peev xwm siv cov kev tshwj xeeb ntxiv, cov ntawv sau ua haujlwm raws li Visual Basic. Koj tuaj yeem ntxig cov khoom hauv daim ntawv duab, duab, suab lossis lwm yam khoom. Feem ntau, muaj sijhawm txaus. Thiab ntawm no tsuas yog ib qho me me ntawm txhua qhov kev pabcuam tshwj xeeb no muaj peev xwm ua tau.

Tab sis yuav hais li cas, nws yog txoj cai mus kom ze yog los mus laij lub matrix los daws kom tau ntau yam sib npaug ntawm tej complexity, nrhiav extremes ntawm kev khiav dej num los tsim lub database thiab nyob qib qub lawv nrog lwm yam kev siv xws li Microsoft Access, thiab ntau npaum li cas - cia li tsis muaj npe.

Qhov no

Tam sim no, tej zaum, nws yog twb paub meej tias lo lus nug ntawm yuav ua li cas paub yuav ua li cas nyob rau hauv Excel koj tus kheej tsis yog li ntawd yooj yim mus rau xav. Tau kawg, yog tias koj paub txog cov qauv hauv kev ua haujlwm hauv cov editor, koj yuav tsis muaj peev xwm los qhia meej txog cov kev ua haujlwm nyuaj. Cov neeg tawm tswv yim ua tim khawv hais tias koj tuaj yeem kawm qhov siab kawg rau ib lub lim tiam. Tab sis yog tias koj xav siv ntau cov lus teb, thiab ntau tshaj ntawd, ua hauj lwm nrog cov ntaub ntawv tsim, tsis muaj teeb meem ntau npaum li cas koj xav tau, tsis muaj cov ntawv nyeem tshwj xeeb lossis cov hoob kawm, koj tsuas ua tsis tau. Ntxiv mus, nws yog qhov zoo tshaj plaws uas peb yuav tsum rub tawm txawm peb paub txog algebra thiab geometry los ntawm tsev kawm ntawv chav kawm. Yog tsis muaj qhov no, koj yuav tsis txawm npau suav ntawm kev siv daim ntawv khom nqi.