Many people when they see Windows 10, they only see the new features and visual changes. For sure, they notice the new Start menu, Cortana, the Action Center, apps, including the new Settings app. However, many users fail to see that Windows 10 brings a lot of changes and improvements under-the-hood as well.
One of the new features in Office 2016 is “Ink Equation”. This feature allows you to insert equations into Word, Excel, and PowerPoint by handwriting them. Ink Equation is designed to be used with a tablet pen on a tablet PC. However, you can use Ink Equation with other input devices, including a mouse, and we’ll show you how to use Ink Equation with a mouse to insert an equation into Word.
Bringing up Windows Task Manager is not much of a task itself, but when a virus disables Ctrl+Alt+Del and takes it hostage, how else are you going to open task manager? Or maybe you’re just looking for some diversity in your life, so here are 6 different ways to open Windows Task Manager. Readers will probably be most familiar with the three-finger salute (AKA Ctrl+Alt+Del).
Microsoft wants Office 2016 to be the last office productivity suite you will ever need. Here are 10 things you should know about how it plans to make that happen. For years we've been promised wonderful benefits from cloud computing, and Microsoft Office 2016 is trying to deliver on those promises. It's designed to meet our expectations of what a cloud-based, mobile-ready productivity suite can and should be. Only time will tell if Office 2016 actually delivers the goods, but the initial reviews are promising.
You might have heard about remote desktop connections, either at work, from your network admin or just from a friend who is rather geeky and knowledgeable about computers and networks. If you don't know what remote desktop connections are, then this article is for you. After receiving a number of questions regarding the purpose and usefulness of remote desktop connections, we've come to the conclusion that it would be a good idea if we explained you a few basic things about what they are, and how they can make your life easier in certain situations.
In previous articles, I explained that the Ribbon toolbar system with its Core and Contextual tabs is designed to expose close to 200 different file management commands in File Explorer. One of these commands that I want to tout, as I wrap up this series on File Explorer, is the Filter feature. While the Filter feature is not actually a command on the Ribbon, it is a very useful tool to have in your arsenal.
Windows 10 allows its built-in apps and Universal apps downloaded from the store to run in the background by default. This can be handy if you want to get notifications from apps like Twitter or News. And it lets the apps update in the background, too. However, there are also certain disadvantages to this. If you’re on a laptop or other Windows 10 device like a Microsoft Surface, you might want to disable them from running to save battery juice.
If creating a website for your business is on the horizon, you may be wondering which content management system (CMS) is the best choice for you. Here’s a look at three of the most widely-used ones. All three are open-source software, each developed and maintained by a community of thousands. Not only are all three free to download and use, but the open-source format means that the platform is continuously being improved to support new Internet technologies. With all of these systems, basic functions can be enhanced ad infinitum with an ever-expanding array of add-ons, contributed from their respective communities.
Every website owner, before ordering a website, faces a dilemma: whether to use a professional developer’s services or try one of the ready-made solutions that content management systems offer. It’s a fight between web developers and ready-made website builders: who offers a more comfortable option for creating a fully-functional website that is easy to manage, customize and that looks great on any device?
To prove this, I’ll demonstrate building a game from scratch using Web technologies and just two external libraries, and I’ll do it in less than one hour. I’ll cover a variety of game development topics, from basic design and layout, controls and sprites, to artificial intelligence (AI) for a simple opponent. I’m even going to develop the game so it works on PCs, tablets and smartphones. If you have some experience with programming as a Web developer or another development domain, but no experience writing games, this article will get you started. If you give me one hour, I promise to show you the ropes.
If you have your Windows 10 computer set up to sync files with a network server, Windows 10 Sync Center will allow you to check the results of your recent sync activity. Its a tool for giving you access to copies of your network files even when your computer isn’t connected to the network. Sync Center allows you to keep information in sync between your computer and Files stored in folders on network servers.
With Power BI Desktop, you can easily import Excel workbooks that contain Power Query queries, Power Pivot models and Power View worksheets into Power BI Desktop. Reports and visualizations are automatically created based on the Excel workbook, and once imported, you can continue to improve and refine those reports using Power BI Desktop, using the existing features and new features released with each Power BI Desktop monthly update.
Ever need to drill down into your Pivot Table to look at the details behind your summary calculations? Simple stuff with the double click of a mouse and Excel will display all of the details behind the summary on a brand new worksheet. Let’s look at an example. The Sales of Widget_A have outsold Year to date in 2013 than any other type of Widget.
The XLS workbook format is often referred to as the Excel 97-2003 workbook format, and for good reason. Those versions of Excel supported spreadsheets with 65,636 rows and 256 columns. Modern workbook formats, such as XLSX allow over one million rows and roughly sixteen-thousand columns. However, you may not realize the depths of frustration that XLS workbooks can cause because the other side effects are subtle. First off, starting with Excel 2007 the Compatibility Checker prompt sometimes appears when you save XLS workbooks..
Excel is really cool when it comes to automatically filling in cells in columns or rows with weekdays, months etc etc…so when you type in the first couple of items in the list, then drag the fill handle, Excel then does the hard work for you. So, are you resticted to having the in built lists that Microsoft has so kindly set for us?.
I had 20 budget files open and I used the previous trick to close all workbooks. I used shift-click on Don’t Save to close all without saving. But then I realized that I also had another file opened that I needed to save. If you are in Excel 2010, you might be able to recover that file. You have to meet all of these criteria...
The lookup table is maintained by another department. They built it with the price to the left of the item number. Can I specify -1 as the third term of the VLOOKUP to indicate that I want a value to the left of the key field? Unfortunately, the Excel team doesn’t offer the ability to VLOOKUP to the left of the key field. However, you can use MATCH to figure out which price to use.
The concept of parameter tables in Power Query will be familiar to some and new to others. A parameter table is a way that you can “pass” values to Power Query (and also Power Pivot) and these values can then be used in your queries and/or the data model. I came across a problem when I needed to develop a Power Query workbook on my local PC, but then share the workbook with another user.
In Windows 10, there are several ways to manage startup apps. In this article, we will see the fastest one. I will also show you how to create a special shortcut to open Startup management options directly with one click. The more apps you install on your computer, the longer it will take to start up Windows.
Since Windows 8, Microsoft has been actively working to adapt the user interface of the operating system to suit touch screens. New apps, new options and lots of UI changes are making it more usable on devices with a touchscreen. Desktop users are still using the traditional keyboard and mouse. For them, keyboard shortcuts are the most useful and fast way to perform daily tasks since the mouse requires lots of scrolling for UIs that are designed with touch in mind.