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 ✈
Adding color gradient effects to your text, shapes and borders is a good way to give it a bit more zing to Microsoft Word, PowerPoint or other Office docs. The gradient feature is quite sophisticated, with a wide range of options and adjustments available but not obvious. To add a
Our Year Planner Excel workbook download is just the start. Here are many suggestions for changes to improve or customize the download. Tips for changing the headings, overall look, change financial year, highlight public holidays, change the look of a day in the week, change weekend shading or day label.
Microsoft has two new formula helpers in Excel. One to suggest the right function (Formula Suggestions) and the other to automatically insert copies of a formula (Formula by Example). For the moment, these two features are in Excel on the web but are likely to spread to other Excel’s during
How to add a calendar as quick reference to your desktop on Windows or Mac. It can be a yearly, monthly or weekly calendar, just like the old paper calendar / blotting paper on an office desktop in olden times (i.e. 20 years ago)! A handy place to put a
Here’s a great Excel yearly planner that we’re delighted to share. It works for 2024 or any other year you like and highlights Public Holidays in a simple and elegant way. Office Watch friend David Peel from the UK made this workbook and let us share with our readers. He’s
Excel has a Calendar Creator template which might work or might not. Why it doesn’t work is a little mystery but we have an alternative for our readers. The ‘Calendar Creator (any year’) template sounds great … a one-page year calendar. Find it from File | New then search for
Type the Lambda upper case Λ, and Lambda lower case λ symbols (aka Lamda) in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Lambda/Lamda (uppercase Λ / lowercase λ) is the 11th letter of the Greek alphabet. The uppercase symbol has various uses, it is
The Delta upper case Δ or Delta lower case δ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Delta (uppercase Δ / lowercase δ) is the fourth letter of the Greek alphabet. It’s the “d” sound in Modern and Ancient Greek. Delta
Looking for some Christmas images, pictures or graphics? Microsoft Office has some in-built Xmas options for the festive tide of Yule. Add these images into Word documents, Outlook emails, PowerPoint slides or even Excel worksheets. Unsubtle Hint: Christmas Cheer with Office has a collection of festive cards, letters, gift tags,
Type the Airplane ✈ symbol, icon, emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Airplane ✈ symbol is often used for signs, directions or an itinerary, possibly in combination with symbols for other transport like train, car, walking. For more ‘airplane’
The Lambda() feature in Excel 365 is great, when you try using it the downsides quickly become obvious. Happily there are workarounds. Lambda() itself is fine. It’s a welcome addition which more advanced users will make Excel do amazing things or simplify complex formulas. See Lambda – strange name for
RGBA color codes are an extension of the RGB (Red, Green, Blue) color system which you can use in modern Microsoft Office with a little trickery. There’s an annoying difference (reversal) in settings on Office for Windows vs other Microsoft services and Office for Mac. RGB colors have been around
