Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Get column name from index in Excel Table
  • How to Use Solver Tool in Excel
  • How to calculate correlation coefficient Correlation in Excel
  • How to create a Histogram in Excel
  • Use Data Form to input, edit and delete records in Excel

References

  • Multi-criteria lookup and transpose in Excel
  • Convert text string to valid reference in Excel using Indirect function
  • How to get address of named range in Excel
  • Two-column Lookup in Excel
  • VLOOKUP function: Description, Usage, Syntax, Examples and Explanation

Data Validations

  • Excel Data validation specific characters only
  • Data validation must not exist in list
  • Excel Data validation exists in list
  • Excel Data validation allow weekday only
  • Excel Data validation date in next 30 days

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.

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.

Result:

Post navigation

Previous Post:

VLOOKUP without #N/A error in Excel

Next Post:

Manipulating text strings using Left, Mid, Right, Len, Substitute 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

Logical Functions

  • IFS function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel XOR Function
  • IF, AND, OR and NOT Functions Examples in Excel
  • AND function: Description, Usage, Syntax, Examples and Explanation
  • FALSE function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Add decimal hours to time in Excel
  • DAYS function: Description, Usage, Syntax, Examples and Explanation
  • Display Date is workday in Excel
  • Get day from date in Excel
  • Count times in a specific range in Excel

Grouping

  • Group numbers with VLOOKUP in Excel
  • How to randomly assign people to groups in Excel
  • Group times into unequal buckets in Excel
  • Group numbers at uneven intervals in Excel
  • Group arbitrary text values in Excel

General

  • How to count total number of cells in a rectangular range in Excel
  • Print Excel Sheet In Landscape Or Portrait
  • List sheet names with formula in Excel
  • How to calculate total from percentage in Excel
  • Using Existing Templates in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning