Latest Post on XplorExcel

Cash Book Template 1.0 - Free Dynamic Excel workbook-min
Excel Template

Cash Book Template 1.0 – Free Dynamic Excel workbook

Offline Cash Book Template in Excel In Cash Book Template you can record your daily cash transactions. The payment of cash and receipts of cash. You can use it as personal as well for your business.  Feature of Offline Cash Book Template in Excel  1 Life-Time Free Excess of 1.0 version 2 Dynamic Excel Workbook

Read More »
GST Invoice Format 3.0 - Free Dynamic Excel sheet
Excel Template

GST Invoice Format 3.0 – Free Dynamic Excel sheet

Nowadays, In India, The seller must have to register under the GST act, who has a turnover above Rs 40 lakh within the financial year. So every seller needs a GST invoice format. We have provided solutions for all sellers all over India. It is a dynamic GST invoice format in excel. GST Invoice Format

Read More »
Example of SUMIFS Function - Feature Images
Excel Formula

Excel SUMIFS Function – Download 2 practice Sheet for free

The “SUMIFS” function is used to know the total of the particular item from the given data with multiple criteria. What is the “SUMIFS” Function? The Excel “SUMIFS” function is used where we need to sum up the value on multiple criteria. For example, If we have given the total sale of all products within

Read More »
Basic-Excel-Shortcut-Keys
Excel Shortcuts

Basic Excel Shortcuts – 10 Must know shortcuts

We can do our work in excel more efficiently with Basic Excel Shortcuts key. Today we will discuss 10 daily use excel shortcuts keys. With the help of these shortcuts, you will save your time more and do work quickly. Please Note: – Your mind will take few days to store these all shortcuts, Firstly

Read More »
Excel Shortcut Keys for Intermediates
Excel Shortcuts

Excel Shortcut Keys for Intermediates

In Excel Shortcut Keys for Intermediates, we will explain the 10 more shortcut keys. With the help of the previous article, you are now much familiar with Excel Shortcut keys. Now we will explain another 10 shortcut keys to speed up your working. Please Note: – Your mind will take few days to store these all shortcuts,

Read More »
Advance Excel Shortcut Keys
Excel Shortcuts

Advance Excel Shortcut Keys – Microsoft Excel

The topic Advance Excel Shortcut Keys will be very easy to understand if you have learnt our previous articles of excel shortcuts (Excel Shortcut keys for beginner and Excel Shortcut keys for Intermediates). Now we will explain another 10 shortcut keys to speed up your working and this is the last group of shortcut key after learning that article you

Read More »
How to use VLOOKUP in Excel - free explanation-min
Excel Formula

How to use VLOOKUP in Excel – free explanation

What is VLOOKUP: – In VLOOKUP, V stands for vertical and with the help of this formula, we can retrieve the matched value from the selected cells(table array) from left to right means in vertical order. It supports approximate and exact matched value. It can only look up and retrieve the values in the vertical order.

Read More »
HLOOKUP in Excel - Explanation with example-min
Excel Formula

How to use HLOOKUP in Excel -Free Explanation

HLOOKUP in Excel: In the HLOOKUP Function “H” stand for horizontal and with the help of this formula, we can retrieve the matched value from the selected cells(table array) from up to down means in horizontal order. It supports approximate and exact matched value. It can only look up and retrieve the values in the horizontal

Read More »
IF-Function-in-Excel-Explanation-with-example
Excel Formula

IF Function in Excel – Free Explanation with example

IF Function in Excel: – The “IF” Function in Excel is a logical test, which represents the result in two ways if the logical condition true and false. There is always two way of getting the value, one is when we got our condition/logic true and another we will get when the condition/logic false. We

Read More »
GST Quotation Format – Free Dynamic Excel sheet
Excel Template

GST Quotation Format 1.0 – Free Dynamic Excel sheet

GST Quotation Format in Excel As per the new taxation system in India, Every registered dealer under GST has to make the invoice in the new format (GST Invoice Format)as per guided by Central Govt. or GST Act 2017. If the businessman wants to provide the price to the other business to get an order

Read More »
GST Invoice Format 3.0 - Free Dynamic Excel sheet
Excel Template

GST Invoice Format 3.0 – Free Dynamic Excel sheet

Nowadays, In India, The seller must have to register under the GST act, who has a turnover above Rs 40 lakh within the financial year. So every seller needs a GST invoice format. We have provided solutions for all sellers all over India. It is a dynamic GST invoice format in excel. GST Invoice Format

Read More »
Cash Book Template 1.0 - Free Dynamic Excel workbook-min
Excel Template

Cash Book Template 1.0 – Free Dynamic Excel workbook

Offline Cash Book Template in Excel In Cash Book Template you can record your daily cash transactions. The payment of cash and receipts of cash. You can use it as personal as well for your business.  Feature of Offline Cash Book Template in Excel  1 Life-Time Free Excess of 1.0 version 2 Dynamic Excel Workbook

Read More »