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.
Here’s how to collaborate on a ‘live’ file (Word document, Excel workbook, PowerPoint deck or OneNote notebook) saved on OneDrive or other cloud service. It’s part of our series on accept a sharing request and collaborating on a ‘live’ document saved online. Microsoft spends a lot of energy getting people
Microsoft spends a lot of time explaining how to share a file (Word document, Excel workbook, PowerPoint deck or OneNote notebook) but very little on how to accept a sharing request and collaborate on a ‘live’ document saved online. Live or real-time collaboration lets two or more people work on
Chromebooks are low cost alternatives to regular laptops with great battery life. They can run Microsoft Office in different ways – two and a half by our count. There were two more, but Microsoft dropped support for them in September 2021. Quick Chromebook buying tips Web apps Chromebooks come with
Save-the-date cards, invitations, place cards and other wedding paperwork can be made in Word. Reduce stress and expenses, by creating your invites digitally through Word. Creating your own invites is a great approach, adding a personal and unique touch to proceedings. Usually, you’ll find Wedding Invites are in A5 size. Simply open your new document, go to the Layout
A security company has revealed a dangerous setting in Microsoft PowerApps. Microsoft has fallen back on one of their oldest tricks, blaming the customer. There’s a similar ‘way too open’ option in Word, Excel and PowerPoint. Power Apps provide ways for organization to make simple apps to access online data
