Excel Blog - Latest Excel tips, tutorials, and videos.

0 Insert a Blank Row after Every Row in Excel (or Every Nth Row)

Final Dataset where blank rows have been inserted after each row

Watch Video – Insert Blank Row After Every Row in Excel People who work with large data sets often need simple things such as inserting/deleting rows or columns. While there are already many different (and simple) ways to add rows in Excel, when it comes to inserting a blank row after every other row (or […]

2 Calculating Moving Average in Excel [Simple, Weighted, & Exponential]

Simple Moving Average (SMA) formula in Excel

Like many of my Excel tutorials, this one is also inspired by one of the queries I got from a friend. She wanted to calculate the moving average in Excel, and I asked her to search for it online (or watch a YouTube video about it). But then, I decided to write one myself (the […]

0 Excel VBA Immediate Window – 5 Awesome Ways to Use it!

‘Immediate window’ can be a useful tool to use when working with VBA in Excel. The Immediate window allows you to quickly do things such as: Get information about Excel files (such as sheet count in a workbook or name of the workbook) Get Debug.Print information quickly Run a line of code in seconds Run […]

4 Separate First and Last Name in Excel (Split Names Using Formulas)

Resulting Data where names have been separated

Watch Video – Split Names in Excel (into First, Middle, and Last name) Excel is an amazing tool when it comes to slicing and dicing text data. There are so many useful formulas as well as functionalities you can use to work with text data in Excel. One of the very common questions I get […]

0 How to Unhide Sheets in Excel (All In One Go)

Watch Video – How to Unhide All Sheets In Excel In case you prefer reading a tutorial over watching a video, below is a detailed written tutorial on unhiding sheets in Excel. When you work with data that is spread across multiple worksheets in Excel, you may want to hide a few worksheets. This could […]

4 Hide Zero Values in Excel | Make Cells Blank If the Value is 0

Click on the Equal to option in Conditional Formatting

Watch Video – How to Hide Zero Values in Excel + How to Remove Zero Values In case you prefer reading over watching a video, below is the complete written tutorial. Sometimes in Excel, you may want to hide zero values in your dataset and show these cells as blanks. Suppose you have a dataset […]

0 How to Delete Every Other Row in Excel (or Every Nth Row)

Click on the filter icon the helper column header

Watch Video – Delete Every Other Row in Excel 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 […]

1 2 3 … 53 Next »