Course Outline
Excel Fundamentals
• Creating and modifying styles
Building Formulas
• Logical functions
• Mathematical functions
• Search functions
Organising Data in Spreadsheets
• Creating custom sort lists
• Data consolidation
• Creating outlines
• Page breaks
• Printable versions
Creating PivotTables
• Fundamental information regarding pivot tables
• Overview of pivot table report fields
• Generating a pivot table report from a data list
• Adjusting the pivot table layout
• Field filtering
• Modifying the calculation type of a data field
• Grouping pivot table data items
• Inserting additional calculations into the data area
• Adding calculated fields
• Adding calculated items
• Retrieving values from a PivotTable report
Designing Charts and Pivot Charts
• Creating PivotCharts
• Altering the chart type
• Developing custom chart types
• Adding trend lines to charts
• Inserting new values and modifying data for graphs
• Data series and their adjustment in charts
• Emphasising chart elements
• Data visualisation on charts - manipulating data series
• Creating a Pivot Chart from information sourced from an external database
• Modifying the PivotChart layout
• Changing the PivotChart type
• Filtering PivotChart fields
• Grouping PivotChart box elements
• Adding a data table to a PivotChart
Data Processing in Spreadsheets
• Conditional formatting
• Custom cell formatting - creating a mask
• Custom conditional formatting
• Summarising data using subtotals
• Creating scenarios
• Data validation
• Creating custom cell formats
• Defining personal number formats
Handling Data from External Sources
• Importing from an Excel file
• Importing from a CSV file
• Importing from a website
• Importing from a folder
Building Interactive Dashboards - Case Study
Requirements
- Familiarity with Windows and the fundamentals of MS Excel
Audience
- Business analysts
- Data analysts
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customised 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 £3200 + 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