xlsnippets | Learn Excel

Radar chart

: Stock or Radar Charts

Plots data on a common axis radiating out from the center of the chart.

Useful for plotting responses to questionnaires or performance reviews.

Available in wireframe (with or without markers) or filled versions.

Sunburst chart

: Hierarchy Charts

Plots data within a hierarchical structure.

Segments are sized proportionally based on values.

Effective at showing how a category is broken into its contributing pieces.

CHOOSE function

: Lookup & Reference Functions

Returns a value from a list based on an index number.

=CHOOSE(index_num, value1, [value2], ...)

ABS function

: Math & Trigonometry Functions

Return the absolute value of a number

=ABS(number)

RANDBETWEEN function

: Math & Trigonometry Functions

Return a random integer number between 2 values

=RANDBETWEEN(bottom,top)

MID function

: Text Functions

Extract characters from within a text string.

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

ROUNDDOWN function

: Math & Trigonometry Functions

Round a number down to a specified number of digits

=ROUNDDOWN(number, num_digits)

ROUNDUP function

: Math & Trigonometry Functions

Round a number up to a specified number of digits

=ROUNDUP(number, num_digits)

ROUND function

: Math & Trigonometry Functions

Round a number to a specified number of digits

=ROUND(number, num_digits)

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])

MATCH function

: Lookup & Reference Functions

Return the relative position of a specified item in a range

=MATCH(lookup_value, lookup_array, [match_type])

MEDIAN function

: Statistical Functions

Returns the median or middle number in a data set.

=MEDIAN(number1, [number2], ...)

AVERAGEIF function

: Statistical Functions

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

AVERAGEIF(range, criteria, [average_range])

AND function

: Logical Functions

Return TRUE or FALSE statements based on testing multiple logical conditions

=AND(logical1, [logical2], ...)

Doughnut chart

: Pie or Doughnut Charts

Plots data proportional to the sum of items.

Data points shown as a percentage of the whole.

Unlike a pie chart, can display multiple categories.

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.

Sparklines

: Pivot Charts and Sparklines

Plots data as miniature charts within a worksheet cell.

Available in line, column or win/loss formats.

Position Sparklines near data for maximum impact.

ISBLANK function

: Information Functions

Return the logical value TRUE if a cell is blank or empty

=ISBLANK(value)

REPT function

: Text Functions

Repeat a specific text string by a number of instances.

REPT(text, number_times)

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

TEXTJOIN() function 26 March 2022

REPLACE() function 26 March 2022

TEXT() 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!