{"id":5965,"date":"2024-12-04T07:52:30","date_gmt":"2024-12-04T07:52:30","guid":{"rendered":"https:\/\/howtogeek.blog\/cs\/?p=5965"},"modified":"2024-12-04T07:52:30","modified_gmt":"2024-12-04T07:52:30","slug":"stepbystep-guide-to-creating-a-monthly-spending-tracker-in-google-sheets","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/cs\/stepbystep-guide-to-creating-a-monthly-spending-tracker-in-google-sheets\/","title":{"rendered":"Podrobn\u00fd pr\u016fvodce vytvo\u0159en\u00edm m\u011bs\u00ed\u010dn\u00edho sledov\u00e1n\u00ed \u00fatraty v Tabulk\u00e1ch Google"},"content":{"rendered":"<p>Efektivn\u00ed spr\u00e1va financ\u00ed je z\u00e1sadn\u00ed, ale \u010dasto se m\u016f\u017ee zd\u00e1t zdrcuj\u00edc\u00ed, zejm\u00e9na kdy\u017e sledujete sv\u00e9 v\u00fddaje. Na\u0161t\u011bst\u00ed n\u00e1stroje jako <strong>Tabulky Google<\/strong> nab\u00edzej\u00ed intuitivn\u00ed platformu pro vytv\u00e1\u0159en\u00ed p\u0159izp\u016fsoben\u00fdch sledova\u010d\u016f m\u011bs\u00ed\u010dn\u00edch v\u00fddaj\u016f. Zat\u00edmco Tabulky Google poskytuj\u00ed n\u011bkolik hotov\u00fdch \u0161ablon, navrhnout sledova\u010d p\u0159izp\u016fsoben\u00fd va\u0161im pot\u0159eb\u00e1m je dosa\u017eiteln\u00e9 a p\u0159\u00edmo\u010dar\u00e9.<\/p>\n<h2 class=\"wp-block-heading\" id=\"step-1-define-your-expense-tracker-structure\">Krok 1: Definujte svou strukturu sledov\u00e1n\u00ed v\u00fddaj\u016f<\/h2>\n<p>Ne\u017e se pono\u0159\u00edte do tvorby va\u0161eho sledov\u00e1n\u00ed v\u00fddaj\u016f, je d\u016fle\u017eit\u00e9 zv\u00e1\u017eit komponenty, kter\u00e9 byste cht\u011bli zahrnout. Zjednodu\u0161en\u00ed nastaven\u00ed pom\u016f\u017ee l\u00e9pe vizualizovat a sledovat va\u0161e v\u00fddaje.<\/p>\n<ul class=\"wp-block-list\">\n<li>P\u0159ejd\u011bte na webovou str\u00e1nku Tabulek Google a ujist\u011bte se, \u017ee jste p\u0159ihl\u00e1\u0161eni ke sv\u00e9mu \u00fa\u010dtu Google.<\/li>\n<li>Chcete-li zah\u00e1jit novou tabulku, vyberte mo\u017enost \u201ePr\u00e1zdn\u00e1 tabulka\u201c.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Vytvo\u0159en\u00ed nov\u00e9 tabulky\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-768-1.webp\" title=\"Vytvo\u0159en\u00ed nov\u00e9 tabulky\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>V nov\u00e9 tabulce klikn\u011bte na tla\u010d\u00edtko \u201e+\u201c v lev\u00e9m doln\u00edm rohu a p\u0159idejte dal\u0161\u00ed list. Budete pot\u0159ebovat dva listy: prvn\u00ed pro zad\u00e1n\u00ed va\u0161ich v\u00fddaj\u016f a druh\u00fd pro shrnut\u00ed a vizualizaci va\u0161ich dat.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"P\u0159id\u00e1n\u00ed nov\u00e9ho listu\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-769-1.webp\" title=\"P\u0159id\u00e1n\u00ed nov\u00e9ho listu\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>V prvn\u00edm listu vytvo\u0159te p\u011bt sloupc\u016f s n\u00e1sleduj\u00edc\u00edmi z\u00e1hlav\u00edmi:\n<ul class=\"wp-block-list\">\n<li><strong>M\u00edsto:<\/strong> Prodejce va\u0161ich n\u00e1kup\u016f.<\/li>\n<li><strong>Kategorie:<\/strong> Typ zakoupen\u00e9ho zbo\u017e\u00ed.<\/li>\n<li><strong>\u010c\u00e1stka:<\/strong> Cena ka\u017ed\u00e9 polo\u017eky.<\/li>\n<li><strong>Datum:<\/strong> Datum n\u00e1kupu.<\/li>\n<li><strong>M\u011bs\u00edc:<\/strong> M\u011bs\u00edc, ve kter\u00e9m k transakci do\u0161lo.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Z\u00e1hlav\u00ed sloupc\u016f sledov\u00e1n\u00ed v\u00fddaj\u016f\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-770-1.webp\" title=\"Z\u00e1hlav\u00ed sloupc\u016f sledov\u00e1n\u00ed v\u00fddaj\u016f\"\/><\/figure>\n<h2 class=\"wp-block-heading\" id=\"step-2-establish-a-category-menu\">Krok 2: Vytvo\u0159te nab\u00eddku kategori\u00ed<\/h2>\n<p>Chcete-li zjednodu\u0161it zad\u00e1v\u00e1n\u00ed dat, p\u0159i\u0159a\u010fte sv\u00fdm transakc\u00edm v n\u00e1stroji pro sledov\u00e1n\u00ed v\u00fddaj\u016f konkr\u00e9tn\u00ed kategorie.<\/p>\n<ul class=\"wp-block-list\">\n<li>Vyberte sloupec \u201eKategorie\u201c, podr\u017ete tla\u010d\u00edtko <code>Ctrl<\/code>nebo <code>CMD<\/code>(v z\u00e1vislosti na va\u0161em za\u0159\u00edzen\u00ed) a klikn\u011bte na nab\u00eddku Vlo\u017eit v horn\u00ed \u010d\u00e1sti.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Vlo\u017eit rozev\u00edrac\u00ed nab\u00eddku\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-771-1.webp\" title=\"Vlo\u017eit rozev\u00edrac\u00ed nab\u00eddku\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Z mo\u017enost\u00ed vyberte &#8216;Rozbalovac\u00ed&#8217;.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Vytv\u00e1\u0159en\u00ed rozev\u00edrac\u00edho seznamu\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-772-1.webp\" title=\"Vytv\u00e1\u0159en\u00ed rozev\u00edrac\u00edho seznamu\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Otev\u0159e se postrann\u00ed panel, kter\u00fd v\u00e1m umo\u017en\u00ed p\u0159id\u00e1vat r\u016fzn\u00e9 kategorie. Chcete-li p\u0159idat dal\u0161\u00ed kategorie, vyberte mo\u017enost P\u0159idat dal\u0161\u00ed polo\u017eku.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"P\u0159id\u00e1v\u00e1n\u00ed kategori\u00ed do rozbalovac\u00ed nab\u00eddky\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-773-1.webp\" title=\"P\u0159id\u00e1v\u00e1n\u00ed kategori\u00ed do rozbalovac\u00ed nab\u00eddky\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Kategorie m\u016f\u017eete barevn\u011b odli\u0161it kliknut\u00edm na rozbalovac\u00ed nab\u00eddky vedle nich. Po dokon\u010den\u00ed klikn\u011bte na &#8216;Hotovo&#8217; a ulo\u017ete sv\u016fj v\u00fdb\u011br.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Dokon\u010dov\u00e1n\u00ed rozev\u00edrac\u00edch kategori\u00ed\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-774-1.webp\" title=\"Dokon\u010dov\u00e1n\u00ed rozev\u00edrac\u00edch kategori\u00ed\"\/><\/figure>\n<h2 class=\"wp-block-heading\" id=\"step-3-format-your-spending-tracker\">Krok 3: Naform\u00e1tujte si sledov\u00e1n\u00ed v\u00fddaj\u016f<\/h2>\n<p>Pro zaji\u0161t\u011bn\u00ed srozumitelnosti a konzistence je d\u016fle\u017eit\u00e9 spr\u00e1vn\u011b naform\u00e1tovat m\u011bs\u00ed\u010dn\u00ed sledov\u00e1n\u00ed v\u00fddaj\u016f.<\/p>\n<ul class=\"wp-block-list\">\n<li>Chcete-li upravit sloupec Datum, vyberte z\u00e1hlav\u00ed sloupce.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"V\u00fdb\u011br sloupce data\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-775-1.webp\" title=\"V\u00fdb\u011br sloupce data\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Najd\u011bte na panelu n\u00e1stroj\u016f mo\u017enost \u201eDal\u0161\u00ed form\u00e1ty\u201c, kterou lze identifikovat podle symbolu \u201e123\u201c.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Mo\u017enosti form\u00e1tov\u00e1n\u00ed\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-776-1.webp\" title=\"Mo\u017enosti form\u00e1tov\u00e1n\u00ed\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Z rozbalovac\u00ed nab\u00eddky vyberte \u201eDatum\u201c nebo p\u0159ejd\u011bte do nab\u00eddky \u201eForm\u00e1t\u201c a vyberte \u201e\u010c\u00edslo\u201c a pot\u00e9 \u201eDatum\u201c.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"V\u00fdb\u011br form\u00e1tu data\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-777-1.webp\" title=\"V\u00fdb\u011br form\u00e1tu data\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Chcete-li zobrazit m\u011bs\u00edc od data n\u00e1kupu, pou\u017eijte funkci TEXT. Klikn\u011bte na prvn\u00ed bu\u0148ku ve sloupci &#8216;M\u011bs\u00edc&#8217;, zadejte: <code>=TEXT(cell_reference,\"mmm\")<\/code>, nahra\u010fte <code>cell_reference<\/code>bu\u0148kou obsahuj\u00edc\u00ed datum.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Funkce TEXT pro zobrazen\u00ed m\u011bs\u00edce\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-779-1.webp\" title=\"Funkce TEXT pro zobrazen\u00ed m\u011bs\u00edce\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Po vypln\u011bn\u00ed ostatn\u00edch sloupc\u016f klikn\u011bte a p\u0159et\u00e1hn\u011bte \u00fachyt v\u00fdpln\u011b z rohu bu\u0148ky sloupce M\u011bs\u00edc, aby se automaticky vyplnily dal\u0161\u00ed bu\u0148ky.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Automatick\u00e9 vypl\u0148ov\u00e1n\u00ed sloupce m\u011bs\u00edce\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-29-1.webp\" title=\"Automatick\u00e9 vypl\u0148ov\u00e1n\u00ed sloupce m\u011bs\u00edce\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Pro form\u00e1tov\u00e1n\u00ed m\u011bny vyberte z\u00e1hlav\u00ed sloupce \u010c\u00e1stka a pot\u00e9 klikn\u011bte na ikonu <code>$<\/code>nebo <code>\u20ac<\/code>na panelu n\u00e1stroj\u016f \u2013 mo\u017en\u00e1 budete pot\u0159ebovat mo\u017enost \u201eDal\u0161\u00ed form\u00e1ty\u201c, pokud se nezobraz\u00ed okam\u017eit\u011b.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Form\u00e1tov\u00e1n\u00ed m\u011bny\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-28-1.webp\" title=\"Form\u00e1tov\u00e1n\u00ed m\u011bny\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>V \u010d\u00e1sti \u201eDal\u0161\u00ed form\u00e1ty\u201c m\u016f\u017eete podle sv\u00fdch po\u017eadavk\u016f zvolit \u201eM\u011bna\u201c, \u201eZaokrouhlen\u00e1 m\u011bna\u201c nebo \u201eVlastn\u00ed m\u011bna\u201c.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"V\u00fdb\u011br m\u011bnov\u00fdch opc\u00ed\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-27-1.webp\" title=\"V\u00fdb\u011br m\u011bnov\u00fdch opc\u00ed\"\/><\/figure>\n<h2 class=\"wp-block-heading\" id=\"step-4-summarize-your-expenses-using-functions\">Krok 4: Shr\u0148te sv\u00e9 v\u00fddaje pomoc\u00ed funkc\u00ed<\/h2>\n<ul class=\"wp-block-list\">\n<li>Po zad\u00e1n\u00ed \u00fadaj\u016f o v\u00fddaj\u00edch do prvn\u00edho listu se pomoc\u00ed z\u00e1lo\u017eek ve spodn\u00ed \u010d\u00e1sti p\u0159epn\u011bte na druh\u00fd list.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"P\u0159ep\u00edn\u00e1n\u00ed list\u016f v Tabulk\u00e1ch Google\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-783-1.webp\" title=\"P\u0159ep\u00edn\u00e1n\u00ed list\u016f v Tabulk\u00e1ch Google\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Ozna\u010dte bu\u0148ky B1 a\u017e M1 prvn\u00edmi t\u0159emi p\u00edsmeny ka\u017ed\u00e9ho m\u011bs\u00edce. Sou\u010det pro ka\u017edou kategorii se projev\u00ed ve sloupci N.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Zad\u00e1v\u00e1n\u00ed \u0161t\u00edtk\u016f m\u011bs\u00edc\u016f\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-784-1.webp\" title=\"Zad\u00e1v\u00e1n\u00ed \u0161t\u00edtk\u016f m\u011bs\u00edc\u016f\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Do druh\u00e9ho sloupce A zadejte kategorie v\u00fddaj\u016f odpov\u00eddaj\u00edc\u00ed kategori\u00edm v prvn\u00ed tabulce.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Zad\u00e1n\u00ed kategori\u00ed v\u00fddaj\u016f\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-31.webp\" title=\"Zad\u00e1n\u00ed kategori\u00ed v\u00fddaj\u016f\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Pod posledn\u00ed kategori\u00ed ve sloupci A uve\u010fte \u0161t\u00edtek \u201eM\u011bs\u00ed\u010dn\u00ed celkem\u201c.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Zad\u00e1n\u00ed m\u011bs\u00ed\u010dn\u00edho sou\u010dtu\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-32.webp\" title=\"Zad\u00e1n\u00ed m\u011bs\u00ed\u010dn\u00edho sou\u010dtu\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Pou\u017eijte vzorec SUMIFS v bu\u0148ce B2 pro shrnut\u00ed kategori\u00ed: <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=\"Pomoc\u00ed vzorce SUMIFS\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-33-1.webp\" title=\"Pomoc\u00ed vzorce SUMIFS\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Po zad\u00e1n\u00ed vzorce jej p\u0159et\u00e1hn\u011bte vodorovn\u011b k posledn\u00ed bu\u0148ce vedle m\u011bs\u00ed\u010dn\u00edho sou\u010dtu a pot\u00e9 dol\u016f p\u0159es kategorie.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"P\u0159eta\u017een\u00ed vzorce p\u0159es bu\u0148ky\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-36-1.webp\" title=\"P\u0159eta\u017een\u00ed vzorce p\u0159es bu\u0148ky\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Ve sloupci N2 pou\u017eijte <code>=SUM(B2:M2)<\/code>k v\u00fdpo\u010dtu sou\u010dtu za kategorii p\u0159eta\u017een\u00edm tohoto vzorce dol\u016f pro v\u0161echny polo\u017eky.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"V\u00fdpo\u010det sou\u010dt\u016f kategori\u00ed\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-35-1-1.webp\" title=\"V\u00fdpo\u010det sou\u010dt\u016f kategori\u00ed\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>V \u0159\u00e1dku M\u011bs\u00ed\u010dn\u00ed sou\u010det shr\u0148te v\u0161echny v\u00fddaje kategori\u00ed pomoc\u00ed <code>=SUM(B2:B10)<\/code>nebo p\u0159\u00edslu\u0161n\u00e9ho rozsahu bun\u011bk v listu.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"V\u00fdpo\u010det m\u011bs\u00ed\u010dn\u00edho sou\u010dtu\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-37-1.webp\" title=\"V\u00fdpo\u010det m\u011bs\u00ed\u010dn\u00edho sou\u010dtu\"\/><\/figure>\n<h2 class=\"wp-block-heading\" id=\"step-5-visualize-expenses-with-charts\">Krok 5: Vizualizujte sv\u00e9 v\u00fddaje pomoc\u00ed graf\u016f<\/h2>\n<p>Vyu\u017eit\u00ed k\u0159ivek a kol\u00e1\u010dov\u00fdch graf\u016f v Tabulk\u00e1ch Google m\u016f\u017ee pomoci vizu\u00e1ln\u011b sledovat va\u0161e v\u00fddaje.<\/p>\n<ul class=\"wp-block-list\">\n<li>Do bu\u0148ky O2 zadejte vzorec pro k\u0159ivky: <code>=SPARKLINE(B2:M2)<\/code>.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Vytv\u00e1\u0159en\u00ed k\u0159ivek pro vizualizaci dat\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-38-1.webp\" title=\"Vytv\u00e1\u0159en\u00ed k\u0159ivek pro vizualizaci dat\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>P\u0159eta\u017een\u00edm \u00fachytu v\u00fdpln\u011b dol\u016f to pou\u017eijete na v\u0161echny kategorie.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Roz\u0161\u00ed\u0159en\u00ed jisker dol\u016f\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-39-1.webp\" title=\"Roz\u0161\u00ed\u0159en\u00ed jisker dol\u016f\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Chcete-li p\u0159idat kol\u00e1\u010dov\u00fd graf, klikn\u011bte v nab\u00eddce na &#8216;Vlo\u017eit&#8217; a vyberte &#8216;Graf&#8217;.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Vlo\u017een\u00ed grafu\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-792-1.webp\" title=\"Vlo\u017een\u00ed grafu\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>V editoru graf\u016f vyberte z rozbalovac\u00ed nab\u00eddky \u201eTyp grafu\u201c mo\u017enost \u201eKol\u00e1\u010dov\u00fd graf\u201c.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"V\u00fdb\u011br typu kol\u00e1\u010dov\u00e9ho grafu\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-793-1.webp\" title=\"V\u00fdb\u011br typu kol\u00e1\u010dov\u00e9ho grafu\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Zadejte rozsah dat v poli &#8216;Data range&#8217;, p\u0159\u00edklad: <code>N2:N10<\/code>.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Nastaven\u00ed rozsahu dat pro graf\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-40.webp\" title=\"Nastaven\u00ed rozsahu dat pro graf\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Klikn\u011bte na &#8216;P\u0159idat \u0161t\u00edtek&#8217;, vyberte rozsah dat pro \u0161t\u00edtky (nap\u0159. <code>A2:A10<\/code>) a dokon\u010dete nastaven\u00ed.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"P\u0159id\u00e1n\u00ed \u0161t\u00edtk\u016f do v\u00fdse\u010dov\u00e9ho grafu\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-41.webp\" title=\"P\u0159id\u00e1n\u00ed \u0161t\u00edtk\u016f do v\u00fdse\u010dov\u00e9ho grafu\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>V\u00e1\u0161 kol\u00e1\u010dov\u00fd graf bude p\u0159edstavovat rozpis va\u0161ich r\u016fzn\u00fdch v\u00fddaj\u016f, co\u017e zlep\u0161\u00ed v\u00e1\u0161 finan\u010dn\u00ed p\u0159ehled.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Fin\u00e1ln\u00ed vizualizace kol\u00e1\u010dov\u00e9ho grafu\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-43.webp\" title=\"Fin\u00e1ln\u00ed vizualizace kol\u00e1\u010dov\u00e9ho grafu\"\/><\/figure>\n<h2 class=\"wp-block-heading\" id=\"step-6-apply-filters-to-view-categories\">Krok 6: Pou\u017eijte filtry pro efektivn\u00ed zobrazen\u00ed<\/h2>\n<p>Filtry mohou zlep\u0161it ovladatelnost va\u0161eho sledova\u010de t\u00edm, \u017ee v\u00e1m umo\u017en\u00ed snadno t\u0159\u00eddit nebo skr\u00fdvat transakce.<\/p>\n<ul class=\"wp-block-list\">\n<li>Klikn\u011bte na z\u00e1hlav\u00ed sloupce, kter\u00fd chcete filtrovat.<\/li>\n<li>Stiskn\u011bte tla\u010d\u00edtko &#8216;Vytvo\u0159it filtr&#8217; reprezentovan\u00e9 obr\u00e1cen\u00fdm troj\u00faheln\u00edkem na panelu n\u00e1stroj\u016f.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Vytv\u00e1\u0159en\u00ed filtr\u016f v Tabulk\u00e1ch Google\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-44-1.webp\" title=\"Vytv\u00e1\u0159en\u00ed filtr\u016f v Tabulk\u00e1ch Google\"\/><\/figure>\n<ul class=\"wp-block-list\">\n<li>Po kliknut\u00ed na ikonu filtru vedle z\u00e1hlav\u00ed sloupce se zobraz\u00ed r\u016fzn\u00e9 mo\u017enosti. Vyberte si z &#8216;Filtrovat podle hodnot&#8217;, &#8216;Sort A to Z&#8217; nebo dal\u0161\u00ed p\u0159edvolby \u0159azen\u00ed a pot\u00e9 klikn\u011bte na &#8216;OK&#8217; pro pou\u017eit\u00ed.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Mo\u017enosti \u0159azen\u00ed pro sloupce\" decoding=\"async\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/12\/image-45.webp\" title=\"Mo\u017enosti \u0159azen\u00ed pro sloupce\"\/><\/figure>\n<h3 class=\"wp-block-heading\" id=\"important-notes\">D\u016fle\u017eit\u00e9 pozn\u00e1mky<\/h3>\n<ul class=\"wp-block-list\">\n<li>V\u00e1\u0161 n\u00e1stroj na sledov\u00e1n\u00ed v\u00fddaj\u016f se automaticky aktualizuje, jakmile budou p\u0159id\u00e1ny nov\u00e9 v\u00fddaje, co\u017e odr\u00e1\u017e\u00ed zm\u011bny v kol\u00e1\u010dov\u00e9m grafu.<\/li>\n<li>Zva\u017ete p\u0159evod sv\u00fdch z\u00e1znam\u016f do form\u00e1tu tabulky pro snaz\u0161\u00ed navigaci a anal\u00fdzu va\u0161ich v\u00fddaj\u016f.<\/li>\n<li>Hlavn\u00ed v\u00fdhodou vytvo\u0159en\u00ed vlastn\u00edho sledov\u00e1n\u00ed v\u00fddaj\u016f nam\u00edsto pou\u017eit\u00ed \u0161ablon je flexibilita p\u0159i prov\u00e1d\u011bn\u00ed okam\u017eit\u00fdch oprav v p\u0159\u00edpad\u011b chyb.<\/li>\n<li>Pro pohodl\u00ed si m\u016f\u017eete do smartphonu nainstalovat aplikaci Tabulky Google a zaznamen\u00e1vat v\u00fddaje na cest\u00e1ch.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Efektivn\u00ed spr\u00e1va financ\u00ed je z\u00e1sadn\u00ed, ale \u010dasto se m\u016f\u017ee zd\u00e1t zdrcuj\u00edc\u00ed, zejm\u00e9na kdy\u017e sledujete sv\u00e9 v\u00fddaje. Na\u0161t\u011bst\u00ed n\u00e1stroje jako Tabulky Google nab\u00edzej\u00ed intuitivn\u00ed platformu pro vytv\u00e1\u0159en\u00ed p\u0159izp\u016fsoben\u00fdch sledova\u010d\u016f m\u011bs\u00ed\u010dn\u00edch v\u00fddaj\u016f. Zat\u00edmco Tabulky Google poskytuj\u00ed n\u011bkolik hotov\u00fdch \u0161ablon, navrhnout sledova\u010d p\u0159izp\u016fsoben\u00fd va\u0161im pot\u0159eb\u00e1m je dosa\u017eiteln\u00e9 a p\u0159\u00edmo\u010dar\u00e9. Krok 1: Definujte svou strukturu sledov\u00e1n\u00ed v\u00fddaj\u016f Ne\u017e se [&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,806],"class_list":["post-5965","post","type-post","status-publish","format-standard","hentry","category-how-to","tag-google","tag-google-sheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/posts\/5965","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/comments?post=5965"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/posts\/5965\/revisions"}],"predecessor-version":[{"id":5966,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/posts\/5965\/revisions\/5966"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/media?parent=5965"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/categories?post=5965"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/tags?post=5965"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}