Excel, SAP, Oracle & automation tips — plus wacky facts
Mail merge, styles, templates and find & replace power moves.
Mail merge, styles, templates and find & replace power moves.
📄 22 articles⬇️ 22 with practice files🕒 Updated 12 Oct 2026
Final project: a reusable company report template with styled headings, automatic numbering, a cover page with property fields, section-based page numbers and a TOC.
Read article →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 →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 →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 →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 →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 →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 →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 →Send the same letter to many people with their own details: connect Word to an Excel list, insert merge fields, format amounts and dates,…
Read article →Send personalised letters, emails or labels from an Excel list with Word Mail Merge — including number and date formatting fixes that trip everyone…
Read article →Insert and convert tables, apply table styles, repeat header rows, align numbers, merge and split cells, simple formulas like =SUM(ABOVE), sort a table, and…
Read article →Finish and share documents properly: inspect and remove hidden data, save as PDF with bookmarks, restrict editing, protect with a password, share OneDrive links…
Read article →
