{"id":5963,"date":"2024-12-04T07:55:56","date_gmt":"2024-12-04T07:55:56","guid":{"rendered":"https:\/\/howtogeek.blog\/lv\/?p=5963"},"modified":"2024-12-04T07:55:56","modified_gmt":"2024-12-04T07:55:56","slug":"stepbystep-guide-to-creating-a-monthly-spending-tracker-in-google-sheets","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/lv\/stepbystep-guide-to-creating-a-monthly-spending-tracker-in-google-sheets\/","title":{"rendered":"Soli pa solim ce\u013cvedis ikm\u0113ne\u0161a t\u0113ri\u0146u izsekot\u0101ja izveidei Google izkl\u0101jlap\u0101s"},"content":{"rendered":"<p>Ir svar\u012bgi efekt\u012bvi p\u0101rvald\u012bt savas finanses, ta\u010du tas bie\u017ei var \u0161\u0137ist nep\u0101rvarami, \u012bpa\u0161i, ja tiek uzskait\u012bti izdevumi. Par laimi, t\u0101di r\u012bki k\u0101 <strong>Google izkl\u0101jlapas<\/strong> pied\u0101v\u0101 intuit\u012bvu platformu piel\u0101gotu ikm\u0113ne\u0161a izdevumu izsekot\u0101ju izveidei. Lai gan Google izkl\u0101jlapas nodro\u0161ina vair\u0101kas gatavas veidnes, j\u016bsu vajadz\u012bb\u0101m piel\u0101gota izsekot\u0101ja izstr\u0101de ir paveicama un vienk\u0101r\u0161a.<\/p>\n<h2 class=\"wp-block-heading\" id=\"step-1-define-your-expense-tracker-structure\">1.\u00a0darb\u012bba: defin\u0113jiet savu izdevumu izseko\u0161anas strukt\u016bru<\/h2>\n<p>Pirms iedzi\u013cin\u0101ties t\u0113ri\u0146u izsekot\u0101ja izveid\u0113, ir svar\u012bgi apsv\u0113rt komponentus, kurus v\u0113laties iek\u013caut. Iestat\u012b\u0161anas vienk\u0101r\u0161o\u0161ana pal\u012bdz\u0113s lab\u0101k vizualiz\u0113t un izsekot j\u016bsu izdevumus.<\/p>\n<ul class=\"wp-block-list\">\n<li>Piek\u013c\u016bstiet Google izkl\u0101jlapu t\u012bmek\u013ca lapai un p\u0101rliecinieties, ka esat pierakst\u012bjies sav\u0101 Google kont\u0101.<\/li>\n<li>Atlasiet opciju Tuk\u0161a izkl\u0101jlapa, lai s\u0101ktu jaunas izkl\u0101jlapas izveidi.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Jaunas izkl\u0101jlapas izveide\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-768-1.webp\" title=\"Jaunas izkl\u0101jlapas izveide\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Jaunaj\u0101 izkl\u0101jlap\u0101 noklik\u0161\u0137iniet uz pogas \u201c+\u201d apak\u0161\u0113j\u0101 kreisaj\u0101 st\u016br\u012b, lai pievienotu citu lapu. Jums b\u016bs nepiecie\u0161amas divas lapas: pirm\u0101 izdevumu ievad\u012b\u0161anai un otr\u0101 datu apkopo\u0161anai un vizualiz\u0101cijai.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Jaunas lapas pievieno\u0161ana\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-769-1.webp\" title=\"Jaunas lapas pievieno\u0161ana\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Pirmaj\u0101 lap\u0101 izveidojiet piecas kolonnas ar \u0161\u0101d\u0101m galven\u0113m:\n<ul class=\"wp-block-list\">\n<li><strong>Vieta:<\/strong> j\u016bsu pirkumu mazumtirgot\u0101js.<\/li>\n<li><strong>Kategorija:<\/strong> ieg\u0101d\u0101to pre\u010du veids.<\/li>\n<li><strong>Summa:<\/strong> katras preces izmaksas.<\/li>\n<li><strong>Datums:<\/strong> pirkuma datums.<\/li>\n<li><strong>M\u0113nesis:<\/strong> m\u0113nesis, kur\u0101 notika dar\u012bjums.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Izdevumu izsekot\u0101ja kolonnu virsraksti\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-770-1.webp\" title=\"Izdevumu izsekot\u0101ja kolonnu virsraksti\"\/><\/figure>\n<h2 class=\"wp-block-heading\" id=\"step-2-establish-a-category-menu\">2.\u00a0darb\u012bba. Izveidojiet kategoriju izv\u0113lni<\/h2>\n<p>Lai racionaliz\u0113tu datu ievadi, izdevumu izsekot\u0101j\u0101 pie\u0161\u0137iriet saviem dar\u012bjumiem noteiktas kategorijas.<\/p>\n<ul class=\"wp-block-list\">\n<li>Atlasiet kolonnu Kategorija, turot nospiestu <code>Ctrl<\/code>vai <code>CMD<\/code>(atkar\u012bb\u0101 no ier\u012bces), un aug\u0161pus\u0113 noklik\u0161\u0137iniet uz izv\u0113lnes Ievietot.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Ievietot nolai\u017eamo izv\u0113lni\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-771-1.webp\" title=\"Ievietot nolai\u017eamo izv\u0113lni\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>No opcij\u0101m izv\u0113lieties &#8220;Nolai\u017eam\u0101 izv\u0113lne&#8221;.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Nolai\u017eam\u0101s izv\u0113lnes izveide\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-772-1.webp\" title=\"Nolai\u017eam\u0101s izv\u0113lnes izveide\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Tiks atv\u0113rta s\u0101njosla, kur\u0101 var\u0113siet pievienot da\u017e\u0101das kategorijas. Atlasiet &#8220;Pievienot citu vienumu&#8221;, lai iek\u013cautu vair\u0101k kategoriju.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Kategoriju pievieno\u0161ana nolai\u017eamajam izv\u0113lnei\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-773-1.webp\" title=\"Kategoriju pievieno\u0161ana nolai\u017eamajam izv\u0113lnei\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Kategorijas var kod\u0113t ar kr\u0101su, noklik\u0161\u0137inot uz t\u0101m blakus eso\u0161aj\u0101m nolai\u017eamaj\u0101m izv\u0113ln\u0113m. Kad esat pabeidzis, noklik\u0161\u0137iniet uz &#8220;Gatavs&#8221;, lai saglab\u0101tu atlasi.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Notiek nolai\u017eam\u0101s izv\u0113lnes kategoriju pabeig\u0161ana\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-774-1.webp\" title=\"Notiek nolai\u017eam\u0101s izv\u0113lnes kategoriju pabeig\u0161ana\"\/><\/figure>\n<h2 class=\"wp-block-heading\" id=\"step-3-format-your-spending-tracker\">3.\u00a0darb\u012bba. Format\u0113jiet savu t\u0113ri\u0146u izsekot\u0101ju<\/h2>\n<p>Lai nodro\u0161in\u0101tu skaidr\u012bbu un konsekvenci, ir \u013coti svar\u012bgi pareizi format\u0113t ikm\u0113ne\u0161a izdevumu izsekot\u0101ju.<\/p>\n<ul class=\"wp-block-list\">\n<li>Lai redi\u0123\u0113tu sleju \u201cDatums\u201d, atlasiet kolonnas virsrakstu.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Tiek atlas\u012bta datuma kolonna\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-775-1.webp\" title=\"Tiek atlas\u012bta datuma kolonna\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>R\u012bkjosl\u0101 atrodiet opciju \u201cVair\u0101k form\u0101tu\u201d, ko var identific\u0113t ar simbolu \u201c123\u201d.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Format\u0113\u0161anas iesp\u0113jas\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-776-1.webp\" title=\"Format\u0113\u0161anas iesp\u0113jas\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Nolai\u017eamaj\u0101 izv\u0113ln\u0113 izv\u0113lieties &#8220;Datums&#8221; vai dodieties uz izv\u0113lni &#8220;Form\u0101ts&#8221; un atlasiet &#8220;Numurs&#8221;, kam seko &#8220;Datums&#8221;.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Datuma form\u0101ta izv\u0113le\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-777-1.webp\" title=\"Datuma form\u0101ta izv\u0113le\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Lai par\u0101d\u012btu m\u0113nesi no pirkuma datuma, izmantojiet funkciju TEKSTS. Noklik\u0161\u0137iniet uz pirm\u0101s \u0161\u016bnas kolonn\u0101 &#8220;M\u0113nesis&#8221;, ievadiet: <code>=TEXT(cell_reference,\"mmm\")<\/code>, aizst\u0101jot <code>cell_reference<\/code>ar \u0161\u016bnu, kur\u0101 ir datums.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"TEXT funkcija m\u0113ne\u0161a displejam\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-779-1.webp\" title=\"TEXT funkcija m\u0113ne\u0161a displejam\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>P\u0113c citu kolonnu aizpild\u012b\u0161anas noklik\u0161\u0137iniet un velciet aizpild\u012b\u0161anas turi no M\u0113ne\u0161a kolonnas \u0161\u016bnas st\u016bra, lai autom\u0101tiski aizpild\u012btu citas \u0161\u016bnas.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"M\u0113ne\u0161a kolonnas autom\u0101tiska aizpild\u012b\u0161ana\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-29-1.webp\" title=\"M\u0113ne\u0161a kolonnas autom\u0101tiska aizpild\u012b\u0161ana\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Lai format\u0113tu val\u016btu, atlasiet slejas virsrakstu Summa un p\u0113c tam r\u012bkjosl\u0101 noklik\u0161\u0137iniet uz ikonas <code>$<\/code>vai\u00a0\u2014 jums var b\u016bt nepiecie\u0161ama opcija \u201cVair\u0101k form\u0101tu\u201d, ja t\u0101 nav redzama uzreiz.<code>\u20ac<\/code><\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Val\u016btas format\u0113\u0161ana\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-28-1.webp\" title=\"Val\u016btas format\u0113\u0161ana\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Sada\u013c\u0101 \u201cVair\u0101k form\u0101tu\u201d varat izv\u0113l\u0113ties \u201cVal\u016bta\u201d, \u201cNoapa\u013cota val\u016bta\u201d vai \u201cPiel\u0101gota val\u016bta\u201d, pamatojoties uz sav\u0101m pras\u012bb\u0101m.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Val\u016btas opciju izv\u0113le\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-27-1.webp\" title=\"Val\u016btas opciju izv\u0113le\"\/><\/figure>\n<h2 class=\"wp-block-heading\" id=\"step-4-summarize-your-expenses-using-functions\">4. darb\u012bba. Apkopojiet savus izdevumus ar funkcij\u0101m<\/h2>\n<ul class=\"wp-block-list\">\n<li>P\u0113c izdevumu datu ievad\u012b\u0161anas pirmaj\u0101 lap\u0101 p\u0101rejiet uz otro lapu, izmantojot apak\u0161\u0101 eso\u0161\u0101s cilnes.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Lapu mai\u0146a pakalpojum\u0101 Google izkl\u0101jlapas\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-783-1.webp\" title=\"Lapu mai\u0146a pakalpojum\u0101 Google izkl\u0101jlapas\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Apz\u012bm\u0113jiet \u0161\u016bnas B1 l\u012bdz M1 ar katra m\u0113ne\u0161a pirmajiem trim burtiem. Katras kategorijas kopsumma tiks atspogu\u013cota N slej\u0101.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"M\u0113ne\u0161a eti\u0137e\u0161u ievad\u012b\u0161ana\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-784-1.webp\" title=\"M\u0113ne\u0161a eti\u0137e\u0161u ievad\u012b\u0161ana\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Otraj\u0101 A kolonn\u0101 ievadiet izdevumu kategorijas, kas atbilst pirmaj\u0101 izkl\u0101jlap\u0101 nor\u0101d\u012btaj\u0101m.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Izdevumu kategoriju ievad\u012b\u0161ana\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-31.webp\" title=\"Izdevumu kategoriju ievad\u012b\u0161ana\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Zem p\u0113d\u0113j\u0101s kategorijas A slej\u0101 iek\u013caujiet eti\u0137eti \u201cKop\u0101 m\u0113nes\u012b\u201d.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Ievadot m\u0113ne\u0161a kopsummu\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-32.webp\" title=\"Ievadot m\u0113ne\u0161a kopsummu\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Izmantojiet SUMIFS formulu \u0161\u016bn\u0101 B2, lai apkopotu kategorijas: <code>=SUMIFS(Sheet1!$C$2:$C$11, Sheet1!$B$2:$B$11, $A2, Sheet1!$E$2:$E$11, B$1)<\/code>.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Izmantojot SUMIFS formulu\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-33-1.webp\" title=\"Izmantojot SUMIFS formulu\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>P\u0113c formulas ievad\u012b\u0161anas velciet to horizont\u0101li l\u012bdz p\u0113d\u0113jai \u0161\u016bnai blakus M\u0113ne\u0161a kopsummai un p\u0113c tam lejup pa kategorij\u0101m.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Formulas vilk\u0161ana pa \u0161\u016bn\u0101m\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-36-1.webp\" title=\"Formulas vilk\u0161ana pa \u0161\u016bn\u0101m\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Slej\u0101 N2 izmantojiet, <code>=SUM(B2:M2)<\/code>lai apr\u0113\u0137in\u0101tu kop\u0113jo summu katr\u0101 kategorij\u0101, velkot \u0161o formulu uz leju visiem ierakstiem.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Kategoriju kopsummas apr\u0113\u0137in\u0101\u0161ana\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-35-1-1.webp\" title=\"Kategoriju kopsummas apr\u0113\u0137in\u0101\u0161ana\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Rind\u0101 M\u0113ne\u0161a kopsumma apkopojiet visus kategoriju izdevumus, izmantojot <code>=SUM(B2:B10)<\/code>vai atbilsto\u0161o \u0161\u016bnu diapazonu sav\u0101 lap\u0101.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Apr\u0113\u0137inot m\u0113ne\u0161a kopsummu\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-37-1.webp\" title=\"Apr\u0113\u0137inot m\u0113ne\u0161a kopsummu\"\/><\/figure>\n<h2 class=\"wp-block-heading\" id=\"step-5-visualize-expenses-with-charts\">5.\u00a0darb\u012bba: vizualiz\u0113jiet savus izdevumus, izmantojot diagrammas<\/h2>\n<p>Sparklines un sektoru diagrammas pakalpojum\u0101 Google izkl\u0101jlapas var pal\u012bdz\u0113t vizu\u0101li izsekot j\u016bsu izdevumiem.<\/p>\n<ul class=\"wp-block-list\">\n<li>\u0160\u016bn\u0101 O2 ievadiet sparklines formulu: <code>=SPARKLINE(B2:M2)<\/code>.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Sparkline izveide datu vizualiz\u0101cijai\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-38-1.webp\" title=\"Sparkline izveide datu vizualiz\u0101cijai\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Velciet aizpild\u012b\u0161anas turi uz leju, lai to lietotu vis\u0101m kategorij\u0101m.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Pagarinot sparklines uz leju\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-39-1.webp\" title=\"Pagarinot sparklines uz leju\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Lai pievienotu sektoru diagrammu, izv\u0113ln\u0113 noklik\u0161\u0137iniet uz &#8220;Ievietot&#8221; un izv\u0113lieties &#8220;Diagramma&#8221;.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Diagrammas ievieto\u0161ana\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-792-1.webp\" title=\"Diagrammas ievieto\u0161ana\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Diagrammas redaktora nolai\u017eamaj\u0101 izv\u0113ln\u0113 Diagrammas veids atlasiet Sektoru diagramma.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Sektoru diagrammas veida izv\u0113le\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-793-1.webp\" title=\"Sektoru diagrammas veida izv\u0113le\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Lauk\u0101 Datu diapazons nor\u0101diet datu diapazonu, piem\u0113ram: <code>N2:N10<\/code>.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Diagrammas datu diapazona iestat\u012b\u0161ana\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-40.webp\" title=\"Diagrammas datu diapazona iestat\u012b\u0161ana\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Noklik\u0161\u0137iniet uz &#8220;Pievienot iez\u012bmi&#8221;, atlasiet iez\u012bmju datu diapazonu (piem., <code>A2:A10<\/code>) un pabeidziet iestat\u012b\u0161anu.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Iez\u012bmju pievieno\u0161ana sektoru diagrammai\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-41.webp\" title=\"Iez\u012bmju pievieno\u0161ana sektoru diagrammai\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Sektoru diagramma par\u0101d\u012bs j\u016bsu da\u017e\u0101do izdevumu sadal\u012bjumu, uzlabojot j\u016bsu finansi\u0101lo ieskatu.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"P\u0113d\u0113j\u0101 sektoru diagrammas vizualiz\u0101cija\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-43.webp\" title=\"P\u0113d\u0113j\u0101 sektoru diagrammas vizualiz\u0101cija\"\/><\/figure>\n<h2 class=\"wp-block-heading\" id=\"step-6-apply-filters-to-view-categories\">6.\u00a0darb\u012bba: izmantojiet filtrus efekt\u012bvai skat\u012b\u0161anai<\/h2>\n<p>Filtri var uzlabot izsekot\u0101ja vad\u0101m\u012bbu, \u013caujot bez piep\u016bles k\u0101rtot vai sl\u0113pt dar\u012bjumus.<\/p>\n<ul class=\"wp-block-list\">\n<li>Noklik\u0161\u0137iniet uz t\u0101s kolonnas galvenes, kuru v\u0113laties filtr\u0113t.<\/li>\n<li>R\u012bkjosl\u0101 nospiediet pogu Izveidot filtru, ko att\u0113lo apgriezts tr\u012bsst\u016bris.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Filtru izveide Google izkl\u0101jlap\u0101s\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-44-1.webp\" title=\"Filtru izveide Google izkl\u0101jlap\u0101s\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Noklik\u0161\u0137inot uz filtra ikonas blakus kolonnas virsrakstam, tiks par\u0101d\u012btas da\u017e\u0101das opcijas. Izv\u0113lieties k\u0101du no &#8220;Filtr\u0113t p\u0113c v\u0113rt\u012bb\u0101m&#8221;, &#8220;K\u0101rtot no A l\u012bdz Z&#8221; vai papildu k\u0101rto\u0161anas preferences, p\u0113c tam noklik\u0161\u0137iniet uz &#8220;Labi&#8221;, lai lietotu.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Kolonnu k\u0101rto\u0161anas iesp\u0113jas\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-45.webp\" title=\"Kolonnu k\u0101rto\u0161anas iesp\u0113jas\"\/><\/figure>\n<h3 class=\"wp-block-heading\" id=\"important-notes\">Svar\u012bgas piez\u012bmes<\/h3>\n<ul class=\"wp-block-list\">\n<li>J\u016bsu izdevumu izsekot\u0101js tiks autom\u0101tiski atjaunin\u0101ts, tikl\u012bdz tiks pievienoti jauni izdevumi, atspogu\u013cojot izmai\u0146as sektoru diagramm\u0101.<\/li>\n<li>Apsveriet iesp\u0113ju p\u0101rv\u0113rst savus ierakstus tabulas form\u0101t\u0101, lai atvieglotu navig\u0101ciju un izdevumu anal\u012bzi.<\/li>\n<li>Galven\u0101 priek\u0161roc\u012bba, veidojot piel\u0101gotu izdevumu izsekot\u0101ju, nevis izmantojot veidnes, ir elast\u012bba, lai k\u013c\u016bdu gad\u012bjum\u0101 nekav\u0113joties veiktu labojumus.<\/li>\n<li>\u0112rt\u012bbas labad viedt\u0101lrun\u012b varat instal\u0113t lietotni Google izkl\u0101jlapas, lai re\u0123istr\u0113tu izdevumus, atrodoties ce\u013c\u0101.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Ir svar\u012bgi efekt\u012bvi p\u0101rvald\u012bt savas finanses, ta\u010du tas bie\u017ei var \u0161\u0137ist nep\u0101rvarami, \u012bpa\u0161i, ja tiek uzskait\u012bti izdevumi. Par laimi, t\u0101di r\u012bki k\u0101 Google izkl\u0101jlapas pied\u0101v\u0101 intuit\u012bvu platformu piel\u0101gotu ikm\u0113ne\u0161a izdevumu izsekot\u0101ju izveidei. Lai gan Google izkl\u0101jlapas nodro\u0161ina vair\u0101kas gatavas veidnes, j\u016bsu vajadz\u012bb\u0101m piel\u0101gota izsekot\u0101ja izstr\u0101de ir paveicama un vienk\u0101r\u0161a. 1.\u00a0darb\u012bba: defin\u0113jiet savu izdevumu izseko\u0161anas strukt\u016bru [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[21,809],"class_list":["post-5963","post","type-post","status-publish","format-standard","hentry","category-how-to","tag-google","tag-google-sheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/posts\/5963","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/comments?post=5963"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/posts\/5963\/revisions"}],"predecessor-version":[{"id":5964,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/posts\/5963\/revisions\/5964"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/media?parent=5963"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/categories?post=5963"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/tags?post=5963"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}