You can more easily organize and view data in Excel by sorting and filtering it. You may use Excel to keep track of lists and other information, maybe people, products, expenses, bills, taxes, and more. But sometimes you need a way to sort and filter all the data in each spreadsheet so you can better arrange what you view or just peek at specific records. And that’s exactly what Excel offers: You can sort the data in each column alphabetically or numerically, from smallest to largest or largest to smallest. You can even add multiple levels to sort the data in more than one way. If sorting doesn’t quite do the trick, you can filter the data. Filtering adds a dropdown menu to each column so that you can choose which data you want to see: You can choose to see data equal to, greater than, or less than a certain value. You can opt to see only records with blank fields. And you can adopt custom filters. But figuring out how to use sorting and filtering properly can be a challenge unless you know your way around both features. Let’s look at the many ways to sort and filter … Read More
You can do a lot more in Excel than just add up numbers. Excel is designed to help you create formulas to perform a variety of different calculations and tasks. But formulas can be intimidating. You probably already know how to auto sum numbers and handle basic calculations. But there’s more to formulas than just the basics. Here’s what you can do with them. You can multiply, subtract, divide, and average numbers. You can see the minimum and maximum numbers in a column or row. You can include different types of calculations in a single formula. You can also use absolute cell references in your formulas to keep certain numbers constant. Let’s look at how to work with formulas in Excel. I’m using Excel 2016 as my test subject, but the steps I describe here apply equally to the previous few versions of the program. This article is part of our premium content. Join Now.Already a paid subscriber? Click here to login.
How often do you receive an email in your Outlook inbox only to decide that you’ll deal with it another time? And how often do you forget to return to that email? Yep, that’s not unusual. Many of us get so much email that we often leave our inboxes filled to the brim with messages that go unattended and unanswered. There must be a way to categorize and flag certain emails so they remain on your radar. And there is, if you’re using Outlook. Microsoft’s desktop email program offers different ways to handle an email that you don’t want to face right away but still need to keep alive. You can tag a message with a name and color category so you can easily spot it and know how to respond to it. You can flag a follow-up to an email to nudge you to look at it on a specific day. And you can set a reminder on a message so you’re alerted about it at a specific date and time. The goal of these actions is to highlight important emails in some way so your attention is drawn or redrawn to them. Let’s check out how to set … Read More
You can squeeze a lot out of Google Chrome by tweaking its various features and settings. Microsoft wants you to use its Edge browser in Windows 10 as the replacement for Internet Explorer. But instead of using a Microsoft browser, you have another option, namely Google Chrome. From its third-place status a few years ago, Chrome has risen to become the most popular and dominant browser in Windows. And it’s no wonder. Chrome offers a clean, mean look and performance. But there’s more to Chrome than meets the eye. To get the most out of Chrome, you’ll want to tweak its array of features and settings. You can import and manage your bookmarks. You can control your privacy and security. You can sync your passwords and history across different devices. You can add more functionality through extensions. And you can install web apps and games to work and play with in Chrome. Let’s look at how to use and customize Google Chrome. If you don’t already have Chrome, open your current browser and download it from its Google page. After the installation complete, you’re asked if you want to make Chrome your default browser. You can choose to do that … Read More
You can often best proofread your documents by hearing them spoken. You try your best to proofread your Microsoft Word documents, even tapping into the Grammar and Spelling checker to look for typos or other mistakes. But mistakes invariably sneak through. What is a good way to move beyond reading and re-reading? One handy trick is by hearing your document read aloud to you. Hearing a document often catches mistakes that the eye misses. And if you’re writing an article, a paper, a speech, or another document that needs to be just right, listening to that document can help you better refine and revise it. To hear your documents read aloud, you can call on the built-in Windows Text-to-Speech (TTS) feature. This feature lets you change the voice, control the volume, and select what you want to hear. Open a document in Microsoft Word that you want to hear read aloud. Click on the Review tab to display the Review Ribbon. Position your cursor at the top of your document or a specific spot where you want the speech to start. Click on the Read Aloud icon on the Ribbon. The Speech feature begins reading your document aloud, highlight each … Read More
Why type when you can speak? You can click on commands and type text in Microsoft Office, Microsoft Edge, and other Windows applications. Or you can speak what you want. Speech recognition can be especially helpful for people who can’t use the keyboard or mouse. But it’s available to anyone who’d like to try talking to Windows instead of typing and mousing. Windows offers its own Speech Recognition tool through which you can dictate text and speak commands in different applications. The Windows 10 Fall Creators Update expands on the voice recognition by allowing you to more easily dictate text in your Office applications and other programs. And you can always ask Cortana to run a variety of commands and tasks. But there’s more to voice dictation than just talking to Windows. You have to train your voice to ensure that the dictation is as accurate as possible. And you must know what you can say and what you can’t say. Let’s look at how to dictate your text and commands to Windows. Whether you’re running Windows 10, Windows 8.1, or Windows 7, you can tap into the built-in Speech Recognition feature. To access this, open Control Panel in icon … Read More
By now you know what Trello can do for you when it comes to organization and project management, and you’ve learned the basics of setting up Trello for your own personal needs. You’ve also read an overview of Trello for teams, including how the application can facilitate better communication and collaboration. You can use Trello well, even effectively, with just that information. But to really become a Trello power user you’ll want to step up your game with keyboard shortcuts, application tie-ins, and automation. Here are the tips and tricks you need to know to upgrade Trello from convenient to life changing. Learn the Keyboard Shortcuts There are a variety of keyboard shortcuts that can be used within Trello to save you time and clicks. “Trello’s system can have a learning curve for new users,” says Brad M. Shaw, president/CEO of Dallas Web Design Inc. Learning keyboard shortcuts changed this for him, and therefore changed his relationship with the app. “Doing simple things like using the space bar to assign the card to yourself, pressing D to open the due date menu and L to add a label saves valuable time,” Shaw says. Here are some of the most valuable … Read More
Trello can be a powerful project management tool for your teams, if you use it effectively and implement it properly As we discussed in “How to Get Started With Trello,” the project management application functions well as a tool for personal planning. But one of the main advantages of Trello for organization is that it has several features designed to make teamwork convenient, collaborative, and easily tracked. Everything that an individual user can do in Trello can also be done on boards that have multiple members because they are part of a designated team: create lists and cards; move around or archive inactive lists or cards; link files, photos, and websites; set due dates and assign tasks via a checklist; and add comments to cards. A team also allows its users to view all associated boards and their members in one place. Team members can be designated as admins, or as regular members; with a business-class Trello account, team admins have admin control over any board in a team whether or not they’ve been invited to a particular board by its admins. This article is part of our premium content. Join Now.Already a paid subscriber? Click here to login.
When there are so many productivity and organization applications available, it can be hard to know which one is the right choice–especially when all of these apps do not necessarily play well with each other, or work across platforms. Fortunately, one of the best–and most versatile–productivity apps is available for Windows and Mac users, on Android and iOS, and for desktop and mobile devices. But while this cross-platform fluidity is an important part of Trello’s appeal, the real secret of its success comes in the way it mimics a very low-tech organizational method: index cards on a corkboard. What Is Trello? Essentially, Trello is an online corkboard. You create boards, which contain lists, which hold individual cards. The user gets a visual view of their projects or information, with the ability to easily add cards and lists and move them around as necessary. Your boards can be private, or you can invite other Trello users to see and collaborate on them–handy for group projects or other situations where you need to share information. Project management is the primary function of Trello, and it does that well, but the app is versatile and intuitive enough to be also be used in … Read More