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

Lookup and Reference Examples

  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions
  • How to get first row number in range in Excel
  • Create hyperlink with VLOOKUP in Excel
  • Last row number in range
  • How to get relative row numbers in a range in Excel

Data Analysis Examples

  • Conditional Formatting Icon Sets Examples in Excel
  • Excel Line Chart
  • What-If Analysis: Scenarios and Goal Seek in Excel
  • Conditional Formatting Color Scales Examples in Excel
  • Excel Frequency Function Example

Data Validation Examples

  • How To Create Drop-down List in Excel
  • Excel Data validation require unique number
  • Excel Data validation must begin with
  • Prevent invalid data entering in specific cells
  • Excel Data validation whole percentage only

Category: Excel Functions

Count and Sum Functions in Excel

by

The most used functions in Excel are the functions that count and sum. COUNT function is one of the STATISTICAL functions while SUM function is one of the Math and Trig functions. You can count and sum based on one criteria or multiple criteria. Count To count the number of cells that contain numbers, use the COUNT function. Countif To count cells …

Continue Reading

IF, AND, OR and NOT Functions Examples in Excel

by

Learn how to use Excel’s logical functions such as the IF, AND, OR and NOT function. If The IF function checks whether a condition is met, and returns one value if true and another value if false. 1. For example, take a look at the IF function in cell C2 below. Above Case Study Explanation: if the …

Continue Reading

Change Case: Uppercase, Lowercase, Propercase in Excel

by

How to convert text to capital letters and more in Excel Often times computer users find it difficult to change case in Excel. Imagine working on a huge volume of excel data and you need to convert a record to capital letters or the reverse. Boom! your stuck because it is not word document. We all …

Continue Reading

Simple Excel Formulas and Functions

by

Every formula in Excel starts with an equal sign, function name then in bracket a cell name or cell ranges or cell references. See illustration below: =Function Name( cell name or cell ranges or cell references) Example: = SUM(A1:A4) A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel. …

Continue Reading

Posts navigation

  • Previous
  • 1
  • …
  • 18
  • 19
  • 20
  • 21

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
  • Remove unwanted characters in Excel
  • SEARCH, SEARCHB functions: Description, Usage, Syntax, Examples and Explanation
  • T function: Description, Usage, Syntax, Examples and Explanation
  • DBCS function: Description, Usage, Syntax, Examples and Explanation
  • Replace one character with another in Excel
  • SECOND function: Description, Usage, Syntax, Examples and Explanation
  • DATEVALUE function: Description, Usage, Syntax, Examples and Explanation
  • Convert decimal minutes to Excel time
  • How to show last updated date stamp in Excel
  • EDATE function: Description, Usage, Syntax, Examples and Explanation
  • Calculate cumulative loan interest in Excel
  • Calculate loan interest in given year in Excel
  • How to calculate principal for given period in Excel
  • RATE function: Description, Usage, Syntax, Examples and Explanation
  • Calculate original loan amount in Excel
© 2022 xlsoffice . All Right Reserved. | Teal Smiles