Учебные материалы по Excel

The SUMIFS() function in Excel sums values that meet multiple criteria, making it useful for conditional calculations with numbers, dates, and text. Learn to use SUMIFS() with syntax, examples, and best practices.

Learn to create clear and informative line graphs in Excel. This guide walks you through each step, from setting up your data to customizing the graph for better readability.

Learn to subtract cells, columns, rows, and more in Excel using the minus sign, cell references, absolute references, and even by using the `SUM()` or SUMPRODUCT() functions.

Excel's CLEAN() function cleans up text by removing non-printable characters. Combine it with other functions like TRIM(), SUBSTITUTE(), and REPLACE() for a cleaner spreadsheet.

Explore how the TRIM() function removes extra spaces and cleans up your data. Combine it with other functions like SUBSTITUTE(), CLEAN(), and VALUE() to fix all kinds of formatting issues.

Learn to count unique values in Excel using basic and advanced formulas. See the difference between unique and distinct values.

There are multiple ways to generate random numbers in Excel, such as the `RAND(),` `RANDBETWEEN(),` and `RANDARRAY()` functions.

Merge two columns in Excel using the ampersand & operator or the CONCAT() function with a custom delimiter. Or use TEXTJOIN(), which lets you ignore blank cells.

Discover how to extract numbers from Excel strings using formulas. Master functions like RIGHT(), LEFT(), and TEXTJOIN() to target numeric data before, after, or anywhere in your text.

Explore simple subtraction for quick and effortless date calculations. Apply the DAYS() and DATEDIF() functions to achieve precise date intervals. Use NETWORKDAYS() and TODAY() to track working days and automatically exclude weekends and holidays.

Learn how to multiply in Excel, including how to multiply columns and rows. Learn to use simple formulas as well as functions like PRODUCT() and SUMPRODUCT().

Learn how to keep important rows and columns visible while you scroll in Excel. I’ve explained Freeze Panes step-by-step, with tips for solving everyday problems and improving your workflow.