DIGITALKARTAI.SHOP ExcelPower 150 Excel formula flashcards + offline drill app LOOKUP & REFERENCE · CORE Return the value in C where column B matches D2. =INDEX($C$2:$C$200,MATCH(D2,$B$2:$B$200,0)) MONEY & BUSINESS · INTERMEDIATE Monthly EMI for ₹5,00,000 at 9.5% over 5 years. =PMT(9.5%/12,5*12,-500000) 150 CARDS 8 CATEGORIES 24 PRACTICE TASKS 0 SIGN-UPS OFFLINE · NO SUBSCRIPTION · ONE PAYMENT
Digitalaikart Original · Flashcards + Offline Drill App

ExcelPower — 150 Excel Formula Flashcards & Drill App

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.

150
Formula cards
8
Categories
24
Practice tasks
0
Sign-ups

One-time ₹199 ₹599 · instant download

Get ExcelPower — ₹199 →

Why Flashcards Beat Another Tutorial

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.

The Eight Categories

150 cards, spread so the everyday work dominates

Lookup & Reference — 24 cards

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.

Text & Cleaning — 24 cards

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.

Date & Time — 18 cards

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.

Maths & Stats — 22 cards

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.

Logic & Errors — 18 cards

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.

Money & Business — 16 cards

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.

Data Analysis — 14 cards

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.

Dynamic Arrays — 14 cards

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.

A Look at Three Cards

Exactly as they appear in the deck and the app

DATA ANALYSIS · INTERMEDIATE

Total the sales in D where region is "North" AND status is "Paid".

=SUMIFS($D$2:$D$500,$B$2:$B$500,"North",$E$2:$E$500,"Paid")

SUMIFS puts the sum range first — the opposite of SUMIF. This trips up almost everyone.

DATE & TIME · INTERMEDIATE

Label the Indian financial year for the date in A2, e.g. FY 2026-27.

="FY "&IF(MONTH(A2)>=4,YEAR(A2),YEAR(A2)-1)&"-"&RIGHT(IF(MONTH(A2)>=4,YEAR(A2)+1,YEAR(A2)),2)

April to March. Change the 4 if your year starts in a different month.

MONEY & BUSINESS · INTERMEDIATE

Work out the taxable value when the invoice total in A2 already includes 18% GST.

=A2/1.18

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.

What You Get for ₹199

One ZIP, seven files, 124 KB

app/index.html — the drill app

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.

cards/ExcelPower-Flashcards-A4.pdf

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.

cards/ExcelPower-Quick-Reference-A4.pdf

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.

practice/ExcelPower-Practice-Workbook.xlsx

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.

data/flashcards.json

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.

data/anki-import.txt

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.

START-HERE.html

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.

LICENSE.txt

Single-user commercial licence in plain English. Use it in paid work for clients; do not resell, share or republish the cards.

Who It Is For

People whose day job is a spreadsheet

🧾

Accounts and back-office staff

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.

📋

MIS and reporting executives

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.

🎓

Students and freshers

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.

🏪

Small business owners

You keep your own books because hiring someone is expensive. These are the sixteen formulas that do the most work for the least effort.

🧑‍🏫

Trainers and teachers

A ready deck for an Excel workshop, with a printable version for the room and an app version for homework. Classroom licences available.

💼

Anyone switching careers into data

Before SQL and dashboards comes the spreadsheet. This is the foundation deck, and it takes ten minutes a day.

How It Works

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.

File Format & Compatibility

Offline first, no lock-in

Format

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.

The app runs in

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.

The workbook opens in

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.

The PDFs

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.

Formula language

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.

What it is not

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.

Licence

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.

Get Instant Access

One-time payment · Lifetime access · No subscription

Buy With Confidence

⚡

Instant delivery

The ZIP downloads the moment Razorpay confirms your payment. No waiting, no account.

🔒

Secure payment

UPI, cards, net banking and wallets through Razorpay. We never see your card details.

📴

Truly offline

The app makes no network calls and stores progress in your own browser. Nothing is uploaded.

♾️

Yours forever

One payment, no renewal, no expiry. The files keep working for as long as you have them.

Frequently Asked Questions

Is this an ebook or a set of files I actually use?

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.

Do I need Excel 365 for these formulas?

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.

How much time does a session take?

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.

Where is my progress saved?

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.

Will it work on my phone?

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.

Does it teach PivotTables, Power Query or macros?

No. It is formulas and functions only. PivotTables, Power Query, charts and VBA are deliberately out of scope, so nothing here is half-explained.

Are the formulas India-specific?

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.

Can I import the cards into Anki or Quizlet?

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.

How many people can use one purchase?

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.

How do I get the files after payment?

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.

Is it a subscription?

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.

Can I get a refund?

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.

Pairs Well With

CashFlow Compass — 13-Week Cash Flow

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.

StaffKit HR — 18 Editable Staff Letters

The staff register and onboarding checklists pair with the lookup and text cards here, so your HR sheet stops being a manual exercise.

Sheets Autopilot — 12 Google Sheets Automations

When a formula is not enough and you want reminders, digests and backups to run themselves.

Fifteen Minutes a Day, and the Formula Comes

150 cards, a drill that remembers what you forget, and a workbook to prove it.

Get ExcelPower →