Excel Cells & Ranges: Fundamentals and Core Operations
Course
This course introduces the fundamental concepts of working with cells and ranges in Microsoft Excel.
Skills you’ll gain: understanding Excel ranges, selecting and navigating cell ranges, modifying ranges, using basic Excel functions (SUM, AVERAGE, MAX, MIN, COUNT), and using named ranges in formulas.
Here is the course outline:
1. Fundamentals and FormattingCover basic cell operations, including data entry, cell formatting techniques such as font styles, borders, and alignment, as well as merging and splitting cells to improve data presentation and structure. 4 sections
|
||||
|
2. Working with Cell Ranges and Navigation BasicsLearn how Excel ranges work and how to efficiently select, navigate, and modify them. This module also introduces basic techniques for working with ranges in formulas, including simple functions like SUM, AVERAGE, MAX, MIN, and COUNT, as well as an introduction to named ranges for better data organization and formula use. 4 sections
|
||||
|
3. We want to hear from you!Learning Management System — NPS 1 section
|
|
|