Si chinsinsi kuti ogwiritsa ntchito ambiri a Excel, popanga matebulo pamapepala, choyamba amaganizira za chitonthozo chawo komanso kumasuka kwawo. Umu ndi momwe matebulo okongola, okongola komanso olemetsa okhala ndi "mitu" yovuta amabadwa, omwe, nthawi yomweyo, sangathe kusefedwa kapena kusanjidwa konse, ndipo ndibwino kuti musaganize za lipoti lodziwikiratu ndi tebulo la pivot.
Posakhalitsa, wogwiritsa ntchito tebulo lotere amafika poganiza kuti "sizingakhale zokongola kwambiri, koma zimatha kugwira ntchito" ndikuyamba kufewetsa kapangidwe ka tebulo lake, ndikupangitsa kuti zigwirizane ndi malingaliro apamwamba:
- mutu wosavuta wa mzere umodzi, pomwe gawo lililonse lidzakhala ndi dzina lake lapadera (dzina lamunda)
- mzere umodzi - ntchito imodzi yomalizidwa (mgwirizano, kugulitsa, kutumiza, projekiti, etc.)
- palibe ma cell ophatikizidwa
- popanda zosweka mu mawonekedwe opanda kanthu mizere ndi mizati
Koma ngati mupanga mutu wa mzere umodzi kuchokera pamagawo angapo kapena kugawa ndime imodzi kukhala zingapo, ndizosavuta, ndiye kuti kukonzanso tebulo kumatha kutenga nthawi yambiri (makamaka zazikulu zazikulu). Zikutanthauza zinthu zotsatirazi:
| Of |  | do |  |
Ponena za ma database, tebulo loyenera nthawi zambiri limatchedwa lathyathyathya (lathyathyathya) - ndilolingana ndi matebulo oterewa kuti ndi bwino kupanga malipoti a pivot tables (pivot tables) ndikuchita analytics.
Mutha kusintha tebulo lamitundu iwiri kukhala lathyathyathya pogwiritsa ntchito ma macro osavuta. Tsegulani Visual Basic Editor kudzera pa tabu Wopanga - Visual Basic (Wopanga - Visual Basic Editor) kapena njira yachidule ya kiyibodi alt+F11. Ikani gawo latsopano (Ikani - Module) ndikukopera zolemba za macro apa:
Sub Redesigner() Dim i As Long Dim hc As Integer, hr As Integer Dim ns As Worksheet hr = InputBox("Сколько строк с подписями сверху?") hc = InputBox("Сколько столбцов столбасов в други песни) Zonama i = 1 Khazikitsani inpdata = Kusankha Set ns = Mapepala Ogwirira Ntchito.Onjezani Kwa r = (hr + 1) Ku inpdata.Rows.Count Kwa c = (hc + 1) Ku inpdata.Columns.Count Kwa j = 1 Ku hc ns. Maselo(i, j) = inpdata.Maselo(r, j) Kenako j Kwa k = 1 Mpaka hr ns.Maselo(i, j + k - 1) = inpdata.Maselo(k, c) Kenako k ns.Maselo( i, j + k - 1) = inpdata.Maselo(r, c) i = i + 1 Next c Next r End Sub Mutha kutseka mkonzi wa VBA ndikubwerera ku Excel. Tsopano titha kusankha tebulo loyambirira (lonse, ndi mutu ndi gawo loyamba ndi miyezi) ndikuyendetsa macro Wopanga - Macros (Wopanga - Macros) kapena kukanikiza kuphatikiza alt+F8.
Macro idzayika pepala latsopano m'buku ndikupanga mtundu watsopano, wokonzedwanso wa tebulo losankhidwa pamenepo. Mutha kugwira ntchito ndi tebulo lotere "lokwanira", pogwiritsa ntchito zida zonse za Excel pokonza ndi kusanthula mindandanda yayikulu.
- Kodi macros ndi chiyani, momwe mungayikitsire macro code mu VBA, momwe mungagwiritsire ntchito
- Kupanga Malipoti ndi PivotTables
- Chida chosinthiranso matebulo a XNUMXD kukhala athyathyathya kuchokera pazowonjezera za PLEX