🎉 Bis zu 70% Rabatt auf ausgewählte ArtikelSale shoppen
Excel at a glance: basics to automation (E-learning in English)
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
Produktinformationen
Produktinformationen
Versand & RĂĽckgabe
Versand & RĂĽckgabe
Excel at a glance: basics to automation (E-learning in English)
Excel at a glance: basics to automation (E-learning in English)
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
$68.61
Excel at a glance: basics to automation (E-learning in English)—
$68.61
Produktinformationen
Produktinformationen
Versand & RĂĽckgabe
Versand & RĂĽckgabe
Description
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
