Tuesday, December 29, 2020

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

Monday, December 28, 2020

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,

Saturday, December 26, 2020

Marriage Invitation | Free Weeding Invitation Template

Tutorial How to Edit This

Preview

In This Tutorial, I'm Going to Tell You How Download & Use I'll Tell Complete Step By Step Tutorial Here.

Step 1: Click to Download Wedding Invitation Template

Step 2: Extract with WinRAR If You Don't Have! Download it By Clicking Here

Step 3: Open Font Folder & Install All Fonts

Step 4: Open Wedding Invitation Folder

Step 5: Open Wedding Invitation In Premiere pro. If Do don't Have! Download it from Adobe Site

Step 6: Wait till Project open it may take time

Then look below in tabs

Step 7: Now edit the text if you want to change the mantra then you can I'm skipping this part now. moving to the invitation text.

Now you can replace Mother Name And Father name Here.

If You don't know how to type in Hindi text! Then open this image this will help you

As of This, you can edit all the tabs.

When All edits will finish back to the main export sequence.

Step 8: Now you can Export Video File. go to File-> Export -> Media

Now you will get this screen Make sure here you can see "Main Export" and Then click here to set the output location

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

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

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.

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

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

How to make Curriculum Vitae In Word | Curriculum Vitae / Resume

BioData/ Resume/ Curriculum Vitae Template Creating In Word ......... Dear Viewer in this video we Learn how to Make a Unique Biodata/ Resume for Job, with unique 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 Share this video to your Friends & Family …........... #Curriculum_Vitae #Resume #Biodata

Tuesday, October 27, 2020

Java Tutorials with Practical Examples (Based on MCS-024 Important Topic)

How to Download and Install Java | JAVA Tutorial Part - 1

Hello Viewers: In This Video Tutorial We Provide Information About Java. & We Learn How to Download & Install Java Software in Our Computer. Also, we Learn How to Set #Java_Path in Computer. We Will Clear Most Useful topic Java Download & Installation Quarries.

----------------------------------------------

How to Write First Program in Java with Compile and Run | JAVA Tutorial Part – 2

In This Video Tutorial We Learn How to Write #First_Program In #Java_with_Compile And Run With #CMD using Notepad++. --- here is Video How To Download Notepad ++: https://youtu.be/N0SIXm0xyRY?t=319 Note: No Need To Download Emmet & Python Script For only Java

----------------------------------------------

How to Use Variable String and Numbers in Java | JAVA Tutorial Part – 3

In This Video Tutorial We Learn How to Use #Variable #String and #Numbers in #Java

----------------------------------------------

Java Data Types - What Is Data Types In Java | JAVA Tutorial Part – 4

In This Video Tutorial We Learn How to use #data_types in java. I will Explain here about #byte, #Short, #integers, #Long, #Float, #Boolean & #Char

----------------------------------------------

Java String & int - How to Use String & Int in Java, | JAVA Tutorial Part - 5

In This Video Tutorial We Learn How to Use #String & Int in Java. I will explain in this video #toUpperCase In Java, #toLowerCaseCase In Java, #concat In Java, #length In Java

----------------------------------------------

Java Math - How to Code Math in Java | JAVA Tutorial Part - 6

In This Video Tutorial We Learn How to Code #Math In #Java

----------------------------------------------

Java Boolean - How to use Boolean in Java | JAVA Tutorial Part - 7

In This Video Tutorial We Learn how to use booleans in java [true/false]

----------------------------------------------

Java if else - How to Use if Else in Java | JAVA Tutorial Part - 8

In This Video Tutorial We Learn How to use if else in java and also about else if in java

----------------------------------------------

Case in java - How to Use Case in Java | Java Tutorial Part - 9

In This Video Tutorial We Learn how to use switch case in java

----------------------------------------------

Java While Loop - How to use While Loop in java | Java Tutorial Part - 10

In This Video Tutorial We Learn While Loop in java for repetitive work

----------------------------------------------

Java For Loop - How to Use For Loop in Java | Java Tutorial Part - 11

In This Video Tutorial, We Learn how to use for loop in java for printing repetitive task

----------------------------------------------

Java Break & Continue - How to Use Break & Continue in Java | Java tutorial part - 12

In This Video Tutorial, We Learn about break & continue Break and Continue in While Loop in java, Break and Continue in For Loop in java, continue statement in java, #break statement in java, labeled break and #continue in java, break if statement java, do you want to continue in switch case in java, #decision making and looping in java, #continue in nested #for #loop java,

----------------------------------------------

Java Arrays - How to Use Array in java | Java Tutorial Part - 13

In This Video Tutorial We Learn Array in java and also variable type with square brackets in java, How to Access the Elements of an Array in Java, Change an Array Element In java, Array Length in java, Loop Through an Array in Java, Loop Through an Array with For-Each, Multidimensional Arrays in java, for loop in java with an array,

----------------------------------------------

Exception - What is Exception in Java | Java Tutorial Part - 14

In This Video Tutorial We Learn about the #exception in java Java Exceptions - Try...Catch, Java #try and #catch, #finally statement after try...catch in java, How to handle an exception in java

----------------------------------------------

Java Method - What is Method in Java | Java tutorials part - 15

In This Video Tutorial We Learn What is #Method in Java and how we use it

----------------------------------------------

Java Classes and Objects - How to use Classes and Objects in Java | Java Tutorial Part - 16

In This Video Tutorial We Learn Abou #class in Java and his #object with #attributes

----------------------------------------------

Java Class Methods - What is Class Method in Java | Java Tutorial Part - 17

In This Video Tutorial, We Learn about the class method in java Java Class Methods, static method in java, Static or Public class method in java, instance method java, Access Methods With an Object in java, java static, java constructor, how to call a method in java, methods in java, instance method vs class method java, static method in java example, What is Class Method in Java, Using Multiple Classes in java

----------------------------------------------

Java Constructors - How to use Constructors in Java | Java Tutorial Part - 18

In This Video Tutorial, We Learn A #constructor in Java is a #special #method that is used to initialize #objects. The constructor is called when an object of a class is created. It can be used to set initial values for #object #attributes

----------------------------------------------

Java Modifiers - How to Use Modifiers in Java | Java Tutorial Part - 19

In This Video Tutorial, We Learn java modifiers with examples, non-access modifiers in java, java modifiers Chart, the #difference between access #specifiers and access #modifiers in java, final keyword in java, #Access #Modifiers in java, Non-Access Modifiers in java, Static in java, Abstract in java,

----------------------------------------------

Java Encapsulation - How to Use Encapsulation in Java | JAVA Tutorial Part - 20

In This Video Tutorial, We Learn How to Use Encapsulation in Java. Why Encapsulation? Better control of class attributes and methods Class variables can be made read-only (if you omit the set method), or write-only (if you omit the get method) Flexible: the programmer can change one part of the code without affecting other parts Increased security of data

----------------------------------------------

Java Inheritance - What Is Inheritance in Java | Java Tutorial Part - 22

In This Video Tutorial, We Learn about #inheritance in #java

----------------------------------------------

Java Polymorphism - What is Polymorphism in Java | Java Tutorial Part - 23

In This Video Tutorial, We Learn About Java Polymorphism &. It is useful for code reusability: reuse attributes and methods of an existing class when you create a new class.

----------------------------------------------

Java Interface - What Is Interface in Java | Java Tutorial Part - 24

In This Video Tutorial, We Learn how to use interface in java. An interface is a reference type in Java. It is similar to a class. It is a collection of abstract methods. A class implements an interface, thereby inheriting the abstract methods of the interface. Along with abstract methods, an interface may also contain constants, default methods, static methods, and nested types.

----------------------------------------------

Java Enums - What is Enums in Java | Java Tutorial Part - 25

In This Video Tutorial, We Learn Enum contains a fixed set of constants. Enums are used to create our own data type like classes. The enum data type (also known as Enumerated Data Type) is used to define an enum in Java.

----------------------------------------------

Java User Input - How to Use Scanner In java | Java Tutorial Part - 26

In This Video Tutorial, We Learn how to take input from the user and process them with our program instructions

----------------------------------------------

Java Date and Time - How to Write Date and Time In Java With Formatting | Java Tutorial Part - 27

In This Video Tutorial, We Learn Formatting Date and Time, java date from the string, java get the current date without time, how to get the current time in java, How to Write Date and Time In Java, Display Current Date In Java, Java Date and Time, java date and time, Display Current Date and Time, java time example, Gyanniti, java date format, Date and Time In Java With Formatting

----------------------------------------------

Java ArrayList - How To Use ArrayList Package In java | Java Tutorial Part - 28

Hello Viewers: In This Video Tutorial We Learn How To Use ArrayList Package In java, Java ArrayList, Access an Item in Java ArrayList, #Add Items in Java ArrayList, Change an Item in Java ArrayList, Remove an Item in Java ArrayList, #ArrayList Size in Java, #Loop Through an ArrayList in Java, Sort an ArrayList in #Java

----------------------------------------------

Hashmap - How to Use HashMap in Java | Java Tutorial Part - 29

In This Video Tutorial, We Learn java hashmap implementation, java hashmap iterator, how to get values from hashmap in java example, hashmap java,

----------------------------------------------

Java Files - How to Create File Through Java | Java Tutorial Part - 30 A

Hello Viewers: In This Video #Tutorial We Learn java 11 create a file, how to create a file in #java, java create a file if #not #exist, java #create an #empty #file, java create a file in the #current #directory, file fileObj = new file(filename), create and write #data to a #file in java,

----------------------------------------------

Java Files - How to Edit and Write File Through Java | Java Tutorial Part - 30 B

In This Video Tutorial, We Learn how to update data inside a text file in java, edit specific line text file java, java write to a text file, how to replace a word in a text file using java, java save data to file, java write to file line by line, java write a string to file, java program to read a text file and write to another file,

----------------------------------------------

Mouse Listener - How to Make Mouse Listener in Java | Java Tutorial Part - 31

In This Video Tutorial, We Learn I will tell you How to Make Mouse Listener in Java Gyanniti, How to Make Mouse Listener in Java, How to use MouseListener event, how to add a mouse listener in JAVA?, How to programmatically fire a MouseEvent to a MouseListener, Java MouseListener, mouse listener program in java, mouse listener and mouse-motion listener in Java, mouse motion listener in Java, mouse click event in java swing example, #mouselistener java,# mouse listener in java applet, java #mouselistener not working, mouse event handling in java

Monday, October 26, 2020

illustrator Tutorials (Learn Toolbar)

illustrator Tutorials for Beginner

How to Use Toolbar In Illustrator Part - 1 (Pen tool, Selection tools)

Hello Viewers: In This Video We Learn some topics:-

1) How to use the Selection tool,

2) How to use the Pen tool,

3) How to create dynamic shapes,

4) How to use carve toll etc.

***

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

Sunday, August 16, 2020

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

Saturday, August 8, 2020

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

Friday, June 26, 2020

Application for Telephone Connection Transfer | टेलीफोन कनेक्शन हस्तांतरण के लिए टेलीफोन विभाग को आवेदन

Application to Telephone Department for Telephone Connection Transfer

Dear readers ! in this post we have provide a application format for Transfer your Telephone Connection

Application for Telephone/ Landline Plan Change | टेलीफोन / लैंडलाइन योजना परिवर्तन के लिए आवेदन

Application for Telephone/ Landline Plan Change

Dear readers through this Post we have provide you a application format for Change your Telephone Tariff Plan. Very Simple format.

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

Pages