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
How to Create a Pivot Table? 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…
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…
How to Insert Symbol in Excel?
How to Insert Symbol in Excel? Have you ever faced the challenge of using special character symbols in number formatting or customized number formatting? It is easy to insert any symbol in numbers i.e Delta…
Usage of Delta Symbol in Excel – Complete Guide
Delta Symbol in Excel 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….
How to Insert Symbol in Excel
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…
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
How to find duplicates in excel?
How to 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 Find and…
Remove Duplicates in Single Column
Remove Duplicates in Excel Highlight/Select the Column A, similar to shown in below screenshot: Go To “Data” tab on Menu Bar and click on “Remove Duplicates” as shown below: Once you click on “Remove Duplicates”,…
How to get RGB Codes of a Color
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…
Few Simple Excel Tips – Excel Learner Should Know
Few Excel Tips 1. CHANGE DIRECTION WHEN YOU PRESS ENTER Whenever you press enter, you must be thinking why my cell selection shifts down. Why it can’t go UP, Down, Left. Surprised This is very…
Impress your Clients by Hiding these Simple Features
How to Hide Ribbon &Formula bar in excel? 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…
Lock Cells to avoid editing, Hide Formulas
Lock Cells to avoid editing, Hide Formulas Sometimes you create amazing projects, dashboards however people can make mistakes and edit the calculations, formats what you have made. Still you can protect the sheets, workbooks and…
Protect Sheets, Share Workbook, Protect Workbook
How to protect and share your 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…
How to Hide Sheet in Excel with or without VBA?
Video: How to Hide Worksheet in Excel? Hide Sheet in Excel When I was creating an excel dashboard, there were multiple sheets which I used for calculation purpose and never wanted anybody to make any…
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 How to Create a Dropdown list in excel?  Microsoft Excel is what most professionals are using for their day-to-day office. Creating a drop-down…
Create Dynamic Data Validation List – Offset Function Method
Create Dynamic Data Validation List When I started my career in working with excel dashboards, I always used to face most common challenge in “Data Validation” technique where I want a smart data validation to avoid all…