Page Border in Excel - Steps use to apply a border to an Excel sheet | How to Apply Border In excel

 Step 1: Open Excel on your computer. you can use window + r for open run command and then write excel here for open MS-Excel and press ok

Step 2: Take a blank document 

 

Step 3: Now When You get a blank document click on page layout mode at the bottom right corner 

After that, you will get a layout like this 

Step 5: Now take the Rectangle tool to draw a simple rectangle 

Now simply Draw an icon of rectengle

Step 6: Set Page Layout to narrow

After that you can see simple arrow icon upon ruler just drag it to up

Step 7: Now you can drag rectangle to top left corner properly

Step 8: Now fit the all corners of rectangle to the page

Step 9: Now go to the format and set fill to no fill

Step 10: Now set shape outline go to More lines 

Step 11: Now in the format shpae set dash border

Step 12: Now go to files

Now go to print option and you can see border on page

Step 13: Now save the file At the location which you want

Last Output

Tags

how to put a border around excel spreadsheet,

how to apply a solid line border to a chart in excel,

how to add borders in excel 2016,

how to add borders in excel 2019,

excel remove border around print area,

excel show page borders,

Different Between to dates in excel | MS-EXCEL Tutorials

 First Write your data if you don't have data then you can use any dummy data or copy from below

You can copy dummy text from here

Start   Date	End Date	Completed Years	Completed Months	Completed Days
01-01-2020	02-01-2022
02-01-2020	03-01-2023
03-01-2020	04-01-2028
06-08-1999	28-12-2020

Now in the cell of completed years write the formula =DATEDIF(B3,C3,"Y"). B3 Indicated the starting date and C3 indicated to end date. When you want to know diffrence about years then use "Y" If Months Then use "M" and if you want to check days then use "D"

Now you can drag it for all rows

Now moving to months =DATEDIF(B3,C3,"M")

Now Moving to days =DATEDIF(B3,C3,"D")

You can use this formula for checking bulk age at onece 

Tags.

how to calculate difference between two dates and times in excel.

number of days between two dates excel.

excel date difference in months,

excel formula to count days from date to today,

datedif excel,

excel formula to calculate number of days between today and another date,

excel between two dates,

days between dates excel,

Balance Maintain Sheet Create In Excel for Partner

 Balance Maintain Sheet Create In Excel | How to create a balance sheet in excel for Partner

Dear Viewer in this video we Learn How to Create a balance sheet in excel for Small Partnership Firm/ Balance Sheet Excel Template with unique formatting & Column option, So guys must Watch Complete Video because it's Every Part very Useful. Thanks. ................. For Getting Latest Video Update Subscribe our YouTube Channel: - https://www.youtube.com/educationaltree/?sub_confirmation=1 Like Our Facebook - https://www.facebook.com/EducationalTree Share this video to your Friends & Family …........... #Balance_Sheet_Excel_Template #Educational_Tree

Index | How to Make Index for notebook | Create Index In Excel

Index | How to Make Index for notebook | Create Index In Excel

Dear Viewer in this video we Learn How to Create Index Format for notebook /Create Index In Excel / Excel Template with unique formatting & Column option, So guys must Watch complete Video because it's Every Part very Useful.

Thanks. ................. For Getting Latest Video Update Subscribe our YouTube Channel: - https://www.youtube.com/educationaltree/?sub_confirmation=1 Like Our Facebook - https://www.facebook.com/EducationalTree Share this video to your Friends & Family …........... #Excel_Template #Educational_Tree

Time Schedule | How to Make Time Schedule Format In Excel

Time Schedule | How to Make Time Schedule Format In Excel

Dear Viewer in this video we Learn How to Create Time Schedule Format for Manage your Time / How to Make Weekly Time Schedule Format In Excel, with unique formatting & Column option, So guys must Watch complete Video because it's Every Part very Useful.

Thanks. ................. For Getting Latest Video Update Subscribe our YouTube Channel: - https://www.youtube.com/educationaltree/?sub_confirmation=1 Like Our Facebook - https://www.facebook.com/EducationalTree Share this video to your Friends & Family …........... #Time_Schedule #Educational_Tree

How to Maintain Contacts in Excel

 How to Maintain Contacts in Excel - Basic Data Entry

Dear Viewer in this video we Learn How to maintain many Contacts In Excel/ How to do data entry work ?/ How to do data entry job?/ How to do Basic Data Entry with unique formatting & Column option, So guys must Watch complete Video because it's Every Part very Useful. Thanks. ................. For Getting Latest Video Update Subscribe our YouTube Channel: - https://www.youtube.com/educationaltree/?sub_confirmation=1 Like Our Facebook - https://www.facebook.com/EducationalTree Share this video to your Friends & Family …........... #Basic_Data_Entry #Educational_Tree

Sale Invoice Template | How to Create GST Sale Invoice in Excel

Sale Invoice Template | How to Create GST Sale Invoice in Excel

Tax Invoice | how to create tax invoice in excel step by Step | Tax invoice template

 

Dear Viewer in this video we Learn How to Make sale invoice template in Excel with unique formatting & Column option, So guys must Watch complete Video because it's Every Part very Useful. Thanks. ................. For Getting Latest Video Update Subscribe our YouTube Channel: - https://www.youtube.com/educationaltree/?sub_confirmation=1 Like Our Facebook - https://www.facebook.com/EducationalTree Share this video to your Friends & Family …........... #Sale_Invoice #Educational_Tree

How to Make Price List Template

 How to Make Price List in Excel with GST Rate Calculation | Price List Template

Dear Viewer in this video we Learn How to Create price list format in Excel with GST Calculation, this Template very helpful for sales Persons/Firms, with unique Tricks, formatting & Column option, So guys must Watch complete Video Because it's Every Part very Useful. Thanks. ................. For Getting Latest Video Update Subscribe our YouTube Channel: - https://www.youtube.com/educationaltree/?sub_confirmation=1 Like Our Facebook - https://www.facebook.com/EducationalTree Share this video to your Friends & Family …........... #Price_List #Educational_Tree

Maintain Bank Balance In Excel With Transaction

 How to Maintain Bank Balance In Excel With Transaction

Dear Viewer in this video we Learn How to Maintain Multiple Bank account detail, transaction, balance & other Details in excel, With unique formatting & Column option, So guys must Watch complete Video because it's Every Part very Useful. I hope this video helpful for create this template in excel. this video only for Information. Thanks. ................. For Getting Latest Video Update Subscribe our YouTube Channel: - https://www.youtube.com/educationaltree/?sub_confirmation=1 Like Our Facebook - https://www.facebook.com/EducationalTree Share this video to your Friends & Family …........... #Educational_Tree,

#Maintain_Bank_Balance,

How to Print Multiple Envelopes with different Address | Learn Mail Marge

Print Multiple Envelopes with different Address

Option -1

How to Print Multiple Envelopes with different Address | Learn Mail Marge

Dear Viewer in this video we Learn How to Print multiple envelopes with different Addresses With Use mail marge Option in Microsoft Word with Best formatting, So guys must Watch complete Video because it's Every Part very Useful. Thanks. ................. For Getting Latest Video Update Subscribe our YouTube Channel: - https://www.youtube.com/educationaltree/?sub_confirmation=1 Like Our Facebook - https://www.facebook.com/EducationalTree …........... #Print_Multiple_Envelopes #Mail_Marge #Educational_Tree

Stock Maintain In Excel

Stock Maintain In Excel

Dear Viewer in through this post we have sharing some videos for Maintain Stock In Excel. from these video you will get an idea for Create a stock maintenance format as you want. we will also share this template for your practice & learning. in end of this post. before using these template must watch complete video without skip any part. because in this video you will also learn How to create table, How to use hyperlink option in excel, how to use table formatting option, etc. 

Example 1

How to Maintain Stock In Excel In Hindi | Create Stock Maintain format in excel With Example

 

Example 2. 

How to maintain your stock in excel Step By Step | Stock Maintain In Excel 

@@@

 

Example 3. 

How to Maintain Stock in Excel | How to Create Stock Maintain format in excel

 

Template Download Link : #Stock_Maintain_Format

Must subscribe Our YouTube Channel and Our Gyanniti Blog  

How To Maintain Daily Expense In Excel

Maintain Daily & Monthly Expense/ Petty Cash

How to Maintain Daily And Monthly Expenses With Category & Daily Breakup | Petty Cash

Hello Viewers: In This Video Tutorial We will learn how to maintain Daily and Monthly Expenses in Excel with Multiple Categories and Complete Detail. Through this Video we will also Learn Very Useful Point of Excel Like a Formatting, Table Creating, Freeze Panes, Printing Setting, etc. so Viewer must watch this video because it's Every part is Very useful you.

How to Maintain Daily Expenses in Excel | Expenses Record Maintain in Excel

This is 2nd Template for Basic Learner In This Video Tutorial We will learn how to maintain Daily

Expenses

Dear Viewer, I hope both videos very helpful for you. kindly provide your valuable feedback and suggestions in the comments box. and Subscribe to our youtube channel.

Thanks

Pending Orders Maintain Template

How to Maintain Sales Order/ Pending Order List In Excel

Dear Viewer In This Video We Learn How to Maintain All Type Order In Excel. Like a Pending Order, sales Order, Processed order, Delivered Order etc. With Customer Details, Marketing. Person Details,  etc. With Some modification you can easily Maintain your All type order. We have share this Template with you. for your Practice or Easily create this template. before using this template must watch Complete video because this video is very helpful for making & using this template. 

Thanks

……

Pending Order List

#GyanNiti #PendingOrders, #orderlist, #salesorderlist

Excel - Sale Purchase Profit Loss | How to Make Sale Purchase Profit Loss Sheet In Excel

STEP 1: Open MS Excel

STEP 2: Press WIN + R Than Type excel and press enter 

STEP 3: When excel will open write a list of your product in collum with their serial number, net leave one collum and to another collum write purchase quantity and price with GST. and leave a collum for the total amount. in the next write sale quantity and price with GST. and leave a collum for the total amount.

(See image below)

STEP 4: To calculate the total amount of purchased items select cell of the total amount and write code =D5+E5 and than press enter. after that, you will get a total amount of items/products in the cell. do the same for sale collum. After all, you have to create the balance table for stock where your unsold item/products will list. to do this select cell of the purchase amount than - with the cell of sale amount than you will get balance stock (=D5-H5) create collum for the purchase amount and select the same cell of purchase with GST cell (by Applying =E5). to get the total amount of balance stock. multiply the purchase price with balance quantity (=M5*L5).

(See image below)

STEP 5: Now do the sum of purchase's total amount & sale's total amount. by using "SUM" formula (=SUM(F5:F9)) do the same in the Sale's & Balance's Table.

STEP 6:

Now: Purchase - Sale = Profit/Loss.

Now you will get the Sale Purchase Profit Loss Spreadsheet.

Thanks for Visiting

Download - Sale Purchase Profit Loss Spreadsheet