xlsnippets | Learn Excel

COUNTA function

: Statistical Functions

Count how many values are in a list of arguments

COUNTA(value1, [value2], ...)

Waterfall chart

: Waterfall, Funnel or Surface Charts

Plots data as a series of color-coded, positive and negative floating columns.

Also known as a bridge chart, shows the impact of additions and subtractions to an initial value.

Useful for visually displaying running totals.

TEXT function

: Text Functions

Format numbers as text by applying format codes.

TEXT(value, format_text)

ISTEXT function

: Information Functions

Return the logical value TRUE if the cell contains any text.

=ISTEXT(value)

ISERR function

: Information Functions

Return the logical value TRUE for any error type except the #N/A error.

=ISERR(value)

SUM function

: Math & Trigonometry Functions

Sum (add) values together.

=SUM(number1,number2,…)

AVERAGEIF function

: Statistical Functions

Calculate the average of numbers in a range that meet specific criteria.

AVERAGEIF(range, criteria, [average_range])

2D Line chart

: Line or Area Charts

Plots data in order and joins with a 2D line.

Track changes or trends over time.

3D option is also available.

Clustered Bar chart

: Column or Bar Charts

Plots data in horizontal bars by category.

Make comparisons between discrete categories.

2D and 3D options are available.

OFFSET function

: Lookup & Reference Functions

Return a reference that is a specified number of rows and columns from a starting point

=OFFSET(reference, rows, cols, [height], [width])

XLOOKUP function

: Lookup & Reference Functions

Lookup values in vertical or horizontal ranges

=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])

NOT function

: Logical Functions

Return the reverse of TRUE or FALSE statements based on testing logical conditions

=NOT(logical)

ISNUMBER function

: Information Functions

Return the logical value TRUE if the cell contains a number.

=ISNUMBER(value)

MID function

: Text Functions

Extract characters from within a text string.

MID(text, start_num, num_chars), MIDB(text, start_num, num_bytes)

IF function

: Logical Functions

Return different TRUE and FALSE results from logical tests

=IF(logical_test,[value_if_true],[value_if_false])

RAND function

: Math & Trigonometry Functions

Return a random number between 0 and 1

=RAND()

LOWER UPPER PROPER functions

: Text Functions

Convert text into lowercase, uppercase or capitalize the first letter in a string.

LOWER(text), UPPER(text), PROPER(text)

CLEAN function

: Text Functions

Remove non-printing characters from a text string.

CLEAN(text)

Pie of pie chart

: Pie or Doughnut Charts

Plots data proportional to the sum of items.

Data points shown as a percentage of the whole.

Smaller values displayed in a secondary pie.

ISNONTEXT function

: Information Functions

Return the logical value TRUE if the cell contains any value that is not text.

=ISNONTEXT(value)

Register (for free!) or Login to access bonus materials

About xlsnippets

Learn how to master functions, charts, pivot tables and more using Excel for Microsoft Office 365. Simple instructions and embedded spreadsheets help you practise the basics.

Latest Updates

TEXT() function 26 March 2022

TEXTJOIN() function 26 March 2022

REPLACE() function 26 March 2022

RANK.AVG() function 25 March 2022

CONCAT() function 22 March 2022

Most Popular

Coming soon

xlsnippets.com is currently in beta version. More functions and bonus content for registered users will be added weekly. Detailed training courses with additional downloadable resources are also on the horizon!