Designed for all those users, who depend heavily on MS Excel to prepare charts, tables, and professional reports that involve complex data. Firstly helpful for all those users, who take a profits of MS Excel regularly to analyze data.
IMPORTANT: participants of ADVANCED course are expected
to have a good prior understanding
of the basic features available in MS Excel.
Advanced Excel webinar – AGENDA
- Keyboard shortcuts, in general to improve your work to high level and also a better time organization
- Use of nested functions and complex formulas
- Table functions and formulas issues
- Indirect functions’ review
- Subtotal and total fields description
- Consolidate data in multiple worksheets problem (the method to consolidate data from a series of worksheets that have different layouts but have the same data labels) and data results difference
- advanced filer criteria, also to import data from other sheets
- PivotTable and PivotCharts
- Online Analytical Processing
- databases and support business intelligence
- tables and data forms issues
- Microsoft Query questions
- Search function and Solver’s usage
- The best practices for creating the right chart for data
- Using the Analysis to perform complex, statistical data analysis
- MS Excel and its financial functions for any loans, investments, depreciation of fixed assets – rules of calculation
- Excel programming rules: data formats and macros for repetitive tasks
- and many more…
Advanced excel webinar – our training formulae
Generally – we always do try to hold the training in small groups. However, it is possible to adapt it to larger numbers of trainees. We generally work on files provided by students, so that the knowledge presented during the course meets its practical application.We strongly insist on extended, exhaustive and comprehensive character of all lessons we organize. So we do press on practice during the course. Finally we are open to any questions that may occur after completing the class.
If you would like to join classes, or if you have any
other questions please see the OTHER QUESTIONS section,
as well as the CALENDAR or CONTACT US via mail.