ContactDEEN
Discuss your ambitions

Management & Administration

Excel and AI: automate analysis and build useful dashboards

Build a more reliable path from raw spreadsheets to information you can use. Combine Excel, Power Query and suitable AI assistance to prepare data, develop formulas, analyse performance and create clear dashboards. Work through practical cases, validate calculations and design refresh routines that a colleague can understand and maintain.

Request information

YOUR PROGRAMME AT A GLANCE

For individuals & organisations
Start date
Choose your start date

We agree a start that fits your professional and personal commitments.

Programme duration
3, 7 or 12 months

OSAM certificates: according to your starting level and learning goals. Company group programmes are usually planned in days or half-days.

Learning format
In person or live online

Synchronous teaching. Both formats include the OSAM platform for course materials and organisational information.

Qualifications
OSAM certificate

From an eduQua-certified institution.

Fees
Contact us

An individual quotation confirms the programme, delivery format and applicable fees.

Expert practitioners
High-level professional experience

Highly personalised teaching with experienced practitioners working at a high professional level.

FROM KNOWLEDGE TO CAPABILITY

What you will be able to do.

Administrative, finance, sales and operations professionals, managers and anyone who regularly prepares Excel reports. The programme suits learners who already work with basic spreadsheets and want to develop more efficient, transparent analysis without relying on unexplained AI-generated results.

  • Translate a business question into defined indicators and a suitable table structure
  • Identify missing values, inconsistent formats and duplicates before analysis
  • Develop and explain formulas with AI assistance and targeted verification
  • Use Power Query to make suitable import and transformation steps repeatable
  • Build clear PivotTable analyses, charts and dashboards with traceable figures
  • Document refresh procedures, quality checks and responsibilities for recurring reports

YOUR LEARNING JOURNEY

A structured programme. Room for your priorities.

These modules form the core programme. Where useful, we refine the emphasis, examples and learning activities to reflect your professional context, starting point and objectives.

01

Start with the question and the indicator

Define the decision your analysis should support before creating a dashboard. Specify each indicator, its calculation, time period and source. Use examples from administration, finance or sales to distinguish meaningful comparisons from attractive but unhelpful figures. Set the scope of the workbook and the checks needed to trust its output.

02

Prepare tables that can be analysed

Organise data with clear headers, consistent types and one observation per appropriate row. Detect duplicates, missing values, inconsistent categories and ambiguous dates. Record how issues are resolved rather than silently replacing them. Create a clean working table while retaining access to the original source for comparison and later corrections.

03

Use AI to develop and explain formulas

Describe the required calculation, table structure and expected result to an approved AI tool or available Copilot feature. Review suggested formulas and ask for explanations of references and conditions. Test ordinary cases, empty cells and exceptional values against known results. Keep formulas understandable enough for you or a colleague to maintain.

04

Power Query: repeat useful preparation steps

Import an appropriate file or table, choose data types and apply transformations through Power Query where supported. Practise combining compatible sources and inspect each recorded step. Compare the prepared output with the original totals. Build a repeatable process for recurring files, while accounting for the connectors and refresh options available in your Excel environment.

05

Analyse with PivotTables and clear comparisons

Use suitable summaries and PivotTables to explore categories, periods and changes. Check aggregation choices so that averages, counts and totals answer the intended question. Investigate outliers and reconcile key figures with the source. Use AI assistance to explore interpretations, then distinguish evidence in the data from explanations that still need investigation.

06

Design dashboards people can read

Select a small number of indicators and charts that serve the intended audience. Clarify units, periods, filters and comparison points. Assemble a readable worksheet with useful visual hierarchy instead of decorative complexity. Test whether another person can understand the main finding, identify its source and see important limits without additional explanation.

07

Refresh, check and maintain reports

Define how data arrives, when the report is refreshed and who checks the result. Practise handling a changed column, missing file or unexpected total. Document connections, credentials ownership and dependencies without exposing secrets. Establish a refresh checklist and a clear handover so that the reporting process remains usable beyond the initial exercise.

08

Complete an analysis from source to decision

Develop a complete workbook using a relevant fictional or authorised dataset. Present the business question, preparation steps, calculation controls and dashboard. Explain what the results support and what they do not establish. Compare the completed process with the previous method and choose practical improvements based on accuracy, maintainability and effort.

THE PEOPLE BEHIND YOUR PROGRESS

Expertise, with a personal connection.

Educational direction, subject expertise and adult learning support. Your final trainer assignment is confirmed in your proposal.

Simon Pawolleck

DIRECTOR’S PERSPECTIVE

Simon Pawolleck

Managing Director

Simon Pawolleck provides OSAM’s overall direction. The focus is on relevant skills, a clear learning structure and personal support that connects professional ambitions with practical progress.

Sébastien Brunelle

EXPERT’S PERSPECTIVE

Sébastien Brunelle

AI expert · OSAM expert network

Sébastien Brunelle is presented as a relevant expert from the OSAM network. The course trainer will be confirmed for your programme. Subject expertise supports practical cases, focused feedback and applications related to your working context.

Sandrine Mélé

ADULT LEARNING & ANDRAGOGY

Sandrine Mélé

Head of Adult Learning

Federal Diploma of Higher Education in Adult Education

Sandrine Mélé oversees the adult learning approach: coherent progression, active participation and learning methods that take account of prior experience. She supports a structured, practical and human approach to developing competence.

300+

Expert practitioners

Active at a high professional level, selected against demanding criteria.

700+

Companies supported

Developing the skills of their employees with OSAM.

4.8/5

Learner satisfaction

An experience centred on the people who learn with us.

Individuals & companies

Personal career goals. Shared organisational priorities.

eduQuaSERI / SEFRI

eduQua-certified institution. Federal qualifications listed by SERI in selected pathways.

GOOD TO KNOW

Your questions, answered.

Who is this programme for?

Administrative, finance, sales and operations professionals, managers and anyone who regularly prepares Excel reports. The programme suits learners who already work with basic spreadsheets and want to develop more efficient, transparent analysis without relying on unexplained AI-generated results. The programme is available to private individuals and organisations, including company teams. OSAM welcomes learners living or working in Switzerland as well as international participants joining live online.

How is this qualification recognised?

OSAM is an eduQua-certified continuing education institution. An OSAM certificate documents the learning agreed for your programme; eduQua is a quality label for the institution, not federal recognition of every individual course.

OSAM’s work connects individual professional development with the needs of companies in Switzerland and internationally. Client references and learner reviews below offer a practical view of that work.

What are the benefits of this programme?

You develop skills you can apply in real situations, with guidance from experienced practitioners and access to learning materials on the OSAM platform. The programme focuses on these outcomes:

  • Translate a business question into defined indicators and a suitable table structure
  • Identify missing values, inconsistent formats and duplicates before analysis
  • Develop and explain formulas with AI assistance and targeted verification
  • Use Power Query to make suitable import and transformation steps repeatable
  • Build clear PivotTable analyses, charts and dashboards with traceable figures
  • Document refresh procedures, quality checks and responsibilities for recurring reports
Can the programme be personalised?

Yes. We start with the established programme and refine the emphasis, practical cases and learning support where useful. Adjustments take account of the individual or company’s professional context, existing skills and goals. The agreed programme is confirmed before enrolment; federal examination requirements remain binding where applicable.

What are the entry requirements?

For the OSAM certificate, contact us to review your current level, prior experience and objectives. We will confirm the appropriate entry requirements and any recommended preparation.

What Excel knowledge should I have before starting?

You should be comfortable entering data, navigating worksheets and using basic formulas. We assess your starting point and can include a refresher on tables and cell references. Advanced statistics or programming are not required for the core pathway; more demanding cases are agreed according to your objectives.

Do I need Copilot in Excel for every exercise?

The programme combines standard Excel methods with suitable AI assistance. Copilot features depend on the account, licence, application version and organisation settings. We confirm your environment before the course and adapt the exercises accordingly. Any software access or licence costs must be agreed; they are not automatically included.

Microsoft · Copilot in Excel FAQ
Will I learn automatic reporting with Power Query?

You learn to make appropriate preparation steps repeatable and to refresh supported connections. Power Query features and available data sources vary across Excel environments. We establish the suitable workflow for yours, including checks and maintenance; the course does not promise unattended refresh of every file or system.

Microsoft · About Power Query in Excel
How do we avoid errors in AI-assisted analysis?

You work with defined indicators, source comparisons and test cases rather than accepting a plausible answer. Formulas, totals, exceptional values and charts are reviewed. Important conclusions are traced back to the data and assumptions. Decisions remain with the responsible person, especially where figures affect financial or operational commitments.

YOUR CAREER, IN PERSPECTIVE

Where could these skills take you?

Depending on your experience and qualifications, this subject can support development in the following professional directions.

Explore Swiss salaries on Salariostat
  • Reporting coordinator
  • Finance assistant
  • Sales operations specialist

Access to a profession depends on your experience and on any qualifications or authorisations required for the role.

YOUR NEXT STEP

Your ambitions. Our starting point.

Tell us where you want to go. Together, we will define the learning journey that gets you there.

info@osam-academy.com+41 31 528 01 28
OSAM+
No obligation. We use your details to respond to your enquiry. Privacy notice