WordHow to Use the AutoCorrect Feature to Create Custom Typing Shortcuts in Microsoft Word
If you are a legal professional, a doctor, or a corporate manager, you likely type...
ExcelHow to Use the FIND Function to Locate a Specific Character Within a Text String in Excel
When cleaning up a massive Microsoft Excel database, you will frequently need to split a...
WordHow to Automatically Add a Table of Authorities to a Legal Document in Microsoft Word
If you are drafting a complex legal brief, court rules mandate that you include a...
WordHow to Use the Combine Revisions Feature to Merge Two Documents in Microsoft Word
If you email a contract to two different business partners, and they both make edits...
ExcelHow to Use the TEXT Function to Convert Numbers into Formatted Dates and Currencies in Excel
When you attempt to combine text and numbers in a single Microsoft Excel cell using...
ExcelHow to Use the NETWORKDAYS Function to Calculate Working Days Between Two Dates in Excel
If you are managing a massive construction project or building an employee payroll sheet in...
WordHow to Use the Keep with Next Feature to Prevent Paragraphs from Separating in Microsoft Word
When formatting a massive corporate report in Microsoft Word, you will often encounter a frustrating...
ExcelHow to Use the REPT Function to Create In-Cell Bar Charts in Excel
When most people need to visualize data in Microsoft Excel, they immediately highlight their numbers...
WordHow to Use the Navigation Pane to Find and Replace Specific Formatting in Microsoft Word
If you inherit a massive 50-page document where the previous author incorrectly bolded every single...
WordHow to Automatically Replace Straight Quotes with Smart Quotes in Microsoft Word
When you are typing a novel or an academic essay in Microsoft Word, the quotation...
ExcelHow to Use the IFERROR Function to Hide Ugly Formula Errors in Excel
When you build a massive dashboard in Microsoft Excel, you will inevitably encounter situations where...
ExcelHow to Use the CLEAN Function to Remove Non-Printable Characters in Excel
When you copy and paste data from an old legacy database, a PDF document, or...
WordHow to Use the AutoCorrect Math Feature to Type Equations Faster in Microsoft Word
Typing complex mathematical equations in Microsoft Word using a standard keyboard is a notoriously frustrating...
ExcelHow to Use the SUBSTITUTE Function to Replace Specific Text in an Excel Cell
If you inherit a massive Excel spreadsheet containing thousands of product codes or employee IDs,...
WordHow to Automatically Translate Selected Text in Microsoft Word
If you are reviewing an international contract or reading an essay containing a few sentences...
ExcelHow to Use the ISBLANK Function to Test if a Cell is Empty in Excel
When you are managing a massive Microsoft Excel database filled with thousands of rows of...
WordHow to Automatically Replace Two Hyphens with an Em Dash in Microsoft Word
If you are writing a formal essay, a novel, or a journalistic article in Microsoft...