Tagged: Excel

How to convert Apple Numbers to Excel

Apple Numbers is a convenient spreadsheet application included with macOS, iOS, and iPadOS for free. While this makes it handy for Apple users, it can make it difficult to share a workbook with a non-Apple user.
Because you can use Microsoft Excel on b…

Google Sheets vs. Excel: Which is better?

If you’re trying to decide on a spreadsheet application, it’s likely that Google Sheets and Microsoft Excel have made their way onto your list of options. After all, these are two of the most popular and widely used spreadsheet tools on the market.

So…

How to create a drop-down list in Excel

Implementing a drop-down list in Excel is a quick and efficient way to choose predefined data. In the process, you’re able to save time from manually entering such data into a given spreadsheet. Drop-down lists are perfect for several purposes, such as…

How to calculate percentages in Excel

Turning data into percentages can give you a new insight, or make summarising heaps of data that bit easier. Calculating percentages is easy with a calculator, but it’s even easier if you have a tool to automatically calculate percentages for you. This…

How to use concatenate in Excel

The concatenate function may not be as well known as other common Excel features such as IF and VLOOKUP, but it’s still effective, even though it performs a more simple function in nature. Concatenate merges the data you have inserted into columns into…