BLOG
Excel Dashboard and Reporting
DATA ANALYSIS TRICKS

Best Excel Resources For 2020

While starting Excelsirji.Com, it is always been critical for me to find the best to amaze the viewer experience. So I spent many hours on web to read, explore amazing excel content which I really found helpful to grow as a perfect data analyst. I started learning new things and …

Read More
Random Rows Selector Tool
FREE VBA UTILITIES

VBA Tool to Select Random Rows in Excel

Random Rows Selector is an MS Excel based tool which can be used to pick random or stratified samples from a set of records available in the Excel. The tool is fully dynamic, it can support any data format in Excel.

Read More
VBA Code to Count Cells by Color
VBA TRICKS

VBA Code to Count Cells by Color

Have you ever felt that Microsoft should have added a formula in Excel which can count the cells based on specific color? I have seen many code requests to share a VBA code that can count the cells by its color. To help our subscribers and developers, we are sharing 2 codes that be used to count the cells with specific color and returns the count of the matching color cells.

Read More
SUBTRACTION AND ADDITION IN DATE FUNCTION
EXCEL TRICKS

Calculations with Date in Excel

Dates function also be used to subtract the Year, Month and Days from the existing dates. Sometimes we need to subtract specific period from the date. In case you are working on large database, this become tedious job for calculating date difference Here we discussed the various scenarios where we …

Read More
Free Tutorial on creating Pivot Tables in Excel
DATA ANALYSIS TRICKS

Pivot Table For Beginners – Part 1

Pivot Tables in excel is backbone of data analysis in excel. If you want to perform various analysis in excel, then I would suggest, learn this amazing excel feature to complete your analysis with in few minutes Common Queries For Pivot Tables What is it Why to use it How …

Read More
Date Function in Excel
EXCEL TRICKS

Date Function in Excel

While using Microsoft Excel, you must have got the situation where you need to use the Date function. Date function is one of the common and most used function in Excel that helps in various calculations. This Function also helps to convert the serial numbers to Date format of your …

Read More
Pareto Chart Sample
DATA ANALYSIS TRICKS
1

Create Pareto Chart In Excel

What is Pareto Chart? Pareto principle was introduced by Italian Economist Vilfredo Pareto. He stated that 80% of the effects are caused by 20% of the causes. So if we closely monitor and solve 20% of the causes. It will significantly improves the affected area and you will see good results.  …

Read More
VBA Code to Sum Cells by Color
VBA TRICKS

VBA Code to Sum Cells by Color

Recently some of our subscribers have requested us to share a VBA code that can sum the cells by its color. To help our subscribers and developers, we are sharing 2 codes that be used to sum the cells with specific color and returns the total sum of the matching color cells

Read More
Logo Inserting Symbols in Excel
EXCEL TRICKS

How to Insert Symbol in Excel Numbers?

Have you ever faced the challenge while using special character symbols in number formatting or any customized number formatting? It is an easy method to insert any symbol in numbers i.e Delta Symbol or Special Character Symbols in Excel Number Formatting.  You may easily do this by following below steps: …

Read More
Delta Symbol
EXCEL TRICKS
1

Usage of Delta Symbol in Excel – Complete Guide

The Greek Capital Alphabet letter Delta (▲) and  is commonly discussed topic in Excel. This is being used for various purposes i.e. changes in quantity, insert the symbol in excel etc. Though inserting Delta (▲) is very easy in any of the MS Office Applications i.e. Excel, Word, Power Point …

Read More
Logo Inserting Symbols in Excel
EXCEL TRICKS

How to Insert Symbol in Excel

I came across many queries regarding inserting special symbols in Excel. Here we are guiding how you may do this quickly in excel. Follow these steps and you may insert any kind of special characters in Excel via using this method. So lets start Excel Symbol Dialog Box Here I …

Read More

Facebook
Facebook
YouTube
YouTube
Pinterest
Pinterest
LinkedIn