Excel Function – SUBTOTAL
Excel Function SUBTOTAL Excel Function “Subtotal” is most commonly used formula in excel and it can make your work easy while performing simple mathematical calculations because of variety of features like: – You can use…
Excel Function – Sum
SUM Function in Excel Excel is a mathematical spreadsheet where you can perform multiple calculations with the help of Excel Formulas. These are automated formulas which refreshes automatically once you refresh your data in a…
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…
Audit Sampling Tool
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.
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.
How to Use RAND and RANDBETWEEN Functions in Excel
RAND AND RANDBETWEEN FUNCTION We have got many instances where we needed to generate a random database or values. “RAND function” is very useful for users who creates random database for various types of working…
Calculations with Date in Excel
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…
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…
EXCEL FUNCTION – DATE
Excel Function DATE 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…
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…
VBA Code to Sum Cells by Color
VBA code that will sum cells by its color through excel function. This code will really help in making the analysis and presentation better.
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…
What is VLOOKUP in Excel?
An ultimate guide for basic user to understand Excel Vlookup function. VLOOKUP is a vertical lookup which helps the user to extract the values from other columns (leftmost) basis on matching column string.
Time and Motion Study – Complete Guide
Here is one more wonderful free tool from ExcelSirJi.com which makes your life easy. Time & Motion Tracker helps you to track Start and End time of any type of transaction or activity. The good thing is, it is VBA based tool which helps you to protect from manual manipulation in the data by the user. It is also easy to use, just click on Start (shortcut: Ctrl+Shift+A) or Stop (Ctrl+Shft+S) buttons to record the time
VBA Code to Delete File
In this article we are going to show you how you can delete file or files using a single line of VBA code. 1. Delete a specific file from the folder, 2. Delete specific type of files from the folder, 3. Delete all files from the folder
VBA Code to Add Border to Excel Range
Through formatting the cells, you can make your Excel data more beautiful and easier to understand. If you record a macro to add borders to Excel range, you will notice that it generates 30 plus lines of code for just a small work. Here we are sharing one line of code which does the same thing.
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
Protect Excel Sheet for Manual Input but Allow Programming Inputs
Did you come across any requirement where you want the user to interact with a sheet only through VBA Form? Here is a simple code which can help you.
VBA Code to Protect Excel Sheet for Manual Input but Allow Programming Inputs
Did you come across any requirement where you want the user to interact with a sheet only through VBA Form? Here is a simple code which can help you here.