Get in Touch
 Duration 14 hours

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.
Investment

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)

Provisional Upcoming Courses (Contact Us For More Information)

Related Categories