Top ratings
Get free trial access now Try first, then study!
4.92/5.0 (from 386 Trusted Shops Reviews )
4.9/5.0
- Google reviews
MS - Excel Basics & Advanced
starting at €780,- | Online Course
» Our Course Packages
Flexible learning - our possible learning options for the course:
Important informations
MS - Excel Basics & Advanced
Course Fee: from €
780,-
Including Exam Fees and Study Materials
Installment Plans Available
No Interest, No Fees
No Interest, No Fees
Information Event
Entry possible at any time
Course Upgrades
Add Another Course
Add Another Course
Academy account forever
learning materials available for life
learning materials available for life
Money-back guarantee
14 days right of withdrawal (according to the Distance Selling Act)
14 days right of withdrawal (according to the Distance Selling Act)
Sound scientific content
Certificate valid worldwide & unlimited in time
Certificate valid worldwide & unlimited in time
Recognized & Certified
Our graduates, partners & friends say
Our team will be happy to advise you at any time by phone, chat or in person
MS Excel
Grundlagen & Vertiefung
Master Excel: From basic knowledge to advanced techniques
Excel is much more than just a spreadsheet program. It is a powerful tool that helps you to manage, analyse and visualize data efficiently. With our "Excel Basics and Advanced" courses, you will acquire comprehensive skills to use your data professionally and make well-founded decisions.
Excel is one of the world's most widely used programs for data analysis and management. It enables you to easily structure, analyze and present complex data sets in an appealing way. Knowledge of Excel opens doors to a wide range of professional opportunities, whether in project management, controlling, marketing or other data-intensive areas. The course is practice-oriented and contains numerous examples and exercises so that you can immediately apply and consolidate what you have learned.
Excel is one of the world's most widely used programs for data analysis and management. It enables you to easily structure, analyze and present complex data sets in an appealing way. Knowledge of Excel opens doors to a wide range of professional opportunities, whether in project management, controlling, marketing or other data-intensive areas. The course is practice-oriented and contains numerous examples and exercises so that you can immediately apply and consolidate what you have learned.
Factsheet on the course
Extent of learning
275 E
3
EQF level
The training is based on EQF level 3 »
Course start
Possible immediately
Learning variant
Online Courses
Available
Languages
DE
EN
ES
Everything at a glance!
MS - Excel Basics & Advanced
Excel Basics and Advanced: Your key to data analysis
Expand your skills and immerse yourself in the world of data analysis with our Excel Basics and Advanced course . Whether you're just starting out or already have experience with Excel, this course will give you the knowledge you need to use Excel effectively and perform complex data analysis. Learn hands-on and at your own pace with numerous examples and exercises to help you apply and consolidate what you have learned immediately.
This course provides you with comprehensive knowledge, from the basics to advanced techniques for editing spreadsheets and formatting. You will learn how to apply conditional formatting and user-defined number formats, use functions from different categories (logic, statistics, financial mathematics, mathematics) and create and design charts using advanced techniques. You will also learn how to analyze, filter and sort tables and lists, create and use scenarios, define validity rules for data and check formulas.
What can you expect from our training?
The course content includes an introduction to the basics of Excel, where you will learn the basic operation and the most important functions. You will be introduced to Excel's , including creating and managing complex tables, applying advanced formatting and analysis techniques and automating tasks with macros.
Topics include:
- Advanced spreadsheet editing and formatting techniques, e.g. conditional formatting, custom number formats.
- Application of functions from different categories such as logic, statistics, financial math and mathematics.
- Creation and design of diagrams using advanced techniques.
- Analyzing, filtering and sorting tables and lists; creating and using scenarios.
- Defining validity rules for data and checking formulas.
- Increase productivity by working with range names and macros.
- Linking, embedding and importing data.
- Merging and comparing workbooks; applying measures to protect spreadsheets.
Who is the course suitable for?
This course is ideal for beginners who have little or no experience with Excel, as well as advanced users who want to expand their knowledge. Professionals who regularly work with data and want to improve their data analysis skills will also benefit from this course.
Would you like to learn about other word processing or presentation programs? Then why not take our MS - Word Basics & Advanced or MS - PowerPoint Basics & Advanced course .
Conditions of participation
- Online or written registration
- Basic computer skills are recommended but not required
- Minimum age 18 years (for participants under 18 years, written parental consent is required for registration)
- Access to an internet-enabled device
- Access to a stable internet connection
Certificate of completion
Our certificates are valid worldwide and are issued in different versions. On request, you can receive our certificate in several languages, with country-specific information and with or without printed grades.
All of these variants are available to you free of charge for a lifetime for downloading from your online campus. In addition, depending on the learning package you have purchased, you will receive a certificate of your choice, which will be issued on special high-quality embossed paper.
The following certificate is awarded:
"Excel - Basics and Advanced"
Do you have specific questions about the training?
We will be happy to help you by phone, e-mail or chat.
Procedure & duration - how your training is structured
The training consists of several modules
You can find the list of modules and subjects by clicking on the "Course content" tab.
Duration of the training
As our training courses can be designed very flexibly, the duration of the training depends heavily on your own learning initiative, the amount of time you spend each week and your previous knowledge. Depending on how much time you can invest and how quickly you absorb the required knowledge, it is also possible to complete the training more quickly.
Online live training via Zoom
The training is conducted live online via Zoom. The instructors teach in real time and share their screen so that you can follow the lessons from the comfort of your own home. You have access to all dates and the link to the live webinar via the Online Campus, so you can easily participate from home.
You will receive the Zoom meeting link by e-mail before the start of the course and it will also be available on our Flexyfit learning platform. Please make sure that you have entered your current e-mail address when registering.
With online distance learning courses, you set the tone
Learn at your own pace, when and where you want. The Academy account accompanies you on your computer, tablet or smartphone and includes everything you need for the course.
You decide how you learn
You can choose from a wide range of Full HD learning videos in which our top instructors teach you the training content. You can also read the content in our scripts and presentations.
No pain, no gain
You will work your way through a variety of compulsory and additional tasks. These include applying conditional formatting, creating user-defined number formats, applying functions from various categories and creating and designing diagrams. All tasks are explained in a step-by-step guide so that you can apply what you have learned in a practical way.
Last but not least... Exams
You can expect lots of multiple choice online exams to test your knowledge. You can take a test exam before each exam to be optimally prepared.
Detailed Course Contents
Extent of learning
275 E | Volume
EDK
187
IT competence
RE
4
Literature research
LE
80
Self-study (learning units)
AE
4
Additional tasks & examinations
This training is suitable for educational leave. The individual review and approval is subject to the respective funding agency. For more detailed information on the duration and procedure of educational leave, please contact us directly! Book a consultation appointment now.
Participation in the face-to-face webinars is mandatory for educational leave and must be proven to the AMS. Confirmation of attendance must be requested on the participant's own responsibility. Confirmation of attendance of the face-to-face webinar will only be issued during each webinar if requested by the participant.
Module MS Excel basics
Show all chapters of the subjects
Data organization and analysis
In this subject, we focus on how you can organize and analyze your data efficiently. This is crucial for keeping large amounts of data organized and finding relevant information quickly.
Sorting and filtering data: You will learn how to sort and filter data in Excel to extract specific information. This includes sorting according to various criteria such as numbers, texts or dates. You will also learn how to apply filters to display only the data that is relevant to your analysis.
Using the autofilter: The autofilter is a powerful tool for filtering data quickly and easily. You will learn how to activate and use the autofilter to keep complex data sets organized. You will learn how to customize filters and apply multiple criteria simultaneously.
Partial results: Partial results are an efficient way to calculate subtotals and other aggregated data within a large data set. You will learn how to insert and configure partial results to simplify your data analysis. This will help you to quickly identify important summaries and trends.
Using these techniques, you will be able to organize and analyze large amounts of data efficiently. You can quickly filter out relevant information and carry out your data analysis precisely and efficiently.
- DATA
- Sort
- Filter
- Using the auto filter
- Calculating partial results
- Apply multiple filter criteria
Show chapter
Diagrams and data visualization
In this subject, you will learn how to visualize your data in Excel. Charts and graphs are crucial for presenting data clearly and recognizing important information at a glance.
Create and edit charts: You'll learn how to create different types of charts in Excel, including column, line, pie and bar charts. We'll show you how to edit and customize charts to present your data accurately and attractively.
Use chart recommendations: Excel offers you chart recommendations based on your data. You will learn how to use these recommendations to create suitable charts quickly and easily. This helps you to visualize your data efficiently without spending a lot of time choosing the right chart type.
Display data with sparklines: Sparklines are small charts embedded in cells that make trends and patterns in your data visible at a glance. You will learn how to create and customize sparklines to visualize your data in a compact and effective way.
With these skills, you will be able to present your data clearly and professionally. You will be able to use different chart types to highlight important information and support your data analysis.
- BASICS
- Creating diagrams
- Editing and customizing diagrams
- Using chart recommendations
- Displaying data with sparklines
- DIFFERENT CHART TYPES
- Bar charts
- line charts
- pie charts
- bar charts
Show chapter
Introduction to the Excel working environment
In this subject you will get to know the basic working environment of Excel. The focus is on providing you with a solid foundation on which you can build to use Excel efficiently and effectively.
Overview of the user interface: You will receive a detailed overview of the Excel user interface. This includes an explanation of the various elements, such as the ribbon, the quick access toolbar and the workbook. You will learn how to move around in Excel, open and close worksheets and switch between different views.
Menus and tools: We will guide you through the various menus and tools that Excel offers. You will learn how the tabs in the ribbon are structured and which functions are hidden behind the respective tabs. From file operations and data analysis tools to charting and formatting options - you will learn where to find which tools and how to use them.
Customize the status bar: The status bar at the bottom of the Excel window gives you important information at a glance. You will learn how to customize the status bar to display exactly the information you need, e.g. sum, average or number of selected cells. This helps you to work more efficiently and access relevant data quickly.
Important basic functions: We will show you the most important basic functions to help you get started with Excel. This includes basic operations such as creating, saving and opening workbooks. You will learn how to enter data in cells and perform simple calculations. We also explain how to carry out basic formatting to make your data clear and appealing.
This comprehensive introduction to the Excel working environment will lay the foundations for your future work with this powerful tool. You will be able to navigate confidently in Excel, use the most important functions and manage and edit your first data efficiently.
- OVERVIEW OF THE USER INTERFACE
- Menus and tools
- Customize status bar
- Workbooks
- IMPORTANT BASIC FUNCTIONS
- Creating, saving and opening workbooks
- Basic formatting and calculations
Show chapter
Formulas and functions
This subject teaches you the basics of working with formulas and functions in Excel. This knowledge is crucial for performing complex calculations and automating your data analysis.
Relative and absolute references: You will learn the difference between relative and absolute cell references and how to apply them in your formulas. Relative references adjust automatically when you copy formulas, while absolute references remain fixed. This is important to ensure correct calculations in your worksheets.
The IF function: The IF function is one of the most used functions in Excel, allowing you to perform conditional calculations. You will learn how to use the What-If function to perform logical tests on your data and display different results based on the test results.
Flash Preview: The flash preview is a tool that helps you automatically recognize and apply patterns in your data. You will learn how to use the flash preview to format and edit data quickly and efficiently. This saves time and increases the accuracy of your data processing.
With this knowledge, you will be able to perform complex calculations and automate your data analysis. You will be able to use formulas and functions effectively to design your worksheets accurately and efficiently.
- BASICS
- Formulas and calculations
- Relative and absolute references
- FUNCTIONS
- Using functions
- Sum
- If
- Average value
- Min
- Max
- Number
- Number2
- Laps
- Flash preview
- Nested functions
Show chapter
Entering and formatting cell contents
In this subject, we focus on entering and formatting cell content. You will learn the basic techniques and advanced methods for presenting your data professionally and clearly.
Basics of cell formatting: You will learn how to enter cell content and apply different formatting. This includes selecting and adjusting fonts, font sizes, colors and borders to make your data visually appealing. You will learn how to left-align, right-align or center cell contents and how to link cells together.
Conditional formatting: A particular focus is on conditional formatting, which allows you to automatically highlight cells based on certain criteria. You will learn how to create and apply conditional formatting rules to, for example, compare numerical values or highlight certain text patterns. This helps you to visualize important information quickly and easily.
Quick analysis: Quick analysis is a practical tool in Excel that allows you to quickly analyse and visualize your data. You will learn how to use this tool to totalize data, calculate average values or create charts. This allows you to recognize important trends and patterns in your data at a glance.
By learning these techniques, you will be able to enter, format and analyze your data efficiently. You will be able to make your worksheets visually appealing and quickly highlight important information, significantly increasing your productivity and professionalism.
- CELL FORMATTING BASICS
- Data input
- Search function
- Sorting
- Copy
- Move
- Delete
- Fonts, font sizes and colors
- Borders and cell connections
- CONDITIONAL FORMATTING
- Quick analysis
- Align cell contents left-aligned, right-aligned or centered
Show chapter
Module MS Excel specialization
Show all chapters of the subjects
Automation and increased productivity
In this subject, participants learn how to increase their efficiency in Excel through automation and the use of advanced techniques. Here are the key learning points:
Macros and range names: Participants will learn how to record, edit and apply macros to automate repetitive tasks. They will also learn how to define and use range names to make formulas and functions clearer and simpler.
Linking and importingdata : Students will learn how to import data from various sources and insert it into their Excel workbooks. They will also learn how to link data between different workbooks and tables to create a consistent and dynamic data structure.
Merge and protect workbooks: This module covers the techniques for merging multiple workbooks and their data. Participants will also learn how to secure their workbooks with passwords and other protective measures to ensure data integrity and confidentiality.
- MACROS AND AREA NAMES:
- Recording, editing and applying macros to automate recurring tasks
- Defining and using range names for better clarity in formulas and functions
- LINKING AND IMPORTING DATA:
- Importing data from different sources into Excel workbooks
- Linking data between worksheets and workbooks for a consistent and dynamic data structure
- MERGE AND PROTECT WORKBOOKS:
- Techniques for merging multiple workbooks and their data
- Apply password protection and other measures to ensure data integrity and confidentiality
- VALIDITY CHECKING AND MONITORING:
- Establish data validity rules to prevent data entry errors
- Creating drop-down lists and data validity rules
- Monitoring and validating data changes
Show chapter
Data analysis and scenarios
This subject focuses on advanced techniques of data analysis and the use of scenarios in Excel. Students will learn to:
Analyze tables and lists: Students will learn how to use pivot tables and pivot charts to effectively analyze and visualize large amounts of data. They will learn how to create, customize and interpret pivot tables to gain valuable insights into the data.
Filtering and sorting data: This module teaches advanced techniques for filtering and sorting data. Participants will learn how to apply complex filtering criteria and sort data in multiple levels to extract relevant information quickly and accurately.
Create and use scenarios: Participants will learn how to create and use different scenarios to perform hypothetical analysis. This includes creating what-if analyses to explore the impact of different assumptions and decisions on their data and make informed decisions. These two subjects provide participants with valuable skills to increase and execute their productivity, helping them to make informed decisions in their everyday professional lives.
Analyze tables and lists: Students will learn how to use pivot tables and pivot charts to effectively analyze and visualize large amounts of data. They will learn how to create, customize and interpret pivot tables to gain valuable insights into the data.
Filtering and sorting data: This module teaches advanced techniques for filtering and sorting data. Participants will learn how to apply complex filtering criteria and sort data in multiple levels to extract relevant information quickly and accurately.
Create and use scenarios: Participants will learn how to create and use different scenarios to perform hypothetical analysis. This includes creating what-if analyses to explore the impact of different assumptions and decisions on their data and make informed decisions. These two subjects provide participants with valuable skills to increase and execute their productivity, helping them to make informed decisions in their everyday professional lives.
- ANALYZE TABLES AND LISTS:
- Using pivot tables and pivot charts to analyze and visualize large amounts of data
- Creating, customizing and interpreting pivot tables
- FILTERING AND SORTING DATA:
- Applying advanced filtering and sorting techniques
- Complex filter criteria and multi-level sorting for precise extraction of relevant information
- CREATE AND USE SCENARIOS:
- Creating and using scenarios for hypothetical analyses (what-if analyses)
- Investigating the impact of different assumptions and decisions on the data
- MONITORING AND VALIDATING DATA:
- Setting up monitoring rules and using validation and error checking functions
- Ensuring data integrity and accuracy
Show chapter
Advanced functions and techniques
In this subject, students will learn how to use advanced functions and techniques in Excel to perform complex data analysis and calculations. Here are the key learning points:
Advanced Formatting: Students will learn how to create and apply custom number formats to present data specifically and clearly. This includes the use of custom formatting rules to display currencies, percentages or custom text formats, for example.
Advanced conditional formatting: This module covers the application of complex conditional formatting to automatically highlight data based on specific criteria. Participants will learn how to combine and apply multiple rules to visually support their data analysis.
Application of functions from different categories: Students will learn how to use advanced functions from the logic, statistics, financial math, and math categories.
- ADVANCED FORMATTING
- Creation and application of user-defined number formats for the specific and clear presentation of data
- Use of user-defined formatting rules (e.g. currencies, percentages)
- ADVANCED CONDITIONAL FORMATTING
- Application of complex conditional formatting to visually support data analysis
- Combination and application of multiple conditional formatting rules
- APPLICATION OF FUNCTIONS FROM DIFFERENT CATEGORIES
- Use of advanced functions from the categories of logic, statistics, financial mathematics and mathematics:
- Logic functions: If, And, Or, Not
- Statistical functions: Mean, Median, Mode, Stabw
- Financial mathematical functions: Interest, Rmz, Ikv
- Mathematical functions: Sum, sum-if, sum-product
Show chapter
Consolidation and structuring
In this subject, participants learn how to consolidate data from several worksheets and workbooks and present it in a structured way. The main learning contents are
Consolidation of data:
Participants will learn how to merge data from different sources and worksheets to create a unified database. This includes using consolidation functions and tools in Excel to calculate totals, averages and other aggregated data.
Working with relationships:
Students will learn how to create and manage links between worksheets and workbooks. They will learn how to dynamically link data so that changes in a source are automatically updated in the linked workbook.
Organizing data:
Participants will learn techniques for organizing and structuring data. This includes creating outlines to divide large amounts of data into manageable sections and using grouping functions to organize and present data hierarchically.
Merging and comparing workbooks:
This module covers methods for merging multiple workbooks. Participants will learn how to compare and consolidate data from different workbooks to create consistent and complete data sets.
Consolidation of data:
Participants will learn how to merge data from different sources and worksheets to create a unified database. This includes using consolidation functions and tools in Excel to calculate totals, averages and other aggregated data.
Working with relationships:
Students will learn how to create and manage links between worksheets and workbooks. They will learn how to dynamically link data so that changes in a source are automatically updated in the linked workbook.
Organizing data:
Participants will learn techniques for organizing and structuring data. This includes creating outlines to divide large amounts of data into manageable sections and using grouping functions to organize and present data hierarchically.
Merging and comparing workbooks:
This module covers methods for merging multiple workbooks. Participants will learn how to compare and consolidate data from different workbooks to create consistent and complete data sets.
- CONSOLIDATION OF DATA
- Merging data from different sources and spreadsheets to create a unified database
- Use consolidation functions and tools to calculate totals, averages and other aggregated data
- WORKING WITH LINKS
- Create and manage links between worksheets and workbooks
- Dynamically link data so that changes in a source are automatically updated in the linked workbook
- STRUCTURING DATA
- Create outlines to structure large amounts of data into manageable sections
- Use grouping functions to display and organize data hierarchically
- MERGING AND COMPARING WORKBOOKS
- Methods for merging and consolidating multiple workbooks
- Compare and consolidate data from different workbooks to create consistent data sets
Show chapter
Professional use of diagrams
In this subject, participants learn how to use advanced charting techniques to visualize their data in a professional and appealing way. The main learning contents are:
Advanced charting techniques: Students will learn advanced techniques for designing and customizing charts. This includes adding trend lines, formatting data series and axes, and applying custom chart elements.
Using Chart Templates: Participants will learn how to create and use chart templates to quickly create consistent and professional charts. They will learn how to save custom templates and apply them to different data sets.
Dynamic Charts: This module covers the creation of dynamic charts that automatically adapt to changes in the underlying data. Participants will learn how to define data ranges and create charts that update based on dynamic data.
Data Visualization with Sparklines: Participants will learn how to use sparklines to display data trends and patterns in compact charts embedded in individual cells. This technique enables quick and efficient visualization of data directly in the worksheets.
- CREATING DIAGRAMS
- Basics of creating charts in Excel
- Creation of different chart types (e.g. column, line, pie and bar charts)
- ADVANCED CHARTING TECHNIQUES
- Designing and customizing charts by adding trend lines and formatting data series and axes
- Application of user-defined chart elements for better data visualization
- USE OF CHART TEMPLATES
- Create and use chart templates to create professional charts quickly and consistently
- Save and apply custom templates to different data sets
- DYNAMIC CHARTS
- Create dynamic charts that automatically adapt to changes in the underlying data
- Define data ranges to create and update dynamic charts
- DATA VISUALIZATION WITH SPARKLINES
- Use sparklines to visualize data trends and patterns in compact charts embedded in individual cells
- Quick and efficient visualization of data directly in the worksheets
Show chapter
Recognition of our IT training courses
Training certification
There are no uniformly standardized training paths in the field of IT training. However, this does not mean that the quality and recognition of our training programs are compromised. Our training institute is ISO 9001 certified and recognized. This certification confirms our commitment to the highest quality standards and continuous improvement.
Through our ISO 9001 certification, we ensure that our IT training programs - including our PHP programmer, web developer, programmer courses, and more - are developed and delivered according to international quality standards. You benefit from structured, practical curricula, experienced instructors and a high level of support during your training.
Institute certification
As a recognized institution in adult education, we subject our curricula to regular evaluations that are recognized by state authorities and funding bodies. Our ongoing goal is to exceed current quality standards and thus guarantee you first-class training. Convince yourself of our certifications.
Our certification gives you the certainty that you are receiving high-quality, recognized training that will optimally prepare you for your professional future.
Funding & educational leave - how it works
Can I get funding for my training?
At the Flexyfit EDV Academy, you have a wide range of options for funding your training. There are various funding programs at federal state and EU level as well as tax incentives that serve as a basis.
Please note, however, that the decision on the allocation and amount of funding is the sole responsibility of the respective funding body.
We will be happy to help you find a suitable funding body and provide you with all the course information you need to apply for funding. You must submit the application itself to the relevant funding body.
How does the funding work?
Depending on the funding institution, your training will be financed either through direct assumption of costs after confirmation of the funding application (e.g. AMS) or through full or partial reimbursement after successful completion of the training (e.g. Waff). We recommend that you contact the relevant funding institutions in person to find out about individual funding options.Can I take educational leave for the course?
Yes, the majority of our courses are suitable for educational leave.
If you would like to continue your education without terminating your employment, you can arrange educational leave with your employer. You will be released from work for the duration of the training.
Plan your educational leave with us now! We will be happy to clarify your individual training requirements with you in a personal, non-binding consultation .
How does educational leave work?
You can take your educational leave for a maximum of- Educational leave over a period of 12 months in one go
- split up, whereby each part must last at least
2 months . The parts must be taken within4 years . - Educational leave with part-time educational leave extending over
2 years
Please note that this is a general summary and it is advisable to check with the relevant bodies or authorities for further details and conditions.
Your employer's consent is essential for educational leave. You must submit the training plans issued by us, which require 20 hours per week for full-time educational leave or at least 10 hours per week for part-time educational leave.
It is also necessary to provide regular proof of the progress of your training, for example through examinations or attendance certificates issued by us.
Anwendungsbereiche und Möglichkeiten mit Excel Kenntnissen
Datenanalyse und Berichterstellung:
Datenorganisation: Strukturieren und Verwalten großer Datenmengen,
um sie für Analysen vorzubereiten.
Berichte und Dashboards: Erstellung
aussagekräftiger Berichte und interaktiver Dashboards zur Visualisierung von Geschäftsdaten und KPIs.
Finanzwesen und Buchhaltung:
Finanzanalysen: Durchführung von Finanzanalysen, Budgetierungen und Prognosen.
Buchhaltung: Verwaltung von Buchhaltungsdaten und Erstellung von Finanzberichten.
Projektmanagement:
Projektplanung: Erstellung und Verwaltung von Projektplänen, Zeitplänen und Budgets.
Ressourcenmanagement: Verfolgung und Verwaltung von Projektressourcen und Aufgaben.
Berichterstellung und Präsentation:
Professionelle Berichte: Erstellen Sie ansprechende und übersichtliche Berichte mit
Formatierungen, Diagrammen und Tabellen.
Datenpräsentation: Nutzen Sie Excel, um Daten
visuell aufzubereiten und in Präsentationen überzeugend darzustellen.
Automatisierung von Aufgaben:
Makros und VBA: Automatisieren Sie wiederkehrende Aufgaben und Prozesse, um Effizienz
und Genauigkeit zu steigern.
Datenimporte und -exporte: Importieren und exportieren
Sie Daten zwischen Excel und anderen Anwendungen nahtlos.
Marketing und Vertrieb:
Kampagnenanalyse: Analyse von Marketingkampagnen und Vertriebsdaten, um den Erfolg
zu bewerten und zu optimieren.
CRM-Daten: Verwaltung und Analyse von Kundendaten
zur Verbesserung von Kundenbeziehungen und Verkaufsstrategien.
Personalwesen:
Mitarbeiterdaten: Verwaltung und Analyse von Mitarbeiterdaten, einschließlich Gehaltsabrechnungen und
Leistungsbeurteilungen.
HR-Berichte: Erstellung von Berichten zur Unterstützung von Personalentscheidungen.
Excel bietet vielseitige Einsatzmöglichkeiten in verschiedenen Bereichen, von der Datenanalyse und Berichterstellung über Finanzwesen und Buchhaltung bis hin zu Projektmanagement, Marketing und Personalwesen. Mit fundierten Kenntnissen in Excel können Sie umfassende und effiziente Lösungen für Ihre beruflichen Herausforderungen entwickeln und umsetzen.
Excel Basics and Advanced: Your key to data analysis
Expand your skills and immerse yourself in the world of data analysis with our Excel Basics and Advanced course . Whether you're just starting out or already have experience with Excel, this course will give you the knowledge you need to use Excel effectively and perform complex data analysis. Learn hands-on and at your own pace with numerous examples and exercises to help you apply and consolidate what you have learned immediately.
This course provides you with comprehensive knowledge, from the basics to advanced techniques for editing spreadsheets and formatting. You will learn how to apply conditional formatting and user-defined number formats, use functions from different categories (logic, statistics, financial mathematics, mathematics) and create and design charts using advanced techniques. You will also learn how to analyze, filter and sort tables and lists, create and use scenarios, define validity rules for data and check formulas.
What can you expect from our training?
The course content includes an introduction to the basics of Excel, where you will learn the basic operation and the most important functions. You will be introduced to Excel's , including creating and managing complex tables, applying advanced formatting and analysis techniques and automating tasks with macros.
Topics include:
- Advanced spreadsheet editing and formatting techniques, e.g. conditional formatting, custom number formats.
- Application of functions from different categories such as logic, statistics, financial math and mathematics.
- Creation and design of diagrams using advanced techniques.
- Analyzing, filtering and sorting tables and lists; creating and using scenarios.
- Defining validity rules for data and checking formulas.
- Increase productivity by working with range names and macros.
- Linking, embedding and importing data.
- Merging and comparing workbooks; applying measures to protect spreadsheets.
Who is the course suitable for?
This course is ideal for beginners who have little or no experience with Excel, as well as advanced users who want to expand their knowledge. Professionals who regularly work with data and want to improve their data analysis skills will also benefit from this course.
Would you like to learn about other word processing or presentation programs? Then why not take our MS - Word Basics & Advanced or MS - PowerPoint Basics & Advanced course .
Conditions of participation
- Online or written registration
- Basic computer skills are recommended but not required
- Minimum age 18 years (for participants under 18 years, written parental consent is required for registration)
- Access to an internet-enabled device
- Access to a stable internet connection
Certificate of completion
Our certificates are valid worldwide and are issued in different versions. On request, you can receive our certificate in several languages, with country-specific information and with or without printed grades.
All of these variants are available to you free of charge for a lifetime for downloading from your online campus. In addition, depending on the learning package you have purchased, you will receive a certificate of your choice, which will be issued on special high-quality embossed paper.
The following certificate is awarded:
"Excel - Basics and Advanced"
Do you have specific questions about the training?
We will be happy to help you by phone, e-mail or chat.
Procedure & duration - how your training is structured
The training consists of several modules
You can find the list of modules and subjects by clicking on the "Course content" tab.
Duration of the training
As our training courses can be designed very flexibly, the duration of the training depends heavily on your own learning initiative, the amount of time you spend each week and your previous knowledge. Depending on how much time you can invest and how quickly you absorb the required knowledge, it is also possible to complete the training more quickly.
Online live training via Zoom
The training is conducted live online via Zoom. The instructors teach in real time and share their screen so that you can follow the lessons from the comfort of your own home. You have access to all dates and the link to the live webinar via the Online Campus, so you can easily participate from home.
You will receive the Zoom meeting link by e-mail before the start of the course and it will also be available on our Flexyfit learning platform. Please make sure that you have entered your current e-mail address when registering.
With online distance learning courses, you set the tone
Learn at your own pace, when and where you want. The Academy account accompanies you on your computer, tablet or smartphone and includes everything you need for the course.
You decide how you learn
You can choose from a wide range of Full HD learning videos in which our top instructors teach you the training content. You can also read the content in our scripts and presentations.
No pain, no gain
You will work your way through a variety of compulsory and additional tasks. These include applying conditional formatting, creating user-defined number formats, applying functions from various categories and creating and designing diagrams. All tasks are explained in a step-by-step guide so that you can apply what you have learned in a practical way.
Last but not least... Exams
You can expect lots of multiple choice online exams to test your knowledge. You can take a test exam before each exam to be optimally prepared.
Detailed Course Contents
Extent of learning
275 E | Volume
EDK
187
IT competence
RE
4
Literature research
LE
80
Self-study (learning units)
AE
4
Additional tasks & examinations
This training is suitable for educational leave. The individual review and approval is subject to the respective funding agency. For more detailed information on the duration and procedure of educational leave, please contact us directly! Book a consultation appointment now.
Participation in the face-to-face webinars is mandatory for educational leave and must be proven to the AMS. Confirmation of attendance must be requested on the participant's own responsibility. Confirmation of attendance of the face-to-face webinar will only be issued during each webinar if requested by the participant.
Module MS Excel basics
Show all chapters of the subjects
Data organization and analysis
In this subject, we focus on how you can organize and analyze your data efficiently. This is crucial for keeping large amounts of data organized and finding relevant information quickly.
Sorting and filtering data: You will learn how to sort and filter data in Excel to extract specific information. This includes sorting according to various criteria such as numbers, texts or dates. You will also learn how to apply filters to display only the data that is relevant to your analysis.
Using the autofilter: The autofilter is a powerful tool for filtering data quickly and easily. You will learn how to activate and use the autofilter to keep complex data sets organized. You will learn how to customize filters and apply multiple criteria simultaneously.
Partial results: Partial results are an efficient way to calculate subtotals and other aggregated data within a large data set. You will learn how to insert and configure partial results to simplify your data analysis. This will help you to quickly identify important summaries and trends.
Using these techniques, you will be able to organize and analyze large amounts of data efficiently. You can quickly filter out relevant information and carry out your data analysis precisely and efficiently.
- DATA
- Sort
- Filter
- Using the auto filter
- Calculating partial results
- Apply multiple filter criteria
Show chapter
Diagrams and data visualization
In this subject, you will learn how to visualize your data in Excel. Charts and graphs are crucial for presenting data clearly and recognizing important information at a glance.
Create and edit charts: You'll learn how to create different types of charts in Excel, including column, line, pie and bar charts. We'll show you how to edit and customize charts to present your data accurately and attractively.
Use chart recommendations: Excel offers you chart recommendations based on your data. You will learn how to use these recommendations to create suitable charts quickly and easily. This helps you to visualize your data efficiently without spending a lot of time choosing the right chart type.
Display data with sparklines: Sparklines are small charts embedded in cells that make trends and patterns in your data visible at a glance. You will learn how to create and customize sparklines to visualize your data in a compact and effective way.
With these skills, you will be able to present your data clearly and professionally. You will be able to use different chart types to highlight important information and support your data analysis.
- BASICS
- Creating diagrams
- Editing and customizing diagrams
- Using chart recommendations
- Displaying data with sparklines
- DIFFERENT CHART TYPES
- Bar charts
- line charts
- pie charts
- bar charts
Show chapter
Introduction to the Excel working environment
In this subject you will get to know the basic working environment of Excel. The focus is on providing you with a solid foundation on which you can build to use Excel efficiently and effectively.
Overview of the user interface: You will receive a detailed overview of the Excel user interface. This includes an explanation of the various elements, such as the ribbon, the quick access toolbar and the workbook. You will learn how to move around in Excel, open and close worksheets and switch between different views.
Menus and tools: We will guide you through the various menus and tools that Excel offers. You will learn how the tabs in the ribbon are structured and which functions are hidden behind the respective tabs. From file operations and data analysis tools to charting and formatting options - you will learn where to find which tools and how to use them.
Customize the status bar: The status bar at the bottom of the Excel window gives you important information at a glance. You will learn how to customize the status bar to display exactly the information you need, e.g. sum, average or number of selected cells. This helps you to work more efficiently and access relevant data quickly.
Important basic functions: We will show you the most important basic functions to help you get started with Excel. This includes basic operations such as creating, saving and opening workbooks. You will learn how to enter data in cells and perform simple calculations. We also explain how to carry out basic formatting to make your data clear and appealing.
This comprehensive introduction to the Excel working environment will lay the foundations for your future work with this powerful tool. You will be able to navigate confidently in Excel, use the most important functions and manage and edit your first data efficiently.
- OVERVIEW OF THE USER INTERFACE
- Menus and tools
- Customize status bar
- Workbooks
- IMPORTANT BASIC FUNCTIONS
- Creating, saving and opening workbooks
- Basic formatting and calculations
Show chapter
Formulas and functions
This subject teaches you the basics of working with formulas and functions in Excel. This knowledge is crucial for performing complex calculations and automating your data analysis.
Relative and absolute references: You will learn the difference between relative and absolute cell references and how to apply them in your formulas. Relative references adjust automatically when you copy formulas, while absolute references remain fixed. This is important to ensure correct calculations in your worksheets.
The IF function: The IF function is one of the most used functions in Excel, allowing you to perform conditional calculations. You will learn how to use the What-If function to perform logical tests on your data and display different results based on the test results.
Flash Preview: The flash preview is a tool that helps you automatically recognize and apply patterns in your data. You will learn how to use the flash preview to format and edit data quickly and efficiently. This saves time and increases the accuracy of your data processing.
With this knowledge, you will be able to perform complex calculations and automate your data analysis. You will be able to use formulas and functions effectively to design your worksheets accurately and efficiently.
- BASICS
- Formulas and calculations
- Relative and absolute references
- FUNCTIONS
- Using functions
- Sum
- If
- Average value
- Min
- Max
- Number
- Number2
- Laps
- Flash preview
- Nested functions
Show chapter
Entering and formatting cell contents
In this subject, we focus on entering and formatting cell content. You will learn the basic techniques and advanced methods for presenting your data professionally and clearly.
Basics of cell formatting: You will learn how to enter cell content and apply different formatting. This includes selecting and adjusting fonts, font sizes, colors and borders to make your data visually appealing. You will learn how to left-align, right-align or center cell contents and how to link cells together.
Conditional formatting: A particular focus is on conditional formatting, which allows you to automatically highlight cells based on certain criteria. You will learn how to create and apply conditional formatting rules to, for example, compare numerical values or highlight certain text patterns. This helps you to visualize important information quickly and easily.
Quick analysis: Quick analysis is a practical tool in Excel that allows you to quickly analyse and visualize your data. You will learn how to use this tool to totalize data, calculate average values or create charts. This allows you to recognize important trends and patterns in your data at a glance.
By learning these techniques, you will be able to enter, format and analyze your data efficiently. You will be able to make your worksheets visually appealing and quickly highlight important information, significantly increasing your productivity and professionalism.
- CELL FORMATTING BASICS
- Data input
- Search function
- Sorting
- Copy
- Move
- Delete
- Fonts, font sizes and colors
- Borders and cell connections
- CONDITIONAL FORMATTING
- Quick analysis
- Align cell contents left-aligned, right-aligned or centered
Show chapter
Module MS Excel specialization
Show all chapters of the subjects
Automation and increased productivity
In this subject, participants learn how to increase their efficiency in Excel through automation and the use of advanced techniques. Here are the key learning points:
Macros and range names: Participants will learn how to record, edit and apply macros to automate repetitive tasks. They will also learn how to define and use range names to make formulas and functions clearer and simpler.
Linking and importingdata : Students will learn how to import data from various sources and insert it into their Excel workbooks. They will also learn how to link data between different workbooks and tables to create a consistent and dynamic data structure.
Merge and protect workbooks: This module covers the techniques for merging multiple workbooks and their data. Participants will also learn how to secure their workbooks with passwords and other protective measures to ensure data integrity and confidentiality.
- MACROS AND AREA NAMES:
- Recording, editing and applying macros to automate recurring tasks
- Defining and using range names for better clarity in formulas and functions
- LINKING AND IMPORTING DATA:
- Importing data from different sources into Excel workbooks
- Linking data between worksheets and workbooks for a consistent and dynamic data structure
- MERGE AND PROTECT WORKBOOKS:
- Techniques for merging multiple workbooks and their data
- Apply password protection and other measures to ensure data integrity and confidentiality
- VALIDITY CHECKING AND MONITORING:
- Establish data validity rules to prevent data entry errors
- Creating drop-down lists and data validity rules
- Monitoring and validating data changes
Show chapter
Data analysis and scenarios
This subject focuses on advanced techniques of data analysis and the use of scenarios in Excel. Students will learn to:
Analyze tables and lists: Students will learn how to use pivot tables and pivot charts to effectively analyze and visualize large amounts of data. They will learn how to create, customize and interpret pivot tables to gain valuable insights into the data.
Filtering and sorting data: This module teaches advanced techniques for filtering and sorting data. Participants will learn how to apply complex filtering criteria and sort data in multiple levels to extract relevant information quickly and accurately.
Create and use scenarios: Participants will learn how to create and use different scenarios to perform hypothetical analysis. This includes creating what-if analyses to explore the impact of different assumptions and decisions on their data and make informed decisions. These two subjects provide participants with valuable skills to increase and execute their productivity, helping them to make informed decisions in their everyday professional lives.
Analyze tables and lists: Students will learn how to use pivot tables and pivot charts to effectively analyze and visualize large amounts of data. They will learn how to create, customize and interpret pivot tables to gain valuable insights into the data.
Filtering and sorting data: This module teaches advanced techniques for filtering and sorting data. Participants will learn how to apply complex filtering criteria and sort data in multiple levels to extract relevant information quickly and accurately.
Create and use scenarios: Participants will learn how to create and use different scenarios to perform hypothetical analysis. This includes creating what-if analyses to explore the impact of different assumptions and decisions on their data and make informed decisions. These two subjects provide participants with valuable skills to increase and execute their productivity, helping them to make informed decisions in their everyday professional lives.
- ANALYZE TABLES AND LISTS:
- Using pivot tables and pivot charts to analyze and visualize large amounts of data
- Creating, customizing and interpreting pivot tables
- FILTERING AND SORTING DATA:
- Applying advanced filtering and sorting techniques
- Complex filter criteria and multi-level sorting for precise extraction of relevant information
- CREATE AND USE SCENARIOS:
- Creating and using scenarios for hypothetical analyses (what-if analyses)
- Investigating the impact of different assumptions and decisions on the data
- MONITORING AND VALIDATING DATA:
- Setting up monitoring rules and using validation and error checking functions
- Ensuring data integrity and accuracy
Show chapter
Advanced functions and techniques
In this subject, students will learn how to use advanced functions and techniques in Excel to perform complex data analysis and calculations. Here are the key learning points:
Advanced Formatting: Students will learn how to create and apply custom number formats to present data specifically and clearly. This includes the use of custom formatting rules to display currencies, percentages or custom text formats, for example.
Advanced conditional formatting: This module covers the application of complex conditional formatting to automatically highlight data based on specific criteria. Participants will learn how to combine and apply multiple rules to visually support their data analysis.
Application of functions from different categories: Students will learn how to use advanced functions from the logic, statistics, financial math, and math categories.
- ADVANCED FORMATTING
- Creation and application of user-defined number formats for the specific and clear presentation of data
- Use of user-defined formatting rules (e.g. currencies, percentages)
- ADVANCED CONDITIONAL FORMATTING
- Application of complex conditional formatting to visually support data analysis
- Combination and application of multiple conditional formatting rules
- APPLICATION OF FUNCTIONS FROM DIFFERENT CATEGORIES
- Use of advanced functions from the categories of logic, statistics, financial mathematics and mathematics:
- Logic functions: If, And, Or, Not
- Statistical functions: Mean, Median, Mode, Stabw
- Financial mathematical functions: Interest, Rmz, Ikv
- Mathematical functions: Sum, sum-if, sum-product
Show chapter
Consolidation and structuring
In this subject, participants learn how to consolidate data from several worksheets and workbooks and present it in a structured way. The main learning contents are
Consolidation of data:
Participants will learn how to merge data from different sources and worksheets to create a unified database. This includes using consolidation functions and tools in Excel to calculate totals, averages and other aggregated data.
Working with relationships:
Students will learn how to create and manage links between worksheets and workbooks. They will learn how to dynamically link data so that changes in a source are automatically updated in the linked workbook.
Organizing data:
Participants will learn techniques for organizing and structuring data. This includes creating outlines to divide large amounts of data into manageable sections and using grouping functions to organize and present data hierarchically.
Merging and comparing workbooks:
This module covers methods for merging multiple workbooks. Participants will learn how to compare and consolidate data from different workbooks to create consistent and complete data sets.
Consolidation of data:
Participants will learn how to merge data from different sources and worksheets to create a unified database. This includes using consolidation functions and tools in Excel to calculate totals, averages and other aggregated data.
Working with relationships:
Students will learn how to create and manage links between worksheets and workbooks. They will learn how to dynamically link data so that changes in a source are automatically updated in the linked workbook.
Organizing data:
Participants will learn techniques for organizing and structuring data. This includes creating outlines to divide large amounts of data into manageable sections and using grouping functions to organize and present data hierarchically.
Merging and comparing workbooks:
This module covers methods for merging multiple workbooks. Participants will learn how to compare and consolidate data from different workbooks to create consistent and complete data sets.
- CONSOLIDATION OF DATA
- Merging data from different sources and spreadsheets to create a unified database
- Use consolidation functions and tools to calculate totals, averages and other aggregated data
- WORKING WITH LINKS
- Create and manage links between worksheets and workbooks
- Dynamically link data so that changes in a source are automatically updated in the linked workbook
- STRUCTURING DATA
- Create outlines to structure large amounts of data into manageable sections
- Use grouping functions to display and organize data hierarchically
- MERGING AND COMPARING WORKBOOKS
- Methods for merging and consolidating multiple workbooks
- Compare and consolidate data from different workbooks to create consistent data sets
Show chapter
Professional use of diagrams
In this subject, participants learn how to use advanced charting techniques to visualize their data in a professional and appealing way. The main learning contents are:
Advanced charting techniques: Students will learn advanced techniques for designing and customizing charts. This includes adding trend lines, formatting data series and axes, and applying custom chart elements.
Using Chart Templates: Participants will learn how to create and use chart templates to quickly create consistent and professional charts. They will learn how to save custom templates and apply them to different data sets.
Dynamic Charts: This module covers the creation of dynamic charts that automatically adapt to changes in the underlying data. Participants will learn how to define data ranges and create charts that update based on dynamic data.
Data Visualization with Sparklines: Participants will learn how to use sparklines to display data trends and patterns in compact charts embedded in individual cells. This technique enables quick and efficient visualization of data directly in the worksheets.
- CREATING DIAGRAMS
- Basics of creating charts in Excel
- Creation of different chart types (e.g. column, line, pie and bar charts)
- ADVANCED CHARTING TECHNIQUES
- Designing and customizing charts by adding trend lines and formatting data series and axes
- Application of user-defined chart elements for better data visualization
- USE OF CHART TEMPLATES
- Create and use chart templates to create professional charts quickly and consistently
- Save and apply custom templates to different data sets
- DYNAMIC CHARTS
- Create dynamic charts that automatically adapt to changes in the underlying data
- Define data ranges to create and update dynamic charts
- DATA VISUALIZATION WITH SPARKLINES
- Use sparklines to visualize data trends and patterns in compact charts embedded in individual cells
- Quick and efficient visualization of data directly in the worksheets
Show chapter
Recognition of our IT training courses
Training certification
There are no uniformly standardized training paths in the field of IT training. However, this does not mean that the quality and recognition of our training programs are compromised. Our training institute is ISO 9001 certified and recognized. This certification confirms our commitment to the highest quality standards and continuous improvement.
Through our ISO 9001 certification, we ensure that our IT training programs - including our PHP programmer, web developer, programmer courses, and more - are developed and delivered according to international quality standards. You benefit from structured, practical curricula, experienced instructors and a high level of support during your training.
Institute certification
As a recognized institution in adult education, we subject our curricula to regular evaluations that are recognized by state authorities and funding bodies. Our ongoing goal is to exceed current quality standards and thus guarantee you first-class training. Convince yourself of our certifications.
Our certification gives you the certainty that you are receiving high-quality, recognized training that will optimally prepare you for your professional future.
Funding & educational leave - how it works
Can I get funding for my training?
At the Flexyfit EDV Academy, you have a wide range of options for funding your training. There are various funding programs at federal state and EU level as well as tax incentives that serve as a basis.
Please note, however, that the decision on the allocation and amount of funding is the sole responsibility of the respective funding body.
We will be happy to help you find a suitable funding body and provide you with all the course information you need to apply for funding. You must submit the application itself to the relevant funding body.
How does the funding work?
Depending on the funding institution, your training will be financed either through direct assumption of costs after confirmation of the funding application (e.g. AMS) or through full or partial reimbursement after successful completion of the training (e.g. Waff). We recommend that you contact the relevant funding institutions in person to find out about individual funding options.Can I take educational leave for the course?
Yes, the majority of our courses are suitable for educational leave.
If you would like to continue your education without terminating your employment, you can arrange educational leave with your employer. You will be released from work for the duration of the training.
Plan your educational leave with us now! We will be happy to clarify your individual training requirements with you in a personal, non-binding consultation .
How does educational leave work?
You can take your educational leave for a maximum of- Educational leave over a period of 12 months in one go
- split up, whereby each part must last at least
2 months . The parts must be taken within4 years . - Educational leave with part-time educational leave extending over
2 years
Please note that this is a general summary and it is advisable to check with the relevant bodies or authorities for further details and conditions.
Your employer's consent is essential for educational leave. You must submit the training plans issued by us, which require 20 hours per week for full-time educational leave or at least 10 hours per week for part-time educational leave.
It is also necessary to provide regular proof of the progress of your training, for example through examinations or attendance certificates issued by us.
Anwendungsbereiche und Möglichkeiten mit Excel Kenntnissen
Datenanalyse und Berichterstellung:
Datenorganisation: Strukturieren und Verwalten großer Datenmengen,
um sie für Analysen vorzubereiten.
Berichte und Dashboards: Erstellung
aussagekräftiger Berichte und interaktiver Dashboards zur Visualisierung von Geschäftsdaten und KPIs.
Finanzwesen und Buchhaltung:
Finanzanalysen: Durchführung von Finanzanalysen, Budgetierungen und Prognosen.
Buchhaltung: Verwaltung von Buchhaltungsdaten und Erstellung von Finanzberichten.
Projektmanagement:
Projektplanung: Erstellung und Verwaltung von Projektplänen, Zeitplänen und Budgets.
Ressourcenmanagement: Verfolgung und Verwaltung von Projektressourcen und Aufgaben.
Berichterstellung und Präsentation:
Professionelle Berichte: Erstellen Sie ansprechende und übersichtliche Berichte mit
Formatierungen, Diagrammen und Tabellen.
Datenpräsentation: Nutzen Sie Excel, um Daten
visuell aufzubereiten und in Präsentationen überzeugend darzustellen.
Automatisierung von Aufgaben:
Makros und VBA: Automatisieren Sie wiederkehrende Aufgaben und Prozesse, um Effizienz
und Genauigkeit zu steigern.
Datenimporte und -exporte: Importieren und exportieren
Sie Daten zwischen Excel und anderen Anwendungen nahtlos.
Marketing und Vertrieb:
Kampagnenanalyse: Analyse von Marketingkampagnen und Vertriebsdaten, um den Erfolg
zu bewerten und zu optimieren.
CRM-Daten: Verwaltung und Analyse von Kundendaten
zur Verbesserung von Kundenbeziehungen und Verkaufsstrategien.
Personalwesen:
Mitarbeiterdaten: Verwaltung und Analyse von Mitarbeiterdaten, einschließlich Gehaltsabrechnungen und
Leistungsbeurteilungen.
HR-Berichte: Erstellung von Berichten zur Unterstützung von Personalentscheidungen.
Excel bietet vielseitige Einsatzmöglichkeiten in verschiedenen Bereichen, von der Datenanalyse und Berichterstellung über Finanzwesen und Buchhaltung bis hin zu Projektmanagement, Marketing und Personalwesen. Mit fundierten Kenntnissen in Excel können Sie umfassende und effiziente Lösungen für Ihre beruflichen Herausforderungen entwickeln und umsetzen.
Available course variations
MS - Excel Basics & Advanced
Learning Type / Learning Method
Course Modality
Study Method
Auditory & Visual Learning Style
Communicative & Kinesthetic Learning Style
Study Timeframe
Study Support (# all-inclusive)
Text & Presentation PDFs
Support via Online Campus, E-mail, Chat, Tel.
WhatsApp & On-site Support
Test/Dummy Exam
Exam/Completion
Final Exam
Certificate in DE, EN or ES
Certificate accepted worldwide & never expires
Academy Account (# all-inclusive)
Lifetime Access to Online Campus
Free Demo Account / Trial Package
Certificate Copy as Downloadable PDF
Certificate with Verification via QR-Code
Financial Aid
Financial Aid/Grant Opportunities
Paid Educational Leave (AT)
Grants for Businesses
Grants for Self-Employed Persons
Course Advising
Cost Estimate for Financial Aid Provider
Benefits
Job Openings Mailing List
Comprehensive Training Opportunities
Absolute Best Price & Service Offer
Online Courses
€ 780,-
online
visual
recommended
suitable
Flexible
up to 100%
non-binding
Basic information on the learning variants:
- The training content is the same for each learning variant
- The examination period, duration of training and examination procedure are independent of the learning variant
- Sie können von der Lernvariante "Fernstudium" auf Präsenz unterricht aufbuchen. Auch einzelne Modulblöcke sind aufbuchbar
- With the "face-to-face course" learning option, you can book and complete individual blocks in private lessons
- The final certificate does not differ, regardless of which learning variant you have completed the course in
- Your Academy account and the learning content will stay with you for the rest of your life
vor 2 Tagen
Auf Vollzeit-Berufstätige wird besonders Rücksicht genommen. Die Aufbereitung der Lernunterlagen (in der Kombination Buchform, Folien und Videos) ist großartig.
Ein wirklich tolles Team, sympathische und professionelle Vortragende, insgesamt ein top Ausbildungsinstitut, das ich jedem nur sehr weiterempfehlen kann. ⭐️⭐️⭐️⭐️⭐️
vor 6 Tagen
Einfach ein Top Team !
vor 15 Tagen
Interessanter und sehr umfangreicher Kursplan, kompetente Betreuung, sehr nettes Team, ganz einfach TOP und jederzeit gerne wieder.
18.11.2023
Schnelle Antwort auf alle Fragen.
11.11.2023
Schnelle Beratung, Top Service
07.11.2023
Sehr gute Unterstützung durch dem Personal, sowohl telefonisch als auch per Mail. Besonderen Dank an Sarah
17.10.2023
Ganz tolles Angebot und Service... jederzeit gerne wieder.
12.10.2023
Nett,
07.10.2023
Schnelle unkomplizierte Anmeldung. Ratenzahlung perfekt und man kann sich das lerntempo selbst anpassen
01.10.2023
Sportkompetenz + Fitnesstrainer B-Lizenz sind ein sehr umfangreicher Kurs, in dem jede Menge Wissen vermittelt wird, welches dem aktuellen wissenschaftlichen Stand entspricht. Man bekommt einen Gegenwert für sein Geld. Der Schwerpunkt liegt auf dem Maschinentraining. Neben bekannten Übungen, werden auch interessante Spezialübungen gezeigt. Was ich etwas vermisst habe sind klassische Hantelübungen (z.B. Kurzhantelüberzüge, Kreuzhebevarianten, Kniebeugen, Bankdrücken, Stirndrücken, SZ-Bizepscurls,... usw.), welche meiner Meinung nach insbesondere für Anfänger etwas besser geeignet sind als einige der gezeigten Kabelzugübungen. Was leider ebenfalls zu kurz kommt, sind Übungen für die Bauchmuskulatur. Hier bitte nachbessern.
Auf Nachrichten wird sehr schnell reagiert. Für das Fachgespräch habe ich innerhalb von 24 Stunden einen Termin bekommen. Ich werde auf jeden Fall weitere Kurse machen. Alles in allem kann ich den Kurs sehr empfehlen.
22.06.2023
Alles 👍
10.05.2023
Alles ist gut vorbereitet, die Kurse, die Mitarbeiter, perfekt.
10.05.2023
Die begleitung in eure Welt war sehr klar und deutig. Die mitarbeitarin hat mich von anfang an begleitet mit telefonate wo sie an alle meine fragen ein antwort gefunden hat. Und auch bei umstellund des Gutschein kauf haben mich die mitarbeiter sofort geholfen
25.04.2023
Aufbau, Unterlagen und Videos sind top, wenn man etwas benötigt reagieren sie schnell.
15.04.2023
Super Team, kompetent, geduldig und immer freundlich
07.04.2023
Kompetente Auskunft, gute Organisation super Kursangebot
01.04.2023
Tolle Academy
10.03.2023
Klasse Ausbildung, qualifiziertes Personal, guter Service
07.03.2023
Die Module sind sehr lehrreich gestaltet. Zudem sind die Videos sehr gut dargestellt und verständlich.
05.03.2023
Vielseitiges Kurs- und Ausbildungsangebot in dem auch verschiedene Richtungen kombiniert werden. Ganz toll!
Rating
Zoe Alina
2 weeks ago
Very well organized team, uncomplicated operation of online lessons, versatile informative script :) All in all top!
[+]
posted on
Susi Sorglos
2 weeks ago
I am very impressed with Flexyfit, always nice and helpful people. Very sympathetic. Thank you very much for your great support.
[+]
posted on
Anna Kober
3 weeks ago
Great training and super nice people. You can tell how much emphasis is placed on conveying the necessary knowledge to the course participants in an understandable way. I was even kindly allowed to take a course completely free of charge after there were somewhat problematic and disruptive participants in my group. I will 100% take more courses with you in the future because learning is extremely fun, especially thanks to the friendly staff!
[+]
posted on
Brigitte Moser
3 weeks ago
The entire flexyfit team is extremely friendly, prompt and helpful. The lecturers are competent and respond to the course participants. All learning materials were provided clearly and in sufficient detail. The additional videos mean there is something for every type of learner. All in all, the training and exam went well. I can definitely recommend flexyfit and will be happy to book and recommend further training courses with you again!
[+]
posted on
safa alj
a months ago
A great team - competent, friendly, always helpful and supportive - provided excellent support for the practical training. We recommend! :)
[+]
posted on
Dr. Michael Kohlberger, BSc MSc
a months ago
Great support and extensive course content. We recommend!
[+]
posted on
Florian Reining
a months ago
I really enjoyed training to become a B-license fitness trainer there. The teaching materials provided are great and flawless. I learned a lot of new things there and always enjoyed what I was doing. The team is great and is always there for you if you have any questions!
[+]
posted on
Hrvoje Stilin (Stilintrhasher)
a month ago
The best thing that could have happened to me is this academy. Access to participants is excellent. All employees are very competent, very professional and very friendly. A person can learn so much that it is indescribably good. I would recommend it to everyone. When I arrived in Austria I was looking for something like this and luckily I found this academy and signed up for the course without hesitation. Everything we get in return is worth 100 times more than what we pay. Indescribable experience, indescribable people, once again and 1000 times I say: Thank you for everything, thank you for this indescribable experience. THANK YOU, THANK YOU, THANK YOU
[+]
posted on
Magdalena Bartosch
a months ago
I was able to learn a lot of new things as part of my training at the Flexyfit Academy and was able to take on a new, demanding challenge with my chosen course. The structure of the training courses is very understandable and clear, so that you can master the distance learning course on your own without any problems. If there were any questions, ambiguities or isolated problems, the Academy team was always quick to help and we could always find a common solution. Here and there I would have liked a little more practical relevance. Nevertheless, I always felt very comfortable, had great speakers and with my degree as a qualified medical sports coach, many new doors are now open to me :)
[+]
posted on
Stefanie Graf
2 months ago
I was able to complete my chosen course very well and quickly. The team is very quick and courteous and you are always offered a good solution if there are any uncertainties. I will book again when I get the chance and can recommend the academy!
[+]
posted on
Search for more courses
Select your preferred course modality and find the fitness education that suits your interests
Please select a learning variant or enter a search text!
