Adds all numeric values in a range of cells, automatically ignoring text headers and blank cells.
Complete Office Reference Kit & Interview Playbook
41 Excel Formulas · Word Standards · Outlook & Anti-Phishing Defense · Windows 11 Shortcuts · AI Prompting & PII Redaction
Workplace Reference Kit & Interview Playbook
Fast, copy-ready office desk guide: 41 Excel formulas, error fixes, Word layouts, Outlook phishing triage, Windows 11 shortcuts, AI prompt templates, and interview flashcards.
Your current plan (Free Starter ($0)) includes the first 2 starter entries in every section. Upgrade to Career Pro ($9/mo) or Bootcamp Pass ($49) to unlock all 87 entries, A4 PDF handbook printing, and offline Markdown downloads.
Microsoft Excel: Complete Formula, Function & Audit Reference
40+ copyable workplace formulas from SUM and IF to XLOOKUP, SUMIFS, Dynamic Arrays, Text Cleaning & 5-Second Error Fixes.
1.1 Essential Math, Aggregation & Rounding
Core arithmetic and statistical functions used in daily budgets, invoices, and operational trackers.
| Topic / Syntax | Summary & Workplace Example | Actions |
|---|---|---|
|
SUM
=SUM(B2:B50)
|
Adds all numeric values in a range of cells, automatically ignoring text headers and blank cells.
=SUM(C2:C25) → $48,250.00 total regional revenue
|
|
|
AVERAGE
=AVERAGE(B2:B50)
|
Calculates the arithmetic mean (sum divided by count of numeric cells).
=AVERAGE(D2:D30) → 84.5 average order value
|
|
|
MEDIAN
=MEDIAN(B2:B50)
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
MIN
=MIN(B2:B50)
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
MAX
=MAX(B2:B50)
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
COUNT
=COUNT(B2:B50)
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
COUNTA
=COUNTA(A2:A50)
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
ROUND
=ROUND(B2 * 1.15, 2)
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
ABS
=ABS(C2 - B2)
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
SUMPRODUCT
=SUMPRODUCT(B2:B10, C2:C10)
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
Growth & Margin %
=(C2 - B2) / B2
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
Calculates the arithmetic mean (sum divided by count of numeric cells).
1.2 Logical & Error-Shielding Functions
Automate pass/fail decisions, multi-tier commissions, and shield executive dashboards from ugly #N/A or #DIV/0! errors.
| Topic / Syntax | Summary & Workplace Example | Actions |
|---|---|---|
|
IF
=IF(B2>=20000, B2*0.10, 0)
|
Evaluates a condition and returns one value if TRUE and another if FALSE.
=IF(C2="Overdue", "Escalate", "Current") → Flags overdue invoices automatically
|
|
|
IFS
=IFS(B2>=90, "Gold", B2>=75, "Silver", TRUE, "Standard")
|
Tests multiple thresholds in order from top to bottom without messy nested IF(...) parentheses.
=IFS(D2>=50000, "10%", D2>=20000, "5%", TRUE, "0%") → Clean commission tier lookup
|
|
|
AND (inside IF)
=IF(AND(B2>=10000, C2="Paid"), "Bonus", "No Bonus")
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
OR / NOT (inside IF)
=IF(OR(B2="VIP", C2>=50000), "Priority", "Standard")
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
IFERROR
=IFERROR(B2 / A2, 0)
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
IFNA
=IFNA(VLOOKUP(D2, $A$2:$C$50, 2, FALSE), "Not Found")
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
Evaluates a condition and returns one value if TRUE and another if FALSE.
Tests multiple thresholds in order from top to bottom without messy nested IF(...) parentheses.
1.3 Conditional Summarization (Single & Multi-Criteria)
The workhorse functions of finance and operations: summing, counting, and averaging rows that match specific filters.
| Topic / Syntax | Summary & Workplace Example | Actions |
|---|---|---|
|
SUMIF
=SUMIF(B2:B100, "North", C2:C100)
|
Sums numbers in sum_range where the corresponding cell in criteria_range matches a single condition.
=SUMIF(B2:B50, "Marketing", D2:D50) → Totals all spend for the Marketing department
|
|
|
SUMIFS
=SUMIFS(C2:C100, B2:B100, "North", D2:D100, "Paid")
|
Sums values in sum_range that satisfy MULTIPLE criteria across different columns simultaneously.
=SUMIFS(E2:E200, B2:B200, "Q3", C2:C200, ">=1000") → Totals Q3 invoices of $1,000 or more
|
|
|
COUNTIF
=COUNTIF(D2:D100, "Paid")
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
COUNTIFS
=COUNTIFS(B2:B100, "North", C2:C100, ">=500")
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
AVERAGEIF
=AVERAGEIF(B2:B100, "North", C2:C100)
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
AVERAGEIFS
=AVERAGEIFS(C2:C100, B2:B100, "North", D2:D100, "Active")
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
Sums numbers in sum_range where the corresponding cell in criteria_range matches a single condition.
Sums values in sum_range that satisfy MULTIPLE criteria across different columns simultaneously.
1.4 Lookup & Reference Mastery (XLOOKUP, VLOOKUP, INDEX/MATCH)
Pull prices, employee names, tax rates, and client tiers across tables without manual copy-pasting.
| Topic / Syntax | Summary & Workplace Example | Actions |
|---|---|---|
|
XLOOKUP
=XLOOKUP(D2, A2:A50, B2:B50, "Not Found")
|
The modern gold-standard lookup. Searches lookup_array for lookup_value and returns the matching item from return_array.
=XLOOKUP(A4, $A$2:$A$20, $B$2:$B$20, 0) * C4 → Pulls unit price for SKU in A4 and multiplies by qty in C4
|
|
|
VLOOKUP
=VLOOKUP(D2, $A$2:$C$50, 2, FALSE)
|
Searches the leftmost column of table_array and returns a value in the same row from column number col_index_num (1 = 1st col).
=VLOOKUP(A2, $E$2:$G$40, 3, FALSE) → Pulls the 3rd column from locked table $E$2:$G$40
|
|
|
INDEX / MATCH
=INDEX(A2:A50, MATCH(D2, B2:B50, 0))
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
Absolute Cell Locks ($)
$A$2:$B$50 (Absolute) vs A2 (Relative)
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
The modern gold-standard lookup. Searches lookup_array for lookup_value and returns the matching item from return_array.
Searches the leftmost column of table_array and returns a value in the same row from column number col_index_num (1 = 1st col).
1.5 Text Cleaning & String Manipulation
Clean messy CRM exports, standardize casing, extract SKU prefixes, and join columns reliably.
| Topic / Syntax | Summary & Workplace Example | Actions |
|---|---|---|
|
TRIM
=TRIM(A2)
|
Strips invisible leading/trailing spaces and collapses accidental double spaces between words into single spaces.
=TRIM(" SKU-104 ") → "SKU-104"
|
|
|
PROPER (with TRIM)
=PROPER(TRIM(A2))
|
PROPER capitalizes the first letter of each word; UPPER forces ALL CAPS (e.g. SKU codes) and LOWER forces lowercase (emails).
=PROPER(TRIM(A2)) → Turns " jORDAN tAYLOR " into "Jordan Taylor"
|
|
|
LEFT
=LEFT(A2, 3)
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
RIGHT
=RIGHT(A2, 4)
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
MID
=MID(A2, 5, 4)
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
LEN
=LEN(A2)
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
TEXTJOIN
=TEXTJOIN(", ", TRUE, A2:A10)
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
CONCAT & & Operator
=CONCAT(A2, " - ", B2)
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
Strips invisible leading/trailing spaces and collapses accidental double spaces between words into single spaces.
PROPER capitalizes the first letter of each word; UPPER forces ALL CAPS (e.g. SKU codes) and LOWER forces lowercase (emails).
1.6 Date Calculations & Excel 365 Dynamic Arrays
Calculate billing deadlines, business days, and dynamic spill lists that update automatically when new rows arrive.
| Topic / Syntax | Summary & Workplace Example | Actions |
|---|---|---|
|
TODAY (Invoice Aging)
=TODAY() - B2
|
Subtracts an invoice due date (B2) from today's live date to measure days overdue.
=IF(TODAY()>B2, TODAY()-B2, 0) → Live days overdue counter on accounts receivable
|
|
|
EOMONTH
=EOMONTH(A2, 0)
|
Returns the exact last day of the month (0 = same month, 1 = next month, -1 = prior month).
=EOMONTH(A2, 1) → Sets contract billing cutoff to the final day of next month
|
|
|
NETWORKDAYS
=NETWORKDAYS(A2, B2)
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
UNIQUE (Dynamic Spill)
=UNIQUE(B2:B50)
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
FILTER (Dynamic Spill)
=FILTER(A2:D50, C2:C50="Overdue", "None")
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
SORT (Dynamic Spill)
=SORT(A2:C50, 3, -1)
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
Subtracts an invoice due date (B2) from today's live date to measure days overdue.
Returns the exact last day of the month (0 = same month, 1 = next month, -1 = prior month).
1.7 Error Diagnostic Guide & Data Audit Rules
Diagnose any spreadsheet error code in 5 seconds and pass automated employer formula grading.
| Error | Cause & Fix | Actions |
|---|---|---|
|
#N/A
Value Not Available
|
Lookup could not find the lookup_value inside the search range — usually due to trailing spaces, mismatched types ("104" text vs 104 number), or an unlocked table range.
Run TRIM(), lock table with $ ($A$2:$C$50), or add XLOOKUP 4th fallback: =XLOOKUP(D2, A2:A50, B2:B50, "Not Found")
Tip: Wrap legacy VLOOKUPs in IFNA(..., "Not Found") instead of leaving raw #N/A on a report.
|
|
|
#DIV/0!
Division by Zero or Blank Cell
|
Formula divides by 0 or an empty cell (which Excel evaluates as 0). Also occurs when AVERAGEIF/AVERAGEIFS matches zero rows.
Shield ratio or margin formulas with IFERROR: =IFERROR(B2 / A2, 0)
Tip: A single #DIV/0! inside a column causes =SUM() at the bottom to fail too.
|
|
|
#VALUE!
Wrong Data Type in Math
|
Diagnose root cause, example fix formula, and prevention rule inside Pro Reference Kit.
|
Pro |
|
#NAME?
Misspelled Function or Unquoted Text
|
Diagnose root cause, example fix formula, and prevention rule inside Pro Reference Kit.
|
Pro |
|
#REF!
Broken / Deleted Reference
|
Diagnose root cause, example fix formula, and prevention rule inside Pro Reference Kit.
|
Pro |
|
#CIRC!
Circular Self-Reference
|
Diagnose root cause, example fix formula, and prevention rule inside Pro Reference Kit.
|
Pro |
|
AUDIT
Pre-Submission Data Audit Rule
|
Diagnose root cause, example fix formula, and prevention rule inside Pro Reference Kit.
|
Pro |
Microsoft Word: Executive Formatting, Tables & PDF Publishing
Semantic heading hierarchy, corporate memo layout, financial table alignment, page breaks, and locked PDF distribution.
2.1 Semantic Typography & Heading Hierarchy
Why professional documents use semantic Ribbon styles instead of manual font resizing.
| Topic / Syntax | Summary & Workplace Example | Actions |
|---|---|---|
|
Heading 1 → Heading 2 Hierarchy
Heading 1 (H1) → Heading 2 (H2) → Body Text
|
Apply Heading 1 to the main document title, Heading 2 to major section headers, and Normal/Body to paragraphs so structure and navigation outlines stay semantic.
H1: "Q3 Financial Audit Memorandum" → H2: "1. Regional Revenue Breakdown" → H2: "2. Corrective Action Plan"
|
|
|
Inline Emphasis Rules
Ctrl + B (Bold) · Ctrl + I (Italic) · Avoid Underline
|
Use Bold sparingly to highlight action owners, deadlines, and dollar figures at the start of bullet points rather than bolding whole paragraphs.
• Finance Team (By Friday 17:00): Complete Q3 vendor reconciliation ($42,500).
|
Apply Heading 1 to the main document title, Heading 2 to major section headers, and Normal/Body to paragraphs so structure and navigation outlines stay semantic.
Use Bold sparingly to highlight action owners, deadlines, and dollar figures at the start of bullet points rather than bolding whole paragraphs.
2.2 Executive Memo & Formal Business Letter Blueprint
Standard structure expected in administrative, operations, and executive assistant assessments.
| Topic / Syntax | Summary & Workplace Example | Actions |
|---|---|---|
|
Executive Memo Header Block
TO: | FROM: | DATE: | SUBJECT:
|
Every internal executive memo opens with a structured 4-line header block separated from the body by a clean rule, followed immediately by the bottom-line summary.
TO: Board of Directors & CFO
FROM: Operations Lead
DATE: 2026-11-06
SUBJECT: Q3 Regional Sales Reconciliation & Cost Controls
|
|
|
Bulleted vs. Numbered Lists
Bulleted Lists (Findings) vs Numbered Lists (Steps)
|
Use Bulleted Lists for unordered highlights or findings; use Numbered Lists (1, 2, 3) for sequential procedures, timelines, or ranked priorities.
1. Freeze duplicate vendor payments
2. Audit Q3 North region ledger
3. Re-issue corrected client PDF
|
Every internal executive memo opens with a structured 4-line header block separated from the body by a clean rule, followed immediately by the bottom-line summary.
Use Bulleted Lists for unordered highlights or findings; use Numbered Lists (1, 2, 3) for sequential procedures, timelines, or ranked priorities.
2.3 Financial Tables, Alignment & PDF Publishing
How to present spreadsheet figures inside Word reports cleanly without broken pagination.
| Topic / Syntax | Summary & Workplace Example | Actions |
|---|---|---|
|
Financial Table Alignment
Text = Left-Aligned · Numbers & Currency = Right-Aligned
|
In any Word table containing numbers or currency, left-align text labels and right-align dollar figures and percentages so decimal points line up vertically.
| Region (Left) | Q3 Revenue (Right) | Status (Center) |
|
|
|
Explicit Page Breaks
Ctrl + Enter (Insert → Page Break)
|
Forces an appendix or new chapter to start cleanly at the top of a new page regardless of upstream edits.
Press Ctrl + Enter directly before "Appendix A: Detailed Transaction Log".
|
|
|
Locked PDF Publishing
File → Export → Publish as PDF (.pdf)
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
In any Word table containing numbers or currency, left-align text labels and right-align dollar figures and percentages so decimal points line up vertically.
Forces an appendix or new chapter to start cleanly at the top of a new page regardless of upstream edits.
Microsoft Outlook: Inbox Triage, Etiquette & Spotting Spam / Phishing
To vs. CC vs. BCC rules, executive subject lines, attachment standards, and the 7-point guide to spotting phishing & wire fraud.
Side-by-Side: Spot the 3 Red Flags in a Forged Wire-Fraud Email
0 in apex-l0gistics-pay.com instead of the letter o, plus extra hyphenated words. Never trust the display name alone.
Clue #2 — Artificial Urgency & Secrecy: Attackers demand immediate payment while explicitly telling you "do not call to confirm" so you skip out-of-band phone verification.
Clue #3 — Executable Double Extension: .pdf.exe disguises Windows malware as a PDF statement. Legitimate invoices never end in .exe, .scr, or .bat.
"Please wire today's payment of $18,400 to our new audit bank account immediately. Our director is in a hearing — do not call to confirm, just reply with the wire receipt."
"Hi team, please extract the attached Q3 regional sales sheet, remove duplicate rows, calculate the North total using SUMIFS, and reply with the final PDF memo by 17:00."
3.1 Professional Email Architecture (To vs. CC vs. BCC & Subjects)
Every recipient field in Outlook sends a specific signal about action ownership and data privacy.
| Topic / Syntax | Summary & Workplace Example | Actions |
|---|---|---|
|
TO: Direct Action Owners
TO: Direct Action Owners Only
|
Place only the person(s) directly responsible for taking action, approving, or replying to the message.
TO: sarah.jenkins@company.com (Manager who requested the Q3 Sales Report)
|
|
|
CC: Informed Stakeholders
CC: (Carbon Copy) Informed Stakeholders
|
Include managers, finance directors, or cross-functional leads who need an audit trail for oversight, but are not required to reply.
CC: finance.director@company.com when submitting final approved totals to your manager
|
|
|
BCC: Privacy & Mass Sends
BCC: (Blind Carbon Copy) External Privacy
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
Executive Subject Line Formula
[Category / Status] Specific Topic — Action & Deadline
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
Place only the person(s) directly responsible for taking action, approving, or replying to the message.
Include managers, finance directors, or cross-functional leads who need an audit trail for oversight, but are not required to reply.
3.2 How to Spot Spam, Phishing & BEC Scams (7-Point Inspection Guide)
Over 90% of corporate cyber breaches and wire-transfer thefts start in the inbox. Inspect these 7 red flags before clicking or replying.
| Topic / Syntax | Summary & Workplace Example | Actions |
|---|---|---|
|
Red Flag 1: Typosquatted Sender Domains
Lookalike / Typosquatted Sender Domains & Display Spoofing
|
Attackers set their display name to your CEO or a trusted vendor, while the real address behind it uses a free webmail account or a lookalike domain.
Scam: <admin@micros0ft-auth-verify.com> vs Real: <security@microsoft.com>
|
|
|
Red Flag 2: Urgent Bank / IBAN Change (Wire Fraud)
Urgent Supplier Bank Account / IBAN Change Requests
|
An email claiming to be a supplier states: "Our bank account is under audit — please wire today's invoice to this updated IBAN immediately."
Scam: Urgent IBAN change by email → Safe: Out-of-band phone verification
|
|
|
Red Flag 3: Pressure to Bypass Verification
Secrecy & Authority Pressure ("Do Not Call Me")
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
Red Flag 4: Double File Extensions & Executables
Dangerous Attachments & Double Extensions (.pdf.exe)
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
Red Flag 5: Mismatched Hover URLs
Mismatched Hover Links & Fake M365 Login Portals
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
Red Flag 6: Panic Countdown Threats
Generic Greetings & Artificial Countdown Threats
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
Protocol: Mandatory Workplace Response
1) Do Not Click/Reply → 2) Click "Report Phishing" → 3) Verify
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
Attackers set their display name to your CEO or a trusted vendor, while the real address behind it uses a free webmail account or a lookalike domain.
An email claiming to be a supplier states: "Our bank account is under audit — please wire today's invoice to this updated IBAN immediately."
Windows 11 Shortcuts, ISO File Naming & Archive Hygiene
High-speed keyboard muscle memory, ISO-8601 file naming conventions, .zip extraction workflows, and folder organization.
4.1 Essential Workplace Keyboard Shortcuts
Master these Windows 11 & Office shortcuts to complete file and spreadsheet tasks 3× faster without hunting through menus.
| Topic / Syntax | Summary & Workplace Example | Actions |
|---|---|---|
|
Copy, Cut & Paste
Ctrl + C (Copy) · Ctrl + X (Move) · Ctrl + V (Paste)
|
Ctrl+C duplicates selected cells, text, or files; Ctrl+X cuts them to move cleanly into a new folder; Ctrl+V pastes at destination.
Select raw export → Ctrl+X → Open /Finance/2026/Q3/ → Ctrl+V to relocate cleanly.
|
|
|
Undo & Redo
Ctrl + Z (Undo) · Ctrl + Y (Redo)
|
Ctrl+Z immediately reverses accidental deletions, bad sorts, or wrong file moves. Ctrl+Y reapplies an undone action.
Accidentally overwrote a formula or renamed the wrong file? Press Ctrl+Z immediately.
|
|
|
Rename, Find & Select All
F2 (Rename / Edit) · Ctrl + F (Find) · Ctrl + A (Select All)
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
New Folder, Explorer & Window Switch
Ctrl + Shift + N · Win + E · Alt + Tab
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
Ctrl+C duplicates selected cells, text, or files; Ctrl+X cuts them to move cleanly into a new folder; Ctrl+V pastes at destination.
Ctrl+Z immediately reverses accidental deletions, bad sorts, or wrong file moves. Ctrl+Y reapplies an undone action.
4.2 Corporate ISO-8601 File Naming & Archive Hygiene
Keep shared company drives searchable, chronological, and free of "final_v2_NEW.xlsx" chaos.
| Topic / Syntax | Summary & Workplace Example | Actions |
|---|---|---|
|
ISO-8601 Corporate Filename Standard
YYYY-MM-DD_Department_Description_v1.ext
|
Start filenames with 4-digit year, 2-digit month, and 2-digit day (YYYY-MM-DD), using underscores (_) instead of spaces.
Bad: final sales report oct v2 REAL.xlsx | Good: 2026-10-31_Finance_Q3_Sales_Summary_v2.xlsx
|
|
|
Compressed .ZIP Archive Workflow
Extract .zip Archive FIRST → Rename → Move to Folder
|
Double-clicking a .zip only opens a read-only preview. Always click "Extract All" into a real folder before editing files inside.
Extract All first → Rename to ISO standard → Move to /Finance/2026/Q3/
|
Start filenames with 4-digit year, 2-digit month, and 2-digit day (YYYY-MM-DD), using underscores (_) instead of spaces.
Double-clicking a .zip only opens a read-only preview. Always click "Extract All" into a real folder before editing files inside.
Workplace AI: How to Prompt Successfully, Pro Tips & Privacy Redaction
The 4-part R.C.T.F. prompt engineering framework, high-impact prompting templates, and mandatory PII redaction rules.
Why Structure & Redaction Matter: Amateur Prompt vs. 4-Part R.C.T.F. Pro Prompt
"Write an email to John Smith (ID 8801025099081, Acc 6281994012) saying his refund is late and summarize these notes."
"[ROLE] Act as a Customer Care Lead. [CONTEXT] Using the redacted notes below for client [REDACTED_NAME] (ID: [REDACTED_ID], Acc: [REDACTED_BANK]), [TASK] draft an apology confirming their refund clears within 24 hours and list 3 root-cause fixes. [FORMAT] Use an empathetic executive tone under 120 words with a bulleted summary."
5.1 How to Prompt AI Successfully: The 4-Part R.C.T.F. Formula
Vague 5-word prompts produce generic, unusable text. Combine all 4 R.C.T.F. building blocks to get executive-ready output on the first try.
| Topic / Syntax | Summary & Workplace Example | Actions |
|---|---|---|
|
Master R.C.T.F. Prompt Blueprint
1. ROLE + 2. CONTEXT + 3. TASK (Action Verb) + 4. FORMAT & CONSTRAINTS
|
ROLE sets expertise, CONTEXT defines audience/inputs, TASK states the action verb (Summarize, Extract, Compare), and FORMAT sets layout, length, and tone.
Act as a Senior Operations Analyst. Using the redacted Q3 delivery logs below for our CFO, extract the top 3 causes of late shipments and propose 1 fix for each. Format as a 3-column Markdown table (Issue, Impact, Fix) followed by a 90-word executive summary in a neutral tone.
|
|
|
Template: Meeting Notes → Action Tracker
Meeting Transcript → Structured Owner & Deadline Table
|
Turns messy, unstructured meeting transcripts into an accountable action-item table without inventing missing deadlines.
Act as an Executive Assistant. Review the redacted meeting notes below inside triple quotes. Extract all decisions made and action items into a table with columns: [Owner, Task Description, Deadline, Priority]. Use a concise, professional tone and mark any missing deadline as [TBD].
|
|
|
Template: De-Escalate VIP Client Delay
Empathetic, Non-Defensive Client Reply Under 120 Words
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
ROLE sets expertise, CONTEXT defines audience/inputs, TASK states the action verb (Summarize, Extract, Compare), and FORMAT sets layout, length, and tone.
Turns messy, unstructured meeting transcripts into an accountable action-item table without inventing missing deadlines.
5.2 Pro Tips for High-Precision AI Prompting
Techniques used by top analysts and operations leads to eliminate hallucinations and keep formatting predictable.
| Topic / Syntax | Summary & Workplace Example | Actions |
|---|---|---|
|
Tip 1: Use Clear Delimiters (""" or <data>)
Wrap Raw Input in """...""" or <notes>...</notes>
|
Keep your prompt instructions at the top and fence the raw email, transcript, or policy inside triple quotes """...""" or XML tags.
Summarize the text inside <notes> into 3 bullets:
<notes>[Paste redacted text here]</notes>
|
|
|
Tip 2: Set Explicit Negative Constraints
Negative Constraints ("Do NOT invent numbers...")
|
Tell the AI explicitly what NOT to do: "Do not invent numbers not in the source", "Do not use clichés", "Do not exceed 150 words."
"Use ONLY the figures provided below. If a metric is missing, write [Data Required] — never estimate."
|
|
|
Tip 3: One-Shot Output Example
Provide 1 Concrete Format Example ("One-Shot")
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
Keep your prompt instructions at the top and fence the raw email, transcript, or policy inside triple quotes """...""" or XML tags.
Tell the AI explicitly what NOT to do: "Do not invent numbers not in the source", "Do not use clichés", "Do not exceed 150 words."
5.3 Mandatory Data Privacy & PII Redaction Rules (GDPR / POPIA / InfoSec)
Pasting unredacted customer or company secrets into public AI tools is a compliance breach. Always sanitize these categories first.
| Sensitive Category & Token | ❌ Never Paste (Leak) | ✓ Safe Redacted Prompt | Actions |
|---|---|---|---|
|
National IDs, SSNs & Passports
[REDACTED_ID]
Strip 13-digit SA IDs, 9-digit US SSNs, passport numbers, driver licenses, and home street addresses before prompting. |
"Summarize claim for ID 8904125089087"
|
"Summarize claim for [REDACTED_ID]"
Tip: Use the 1-Click "Auto-Redact PII" button in Deskademy AI Studio to replace sensitive tokens automatically.
|
|
|
Bank Accounts, IBANs & Cards
[REDACTED_BANK]
Remove all 9–16 digit account numbers, IBANs, routing codes, CVVs, and individual payroll figures before prompting. |
"Refund Acc #62849104829"
|
"Refund Account [REDACTED_BANK]"
Tip: Even after deleting a chat session, external AI providers may retain logs for abuse monitoring.
|
|
|
Passwords, API Keys & Private URLs
[REDACTED_PASSWORD]
|
Redaction leak example and safe replacement pattern included with Pro access.
|
Pro | |
Practical Office Interview Q&A & 15-Minute Assessment Playbook
Self-test flashcards with winning interview answers and how to score 90%+ on live employer simulations.
6.1 Top Practical Interview Questions & Winning Answers
Test yourself first before revealing each winning answer — hiring managers ask these exact scenarios to verify real hands-on skill.
| Topic / Syntax | Summary & Workplace Example | Actions |
|---|---|---|
|
XLOOKUP vs. VLOOKUP & #N/A Causes
Q1: "When do you use XLOOKUP vs. VLOOKUP, and what causes #N/A?"
|
I prefer XLOOKUP because it defaults to an exact match, can look up columns to the left or right, doesn't break if someone inserts a column, and has a built-in 4th argument for missing values. If I use VLOOKUP, I always lock the table range with F4 ($A$2:$C$50) and set the 4th argument to FALSE. When #N/A happens, I check for trailing spaces using TRIM() or verify the ID exists in the source table.
Key terms: Exact match (FALSE), Absolute references ($), TRIM(), Built-in fallback
|
|
|
Verifying a Financial Workbook Before Sending
Q2: "How do you verify a financial spreadsheet is 100% accurate before sending it to the CFO?"
|
I follow a 4-step audit checklist: 1) Run Data → Remove Duplicates on transaction IDs so no invoice is double-counted, 2) Verify all totals use dynamic formulas like SUMIFS and XLOOKUP rather than hardcoded numbers, 3) Wrap ratios in IFERROR so a zero row doesn't break grand totals, and 4) Export the executive summary as a locked PDF.
Demonstrates end-to-end ownership from raw data hygiene to executive delivery.
|
|
|
Handling an Urgent Supplier Bank Change Email
Q3: "You receive an urgent email from a supplier asking to update their bank account for today's payment. What do you do?"
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
|
Using AI Safely Without Data Leaks
Q4: "How do you use AI tools at work without putting company data at risk?"
|
Full explanation, workplace example & tip unlocked on paid plans. | Pro |
I prefer XLOOKUP because it defaults to an exact match, can look up columns to the left or right, doesn't break if someone inserts a column, and has a built-in 4th argument for missing values. If I use VLOOKUP, I always lock the table range with F4 ($A$2:$C$50) and set the 4th argument to FALSE. When #N/A happens, I check for trailing spaces using TRIM() or verify the ID exists in the source table.
I follow a 4-step audit checklist: 1) Run Data → Remove Duplicates on transaction IDs so no invoice is double-counted, 2) Verify all totals use dynamic formulas like SUMIFS and XLOOKUP rather than hardcoded numbers, 3) Wrap ratios in IFERROR so a zero row doesn't break grand totals, and 4) Export the executive summary as a locked PDF.
6.2 How to Score 90%+ on 15-Minute Pre-Employment Simulation Tests
Tactical checklist for passing live Deskademy employer assessments with zero proctoring flags.
| Topic / Syntax | Summary & Workplace Example | Actions |
|---|---|---|
|
Strategy 1: Zero Tab-Switch Telemetry
Stay in the Active Browser Tab (Zero Tab-Switch Flags)
|
Employer assessment links track browser focus switches (visibilitychange) and external clipboard pastes. Switching tabs more than twice flags your scorecard.
Use the simulator's built-in "fx Insert Function" helper instead of opening another browser tab to look up syntax.
|
|
|
Strategy 2: The 4-Step "Day 1" Workflow
Execute the 4-Step "Day 1 in the Office" Sequence
|
In connected multi-app tests, outputs from one app feed the next. Follow the natural office flow: 1) Outlook → 2) File Explorer → 3) Excel → 4) Word & Outlook Reply.
1) Report phish & read brief → 2) Extract .zip & ISO-rename → 3) Dedupe + XLOOKUP/SUMIFS → 4) H1 Memo + PDF + CC Finance Director
|
Employer assessment links track browser focus switches (visibilitychange) and external clipboard pastes. Switching tabs more than twice flags your scorecard.
In connected multi-app tests, outputs from one app feed the next. Follow the natural office flow: 1) Outlook → 2) File Explorer → 3) Excel → 4) Word & Outlook Reply.