Excel is the most widely used tool for data management and analysis. In this course, you will learn how to take your Excel skills to the next level, analyze complex data and create impressive charts - step by step!
Disclaimer:
This e-learning course was fully translated with AI support. Subtitles are based on the original German version (see here). The video modules display the German user interface, but the spoken language is English, including English captions. Minor discrepancies may occur, with the German version being the authoritative reference.
Excel is the most widely used tool for data management and analysis. In this course, you will learn how to take your Excel skills to the next level, analyze complex data and create impressive charts - step by step!
This is what you will learn:
- Create, adapt and structure tables.
- Perform calculations - from basic arithmetic operations to complex formulas.
- Use filters and sorting functions for targeted data selection.
- Create professional diagrams and visualizations.
- Automation techniques such as SVERWEIS, conditional formatting and nested functions.
- Make efficient print and layout settings.
Requirements:
- Basic knowledge of using a computer.
- An installed version of Microsoft Excel (2010 or newer recommended).
- Motivation to use Excel effectively and to learn it from scratch.
Who is this course suitable for?
- Beginners who want to learn Excel from scratch.
- Advanced users who want to expand their knowledge and use professional functions.
- Professionals from all sectors who work with data and want to manage or analyze it better.
- Students and freelancers who want to use Excel efficiently to complete projects and tasks faster.
NOTE:
To access your e-learning course with us, you need a Golem Career World customer account. Use the same e-mail address to purchase the course that you want to use to access it. Your customer account is of course free of charge.
After your purchase:
a) Log in to your Golem Karrierewelt account, go to “View order” and select “View online”.
b )After order confirmation: Click on “View order” and follow the link “to my courses”.
c) Or use the “My e-learning courses” link directly.
d) Have you used the price advantage and purchased access for several people? Please inform all authorized persons that a free Golem Career World account is required to access the e-learning courses. Those entitled to access will automatically receive an invitation to their account from us and must activate it once in order to access the courses.
Detailed course description:
Excel is more than just a spreadsheet program. It allows you to manage complex data, perform calculations and create clear diagrams. This makes Excel a powerful tool for working efficiently and making informed decisions.
In this course you will learn step by step how to fully utilize Excel - from basic navigation, creating and formatting tables to advanced functions such as conditional calculations and the use of SVERWEIS
Course content - 9 sections - 35 lessons - 4h 17min Total duration
Section 1: introduction and basics - from zero to Excel
1. What you can expect in the course
2. Install Excel and get started right away
3. Your first look at Excel - navigation and structure
4. Saving and optimally managing files
5. Basic formatting - colors, fonts and initial adjustments
Section 2: first steps - data and formulas made easy
6. Quick start with formulas - First calculations made easy
7. Mastering basic arithmetic operations in Excel
8. Auto-fill - your new favorite helper
9. Combine and join cells for better readability
Section 3: organize and optimize data
10. Create more space and clarity in tables
11. Show and hide rows and columns for a tidy view
12. Fixed headers for a better overview when scrolling
13. Customize number formats
Section 4: basics of calculations - how it works
14. Clever use of sums and simple functions
15. Using averages and statistics in a simple way
16. Working efficiently with mathematical expressions
17. Cleverly copy and transfer formulas
Section 5: in-depth calculations - more power for your data
18. Nested and more complex formulas explained simply
19. Understanding conditional calculations with the IF function
20. Using multiple conditions like a pro
21. Error management - automatic error correction in formulas
Section 6: analyze & filter data
22. Use filters for targeted data selection
23. Sorting and organizing for structured tables
Section 7: visualize and design charts
24. Visualize your data - the basics of charts
25. Creating bar and column charts for comparisons
26. Showing trends with line charts
27. Visualize proportions and distributions with pie charts
Section 8: print settings and page layout for professionals
28. Print more efficiently - tips and layout optimization
29. Setting up page layouts for clear printouts
Section 9: advanced functions - time saving and automation
30. Activate automatic calculation or control it manually
31. Master time calculations and calendar formulas
32. Statistical functions for data-based decisions
33. Count values - analyze frequencies
34. Table linking with SVERWEIS - merging data in a targeted manner
35. Nested formulas explained simply
