Skip to content
Excel Unlocked

Let’s Unlock the Power of Excel for You

  • Home
  • Functions
  • Tips and Tricks
  • Charts
  • About Us
Excel Unlocked
  • Home
  • Functions
  • Tips and Tricks
  • Charts
  • About Us
infographics dynamic array formulas in excel

Dynamic Array Formulas in Excel – Usage, Example, #SPILL

Dynamic Array Formulas are real game changers when one knows how to use them! They are compatible with Microsoft Excel 365 and Excel 2022 versions.… Read Article
infographics making a calculated field in pivot table in excel

Making Calculated Field in Pivot Table in Excel

In the earlier blogs, we did the usage of Pivot Tables in Excel. In pivot Tables, we can add the pivot fields ( Columns )… Read Article
infographics text and number filters in excel

Text and Number Filter in Pivot Table in Excel

There are a number of ways to filter the data in a pivot table. In the previous blog, we learned how to filter the pivot… Read Article
infographics link multiple pivot tables to one slicer in excel

Link Multiple Pivot Tables to One Slicer in Excel

In the previous blogs, we have learned to create pivot tables and how we can add single and multiple slicers to one pivot table. Slicers… Read Article
infographics slicers in pivot table

Slicers with Pivot Table – Multiple Slicers

There are several ways to filter our data in the pivot table. Since pivot tables use the simplest drag and drop field method, slicers are… Read Article
infographics sort pivot table data manually

How to Sort Pivot Table Manually?

In the previous blog, we learned how to sort the pivot table data in ascending order, descending order, and alphabetically. This blog will learn how… Read Article
infographics sort data in pivot table in excel

Sort Data in Pivot Table – Fields, Rows, and Sub Totals

Sorting our data plays a very important role in easily getting the correct order of things, maximum and minimum results and we can even sort… Read Article
infographics group data in pivot tables

Group Data in Pivot Table – Dates, Numbers, Text

Grouping the Data items in the pivot table help us quickly reach conclusions without going into a deep study. We can define ranges for numbers,… Read Article
infographics make pivot table from scratch by using a blank pivot table

Making Pivot Table from Scratch – Blank Pivot Table

In the previous blog, we learned the Fundamentals of Pivot tables and how to make recommended pivot tables as per our data set. In this… Read Article
infographics pivot table in excel

Pivot Table in Excel – Making Pivot Tables

The Pivot Table is the most technologically sophisticated component in excel. With the usage of pivot tables, we can easily slice and dice our data.… Read Article
infographics bell curve in excel

Bell Curve in Excel – Usage, Making, Formatting

Bell Curve in Excel is one of the advanced Excel charts. There is no built-in chart type in excel to make a bell curve but… Read Article
norm.dist infographics in excel

NORM.DIST Function in Excel – Get PDF and CDF

In the recent blogs, we did the usage of AVERAGE and STDEV.P Function in Excel. The parameters of NORM.DIST Function uses these two functions. Let… Read Article
Post navigation
Older posts
Newer posts
← Previous Page1 Page2 Page3 … Page30 Next →
Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Subscribe to Blog via Email

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

Join 298 other subscribers

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

Categories

  • Charts (67)
  • Functions (222)
  • Templates (0)
  • Tips and Tricks (59)
  • Uncategorized (2)

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.

  • Home
  • Privacy Policy
  • Terms of Use
  • About Us
  • Contact Us
  • Site Map
Copyright @ Excelunlocked.com 2022