

Category Archives for "Excel Tips"

1 [FREE Invoice Generator Template] Save Excel Invoice as PDF

I recently had to get myself registered under Goods and Services Tax (GST) so that I can file for GST on my earnings. Once you have a GST number, you need to file your tax return every month (in India). So every month, my Charted Accountant would reach out to me asking for sales invoices […]

3 Extract Data From PDF to Excel with this Converter (FREE TRIAL)

Convert Button Convert to Excel dialog box

Want to convert a PDF to Excel? Here is a tool that you can use to extract data from PDF to Excel with a high accuracy and format. You also don’t need to give your email address or upload your PDF files anywhere. This tools is completely secure and convert PDF to Excel in seconds.

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.

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

« Previous 1 2 3 4 5 … 33 Next »