Case v 42

Did you type a line of text and then realize that it should have been capitalized differently? Instead of typing the line again, you can quickly and easily change the case of any text in Word without retyping it. To change the case on text in a Word document, select the text you want to change and make sure the Home tab is active. Then, click the “Change Case” button on the Home tab. Select the desired type of capitalization from the drop-down menu. The following types of capitalization are available: Sentence case: Capitalizes the first letter of the first word in a sentence. lowercase: Makes every letter lowercase. UPPERCASE: Makes every letter UPPERCASE. Capitalize Each Word: Capitalizes the first letter of every word. This is useful for titles or headings. tOGGLE cASE: This makes the first letter of every word lowercase and the rest of the letters UPPERCASE. Toggle Case may seem like a strange option, but it’s useful if you’ve been typing text without realizing … [Read more...] about How to Easily Change the Case on Text in Microsoft Word

CES looked a bit different this year after going all-digital, but that didn’t stop companies from unveiling new products. After careful deliberation, the How-To Geek and Review Geek teams have awarded the following 11 products with How-To Geek’s Best of CES 2021 awards. Before jumping into the awards, Review Geek has been hard at work covering all of the CES 2021 announcements that you need to know about. Head on over there if you’ve missed anything from the internationally renowned trade show. Best in Show: Kensington StudioDock In order to stand out from everything announced at CES 2021 and win Best in Show, a product needs to make an entrance. The Kensington StudioDock did just that, causing most of the team to say, “I want that.” Using the StudioDock in conjunction with a Bluetooth keyboard and mouse, you can turn your iPad Pro or Air into an iPadOS iMac. Use the two built-in wireless chargers and the optional Apple Watch charger (which is coming soon) and … [Read more...] about Best of CES 2021: The Top Products Coming This Year

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 “Flash Fill.” How to Use “Text to Columns” in Excel Select the cells you want to split by clicking the first cell and dragging down to the last cell in the column. In our example, we’ll split the first and last names listed in column A into two different columns, column B (last name) and column C (first name.) Click the “Data” tab at the top of the Excel Ribbon. Click the “Text to Columns” button in the Data Tools section. In the Convert Text to Columns Wizard, select “Delimited” and then click “Next.” Delimited works great in our example, as the names are separated by commas. If the names were separated only by a space, you could select “Fixed width” instead. Check both the “Comma” and “Space” delimiters and then the “Next” button. … [Read more...] about How to Split Data Into Multiple Columns 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. How to Sort Data in an Excel Spreadsheet In Excel, click inside the cell atop the column you want to sort. In our example, we’re going to click cell D3 and sort this column by salary. From the “Data” tab on top of the ribbon, click “Filter.” Atop each column, you’ll now see an arrow. Click the arrow of the column you wish to sort to bring up a menu that enables us to sort or filter the data. The first and most obvious way to sort data is from smallest to largest or largest to smallest, assuming you have numerical data. In this case, we’re sorting salaries, so we’ll sort from smallest to largest by clicking the top option. We can apply the same sorting to any of the other columns, sorting by the date of hire, for example, by selecting the “Sort … [Read more...] about How to Sort and Filter Data in Excel

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 common pitfalls. Table of Contents Start With a Goal Less Is More Consider Your Typeface Make Bullet Points Count Limit the Use of Transitions Skip Text Where Possible Think in Color Take a Look From the Top Down Bonus: Start With Templates Start With a Goal It all starts with identifying what we’re trying to achieve with the presentation. Is it informative, a showcase of data in an easy-to-understand medium? Or is it more of a pitch, something meant to persuade and convince an audience and lead them to a particular outcome? It’s here where the majority of these presentations go wrong with the inability to identify the talking points that best support our goal. Always start with a goal in mind: to entertain, … [Read more...] about 8 Tips to Make the Best PowerPoint Presentations