Pivot Tables are great when you want to analyze a huge amount of data in seconds. It also allows you to quickly create different views of data by simply dragging and dropping. And to create a Pivot Table, you need to have the data in a specific Pivot Table ready format. In many cases, you’re […]
One of my friends works in a healthcare analytics company. He often connects with me on some of the real-life issues he faces while working with data in Excel. A lot of times, I convert his queries into Excel tutorials on this site, as it could be helpful for my other readers as well. This […]
Power Query can be of great help when you want to combine multiple workbooks into one single workbook. For example, suppose you have the sales data for different regions (East, West, North, and South). You can combine this data from different workbooks into a single worksheet using Power Query. If you have these workbooks in […]
Last few weeks have been really hectic for me at work. Weekdays are crazy and the weekends are never enough. Early this week, I was going through our annual holiday calendar to check for the next holiday, and plan a vacation if possible. And that gave me the idea for this Excel holiday calendar template. In […]
Watch Video – Select 500 cells/rows in Excel (with a single click) A few days ago I was working with a dataset where I had multiple sheets full of data. I had to select the first 500 cells at one go from each worksheet and copy it. I then had to paste this data into a tool I […]
Watch Video – Get a List of File Names from Folders & Sub-folders Some time ago I wrote an Excel Tutorial about getting a list of file names from a folder in Excel. In that tutorial, I showed various ways to get the list of file names from a folder (using the FILE function and VBA). However, the […]
Watch Video – 3 Ways to Select Visible Cells in Excel What do you do when you have to copy a range of cells in Excel and paste it somewhere else? In most cases, the below three steps get the work done: Select the cells that you want to copy. Copy the cells (Control + […]
Watch Video – How to Remove Hyperlinks in Excel I often find it quite frustrating when Excel automatically creates a hyperlink as soon as I insert an email id or a URL in a cell and hit enter. Now, when I try to select a cell (or double-click on it to get into the edit […]
Watch Video – Round to the Nearest Integer or the Multiple of 0.5 / 5 / 10 in Excel Rounding a number to the nearest integer or the nearest 0.5 or 5 or 10 multiple is a common task for many people. For example, if you’re a project manager involved in effort estimate, you can’t […]
Watch Video – 7 Quick and Easy Ways to Number Rows in Excel When working with Excel, there are some small tasks that need to be done quite often. Knowing the ‘right way’ can save you a great deal of time. One such simple (yet often needed) task is to number the rows of a […]
Read Full Article
Read for later
Articles marked as Favorite are saved for later viewing.
Scroll to Top
Separate tags by commas
To access this feature, please upgrade your account.