Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
To be able to reference cells and ranges is what makes any spreadsheet tool work. And Excel is the best and most powerful one out there. In this tutorial, I will cover all that you need to know about how to reference cells and ranges in Excel. Apart from the basic referencing on the same …
If you have an Excel workbook with many worksheets, there is no easy way to split each of these sheets into separate Excel files and save separately. This could be needed when you have sheets for different months or regions or products/clients, and you want a separate workbook for each sheet (as an Excel file …
To get the sum of an entire column is something most of us have to do quite often. For example, if you have the sales data to date, you may want to quickly know the total sum in the column to the sales value till the present day. You may want to quickly see what …
In this tutorial, I will show you some really simple ways to insert a blank row after every row in an existing dataset (or after every Nth row). People who work with large data sets often need simple things such as inserting or deleting rows and columns. While there are already many different (and simple) …
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 …
‘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: While you don’t need to use immediate window to work with VBA in Excel, knowing how to use it well can make you a lot more efficient. In this …
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 about manipulating text data is – “How to separate first and last names …
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 …
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 as shown below and you want to hide the value 0 in all these cells (or …
©trumpexcel.com – Free Online Excel Training
