Get in Touch

Course Outline

Basic Information About the Excel Program

  • Excel Data Types – How Excel Handles Dates and Times
  • Searching for Values in a Spreadsheet – Find and Select
  • Worksheet Protection
  • Data Validation
  • Creating Data Series
  • AutoCorrect
  • Flash Fill
  • Go To Special
  • Paste Special
  • Text to Columns
  • Quick Access Toolbar
  • Best Practices for Creating Spreadsheets
  • Keyboard Shortcuts
  • Cell Formatting
  • Conditional Formatting

Creating Formulas

  • Inserting Functions
  • Editing Formulas
  • Logical Functions
  • Mathematical Functions
  • Lookup Functions
  • Text Functions
  • Date and Time Functions
  • Summing Cell Contents Using the AutoSum Button
  • Adding Functions Using the Dialog Box
  • Formula Auditing
  • Determining Value Location
  • Defining Names for Ranges
  • Modifying Named Ranges
  • Utilising Named Ranges in Formulas

Creating PivotTables

  • Basic Information About PivotTables
  • Reviewing PivotTable Report Fields

Creating Charts and PivotCharts

  • Creating PivotCharts
  • Changing Chart Type

Requirements

Familiarity with the Windows operating system and basic proficiency in Microsoft Excel

 14 Hours

Number of participants


Price per participant

Open Training Courses require 5+ participants.

Testimonials (7)

the trainer's patience,

Agata Halubicka - Sad Rejonowy w Krosnie Odrzanskim
Course - Microsoft Office Excel - poziom średnio zaawansowany

communication beween teacher and us

Julia Hudziak - LKQ Polska Sp. z o. o.
Course - Microsoft Office Excel - poziom średnio zaawansowany

The interaction of the trainer with the trainees

- NEVEON Romania
Course - Microsoft Office Excel - intermediate level

I liked the presentation style for each module and the fact that it was very clear and easy for everyone to understand :)

Denisa - NEVEON Romania
Course - Microsoft Office Excel - intermediate level

scope of material

Marcin - Instytut Energetyki- Panstwowy Instytut Badawczy
Course - Microsoft Office Excel - poziom średnio zaawansowany

good pace and great advice

Kacper - Instytut Energetyki- Panstwowy Instytut Badawczy
Course - Microsoft Office Excel - poziom średnio zaawansowany

A lot of practical exercises

Olena - Alfa Laval
Course - Microsoft Office Excel - poziom średnio zaawansowany

Upcoming Courses

Microsoft Office Excel - intermediate level

2026-10-16 09:30
14 hours
København, Copenhagen
3472 EUR (Online)
3872 EUR (Classroom)

Microsoft Office Excel - intermediate level

2026-10-30 09:30
14 hours
Copenhagen, City Center
3472 EUR (Online)
3872 EUR (Classroom)

Microsoft Office Excel - intermediate level

2026-11-13 09:30
14 hours
København, Copenhagen
3472 EUR (Online)
3872 EUR (Classroom)

Microsoft Office Excel - intermediate level

2026-11-27 09:30
14 hours
Copenhagen, City Center
3472 EUR (Online)
3872 EUR (Classroom)

Microsoft Office Excel - intermediate level

2026-12-11 09:30
14 hours
København, Copenhagen
3472 EUR (Online)
3872 EUR (Classroom)

Related Courses

Working with spreadsheet in Microsoft Excel

 14 Hours
This hands-on Excel course in Denmark encompasses data entry, formatting, formulas, functions, and chart creation. Learners will master efficient calculation techniques, spreadsheet task automation, and strategies to protect sensitive data from unauthorized access or inadvertent modifications.
Read more...

Excel Advanced with VBA

 21 Hours
This Excel Advanced with VBA course in Denmark focuses on optimizing data management through advanced formulas and VBA automation. Participants will learn to build custom functions, design forms, and streamline workflows using macros and external data integration to enhance productivity.
Read more...

Visual Basic for Applications (VBA) in Excel (intermediate level)

 14 Hours
This guided training in Denmark assists Excel users in refining their VBA capabilities to an intermediate standard. Participants will design custom interfaces, gain command over complex data types, and implement robust error prevention and diagnostic strategies. It is well-suited for professionals aiming to streamline workflow automation.
Read more...

Microsoft Office Excel - working effectively with the spreadsheet

 14 Hours
Achieve Excel mastery through this 14-hour training session based in Denmark. Develop expertise in advanced formulas, formatting, charting, and PivotTables to significantly enhance productivity. This course is ideal for professionals looking to refine their data analysis and reporting skills, moving effectively from an intermediate to an advanced level.
Read more...

Visual Basic for Applications (VBA) for Analysts

 21 Hours

This instructor-led, live training in Denmark (delivered online or onsite) is tailored for beginner-level analysts who intend to use Excel VBA to automate repetitive tasks, clean and transform data, and optimize reporting workflows.

By the end of the course, participants will be able to: record and edit macros, write basic VBA procedures, work with Excel objects for reporting purposes, and debug fundamental automation solutions.

Read more...

Analysing Financial Data in Excel

 14 Hours
Gain proficiency in advanced Excel techniques for financial analysis, such as INDEX-MATCH, PivotTables, VBA, and Solver, delivered in Denmark. Develop expertise in Goal Seek, database queries, and external data integration to automate processes and convert raw data into actionable insights and forecasts.
Read more...

Excel Basics

 14 Hours
Acquire core Microsoft Excel competencies in this introductory training in Denmark. The program addresses data input, styling, formulas, functions, tables, and visual representation, enabling participants to establish a solid base for data analysis and reporting in practical work scenarios.
Read more...

Microsoft Excel (Basic, Intermediate, and Advanced)

 28 Hours

This live, instructor-led training in Denmark (delivered online or on-site) is designed for data analysts at all levels. It aims to equip participants with the skills to use Excel for various tasks, from data entry and formula creation to complex analysis and automation.

By the end of the session, you will be able to:

  • Move confidently through the Excel interface to manage basic data entry, formatting, and calculations.
  • Implement advanced formulas, functions, and conditional formatting for deeper analysis.
  • Build and control pivot tables and charts to visualize data effectively.
  • Employ Power Query and Power Pivot tools for sophisticated data processing.
  • Streamline operations by automating tasks using macros and VBA.
Read more...

Excel: Basic, Intermediate, Advanced

 10 Hours
This instructor-led Excel training in Denmark takes users from basic data entry through to advanced automation. Learners will gain mastery over formulas, PivotTables, and VBA via practical exercises. It is an ideal choice for those aiming to strengthen their professional reporting and analytical skills.
Read more...

Excel Data Analysis

 14 Hours

This instructor-led, live training in Denmark (online or onsite) is designed for business and data analysts ranging from beginner to intermediate levels who aim to utilize Excel for data analysis and reporting in their professional projects.

By the conclusion of this training, participants will be capable of:

  • Using Excel formulas and functions to perform calculations and data manipulation.
  • Applying Excel data analysis tools like PivotTables, What-If Analysis, and Forecasting to summarize and visualize data.
  • Using Excel charts and graphs to create and customize data visualizations.
  • Applying Excel data validation and conditional formatting to ensure data quality and highlight insights.
  • Using Excel data import and export features to connect with external data sources and share data.
Read more...

Financial Analysis in Excel

 14 Hours
Elevate your financial analysis capabilities with this comprehensive Excel course in Denmark. Acquire mastery of advanced functions, pivot tables, and external data workflows while exploring real-world applications such as the time value of money, forecasting models, and securities analysis to enable data-driven decision-making.
Read more...

Excel and Google Sheets

 14 Hours

This live, instructor-led training in Denmark, offered online or on-site, targets professionals from beginner to intermediate levels. It is tailored for those looking to enhance their productivity and efficiency by harnessing the advanced features of Excel and Google Sheets for data organization, analysis, and collaboration.

Upon completion, participants will be able to:

  • Master the navigation and utilization of core features in Excel and Google Sheets.
  • Execute data analysis and generate actionable insights via advanced spreadsheet methods.
  • Engage in real-time collaboration using Google Sheets to streamline teamwork.
  • Design reusable templates for effective reporting, tracking, and project management.
Read more...

Excel for Inventory, Budgeting, and Data Analysis

 14 Hours
This live training in Denmark is tailored for intermediate Excel users seeking to excel in inventory control, budgeting, and reporting. Discover how to process datasets with over 5,000 rows by utilizing formulas, pivot tables, and macros. Develop practical competencies in a hands-on lab setting to streamline task automation.
Read more...

Excel Modelling

 7 Hours
Join this live Excel modelling training in Denmark to build powerful data analysis skills. Learn structured problem-solving, advanced functions, and model design principles. Participants gain hands-on experience creating scalable models for scenario analysis and effective business reporting.
Read more...

Excel to Power BI

 7 Hours

This instructor-led live training, available online or on-site in Denmark, is designed for data analysts looking to enhance their ability to prepare data in Excel and visualize it in Power BI.

By the end of the session, participants will have the capability to:

  • Comprehend the underlying principles, objectives, and approaches of data analysis.
  • Leverage DAX formulas in Power BI for advanced calculation tasks.
  • Develop and apply targeted visualizations and charts for specific analytical cases.
  • Use Power View to import data, enabling a shift from Excel-based Power BI to independent Power BI usage.
Read more...

Related Categories

Excel
Excel