Skip to content

Let's the Power of Excel

  • Home
  • Functions
  • Tips and Tricks
  • Templates
  • About Us
Menu
  • Home
  • Functions
  • Tips and Tricks
  • Templates
  • About Us

Recent Posts

HOUR Function in Excel
Functions
January 23, 2021 No Comments
How To Add Conditional Column in Excel Power Query
Functions

How to Add Conditional Column in Excel Power Query

November 30, 2020 No Comments
Group and Summarize Data in Excel Power Query
Functions

Group and Summarize Data in Excel Power Query

November 28, 2020 No Comments
How to Transpose Data in Excel Power Query
Functions

Transpose Data in Excel Using Excel Power Query

November 21, 2020 No Comments
« Previous Page1 Page2 Page3 Page4 Page5 Next »

Category: FUNCTIONS

How to Convert JSON to Excel Using Power Query

How to Convert JSON to Excel Using Power Query

How to Unpivot Data in Excel Using Power Query

How to Unpivot Data in Excel Using Power Query

Convert Table from PDF to Excel Using Power Query

Convert Table from PDF to Excel Using Power Query

Merge Text Files in Folder to Excel

Combine or Merge All Text Files in Folder in Excel

Import Data From Text File To Excel

How to Import Data from Text File or Notepad to Excel

Data Types in Power Query

What are Data Types in Excel Power Query

« Previous Page1 Page2 Page3 Page4 Page5 Next »
More Functions

Category: TIPS AND TRICKS

Insert Tick and Cross Mark Symbol in Excel

Insert Tick Mark or Cross Mark in Excel

Find and Replace Cell Color in Excel

Find and Replace Cell Color in Excel

Using Wildcard Characters in Excel

Advanced Search Using Wildcard Characters in Excel

Split Cells Diagonally in Excel

How to Split Cell Diagonally in Excel

Four Ways to Run A Macro in Excel

Four Ways to Run A Macro in Excel

Add Macro to Quick Access Toolbar or Ribbon

Add Macro to Quick Access Toolbar and Ribbon

« Previous Page1 Page2 Page3 Page4 Page5 Next »
More Tips and Tricks

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 280 other subscribers

Popular posts

  • DAY Function in Excel ... 39 views
  • DATE Function in Excel &#... 20 views
  • DATEVALUE function in Exc... 16 views

Recent Comments

  • Parth Gupta on Show Negative Numbers in Bracket and in Red Color
  • Shailesh on Sparkline in Excel – Insert, Edit and Delete
  • Dhrunil Bhatt on Stack Data from One Column into Multiple Columns

Archives

  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • Home
  • Privacy Policy
  • Terms of Use
  • About Us
  • Contact Us
Menu
  • Home
  • Privacy Policy
  • Terms of Use
  • About Us
  • Contact Us

Categories

  • Functions (86)
  • Tips and Tricks (58)

Mission

ExcelUnlocked is dedicated to unlocking the power of Excel for professionals, students and all others who use Excel in their day to day activity.