Type the Greek letter Omega in upper case Ω or lower case ω in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Omega (uppercase Ω / lowercase ω) is the twenty fourth and final letter of the Greek alphabet. It is used to often
Here are the best ways to get results from Microsoft Forms into an Excel workbook. Sadly they aren’t the elegant and efficient ways available in modern Microsoft Excel 365, 2021 or 2019 for Windows. We’ll explain how to get Microsoft Forms results into Excel for better filtering and analysis. Then
I said there are at least six tricks with the Excel Name Box and that’s before you get into using named rangers and objects. The Name Box lets you select a cells and give them a name or jump to an existing named range. It’s the same as going to
I found at least six uses for the Excel Name Box beyond just displaying the current cell address. The Name Box is an unassuming little box at the top of your Excel worksheet that you may not have thought about much, but it has a powerful range of uses for
Microsoft Word’s Sort feature is OK but has its limitations. We humans insist on variations of the simple ‘first and last’ name that confuse a computer. Here’s some name sorting traps and workarounds. For short lists, it’s probably enough to do a Word surname sort then manually adjust the list
A full and searchable list of the measurements and multiplier prefixes available for Excel’s CONVERT function. This is a table of the abbreviations used in the Excel CONVERT() function. The basic units inbuilt to the function are all listed plus some of the common measures available using the Multiplier prefixes.
Converting SVG icons into JPG is essential for older Word and Office versions that don’t have native icon/SVG support. Here’s some options for conversion or sourcing alternatives. SVG’s are great with many advantages for Office 365 and Office 2021/2019 users. Not everyone has the latest Microsoft Office or shares documents
Insert the Phi uppercase Φ, and Phi lowercase φ / φ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Phi (uppercase Φ / lowercase φ / φ) is the 21st letter of the Greek alphabet. The uppercase symbol has various uses, such as the cumulative distribution function of standard normal deviation in
Microsoft is working on extending OpenAI features like ChatGPT to help people write Word documents based on a short suggestion. And there’s a lot more possible given Microsoft’s investment in OpenAI, even a koala poem ‘written’ by Dorothy Parker. Office Watch has been looking at ChatGPT’s ability to write Office
How to insert the Upwards arrow ↑ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. The upwards arrow ↑ symbol is used for various purposes. It can notate a mathematical symbol for ‘undefined’, for very large integers or in medical notation it can mean increased. Of course, there are plenty of uses in
Get ChatGPT or Copilot to show working Office VBA code to select and open a Word, Excel or PowerPoint document. It’s an example of how to work with ChatGPT to get the code you need and its limitations. In episode 1 of this saga, Office Watch showed how to use
To make data entry simpler in Excel, form controls such as checkboxes can be added. A checkbox can be used to select or deselect an option. Checkboxes are useful for forms that have multiple options. The trick is using Excel’s Developer tab which holds the checkbox control. See How to get the Developer Tab in
How to insert the Sigma upper case Σ and Sigma lower case σ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Sigma (uppercase Σ / lowercase σ) is the eighteenth letter of the Greek alphabet. In mathematics, the uppercase sigma symbol is used
Insert the Double Dagger ‡ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Double Dagger ‡ symbol is used to mark a third footnote after the asterisk and dagger in a Word document. How Double Dagger ‡ looks in different fonts. Here’s some
How to change the look of Word mail merge data like dates and dollar amounts to exactly what you want to see in the documents. Nancy M asks: “I try to merge data (such as amount, PO#, to whom, as well as the date) from an Excel database. In the
How can you put percentages into a Word mail merge? There are several methods including the one we like because it’s reliable and simple. Following our article on importing Excel data into a Word mail merge, here are the options for using percentages. Excel might show a percentage but the
Microsoft has made some ‘under the hood’ improvements to the combo ‘IF’ and ‘IFS’ functions like SumIFS(), SumIF(), CountIF() to make them faster than before. Just don’t believe Microsoft’s excessive boasts. The functions themselves behave the same but they now have a cached index for the range. That index is
Consider switching to SumIFS, it’s much the same as the older Excel function, SumIf() but easier to expand as your needs change. It can add up values according to more than criteria like a name and date range. We’ve talked about SUMIF and how its parameter order is a little
Type Infinity ∞ and similar symbols into Microsoft Word, Excel, PowerPoint or Outlook. In Office for Windows and Office for Mac you can enter Infinity, Incomplete Infinity, Tie over Infinity and Infinity negated. Infinity ∞ symbol is used for anything that has no end or boundless. Of course, it’s in
Can Office 2007 and other older versions of Office (Office 2010, Office 2013) be installed on Windows 11? What are the licensing, activation problems? How about moving documents? There are four issues to consider; licencing, compatibility, support/patches and migrating documents: Officially only these versions of Microsoft Office are supported on
Can Office 2007 and other older versions of Office (Office 2010, Office 2013) be installed on Windows 10. What are the licensing, activation problems? How about moving documents? Eileen G asks a common question to Office Watch: “I got a new HP desktop computer, but can I install the old
Insert a Dagger † into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Dagger † symbol is used to indicate a footnote if an asterisk has been already used. Footnotes and Endnotes in Word Formatting Footnotes and Endnotes Dagger is a different look
Microsoft Office has plenty of important changes and end dates coming in 2023, starting with two in January. Here’s a list of what Microsoft has in store for their paying customers. Microsoft 365 app coming in January 2023 The Office mobile app (the ‘all in one’ app) is being changed
There are a lot more airplane symbols available in Microsoft Office including ones for landing, takeoff and even pilots. Also how to get plane graphics for specific models like a 747 Jumbo. If you know where to look, Office has plenty of ‘airplane’ related graphics beyond the simple Airplane ✈
