50 Microsoft Excel Functions with Interactive Emulator
Learn the most useful Excel formulas through a responsive WordPress-ready emulator. Type a formula, choose a suggestion, or click “Use in Emulator” from the table. The visual canvas explains what happens in the workbook, table, formula cell, lookup map, and report layer.
Learning note: emulator output is simulated for training. Real results can vary by Excel version, language/locale settings, separators, workbook data, table names, date settings, and Microsoft 365 availability.
Responsive Microsoft Excel Emulator
The FREE pack is active now with 50 formulas and 10 guided challenges. LITE, PRO, and PRO Plus are shown as upcoming tiers for deeper labs, scoring, downloads, and advanced dashboards.
Challenge: run
=SUM(B2:B10) to start your Excel session.EXCEL WORKSPACE
WORKBOOK SCOPE 0
excel-runbook.xlsx0/10
Microsoft Excel
FREE challenges are available now. LITE, PRO, and PRO Plus will be available soon with more guided labs and deeper scoring.
Expected workbook formulas
=SUM(B2:B10)Run the next formula to receive guided feedback.
Run the next formula to receive guided feedback.
Excel Visual CanvasNo changes yet: run a formula to move simulated Excel resources.
What is happening?Run an Excel formula to see how the emulator updates the workbook, data table, formula cells, lookup map, and dashboard layer.
WORKSPACE OUTPUT
waiting$ Waiting for an Excel formula... Run a formula to see simulated output here.
$ Excel Emulator Ready Tip: choose a function from the table and click "Use in Emulator".
On small screens, the table automatically becomes cards so content is not cut off.
| # | Function / Command | Description | Example | Actions |
|---|---|---|---|---|
| 1 | SUM | Add numbers in a range. | =SUM(B2:B10) | |
| 2 | AVERAGE | Calculate the arithmetic mean of a range. | =AVERAGE(B2:B10) | |
| 3 | MIN | Return the smallest value in a range. | =MIN(B2:B10) | |
| 4 | MAX | Return the largest value in a range. | =MAX(B2:B10) | |
| 5 | COUNT | Count cells that contain numbers. | =COUNT(B2:B100) | |
| 6 | COUNTA | Count cells that are not empty. | =COUNTA(A2:A100) | |
| 7 | COUNTBLANK | Count empty cells in a range. | =COUNTBLANK(C2:C100) | |
| 8 | IF | Return one value when a condition is true and another when false. | =IF(D2>=90,"Bonus","Review") | |
| 9 | IFS | Evaluate multiple conditions in order. | =IFS(D2>=90,"High",D2>=70,"Medium",TRUE,"Low") | |
| 10 | AND | Return TRUE when all conditions are true. | =AND(D2>=90,E2="Yes") | |
| 11 | OR | Return TRUE when at least one condition is true. | =OR(F2="Urgent",G2>1000) | |
| 12 | NOT | Reverse TRUE/FALSE logic. | =NOT(H2="Closed") | |
| 13 | SUMIF | Sum values that match one condition. | =SUMIF(C2:C100,"North",D2:D100) | |
| 14 | SUMIFS | Sum values that match multiple conditions. | =SUMIFS(E:E,B:B,"North",C:C,"Pro") | |
| 15 | COUNTIF | Count rows that match one condition. | =COUNTIF(C2:C100,"North") | |
| 16 | COUNTIFS | Count rows that match multiple conditions. | =COUNTIFS(B:B,"North",C:C,"Pro") | |
| 17 | AVERAGEIF | Average values that match one condition. | =AVERAGEIF(C2:C100,"North",D2:D100) | |
| 18 | XLOOKUP | Look up a value and return a related result. | =XLOOKUP(A2,Products[SKU],Products[Price]) | |
| 19 | VLOOKUP | Search vertically in a table and return a column value. | =VLOOKUP(A2,Products!A:D,4,FALSE) | |
| 20 | HLOOKUP | Search horizontally in a table and return a row value. | =HLOOKUP(B1,A1:H5,3,FALSE) | |
| 21 | INDEX | Return a value from a position in a range. | =INDEX(B2:B20,5) | |
| 22 | MATCH | Return the position of a lookup value. | =MATCH(E2,A2:A20,0) | |
| 23 | FILTER | Return rows that meet a condition. | =FILTER(A2:D100,D2:D100>1000) | |
| 24 | SORT | Sort a range or array. | =SORT(A2:D100,4,-1) | |
| 25 | UNIQUE | Return unique values from a list. | =UNIQUE(C2:C100) | |
| 26 | TEXT | Format a number or date as text. | =TEXT(TODAY(),"yyyy-mm-dd") | |
| 27 | CONCAT | Join text values together. | =CONCAT(A2," - ",B2) | |
| 28 | TEXTJOIN | Join text values with a delimiter while optionally ignoring blanks. | =TEXTJOIN(" | ",TRUE,A2:C2) | |
| 29 | LEFT | Extract characters from the left side of text. | =LEFT(A2,3) | |
| 30 | RIGHT | Extract characters from the right side of text. | =RIGHT(A2,4) | |
| 31 | MID | Extract characters from the middle of text. | =MID(A2,5,3) | |
| 32 | LEN | Return the number of characters in text. | =LEN(A2) | |
| 33 | TRIM | Remove extra spaces from text. | =TRIM(A2) | |
| 34 | UPPER | Convert text to uppercase. | =UPPER(A2) | |
| 35 | LOWER | Convert text to lowercase. | =LOWER(A2) | |
| 36 | PROPER | Capitalize the first letter of each word. | =PROPER(A2) | |
| 37 | TODAY | Return the current date. | =TODAY() | |
| 38 | NOW | Return the current date and time. | =NOW() | |
| 39 | YEAR | Extract the year from a date. | =YEAR(A2) | |
| 40 | MONTH | Extract the month number from a date. | =MONTH(A2) | |
| 41 | DAY | Extract the day number from a date. | =DAY(A2) | |
| 42 | DATE | Create a date from year, month, and day. | =DATE(2026,6,9) | |
| 43 | NETWORKDAYS | Count working days between two dates. | =NETWORKDAYS(A2,B2) | |
| 44 | IFERROR | Return a fallback value when a formula has an error. | =IFERROR(H2/I2,0) | |
| 45 | ROUND | Round a number to a specified number of digits. | =ROUND(D2,2) | |
| 46 | ROUNDUP | Round a number upward. | =ROUNDUP(E2,0) | |
| 47 | ROUNDDOWN | Round a number downward. | =ROUNDDOWN(E2,0) | |
| 48 | ABS | Return the absolute value of a number. | =ABS(F2) | |
| 49 | SUBTOTAL | Calculate subtotal values that can respect filters. | =SUBTOTAL(9,D2:D100) | |
| 50 | PMT | Calculate a loan payment based on constant payments and interest rate. | =PMT(8%/12,36,-25000) |
Conclusion
This Microsoft Excel FREE emulator is ready. The FREE version includes the active formula table, visual canvas, and 10 guided challenges. LITE, PRO, and PRO Plus are visible as upcoming expansion tiers for guided workbooks, advanced dashboards, downloadable exercises, stronger scoring, and business cases.