Co umi-excel
-
Upload
pavel-lasak -
Category
Documents
-
view
1.647 -
download
2
description
Transcript of Co umi-excel
![Page 1: Co umi-excel](https://reader034.fdocument.pub/reader034/viewer/2022050805/559ca6f11a28abb90d8b4866/html5/thumbnails/1.jpg)
Co umí Excel?
Pavel Lasák
http://office.lasakovi.com© 2013
získejte z něj maximum
![Page 2: Co umi-excel](https://reader034.fdocument.pub/reader034/viewer/2022050805/559ca6f11a28abb90d8b4866/html5/thumbnails/2.jpg)
Grafy - klasické
Pavel Lasák http://office.lasakovi.com © 2013
![Page 3: Co umi-excel](https://reader034.fdocument.pub/reader034/viewer/2022050805/559ca6f11a28abb90d8b4866/html5/thumbnails/3.jpg)
Grafy – netradiční
Pavel Lasák http://office.lasakovi.com © 2013
![Page 4: Co umi-excel](https://reader034.fdocument.pub/reader034/viewer/2022050805/559ca6f11a28abb90d8b4866/html5/thumbnails/4.jpg)
Grafy – vodopádový - waterfall
Pavel Lasák http://office.lasakovi.com © 2013
![Page 5: Co umi-excel](https://reader034.fdocument.pub/reader034/viewer/2022050805/559ca6f11a28abb90d8b4866/html5/thumbnails/5.jpg)
Grafy – netradiční - ganttův
Pavel Lasák http://office.lasakovi.com © 2013
![Page 6: Co umi-excel](https://reader034.fdocument.pub/reader034/viewer/2022050805/559ca6f11a28abb90d8b4866/html5/thumbnails/6.jpg)
Grafy – netradiční - hodiny
Pavel Lasák http://office.lasakovi.com © 2013
![Page 7: Co umi-excel](https://reader034.fdocument.pub/reader034/viewer/2022050805/559ca6f11a28abb90d8b4866/html5/thumbnails/7.jpg)
Tabulky – řazení, filtrování
Pavel Lasák http://office.lasakovi.com © 2013
![Page 8: Co umi-excel](https://reader034.fdocument.pub/reader034/viewer/2022050805/559ca6f11a28abb90d8b4866/html5/thumbnails/8.jpg)
Tabulky – podmíněné formátování
Pavel Lasák http://office.lasakovi.com © 2013
![Page 9: Co umi-excel](https://reader034.fdocument.pub/reader034/viewer/2022050805/559ca6f11a28abb90d8b4866/html5/thumbnails/9.jpg)
Data – ověření (kontrola)
Pavel Lasák http://office.lasakovi.com © 2013
![Page 10: Co umi-excel](https://reader034.fdocument.pub/reader034/viewer/2022050805/559ca6f11a28abb90d8b4866/html5/thumbnails/10.jpg)
Data – externí zdroje
Pavel Lasák http://office.lasakovi.com © 2013
![Page 11: Co umi-excel](https://reader034.fdocument.pub/reader034/viewer/2022050805/559ca6f11a28abb90d8b4866/html5/thumbnails/11.jpg)
Data – analýzy, seskupování
Pavel Lasák http://office.lasakovi.com © 2013
![Page 12: Co umi-excel](https://reader034.fdocument.pub/reader034/viewer/2022050805/559ca6f11a28abb90d8b4866/html5/thumbnails/12.jpg)
VBA - Aplikace
Pavel Lasák http://office.lasakovi.com © 2013
![Page 13: Co umi-excel](https://reader034.fdocument.pub/reader034/viewer/2022050805/559ca6f11a28abb90d8b4866/html5/thumbnails/13.jpg)
Ostatní – šifry, fraktály, Colatzův problém, četnosti
Pavel Lasák http://office.lasakovi.com © 2013
![Page 14: Co umi-excel](https://reader034.fdocument.pub/reader034/viewer/2022050805/559ca6f11a28abb90d8b4866/html5/thumbnails/14.jpg)
Pavel Lasák http://office.lasakovi.com © 2013
a mnohem více …
Děkuji za pozornost.