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

Будьте в курсе последних новостей, методов и ресурсов по Excel. Наши учебные материалы содержат практические пошаговые разборы и кейсы, которые помогут вам повысить квалификацию.

Другие технологии:

Обучение двух или более человек?Попробуйте DataCamp for Business

Claude in Excel: Anthropic's AI Excel Assistant

A beginner-friendly guide to using Claude inside Excel. You’ll learn what it actually does, where it's most helpful, and how to use it safely in real spreadsheets without breaking anything.

28 января 2026 г.

Gridlines in Excel: How to Add, Print, and Remove

Understand how Excel gridlines work, when they appear, and how they are different from borders. Learn to create clear worksheets on screen and in print.

27 января 2026 г.

How to Clear Excel Cache (Windows and Mac)

Learn how to clear Excel cache on Windows and Mac to solve common problems like lag and sync errors, and follow best practices to keep Excel running smoothly.

26 января 2026 г.

Excel Version History: How to View, Restore, and Recover Your Work

Learn how Excel version history helps you view, restore, and recover previous file versions without losing your current work.

23 января 2026 г.

How to Add Days to a Date in Excel: All Methods Explained

Learn how to add days to a date in Excel using simple arithmetic and functions like DATE(), EDATE(), and WORKDAY(), with practical examples and pitfalls to avoid.

22 января 2026 г.

How to Show Formulas in Excel (Instead of Results)

Learn how to show formulas for a full worksheet, check individual cells, prepare files for review or printing, and avoid common issues.

15 января 2026 г.

Reduce Excel File Size: Effective Methods That Actually Work

Large Excel files slow everything down and make sharing harder than it should be. This guide explains why Excel files grow over time and shows practical, safe ways to reduce file size.

10 января 2026 г.

Excel Power Pivot: A Step-by-Step Guide

Learn how to connect tables, write DAX formulas, and build interactive reports inside Excel.

6 января 2026 г.

SUMPRODUCT() Excel: What You Should Know

A practical guide to using SUMPRODUCT() for conditional, weighted, and matrix-based calculations in Excel

6 января 2026 г.

How to Find Circular References in Excel

Learn what circular references are, why they cause problems, and how to fix them using simple and advanced techniques.

5 января 2026 г.

Excel Solver: Optimize Complex Decisions with Multiple Variables

Learn how to use Excel Solver to solve optimization problems with multiple constraints and decision variables. This guide covers setup, solving, and interpreting results with a practical example.

12 декабря 2025 г.

How to Freeze Multiple Rows in Excel

Learn how to freeze multiple rows in Excel with step-by-step instructions, tips, and troubleshooting to keep your headers visible while scrolling.

8 декабря 2025 г.