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.