Numbers make the world go round. Excel’s become indispensable for crunching numbers – so why not make the most of the application? We’ve got a wealth of how-to articles on optimizing the ways you work within Excel, and we’ll be spending this week collecting them in one place. This way, you get a comprehensive how-to that will allow you an easy reference for mastering Microsoft’s flagship spreadsheet program. Email subscribers will have the full text of all these articles: How to Sort and Filter Your Data in Microsoft Excel How to Work With Formulas in Microsoft Excel How to Protect and Secure Your Data in Microsoft Excel Helpful Free Add-ins for Microsoft Excel We’ll have more great Excel content on Thursday. …This article is part of our premium content. Join Now.Already a paid subscriber? Click here to login.
Having difficulty getting Office 365 to behave? These tips and tricks can help. You use or are trying to use Microsoft Office 365 but are running into problems with it. Maybe it’s not activating properly. Perhaps it’s installed and activated, but a specific program such as Outlook isn’t working right. What can you do? One option for activation issues is to run a tool called the Activation Troubleshooter. For those issues and other problems, you can always try to run a repair or reinstall of Office 365. Another move to use a free program from Microsoft named Microsoft Support and Recovery Assistant for Office 365. Also known as SaRA, the Support and Recovery Assistant runs a series of tests to look for glitches and maladies in Office 365. If it finds something amiss, the program can try to fix the issue or tell you how to fix it yourself. The one limitation with SaRA is that it works only with accounts that use Office 365 on the backend, such as Office 365 for Business or Education. Office 365 for Home and Outlook.com aren’t supported. If you use Gmail, Yahoo Mail, your ISP’s email, or some other service on the backend, … Read More
Since today is Global Accessibility Awareness Day, we’ll review how a few of the big tech companies are helping with accessibility when it comes to their products and services. Global Accessibility Awareness Day (GAAD) began back in 2012 with a goal to drive the dialog about making digital access to resources/services accessible to those with disabilities. On the seven-year anniversary of the establishment of GAAD, tech companies are showing how they are making their own technology even more accessible. Microsoft The folks in Redmond have become pretty good at building hardware over the last few years with their Surface line of devices and accessories. Today, they showed how that same approach can make a significant difference for gamers with the unveiling of their upcoming Xbox Adaptive Controller. This article is part of our premium content. Join Now.Already a paid subscriber? Click here to login.
Workflow automation is an increasingly important factor in productivity. A research report from Formstack released this year found that half of managers are spending the equivalent of one full workday each week on administrative tasks, many of which could be automated. And 44 per cent of managers reported that their workplace has invested significantly in workflow automation tools within the past two years. Managers are spending significant amounts of time, up to half of the average workday, on administrative tasks. In many cases, these tasks could be automated. “Few business owners really grasp the concepts of what automation in technology can do,” said Martin Webb, a founder of Tudodesk. “When they start a business or look to grow it, they instantly assume the problem they need to solve is by hiring help.” There are times when automating repetitive or administrative tasks can free up time and mental space, allowing for focus on more important matters. Automate Your Email This article is part of our premium content. Join Now.Already a paid subscriber? Click here to login.
Microsoft first announced their plans to build an ecosystem of devices around your Windows 10 system at BUILD 2017. Since then they have been testing several features to bring this ecosystem to life. The ultimate goal is to make it easier to pick up activities and work you have started on other devices in this ecosystem. Cortana, if you use the digital assistant on your compatible devices, will help you pick up where you left off on other Windows 10 devices. If you are using a Windows 10 based device and move to another Windows 10 device using the same Microsoft Account in about a 10-minute period, you will receive a notification in the Windows 10 Action Center. This notification will have shortcuts to websites that you were actively using on the other device. This is very handy as you move between Windows 10 devices but what about when you are on your mobile device and want to easily get a website to browse on a larger screen. That is where the Continue on PC feature in the Windows 10 April 2018 Update comes in handy. Updated versions of Microsoft Edge on Android and iOS devices now have a button … Read More
Two zero-day exploits need attention now, say analysts. Microsoft patched 68 vulnerabilities in its monthly Patch Tuesday release, including two zero-day exploits. Of the patches 21 are listed as critical, 45 rated important and two listed low in severity. Updates this month affect several products including Microsoft Windows, Internet Explorer, Edge, Office and Exchange Server. Obviously, the priority for deploying is for those are those under active attack. That includes are CVE-2018-8174, a Windows VBScript Engine Remote Code Execution Vulnerability. The flaw was discovered and reported by Kaspersky Lab researchers and impacts IE and other projects that embed the IE web rendering engine. “This technique, until fixed, allowed criminals to force Internet Explorer to load, no matter which browser one normally used — further increasing an already huge attack surface,” according to Anton Ivanov, security researcher at Kaspersky, in an email to Ars Technica. “We urge organizations and private users to install recent patches immediately, as it won’t be long before exploits to this vulnerability make it to popular exploit kits and will be used not only by sophisticated threat actors but also by standard cybercriminals.” The other bug to prioritize is CVE-2018-8120, a vulnerability in older Windows OS versions … Read More
I recently shared details about the retirement of HomeGroup from the Windows 10 April 2018 Update. This feature update was made available for download last week; as of this month’s Patch Tuesday, the update is now beginning its rollout through Windows Update. Microsoft had given users a heads up about the removal of HomeGroup from this fifth feature update for Windows 10 which is why we knew that was coming. When they began the availability of the update to the public last week that triggered the publication of the complete list of features that were either removed or planned for removal/replacement in this update. On the page listing these changes for the feature update there is a caveat from Microsoft which states: This list is subject to change and might not include every affected feature or functionality This article is part of our premium content. Join Now.Already a paid subscriber? Click here to login.
You can narrow, expand, and otherwise fine-tune your searches in Outlook. If you use Microsoft Outlook, you’ve probably tapped into the regular search feature in which you type a keyword or phrase in the search field and then wait for matching emails to appear. But there’s much more to searching in Outlook than meets the eye. In this article, you’ll master the following skills: Search just your current mailbox or all mailboxes as well as your current folder or all folders. Limit the search to just recent items or include older items as well. Look for messages based on sender, recipient, date, attachment, status, body text, and more. You can easily access recent searches. You can search your calendar and contacts separately or along with email messages. Modify the default settings for searching. I’m using Outlook 2016 via my Office 365 subscription. But most of the features and options I discuss here should work in the prior couple of versions of Outlook. To start, open Outlook. If you’re like me, you may have thousands of messages scattered throughout a host of folders. You may even maintain more than one account or mailbox in Outlook. To run a basic search, type … Read More
In last weeks’ newsletters (Tuesday and Thursday), we took a closer look at some of the new features of what we called the Productivity Update, i.e. the Windows 10 April 2018 Update aka Windows 10 Version 1803 (OS Build 17134.1). Note: If you are interested in seeing more about some of the enterprise/business related features in this update you can check out the review we posted at ITPro Today last week. This week, we are going to review the various methods for upgrading or clean installing your current Windows 10 installation to this fifth feature update for the operating system. Windows Update (Automatic) When Microsoft begins an automatic roll out of an update like this, they usually begin with known hardware configurations. That means targeting hardware such as first-party Surface devices, some of their OEM partners’ machines, or newer machines that are more likely to be compatible with the update to Windows 10. This article is part of our premium content. Join Now.Already a paid subscriber? Click here to login.
You likely depend on your Microsoft account so you want to make sure it’s safe and secure. You probably use your Microsoft Account for a variety of tasks. You may use it to sign into your Windows 10 PCs and other devices. You might use it to access Microsoft Office, Skype, and other Microsoft products and subscriptions. You can use it to sign into various Microsoft services such as Xbox Live. And you may use it to establish your payment options with Microsoft. For all those reasons and more, you want to make sure your Microsoft Account credentials don’t fall into the wrong hands. How can you secure and protect your account? We will walk you through these security fundamentals: First, you need to ensure that you’re using a strong and complex password. (Make sure it’s not one of these.) Then you can secure your account and verify your identity by using backup email addresses or a phone number and a code sent via text message. You can set up two-factor authentication to further protect your account. And you can verify your identity on your mobile phone via the Microsoft Authenticator app. I’ll assume you already have a Microsoft Account to … Read More