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.
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
Interactive checkboxes can easily be added to your Word document for a variety of uses. Perhaps you need to create a to-do checklist to help monitor the completion of tasks on top of a collaboration document, or make it simpler for users to read and complete surveys or forms. Either way, we will provide
Outlook’s Folder Pane displays all folders which lets you quickly move between folders and views. Minimise the Folder pane, you will no longer be able to see your folders. As a result, some users get puzzled as to how they can bring back the expanded Folder Pane view. There are a few ways that
Here’s what you need to know about the two official international document formats, Microsoft’s OpenXML (.docx .xlsx etc) and Open Document Format (.odt .ods etc) both supported in Microsoft Office and most other office suite software. Each format has been recognized by international bodies so there are two ‘official’ document
Not only can Teams share Word, Excel or PowerPoint files, but you can also make new documents right in Teams or upload existing documents. Create a New File You can easily create a new file within Teams for Word, Excel, PowerPoint or OneNote from the New pull-down list at left.
Excel’s PivotTable allows you to evaluate trends, comparisons, and patterns within datasets. Once a PivotTable is setup, you can filter “Drill down” into it to focus on key information. These days there are several ways to filter a PivotTable, Slicers (which Microsoft loves to boast about), AutoFilter and by Field
Soon older versions of Outlook won’t be able to connect to Microsoft hosted mailboxes, even though both the software and service come from the same company. Here’s what’s happening, why, who is affected and what to do. Microsoft is finally ending older, insecure, ‘Basic’ authentication connections to their Microsoft 365
Teams makes it simple to share files and collaborate. If you are working with Word, Excel, PowerPoint, or Visio files, your coworkers may read, edit, and collaborate on them directly from Teams. The different ways to open a document in Teams. Files Access Within Microsoft Teams, each Channel has a
Office Depot in the USA has a good deal available now for both Microsoft 365 Family and Personal, but with an important limitation buried in the fine print. Both offers are for 15 months of Microsoft 365 for the price of 12 but you must buy a ‘qualifying product’ to
While OneNote is very flexible, especially with pages, there’s an overall structure from Notebooks to Sections, Pages, sub-pages and containers. NOTEBOOKS OneNote is based on a series of notebooks. You can make notebooks for any topic you like. One for personal or diverse notes. Others for work, a hobby, subjects
Since 2003, OneNote has been available to many Office users as part of their Office suites or subscriptions. It features free-form note-taking and multiuser collaboration, plus it’s fairly straightforward and user-friendly, so why not give it a try? What is OneNote? OneNote is a place to keep notes of all
Pages can contain all manner of things, it’s as simple as ‘click on the page and type’. A container is automatically created for you. Of course, you can copy things from elsewhere (web pages, documents etc) and paste into OneNote. The real power of OneNote is to include lots of
Teams makes it simple to share files and collaborate. If you are working with Word, Excel, PowerPoint, or Visio files, your coworkers may read, edit, and collaborate on them directly from Teams. Co-edit files Each team member has access to files that have been uploaded and shared on Teams. You
If you’re not willing or able to spend the money, there are several ways you can access Microsoft Office for free. These tips are just good for saving money. Some are useful standby’s to keep in mind if you can’t use the full Microsoft 365 desktop programs. Maybe your computer
Simple, easy and free ways to convert audio files like WAV, FLAC and many others into a format that PowerPoint or your smartphone prefers such as MP3, MP4 or AAC. The BBC Sound effect downloads are in WAV format. That’s a good, high-fidelity and uncompressed format that works in PowerPoint
How to stop your Office Watch newsletters going to the Junk E-mail folder. To make sure your Office Watch newsletters don’t end up in your Junk Email folder you need to set us up as a ‘Safe Sender’. Here’s how to do that in Outlook. Keep in mind that Outlook
If you think font selection is hard, spare a thought for lawyers who have to deal with different official rules, recommendations and accepted practice for court submissions. Jason Steed at JDSupra sets out the complications for US lawyers. The D.C Circuit court started ‘discouraging’ use of Garamond font but no
