Category:Excel
If you know Excel, please write code for some of the tasks not implemented in Excel.
Excel is a spreadsheet program from Microsoft Office suite applications. Excel provides calculations, cell referencing, and illustration of data sheets by using its functions, formulas, graphs, etc.
The Excel formula language consists of several hundred pure functions, and only constitutes a Turing-complete programming language in recent builds (Office 365 beta, since Dec 2020) which have introduced a LAMBDA function, and the ability to bind names to reusable custom functions in the Excel Name Manager.
The Excel formula language, for all its limitations, is arguably the most widely used programming language in the world.
Estimates of the number of users are typically in the region of 750 million.
(See The LAMBDA worksheet function)
(and, of course: XKCD 2453 - Excel Lambda)
Pages in category "Excel"
The following 75 pages are in this category, out of 75 total.
A
C
F
M
N
P
S
- SEDOLs
- Shift list elements to left by 3
- Show ASCII table
- Sierpinski carpet
- Sierpinski triangle
- Sleeping Beauty problem
- Smallest square that begins with n
- String case
- String concatenation
- Strip a set of characters from a string
- Sum digits of an integer
- Sum of a series
- Sum of elements below main diagonal of matrix
- Sum of first n cubes
- Sum of squares
- System time