Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
Sometimes you may have a need to delete every other row (i.e., alternate rows), or every third/fourth/fifth row in Excel. One use-case of this could be when you have weekly data and you only want the data for even weeks or odd weeks. Another could be when you get a data dump from a database …
When you enter a text string in Excel which exceeds the width of the cell, you can see the text overflowing to the adjacent cell(s). Below is an example where I have some address in column A and these address overflow to the adjacent cells as well. And in case you have some text in …
When working with large data sets, you may have the need to quickly delete rows based on the cell values in it (or based on a condition). For example, consider the following examples: There are multiple ways to skin this data cat in Excel. The method you choose to delete the rows will depend on …
Want some Excel files to open automatically when you start Excel? These could be files the that you open every day in the morning (such as tracking sheet or timesheet), or some project related files that you need to open as soon as you start Excel. While you always have the option to open these …
Sorting data in Excel has been made quite easy with all the in-built options. You can easily sort your data alphabetically, based on the value in the cells, or by cell and font color. You can also do multi-level column sorting (i.e., sorting by column A and then by column B) as well as sorting …
If you want to count how many different customers bought from each store, a Pivot Table looks like the obvious tool. Excel Pivot Tables are amazing (I know I mention this every time I write about Pivot Tables, but it’s true). With a basic understanding and a little drag and drop, you can get a …
Pivot Table is one of the best features in Excel. You don’t need to know any formula or coding to quickly crunch thousands of rows of data and create quick summaries out of it. All you need to know is how to drag and drop and a little bit of knowledge of how to create …
Excel has a lot of options when it comes to sorting data. And one of those options allows you to sort your data based on the color of the cell. For example, in the below dataset, you can sort by color to get the names of all the students who scored above 80 together at …
Excel allows having hyperlinks in cells which you can use to directly go to that URL. For example, below is a list where I have company names which are hyperlinked to the company website’s URL. When you click on the cell, it will automatically open your default browser (Chrome in my case) and go to …
©trumpexcel.com – Free Online Excel Training
