It’s easy to Convert between Excel and Google Sheets. Convert between Excel and Google Sheets – Open an Excel file in Google Sheets To open an Excel file in Sheets, start with a blank Sheets workbook, go to the File menu, and select Import. Then select Upload, and Select a file from you device. Find […]
Convert between Excel and Google Sheets in seconds Read More »
Sometimes you want to convert Excel to a PDF. You may be making a presentation to your boss, or sending someone financial statements. And you don’t want to use a live spreadsheet. This is incredibly easy to do in Excel. It literally takes 3 seconds. Yet I often see advertorials selling useless rip-off third party
Convert Excel to a PDF in 3 Seconds Read More »
Have you ever wanted to use tags in Excel? Maybe you want to assign tags in Excel for your business contacts, friends, or favorite recipes. You may have many different tags, frequently create new ones, and an arbitrary amount of tags assigned to each individual. It’s extremely easy to do this using filters and Excel’s
Tags in Excel: How to Implement Them in Seconds Read More »
Have you ever wanted to remove duplicates from a list in Excel? It’s a common issue. You have a long list of names or other values where some of them are repeats, and you need a list where each value appears only once. There are two quick and easy ways to do this. Method 1:
2 Easy Ways to Remove Duplicates From a List in Seconds Read More »
There are sometimes leading zeros in zip codes in the United States. Meaning that a 5-digit US zip code could be something like 03842. But Excel assumes numbers shouldn’t start with zeros, and removes them. There’s an easy way to fix leading zeros in zip codes that takes literally 10 seconds – no matter how
Fix leading zeros in zip codes in Excel in 10 seconds Read More »
Freezing panes will make your life a whole lot easier. Anytime you have a spreadsheet that is too big to fit on one screen, you have a problem. When you scroll down, you can’t see the column headers. And when you scroll to the right, you can’t see the row labels. You end up having
Freezing Panes to Make Your Life Easier Read More »
Filters are Excel’s “Easy” button. They let you be faster, more effective, and quickly analyze data. They’re incredibly simple to use. All it takes are a few clicks. But few beginners are aware of them. When I show filters to my clients, it tends to blow their minds. The immediately see the possibilities for how
Filters: Excel’s Easy Button Read More »
Reader SV wrote in to ask: “How to I transpose a table, like copying and pasting a vertical column of cells to a horizontal row of cells?” Great question! Let’s say you have data that looks like this: Then you decide that you’d rather have the dates running across the top, with each individual and
How to Transpose Information in Excel Read More »
