Excel Essentials
Beginner
This training helps you understand and practice the fundamentals of Excel.
This training is a must for everyone who works in Excel on daily basis. It helps you navigate smoothly through all important features of Excel.
Get Offer
FOR TEAMS
Objectives
Topics
What is a Spreadsheet?
- Introduction to spreadsheets
- Mathematics and formulas
- Formatting
- Page setup and printing
Formulas and Functions: Performing Quantitative Analysis
- Formula basics
- Function basics
- Logic and lookup functions
- Range names
Charts: Depicting Data Visually
- Chart creation basics
- Chart elements
- Chart design and sparklines
Datasets and Tables
- Excel tables
- Table manipulation
- Table aggregation
- Conditional formatting
- Subtotals and outlines
PivotTables and Pivot Charts: Summarizing and Analyzing Data
- Pivot Table Basic
- Pivot Table Options
- Pivot Table Design and Pivot Charts
Training Formats
In Person
Team Training
At Your Office
Real-Time
Team Training
Online
Self-Paced
for Individuals
Online
FAQ
Who is my trainer?
We do not guarantee a specific instructor per course but we make sure your training is led by an expert in the field. We are able to indicate your instructor's name before booking the training as we see their availability for given dates. Please not that our trainers have experience across different industries and unique knowledge of applications of the analytical tools.
Will we need and NDA (non-disclosure agreement)?
It is common for the course participants to approach us with their specific problems based on the company data. It is often sensitive data and we would like to make sure you can feel save and secure about it. Therefore, we always recommend signing an NDA and send it along as our pre training preparation package. However, it is not required.
What is the language of instruction?
As we mostly train international companies, all our trainings are conducted in English unless specifically agreed otherwise; however, support is provided in English, Dutch, Polish, and German.
Will we receive a certificate of completion?
At the end of the training you will receive a certificate of completion, which specifies the learned contents of the seminar.
Can my training be customized?
Yes it is possible, however it may generate additional cost depending on the magnitude of changes. We would like to discuss it case by case to find an optimal solution. If you are interested in developing a training based on your data drop us a line.
The level within my team varies. What can we do?
Before the training all participants are asked to take a short survey. This helps us in understanding better the level across your team beforehand. Additionally, we are flexible and will adjust to your needs as we go. The instructor can quickly recognize learning curve of the group and adjust the pace during the training. Usually 10% of the course outline is moderated during the training.
What is the difference between in-person training and real-time training?
In-person training means our trainer comes to your office to host the training. Therefore, having a dedicated room where all participants feel comfortable is important. Alternatively, in extraordinary circumstances, we could arrange a training location for your team but this would come at additional expense. The Real-Time Training takes place as scheduled online sessions either via Zoom, MS Teams, Webex, Hangouts or another software of your choice. This setup allows for scheduling flexibility, trainings of remote teams and direct screen sharing for the questions. Training content is the same for both.
What happens after I send a training request?
Once you inquire for the training offer, we will send you a pdf document with exact course outline and our offer.
If you like it, you confirm the booking via email and we block the training dates that suit you.
We follow-up with pre-training preparation, access links and all detailed information so that the training can run smoothly.