OFFICE ARTICLES / MICROSOFT OFFICE, GOOGLE DOCS, AND MORE
Even if you’re familiar with Microsoft Word, you might be surprised by the number and variety of keyboard shortcuts you can use to speed up your work, and just generally make things more convenient.
If you don’t want to show decimal values in Excel, you can simplify your numerical data using the ROUND functions. Excel offers three functions: ROUND, ROUNDUP, and ROUNDDOWN. Let’s take a look at how they work.
Microsoft Word lets you easily create and format multilevel lists in your documents. You can choose from a variety of formatting options, including bulleted, numbered, or alphabetized lists. Let’s take a look.
Templates let you configure all the relevant settings you want pre-applied to documents—page layout, styles, formatting, tabs, boilerplate text, and so on. You can then easily create a new document based on that template.
You may not think of Word as a tool for designing web pages, and that’s okay—it’s really not very good at it, anyway. But, if you have an existing Word document that you need to turn into a web page for whatever reason, Word has you covered with some built-in tools.
You can remove or make changes to headers or footers on any page in Microsoft Word. This is handy if, for example, you want to hide the header or footer on a specific page. The process is a bit different if you want to delete a header or footer on the first page of your document or on any other pages. Here’s how it works.
If you use Microsoft Outlook, and want to set it up with your Gmail address, you’re in luck. Newer versions of Outlook make this easier than ever. You’ll need to enable a couple of settings on the Gmail website, and then connect to your Gmail account in Outlook. Let’s take a look.
Adding hyperlinks to your Word document is an easy way to give your readers quick access to information on the web or in another part of a document without having to include that content right on the page. Let’s look at how to insert, manage, and delete different kinds of hyperlinks in your Word documents.
There are several different methods for selecting a block of cells in Excel, or extending an existing selection with more cells. Let’s take a look at them.
Sometimes, you need to stick a landscape oriented page in the middle of a portrait-oriented Word document—a spreadsheet, graph, or wide image, maybe. Here’s how to do that, and how to keep your page numbering intact when you do.
Office 2016 is the latest version of Microsoft Office for both Windows PCs and Macs. If you subscribe to Office 365, you’ll always receive updates to the latest version of Office. If you buy a traditional single system license, you have to purchase each new version to receive it.
PDFs are handy for distributing documents so that they’re seen the same way by all parties. Typically, you’ll create documents using another app, and then convert them to PDF. Here’s how to do it for a Microsoft Word document.
There was a time when you had to have Microsoft Office installed to create, edit, or even view a Microsoft Word document. Thankfully, that’s no longer the case. There are a number of free alternatives for working with those Word documents people occasionally send you.
You’re probably familiar with the basics of Google Sheets, but Google’s spreadsheet offering boasts loads of features that aren’t obvious at first glance. Here are some of our favorites.
Office 2019 launches this year, but Office 365 Pro Plus users shouldn’t expect a bunch of new features.
For reasons I cannot fully understand, I decided to use Outlook on my Mac. That’s when I discovered that Outlook was making me click “Download Pictures” on every single email, which is really annoying. Here’s how to make Outlook download the stupid pictures automatically.
If you use Excel spreadsheets to collect data from other people, but find that they often fill your carefully-planned cells with the wrong kind of information, data validation can help.
Windows offers a setting named Dark Mode that applies a dark theme to apps you get from the Windows Store. It doesn’t affect most desktop apps, or tools like File Explorer, but we’ve got some other solutions for those. Here’s how to get your whole desktop (or as much as possible) looking dark.
Odds are pretty good that you create the same types of Excel spreadsheets over and over again. Creating a custom template can help make that process a lot smoother.
Excel spreadsheets can be hard to read at a glance, thanks to dense information and the grid formatting. Spending a little time on your spreadsheet to make it easier to read is a solid plus, starting with the borders around different cells.
Macros are basic bits of programming that let you hit a quick button or keyboard shortcut to trigger a pre-recorded action. Here’s how to make easy ones in Word.
When you create multiple columns in Word, they default to a set width. It’s easy to change that default width for each column. Let’s look at two ways you can do that.
Like peanut butter and chocolate, a word processor with some basic spreadsheet chops makes a fantastic combination. When you want some rather easy number-crunching embedded in an otherwise ordinary text document, Microsoft Word has you covered, thanks to baked-in functionality from its sister program Excel.
LibreOffice Writer can handle some of the very basic tools that are part of Calc (the LibreOffice version of Microsoft Excel) with its Table function. For example, to sum up the contents of multiple cells and place the total in a new cell, you use the exact same formula, “=sum<[cellstart]:[cellfinish]>.
If you’re using the free and open source LibreOffice suite of programs, your word processor is probably way more powerful than it needs to be. Writer has at least as many standard features as the paid Microsoft Word, and getting more acquainted with some of them can help dramatically streamline your workflow. In other words, spend a little time setting stuff up and you’ll fly through your documents like a 60WPM Superman.
