Microsoft Excel Tutorial rau Dummies

Microsoft Excel Tutorial rau Dummies

Excel Tutorial rau Dummies yuav tso cai rau koj nkag siab yooj yim thiab paub cov txuj ci tseem ceeb ntawm kev ua haujlwm hauv Excel, yog li koj tuaj yeem ntseeg siab mus rau ntau cov ncauj lus nyuaj. Cov lus qhia yuav qhia koj siv Excel interface, siv cov qauv thiab cov haujlwm los daws ntau yam teeb meem, tsim cov duab kos thiab kab kos, ua haujlwm nrog cov lus pivot thiab ntau ntxiv.

Cov lus qhia tau tsim tshwj xeeb rau cov neeg siv Excel tshiab, ntau dua rau "ua tiav dummies". Cov ntaub ntawv yog muab nyob rau hauv cov theem, pib nrog lub hauv paus heev. Los ntawm ntu mus rau ntu ntawm cov lus qhia, ntau thiab ntau nthuav thiab nthuav ntau yam muaj. Tom qab ua tiav tag nrho cov chav kawm, koj yuav ntseeg siab siv koj txoj kev paub hauv kev xyaum thiab kawm paub ua haujlwm nrog Excel cov cuab yeej uas yuav daws tau 80% ntawm tag nrho koj cov dej num. Thiab qhov tseem ceeb tshaj plaws:

  • Koj yuav tsis nco qab lo lus nug: "Yuav ua li cas ua haujlwm hauv Excel?"
  • Tam sim no tsis muaj leej twg yuav twv yuav raug hu koj "teapot".
  • Tsis tas yuav yuav cov lus qhia tsis muaj txiaj ntsig rau cov pib tshiab, uas tom qab ntawd yuav sib sau cov plua plav ntawm lub txee rau xyoo. Yuav tsuas yog cov ntaub ntawv tsim nyog thiab muaj txiaj ntsig!
  • Ntawm peb lub xaib koj yuav pom ntau yam kev kawm sib txawv, cov lus qhia thiab phau ntawv qhia ua haujlwm hauv Microsoft Excel thiab tsis yog xwb. Thiab tag nrho cov no nyob rau hauv ib qho chaw!

Tshooj 1: Excel Basics

  1. Taw qhia rau Excel
    • Microsoft Excel interface
    • Ribbon hauv Microsoft Excel
    • Backstage saib hauv Excel
    • Quick Access Toolbar thiab Phau Ntawv Saib
  2. Tsim thiab qhib phau ntawv ua haujlwm
    • Tsim thiab qhib Excel phau ntawv ua haujlwm
    • Compatibility hom hauv Excel
  3. Txuag phau ntawv thiab sib qhia
    • Txuag thiab AutoRecover Workbooks hauv Excel
    • Exporting Excel Phau Ntawv Ua Haujlwm
    • Sib koom Excel Workbooks
  4. Cell Basics
    • Cell hauv Excel - cov ntsiab lus yooj yim
    • Cell cov ntsiab lus hauv Excel
    • Luam, txav thiab tshem tawm cov hlwb hauv Excel
    • Autocomplete cells hauv Excel
    • Nrhiav thiab Hloov hauv Excel
  5. Hloov kab, kab thiab kab
    • Hloov kab dav thiab kab qhov siab hauv Excel
    • Ntxig thiab tshem tawm kab thiab kab hauv Excel
    • Txav thiab zais kab thiab kab hauv Excel
    • Qhwv cov ntawv thiab sib koom ua ke hauv Excel
  6. Cell Formatting
    • Kev teeb tsa font hauv Excel
    • Aligning cov ntawv hauv Excel hlwb
    • Ciam teb, shading thiab cell styles hauv Excel
    • Tus lej formatting hauv Excel
  7. Excel Sheet Basics
    • Rename, ntxig thiab rho tawm ib daim ntawv hauv Excel
    • Luam, txav thiab hloov xim ntawm daim ntawv ua haujlwm hauv Excel
    • Kev faib cov nplooj ntawv hauv Excel
  8. Nplooj ntawv layout
    • Formatting margins thiab nplooj orientation hauv Excel
    • Ntxig nplooj ntawv so, luam cov headers thiab footers hauv Excel
  9. Phau ntawv luam tawm
    • Sau vaj huam sib luag hauv Microsoft Excel
    • Teem thaj chaw luam tawm hauv Excel
    • Teeb cov npoo thiab nplai thaum luam ntawv hauv Excel

Nqe 2: Cov qauv thiab cov haujlwm

  1. Cov qauv yooj yim
    • Cov neeg ua lej lej thiab cov ntaub ntawv ntawm tes hauv Excel cov qauv
    • Tsim cov qauv yooj yim hauv Microsoft Excel
    • Kho cov qauv hauv Excel
  2. Cov qauv tsis yooj yim
    • Taw qhia rau cov qauv complex hauv Excel
    • Tsim cov qauv complex hauv Microsoft Excel
  3. Cov txheeb ze thiab kiag qhov txuas
    • Cov txheeb ze txuas hauv Excel
    • Cov ntaub ntawv tsis raug hauv Excel
    • Txuas mus rau lwm nplooj ntawv hauv Excel
  4. Formulas thiab Functions
    • Taw qhia rau Functions hauv Excel
    • Inserting Function hauv Excel
    • Function Library hauv Excel
    • Function Wizard hauv Excel

Tshooj 3: Ua haujlwm nrog cov ntaub ntawv

  1. Worksheet Appearance Control
    • Cov cheeb tsam khov hauv Microsoft Excel
    • Sib faib cov nplooj ntawv thiab saib Excel phau ntawv ua haujlwm hauv qhov rais sib txawv
  2. Xaiv cov ntaub ntawv hauv Excel
    • Kev txheeb xyuas hauv Excel - cov ntaub ntawv yooj yim
    • Customized hauv Excel
    • Xaiv cov qib hauv Excel
  3. Lim cov ntaub ntawv hauv Excel
    • Lim hauv Excel - Basics
    • Advanced lim hauv Excel
  4. Ua hauj lwm nrog pab pawg thiab debriefing
    • Pawg thiab Subtotals hauv Excel
  5. Tables hauv Excel
    • Tsim, hloov kho thiab tshem tawm cov ntxhuav hauv Excel
  6. Kab kos thiab Sparklines
    • Cov kab ntawv hauv Excel - Basics
    • Layout, Style, thiab lwm yam kev xaiv kab kos
    • Yuav ua li cas ua haujlwm nrog sparklines hauv Excel

Tshooj 4: Advanced nta ntawm Excel

  1. Ua hauj lwm nrog cov ntawv sau thiab taug qab cov kev hloov pauv
    • Taug qab kev hloov kho hauv Excel
    • Tshawb xyuas cov kev hloov kho hauv Excel
    • Cell lus hauv Excel
  2. Ua kom tiav thiab tiv thaiv cov ntawv ua haujlwm
    • Kaw thiab tiv thaiv phau ntawv ua haujlwm hauv Excel
  3. Kev Ntsuas Ntawm Tus Qauv
    • Conditional Formatting hauv Excel
  4. Pivot tables thiab cov ntaub ntawv tsom xam
    • Taw qhia rau PivotTables hauv Excel
    • Cov ntaub ntawv Pivot, Lim, Slicers, thiab PivotCharts
    • Yuav ua li cas yog tsom xam hauv Excel

Kauj Ruam 5: Advanced Formulas hauv Excel

  1. Peb daws cov teeb meem uas siv cov logical functions
    • Yuav ua li cas teeb tsa ib qho yooj yim boolean mob hauv Excel
    • Siv Excel Boolean Functions txhawm rau txheeb xyuas cov xwm txheej nyuaj
    • IF ua haujlwm hauv Excel nrog piv txwv yooj yim
  2. Kev suav thiab suav nrog hauv Excel
    • Suav cov cell hauv Excel siv COUNTIF thiab COUNTIF ua haujlwm
    • Cov txiaj ntsig hauv Excel siv cov haujlwm SUM thiab SUMIF
    • Yuav ua li cas xam tag nrho cov cumulative hauv Excel
    • Muab xam qhov hnyav nruab nrab siv SUMPRODUCT
  3. Ua haujlwm nrog cov hnub thiab sijhawm hauv Excel
    • Hnub thiab sijhawm hauv Excel - cov ntsiab lus yooj yim
    • Nkag mus thiab formatting hnub thiab sijhawm hauv Excel
    • Muaj nuj nqi kom rho tawm ntau yam tsis muaj hnub thiab sijhawm hauv Excel
    • Muaj nuj nqi los tsim thiab tso saib hnub thiab sijhawm hauv Excel
    • Excel ua haujlwm rau suav hnub thiab sijhawm
  4. Nrhiav cov ntaub ntawv
    • VLOOKUP muaj nuj nqi hauv Excel nrog cov piv txwv yooj yim
    • SAIB muaj nuj nqi hauv Excel nrog piv txwv yooj yim
    • INDEX thiab MATCH ua haujlwm hauv Excel nrog cov piv txwv yooj yim
  5. Zoo kom paub
    • Excel Statistical Functions Koj Yuav Tsum Paub
    • Excel lej ua haujlwm koj yuav tsum paub
    • Excel cov ntawv ua haujlwm hauv cov piv txwv
    • Txheej txheem cej luam ntawm qhov yuam kev uas tshwm sim hauv Excel cov qauv
  6. Ua haujlwm nrog cov npe hauv Excel
    • Taw qhia rau lub xov tooj ntawm tes thiab ntau lub npe hauv Excel
    • Yuav ua li cas sau npe lub xov tooj ntawm tes lossis ntau yam hauv Excel
    • 5 Cov Cai thiab Cov Lus Qhia Tseem Ceeb rau Tsim Cell thiab Ntau Lub Npe hauv Excel
    • Lub Npe Tus Thawj Tswj hauv Excel - Cov cuab yeej thiab cov yam ntxwv
    • Yuav sau npe li cas hauv Excel?
  7. Ua haujlwm nrog arrays hauv Excel
    • Taw qhia rau array qauv hauv Excel
    • Multicell array qauv hauv Excel
    • Ib leeg cell array qauv hauv Excel
    • Arrays ntawm qhov tsis tu ncua hauv Excel
    • Kho cov qauv array hauv Excel
    • Siv cov qauv array hauv Excel
    • Txoj hauv kev los kho cov qauv array hauv Excel

Tshooj 6: Xaiv tau

  1. Interface customization
    • Yuav ua li cas kho cov Ribbon hauv Excel 2013
    • Coj mus rhaub hom ntawm Ribbon hauv Excel 2013
    • Txuas cov qauv hauv Microsoft Excel

Xav paub ntau ntxiv txog Excel? Tshwj xeeb tshaj yog rau koj, peb tau npaj ob qho kev qhia yooj yim thiab muaj txiaj ntsig: 300 Excel piv txwv thiab 30 Excel ua haujlwm hauv 30 hnub.

Sau ntawv cia Ncua