Video 06 Working with Ranges docx

Описание: This video covers the essential concepts of working with ranges and basic functions in Excel. It explains what ranges are (contiguous or non-contiguous groups of cells), demonstrates advanced selection techniques, and highlights best practices for naming ranges to improve formula clarity and workbook management. The video also introduces multi-sheet (3D) references for aggregating data across identically structured sheets, outlining their syntax, limitations, and use cases.
Core Excel functions discussed include SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, and COUNTBLANK, with special attention to what each function processes or ignores (such as numbers, text, blanks, or errors) and their behavior with mixed arguments and references.
The video also explains the difference between relative, absolute, and mixed references, and how to use them effectively when copying formulas. Viewers are encouraged to practice naming ranges, applying functions, and experimenting with reference types.