Numbers make the world go round. Excel’s become indispensable for crunching numbers – so why not make the most of the application? This is part two of our collection on mastering Microsoft’s flagship spreadsheet program. (Part one is here.) Email subscribers will have the full text of all these articles: Avoid Copy and Paste Problems in Microsoft Excel Use Templates to Enhance Your Excel Spreadsheets”}”>Use Templates to Enhance Your Excel Spreadsheets How to Use Multiple Worksheets in a Microsoft Excel Workbook How to Work with Large Spreadsheets in Microsoft Excel We’re taking a quick summer break and will be back with new content on Tuesday, June 12, 2018.
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.
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.
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.
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.
Welcome back to our examination of the Windows 10 April 2018 Update (also be known under its official name of Windows 10 Version 1803 (OS Build 17134.1). In part one of the review, I suggested it be called the Productivity Update. I’ll keep calling it that in this examination of some other highly useful features: Cortana, Startup Apps Control, Accessibility, Microsoft Edge and Security. Cortana Cortana has received a slight makeover with new information cards for both her Notebook and Skills areas when you click on the Cortana icon on the Windows 10 Taskbar. This makes these settings faster to access because they are just one level away when you open Cortana. There is also an edit icon next to your name so that you can adjust the Places which Cortana knows about such as Home and Work. This article is part of our premium content. Join Now.Already a paid subscriber? Click here to login.
Now that it’s been released to the public, it’s time to take a closer look at the fifth major feature update to Microsoft’s latest operating system. This feature update has been in development since July 2017 and there have been 27 public development builds released to testers over that nearly nine-month period. Microsoft never formally named this feature update like they have done in the past with monikers like Anniversary, Creators, and Fall Creators Update. Instead, they have chosen to simply call it the Windows 10 April 2018 Update. It will also be known under its official name of Windows 10 Version 1803 (OS Build 17134.1). If I were providing suggestions for naming this feature update, then I would recommend calling it the Productivity Update. The key additional features in this package of updates really can help you be more productive. This release makes significant changes in how you access the data across your ecosystem of Windows 10 based devices. This article is part of our premium content. Join Now.Already a paid subscriber? Click here to login.
Q. Is HomeGroup Really Leaving Windows 10? I can confirm that this is, in fact, happening. It’s been happening for a while: Microsoft notified testers during the Redstone 4 feature update development cycle when they released Build 17063 in December of last year. You must scroll almost all the way to the bottom of those very lengthy release notes to find the details about HomeGroup’s retirement under the Other notable changes section. I know many of you are still on Windows 7, which means you may also be using the HomeGroup features on your home network. (In fact, HomeGroup was introduced as part of Windows 7 when it was released to general availability in October 2009.) In those ensuing eight and a half years, technology has come along that really eliminates the need for HomeGroup as it was originally devised. When parallel services can adequately replace the feature in Windows 10, then it makes sense for the Redmond company to stop supporting that part of the code base. This article is part of our premium content. Join Now.Already a paid subscriber? Click here to login.
Last year during Microsoft Ignite in Orlando, I sat in on a presentation about a new collaborative tool for the Windows 10 desktop called Microsoft Whiteboard. Microsoft already had a collaboration tool for its Surface Hub line of devices; the idea behind this new app was to bring that level of group creativity from the conference room to the desktops, laptops, and tablets running Windows 10. In December of last year, the Microsoft Whiteboard App preview was released in the Microsoft Store. Since then it has been updated multiple times and continues to become more robust through bug fixes, performance enhancements, and feature additions. The app is reliable enough after five months of availability for daily use. So why not try it? Get started by downloading it from the Microsoft Store and then opening the app for the first time so it can be associated with your Microsoft Account. This article is part of our premium content. Join Now.Already a paid subscriber? Click here to login.