Get in Touch
 Duration 10 hours

Course Outline

Excel Fundamentals

  • Gaining insight into the Excel user interface
  • Inputting and modifying data
  • Applying essential formatting options

Core Spreadsheet Capabilities

  • Managing rows, columns, and multiple worksheets
  • Executing basic formulas and calculations
  • Utilising copy, fill, and auto-complete features

Fundamentals of Data Visualisation

  • Constructing standard charts
  • Personalising chart components
  • Choosing the most appropriate chart type for your data

Intermediate Formulas and Functions

  • Implementing logical functions
  • Manipulating text and date functions
  • Differentiating between absolute and relative cell references

Data Organisation and Analysis

  • Sorting and filtering datasets
  • Operating with structured tables
  • Applying conditional formatting rules

Advanced Excel Features

  • Summarising data using PivotTables
  • Visualising insights with PivotCharts
  • Utilising advanced lookup functions

Automation and Efficiency Tools

  • Developing and executing macros
  • Capturing repetitive procedures
  • Exploring introductory VBA concepts

Professional Reporting Methods

  • Structuring worksheets effectively
  • Developing reusable templates
  • Adhering to best practices for data presentation

Wrap-up and Subsequent Steps

Requirements

  • Familiarity with general computer operations
  • Experience with standard office productivity applications
  • A keen interest in developing spreadsheet competencies

Target Audience

  • Corporate professionals
  • Administrative personnel
  • Individuals requiring spreadsheet expertise for everyday tasks

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 (2)

Provisional Upcoming Courses (Contact Us For More Information)

Related Categories