Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Learn Named Range | Sorting, Filtering and Cleaning Data
Google Spreadsheets
course content

Course Content

Google Spreadsheets

Google Spreadsheets

1. Introduction to Google Sheets
Why do you need Google Sheets?Creating Google SheetsOpening Google SheetsRenaming Google SheetsCopying Google SheetsDeleting Google SheetsMoving Google SheetsDownloading Google Sheets
2. Formatting of Cells and Ranges
Basic Editing OperationsFormatting DataWorking with FontsFormatting Text and Filling with ColorFormatting BordersMerging Cells and Text AlignmentClear Formatting and Paint Format ToolsSelecting Cells and RangesAdjusting Column and Row Size and PositionCopying and Deleting Columns and Rows Freezing and Grouping Rows and Columns
3. Advanced Formatting of Cells
Splitting Text to ColumnsTrimming WhitespacesInserting Internal and External HyperlinksAutocompleting CellsCreating CheckboxesCreating FormsAdding NotesAdding ImagesCreating DrawingsChallenge: Mastering Event Planning ChallengeChallenge: Your Event, Your Plan
4. Sorting, Filtering and Cleaning Data
Find and ReplaceSorting RangeSearching Filter and Filter by ConditionCustom Filter ViewsConditional Formatting and Color Scale Using SlicersNamed Range Removing DuplicatesChallenge: Library Book List Management
5. Creating Charts
Line ChartBasic Chart SettingsChart Style and Chart and Axis TitlesLegend, Gridlines and TicksHorizontal and Vertical Axis CustomizationArea ChartColumns and Stacked ColumnsPie ChartChallenge: Data Visualization Sprint Sales Insights
6. Basic Functions
Basic CalculationsArithmetic Functions Statistical FunctionsRounding FunctionsWorking with Numbers and Integers Working with Roots and PowersRandom Number GenerationText Functions Working with Dates and TimeSort FunctionChallenge: Sales Visualization Trends and Analytics
7. Logical Functions
AND and OR FunctionsIF and Nested IF FunctionsIFS FunctionSUMIFS, COUNTIFS and AVERAGEIFSChallenge: Employee Performance and Payroll Analysis with Excel Functions
8. Collaboration and Security
Access Control and Real-Time Document CollaborationNotification Rules Chatting with Other UsersProtecting Sheets and RangesComments and Google Meet IntegrationVersion History and Data Recovery

book
Named Range

In this chapter we will cover the topic Named Range. You will learn how to use this tool to assign names to ranges of cells, making it easier to reference them in formulas and improving the readability of your tables. This is especially useful for creating more understandable and easily editable formulas.

Adding a Named Range

  • Select the range of cells you want to name;
  • Go to Data → Named ranges;
  • Enter a name for the range in the Name field (e.g., Price);
  • If there's a cell name, insert the number next to the letter that corresponds to the first cell in the range, without the column name before the colon :;
  • Click Done.

Example of Use

Open our real estate data table.

  • Using a Named Range in a formula to calculate the average house price:
    • Create a new Named Range for house prices: select cells H2
      and name it Price;
    • Enter the formula to calculate the average house price:
      =AVERAGE(Price);
  • Counting the number of houses built after 2000:
    • Create a new Named Range for the year built: select cells D2
      and name it Year_Built;
    • Enter the formula to count the number of houses built after 2000:
      =COUNTIF(Year_Built, ">2000").

Now, you can easily track the average house price and the number of houses built after 2000 using named ranges.

Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 4. Chapter 7
We're sorry to hear that something went wrong. What happened?
some-alt