Bryan Clark
How-To Geek
Mexico
Contact Bryan
Discover and connect with journalists and influencers around the world, save time on email research, monitor the news, and more.
| Recent: |
|
| Past: |
|
Past articles by Bryan:
How to Fill Excel Cells Automatically with Flash Fill and Auto Fill
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. → Read More
How to Use Excel’s “Quick Analysis” to Visualize Data
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. → Read More
How to Use Pivot Tables to Analyze Excel Data
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. → Read More
How to Transpose Excel Data from Rows to Columns (or Vice Versa)
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. → Read More
How to Add Line Breaks in Microsoft 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 line breaks. → Read More
How to Make Sortable Headings in Excel
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. → Read More
How to Create and Use Sections in Microsoft Word
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. → Read More
How to Sort and Filter Data in Excel
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. → Read More
How to Add Percentages Using Excel
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 look at both. → Read More
How to Renew a Mac’s IP Address (to Troubleshoot Problems)
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 the details your router provides. → Read More
How to Calculate the Sum of Squares in Excel
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. → Read More
How to Save Instagram Audio Messages on an iPhone
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 send them just about anywhere. → Read More
How to Create Random (Fake) Datasets in Microsoft Excel
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 risk mistakes with the real thing. → Read More
How to Use the vCard Feature in Outlook
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. → Read More
How to Insert Outlook Contact Information in Microsoft Word
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 a button in any Microsoft Office application. → Read More
How to Use Linked Text to Update Multiple Word Documents
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 yourself changing the same details in a dozen documents, try this instead. → Read More
How to Change a PowerPoint Show (PPSX) to a Work File (PPTX)
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 format. → Read More
How to Insert Bullet Points in an Excel Spreadsheet
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. Instead, we’ll try some manual trickery to get the task done. → Read More
How to Calculate the Sum of Cells in Excel
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 cells. → Read More
How to Forget Wi-Fi Networks a Mac Previously Connected to
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. → Read More