

Category Archives for "Excel Tips"

0 How to Unpivot Data in Excel using Power Query (aka Get & Transform)

In this tutorial, I’ll show you how to unpivot data using Power Query (Get & Transform). Pivot Table needs the data in a specific format so that it can analyze it and create different views from it. In case you don’t have the data in a Pivot Table ready format, you can use Power Query to unpivot the data set.

2 Combine Data from Multiple Workbooks in Excel (using Power Query)

Combine Data from Multiple Workbooks - data for each workbook when clicked

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 […]

12 Excel Holiday Calendar Template (FREE Download)

Excel Holiday Calendar List Template - Demo

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 […]

5 [Quick Tip] How to Select 500 cells/rows in Excel (with a single click)

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 […]

6 Get a List of File Names from Folders & Sub-folders (using Power Query)

Combine Data from Multiple Workbooks - files from folder

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 […]

5 3 Quick Ways to Select Visible Cells in Excel

Select Visible Cells in Excel - using keyboard shortcut ALT semicolin

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 + […]

0 How to Quickly Remove Hyperlinks from a Worksheet in Excel

Remove All Hyperlinks - Paste VBA code in module

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 […]

« Previous 1 2 3 4 5 … 33 Next »