Our latest articles...
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.
Recent top stories
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.
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. Xbox Adaptive Controller (Via Microsoft) This device works with the Xbox One console and Windows 10 PCs to create a custom set of controls which will allow gamers with various accessibility challenges to enjoy gaming once again or discover it for the first time. The device itself has programmable buttons but it also can be connected to external devices such as joysticks, mounts, buttons, and other switches that enable a gamer with limited … Read More
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 Many people find themselves feeling overwhelmed with emails. Inbox Zero is a great goal, but it seems like an impossible dream much of the time. Automating your inbox is one way to stay on top of your emails, and it’s surprisingly useful. … 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 In other words, this list might or might not be complete. It also might change at some point. Based on my past experience with these things, I can say that the list rarely changes. Let’s run down this list. We begin with items that have been removed: Groove Music Pass: Microsoft canceled this feature late last year and handed the reigns over to … 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. Older hardware will come later in the process. Microsoft monitors these early stages of the rollout very closely. When an issue is detected either through their telemetry or they begin to see a trend in the Feedback Hub with certain devices they will put a block in … Read More
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. The Cortana Show Me App is new to the Redstone 4 feature update and will show you how to accomplish various tasks on Windows 10. This app shows and talks you through those processes using your system so that once you reach the point you’re ready to take over it will be right there on the screen ready for you. The collection of walkthroughs is limited at … Read More