Stop reading formulas and start recalling them
You have watched the tutorials. You still open a blank cell, type an equal sign, and stall. That is not a knowledge problem, it is a recall problem — and recall comes from retrieval, not from reading. ExcelPower is a deck of 150 cards. Each one states a real task in plain English — return the value in C where B matches, total sales where region is North and status is Paid, work out the taxable value when the invoice already includes 18% GST — and the exact formula sits right underneath with a one-line note on why it works. The cards come three ways: an offline drill app that schedules them with five-box spaced repetition and tracks what you actually know, a printable A4 deck you can cut and keep beside the laptop, and a practice workbook where you type the formula into a real sheet with 40 rows of example data and check yourself against an answer key. Eight categories run from VLOOKUP and TRIM through GST arithmetic, EMI splits, ageing buckets, SUMIFS and the Excel 365 dynamic arrays. Nothing installs, nothing uploads, and nothing needs an internet connection.
One-time ₹199 ₹599 · instant download
The gap is recall, not information
Every Excel problem has a written answer somewhere, and that is exactly the problem: the answer is in a tab you closed, not in your head. Watching a video builds recognition — you nod at INDEX/MATCH and feel like you know it. Then a real sheet arrives with a code in column F and prices in column G, and the formula will not come.
A flashcard forces the other thing. You see the task, you attempt the formula in your head or on paper, and only then do you check. That attempt is what builds the memory, and getting it wrong is not a failure — it is the moment the card earns its place in the next session. ExcelPower pairs every card with a note that names the trap: that SUMIFS takes the sum range first while SUMIF takes it last, that a VLOOKUP with TRUE needs a sorted column, that dividing by 1.18 is not the same as subtracting 18%, that RANK ties share a number.
The deck is deliberately narrow. Formulas only. No PivotTables, no Power Query, no charts, no macros — because a deck that tries to cover everything teaches nothing well.
150 cards, spread so the everyday work dominates
VLOOKUP with and without IFERROR, INDEX/MATCH in both directions, XLOOKUP with a fallback and a slab mode, two-condition lookups, FILTER, the last non-blank value in a column, INDIRECT, HYPERLINK and the distinct-count formulas that work in old Excel.
TRIM, LEFT, RIGHT, MID, FIND, SEARCH, SUBSTITUTE and TEXTJOIN on data that arrived from a PDF, a bank statement or a WhatsApp forward. Split an email into user and domain, pad an invoice number to four digits, count a word inside a cell, kill the line breaks.
Ageing buckets that never go negative, EDATE and EOMONTH, due dates from credit days, NETWORKDAYS and WORKDAY, and the April-to-March financial year label in the form FY 2026-27 — the one formula every Indian MIS sheet needs and nobody remembers.
SUM, SUMIF, SUMPRODUCT, ROUND and its family, LARGE and SMALL, MEDIAN against AVERAGE on skewed invoice data, RANK, MROUND, SUBTOTAL for filtered rows and AGGREGATE for a range that already contains errors.
IF, nested IF, IFS, SWITCH, AND, OR, IFERROR against IFNA, the difference between blank and empty-string, duplicate flagging with an expanding range, and LET for formulas that name their own ranges.
PMT, IPMT, PPMT and CUMPRINC for a real loan; CAGR; SIP growth with FV; GST at 18% in both directions; margin versus markup, which is where quotes go wrong; break-even units; landed cost per unit; annualising a 90-day return.
SUMIFS and COUNTIFS with date ranges, month-to-date totals from a single cell, running totals and running balances, share of total, cumulative percentage for a Pareto, rank within a region, MAXIFS, and percentile-based flags.
FILTER with two conditions, UNIQUE with SORT, SEQUENCE for twelve month ends, VSTACK and HSTACK, TAKE and DROP, TEXTSPLIT, XLOOKUP returning a whole row, BYROW with LAMBDA, and LET around a filtered range. Every one of these is marked Excel 365.
Exactly as they appear in the deck and the app
Total the sales in D where region is "North" AND status is "Paid".
SUMIFS puts the sum range first — the opposite of SUMIF. This trips up almost everyone.
Label the Indian financial year for the date in A2, e.g. FY 2026-27.
April to March. Change the 4 if your year starts in a different month.
Work out the taxable value when the invoice total in A2 already includes 18% GST.
Divide, do not subtract 18%. The tax is on the base, not on the gross.
These three cards ship exactly as shown. Nothing in the deck is a placeholder.
One ZIP, seven files, 124 KB
One self-contained file. Study mode with search and category filters, a spaced-repetition drill across five boxes, a ten-question multiple-choice quiz that reshuffles every time, and a progress screen with mastery by category and a day streak. Keyboard shortcuts: space to reveal, 1-2-3 to grade. Works with the Wi-Fi off.
The full deck, ten cards per A4 sheet, framed and ready to cut. 15 sheets, single-sided on purpose so the answer is right there to cover with your hand. Every card carries its category, level and card number.
All 150 formulas on four pages, grouped by category, task beside formula. Print it for the wall or keep it open in a second window while you work.
40 rows of clearly labelled example sales data, 24 practice tasks with gold answer cells, and an answer key that gives the exact formula plus one line on why it works. Five sheets, no macros.
All 150 cards as structured data — id, category, level, task, formula, note. For anyone who wants to build their own tool on top of the deck.
Tab-separated, front and back, ready for Anki File > Import or the Quizlet import box. If you already live in a spaced-repetition app, you do not have to switch.
A one-page guide: what each file is, the three-minute start, how the five boxes work, how to print at 100% scale, how to import into Anki, and what the deck deliberately does not cover.
Single-user commercial licence in plain English. Use it in paid work for clients; do not resell, share or republish the cards.
People whose day job is a spreadsheet
Receivables ageing, GST-inclusive totals, payment statuses, month-end summaries. The Money, Date and Data Analysis cards are your daily work, written the way an Indian ledger actually looks.
You inherit someone else's messy export and have two hours to make it presentable. Text & Cleaning plus SUMIFS and the dynamic arrays cover most of that two hours.
Interviews ask for VLOOKUP and SUMIFS, not theory. 72 Core cards give you the vocabulary, and the quiz mode tells you when you actually have it.
You keep your own books because hiring someone is expensive. These are the sixteen formulas that do the most work for the least effort.
A ready deck for an Excel workshop, with a printable version for the room and an app version for homework. Classroom licences available.
Before SQL and dashboards comes the spreadsheet. This is the foundation deck, and it takes ten minutes a day.
Three minutes to start, ten minutes a day
Day one. Unzip the folder, double-click app/index.html, and press Drill. Read the task, say the formula out loud, press Space to check, then grade yourself honestly with 1, 2 or 3. That is the whole method. Ten minutes gets you through thirty to forty new cards.
Every day after. The app only shows what is due. A card you got right moves up a box and comes back in 1, 3, 7 or 14 days; a card you got wrong returns to box 1 and comes back in ten minutes. Nothing is scheduled by a calendar you have to keep — the queue rebuilds itself from what you have actually answered.
The practice layer. Open the workbook on the weekend and do five tasks. Typing =SUMIFS( into a real cell is a different skill from reciting it, and the answer key is there the moment you want it. The Sales sheet has 40 rows of fictional data, so nothing you do can damage real records.
The print layer. Print the deck at 100% scale, cut on the frames, and keep the eight or ten cards you keep forgetting on the desk. The card number in the corner tells you where it belongs when it drifts.
Offline first, no lock-in
One ZIP (124 KB) containing two PDFs, one .xlsx workbook, one self-contained HTML app, one JSON data file, one tab-separated text file, one HTML guide and a licence. Unzips with the built-in tools on Windows, macOS, Linux, Android and iOS.
Chrome, Edge, Firefox and Safari on desktop and mobile. It is a single HTML file with no external scripts, no fonts to download and no network calls — open it from a USB stick with the Wi-Fi off and it works the same.
Microsoft Excel 2016 or later, Microsoft 365, Excel for the web, Google Sheets and LibreOffice Calc 7+. Macro-free, so no security prompt and no blocked-file warning.
A4 page size, print at 100% scale. The card deck is designed for plain 80 gsm paper; 120 gsm card stock survives a pocket better.
English function names with commas. If your Excel is set to a locale that uses semicolons, replace each comma with a semicolon — the guide says this too.
Not a course, not an ebook, and not a PivotTable or Power Query guide. It does not cover VBA, macros, charts or Power BI, and it does not replace Excel's own documentation for edge cases.
One purchase, one person, forever
Your purchase covers one person, on any number of your own devices, for as long as you like, with no renewal. You may use the formulas in paid work for your employer or your clients, edit the workbook and the app for your own use, and print the deck as often as you want. You may not resell, share, upload or republish the cards, the workbook, the app or the ZIP, and you may not present the deck as your own material. Team and classroom licences are available — write to lonefaisal977@gmail.com. Full terms are in LICENSE.txt inside the ZIP.
Microsoft, Excel and Microsoft 365 are trademarks of Microsoft Corporation. This is an independent study aid, not affiliated with, endorsed by or sponsored by Microsoft.
One-time payment · Lifetime access · No subscription
The ZIP downloads the moment Razorpay confirms your payment. No waiting, no account.
UPI, cards, net banking and wallets through Razorpay. We never see your card details.
The app makes no network calls and stores progress in your own browser. Nothing is uploaded.
One payment, no renewal, no expiry. The files keep working for as long as you have them.
Files you use. The ZIP holds an offline drill app you open in a browser, a printable A4 card deck, a four-page quick reference, and a practice workbook with 24 tasks and an answer key. There is no prose to read from cover to cover.
No. Most of the 150 cards are classic functions that work in Excel 2010 and later: VLOOKUP, INDEX/MATCH, SUMIFS, TEXT, EOMONTH, IF, PMT and so on. Fourteen cards cover Excel 365 dynamic arrays such as FILTER, SORT, UNIQUE and XLOOKUP. Every one of those says so in its note, and where an older alternative exists the note names it.
Ten minutes. The drill only shows cards that are due, so a day one session is short and a day thirty session is shorter. If you skip a few days nothing breaks — the due cards simply queue up.
In your own browser, using local storage. Nothing is uploaded and no account is created. Keep the app in the same folder and use the same browser, and the progress stays. The Progress screen has a Download my progress button that saves a JSON backup.
Yes. The drill app is one HTML file that reflows to a single column on a phone, with large tap targets for grading. Copy it to your phone, open it in Chrome or Safari, and drill on the commute. The printable PDF is meant for a desktop printer.
No. It is formulas and functions only. PivotTables, Power Query, charts and VBA are deliberately out of scope, so nothing here is half-explained.
Sixteen cards are written for Indian work: GST-inclusive arithmetic at 18%, EMI and interest split, lakh and crore amounts, April-to-March financial year labels, and ageing buckets for receivables. The other 134 are general Excel and work anywhere.
Yes. The ZIP includes a tab-separated text file with all 150 cards, front and back, ready for Anki File > Import or the Quizlet import box. The JSON file is there if you want to build something of your own.
One person, on any number of their own devices, for as long as they like. Team and classroom licences are available — write to lonefaisal977@gmail.com. You may not share the ZIP, resell it or republish the cards.
After a successful payment on Razorpay you land on a thank-you page with a download button. Click it and the ZIP is yours immediately. No account, no waiting for an email.
No. One payment of ₹199. No renewal, no expiry, no per-seat fee, and the files keep working offline for as long as you have them.
Digital products are non-refundable once downloaded. If a file arrives corrupted or will not open, or you were charged incorrectly, email lonefaisal977@gmail.com within 7 days and it will be replaced or resolved.
Once you can build the formulas, put them to work on a forecast. Thirteen weekly closes, buffer alerts and three scenarios in one Excel file.
The staff register and onboarding checklists pair with the lookup and text cards here, so your HR sheet stops being a manual exercise.
When a formula is not enough and you want reminders, digests and backups to run themselves.
150 cards, a drill that remembers what you forget, and a workbook to prove it.
Get ExcelPower →