Course description
The training content is focused on advanced functions and tools that are most commonly used in Excel for complex calculations or when working with large volumes of data.
Participants will learn how to format cells based on specific rules. Through various examples, they will practice using popular functions such as IF, VLOOKUP, SUMIF, COUNTIF, and others.
They will discover which functions are useful for working with text, dates, and time. They will learn how to combine and nest functions, quickly identify errors in formulas, and correct them.
The course also covers linking worksheets and workbooks, as well as merging data from multiple tables. Participants will be introduced to best practices for preparing data in Excel and tools for working with large datasets.
They will explore advanced options for filtering, sorting, and grouping data, as well as analyzing data using pivot tables. They will learn how to use different pivot table settings and views.
Finally, they will learn how to visualize data using various chart types, including combined and pivot charts.
