Excel - Bootcamp

• Understanding the power of pivot tables
• Pivot table structure
• Data design for pivot tables

• Adding fields and rearranging a pivot table report
• Incorporating data source changes
• Inserting a filter field and adding layers

• Changing the report layout and formatting
• Adding grand totals and multiple subtotals
• Changing the type of calculation used to summarize values
• Adjusting the display settings for calculated values

• Grouping dates and times, values, and text fields
• Using filters for row and column fields
• Filtering using the filters area, slicers and timelines
• Sorting in a pivot table

• Alternative methods for pivot table calculations
• Calculated fields and items
• Managing and maintaining pivot table calculations

• Creating and editing a pivot chart
• Applying conditional formatting within a pivot table
• Pivot chart limitations and alternatives

• Building a data model and managing relationships
• Adding and removing tables from the data model
• Building a pivot table using external data sources

• Understanding and choosing chart types
• Creating and customizing chart elements
• Exploring user interface choices for modifying charts
• Filtering and handling missing and hidden data
• Creating chart templates
• Applying best visualization practices

• Integration of dynamic elements into charts
• Applying area highlights
• Using conditional colors in charts
• Creating performance tracking and project control charts
• Time tracking with gantt charts and timelines
• Visualization with single data point charts

• Creating and customizing sparklines
• Specifying conditional formatting rules
• Using conditional formats that use graphics
• Conditional formatting with the REPT function

• Inserting form controls
• Linking form controls to data and graphs
• Creating scrollable tables
• Substituting form controls with slicers

• Entering and editing arithmetic, comparison, text, and reference formulas
• Formula operators and calculation settings
• Copying formulas and range references
• Working with external links
• Applying and using range names in formulas
• Troubleshooting formulas using formula auditing tools

• Understanding the structure of a function
• Finding the required function
• Adding intelligence with logical and information functions
• Combining functions for extended functionality

• Calculating central measures
• Identifying extreme values
• Creating frequency distributions

• Entering and editing single-cell and multicell array formulas
• Math array operations
• Comparative array operations and aggregate calculations
• Join array operations
• Array constants
• Array functions

• Data import and structuring
• Removing unwanted characters
• Converting and formatting text, concatenating data
• Searching and extracting substrings
• Filling and deleting gaps
• Removing duplicates

• Dealing with dates and times
• Date- and time-related functions

• Retrieving information with lookup functions
• Exact versus approximate lookups
• Looking up values to the left of a column
• Performing two-way lookups
• Performing multiple column lookups
• Case-sensitive lookups

• Tables and structured references
• Advanced filtering techniques and database functions
• Outlining and subtotals

We do not guarantee a specific instructor per course but we make sure your training is led by an expert in the field. Our trainers have experience across different industries and unique knowledge of applications of the analytical tools.

Everything. Really- no tricks here, it is the price excluding VAT. And it is the end price, no extra travel cost or allowance cost for the trainer, no location charges or other hidden traps. What you see is what you get.

It is common for the course participants to approach us with their specific problems based on 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.

Inhouse training (at your office) and Open registration trainings are conducted in English unless specifically agreed otherwise; however, support is provided in English, Dutch, Polish, and German.

At the end of the training you will receive a certificate of completion, which specifies the learned contents of the seminar.

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.

We are flexible and will adjust to your needs as we go. The instructor can quickly recognize the level and learning curve of the group and adjust the pace, cases and topics as needed during the training. Usually 10% of the course outline is moderated during the training.

Inhouse training means we come to your office to conduct 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 Open Registration means you join a training in one of our locations and join participants from different companies at a designated training location.

1. Once you inquire offer, we will send you a pdf document with exact course outline and summary of the price you have seen online.
2. If you like it, you confirm the booking via email and we block the training dates that suit you.
3. We follow-up with pre training preparation and setting up all the details so that the training can run smoothly.