How to Separate First and Last Name in Excel

Click on text to columns in Data tab

Let’s say you have a spreadsheet with lots of names, and you want to make an analysis of the data. When the first and last names are together in a cell, it makes it extremely difficult to analyze, sort, and find important information. To eliminate this difficulty, we will learn in this tutorial to separate … Read more

How to Delete Multiple Sheets/Tabs in Excel at ONCE

Right click and delete a single sheet

Opening sheets for different purposes within an Excel document is an excellent feature. However, sometimes you may accidentally open multiple unnecessary sheets, which can cause redundancy, especially if you don’t know how to delete multiple sheets in Excel at once. In this tutorial, we will learn how to delete a single sheet and then to … Read more

How to Sort by Date in Excel

Click on custom sort

Sorting is an extremely useful function of Excel. Excel sort enables many options and variations so that you can sort your data with any specification. In this tutorial, we will learn how to sort by date in Excel: we will sort a single column or the entire data by date, and also learn how to … Read more

How to Remove Leading Apostrophes in Excel (2025)

Example of a column with leading apostrophes in excel

If you have worked on Excel files extracted from a database or a system, you probably have encountered cells with leading apostrophes. If you’re like me, you too might have wondered why in the world they’re there. It turns out that the apostrophe (or single quote) (‘) that you see at the beginning of a … Read more

How to Calculate Cumulative Percentages in Excel?

Drag the fill handle up to the last row to copy the formula to the remaining cells.

A cumulative percentage is a statistical tool commonly used in analyzing scientific research, finance, and sales data. But what exactly is it, and what is its purpose? Cumulative Percentage is defined as a way of expressing frequency distribution. It shows the percentage of the cumulative frequency within each interval. Essentially, it can be viewed as … Read more