Excel Advanced Training

DA

datatraining.io

DA

Excel
Advanced
Training

Excel Advanced
Become Excel Pro

OBJECTIVE:
Understand how to perform complex analysis with Excel and how to use advanced options to improve the analysis of the data.

DURATION:
14h split into 4 sessions (3.5h each)

FORMAT:
Real time Training Online. Access to online environment, call via Zoom, MS Teams or Webex.

TOPICS:

Advanced Pivot Tables and Charts
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
Changing the type of calculation used to summarize value
Adjusting the display settings for calculated values
Alternative methods for Pivot Table Calculations
Calculated fields and items
Creating, editing and conditionally formatting Pivot Chart
  Building a data model and managing relationships
Adding and removing tables for the data model

Grouping, sorting and filtering
   Grouping dates and times, values and text fields
Using filters for row and column fields
Filtering using the filter area, slicers and timelines
Sorting in Pivot Tables

Advanced Visualizations
Choosing the right chart type
Exploring user interface choices for modifying charts
Filtering and handling missing and hidden data
Creating chart templates
Applying best visualization practices
Integrations of dynamic elements into charts
Applying area highlights
Using conditional colors in charts
Creating performance tracking and project control chart
Time tracking with Gantt charts and timelines
Sparklines creation and customization
Conditional formatting with the REPT Function

Formulas and Functions
Review of formulas (arithmetic, comparison, text, reference)
Formula operators
Copying formulas and range references
Range names in formulas
Troubleshooting
Structure of functions
Adding intelligence with logical and information functions
Combining functions for extended functionality

Data Analysis
Calculating central measures, extreme values and creating frequency distributions

Array formulas
Math array operators
Comparative array operators and aggregate calculations
Join array operators
Constants and functions

Manipulating text and data cleaning
Data Import and structuring
Removing unwanted characters
Concatenating data
Searching and extracting substrings
Filling and deleting gaps
Removing duplicates

Working with dates and Times
Dealing with dates and times
Date and time related functions

Data Extraction and Validation
Retrieving information with lookup
Exact vs approximate lookups
Performing two-ways lookups
Multiple column lookups

ACCESS:
Training Call
Training Materials
Learning Path (over 6h of recorded content)
Additional optional assignments (2)
Possibility to ask questions ad hoc to the trainer at any point (email)

Bas Dohmen

datatraining.io

His background is in finance and he has worked as a BI consultant before.

Over the last 8 years he has been consulting on projects and training international teams in Power BI, Tableau and advanced Excel.
He is widely recognized in the Power BI community and has one of the fastest growing Power BI YouTube channels worldwide- How to Power BI.

Your country?

Your company size?

Your Profession?

I accept the Terms & Conditions

I would like to receive news, tips and tricks, and other promotional material

Forgot your password?

DA

datatraining.io

DA

Excel
Advanced
Training

For who?

Excel Expert Trainer

Bas Dohmen

datatraining.io

Click "Edit Contents" and start uploading your learning material.

Select a course first to display its contents.

No available contents for

Registro y Pago

Registro

Producto

There are no free, paid or coming soon courses in your school yet.
Why don't you create one?

The school owner is working hard preparing the courses for you.

Oops, you haven't created any courses yet.

No blog posts found in your blog. Why don't you create one?

DA datatraining.io

DA Excel AdvancedTraining

For who?

Excel Expert Trainer

Bas Dohmen

datatraining.io

Click "Edit Contents" and start uploading your learning material.

Select a course first to display its contents.

No available contents for

Registro y Pago

Registro

Producto

There are no free, paid or coming soon courses in your school yet.Why don't you create one?

The school owner is working hard preparing the courses for you.

Oops, you haven't created any courses yet.

No blog posts found in your blog. Why don't you create one?

DA

datatraining.io

DA

Excel
Advanced
Training

There are no free, paid or coming soon courses in your school yet.
Why don't you create one?