What are Lists in Excel & How to Create Custom List for Autofill
top of page
Most of the excel users might have already used Lists, without even realizing that they are using it. When you enter a value and drag it,...
Sajit Simon
- 3 min
Basics of Pivot Tables in Excel Part 2
This is in continuation to my earlier content, so if you have not gone through the Part 1 of the series then you should definitely read...
Sajit Simon
- 3 min
Basics of Pivot Tables in Excel Part1
PIVOT TABLES, to put it in simple words, pivot tables are the most convenient way of creating a quick summary out of your data without...
Sajit Simon
- 2 min
5 Most Amazing & Unknown Excel Formulas
Excel is one of the most extensive and useful software that I have ever used. This is because it is still evolving & getting more...
Sajit Simon
- 3 min
Mastering Custom Formatting in Excel
No matter how we analyze our data, formatting remains a key part of the activity because it helps us clearly view the data in our desired...
Sajit Simon
- 2 min
When to use SUMIFS vs DSUM?
There are multiple aggregation functions in excel and few of them are popular choice because of its ease of use and SUMIFS would probably...
Sajit Simon
- 5 min
Filtering Data in Excel will not be same after Reading This - Implement Advanced Filter with VBA
Advanced filters as the name suggests is one of the advanced functionalities within Excel which makes it really easy to filter out large...
Sajit Simon
- 3 min
Data Transformation using Power Query - Part 2
Welcome to the second part of the data transformation series and if you have not seen the 1st part then I would highly recommend you to...
Sajit Simon
- 3 min
Data Transformation using Power Query - Part 1
Data transformation is one of the key steps in the Data Analytics world but often it is overlooked which leads to huge amounts of rework...
Sajit Simon
- 4 min
How to Trigger VBA Code When a Worksheet is Updated
Automation is not as difficult as you might think. In fact, in some use cases, it is so simple that you will find using excel formulas...
Sajit Simon
- 3 min
How WILDCARDS are a Real Time Saver
Wildcards are simply awesome because it has the potential to reduce your analysis efforts to just seconds. It has been a secret recipe...
Sajit Simon
- 3 min
Forget Nested IF Function, Use IFS instead
IF function and nested IF function has been a lifeline of many excel users for a long time now. And quite frankly it has the ability to...
Sajit Simon
- 3 min
Calculated Fields & Items in Pivot Tables
Pivot tables are one of the most useful features of excel which makes it super easy to summarize your data in any form you want. But...
Sajit Simon
- 2 min
Drop down with dynamic name range in excel
Have you ever wondered if we can create a drop down within a cell of excel? And even if you have created a drop down using Data...
Sajit Simon
- 3 min
Append multiple excel files in a folder to a single excel file using Power Query
Often we are in a situation where we would have to compile or append a huge list of data files together before we get into our analysis....
Sajit Simon
- 3 min
Conditional Formatting with Formula in Excel
We all must have manually formatted our excel spreadsheet at some point in time either for creating a border or highlighting a cell or...
bottom of page