{"id":6227,"date":"2025-01-07T13:29:28","date_gmt":"2025-01-07T13:29:28","guid":{"rendered":"https:\/\/howtogeek.blog\/cs\/?p=6227"},"modified":"2025-01-07T13:29:28","modified_gmt":"2025-01-07T13:29:28","slug":"tracking-your-subscriptions-with-google-sheets-a-stepbystep-guide","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/cs\/tracking-your-subscriptions-with-google-sheets-a-stepbystep-guide\/","title":{"rendered":"Sledov\u00e1n\u00ed p\u0159edplatn\u00e9ho pomoc\u00ed Tabulek Google: Podrobn\u00fd pr\u016fvodce"},"content":{"rendered":"<p>Spr\u00e1va v\u00edce p\u0159edplatn\u00fdch m\u016f\u017ee b\u00fdt ohromuj\u00edc\u00ed, zvl\u00e1\u0161t\u011b kdy\u017e se spol\u00e9h\u00e1te na r\u016fzn\u00e9 slu\u017eby zalo\u017een\u00e9 na p\u0159edplatn\u00e9m. Mnoho lid\u00ed pou\u017e\u00edv\u00e1 nativn\u00ed n\u00e1stroje nab\u00edzen\u00e9 t\u011bmito platformami, jako je Google Play Store nebo Apple App Store, ke sledov\u00e1n\u00ed sv\u00fdch p\u0159edplatn\u00fdch, ale tyto mo\u017enosti \u010dasto p\u0159ich\u00e1zej\u00ed s omezen\u00edmi. Podobn\u011b, i kdy\u017e se specializovan\u00e9 aplikace pro sledov\u00e1n\u00ed p\u0159edplatn\u00e9ho mohou zd\u00e1t p\u0159ita\u017eliv\u00e9, mohou tak\u00e9 v\u00e9st k dal\u0161\u00edm v\u00fddaj\u016fm. Na\u0161t\u011bst\u00ed m\u016f\u017eete spr\u00e1vu p\u0159edplatn\u00e9ho bez n\u00e1mahy zjednodu\u0161it a zefektivnit pomoc\u00ed <strong>Tabulek Google<\/strong> \u2013 bezplatn\u00e9ho a v\u0161estrann\u00e9ho \u0159e\u0161en\u00ed!<\/p>\n<h2 id=\"step-1-designing-your-subscription-tracker\">Krok 1: N\u00e1vrh va\u0161eho sledov\u00e1n\u00ed p\u0159edplatn\u00e9ho<\/h2>\n<ul>\n<li>Za\u010dn\u011bte t\u00edm, \u017ee ve webov\u00e9m prohl\u00ed\u017ee\u010di nav\u0161t\u00edv\u00edte Tabulky Google a p\u0159ihl\u00e1s\u00edte se ke sv\u00e9mu \u00fa\u010dtu Google.<\/li>\n<li>Vyberte \u201ePr\u00e1zdn\u00e1 tabulka\u201c a vytvo\u0159te novou tabulku v\u011bnovanou va\u0161emu sledov\u00e1n\u00ed p\u0159edplatn\u00e9ho.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Vytvo\u0159en\u00ed nov\u00e9 tabulky v Tabulk\u00e1ch Google\" class=\"wp-image\" decoding=\"async\" height=\"470\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-529-1.webp\" title=\"Vytvo\u0159en\u00ed nov\u00e9 tabulky v Tabulk\u00e1ch Google\" width=\"835\"\/><\/figure>\n<ul>\n<li>Kliknut\u00edm na v\u00fdchoz\u00ed textov\u00e9 pole \u201eTabulka bez n\u00e1zvu\u201c p\u0159ejmenujete sv\u016fj list na vhodn\u011bj\u0161\u00ed, nap\u0159\u00edklad \u201eSledov\u00e1n\u00ed p\u0159edplatn\u00e9ho\u201c.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Pojmenov\u00e1n\u00ed tabulky v Tabulk\u00e1ch Google\" class=\"wp-image\" decoding=\"async\" height=\"469\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-530-1.webp\" title=\"Pojmenov\u00e1n\u00ed tabulky v Tabulk\u00e1ch Google\" width=\"834\"\/><\/figure>\n<ul>\n<li>Nastavte sv\u016fj list p\u0159id\u00e1n\u00edm z\u00e1kladn\u00edch z\u00e1hlav\u00ed sloupc\u016f. Zva\u017ete zahrnut\u00ed z\u00e1hlav\u00ed, jako je n\u00e1zev p\u0159edplatn\u00e9ho, \u200b\u200bkategorie, m\u011bs\u00ed\u010dn\u00ed n\u00e1klady, ro\u010dn\u00ed n\u00e1klady, frekvence plateb a akce (jako obnoven\u00ed nebo zru\u0161en\u00ed).<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Vytv\u00e1\u0159en\u00ed sloupc\u016f v Tabulk\u00e1ch Google\" class=\"wp-image\" decoding=\"async\" height=\"552\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-531-1.webp\" title=\"Vytv\u00e1\u0159en\u00ed sloupc\u016f v Tabulk\u00e1ch Google\" width=\"982\"\/><\/figure>\n<ul>\n<li>Pro sloupce jako Kategorie a Frekvence je v\u00fdhodn\u00e9 vytvo\u0159it rozbalovac\u00ed nab\u00eddky. Chcete-li to prov\u00e9st, klikn\u011bte na z\u00e1hlav\u00ed sloupce, pot\u00e9 stiskn\u011bte a podr\u017ete <code>Ctrl<\/code>p\u0159i v\u00fdb\u011bru sousedn\u00edch bun\u011bk z\u00e1hlav\u00ed sloupce.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"V\u00fdb\u011br bun\u011bk pro rozev\u00edrac\u00ed nab\u00eddku\" class=\"wp-image\" decoding=\"async\" height=\"480\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-532-1.webp\" title=\"V\u00fdb\u011br bun\u011bk pro rozev\u00edrac\u00ed nab\u00eddku\" width=\"854\"\/><\/figure>\n<ul>\n<li>P\u0159ejd\u011bte do nab\u00eddky &#8216;Vlo\u017eit&#8217; um\u00edst\u011bn\u00e9 naho\u0159e.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Vkl\u00e1d\u00e1n\u00ed rozbalovac\u00ed nab\u00eddky do Tabulek Google\" class=\"wp-image\" decoding=\"async\" height=\"464\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-534-1.webp\" title=\"Vkl\u00e1d\u00e1n\u00ed rozbalovac\u00ed nab\u00eddky do Tabulek Google\" width=\"824\"\/><\/figure>\n<ul>\n<li>Ze zobrazen\u00fdch mo\u017enost\u00ed vyberte \u201eRozbalovac\u00ed\u201c, \u010d\u00edm\u017e se vygeneruj\u00ed rozbalovac\u00ed nab\u00eddky pro vybran\u00fd sloupec. Na prav\u00e9 stran\u011b se objev\u00ed nov\u00fd panel.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Vytv\u00e1\u0159en\u00ed rozev\u00edrac\u00edch seznam\u016f v Tabulk\u00e1ch Google\" class=\"wp-image\" decoding=\"async\" height=\"467\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-535-1.webp\" title=\"Vytv\u00e1\u0159en\u00ed rozev\u00edrac\u00edch seznam\u016f v Tabulk\u00e1ch Google\" width=\"831\"\/><\/figure>\n<ul>\n<li>Zadejte po\u017eadovan\u00e9 polo\u017eky pro mo\u017enosti rozev\u00edrac\u00edho seznamu tak, \u017ee je zad\u00e1te do pol\u00ed napravo. Chcete-li p\u0159idat dal\u0161\u00ed kategorie, pou\u017eijte tla\u010d\u00edtko \u201eP\u0159idat dal\u0161\u00ed polo\u017eku\u201c.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"P\u0159id\u00e1v\u00e1n\u00ed polo\u017eek do rozbalovac\u00ed nab\u00eddky v Tabulk\u00e1ch Google\" class=\"wp-image\" decoding=\"async\" height=\"447\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-536-1-1.webp\" title=\"P\u0159id\u00e1v\u00e1n\u00ed polo\u017eek do rozbalovac\u00ed nab\u00eddky v Tabulk\u00e1ch Google\" width=\"794\"\/><\/figure>\n<ul>\n<li>Barevn\u011b ozna\u010dte polo\u017eky kliknut\u00edm na barevn\u00fd \u010dtvere\u010dek vedle ka\u017ed\u00e9 polo\u017eky pro lep\u0161\u00ed vizu\u00e1ln\u00ed organizaci.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Barevn\u00e9 k\u00f3dov\u00e1n\u00ed polo\u017eek rozev\u00edrac\u00edho seznamu\" class=\"wp-image\" decoding=\"async\" height=\"463\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-537-1.webp\" title=\"Barevn\u00e9 k\u00f3dov\u00e1n\u00ed polo\u017eek rozev\u00edrac\u00edho seznamu\" width=\"823\"\/><\/figure>\n<ul>\n<li>Po dokon\u010den\u00ed rozbalovac\u00ed nab\u00eddky Kategorie zopakujte tyto kroky pro sloupec Frekvence. Zadejte podrobnosti o p\u0159edplatn\u00e9m bez uveden\u00ed symbolu m\u011bny ve v\u00fd\u0161i jejich n\u00e1klad\u016f.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Zad\u00e1v\u00e1n\u00ed \u00fadaj\u016f o p\u0159edplatn\u00e9m do Tabulek Google\" class=\"wp-image\" decoding=\"async\" height=\"464\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-539-1.webp\" title=\"Zad\u00e1v\u00e1n\u00ed \u00fadaj\u016f o p\u0159edplatn\u00e9m do Tabulek Google\" width=\"825\"\/><\/figure>\n<ul>\n<li>Zv\u00fdrazn\u011bte bu\u0148ky ve sloupci &#8216;Datum p\u0159ihl\u00e1\u0161en\u00ed&#8217;, p\u0159ejd\u011bte do nab\u00eddky &#8216;Form\u00e1t&#8217; a vyberte &#8216;\u010c\u00edslo&#8217; a pot\u00e9 vyberte &#8216;Datum&#8217; pro form\u00e1tov\u00e1n\u00ed t\u011bchto z\u00e1znam\u016f jako data.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Form\u00e1tov\u00e1n\u00ed dat v Tabulk\u00e1ch Google\" class=\"wp-image\" decoding=\"async\" height=\"474\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-540-1.webp\" title=\"Form\u00e1tov\u00e1n\u00ed dat v Tabulk\u00e1ch Google\" width=\"842\"\/><\/figure>\n<ul>\n<li>Podobn\u011b vyberte polo\u017eky ve sloupci \u201e\u010c\u00e1stka\u201c. Postupujte podle stejn\u00e9ho postupu, ale pro p\u0159esn\u00e9 form\u00e1tov\u00e1n\u00ed \u010d\u00e1stek zvolte \u201eM\u011bna\u201c nebo \u201eZaokrouhlen\u00e1 m\u011bna\u201c m\u00edsto Datum. Pokud pou\u017e\u00edv\u00e1te jinou m\u011bnu, vyberte mo\u017enost Vlastn\u00ed m\u011bna.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Form\u00e1tov\u00e1n\u00ed m\u011bny v Tabulk\u00e1ch Google\" class=\"wp-image\" decoding=\"async\" height=\"485\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-542-1.webp\" title=\"Form\u00e1tov\u00e1n\u00ed m\u011bny v Tabulk\u00e1ch Google\" width=\"862\"\/><\/figure>\n<ul>\n<li>Nezapome\u0148te propojit rozbalovac\u00ed mo\u017enosti pro sloupec \u201eAkce\u201c s mo\u017enostmi jako \u201eObnovit\u201c, \u201eZru\u0161it\u201c nebo \u201eUpgradovat\u201c.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Vytv\u00e1\u0159en\u00ed tla\u010d\u00edtek akc\u00ed v Tabulk\u00e1ch Google\" class=\"wp-image\" decoding=\"async\" height=\"458\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-546-1.webp\" title=\"Vytv\u00e1\u0159en\u00ed tla\u010d\u00edtek akc\u00ed v Tabulk\u00e1ch Google\" width=\"814\"\/><\/figure>\n<h2 id=\"step-2-monitoring-your-subscriptions\">Krok 2: Sledov\u00e1n\u00ed p\u0159edplatn\u00e9ho<\/h2>\n<p>Je nezbytn\u00e9 p\u0159esn\u011b vypo\u010d\u00edtat n\u00e1klady na p\u0159edplatn\u00e9 podle jejich frekvence. M\u00e1te mo\u017enost n\u00e1sobit, d\u011blit nebo uchov\u00e1vat \u010d\u00e1stku podle toho, jak \u010dasto plat\u00edte.<\/p>\n<ul>\n<li>Chcete-li ur\u010dit m\u011bs\u00ed\u010dn\u00ed cenu p\u0159edplatn\u00e9ho, \u200b\u200bpou\u017eijte n\u00e1sleduj\u00edc\u00ed vzorec: <code>=IF(C2=\"Monthly\",E2,IF(C2=\"Annually\",E2\/12,IF(C2=\"Weekly\",E2*4,\"\")))<\/code>.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"V\u00fdpo\u010det n\u00e1klad\u016f na p\u0159edplatn\u00e9 v Tabulk\u00e1ch Google\" class=\"wp-image\" decoding=\"async\" height=\"483\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-543-1.webp\" title=\"V\u00fdpo\u010det n\u00e1klad\u016f na p\u0159edplatn\u00e9 v Tabulk\u00e1ch Google\" width=\"858\"\/><\/figure>\n<ul>\n<li>Pro ro\u010dn\u00ed n\u00e1klady jednodu\u0161e vyn\u00e1sobte m\u011bs\u00ed\u010dn\u00ed \u010d\u00e1stku 12. Vzorec, kter\u00fd byste pou\u017eili, je: <code>=IF(C2=\"Monthly\",E2*12,IF(C2=\"Annually\",E2,IF(C2=\"Weekly\",E2*52,\"\")))<\/code>.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Vzorec pro kalkulaci ro\u010dn\u00edch n\u00e1klad\u016f\" class=\"wp-image\" decoding=\"async\" height=\"485\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-544-1.webp\" title=\"Vzorec pro kalkulaci ro\u010dn\u00edch n\u00e1klad\u016f\" width=\"862\"\/><\/figure>\n<ul>\n<li>Chcete-li zjistit kumulativn\u00ed n\u00e1klady v pr\u016fb\u011bhu \u010dasu, po\u010d\u00edtejte s t\u00edm, kolik obdob\u00ed uplynulo od va\u0161\u00ed prvn\u00ed platby. Vzorec pro celo\u017eivotn\u00ed n\u00e1klady je: <code>=IFS(C2 = \"Weekly\", F2 * INT((TODAY()-D2)\/7), C2 = \"Monthly\", (DATEDIF(D2,TODAY(), \"m\") * F2), C2 = \"Annually\", (H2 * DATEDIF(D2, TODAY(),\"y\")))<\/code>.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Vzorec pro v\u00fdpo\u010det celo\u017eivotn\u00edch n\u00e1klad\u016f\" class=\"wp-image\" decoding=\"async\" height=\"539\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-545-1.webp\" title=\"Vzorec pro v\u00fdpo\u010det celo\u017eivotn\u00edch n\u00e1klad\u016f\" width=\"959\"\/><\/figure>\n<ul>\n<li>V posledn\u00edm sloupci se rozhodn\u011bte, zda chcete p\u0159edplatn\u00e9 obnovit, zru\u0161it nebo upgradovat.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Sledov\u00e1n\u00ed stavu p\u0159edplatn\u00e9ho\" class=\"wp-image\" decoding=\"async\" height=\"484\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-547-1.webp\" title=\"Sledov\u00e1n\u00ed stavu p\u0159edplatn\u00e9ho\" width=\"861\"\/><\/figure>\n<p>Pokud pouze hled\u00e1te zp\u016fsob, jak sledovat sv\u00e9 odb\u011bry, m\u016f\u017eete se zastavit zde. Vylep\u0161en\u00ed va\u0161eho trackeru v\u0161ak m\u016f\u017ee p\u0159in\u00e9st hlub\u0161\u00ed vhled do va\u0161ich finan\u010dn\u00edch z\u00e1vazk\u016f!<\/p>\n<h2 id=\"step-3-applying-conditional-formatting\">Krok 3: Pou\u017eit\u00ed podm\u00edn\u011bn\u00e9ho form\u00e1tov\u00e1n\u00ed<\/h2>\n<p>Podm\u00edn\u011bn\u00e9 form\u00e1tov\u00e1n\u00ed v\u00e1m m\u016f\u017ee pomoci rychle identifikovat p\u0159edplatn\u00e1, kter\u00e1 se bl\u00ed\u017e\u00ed k datu obnoven\u00ed.<\/p>\n<ul>\n<li>P\u0159idejte dva nov\u00e9 sloupce ozna\u010den\u00e9 \u201eP\u0159\u00ed\u0161t\u00ed datum splatnosti\u201c a \u201eDny do akce\u201c.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"P\u0159id\u00e1v\u00e1n\u00ed nov\u00fdch sloupc\u016f pro odb\u011bry\" class=\"wp-image\" decoding=\"async\" height=\"469\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-548-1.webp\" title=\"P\u0159id\u00e1v\u00e1n\u00ed nov\u00fdch sloupc\u016f pro odb\u011bry\" width=\"834\"\/><\/figure>\n<ul>\n<li>D\u00e1le p\u0159ejd\u011bte do nab\u00eddky \u201eForm\u00e1t\u201c a vyberte \u201ePodm\u00edn\u011bn\u00e9 form\u00e1tov\u00e1n\u00ed\u201c.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"P\u0159\u00edstup k podm\u00edn\u011bn\u00e9mu form\u00e1tov\u00e1n\u00ed\" class=\"wp-image\" decoding=\"async\" height=\"497\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-550-1.webp\" title=\"P\u0159\u00edstup k podm\u00edn\u011bn\u00e9mu form\u00e1tov\u00e1n\u00ed\" width=\"884\"\/><\/figure>\n<ul>\n<li>V panelu, kter\u00fd se otev\u0159e, ur\u010dete rozsah bun\u011bk pro podm\u00edn\u011bn\u00e9 form\u00e1tov\u00e1n\u00ed (nap\u0159\u00edklad <code>A2:K100<\/code>). Klikn\u011bte na rozbalovac\u00ed nab\u00eddku \u201eForm\u00e1tovat bu\u0148ky, pokud\u201c.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Rozsah nastaven\u00ed pro podm\u00edn\u011bn\u00e9 form\u00e1tov\u00e1n\u00ed\" class=\"wp-image\" decoding=\"async\" height=\"452\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-551-1-1.webp\" title=\"Rozsah nastaven\u00ed pro podm\u00edn\u011bn\u00e9 form\u00e1tov\u00e1n\u00ed\" width=\"804\"\/><\/figure>\n<ul>\n<li>Z rozbalovac\u00ed nab\u00eddky vyberte mo\u017enost Vlastn\u00ed vzorec.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"V\u00fdb\u011br vlastn\u00edho vzorce pro form\u00e1tov\u00e1n\u00ed\" class=\"wp-image\" decoding=\"async\" height=\"432\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-552-1.webp\" title=\"V\u00fdb\u011br vlastn\u00edho vzorce pro form\u00e1tov\u00e1n\u00ed\" width=\"768\"\/><\/figure>\n<ul>\n<li>Do pole \u201eHodnota nebo vzorec\u201c zadejte: <code>=AND(ISNUMBER($K2), $K2 &lt;= 28)<\/code>. T\u00edm se zv\u00fdrazn\u00ed \u0159\u00e1dky, kde jsou p\u0159edplatn\u00e9 splatn\u00e9 do 28 dn\u016f.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Nastaven\u00ed vzorce podm\u00edn\u011bn\u00e9ho form\u00e1tov\u00e1n\u00ed\" class=\"wp-image\" decoding=\"async\" height=\"467\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-553-1.webp\" title=\"Nastaven\u00ed vzorce podm\u00edn\u011bn\u00e9ho form\u00e1tov\u00e1n\u00ed\" width=\"830\"\/><\/figure>\n<h3 id=\"useful-tips-to-remember\">U\u017eite\u010dn\u00e9 tipy k zapamatov\u00e1n\u00ed<\/h3>\n<ul>\n<li>Jakmile je v\u00e1\u0161 sledova\u010d zaveden, m\u016f\u017eete jednodu\u0161e aktualizovat relevantn\u00ed informace, jako jsou \u010d\u00e1stky, ani\u017e byste pot\u0159ebovali dal\u0161\u00ed podrobnosti. Tabulky Google automaticky zajist\u00ed odpov\u00eddaj\u00edc\u00ed aktualizaci v\u0161ech z\u00e1visl\u00fdch pol\u00ed.<\/li>\n<li>Vyu\u017eijte kontingen\u010dn\u00ed tabulky pro okam\u017eit\u00e9 statistiky z va\u0161ich dat p\u0159edplatn\u00e9ho. Umo\u017en\u00ed v\u00e1m to analyzovat va\u0161e vzorce v\u00fddaj\u016f na prvn\u00ed pohled.<\/li>\n<li>P\u0159esto\u017ee Tabulky Google nepodporuj\u00ed kontingen\u010dn\u00ed grafy, m\u016f\u017eete sv\u016fj soubor snadno exportovat do aplikace Microsoft Excel, kter\u00e1 tuto funkci poskytuje.<\/li>\n<li>Pokud zn\u00ed vytv\u00e1\u0159en\u00ed va\u0161eho n\u00e1stroje pro sledov\u00e1n\u00ed p\u0159edplatn\u00e9ho skli\u010duj\u00edc\u00edm zp\u016fsobem, zva\u017ete pou\u017eit\u00ed p\u0159edem p\u0159ipraven\u00fdch \u0161ablon v Tabulk\u00e1ch Google jako v\u00fdchoz\u00ed bod.<\/li>\n<li>U\u017eivatel\u00e9 Google Workspace mohou do galerie \u0161ablon p\u0159isp\u00edvat vlastn\u00edmi \u0161ablonami pro sledov\u00e1n\u00ed p\u0159edplatn\u00e9ho, \u200b\u200baby je mohli pou\u017e\u00edvat ostatn\u00ed.<\/li>\n<\/ul>\n<h3>Dal\u0161\u00ed statistiky<\/h3>\n<h4><strong>1. Mohu pou\u017e\u00edvat Tabulky Google na mobilu ke sledov\u00e1n\u00ed odb\u011br\u016f?<\/strong><\/h4>\n<p>Ano, Tabulky Google jsou dostupn\u00e9 na mobiln\u00edch za\u0159\u00edzen\u00edch prost\u0159ednictv\u00edm aplikace Tabulky Google nebo va\u0161eho mobiln\u00edho prohl\u00ed\u017ee\u010de. To v\u00e1m umo\u017en\u00ed aktualizovat a sledovat va\u0161e p\u0159edplatn\u00e9 odkudkoli.<\/p>\n<h4><strong>2. Existuje zp\u016fsob, jak ochr\u00e1nit sv\u00e1 p\u0159edplatitelsk\u00e1 data v Tabulk\u00e1ch Google?<\/strong><\/h4>\n<p>Absolutn\u011b! Tabulky Google v\u00e1m umo\u017e\u0148uj\u00ed nastavit opr\u00e1vn\u011bn\u00ed ke sd\u00edlen\u00ed a \u00faprav\u00e1m, co\u017e zaji\u0161\u0165uje, \u017ee pouze opr\u00e1vn\u011bn\u00ed u\u017eivatel\u00e9 budou m\u00edt p\u0159\u00edstup k va\u0161im dat\u016fm p\u0159edplatn\u00e9ho nebo je upravovat.<\/p>\n<h4><strong>3. Jak mohu exportovat sledov\u00e1n\u00ed p\u0159edplatn\u00e9ho pro jin\u00e9 \u00fa\u010dely?<\/strong><\/h4>\n<p>Soubor Tabulek Google si m\u016f\u017eete snadno st\u00e1hnout v r\u016fzn\u00fdch form\u00e1tech v\u010detn\u011b Excelu, PDF a CSV. P\u0159ejd\u011bte do nab\u00eddky \u201eSoubor\u201c, vyberte \u201eSt\u00e1hnout\u201c a vyberte po\u017eadovan\u00fd form\u00e1t.<\/p>\n<p><a class=\"xiaomi\" href=\"https:\/\/allthings.how\/how-to-use-google-sheets-to-track-your-subscriptions\/\" rel=\"noopener noreferrer nofollow\" target=\"_blank\">Zdroj a obr\u00e1zky<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Spr\u00e1va v\u00edce p\u0159edplatn\u00fdch m\u016f\u017ee b\u00fdt ohromuj\u00edc\u00ed, zvl\u00e1\u0161t\u011b kdy\u017e se spol\u00e9h\u00e1te na r\u016fzn\u00e9 slu\u017eby zalo\u017een\u00e9 na p\u0159edplatn\u00e9m. Mnoho lid\u00ed pou\u017e\u00edv\u00e1 nativn\u00ed n\u00e1stroje nab\u00edzen\u00e9 t\u011bmito platformami, jako je Google Play Store nebo Apple App Store, ke sledov\u00e1n\u00ed sv\u00fdch p\u0159edplatn\u00fdch, ale tyto mo\u017enosti \u010dasto p\u0159ich\u00e1zej\u00ed s omezen\u00edmi. Podobn\u011b, i kdy\u017e se specializovan\u00e9 aplikace pro sledov\u00e1n\u00ed p\u0159edplatn\u00e9ho mohou zd\u00e1t [&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":[806,126],"class_list":["post-6227","post","type-post","status-publish","format-standard","hentry","category-how-to","tag-google-sheets","tag-microsoft"],"acf":[],"_links":{"self":[{"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/posts\/6227","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=6227"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/posts\/6227\/revisions"}],"predecessor-version":[{"id":6228,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/posts\/6227\/revisions\/6228"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/media?parent=6227"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/categories?post=6227"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/tags?post=6227"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}