Author Archives: Lance Whitney
Your Word Tables can look better if you know how to properly format them. You probably already know how to create tables in Microsoft Word. But formatting them is another matter. Formatting a table not only gives it the right look but can also make it easier to use. Maybe you’ve struggled with table formatting in the past, or perhaps you’d just like to learn all the different ways you can format a table. Your options abound in Word. You can create a table with a certain layout. You can apply border styles either to the whole table or to individual rows or columns. And you can give your table a snazzy new look by selecting an entire table style. Let’s go over the process for formatting tables in Microsoft Word. As always, I’m using Word 2016 through my Office 365 subscription. But the process for formatting tables is similar across the past few versions of Word. Let’s start by launching Word with a blank new document. Click on the Insert ribbon and then click on the Table button. Word offers three ways to create a table. You can insert a table by moving your mouse cursor over a specific … Read More
You can automate a host of time-consuming tasks via macros. Do you find yourself running the same laborious and repetitive commands and tasks in Microsoft Word or Excel? There must be a better way, you say to yourself. And there is, with macros. Through a macro, you can record or create a series of commands and tasks in a Microsoft Office application. Then, whenever you want to run those commands, you just trigger the macro. You can create macros to automate just about anything in a program like Word or Excel — apply special formatting, change the layout, insert objects. Macros can sound intimidating if you’ve never ventured into their territory. They’re stored as mini programs using the Visual Basic for Applications (VBA) language. But you don’t need to be a programmer to use macros. You can record the macro by performing the various commands step by step. You can then edit the macro to make any changes. Let’s check out how to use macros to save time in Microsoft Office. This article is part of our premium content. Join Now.Already a paid subscriber? Click here to login.
Your emails can look more appealing with the right themes and stationery. Do your messages from Microsoft Outlook look dull? Maybe you’re trying to promote a product or service in your emails or you just want to wow recipients with a certain style to your emails. And your regular messages just seem blah, at least visually. Can you spruce them up? Sure, you can format each email individually with specific fonts, colors, and other attributes. You can tap into styles to touch up your emails. Or you can rely on themes and stationery. Through themes, you can paint your emails with a specific visual style. You can choose from the built-in themes and create your own themes. Using themes and stationery, you can set up your messages with specific fonts, colors, backgrounds, and other elements. You can choose to apply your stationery to selected individual messages or to all new HTML emails you compose. Let’s see how you can spruce up your Outlook messages with themes and stationery. For this article, I’m using Outlook 2016 via Office 365, but the process for using themes and stationery is similar in the prior few versions of Outlook. This article is part of … Read More
You can enhance your PowerPoint presentations through the power of add-ins. Looking for a way to jazz up your PowerPoint presentations? Microsoft can lead the way, through add-ins. An add-in enhances your Office documents and presentations by giving you more power and flexibility over them. The right add-ins for PowerPoint can ease the process of creating your presentations and lead to more effective demonstrations and slide shows: Free Picture Finder can track down royalty-free photographs that you can use in your presentations. Pickit Free Images finds free and legally-cleared stock photos, icons, and illustrations to perk up your presentations. Handy Calculator conveniently displays a calculator next to your presentation. OfficeMaps can insert maps of specific countries, cities, and other locales. Khan Content from Microsoft lets you add free videos and exercises from training site Khan Academy. And PowerPoint Training and Tips provides tips and tricks for using PowerPoint. Let’s check out these useful and free add-ins for PowerPoint. Note: Most add-ins work with PowerPoint 2016 and 2013 but not with older versions such as PowerPoint 2010 or 2007. Some add-ins also support the free online version of PowerPoint and PowerPoint for the iPad. You can browse and search for an … Read More
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.
Is that missing Word document gone for good or is there a way to recover it? Let’s find out. Uh, oh. That Word document you spent the past few hours writing has mysteriously vanished. Do you have to start it from scratch? Not necessarily. Your Word documents can sometimes go kerflooey, either disappearing completely or losing the latest changes. Those scenarios can occur if a document crashes or freezes or just doesn’t save properly. That recently happened to me even though I had been saving a now-lost document regularly. So how can you find the document? You have a few options. You can scour the Recycle Bin. Depending on your settings in Word, you may be able to dig up a backup or an AutoRecovered version of your document. If those searches come up empty, you can look for temp files and files with the tilde (~) character. Let’s check out the different ways to recover a lost Word document. As always, I’m using Word 2016 via my Office 365 subscription, but the steps I cover here work with the prior few versions of Word as well. Let’s start by assuming that you’d been working on a document and now … Read More
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 automate a host of time-consuming tasks via macros. Do you find yourself running the same laborious and repetitive commands and tasks in Microsoft Word or Excel? There must be a better way, you say to yourself. And there is: With macros. Through a macro, you can record or create a series of commands and tasks in a Microsoft Office application. Then, whenever you want to run those commands, you just trigger the macro. You can create macros to automate just about anything in a program like Word or Excel — apply special formatting, change the layout, insert objects. Macros can sound intimidating if you’ve never ventured into their territory. They’re stored as mini programs using the Visual Basic for Applications (VBA) language. But you don’t need to be a programmer to use macros. You can record the macro by performing the various commands step by step. You can then edit the macro to make any changes. Let’s check out how to use macros to save time in Microsoft Office. Macros are available in Word, Excel, and PowerPoint. The process for creating a macro is the same across all three applications. So once you master macros in one program, … 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