Excel DailyDrills is a browser-based practice app for learning Microsoft Excel by doing rather than by reading. Each lesson opens a real spreadsheet grid in the browser, and the learner types the formula themselves, presses Check, and finds out immediately whether it works. The course contains 49 lessons with 300 exercises, running from the very first cell reference through SUM, IF, VLOOKUP, XLOOKUP, INDEX and MATCH, conditional sums, text and date functions, dynamic arrays, pivot tables and keyboard shortcuts. It is built for beginners who have opened Excel a few times and want to finally feel comfortable with formulas, students and job seekers preparing for Excel tests in job interviews, internships or courses, and office workers who use Excel every day but copy formulas without fully trusting them.
The product addresses a specific gap: reading about Excel is not the same as being able to produce a formula under pressure. What makes a skill last, according to the product, is retrieval — having to produce the answer yourself — and every exercise is designed around that, with an instant check so you never practice a mistake for long. The tasks also look like real work: you fill in a price list, grade a test, total the sales of one region, clean up messy names, or find the matching record in a second table. Because learners type into a real grid, they pick up the details that trip people up in Excel: where the commas go, when to lock a reference with $, why a lookup returns #N/A, and how to read an error instead of fearing it.
The Fundamentals section covers the grid — cells, rows and columns, cell names, ranges and what cells can hold — followed by first formulas using =, + − * / and cell references, relative and absolute references with the $ sign, and sheet editing such as filling, inserting, moving and undoing. It continues with adding up with SUM, summarizing a list with AVERAGE, MIN, MAX and COUNT, ranking values with LARGE and SMALL, rounding with ROUND, ROUNDUP and ROUNDDOWN, number formats for currency, percent and dates, decisions with IF, and combining tests with AND, OR and NOT.
The Errors and conditions section teaches how to read errors and use IFERROR (#DIV/0!, #NAME?, #REF! and #VALUE!), how to check cells with ISBLANK, ISNUMBER, ISERROR and IFNA, counting by condition with COUNTIF and COUNTIFS, summing by condition with SUMIF, SUMIFS, AVERAGEIF and AVERAGEIFS, SUMPRODUCT for multiplying and adding in one step without helper columns, and HLOOKUP plus tests with SWITCH and XOR. The Lookups section then covers finding data with XLOOKUP, the classic VLOOKUP including approximate matches, INDEX and MATCH for two-way lookups, CHOOSE and SUBTOTAL for picking by number and totaling filtered lists, and OFFSET and INDIRECT for references built on the fly.
Text and dates includes pulling text apart with LEFT, RIGHT, MID, LEN and FIND, extracting the first and last word from a full name, cleaning and joining text with TRIM, PROPER, UPPER, LOWER, SUBSTITUTE, & and TEXTJOIN, more text tools such as SEARCH, VALUE and UPPER, data cleaning tools like Find & Replace, Flash Fill and Text to Columns, sorting and filtering a list, and date work with YEAR, MONTH, DAY, DATE, EOMONTH, EDATE, NETWORKDAYS, DATEDIF, DAYS, WEEKDAY and WORKDAY. Statistics, charts and tables covers MEDIAN, MODE.SNGL, RANK.EQ and STDEV.S, math helpers such as MOD, INT, ABS, CEILING and RAND, Conditional Formatting, charts, Tables and named ranges, finance functions FV, PMT and NPV, Power Query and Power Pivot, and protecting cells and adding comments.
Modern Excel and speed covers dynamic arrays with UNIQUE, SORT and FILTER, more modern functions including XMATCH, SEQUENCE, LET and TAKE, TEXTSPLIT and VSTACK, keyboard shortcuts for navigation, working with the ribbon from the keyboard, pivot tables as summaries without formulas, drop-down lists and data validation, and fast formatting with shortcuts and Format Painter. Three case studies — a bakery's week, a gym's members and a skills check on a repair shop's job log — put everything together on realistic data. The course deliberately teaches both the modern tools, because they are faster to write and easier to read, and the classics found in older workbooks, so learners can read them, fix them and decide when to replace them. XLOOKUP and dynamic arrays need Excel 2021 or newer, while the classics work in every version.
A lesson follows a consistent rhythm. Each new idea comes with a short explanation, a few sentences and a small table, never a wall of text. The learner then solves a task in a real grid: some tasks ask for a formula, some ask you to predict a result or spot the bug in someone else's formula, and the shortcut lessons ask you to press the right keys. Answers are checked the moment Check is pressed; if stuck, a learner can ask for a hint or reveal the answer with an explanation of why it works. Review mode brings back the skills that were hard a little later, and it is always optional. Learners earn XP for every exercise and level up as they go, and can set a daily goal and keep a streak. A short placement test lets people who already know the basics skip ahead to the lessons that are new to them.
The benefits are framed around durability and transfer. Retrieval practice plus instant feedback means mistakes are corrected quickly rather than repeated. Realistic tasks mean that when the same problem shows up at work, the learner has already solved it once. Typing into a real grid builds familiarity with syntax details, reference locking and error messages. Because the exercises run in the browser with nothing to download, practice is available on any computer, and what is learned works the same way in Excel on Windows, with almost everything also applying to Excel for Mac and Excel for the web. Most formulas also work the same way in Google Sheets, though the course follows Excel's exact syntax and behavior.
Typical use cases map closely to the exercises described. A job seeker preparing for an Excel test in an interview can use the drills and the dedicated test-practice material. An office worker who copies formulas without trusting them can work through conditional sums and lookups to understand what the formulas actually do. Someone handed a messy export can practice Find & Replace, Flash Fill, Text to Columns, TRIM and SUBSTITUTE on realistic data. Analysts can rehearse VLOOKUP, XLOOKUP and INDEX/MATCH against a second table, and learners who want a habit can set a daily goal and keep a streak with short drills. Teams and classes use a Team or Education plan, where managers and teachers invite people, assign lessons and follow everyone's progress on a dashboard.
The free tier covers the first 10 lessons, the placement test, hints, answers and a daily review session, with no time limit and no credit card, and no account is needed for the first exercises — progress made before creating a free account comes with you. Pro unlocks all lessons, the case studies and unlimited review. Function names are shown in the learner's own language, so SUM, SOMME or SUMME appears as the user's Excel shows it, and the product is available in 11 languages with guides and exercises from basics to advanced. A separate Excel functions guide explains the most used functions with worked examples and common mistakes, including VLOOKUP, XLOOKUP, INDEX, MATCH, IF, COUNTIFS, SUMIFS, SUM, AVERAGE and ROUND, plus a guide to cell references for anyone confused by the $ sign.
In short, Excel DailyDrills turns Excel learning into a short, repeatable daily practice: a live grid, a formula you type yourself, an immediate check, and a review loop that brings back what was hard. It is a way to get really good at Excel through typing rather than watching, with the first formula one click away.