Are you interested in advanced tools of Excel? We offer the possibility of learning advanced methods and tools in Excel with the following suggested outline. Topics are presented by the trainer, then he answers any questions from the audience about the topic and then students do exercises on their computer to use their new knowledge. Throughout the trainer assists them and advises individually.
You will learn how to:
- use conditional functions (IF, COUNTIF, SUMIF, COUNTIFS, SUMIFS etc…)
- use database functions to calculate summaries from large tables
- create an array formula and use it for special functions
- link the two tables by using the lookup functions such as VLOOKUP, HLOOKUP, INDEX, MATCH etc.
- prepare a form for users through form controls like a combo box, option button, check box, scroll bar etc.
- fully use all options of the Pivot table
- merge data from multiple tables into a single one
- create groups and automatic outline for easy hide and show parts of the table
- work with the names of cells, named ranges and constants instead of cell addresses
- create and record simple macros for repetitive operations
- display data in a chart, such as bar, pie, or line, exactly as you want
Similar posts about this topic
- 28.3.2012 Training Excel for experts
- 15.1.2010 Training Excel for beginners
- 15.1.2010 Excel intermediate training
16.1.2010 Training Word for beginners
3.4.2012 Training Access
Trainer Bc. Petr Vadlejch since 2007 specializes in trainings of Microsoft Office Applications and is a certified specialist in Microsoft Office.
Pozdravujem Vás pán Vadlejch.
Mol by som pre vás ponuku pri riešení nasledovného problému spojeného s vkladaním objektov do xlsx.
Otázka znie, či excel disponuje funkcionalitou na fixáciu vloženého objektu (napr. wor vo forme ikony) do konkrétnej bunky, ktorá je súčasťou zoskupených riadkov (po zabalení zoskupených riadkov a následnom zavretí a otvorení súboru, vložený objekt sa posunie do inej časti sheetu). V nápovede k XLS a ani na internete som nenašiel riešenie.
Ak by to u vás fungovalo, pošlite mi náklady na vyriešenie a číslo účtu. Po pripísaní platby, mi FUNGUJÚCE riešenie prepošlete. Je to u vás OK?
Ďakujem,
RoKla
Ano, poslal jsem Vám email, děkuji za poptávku.
Dobry den,
kamaradka mi Vas doporucila,pro jejich firmu jste delat skoleni na excel a pry vyborne. Potrebovala bych se doucit excel, podle Vaseho webu cca pokrocilou uroven. Zajem mam jako soukroma osoba.
Nebudete nekdy poradat skoleni pro skupinu lidi,ke ktere bych se mohla pridat? Jsem z Prahy.
Dekuji mnohokrat.
Zuzana L