Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to get first column number in range in Excel
  • Lookup entire row in Excel
  • How to use Excel ROWS Function
  • Extract data with helper column in Excel
  • How to calculate two-way lookup VLOOKUP in Excel Table

Data Analysis Examples

  • How to calculate current stock or inventory in Excel
  • How to create dynamic reference table name in Excel
  • Conditional Formatting Data bars Examples in Excel
  • How to combine 2 or more chart types in a single chart in Excel
  • Filter Data Based on Date in Excel

Data Validation Examples

  • Excel Data validation must begin with
  • Excel Data validation exists in list
  • Excel Data validation unique values only
  • Excel Data validation must not contain
  • Excel Data validation must contain specific text

Things you find in Excel Status Bar

by

The quickest way to see the average, count, numerical count, minimum, maximum or sum of selected cells is by taking a look at the status bar.

Worked Example:   Group and Ungroup Worksheets in Excel

1. Select a range of cells.

2. Look at the status bar at the bottom of your window to see the sum of these cells.

3. Right click the status bar to add the average, count, numerical count, minimum or maximum.

Worked Example:   Freeze and Unfreeze Panes in Excel

Result:

Worked Example:   Lock Cells in a Worksheet Excel

Post navigation

Previous Post:

Join Text Strings Using Concatenate or ‘& Operator’ in Excel

Next Post:

Understanding VBA Function and Sub in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Normalize text by removing punctuations, extra spaces and more in Excel
  • UPPER function: Description, Usage, Syntax, Examples and Explanation
  • How to display conditional message with REPT function in Excel
  • How to translate letters to numbers in Excel
  • Remove line breaks in a cell in Excel
  • Get days between dates in Excel
  • Get days, months, and years between dates in Excel
  • How to calculate nth day of week in month in Excel
  • Get first Monday before any date in Excel
  • Generate series of dates by weekends in Excel
  • How to calculate principal for given period in Excel
  • How to calculate simple interest in Excel
  • COUPDAYBS function: Description, Usage, Syntax, Examples and Explanation
  • PRICEDISC function: Description, Usage, Syntax, Examples and Explanation
  • NOMINAL function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles