Word Intermediate Lesson 7: Compare Versions and Control Changes
Find every change between two contract versions with Compare, accept or reject them one by one, combine reviewers' copies and limit who can edit…
Read article →Atul Vij
Word Intermediate Lesson 6: Fill-In Forms With Content Controls
Word Intermediate Lesson 6: Fill-In Forms With Content Controls
Build a joining form people fill in without breaking the layout: text, date-picker, drop-down and checkbox content controls, then restrict editing to filling in…
Read article →Word Intermediate Lesson 5: Mail Merge Rules, Skip Records and Rupee Formats
Word Intermediate Lesson 5: Mail Merge Rules, Skip Records and Rupee Formats
Advanced mail merge: IF rules for different wording, SKIPIF to leave out records, and why Word cannot show lakhs grouping, with the Excel workaround…
Read article →Word Intermediate Lesson 4: Fields and Document Properties
Word Intermediate Lesson 4: Fields and Document Properties
Use fields so headers, dates and page counts update themselves: document properties in headers, DATE and PAGE of NUMPAGES, Alt+F9 to see field codes…
Read article →Word Intermediate Lesson 3: Captions, Cross-References and a Table of Figures
Word Intermediate Lesson 3: Captions, Cross-References and a Table of Figures
Number figures and tables automatically, refer to them with cross-references that update ("see Table 1") and build a table of figures for reports and…
Read article →Word Intermediate Lesson 2: Section Breaks, Headers and Page Numbers
Word Intermediate Lesson 2: Section Breaks, Headers and Page Numbers
Roman numerals for the front pages, numbering from 1 for the body, one landscape page and a different header per section, using section breaks…
Read article →Word Intermediate Lesson 1: Numbered Headings (1, 1.1, 1.1.1) That Never Break
Word Intermediate Lesson 1: Numbered Headings (1, 1.1, 1.1.1) That Never Break
Link a multilevel list to Heading styles so policies and reports number themselves as 1, 1.1, 1.1.1, then add a table of contents. Plus…
Read article →DBCS Function in Excel: Half-Width to Full-Width (Older Name)
DBCS Function in Excel: Half-Width to Full-Width (Older Name)
TextLevel: ExpertAvailable in: Excel 2007+DBCS is the older name of JIS, converting to full-width characters.Syntax=DBCS(text)ArgumentWhat it.
Read article →Prompt Engineering Lesson 8: Build Your Own Prompt Library
Prompt Engineering Lesson 8: Build Your Own Prompt Library
Save and reuse prompts that work: a simple library in OneNote, Excel or text files, templates with placeholders, custom instructions, Copilot prompt saving, and…
Read article →Prompt Engineering Lesson 7: Avoiding Wrong Answers (Hallucinations)
Prompt Engineering Lesson 7: Avoiding Wrong Answers (Hallucinations)
Why AI makes things up, which questions are risky, prompts that reduce it (give sources, allow “I don’t know”), and a verification routine for…
Read article →Prompt Engineering Lesson 6: Long Documents and Summaries
Prompt Engineering Lesson 6: Long Documents and Summaries
Summarise and question long documents: summary types, asking for quotes and page references, chunking very long files, comparing versions and meeting-minutes prompts.
Read article →Prompt Engineering Lesson 5: Getting Structured Output — Tables and JSON
Prompt Engineering Lesson 5: Getting Structured Output — Tables and JSON
Ask for answers you can use directly: markdown tables to paste into Excel, CSV, JSON with a fixed schema, and extracting fields from messy…
Read article →