Skip to content
Excel Unlocked

Let's Unlock the Power of Excel for You

  • Functions
  • Tips and Tricks
  • Charts
  • VBA and Macro
  • About Us
Excel Unlocked
  • Functions
  • Tips and Tricks
  • Charts
  • VBA and Macro
  • About Us
How to Convert CSV File to Excel Using Power Query

How to Convert CSV File To Excel Using Power Query

The Excel Power Query feature (also popularly known as ‘Get & Transform’) is an amazing excel tool used to import and transform data from external… Read Article
How to Convert JSON to Excel Using Power Query

How to Convert JSON to Excel Using Power Query

JSON stands for JavaScript Object Notation. It is a lightweight data-interchange format used to exchange data between a browser and a server in a text… Read Article
How to Unpivot Data in Excel Using Power Query

How to Unpivot Data in Excel Using Power Query

Excel Pivot Table is an amazing excel feature which is used to create different types of summary reports based on the huge table for the… Read Article
Convert Table from PDF to Excel Using Power Query

Convert Table from PDF to Excel Using Power Query

The Power Query has proved to be a life-saver feature for many excel users. This feature helps to extract and import data from various sources… Read Article
Merge Text Files in Folder to Excel

Combine or Merge All Text Files in Folder in Excel

The Excel Power Query feature has proved to be a life-saver when you want to get and transform data from various external sources. External sources… Read Article
Import Data From Text File To Excel

How to Import Data from Text File or Notepad to Excel

The Excel Power Query also called the ‘Get & Transform’ feature is an excellent excel tool to extract and import data from various internal or… Read Article
Data Types in Power Query

What are Data Types in Excel Power Query

Excel Power Query is a powerful inbuilt tool provided by Microsoft in Excel versions 2016 and higher. The power query feature allows you to get… Read Article
How to Refresh Power Query in Excel

4 Ways to Refresh Power Query in Excel

Power Query is a very powerful tool provided by Microsoft for data cleaning. You can use this feature to import data from multiple sources and… Read Article
Import Data from Web To Excel

Import Data from Web To Excel Using Power Query

The Power Query is an amazing feature provided by Microsoft in Excel 2016 and higher versions. Using this feature, you can extract data from various… Read Article
Get Filenames from Folder in Excel

How To Get All Filenames in Folder in Excel

Power Query is an amazing feature provided by Microsoft to import, transform, and extract the data from various sources such as other workbooks, CSV file… Read Article
Download Install Power Query in Excel 2010 & 2013

Install Power Query in Excel 2010 [Step by Step Guide]

Power Query in Excel is a very powerful tool provided by Microsoft in Excel Application. This feature allows you to get data from various sources… Read Article
Overview of Power Query Tool Excel

Overview of Power Query in Excel

This is the introductory blog on the basics and overview of the Power Query feature in Excel. In this blog, we would unlock this amazing… Read Article
Older posts
Newer posts
← Previous Page1 … Page31 Page32 Page33 … Page42 Next →
Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Recent Comments

  • Nilesh Patel on Excel DATEDIF Function – Find Difference Between Dates
  • daniel on Excel XNPV Function – NPV With Irregular Cash Flows
  • wout on How to Insert Picture or Image in Excel Comment

Archives

Categories

  • Charts (69)
  • Functions (281)
  • Tips and Tricks (73)
  • VBA and Macro (73)
  • Home
  • Privacy Policy
  • Terms of Use
  • About Us
  • Contact Us
  • Site Map
Copyright @ExcelUnlocked.com 2025