Microsoft Excel has introduced two powerful new functions that make importing external data into spreadsheets faster and simpler. IMPORTTEXT and IMPORTCSV functions let you pull data directly from text or CSV files into Excel with a single formula, creating refreshable dynamic arrays can be updated when the source changes. These functions give Excel users a […]
Whether it’s no smoking, talking, eating or whatever you can make your own ‘Prohibited’ or ‘Not Allowed’ symbol for serious or fun reasons. Whether you want to block a specific action in a document, presentation, or worksheet, Word, Excel and PowerPoint make it easy to design your own customized “Don’t” symbol. From combining shapes to […]
Need to insert the square root symbol (√) in Microsoft Office? Whether you’re working in Word, Excel, PowerPoint or Outlook, there are several quick and easy ways to add √ to your document, spreadsheet or email. From keyboard shortcuts and Alt codes to Equation tools and symbol menus, here’s how to insert the square root […]
Creating clean, professional-looking stacked fractions in Microsoft Office is easier than many users realize, if you know where to look. The built-in Equation feature lets you insert vertical (stacked) and other fractions quickly, without hacks or manual formatting. Here’s the fastest and most reliable way to add proper mathematical fractions in Word, Excel or PowerPoint. […]
Microsoft talks about “Office Math” in Microsoft Office but you won’t find that name in Word, Excel, PowerPoint or OneNote. We explain where to find “Office Math” and why it appears under the name “Equation” in Microsoft 365 or Office. Also how to convert “Equation Editor” formulas into modern “Office Math” Microsoft talks about “Office […]
