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 →Office
Word, PowerPoint, Outlook and Google Workspace tips for faster everyday work.
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 →Outlook Intermediate Lesson 8: Power Automate Flows for Email
Outlook Intermediate Lesson 8: Power Automate Flows for Email
Save invoice attachments to OneDrive automatically, get a Teams message for VIP mail and log orders to Excel with Power Automate cloud flows: no…
Read article →Outlook Intermediate Lesson 7: Safe VBA Macros – Save Attachments, Unread Report, Template Replies
Outlook Intermediate Lesson 7: Safe VBA Macros – Save Attachments, Unread Report, Template Replies
Three Outlook VBA macros that only read and save: save attachments of selected mails with the date in the file name, an unread-mail report…
Read article →Outlook Intermediate Lesson 6: Calendar Skills for Teams
Outlook Intermediate Lesson 6: Calendar Skills for Teams
Scheduling Assistant and room finder, shared and delegated calendars, time zones for overseas calls, Bookings pages and meeting habits that save time.
Read article →Outlook Intermediate Lesson 5: The 4D Inbox System and Category Color Management
Outlook Intermediate Lesson 5: The 4D Inbox System and Category Color Management
Set up a simple system with five colour categories and flag dates, Quick Steps and the daily and weekly routine that keeps the inbox…
Read article →Outlook Intermediate Lesson 4: Email Productivity with Quick Steps, Quick Parts and Templates
Outlook Intermediate Lesson 4: Email Productivity with Quick Steps, Quick Parts and Templates
Stop retyping the same emails: save .oft templates, insert Quick Parts paragraphs, use My Templates in new Outlook and fill-in placeholders for payment reminders…
Read article →Outlook Intermediate Lesson 3: Custom Views and Conditional Color Formatting
Outlook Intermediate Lesson 3: Custom Views and Conditional Color Formatting
Make important mail stand out: colour mail from your manager, show attachment size and category columns, group by conversation or sender, and save custom…
Read article →Outlook Intermediate Lesson 2: Advanced Search Operators and Persistent Search Folders
Outlook Intermediate Lesson 2: Advanced Search Operators and Persistent Search Folders
Find any mail in seconds with from:, hasattachments:, received: and AND/OR/NOT, and save repeated searches as Search Folders that update themselves.
Read article →