Power Automate Intermediate Lesson 6: Scheduled Reminders That Don’t Spam
A daily flow that emails customers 3 days before an invoice is due, marks them reminded so nobody gets two mails, and runs on…
Read article →Atul Vij
In-Cell Bar Charts in Excel: REPT, Data Bars and Sparklines
In-Cell Bar Charts in Excel: REPT, Data Bars and Sparklines
Three ways to show charts inside cells — the REPT formula trick, conditional-formatting Data Bars and Sparklines — for compact dashboards that update automatically.
Read article →Power Automate Intermediate Lesson 5: Error Handling With Scopes and Run After
Power Automate Intermediate Lesson 5: Error Handling With Scopes and Run After
Make flows fail loudly and recover: Try/Catch scopes, Configure run after, retry policies, the run link in alerts and terminate with a clear status.
Read article →Power Automate Intermediate Lesson 4: Apply to Each, Arrays and Select
Power Automate Intermediate Lesson 4: Apply to Each, Arrays and Select
Loop through rows and attachments, build arrays with Select and Filter array, join them into one email table, and speed up loops with concurrency.
Read article →Power Automate Intermediate Lesson 3: Approvals Routed by Amount
Power Automate Intermediate Lesson 3: Approvals Routed by Amount
Build an expense approval: auto-approve small claims, send large ones to the finance head, record the outcome and comments in Excel and email the…
Read article →Power Automate Intermediate Lesson 2: Excel Tables Done Right
Power Automate Intermediate Lesson 2: Excel Tables Done Right
Use the Excel Online connector without surprises: real tables, List rows with filters, ISO dates instead of serial numbers, adding and updating rows by…
Read article →Power Automate Intermediate Lesson 1: Expressions for Dates, Text and Numbers
Power Automate Intermediate Lesson 1: Expressions for Dates, Text and Numbers
Write Power Automate expressions: formatDateTime, convertFromUtc to India Standard Time, addDays, concat, split, replace and float for rupee text, with results.
Read article →Excel Shortcut of the Week: Ctrl+E Flash Fill
Excel Shortcut of the Week: Ctrl+E Flash Fill
Flash Fill (Ctrl+E) splits, joins and reformats text by example — no formulas. How to use it, five real examples, and when to use…
Read article →TallyPrime Shortcut Keys: The Complete List for Faster Accounting
TallyPrime Shortcut Keys: The Complete List for Faster Accounting
Every TallyPrime shortcut you actually use — vouchers F4 to F10, Alt and Ctrl combinations, report navigation and the new Go To menu —…
Read article →TallyPrime for Beginners: From Company Creation to Your First GST Invoice
TallyPrime for Beginners: From Company Creation to Your First GST Invoice
A complete beginner walkthrough of TallyPrime: create a company, enable GST, set up ledgers, stock items and tax rates, record a sales invoice, and…
Read article →OCT2DEC Function in Excel: Octal to Decimal
OCT2DEC Function in Excel: Octal to Decimal
OCT2DEC converts a octal number to decimal. Used for device codes, permission bits, memory addresses and number-system lessons.
Read article →Phone Storage Full? 12 Safe Ways to Free Space on Android
Phone Storage Full? 12 Safe Ways to Free Space on Android
Free up gigabytes on an Android phone without losing anything important: WhatsApp media cleanup, Google Photos backup, cached data, offline maps, downloads, duplicate files…
Read article →