All about Microsoft Office for Apple Mac. Word, Excel, PowerPoint and Outlook on macOS
Microsoft 365 for Mac, Office 2021 for Mac and earlier versions.
The latest macOS, v12 called ‘Monterey’ is out now. Which Microsoft Office for Mac will work with the new operating system for Mac computers? Should you update to Monterey now or wait a little while? In short, any Office for Mac which works with ‘Big Sur’ macOS v11 is OK
There’s a new generation growing up who see the Office ribbon differently from their parents. To some young people a floppy disk icon looks more like a vending machine! Check out this icon on the older Office ribbon …. To you, me and most people it means ‘Save’ because that’s
Word has many options to make simple checklists that you can print out and tick with a pen (ink or digital). Plenty of formatting choices for the shape of the tick ‘box’, it’s color and size. There’s a simple shortcut to re-order the list. Previously we’ve discussed how to make
Redo is the often-forgotten partner to Undo. It’s mostly used to ‘undo an undo’ or reverse the last ‘Undo’ action but ‘Redo’ has other uses in Word, Excel, PowerPoint and Outlook. In most cases, you use the redo button to revert to a previous state. For example, if you used
Excel and Wolfram have teamed up to produce a handy interactive Periodic Table Template, useful for those searching for an introduction to chemistry, or a handy guide for study. The table lets you easily access information on elemental properties, chemical compounds, diagrams and more. You can download or open the
Here’s the short list of new and changed features in Access 2021. It has only three new and changed features in the high-end Office 2021 and Office LTSC 2021 bundles. Remove, relink, or refresh linked tables The Access database includes a Linked Table Manager that provides a central location for
Visio 2021 has only two new and changed features in the high-end Office 2021 and Office LTSC 2021 bundles. Visio’s new shapes and stencils Microsoft has added many more stencils for users to use when creating Azure diagrams. For example, stencils can be used to create diagrams on network topologies,
An essential part of Word’s citations and bibliography feature is the Source Manager dialog – here’s how to, er, manage the Source Manager. Open the Source Manager from References | Citations and Bibliography | Manage Sources. There is a Current List (at right) which is saved in the current document.
The workload of students and academics has been made a lot easier with the arrival of Citation features in Word. They are useful for everyone, not just in academia. Citations are individual references to source material you’ve quoted in your document. A Bibliography is a list of citations and sources
Microsoft Word’s ‘Similarity Checker’ compares Word document text with online sources. That can warn the writer / student or reader / teacher about plagiarism or accidental copying. Word Similarity Checker uses Bing search to compare the text with online sources. It shows a percentage of text similar to text found
How many rows and columns does Excel have now and in the last 25 years of Excel for Windows and Mac? All the talk about 64-bit versions of Office has raised the issue of maximum rows and columns in Excel. A few readers seem to believe that 64-bit Excel will
There are many online tools that will summarize or paraphrase a long Word document into something shorter and more readable. These five tools also have other uses. Originally, Word 2007 had an Auto Summarize feature, but it was dropped in Word 2010, so Word users will need to rely on
Good news iOS users, if you’re a Microsoft 365 subscriber, you now have access the premium content library. Take your Word, Excel, and PowerPoint creations to the next level with thousands of royalty-free images, icons, stickers, and illustrations. Here’s how it works Tap Insert | Pictures | Stock Images on your iOS device,
Numbered or bullet lists don’t have to look the way Microsoft sets automatically here’s how to change them to suit your needs and style. In Microsoft Word, it is simple to create a numbered or bullet list. Simply select your text | Home Tab | Paragraph Group| Select the Numbering
Organizations need to start work now to reduce the impact of coming price rise. Microsoft 365 enterprise licenses can increase by up to 25% on 1 March 2022 . Here’s some tips to keep the costs of Microsoft 365 down, despite Redmond’s efforts to get more money from customers. Individuals
Skype is getting a surprise makeover with improved group calling views, display customization, two camera support and even translation on calls to regular phone lines. Microsoft calls these changes, we’re not kidding, ‘buttery smooth’. The announcement is a surprise because all the indications have been that Skype is on its
There are two exponential function options in Excel. Like many things in Excel, what looks simple has some traps for the unwary. We’ll explain why the Power() and ^ don’t always give the same or even correct result. Exponentiation is an operation in mathematics, written as an, involving the base
Let’s imagine you’re in Word’s Print Preview and you’ve suddenly noticed an error in your document. You close print preview to make the change, then you go back to print preview again or you can discover Print Preview Edit Mode. Print Preview in Word has all sorts of goodies for
XMatch() function in Excel locates an item in an array or range of cells, then returns its position relative to the item. It’s similar to XLookup() which returns the cell value while XMatch returns a relative position in the array. Syntax =XMATCH(lookup_value, lookup_array, [match_mode], [search_mode]) Arguments Lookup_value – the value to find. Lookup_array
Excel can use past data to project possible future results with the Forecast feature. It’s a very simple version of statistical ‘modelling’. The Forecast function will let you predict future values and data trends, such as consumer trends, future sales and or inventory needs, based on seasonality. Here’s a simple guide on how to use the Forecast feature. Although
Previously we talked about How to add a Drop-down List in Word, but you can also work more efficiently in Excel worksheets by making use of drop-down or pull-down lists. We will show you how to use Microsoft Excel’s data validation function to create useful lists within your spreadsheets. How to avoid the trap that lies waiting for the unwary
As if Lambda() was already a great addition to Excel 365, Microsoft is adding what they call ‘helper’ functions to add even more abilities. Here’s a very short overview of each helper function with links to more information. In some cases, the helper functions are a new and better way to do things already
Excel 365’s nifty LAMBDA feature is getting an interesting, literally optional, improvement plus ‘Helper’ functions to extend its usefulness. LAMBDA, a powerful tool that allows users to create their own Excel 365 custom functions without VBA. The feature allows longer formulas to be written once then referenced in a worksheet to a shorter name of the user’s choosing. LAMBDA isn’t just another Excel function, it’s an important change in how
There’s another way you can force a page break before a paragraph in Microsoft Word. By setting this up, the page breaks can automatically appear without you having to worry. This is particularly useful if you have long documents with several different headings. Just simply modify the style to include
