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
Microsoft has publicly released Office LTSC or Long Term Servicing Channel. It’s the ‘fixed feature’ Office suite for volume licence customers. It’s a replacement for Office 2019 but only available to business and government customers. Office 2021 is the personal and small business equivalent which will be out on 5
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
Microsoft has released a patch for the MSHTML security bug that’s being used with Office documents to infect computers. The bug is in MSHTML, the browser rendering engine used by Microsoft Office. If someone is tricked into opening a hacked Office document with ActiveX control, they could infect their computer
There are many API’s available on the Internet that can provide great and timely data in ways that Excel can understand, here’s how you can do it. We’ve recently received emails asking how to use Excel to import data from specific API’s. Always we have the same answers because most
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
The September 2021 release preview has a lot more than usual new and updated features in Office 365 for Windows. Almost as if Microsoft has been saving them up for a bumper surprise! It’s all in the ‘Current Channel (Preview)’ release v2109 build 14430.20088 that’s out now. This is the
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
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
The hardware requirements for Windows 11 are surprisingly high especially the increased security requirements. Some brand-new computers, even Microsoft’s own high-priced Surface computers bought today might not be compatible with Windows 11. See all the Office-Watch.com coverage of Windows 11 Unlike previous major Windows releases, you can’t assume that a
The new Widgets pane in Windows 11 has three widgets for Outlook and Microsoft 365 users. Calendar, To Do and one only for Enterprise users. Widgets are a pop-up window of configurable small panes. The selection of widgets is quite limited, at least for now; Weather, Traffic, Stocks, Sports, Entertainment
Now you know how to insert checkboxes in Excel, here are some ways to use check box cells in Excel. Counting the checked/unchecked boxes, calculate percentage checked and even showing a separate list of items based on their checked status. A cell with a check box has two values: TRUE – checked FALSE – UNchecked
Microsoft has updated the Office programs to support the OpenDocument format (ODF) to version 1.3. Most people use Office Open XML format (OOXML) which is the official name for what is usually called the ‘new’ Microsoft Office formats, .docx .xlsx .pptx etc. OpenDocument files .odt .ods .odp etc are also
OneDrive on Mac computers won’t be supported on older macOS from mid-September 2021. The latest macOS and last two releases will continue work and be supported. Microsoft’s general policy for supporting Office on Mac computers is to support the most recent version of macOS and the two versions before that.
