A lot of the tasks you’ll complete in Microsoft Excel are tedious. Luckily, Excel has several features that make this kind of spreadsheet work bearable. We’ll look at two of them: Flash Fill and Auto Fill….
Creating a chart in Excel is neither easy nor intuitive for inexperienced users. Luckily, there’s a feature called Quick Analysis that can create charts, tables, and more with just a click.
Pivot Tables are both incredibly simple and increasingly complex as you learn to master them. They’re great at sorting data and making it easier to understand, and even a complete Excel novice can find value in using them….
Slideshows are an intuitive way to share complex ideas with an audience, although they’re dull and frustrating when poorly executed. Here are some tips to make your Microsoft PowerPoint presentations sing while avoiding commo…
If you start an Excel workbook by grouping data into the same cell and later decide to ungroup it, Excel has several easy functions that can split one spreadsheet column into two. Here’s how to use both “Text to Columns” and …
If you started to enter data in a vertical arrangement (columns) and then decided it would be better in a horizontal one (rows), Excel has you covered. We’ll look at three ways to transpose data in Excel….
There are multiple ways to add line breaks in Excel, though none of them are obvious solutions. As with most problems in Excel, there are actually multiple ways to accomplish this. We’ll look at three different ways to add li…
Microsoft Excel becomes a powerhouse once you get into its expansive list of sorting options. Here we’ll cover its most straightforward option for sorting, a simple option that enables us to reorder data in specific columns….
Inserting a Section Break in a Word document gives you a number of ways to split up large walls of text. This feature is useful not just for breaking up text by pages but also for multi-column layouts….
Sorting and filtering data offers a way to cut through the noise and find (and sort) just the data you want to see. Microsoft Excel has no shortage of options to filter down huge datasets into just what’s needed….
Do you want to add percentages in Excel? There are a few ways to do this. In one sense, you could be talking about adding percentage values. Or, you could be looking for a way to add a 15% increase to a value. We’ll take a lo…
Renewing your IP address often fixes minor glitches and connectivity issues. Your Mac will ask your DHCP server—often your Wi-Fi router—for a new IP address and connect using either the same one or a new one, depending on…
Finding the sum of squares in Microsoft Excel can be a repetitive task. The most obvious formula requires a lot of data entry, though there’s a lesser-known option that gets you to the same place.
There’s no native way to save voice messages and other audio files in the Instagram app, but there is a built-in screen recorder in every iPhone. Using this and an audio conversion app, we can save these audio files and sen…
Microsoft Outlook uses vCalendar files to exchange information about meetings and appointments with others in your home or organization. With vCalendar files, you can easily schedule appointments with others even if they’re…
Creating random data to fill an Excel workbook is as simple as adding a few little-known formulas. These formulas come in handy when honing your Microsoft Excel skills, as they give you fake data to practice with before you r…
A vCard is a virtual business card that you can attach to emails in Outlook (or elsewhere) and send digitally. Here’s how to create a vCard, send one, or import one in both Outlook and Gmail.
There are a number of ways to insert contact information into a Word document. Perhaps the easiest is just adding an Address Book button to the Quick Access Toolbar so that you can add contacts on-the-fly and at the touch of …
Microsoft Word makes it easy to add the same text to multiple documents. This is especially handy for text with special formatting, the kind of text that often breaks when pasting it into a new document. The time you find you…
PowerPoint files come in two formats: PPTX files are editable PowerPoint presentations and PPSX files are a view-only format intended for presentations. You can edit a PPSX file, but you must first convert it back to a PPTX f…
Adding a bulleted list in an Excel worksheet isn’t straightforward, but it’s possible. Unlike Microsoft Word—or even PowerPoint—there’s not much in the way of visual cues to guide you when adding these lists. Instea…
Microsoft Excel may be known for complex calculations and formulas, but it’s no slouch at simple arithmetic. There are a number of ways to find solutions to simple math problems, like finding the sum of numbers in multiple …
Macs automatically remember all the Wi-Fi networks you’ve ever connect to along with their passphrases. If you’re having trouble connecting to Wi-Fi, you can remove the list of networks to troubleshoot your problem….
Exponents are simply repeated multiplications. For example, four to the third power (4³) isn’t 4 x 3, it’s 4 x 4 x 4, which equals a total of 64. If that sounds complicated, fear not; Excel can do the heavy lifting for you…
YouTube makes uploading videos easy. Downloading them is another story altogether. Here’s how you can download any video you’ve ever uploaded to YouTube.