Course Outline
Excel basics
• Creating and modifying styles
Building formulas
• Logical functions
• Mathematical functions
• Search functions
Organizing spreadsheet data
• Creating custom sort lists
• Data consolidation
• Creating outlines
• Managing page breaks
• Preparing printable versions
Building a PivotTable
• Fundamental concepts of pivot tables
• Overview of pivot table report fields
• Generating pivot table reports from data lists
• Adjusting the pivot table layout
• Field filtering techniques
• Modifying the calculation type of data fields
• Grouping data items within a pivot table
• Inserting additional calculations into the data area
• Adding calculated fields
• Adding calculated items
• Retrieving values from PivotTable reports
Generating charts and pivot charts
• Creating PivotCharts
• Switching chart types
• Designing custom chart types
• Adding trend lines to charts
• Updating values and modifying graph data
• Managing and modifying data series in charts
• Highlighting specific chart elements
• Data visualization through chart and data series manipulation
• Creating Pivot Charts from external database information
• Adjusting the PivotChart layout
• Changing the PivotChart type
• Filtering PivotChart fields
• Grouping PivotChart box elements
• Incorporating a data table into a PivotChart
Spreadsheet data processing
• Conditional formatting
• Custom cell formatting and mask creation
• Advanced conditional formatting
• Summarizing data using subtotals
• Creating scenarios
• Implementing data validation
• Designing custom cell formats
• Defining custom number formats
Handling external data sources
• Importing from Excel files
• Importing from CSV files
• Importing from websites
• Importing from local folders
Building interactive dashboards - Case study
Requirements
- Familiarity with Windows operating systems and basic MS Excel functionalities.
Audience
- Business analysts.
- Data analysts.
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 2900 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (7)
Excel cases from wnd day
Blazej - LKQ Polska Sp. z o. o.
Course - Excel Data Analysis
The instructor and the way he teach
Mohammad Almalek - Dubai Government Human Resources Department - DGHR
Course - Excel Data Analysis
the subject
Laila - Dubai Government Human Resources Department - DGHR
Course - Excel Data Analysis
His engage with the trainees & answer their questions.
sharifa alshehi - Dubai Government Human Resources Department - DGHR
Course - Excel Data Analysis
TRINER IS VERY GOOD
KHALID ALMUJAININ - Dubai Government Human Resources Department - DGHR
Course - Excel Data Analysis
practical nature and patience of trainer
Angela de Jong - Dubai Government Human Resources Department - DGHR
Course - Excel Data Analysis
Lots of practical exercises