{"id":6722,"date":"2018-07-30T08:23:31","date_gmt":"2018-07-30T06:23:31","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=6722"},"modified":"2022-08-09T12:44:33","modified_gmt":"2022-08-09T10:44:33","slug":"excel-mac-igy-kezdd","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/","title":{"rendered":"Excel Mac, erre figyelj, ha Macintosh-on kezdesz Excelezni!"},"content":{"rendered":"\n<p>Miben m\u00e1s az Excel Mac? Hogyan hozz l\u00e9tre t\u00e1bl\u00e1zatot, alap form\u00e1z\u00e1sokat \u00e9s egyszer\u0171bb k\u00e9pleteket? Mutatom a kezd\u0151 l\u00e9p\u00e9seket, mire, hogyan haszn\u00e1lhatod az Excelt Mac g\u00e9pen.<\/p>\n\n\n\n<!--more-->\n\n\n\n<h2 class=\"wp-block-heading\">Hogy n\u00e9z ki az Excel Mac g\u00e9peken?<\/h2>\n\n\n\n<p>Ha m\u00e1r l\u00e1tt\u00e1l Excelt, akkor a Macintoshon, Macbookon megnyitva is ismer\u0151s fel\u00fcletet tal\u00e1lsz. Hasonl\u00f3 szalagos men\u00fc: Kezd\u0151lap, Besz\u00far\u00e1s, Lapelrendez\u00e9s, K\u00e9pletek, Adatok&#8230;<\/p>\n\n\n\n<div class=\"wp-block-media-text alignwide is-stacked-on-mobile\" style=\"grid-template-columns:56% auto\"><figure class=\"wp-block-media-text__media\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Excel_Mac_Macintosh_hasznalat-1024x576.jpg\" alt=\"\" class=\"wp-image-9271 size-full\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Excel_Mac_Macintosh_hasznalat-1024x576.jpg 1024w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Excel_Mac_Macintosh_hasznalat-300x169.jpg 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Excel_Mac_Macintosh_hasznalat-768x432.jpg 768w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Excel_Mac_Macintosh_hasznalat-1536x864.jpg 1536w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Excel_Mac_Macintosh_hasznalat.jpg 1600w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><div class=\"wp-block-media-text__content\">\n<p>Kezd\u0151t\u0151l halad\u00f3ig 8 r\u00e9szes online Excel tanfolyam &#8211; kimondottan\u00a0<a rel=\"noreferrer noopener\" href=\"https:\/\/exceltitok.hu\/csoportos-kezdo-excel-tanfolyam-mac\/\" target=\"_blank\"><span style=\"text-decoration: underline;\">Macintosh Excellel!<\/span><\/a><\/p>\n\n\n\n<p>Ha szeretn\u00e9d jobban megismerni az Exceled, jelentkezz \u00e9s tanulj vel\u00fcnk! Legyen a bar\u00e1tod az Excel!<\/p>\n<\/div><\/div>\n\n\n\n<p>Fel\u00fcl ugyan\u00fagy bet\u0171k hat\u00e1rozz\u00e1k meg az oszlopokat, oldalt pedig sz\u00e1mok, amik a&nbsp;sorokat azonos\u00edtj\u00e1k. (Hivatalosan oszlopazonos\u00edt\u00f3, sorazonos\u00edt\u00f3) &#8230;\u00e9s sok-sok \u00fcres cella &#8211; pontosan XFD1048576-ig, mint az Excelben.&nbsp;Mint egy koordin\u00e1ta rendszerben, a kett\u0151 kombin\u00e1ci\u00f3ja hat\u00e1rozza meg a&nbsp;cell\u00e1t.<\/p>\n\n\n\n<figure class=\"wp-block-image alignfull\"><img decoding=\"async\" width=\"871\" height=\"362\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/macbook-excel-hasznalat-uj-fajl.png\" alt=\"\u00cdgy n\u00e9z ki az Excel MacBookon\" class=\"wp-image-6728\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/macbook-excel-hasznalat-uj-fajl.png 871w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/macbook-excel-hasznalat-uj-fajl-300x125.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/macbook-excel-hasznalat-uj-fajl-768x319.png 768w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/macbook-excel-hasznalat-uj-fajl-660x274.png 660w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/macbook-excel-hasznalat-uj-fajl-240x100.png 240w\" sizes=\"(max-width: 871px) 100vw, 871px\" \/><\/figure>\n\n\n\n<p>A cell\u00e1kban vannak adatok, de fent a&nbsp;Szerkeszt\u0151l\u00e9cen l\u00e1tod, hogy mi szerepel t\u00e9nylegesen a cell\u00e1ban &#8211; p\u00e9ld\u00e1ul ha k\u00e9plet eredm\u00e9nyek\u00e9nt ker\u00fclt be a tartalom.<\/p>\n\n\n\n<p>A Szerkeszt\u0151l\u00e9ct\u0151l balra, a Beilleszt\u00e9s ikon alatt tal\u00e1lod a N\u00e9v mez\u0151t, ami mindig mutatja az akt\u00edv cell\u00e1t, azaz, hogy \u00e9ppen melyik cell\u00e1n \u00e1ll a kurzorod.<\/p>\n\n\n\n<p>A Kezd\u0151lapon tal\u00e1lod a leggyakoribb ikonok, els\u0151k\u00e9nt ezekkel ismerkedj. Ha kor\u00e1bban m\u00e1r dolgozt\u00e1l Excellel, akkor ismer\u0151sek lesznek a funkci\u00f3k.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Mozg\u00e1s, kijel\u00f6l\u00e9s az&nbsp;Excel Mac programban<\/h2>\n\n\n\n<p>A cell\u00e1k kijel\u00f6l\u00e9s\u00e9re&nbsp;<span style=\"text-decoration: underline;\"><a title=\"A kijel\u00f6l\u00e9s fort\u00e9lyai \u2013 avagy hogyan haszn\u00e1ld az egeret a t\u00e1bl\u00e1zatokban?\" href=\"https:\/\/sosexcel.com\/exceltippek\/a-kijeloles-fortelyai-avagy-hogyan-hasznald-az-egeret-tablazatokban\/\" target=\"_blank\" rel=\"noopener\">eleinte az egeret \u00e9rdemes haszn\u00e1lnod<\/a><\/span>. B\u00e1r egy kicsit elt\u00e9r a Mac touchpad haszn\u00e1lata az eg\u00e9rt\u0151l, ha m\u00e1r a norm\u00e1l haszn\u00e1latban megszoktad, akkor az Excelben sem fog gondot okozni.<\/p>\n\n\n\n<p>Persze \u00e9rdemes a billenty\u0171kkel val\u00f3 mozg\u00e1st \u00e9s kijel\u00f6l\u00e9st is miel\u0151bb begyakorolnod &#8211; hiszen <span style=\"text-decoration: underline;\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/akar-500-napot-is-veszithetsz-ha-tul-sokat-hasznalod-az-egeret\/\" target=\"_blank\" rel=\"noopener\">\u00e9ves szinten t\u00f6bb napot megsp\u00f3rolhatsz<\/a><\/span> egy kis odafigyel\u00e9ssel:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>A nyilakkal [\u2192\u2191\u2190\u2193]&nbsp;tudod cell\u00e1nk\u00e9nt mozgatni a kurzort.<\/li><li>Ha nyomva tartod a Shiftet is&nbsp;[Shift \u2192\u2191\u2190\u2193], akkor a k\u00f6ztes cell\u00e1kat is kijel\u00f6li az Excel.<\/li><li>Term\u00e9szetesen a nagyobb t\u00e1vols\u00e1gokat nem kell egyes\u00e9vel nyomogatnod, hanem a Cmd [\u2318] seg\u00edts\u00e9g\u00e9vel &#8222;turb\u00f3s\u00edthatod&#8221; a nyilakat. Ez az adott ir\u00e1nyban keresi meg az utols\u00f3 kit\u00f6lt\u00f6tt cell\u00e1t, vagy \u00fcres cell\u00e1k eset\u00e9n a k\u00f6vetkez\u0151 olyat, amiben adat van.&nbsp; [\u2318 \u2192\u2191\u2190\u2193]<\/li><li>A 2 gombot term\u00e9szetesen egy\u00fctt is haszn\u00e1lhatod [\u2318 Shift \u2192\u2191\u2190\u2193], p\u00e9ld\u00e1ul az&nbsp;A2-b\u0151l indulva a \u2318&nbsp;Shift \u2192 kijel\u00f6li az els\u0151 adatot (sort), m\u00edg a \u2318&nbsp;Shift \u2193 az A oszlopban l\u00e9v\u0151 sz\u00f6vegeket.<\/li><\/ul>\n\n\n\n<p>A cell\u00e1kat ugyan\u00fagy form\u00e1zhatod, mint a sz\u00f6vegeket a Wordben, haszn\u00e1ld a Kezd\u0151lap ikonjait:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Bet\u0171t\u00edpus<\/li><li>Bet\u0171m\u00e9ret<\/li><li>Bet\u0171m\u00e9ret n\u00f6vel\u00e9se \/ cs\u00f6kkent\u00e9se<\/li><li>F\u00e9lk\u00f6v\u00e9r \/ D\u0151lt \/ Al\u00e1h\u00fazott<\/li><li>Szeg\u00e9lyek<\/li><li>Kit\u00f6lt\u00e9s (cella sz\u00edne)<\/li><li>Bet\u0171sz\u00edn<\/li><li>Sz\u00f6veg igaz\u00edt\u00e1sa: f\u00fcgg\u0151legesen (fel, le, k\u00f6z\u00e9pre) \u00e9s v\u00edzszintesen (jobbra, balra, k\u00f6z\u00e9pre)<\/li><li>T\u00e1jol\u00e1s \/ <span style=\"text-decoration: underline;\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/hogyan-valtoztathatod-meg-szoveg-irasiranyat-excelben\/\" target=\"_blank\" rel=\"noopener\">Sz\u00f6vegir\u00e1ny<\/a><\/span><\/li><li>Beh\u00faz\u00e1s (n\u00f6vel\u00e9s, cs\u00f6kkent\u00e9s)<\/li><\/ul>\n\n\n\n<p><strong>Az adatbevitelkor el\u00e9g csak kijel\u00f6ln\u00f6d (egyszer! r\u00e1kattintanod) a cell\u00e1ra<\/strong>, \u00e9s&nbsp;m\u00e1r \u00edrhatod is az \u00e9rt\u00e9ket,&nbsp;amit ott szeretn\u00e9l l\u00e1tni (ne ijedj meg, ha nem l\u00e1tod a kurzort). A tartalom r\u00f6gz\u00edt\u00e9s\u00e9re az Enter \u00e9s a Tab&nbsp;gombokat haszn\u00e1lhatod. Mindkett\u0151 a k\u00f6vetkez\u0151 cell\u00e1ba ugrik, az&nbsp;egyik lefel\u00e9, a m\u00e1sik jobbra. Gyors\u00edthatsz, ha a Tabbal m\u00e9sz v\u00e9gig a soron, \u00e9s az utols\u00f3 adatn\u00e1l nyomsz Entert, mert akkor visszaker\u00fclsz a sor elej\u00e9re.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">T\u00e1bl\u00e1zat fel\u00e9p\u00edt\u00e9se, elrendez\u00e9se<\/h2>\n\n\n\n<p><strong>Igyekezz egy cell\u00e1ba csak sz\u00e1mot vagy csak sz\u00f6veget \u00edrni<\/strong>, s\u0151t tagold k\u00fcl\u00f6n oszlopokra, amennyire csak tudod.<\/p>\n\n\n\n<p>P\u00e9ld\u00e1ul a id\u0151intervallumok kezdet\u00e9t \u00e9s v\u00e9g\u00e9t k\u00fcl\u00f6n oszlopban add&nbsp;meg, \u00edgy tudod majd az eltelt napokat is sz\u00e1molni.<\/p>\n\n\n\n<figure class=\"wp-block-image alignfull\"><img decoding=\"async\" src=\"http:\/\/exceltitok.hu\/wp-content\/uploads\/2013\/11\/Pivot_adatbazis.jpg\" alt=\"Az inform\u00e1ci\u00f3 t\u00edpusa szerint tagold az adatok\" class=\"wp-image-554\"\/><\/figure>\n\n\n\n<p><strong style=\"font-family: Arial, sans-serif; font-size: 16px; font-style: normal;\"><\/strong>Nevek \u00e9s c\u00edmek eset\u00e9ben is \u00e9rdemes elgondolkodnod azon,\u00a0hogy milyen tagol\u00e1sban lesz sz\u00fcks\u00e9ged k\u00e9s\u0151bb az inform\u00e1ci\u00f3ra: mehet egy mez\u0151be, vagy k\u00fcl\u00f6n szeretn\u00e9d kezelni p\u00e9ld\u00e1ul a vezet\u00e9knevet \u00e9s a keresztnevet. Persze, ha k\u00e9s\u0151bb meggondolod magad, akkor is <span style=\"text-decoration: underline;\"><a rel=\"noopener\" href=\"https:\/\/sosexcel.com\/exceltippek\/vezetek-es-keresztnev\/\" target=\"_blank\">fel tudod darabolni<\/a><\/span>, vagy <span style=\"text-decoration: underline;\"><a rel=\"noopener\" href=\"https:\/\/sosexcel.com\/exceltippek\/szovegek-osszefuzese\/\" target=\"_blank\">\u00f6ssze tudod f\u0171zni<\/a><\/span> \u0151ket.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Excel Mac haszn\u00e1lat: a sz\u00e1mok form\u00e1z\u00e1sa<\/h2>\n\n\n\n<p>A leggyakoribb form\u00e1z\u00e1s az ezres csoportos\u00edt\u00e1s.&nbsp;Az ezres tagol\u00e1s seg\u00edt, hogy k\u00f6nnyebb legyen kiolvasni a nagyobb \u00e9rt\u00e9keket.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><img decoding=\"async\" width=\"735\" height=\"598\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/ezres-csoportositas-excel-mac.png\" alt=\"Ezres csoportos\u00edt\u00e1s Excel Mac g\u00e9pen - csak a k\u00fclalak t\u00e9r el, a m\u00f3dszer ugyanaz\" class=\"wp-image-6730\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/ezres-csoportositas-excel-mac.png 735w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/ezres-csoportositas-excel-mac-300x244.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/ezres-csoportositas-excel-mac-660x537.png 660w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/ezres-csoportositas-excel-mac-240x195.png 240w\" sizes=\"(max-width: 735px) 100vw, 735px\" \/><\/figure><\/div>\n\n\n\n<p>A be\u00e1ll\u00edt\u00e1shoz a&nbsp;cell\u00e1k&nbsp;kijel\u00f6l\u00e9se ut\u00e1n v\u00e1laszd a <strong>jobbklikk Cellaform\u00e1z\u00e1s&nbsp;<\/strong>men\u00fct [billenty\u0171kkel: Ctrl1 vagy&nbsp;\u23181],&nbsp;majd a Cellaform\u00e1z\u00e1s ablakon v\u00e1laszd a <strong>Sz\u00e1m kateg\u00f3ri\u00e1t.<\/strong><\/p>\n\n\n\n<p>Itt tudod a tizedes jegyeket n\u00f6velni\/cs\u00f6kkenteni, \u00e9s megtal\u00e1lod az Ezres tagol\u00e1s&nbsp;jel\u00f6l\u0151n\u00e9gyzetet,&nbsp;<strong>pip\u00e1ld be az ezres csoportos\u00edt\u00e1st.<\/strong><\/p>\n\n\n\n<p>Fel\u00fcl a Minta mez\u0151ben r\u00f6gt\u00f6n l\u00e1tod, hogy hogyan fog a t\u00e1bl\u00e1zatban megjelenni a sz\u00e1m. Ha el\u00e9gedett vagy, akkor m\u00e1r csak le kell ok\u00e9znod.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><img loading=\"lazy\" decoding=\"async\" width=\"428\" height=\"460\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Excel-Mac-szamformatum-lista.png\" alt=\"Sz\u00e1mform\u00e1tumok list\u00e1ja az Excel Mac k\u00e9perny\u0151j\u00e9n\" class=\"wp-image-6732\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Excel-Mac-szamformatum-lista.png 428w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Excel-Mac-szamformatum-lista-279x300.png 279w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Excel-Mac-szamformatum-lista-240x258.png 240w\" sizes=\"(max-width: 428px) 100vw, 428px\" \/><\/figure><\/div>\n\n\n\n<p>Az ezres csoprotos\u00edt\u00e1s 2 tizedesjeggyel gyorsbillenty\u0171je a magyar nyelv\u0171 Excel Mac g\u00e9peken: Ctrl Shift 4 (angol nyelv\u0171 g\u00e9peken elt\u00e9rhet.)<\/p>\n\n\n\n<p>A sz\u00e1mok form\u00e1z\u00e1s\u00e1ra haszn\u00e1lhatod a Kezd\u0151lap k\u00f6zep\u00e9n tal\u00e1lhat\u00f3 list\u00e1t, vagy az alatta tal\u00e1lhat\u00f3 ikonokat is, csak\u00fagy, mint a &#8216;hagyom\u00e1nyos&#8217; Excelben.<\/p>\n\n\n\n<p>A p\u00e9nznemet hat\u00e1rozattan k\u00f6nnyebb ebb\u0151l a mini-list\u00e1b\u00f3l kikeresni, mint a a Cellaform\u00e1z\u00e1s panel hossz\u00fa list\u00e1j\u00e1b\u00f3l.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright\"><img loading=\"lazy\" decoding=\"async\" width=\"312\" height=\"259\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Excel-Mac-penznem-lista.png\" alt=\"K\u00fcl\u00f6nb\u00f6z\u0151 p\u00e9nznemek az Excel MacBookon\" class=\"wp-image-6731\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Excel-Mac-penznem-lista.png 312w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Excel-Mac-penznem-lista-300x249.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Excel-Mac-penznem-lista-240x199.png 240w\" sizes=\"(max-width: 312px) 100vw, 312px\" \/><\/figure><\/div>\n\n\n\n<p>A&nbsp;sz\u00e1zal\u00e9kform\u00e1tumot \u00e9s a tizedesjegyeket is k\u00f6nnyen be\u00e1ll\u00edthatod az ikonokkal.<\/p>\n\n\n\n<p>A 000 ikonnal az ezres csoportos\u00edt\u00e1st \u00e1ll\u00edthatod be, de mivel ez&nbsp;&#8216;K\u00f6nyvel\u0151i&#8217; form\u00e1tum, ez\u00e9rt lesz a v\u00e9g\u00e9n egy kis sz\u00fcnet (a \u2018hi\u00e1nyz\u00f3\u2019 Ft vagy \u20ac helye), amit nem is tudsz elt\u00fcntetni, csak ha vissza\u00e1ll\u00edtod &#8216;Sz\u00e1m&#8217; form\u00e1tumra.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Excel alapok: sz\u00e1mol\u00e1sok, k\u00e9pletek<\/h2>\n\n\n\n<p>Az Excel \u00fagy m\u0171k\u00f6dik mint egy sz\u00e1mol\u00f3g\u00e9p!&nbsp;<strong>Gyorsan \u00e9s pontosan tud sz\u00e1molni<\/strong>, s\u0151t, <span style=\"text-decoration: underline;\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/mi-a-muveletek-sorrendje-es-mikor-kell-zarojelet-hasznalni\/\" target=\"_blank\" rel=\"noopener\">m\u00e9g a m\u0171veletek sorrendj\u00e9t is ismeri<\/a>!<\/span><\/p>\n\n\n\n<p>Ha sz\u00e1moln\u00e1l vele, jel\u00f6ld ki azt a cell\u00e1t, ahov\u00e1 az eredm\u00e9nyt akarod. Egyszer\u0171en kezdd = vagy + jellel \u00e9s \u00edrd be ugyan\u00fagy a sz\u00e1m\u00edt\u00e1st, mint egy sz\u00e1mol\u00f3g\u00e9pbe. (Ezt h\u00edvjuk&nbsp;<strong>k\u00e9pletnek<\/strong>.)<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><img loading=\"lazy\" decoding=\"async\" width=\"283\" height=\"168\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Excel-Mac-k\u00e9plet.png\" alt=\"K\u00e9plet \u00edr\u00e1s az Excel Mac g\u00e9peken is egyenl\u0151s\u00e9gjellel (vagy +) kezd\u0151dik.\" class=\"wp-image-6737\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Excel-Mac-k\u00e9plet.png 283w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Excel-Mac-k\u00e9plet-240x142.png 240w\" sizes=\"(max-width: 283px) 100vw, 283px\" \/><\/figure><\/div>\n\n\n\n<p>Ha a sz\u00e1mot m\u00e1r kor\u00e1bban be\u00edrtad, akkor haszn\u00e1ld azt a \u201ccell\u00e1t&#8221;, amiben szerepel. (ezt h\u00edvj\u00e1k az Excelben <strong>hivatkoz\u00e1snak<\/strong>).<\/p>\n\n\n\n<p>Ezt a cell\u00e1t behozhatod az eg\u00e9rrel is, de gyorsabb, ha ink\u00e1bb a nyilakkal l\u00e9psz r\u00e1. Itt a k\u00e9pen a B2-be \u00edrom a k\u00e9pletet, \u00edgy a balrany\u00edllal hivatkoztam be az A2 cell\u00e1ban szerepl\u0151 sz\u00e1mot.&nbsp;Ha v\u00e9letlen\u00fcl elrontod, semmi gond, a nyilak seg\u00edts\u00e9g\u00e9vel tudod korrig\u00e1lni a poz\u00edci\u00f3dat.&nbsp;(Am\u00edg m\u00e9g&nbsp;villog a keret, azt jelenti, hogy&nbsp;tudsz m\u00f3dos\u00edtani a hivatkoz\u00e1s hely\u00e9n.)<\/p>\n\n\n\n<p>Ha meg vagy el\u00e9gedve a poz\u00edci\u00f3val, \u00edrd be a m\u0171veleti jelet (jelen esetben * a szorz\u00e1s miatt), \u00edgy fix lesz az els\u0151 keret, \u00e9s folytathatod a k\u00e9pletet.<\/p>\n\n\n\n<p>A mez\u0151ben \u00e9s a szerkeszt\u0151l\u00e9cen ezt l\u00e1tod: =A2*1,27<br>A k\u00e9plet r\u00f6gz\u00edt\u00e9s\u00e9hez haszn\u00e1ld az Entert.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Gyakori k\u00e9rd\u00e9s, hogy hol szerepel a MacBook billenty\u0171zeten a szorz\u00e1sjel, vagy csillag (*)\nA * az Alt Shift k\u00e9rd\u0151jel (?) kombin\u00e1ci\u00f3, azaz 3 ujj sz\u00fcks\u00e9ges hozz\u00e1.<\/pre>\n\n\n\n<p><strong>A hivatkoz\u00e1s 2 legnagyobb el\u0151nye<\/strong>, hogy<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\u00e1t\u00edrva a cell\u00e1kban a sz\u00e1mokat, mindig naprak\u00e9sz eredm\u00e9nyt mutat a k\u00e9plet,<\/li><li>illetve lem\u00e1solva a t\u00f6bbi sorba ott is megism\u00e9tli a sz\u00e1mol\u00e1st.<img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-6736 size-full\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Excel-Mac-b\u00fcty\u00f6k.png\" alt=\"Excel Mac verzi\u00f3n is m\u0171k\u00f6dik a duplakattos k\u00e9pletm\u00e1sol\u00e1s.\" width=\"218\" height=\"117\"><\/li><\/ul>\n\n\n\n<p>A m\u00e1sol\u00e1shoz jel\u00f6ld ki a k\u00e9pletet tartalmaz\u00f3 cell\u00e1t, \u00e9s a jobb als\u00f3 sarokban l\u00e9v\u0151 b\u00fctyk\u00f6t (ahogy f\u00f6l\u00e9 viszed az egeret, fekete + jell\u00e9 alakul) fogd meg \u00e9s h\u00fazd le az eg\u00e9rrel. Vagy ha m\u00e1r vannak adatok a t\u00e1bl\u00e1zatban, akkor gyorsabb, ha a (Tartalomm\u00e1sol\u00f3) b\u00fcty\u00f6kn\u00e9l dupl\u00e1n kattintasz.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Egyszer\u0171bb f\u00fcggv\u00e9nyek haszn\u00e1lata Excel Mac verzi\u00f3ban<\/h2>\n\n\n\n<p>Az Excelben vannak <strong>el\u0151re gy\u00e1rtott f\u00fcggv\u00e9nyek<\/strong>, egy-egy konkr\u00e9t sz\u00e1m\u00edt\u00e1sra.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><img loading=\"lazy\" decoding=\"async\" width=\"211\" height=\"141\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Macintosh-Excel-szum.png\" alt=\"A SZUM mag\u00e1t\u00f3l megkeresi a legk\u00f6zlebbi sz\u00e1mokat, az Excel Mac verzi\u00f3ban is.\" class=\"wp-image-6814\"\/><\/figure><\/div>\n\n\n\n<p>A legismertebb a SZUM (angolul SUM), amely a kijel\u00f6lt sz\u00e1mokat egyes\u00e9vel \u00f6sszeadja.<\/p>\n\n\n\n<p>P\u00e9ld\u00e1ul nem kell be\u00edrnod:&nbsp;=A2+A3+A4<\/p>\n\n\n\n<p>Hanem helyette gyorsabb f\u00fcggv\u00e9nnyel: =SZUM(A2:A4)<\/p>\n\n\n\n<p>R\u00e1ad\u00e1sul b<span style=\"font-size: 16px;\">eg\u00e9pel\u00e9s helyett haszn\u00e1lhatod a men\u00fc jobb sz\u00e9l\u00e9n tal\u00e1lhat\u00f3&nbsp;\u2211 gombot, amely \u00f6szt\u00f6n\u00f6sen ki is jel\u00f6li a k\u00e9plet f\u00f6l\u00f6tt tal\u00e1lhat\u00f3 sz\u00e1mokat. (Ha sz\u00fcks\u00e9ges, a kijel\u00f6l\u00e9st m\u00f3dos\u00edthatod, am\u00edg villog a keret: egyszer\u0171en hagyd figyelmen k\u00edv\u00fcl, \u00e9s kattints a j\u00f3 cell\u00e1kra.)<\/span><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><img loading=\"lazy\" decoding=\"async\" width=\"298\" height=\"230\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Macintosh-Excel-szum-atlag.png\" alt=\"AutoSzum helyett a \u2211 jelet keresd az Excel Mac jobb fels\u0151 sark\u00e1ban.\" class=\"wp-image-6815\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Macintosh-Excel-szum-atlag.png 298w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Macintosh-Excel-szum-atlag-240x185.png 240w\" sizes=\"(max-width: 298px) 100vw, 298px\" \/><\/figure><\/div>\n\n\n\n<p>Hasonl\u00f3 f\u00fcggv\u00e9ny az \u00c1TLAG (angolul AVERAGE), amely a&nbsp;kijel\u00f6lt sz\u00e1mok matematikai \u00e1tlag\u00e1t adja eredm\u00e9ny\u00fcl: azaz \u00f6sszead\u00e1s ut\u00e1n elosztja a darabsz\u00e1mmal.<\/p>\n\n\n\n<p>Az \u00c1tlagot, \u00e9s a hasonl\u00f3 Darabsz\u00e1m, Maximum, Minimum f\u00fcggv\u00e9nyt a <span style=\"font-size: 16px;\">\u2211 melletti kis nyilat lenyitva tal\u00e1lod<\/span>.<\/p>\n\n\n\n<p>A t\u00f6bbi f\u00fcggv\u00e9nyt a K\u00e9pletek f\u00fcl\u00f6n tal\u00e1lod. Az a legpraktikusabb, ha a leggyakoribb f\u00fcggv\u00e9nyeket megismered \u00e9s begyakorlod azt is, hogyan tudod kombin\u00e1lni \u0151ket.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">M\u00e9g t\u00f6bb Excel haszn\u00e1lat Mac-en<\/h2>\n\n\n\n<p>Ha szeretn\u00e9d t\u00f6bb dologra haszn\u00e1lni a Macintoshon fut\u00f3 Excel programod, akkor jelentkezz hozz\u00e1nk <a href=\"http:\/\/exceltitok.hu\/oktatas\/\" target=\"_blank\" rel=\"noopener\"><span style=\"text-decoration: underline;\">egy\u00e9ni Excel tanfolyamra<\/span><\/a>. Mi is ismerj\u00fck, haszn\u00e1ljuk a MacBookot, \u00e9s az Excel saj\u00e1toss\u00e1gait. Sz\u00edvesen tan\u00edtunk Neked is hasznos tr\u00fckk\u00f6ket.<\/p>\n\n\n\n<p>Vagy csatlakozz a csoportos <a rel=\"noopener\" href=\"https:\/\/exceltitok.hu\/csoportos-kezdo-excel-tanfolyam-mac\/\" target=\"_blank\"><span style=\"text-decoration: underline;\">Macintosh Excel tanfolyam<\/span><\/a>unkhoz! (A linkre kattintva tudod ellen\u0151rizni, hogy mikor indul \u00faj csoport.)<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">M\u00e9g t\u00f6bb Macintosh tipp Excelre:<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a rel=\"noreferrer noopener\" href=\"https:\/\/sosexcel.com\/exceltippek\/feleslegesen-vagy-rosszul-torolsz\/\" target=\"_blank\">Feleslegesen vagy rosszul t\u00f6r\u00f6lsz<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/exceltitok.hu\/kereses-es-csere-az-excelben\/\" target=\"_blank\">Keres\u00e9s \u00e9s csere az Excelben<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/exceltitok.hu\/szovegbol-oszlopok-mac-excelen\/\" target=\"_blank\">Sz\u00f6vegb\u0151l oszlopok Mac Excelen, azaz hogyan darabolj sz\u00f6vegeket?<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/sosexcel.com\/exceltippek\/enterek-torlese-wordben\/\" target=\"_blank\">Enterek t\u00f6rl\u00e9se Wordben<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/sosexcel.com\/exceltippek\/excel-fulek-bekapcsolasa-macintoshon\/\" target=\"_blank\">Excel f\u00fclek bekapcsol\u00e1sa Macintoshon<\/a><\/li><li><a href=\"https:\/\/exceltitok.hu\/mac-excel-tablazatok\/\" data-type=\"URL\" data-id=\"https:\/\/exceltitok.hu\/mac-excel-tablazatok\/\" target=\"_blank\" rel=\"noreferrer noopener\">Mac Excel t\u00e1bl\u00e1zatok, kimutat\u00e1s el\u0151k\u00e9sz\u00edt\u00e9se<\/a><\/li><\/ul>\n\n\n\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/hogyan-irj-kepleteket-az-excelben\/\"><span style=\"text-decoration: underline;\">Hogyan \u00edrj k\u00e9pleteket az Excelben?<\/span><\/a><br><a href=\"https:\/\/exceltitok.hu\/szovegbol-oszlopok-mac-excelen\/\"><span style=\"text-decoration: underline;\">Sz\u00f6vegb\u0151l oszlopok Mac Excelen, azaz hogyan darabolj sz\u00f6vegeket?<\/span><\/a><\/p>\n\n\n\n","protected":false},"excerpt":{"rendered":"<p>Miben m\u00e1s az Excel Mac? Hogyan hozz l\u00e9tre t\u00e1bl\u00e1zatot, alap form\u00e1z\u00e1sokat \u00e9s egyszer\u0171bb k\u00e9pleteket? Mutatom a kezd\u0151 l\u00e9p\u00e9seket, mire, hogyan haszn\u00e1lhatod az Excelt Mac g\u00e9pen.<\/p>\n","protected":false},"author":1,"featured_media":9271,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[101,103,60],"class_list":["post-6722","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tippek-gyakori-kerdesek","tag-alapok","tag-mac","tag-macintosh"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel Mac, erre figyelj, ha Macintosh-on kezdesz Excelezni!<\/title>\n<meta name=\"description\" content=\"Miben m\u00e1s az Excel Mac? Hogyan hozz l\u00e9tre t\u00e1bl\u00e1zatot, alap form\u00e1z\u00e1sokat \u00e9s egyszer\u0171bb k\u00e9pleteket? Mutatom a kezd\u0151 l\u00e9p\u00e9seket a Mac g\u00e9pen.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Mac, erre figyelj, ha Macintosh-on kezdesz Excelezni!\" \/>\n<meta property=\"og:description\" content=\"Miben m\u00e1s az Excel Mac? Hogyan hozz l\u00e9tre t\u00e1bl\u00e1zatot, alap form\u00e1z\u00e1sokat \u00e9s egyszer\u0171bb k\u00e9pleteket? Mutatom a kezd\u0151 l\u00e9p\u00e9seket a Mac g\u00e9pen.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/\" \/>\n<meta property=\"og:site_name\" content=\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/bernadett.koros\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-30T06:23:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-09T10:44:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Excel_Mac_Macintosh_hasznalat.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1600\" \/>\n\t<meta property=\"og:image:height\" content=\"900\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Bernadett\" \/>\n<meta name=\"twitter:label1\" content=\"Szerz\u0151:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bernadett\" \/>\n\t<meta name=\"twitter:label2\" content=\"Becs\u00fclt olvas\u00e1si id\u0151\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Excel Mac, erre figyelj, ha Macintosh-on kezdesz Excelezni!\",\"datePublished\":\"2018-07-30T06:23:31+00:00\",\"dateModified\":\"2022-08-09T10:44:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/\"},\"wordCount\":1793,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Excel_Mac_Macintosh_hasznalat.jpg\",\"keywords\":[\"alapok\",\"Mac\",\"Macintosh\"],\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/\",\"name\":\"Excel Mac, erre figyelj, ha Macintosh-on kezdesz Excelezni!\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Excel_Mac_Macintosh_hasznalat.jpg\",\"datePublished\":\"2018-07-30T06:23:31+00:00\",\"dateModified\":\"2022-08-09T10:44:33+00:00\",\"description\":\"Miben m\u00e1s az Excel Mac? Hogyan hozz l\u00e9tre t\u00e1bl\u00e1zatot, alap form\u00e1z\u00e1sokat \u00e9s egyszer\u0171bb k\u00e9pleteket? Mutatom a kezd\u0151 l\u00e9p\u00e9seket a Mac g\u00e9pen.\",\"breadcrumb\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/#primaryimage\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Excel_Mac_Macintosh_hasznalat.jpg\",\"contentUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Excel_Mac_Macintosh_hasznalat.jpg\",\"width\":1600,\"height\":900},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sosexcel.com\/exceltippek\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Mac, erre figyelj, ha Macintosh-on kezdesz Excelezni!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#website\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/\",\"name\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"description\":\"ha S.O.S. seg\u00edts\u00e9gre van sz\u00fcks\u00e9ged!\",\"publisher\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/sosexcel.com\/exceltippek\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"hu\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\",\"name\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png\",\"contentUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png\",\"width\":600,\"height\":133,\"caption\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b\",\"name\":\"Bernadett\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"caption\":\"Bernadett\"},\"description\":\"Bernadett 10 \u00e9vig dolgozott a versenyszf\u00e9r\u00e1ban, majd az ott szerzett tapasztalatok alapj\u00e1n \u00e1ll\u00edtotta \u00f6ssze az ExcelTitok k\u00e9pz\u00e9si m\u00f3dszert. 2010 szeptembere \u00f3ta csak Excel oktat\u00e1ssal foglalkozik. Oktat\u00f3i csapat\u00e1val m\u00e1ra m\u00e1r t\u00f6bb mint 2000 emberrel foglalkoztak szem\u00e9lyesen, egy\u00e9ni oktat\u00e1s keret\u00e9ben. C\u00e9lja, hogy \u00edr\u00e1sainak \u00e9s munk\u00e1j\u00e1nak k\u00f6sz\u00f6nhet\u0151en min\u00e9l t\u00f6bben megbar\u00e1tkozzanak az Excellel.\",\"sameAs\":[\"http:\/\/exceltitok.hu\/\",\"https:\/\/www.facebook.com\/bernadett.koros\"],\"url\":\"https:\/\/sosexcel.com\/exceltippek\/author\/sos-excel\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Mac, erre figyelj, ha Macintosh-on kezdesz Excelezni!","description":"Miben m\u00e1s az Excel Mac? Hogyan hozz l\u00e9tre t\u00e1bl\u00e1zatot, alap form\u00e1z\u00e1sokat \u00e9s egyszer\u0171bb k\u00e9pleteket? Mutatom a kezd\u0151 l\u00e9p\u00e9seket a Mac g\u00e9pen.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/","og_locale":"hu_HU","og_type":"article","og_title":"Excel Mac, erre figyelj, ha Macintosh-on kezdesz Excelezni!","og_description":"Miben m\u00e1s az Excel Mac? Hogyan hozz l\u00e9tre t\u00e1bl\u00e1zatot, alap form\u00e1z\u00e1sokat \u00e9s egyszer\u0171bb k\u00e9pleteket? Mutatom a kezd\u0151 l\u00e9p\u00e9seket a Mac g\u00e9pen.","og_url":"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2018-07-30T06:23:31+00:00","article_modified_time":"2022-08-09T10:44:33+00:00","og_image":[{"width":1600,"height":900,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Excel_Mac_Macintosh_hasznalat.jpg","type":"image\/jpeg"}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"9 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Excel Mac, erre figyelj, ha Macintosh-on kezdesz Excelezni!","datePublished":"2018-07-30T06:23:31+00:00","dateModified":"2022-08-09T10:44:33+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/"},"wordCount":1793,"commentCount":2,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Excel_Mac_Macintosh_hasznalat.jpg","keywords":["alapok","Mac","Macintosh"],"articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/","url":"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/","name":"Excel Mac, erre figyelj, ha Macintosh-on kezdesz Excelezni!","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Excel_Mac_Macintosh_hasznalat.jpg","datePublished":"2018-07-30T06:23:31+00:00","dateModified":"2022-08-09T10:44:33+00:00","description":"Miben m\u00e1s az Excel Mac? Hogyan hozz l\u00e9tre t\u00e1bl\u00e1zatot, alap form\u00e1z\u00e1sokat \u00e9s egyszer\u0171bb k\u00e9pleteket? Mutatom a kezd\u0151 l\u00e9p\u00e9seket a Mac g\u00e9pen.","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Excel_Mac_Macintosh_hasznalat.jpg","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/07\/Excel_Mac_Macintosh_hasznalat.jpg","width":1600,"height":900},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/excel-mac-igy-kezdd\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Excel Mac, erre figyelj, ha Macintosh-on kezdesz Excelezni!"}]},{"@type":"WebSite","@id":"https:\/\/sosexcel.com\/exceltippek\/#website","url":"https:\/\/sosexcel.com\/exceltippek\/","name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"ha S.O.S. seg\u00edts\u00e9gre van sz\u00fcks\u00e9ged!","publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sosexcel.com\/exceltippek\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"hu"},{"@type":"Organization","@id":"https:\/\/sosexcel.com\/exceltippek\/#organization","name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","url":"https:\/\/sosexcel.com\/exceltippek\/","logo":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png","width":600,"height":133,"caption":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b","name":"Bernadett","image":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","caption":"Bernadett"},"description":"Bernadett 10 \u00e9vig dolgozott a versenyszf\u00e9r\u00e1ban, majd az ott szerzett tapasztalatok alapj\u00e1n \u00e1ll\u00edtotta \u00f6ssze az ExcelTitok k\u00e9pz\u00e9si m\u00f3dszert. 2010 szeptembere \u00f3ta csak Excel oktat\u00e1ssal foglalkozik. Oktat\u00f3i csapat\u00e1val m\u00e1ra m\u00e1r t\u00f6bb mint 2000 emberrel foglalkoztak szem\u00e9lyesen, egy\u00e9ni oktat\u00e1s keret\u00e9ben. C\u00e9lja, hogy \u00edr\u00e1sainak \u00e9s munk\u00e1j\u00e1nak k\u00f6sz\u00f6nhet\u0151en min\u00e9l t\u00f6bben megbar\u00e1tkozzanak az Excellel.","sameAs":["http:\/\/exceltitok.hu\/","https:\/\/www.facebook.com\/bernadett.koros"],"url":"https:\/\/sosexcel.com\/exceltippek\/author\/sos-excel\/"}]}},"_links":{"self":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/6722","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/comments?post=6722"}],"version-history":[{"count":25,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/6722\/revisions"}],"predecessor-version":[{"id":9625,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/6722\/revisions\/9625"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media\/9271"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=6722"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=6722"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=6722"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}