The Goal
We usually use Excel with its basic skills in our daily work. However, we often do not have a good grasp of its advanced and practical capabilities that will provide us with efficiency. Within the scope of our training, we will learn these techniques you need according to your priorities. We will help you to adopt these methods, especially with exercises, and to bring Excel more into your daily business life. We aim to get you a lot.
The Scope
Let’s get to know Excel closely;
There is no limit to what can be done with Excel! Application examples.
What are my daily needs?
How does Excel give me efficiency for my needs?
Exercise
Let’s take a look at the basic capabilities of Excel;
Introduction of the working environment
Working with formulas – Financial and statistical analysis
Tables and conditional formatting methods
Exercise
Data visualization and graphical representation;
Using advanced graphic representation techniques
Visualization with custom number formats and shapes
Sparklines
Exercise
Working with data and analysis techniques;
Transferring, cleaning, validating data
Pivot tables – Advanced Excel tool to analyze data
Querying data
Exercise
Automating Excel;
Working with macros
Exercise
Who can attend this training?
Anyone who wants to increase their productivity by using the advanced capabilities of Excel can participate.
Training Duration
2 days
(The content and its duration can be customized according to the needs of the training group)
