Training Excel advanced
Training description
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.
- For beginners
- For intermediate
- For advanced
- For experts
Topics
- 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
Duration
This course lasts 1 – 3 days.
Course date
Go to a contact form to make an order or obtain more information.
Similar posts about this topic
2.7.2020 - 19.4.2018 Training Excel VBA basics
3.11.2017 
17.10.2017 Convert text to formula using EVALUATE
30.9.2017
3 Comments
Pozdravujem Vás pán Kohoutek.
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