What kinds of Excel tutorials and resources does Exceljet offer?

Updated

Exceljet is a learning site for Microsoft Excel built around short, example-driven material: formula walkthroughs, bite-sized videos, function references, and articles organized by topic. It suits people who want to see a working formula and its explanation rather than read a full textbook, and it covers everything from basic counting and summing to dynamic arrays, lookup, dates, pivot tables, and shortcuts.

Formula examples

The Featured Formulas section shows a concrete formula alongside the problem it solves. A representative example is counting birthdays by year, which uses SUMPRODUCT and YEAR:

=SUMPRODUCT(--(YEAR(data[Birthday])=E5))

Here data is an Excel Table, and the formula counts rows whose birthday year matches the value in E5. Other examples in this section include counting cells between dates and testing whether a cell contains a number. Each entry follows the same pattern: a stated task, the formula, and an explanation of how it works.

Short video tutorials

Featured Videos are short clips, typically two to four minutes, each focused on one technique. Examples listed on the site include:

  • How to generate random times
  • How to generate random dates
  • How to perform a random sort
  • How to use SUMIFS with an Excel Table

The short format works well when you want to see a technique performed rather than read about it, and the narrow scope means you can watch one clip to solve one problem.

Function references

Featured Functions explains individual Excel functions, what they return, and how they behave. Examples include:

Function Category What it does
UNIQUE Dynamic array Extracts unique values from a range or array; returns a dynamic array that updates when source data changes; not case-sensitive; works with text, numbers, dates, and other types
SORT Dynamic array Sorts a range or array
WORKDAY Date and time Returns a working day a given number of days away

These pages are useful when you know which function you need but want to confirm its arguments or edge-case behavior.

Articles and topic browsing

Recent Articles covers broader subjects that don't fit a single formula or function. Examples include combinations and permutations in Excel (with FACT and PERMUT), arrays in Excel, replacing the DATEDIF function, and a seeded random number generator. There is also a shortcuts article on the ones worth knowing.

Topics By Category organizes the whole library so you can browse by area rather than search. The categories include:

  • Formulas — count, sum, average, dynamic array, min and max, lookup, if, grouping, rank, round, date and time, text, financial, percentage, random, range, tables, errors
  • Shortcuts — file, ribbon, general, tables and filters, drag and drop, navigation, selection, active cell, extend selection, select special, cell edit mode, entering data, formatting, number formatting, borders, formulas, grid operations, pivot tables, workbook, dialog boxes
  • Functions — logical, date and time, lookup and reference, text, dynamic array, engineering, financial, information, math, trigonometry, statistical, web, database, user

How to choose where to start

If you have a specific task, start with a formula example or a function page. If you want to watch a technique, use the videos. If you are learning an area systematically, browse Topics By Category. The site also carries user testimonials, including one from a user who automated a long-standing budgeting problem in their industry.