There’s more to Office 365 than just Word, Excel, and PowerPoint. You may have a subscription to Office 365 mostly to gain access to Word, Excel, and possibly PowerPoint. But there’s a lot more to an Office 365 plan than just the core Microsoft programs: You can use Office 365 to store and sync files on a hefty 1TB of OneDrive space. You can use Skype to make and receive phone calls and text messages in more than 60 countries with 60 free minutes each month. You can access your calendar and contacts. You can store up to 50GB of messages and file attachments in the online version of Outlook. And you can use most of these features and apps on a mobile device. Let’s go over some best practices for getting the most out of your Office 365 subscription. Choose Your Office 365 Subscription This article is part of our premium content. Join Now.Already a paid subscriber? Click here to login.
You can use Microsoft Word with Google Docs to create and collaborate on documents. You’ve always used Microsoft Word to create your own documents. But now you work with or for other people who use Google Docs. Do you need to renounce Word and adopt Google Docs to take on these new projects? Nope, you can tag team both applications. The two actually play well together. Here’s how: You can create your documents in Word and upload them to Google Drive. You can then view, read, and edit your Word docs in Google Docs to make further changes. You can easily share documents with other people. Google Docs offers its own version of Track Changes so you can see the modifications each person makes to your documents. And you can save a Google Docs file as a Word document, among other formats. First, you’ll need to create a Google account if you don’t already have one. Your Google account provides access to Google Docs and Google Drive, both of which you’ll use to upload, edit, and share documents. Browse to the Google Accounts page to set up your account. Next, segue to Microsoft Word. You can use any version of Word for … Read More
Here’s a look at the sleeker, thinner Ribbon slated for all Office applications. Microsoft has given us a taste of the future of Office through the online version of Word. Check out Word Online and you should notice that the Ribbon has gone on a diet. To cut down on the clutter, Microsoft has transformed the traditional big, bulky Ribbon that sports every command available into a more compact flavor where you need to dig around to find certain commands. For now, only Word Online sports the new Ribbon. But it’s destined for the other Office Online programs as well as the full Office 365 and Office 2019 suites. The new Ribbon isn’t difficult to use (in many ways it’s easier). But it may take time to adjust to it and learn where all the necessary commands are hiding. Let’s check out the new Ribbon so you’re prepared once it hits Office en masse. Fire up Office Online through your favorite browser. Sign in with your Microsoft Account if requested. Click on the icon for Word. Open an existing document from OneDrive or select a template so you have some content to play with. This article is part of our … Read More
Printing in Excel doesn’t have to be problematic. You’ve created a long or intricate Excel spreadsheet. And you’ve just sent it to your printer. But when you check the pages coming out of the printer, you see that the spreadsheet didn’t print right. Whatever went wrong, you can avoid many printing problems in Excel by following the right steps. You can ensure that your spreadsheet prints in the right orientation, takes up the right number of pages, and doesn’t get cut off at the wrong spots. Let’s check out how. I’m using Excel 2016 for these steps, but the basic features and options for printing should be the same across the previous couple of versions. If you want to try this out on your end, launch Excel and create or open a large spreadsheet. If not, just follow along. Set Paper Size and Orientation. Before you print, you should set up your page options. The first step is to confirm or change your paper size. Click on the Page Layout tab and click on the Paper Size button. You can choose Letter, Legal, and other sizes. Letter or legal are the most common choices in the US. But if you’re … Read More
The right type of image or illustration can give your document more oomph. You’re creating a Word document with just plain text. And it looks kind of blah. One way to enhance a document is with the right type of visuals. But instead of just using the same old clip art and standard images, you can truly spice up and illustrate your document with shapes, icons, and models. With shapes, you create lines, squares, arrows, callouts, and other objects to call attention to or highlight text in your document. With icons, you can include drawings of people, faces, and places to better explain or even replace certain text. And with 3D models, you can make your documents pop off the screen or page with three-dimensional images that you can grab online or create yourself. Let’s check out how to spice up your Word documents with the right shapes, icons, and models. For this article I’m using Word 2016 as usual. You should be able to access most of these features in the past couple of versions of Word. However, 3D models work only in Office 2016 and Office 365. This article is part of our premium content. Join Now.Already a … Read More
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.
Having difficulty getting Office 365 to behave? These tips and tricks can help. You use or are trying to use Microsoft Office 365 but are running into problems with it. Maybe it’s not activating properly. Perhaps it’s installed and activated, but a specific program such as Outlook isn’t working right. What can you do? One option for activation issues is to run a tool called the Activation Troubleshooter. For those issues and other problems, you can always try to run a repair or reinstall of Office 365. Another move to use a free program from Microsoft named Microsoft Support and Recovery Assistant for Office 365. Also known as SaRA, the Support and Recovery Assistant runs a series of tests to look for glitches and maladies in Office 365. If it finds something amiss, the program can try to fix the issue or tell you how to fix it yourself. The one limitation with SaRA is that it works only with accounts that use Office 365 on the backend, such as Office 365 for Business or Education. Office 365 for Home and Outlook.com aren’t supported. If you use Gmail, Yahoo Mail, your ISP’s email, or some other service on the backend, … Read More
Columns can be challenging, but you can master them with the right techniques. You’re creating a Microsoft Word document that you think may work better if formatted into columns. Fine, but columns can be tricky. You have to decide how many columns to use and how and where to apply them. And columns can often run amuck by breaking at the wrong places, not continuing correctly to the next page, or not stopping where you want them to stop. You often have to play around with the columns to coax them to come out right. Believe it or not. columns can be easier. If you know how to create and customize your columns, you should be able to get them to work and look the way you want. Why even fuss with columns? You may be creating a newsletter or brochure in Word and need to format your document in columns for printing. You may be writing a report that has to adhere to a column format. But even a regular document formatted in columns can be more inviting and easier to read than one in which the text stretches across the entire width of the page. The steps I … Read More
These tips and tricks can help you more easily handle a huuuuuge spreadsheet. You’ve created an Excel spreadsheet that stretches beyond what you can see on the screen, maybe one that encompasses hundreds of rows or columns. And now working with and navigating that spreadsheet has become slow and clumsy. Do you need to pare down your spreadsheet? Nope, don’t change it. Instead, you can tap into various tools and features in Excel to use and move around your big spreadsheet. Here’s what you can do: Certain keyboard shortcuts can hop around your spreadsheet in the blink of an eye. You can also name cells or ranges of cells to move to them by name. You can filter the data in a row to see only certain content. You can freeze specific rows and columns, such as header rows, so they’re always visible. And you can split your spreadsheet to see more than one area. Let’s check out the different ways to work with large Excel spreadsheets. I’m using Excel 2016 for the examples here, but you should be able to apply the same tricks in the past couple of versions of the program. To start, load Excel and create … Read More