Office Mastery | Coach

Office Mastery

Add/Update information

Reviews

Tags

• Businesses
• Sport & recreation
• Coach
• Computer training school
• Sport & fitness instruction

23.01.2022 It takes less than a minute to password protect Word documents and could save you a world of pain. https://bit.ly/3hjfHix #02RIV #WordTips

22.01.2022 A Word index allows the reader to search for a specific word or phrase, normally in alphabetical order and go straight to the relevant page (or pages).Here's how to build an index page in Microsoft Word using the mark and index method https://youtu.be/64L-mOumBuY #02RIV #WordTips #WordIndex

21.01.2022 Do you need to set up dual multilevel numbering in Word, where two independent numbering systems run concurrently through your document? I have the solution: https://bit.ly/3d0MJRu #02RIV #WordTips

21.01.2022 If you need to create a multilevel numbering system in Word (such as 1 - 1.1 - 1.1.1) that updates itself automatically, but you just can't get it to work, check out this post. https://officemastery.com/_word-multilevel-numbering-word #02RIV #WordTips #Multilevel

20.01.2022 How big is a point? When choosing a font size, what does point size mean? https://bit.ly/2XvNL24 #02RIV #WordTips

19.01.2022 COUNTIFS is like COUNTIF on overdrive. It counts up all rows where for specified ranges, specified conditions are true. https://youtu.be/GRpmO_B_-10 For example, where COUNTIF says, look at this range and check for this, COUNTIFS says, look at range 1 and check for this AND look at range 2 and check for that AND look at range 3 and check for something else. And you can keep on going. ... Where all conditions are met, the row is counted. #02RIV #ExcelTips #COUNTIF

18.01.2022 Discover lots of attractive visual separators you can add to your document with just 3 keys. https://officemastery.com/horizontal-separators-in-microsof #02RIV #WordTips

17.01.2022 How to write a SUMIF formula in Excel (with examples). https://bit.ly/2XccI3D This video walks you through how to create a number of different SUMIF formulas from scratch. #02RIV #ExcelTips #SUMIF

17.01.2022 Advanced text effects in MS Word ... https://bit.ly/2ZBILM1 (kerning, ligatures, stylistic effects, superscript, subscript, lowering text, stretching, spacing, drop caps, separators, text watermarks, image watermarks) #02RIV #WordTips

17.01.2022 Stretching text and spacing text in a Word document can bring your titles and headings to life. Here's the lowdown ... https://bit.ly/2Ab1Euq #02RIV #WordTips

14.01.2022 What are ligatures and stylistic effects? Why, where and how are they used in Microsoft Word? https://bit.ly/2X3dgbU #02RIV #WordTips

14.01.2022 If items in your Table of Contents are misaligned, it's a simple case of fine-tuning the TOC styles. https://bit.ly/2XbQ0s9 This video explains how and ends with a killer tip to identify exactly where a glitch is occurring.... #02RIV #WordTips #TOC #Styles

13.01.2022 Discover the best way to create a drop-down list in Excel that makes it easy to maintain and re-use and puts YOU in full control. https://youtu.be/FJLUsmo5aEY #02RIV #ExcelTips #DropDownList

12.01.2022 Add a touch of professionalism to your Word document with a drop cap. A drop cap draws the reader's attention to the beginning of a new chapter or section. It's super easy. https://officemastery.com/drop-cap-in-microsoft-word #02RIV #WordTips

12.01.2022 Hidden secrets of the Backstage view in Word. What the experts do: Go meta. Claim ownership. Protect their IP. Inspect the document for flaws. https://bit.ly/2YtS4LE #02RIV #WordTips

12.01.2022 3 ways to add text or image watermarks to your document. https://bit.ly/2LZM1si #02RIV #WordTips

11.01.2022 Why not add a single, double, triple, dotted or dashed separator to your document? Add visual appeal with 3 quick keystrokes. https://bit.ly/2MS4gAE #02RIV #WordTips

11.01.2022 There's a technique that the pros use to build their index page cleanly and quickly. Compared to the messy and laborious 'mark and index' method, using a concordance is a dream and can be reused on other documents. Here's the low-down: https://youtu.be/jnYWmfxDOag #02RIV #WordTips #WordIndex

10.01.2022 Is your Word index (created using 'mark and index' or a concordance file) looking messy, disorganised or just plain boring? It doesn't take long to give your entire index a facelift. https://youtu.be/yhG5cZFu_no #02RIV #WordTips #WordIndex

10.01.2022 Going beyond standard dropdown lists, you may want to choose an item from list 1, then select appropriate sub items from list 2 based on your choice. Likewise from list 2 to list 3. That's what I call dependent or multilevel dropdown lists. https://youtu.be/d4_LCPN7g84 #02RIV #ExcelTips #DropDownLists

09.01.2022 How do you delete multiple selected emails in Outlook quickly and easily on demand, or automatically? https://bit.ly/2TNxsg3 3 approaches to cleaning up email: Inbox Rules, Quick Steps and Conversation Cleanup. ... Hey, you may even reach Inbox Zero! #02RIV #OutlookTips #EmailCleanup

08.01.2022 You worked hard to produce it. Now, stop people stealing and plagiarising it. Here are 5 simple measures you can take to protect your document and intellectual property (IP): https://bit.ly/3ff8tdF #02RIV #WordTips

08.01.2022 When using different fonts or mixing images and text, raised text or lowered text allows you to position it with precision. Here's how. https://bit.ly/3elvzPl #02RIV #WordTips

08.01.2022 Always inspect a Word document to remove personal or hidden information and check for accessibility and compatibility issues. https://bit.ly/30vE9HH #02RIV #WordTips

08.01.2022 What is font kerning? https://bit.ly/2X07bwM Where is kerning used? Why is kerning needed? Who uses kerning? How do you set kerning in Microsoft Word? #02RIV #WordTips

08.01.2022 How to write a SUMIFS formula in Excel (with examples). https://bit.ly/2ZNwhRB SUMIFS is like SUMIF on supercharge. This video walks you through how to create a number of different SUMIFS formulas from scratch.... #02RIV #ExcelTips #SUMIFS

07.01.2022 How to create custom appendices in Word (by cleverly using TC and TOC fields). https://bit.ly/2Xcgxpl See how to create a series of appendices that list all the sentences within the document that contain a specific word or phrase.... #02RIV #WordTips #Appendix

06.01.2022 Add a Drop Cap like professional writers do. It grabs the reader's attention, draws their eye and provides a visual starting point to start reading. https://bit.ly/3cUScZU #02RIV #WordTips

06.01.2022 COUNTIF lets you tally the number of items in a list that meet a given criteria. It gives you much more control than COUNT, COUNTA and COUNTBLANK because you can be much more specific than just counting data of a particular type. https://youtu.be/B-P2Q2jQqLQ #02RIV #Excel #Formula

06.01.2022 How do some people get those funky bullet points in Word? Ever wondered how to create your own numbered lists or customised bullet points using symbols, icons or pictures? Here's the lowdown. https://bit.ly/30kK6XQ #02RIV @WordTips

05.01.2022 Conduct a combined 2-column lookup on an Excel table using a simple array formula. No concatenation. No complex or convoluted techniques. https://youtu.be/gyuHtu_3YWo #02RIV #ExcelTips

04.01.2022 Looking for a new computer? With so many to choose from, which features are essential, which are nice to have and which can be ignored? This beginners guide will help you get the right computer for you: https://bit.ly/2UnxvPI #02RIV #NewLaptop #NewComputer

03.01.2022 What are superscript and subscript and where would you use them? Here are 3 ways using Microsoft Word ... https://bit.ly/2ZJcGSn #02RIV #WordTips

02.01.2022 Beginners Guide: 3 places to find help in Microsoft Word to get you out of a fix. https://bit.ly/3feCoTb #02RIV #WordTips