How to Create Pie Chart in Excel (Complete Tutorial)
Pie Chart is one of the ways of visual presentation of your data sets. Sometimes it makes easier to understand the data while visualizing.
How Histogram Works in Excel? (Definitive Guide)
In layman language, this chart divides the data into multiple range groups with same interval i.e. 1-5, 5-10… and then plot the data into these groups to find the distribution among these group. So that you may understand, what are the major areas which has large impact or your major data fall. This helps the user to understand the nature of your data
HOW TO COMPARE TWO COLUMNS IN EXCEL
Comparing Columns in Microsoft excel is much often feature that is used while managing database. We have many ways to compare the columns in excel and can be used as per the requirement. We will…
How to use CONDITIONAL FORMATTING in Excel
Conditional Formatting helps to easily identify the usual and unusual numbers/ conditions, creating interactive visualization by means of Highlight Cells by Rules, Top/Bottom Rules, Data Bars, Color Scales and Icon Sets.
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…
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...
Create Pareto Chart In Excel
Watch Excel Tutorial Video - 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...
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…
Usage of Delta Symbol in Excel – Complete Guide
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...
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…
Video – How to Use Conditional Formatting?
This video will help you to understand how you may use conditional formatting to highlight row based on conditions. Subscribe us for more updates
Find Duplicates in Excel
Watch Excel Tutorial Video -Find Duplicates in Excel Hope you read the post “Remove Duplicates in Excel”. Now I am going to explain how you can find these duplicates. There are multiple methods available to...
Remove Duplicates in Single Column
Watch Excel Tutorial Video - Remove Duplicates in Single Column When you see duplicate data in single column, you may follow this article to remove these duplicates with few clicks. If you see below screenshot,...
How to get RGB Codes of a Color
Excel supports more than 16 million colors in a cell; hence you should know how to set the exact color in a cell. To do this through VBA, you can use RGB (Red, Green, Blue)…
Impress your Clients by Hiding these Simple Features
While preparing many projects, my clients always want me to make professional, good looking dashboards. So I hide few things like Gridlines, Column & Row headings and Formula Bar. This can give WOW experience to…
Protect Sheets, Share Workbook, Protect Workbook
Creating beautiful and professional dashboards, projects always lead you to success however there are places when you wanted to protect your dashboards, sheets, cells to prevent users to make unnecessary editing because it can change…
TRIM Excel Formula – How to remove extra spaces or leading spaces in Excel?
You must have faced a condition when your data cells contain extra spaces, leading spaces or trailing spaces and you wanted to remove these extra spaces to standardize the data. So here you may use…
How to Create dropdown List in Excel
Watch Excel Tutorial Video - How To Create Dropdown List In Excel Excel is an awesome Microsoft utility which most of the professionals are using for their day to day office use as Excel is...