Description

Microsoft Excel Diploma Switzerland

Microsoft Excel Diploma

Most careers require at least a basic understanding of Microsoft Excel, while many professional roles require advanced Excel skills. The Microsoft Excel Diploma enables learners to develop advanced Excel capabilities that can support career progression across a wide range of industries.

Souters offers learners the opportunity to gain a recognised professional qualification through the CPD Standards Institute: the Microsoft Excel Diploma.

The Microsoft Excel Diploma combines all levels of Excel training:

  • Beginner Level
  • Intermediate Level
  • Advanced Level

Our accredited online training programme provides an in-depth understanding of Microsoft Excel and helps learners develop the confidence to use Excel effectively in the workplace.

Participants from across Switzerland and further afield can join this flexible online programme and study at a pace that suits their schedule.

Diploma Format

The Diploma is delivered through an interactive online learning system designed to maximise engagement and practical learning.

All training materials have been developed by Microsoft Platinum Partners.

The learning platform includes a Virtual Tutor who:

  • Provides instruction throughout the programme
  • Guides learners through exercises
  • Offers corrections and feedback
  • Supports practical skill development

This state-of-the-art learning system provides a highly interactive experience that helps learners transfer their knowledge directly into the workplace.

Course Content

1. Beginner Level – Excel

Getting Started with Excel

  • Essential workbook functions
  • Introduction to Excel functionality

Formatting in an Excel Workbook

  • Formatting fonts
  • Formatting cells
  • Borders, colours and highlighting

Editing and Formatting Data

  • Copying, cutting and pasting
  • Formatting improvements

Calculations in Excel

  • Creating formulas
  • Basic calculations
  • SUM and essential functions
  • Reproducing data in adjacent cells

Improving Efficiency

  • Numerical formats
  • Spell checking
  • Find and Replace

Working with Rows, Columns and Cells

  • Inserting, deleting and moving rows, columns and cells
  • Copying to non-adjacent cells
  • Merging cells
  • Changing cell styles
  • Changing text orientation

Printing and Page Layout

  • Page layout
  • Print preview and printing
  • Headers and footers
  • Repeating row and column headings
  • Hiding sheet elements
  • Page breaks and print areas

Workbook Management

  • Introduction to tables
  • Sorting data
  • Customising presentation
  • Working with dates

Tables and Charts

  • Subtotal rows
  • Advanced filtering options
  • Splitting windows
  • Freezing rows and columns

2. Intermediate Level – Excel

Increasing Efficiency

  • Excel Help
  • Spell checking
  • Find and Replace
  • Moving and copying cells
  • Working with cell formatting and styles

Managing Worksheets

  • Multiple worksheets
  • Sheet naming and colours
  • Inserting and deleting sheets
  • Copying, moving and hiding sheets
  • Splitting windows and freezing panes

Advanced Tables, Formulas and Functions

  • Merging and wrapping text
  • Absolute references
  • Linked data
  • Transposing data
  • Date functions
  • Conditional calculations
  • Custom formats
  • Conditional formatting
  • Named ranges
  • Data validation
  • Multiple ranges and calculations

Charts and Data Presentation

  • Creating and managing charts
  • Formatting charts
  • Managing chart labels and axes
  • Sparklines

Visual Elements in Excel

  • Drawing objects
  • Text boxes
  • Pictures and images
  • Object alignment, grouping and formatting

Database Functionality

  • Automatic calculations
  • Automatic filtering
  • Custom filters
  • Duplicate and blank cell management
  • Advanced filtering
  • Criteria ranges
  • Statistical calculations
  • Flash Fill

3. Advanced Excel Module

  • Pivot Tables
  • Pivot Charts
  • Advanced Formulas
  • VLOOKUP
  • Date Functions
  • IF Statements
  • AND and OR Functions
  • Nested Functions
  • Array Formulas
  • Conditional Formulas
  • Scenarios
  • Goal Seek
  • Advanced Functions
  • Auditing and Error Checking
  • Templates and Themes
  • Workbook Protection
  • Workbook Sharing

Accreditation

We are a Certified Microsoft Office Academy.

The Microsoft Excel Diploma is CPD Accredited.

Upon successful completion, participants receive a CPD Accredited Microsoft Excel Diploma.

Benefits

  • Training developed by senior Microsoft trainers from a Microsoft Certified Academy
  • CPD Accredited Microsoft Excel Diploma
  • Internationally recognised professional qualification
  • Interactive virtual learning supported by a Virtual Tutor
  • Practical exercises designed to develop workplace-ready skills
  • Comprehensive training from Beginner to Advanced level
  • Improved confidence when using Excel professionally
  • Enhanced employability and career opportunities
  • Professionally accredited qualification that strengthens your CV

Outcome

CPD Accredited Microsoft Excel Diploma

Successful participants receive a CPD Accredited Microsoft Excel Diploma demonstrating proficiency from Beginner through to Advanced Excel levels.

Switzerland and International Participants

This programme is suitable for participants based across Switzerland and internationally. Whether you are located in Zurich, Geneva, Basel, Lausanne, Bern, Zug, Lucerne, St. Gallen or elsewhere, you can access the training online from any location.

The flexible learning format allows learners to develop advanced Microsoft Excel skills while balancing work, study and personal commitments, making it ideal for professionals seeking to improve productivity, reporting and data analysis capabilities.