BLOG

#### Excel VBA Tips you Must Know – Part 1

Here we are coming with one more exciting post which can help you to solve very basic but very important problems while writing VBA codes.

#### EXCEL FUNCTION – WORKDAY

Are you working today? or Do you have Work Off or holiday today?  I am asking this question because I am gonna tell you the most commonly used function in Excel “Workday”. “Workday” as name suggest that it brings the day when you will be working or you are expecting …

#### 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 this function for different purposes instead of multiple functions i.e. SUM, AVERAGE, COUNT, MAX, MIN, Standard Deviation etc. …

#### Excel Function – Sum Formula

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 given range. Here you should know about “Excel Ranges” before starting to use Excel Formulas. You can SUM (Add) …

#### 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 …

#### Free Excel Based Random Data Sampling Tool For 2020

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.

#### 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 …

#### 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 …

#### 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 …