Excel Intermediate e-learning

Excel Intermediate e-learning

Get more out of Excel! In our intermediate Excel e-learning material, we take a step up from the basics and show formulas and tricks in our instructional videos that will significantly ease your work. You can immediately try out the novelties in the practice exercises of the instructional material.

23 témakör
134 lap
23 önellenőrző teszt
93 kép
28 oktatóvideó
Letölthető gyakorló feladatok
A teljesítés feltétele az összes lap megtekintése
A tananyag teljesítését tanúsító Igazolás a rendszerből tölthető le
Tartalom
Introduction, Useful Tips and Tricks in Excel

1. Introduction, Useful Tips and Tricks in Excel

In the first step, we will look at some useful tricks that can significantly speed up our work.
5 1 4 1 1
Lecke multimédia tartalma (1)
Useful Tips and Tricks
Formatting Tables, Number Formats

2. Formatting Tables, Number Formats

An important part of spreadsheet management is the use of various types of formats.
6 1 7 1 1
Lecke multimédia tartalma (1)
Formatting Tables, Number Formats
Paste Special

3. Paste Special

With Paste Special, we can determine the way the copied cells are pasted.
4 1 3 1 1
Lecke multimédia tartalma (1)
Paste Special
Calculations in the Table - Repetition

4. Calculations in the Table - Repetition

One of Excel's main functions is performing various calculations.
4 1 6 1 1
Lecke multimédia tartalma (1)
Calculations in the Table - Review
Using Functions - Repetition

5. Using Functions - Repetition

In Excel, we can use a variety of functions for calculations. Depending on the type of problem, we can choose from numerous categories available in the function library.
4 1 4 1 1
Lecke multimédia tartalma (1)
Using Functions – Revision
The IF function

6. The IF function

It evaluates the condition we specify, and if the condition is true, it displays one value in the cell, and if false, another.
5 1 6 1 1
Lecke multimédia tartalma (1)
The IF function
Nesting Functions

7. Nesting Functions

During our work, we may need to apply multiple functions at once to solve a problem.
5 1 6 1 1
Lecke multimédia tartalma (1)
Nesting Functions
The COUNTIFS Function

8. The COUNTIFS Function

With the help of this function, we can count how many cells in a specific range meet the condition we specify.
5 1 5 1 1
Lecke multimédia tartalma (1)
COUNTIFS Function
SUMIFS and AVERAGEIFS Functions

9. SUMIFS and AVERAGEIFS Functions

During our work with tables, there might be instances where we are interested in the sum or average of rows that meet specific criteria.
4 1 4 1 1
Lecke multimédia tartalma (1)
SUMIFS and AVERAGEIFS Functions
Searching with the VLOOKUP Function

10. Searching with the VLOOKUP Function

During our work, we often encounter search-related tasks.
6 1 6 1 1
Lecke multimédia tartalma (1)
Searching with the VLOOKUP function
Searching with the XLOOKUP Function

11. Searching with the XLOOKUP Function

For search tasks, in addition to using the VLOOKUP function, we can also use the XLOOKUP function!
4 2 8 1 2
Lecke multimédia tartalma (2)
Searching with the XLOOKUP Function
Searching with the XLOOKUP Function Based on Word Fragment
Error Handling

12. Error Handling

When working with tables, there may be a time when the result of a formula is some sort of error message, which isn't necessarily our fault.
5 1 5 1 1
Lecke multimédia tartalma (1)
Error Handling
Rounding Numbers

13. Rounding Numbers

Working with tables often requires rounding.
4 1 4 1 1
Lecke multimédia tartalma (1)
Rounding Numbers
Handling Date and Time Values in Excel

14. Handling Date and Time Values in Excel

When working with spreadsheets, we frequently encounter date and time values.
5 1 6 1 1
Lecke multimédia tartalma (1)
Handling Date and Time Values in Excel
Text Handling in Excel

15. Text Handling in Excel

Let's familiarize ourselves with another useful feature of Excel, the Text to Columns.
8 1 8 1 1
Lecke multimédia tartalma (1)
Text handling in Excel
Text Functions

16. Text Functions

When working with tables, we often encounter situations where we need to combine values from separate cells into a single cell.
3 1 3 1 1
Lecke multimédia tartalma (1)
Text Functions
Other Functions Related to Formulas

17. Other Functions Related to Formulas

Now that we are familiar with several functions and techniques for creating complex formulas, let's look at some other useful features related to them.
6 1 6 1 1
Lecke multimédia tartalma (1)
Other Functions Related to Formulas
Use of Advanced Filtering

18. Use of Advanced Filtering

The AutoFilter feature in Excel is very commonly used to filter out important information from tables. When conditions are set for multiple columns, there is a logical AND relationship between them. But what if we need a logical OR relationship between conditions?
4 1 4 1 1
Lecke multimédia tartalma (1)
Use Of Advanced Filtering
Conditional Formatting

19. Conditional Formatting

We can extract important information from our tables in various ways. One solution is to use conditional formatting.
10 2 11 1 1
Lecke multimédia tartalma (2)
Using Conditional Formatting
Conditional Formatting – Additional Options
Filtering Duplicates

20. Filtering Duplicates

During our work, we often encounter data in tables that occur multiple times. There are several methods for detecting duplicates, and conditional formatting is one of them.
5 1 5 1 1
Lecke multimédia tartalma (1)
Filtering out Duplicates
Charts and Sparklines

21. Charts and Sparklines

Charts and Sparklines are a powerful tool for visualizing numerical data from our spreadsheets.
15 3 16 1 3
Lecke multimédia tartalma (3)
Charts
Charts
Sparklines
Table function

22. Table function

The Excel Table function is a versatile tool, offering significant benefits, particularly in creating reports and analyzing data.
7 1 7 1 1
Lecke multimédia tartalma (1)
Table function
Creating a Pivot Table

23. Creating a Pivot Table

A pivot table is needed when we want to create a summary from a larger dataset.
10 2 10 1 1
Lecke multimédia tartalma (2)
Creating a Pivot Table
Creating A Pivot Table - Continuation

Excel Intermediate e-learning

The e-learning material builds on a basic knowledge of Excel and introduces more efficient and advanced ways of using the application. It helps learners deepen their understanding of formulas and functions, including nested functions, conditional calculations, and lookups using the VLOOKUP and XLOOKUP functions. The course also covers features that support everyday work, such as error handling, working with date, time and text data, advanced filtering and Paste Special, conditional formatting, and identifying duplicate values. It also introduces the use of charts and sparklines, the Table feature, and the creation of PivotTables.

Price: HUF 23,000. By clicking the DEMO button, you can view one of the lessons of the course material without registration.

Access duration: 365 days

Flexible learning: The e-learning course can be completed independently, according to your own schedule and at your own pace. The course material can be accessed anytime and from anywhere during the access period, allowing learning to be flexibly incorporated into your daily schedule. Completing the entire course is to take approximately 15 hours.

Köszönjük értékelését!

Ha szeretne szöveges értékelést is megadni, kérjük írja le véleményét:

Küldés Mégse

Tananyagok

rendezés: