Ms Excel training Intermediate (ENGLISH)

[Guest StibTo]

Cus, delal jsem vcera v praci Ms Excel training pro kolegy tak me napadlo se o to podelit i tady, treba se to nekomu bude hodit. Je tam mozna obcas nejaky firemni obrazek toho si nevsimejte ale teda je to bohuzel v anglictine (to byla tady nutnost). Tak pokud nebudete mit problem to prelouskat (neni to tezka AJ) tak stahujte, snad poslouzi

http://www.sendspace.com/file/a6e4rz

Uploadnuty archiv obsahuje vzdy vysvetleni ve Wordu + procviceni v Excelu, POZOR - nutno mit aktivovana MAKRA.

Pripadne dotazy sem do vlakna samozrejme.

[Guest StibTo]

Ještě přehled co tam je obsaženo :

1) Conditional Formatting (format/color/... of cell changes when certain condition is met)

2) Applying filters, using Custom filters, Sort According to..

3) Freeze Panes (ex.: lock header)

4) Functions in Excel -> IF, CONCATENATE, COUNT, COUNTIF, VLOOKUP, RETURN VALUE, TODAY(), NOW(), SUM, AVERAGE, combined functions

5) Validation list

6) Pivot Tables

7) Advanced Filter - Unique Records Only

8) Charts (graphs)

9) Compare two Excel windows side by side

10) Text to columns

11) Share Workbook

12) Protect Workbook

13) Hyperlinks

14) Recording and editing simple MACRO functions

15) Letters & Merging

[h4wk3y]

Pekne, diky za nasdileni!

[Guest StibTo]

Rado se stalo !