Excel formulas: Learn & Try

Learn what a spreadsheet function does, see how its syntax works, and try supported examples with your own values. Excel formulas brings together a formula reference, hands-on practice, chart creation and study tools for students, office users and people preparing for spreadsheet interviews.

Understand functions in context
Browse 14 function families, from logical, text and math functions to date and time, lookup and reference, statistics and financial calculations. The library also covers database, engineering, information, compatibility, cube, web, and add-in topics. These are learning topics: each lesson helps you understand the function rather than promising access to external data services.

Open a lesson to read its explanation, review the syntax and examine examples. Move through the category with Previous and Next controls, save a useful formula, or mark the lesson complete. Search across formula names, category information, use cases and interview questions when you need a focused starting point.

Practice with a live worksheet
The Formula Playground gives you an editable grid, a formula input and a result display. Change cell values or adjust an expression to see how a supported calculation responds. Selected lesson examples offer a Try It button that opens the practice grid with the example formula and data. Quick input keys help enter operators, brackets and range punctuation on a phone.

Use the playground to explore totals, averages, conditions and references in small datasets. It supports a selection of functions for practice; the learning library is broader than the calculation engine. Check results against the lesson and the spreadsheet software you use for your actual work.

Turn entered data into charts
Build a chart from a worksheet of labels and numbers. Add or remove rows and columns, edit the chart title, then choose column, bar, line, area, pie, doughnut, scatter or radar. Preview the chart alongside its data table before saving. Export the chart as a PNG image or PDF, or share its image through the device's sharing options.

Make learning easier to resume
Find a daily formula on Home, mark it complete and follow your current streak and 30-day challenge. The Learning Hub includes beginner, intermediate and advanced paths with category completion progress. Continue learning and Recently Viewed help you return to a lesson, while saved formulas keep useful references close at hand. An optional daily reminder can prompt you to study after notification permission is granted.

Review beyond formulas
Browse desktop keyboard shortcut references, read practical spreadsheet tips and prepare with interview questions and answers. Take timed quizzes through Bronze, Silver, Gold and Diamond levels, view results and revisit quiz history. Meeting a level's passing requirement unlocks an in-app certificate you can save or share as a record of practice.

Choose light, dark or system appearance for reading. Favorites and learning progress are stored locally on the device. The app includes advertising, and certificate achievements represent in-app learning activity. Excel formulas is an independent learning app and is not affiliated with or endorsed by Microsoft.