Thursday, April 30, 2020

How to Make First Presentation in MS-PowerPoint? If your interest in Des...

In MS- PowerPoint the First method to learn about Presentation you know about SLIDES. How to insert,delete & duplicate slide in PowerPoint?

There are many tools use in #PowerPoint to make a beautiful #Presentation. The #'TEXT BOX' is the main part of it. With the help of #Text Box u can write any text or numbers with different colors, #Change the Outline, #Change the Effects. U can #Rotate,#Delete,#Move,#Size & change the different Styles.

Another thing in Home Tab is FONT. U can change font styles, #Size, #Color, #Bold, #Underline &# Italic etc. U also change the #Text Alignment : Center,#Left & Right. If in your Presentation has many Points, u can use #Bullets or Numbering.
After making Presentation u can show your slide to Slide show or press F5.
& Save in PPT Format.

Presentation are many types: You can make Presentation related Sports, Cars, Bike, Schools, Colleges, Product, Movies, Introduction etc which use in All office Meeting.

You tube: https://youtu.be/LtMuQmJYBxE
Guys This video for Beginners Students.
If Guys You have any doubt You Can Mail:
samrattechnologies1@gmail.com

follow us on Facebook, Instagram, Link din, Twitter.
Like & Subscribe this Chanel for More Trending Latest Technologies Related Videos.


Thanks & Regards
Samrat Technologies

Unit-8 Work with Inventory & Stock Manage

Unit-8 Work with Inventory & Stock Manage

#Inventory Info,#Stock Group,#Stock Item,#Unit Measure,#Transaction in Purchase / Sale.
 Hi guys This Video Related #Stock manage in Tally ERP 9.
In This video you Learn Inventory Management in Tally
How To Create #units According Business.
How you Create #Stock Group?
How to Add Stock #Items in Business
How to Purchase in #cash / #credit with stock.
How to sale in #cash / #credit with stock
These Stock Management Entries very important for all business in that you can Manage all stock which you have pending or sale.so guys See this lec. complete.
If Guys You have any doubt You Can Mail:
samrattechnologies1@gmail.com

follow us on Facebook, Instagram, Link din, Twitter.

You tube : https://youtu.be/84RaRn91XWU
Youtube:https://youtu.be/NMowUkgO-_8

Account More Videos: https://www.youtube.com/channel/UCs7V...
Like & Subscribe this Chanel for More Trending Latest Technologies Related Videos.


Thanks & Regards
Samrat Technologies

Wednesday, April 29, 2020

Accounts Transactions Related Purchase, Sale, Purchase Return, Sale Retu...

Accounts Transactions Related #Purchase, #Sale, #Purchase Return, #Sale Return, #Discount.
These are very important Transactions for Business
When we do any purchasing/ Sale  Related Which Business you have that Entry should be credit or cash you do transactions in Purchase mode/ Sale mode.
When Some goods return to us use credit node sale return.
When we return goods to person use debit node purchase return.
also we use discount Receive and Discount allow.
Shortcut use: Purchase F9, Sale F8, Debit Note Ctrl+F9, Credit Note Ctrl+F8, F5, F6.
For Practice i ll send you Blog Link you copy that exercise for practice.
 https://samrattechnologies.blogspot.com/
Dear These are Basic Transaction which u apply and clear your doubts for transactions.
if you have any doubt follow us on Facebook, Instagram, link din
also use mail for any doubt: samrattechnologies1@gmail.com
Like & Subscribe Chanel for more Updated  Videos & notifications.

 you tube: https://youtu.be/OJ-49m4m3vU


Thanks & Regards 
Samrat Technologies

Tuesday, April 28, 2020

How to Create a 'Pivot Table Report' in Excel & show Data Presenting in ...

How to Create a 'Pivot Table Report' in MS-Excel when you are in any Meeting where need fast Data Presentation.  

You can easily arrange #Summarize & #Complex data in #EXCEL. You can use #Sum,#Average,#Count,#Min,#Max,#Product without using Formulas. Also #Data Sorting & Filter Color wise or #Ascending/#Descending wise. U can also use #Pivot Chart like #Pie Chart, #Column Chart, #Bar Chart & #Line Chart etc. You can use Number Formatting like #Currency,#Accounting,#Percentage, #Date & Time Format. In Pivot Table u can use the #SLICER & #TIMELINE for sort the Date wise data.
In short we can find any Value from #Complex data to show in our Presentation. Also show data #Filter & Sort the #Date wise, #Product wise, #Name wise, #City wise, #State wise, #Country wise etc.
This is the Very ADVANCED option in MS-EXCEL which use in every Private #Company, #Banks, #Colleges, #Schools & Multinational Companies.
This Video is very important who work in MNC's and if they have to need show data in Meeting.
 Guys Like & Subscribe You Tube Chanel if you Interested ore Notification and Learn Something  New.
You tube: https://youtu.be/tGBf0AlXyZg


Thanks & Regards 
Samrat Technologies

How to Manage Accounts with Tally ERP 9.0.?

How to Manage Accounts with Tally ERP 9.0.?

Unit 1- 4 Work with Tally ERP 9.0
#Accounts Info, #Company Creation, #Accounting Ledgers Creation, #Accounting Vouchers,#Contra, #Payment, #Receipt, #Journal
#Shortcuts: Alt+F3, F11, F12, F4, F5, F6, F7
 Hi guys This Video Related Accounts manage in Tally ERP 9.
In This video you Learn
1. How Many Type use to manage Accounts.
2. How to create Company in Tally ERP 9.
3. How to Make Ledgers to do Transactions.
4. Accounting Vouchers Transactions in #CONTRA, #PAYMENT, #RECEIPT, #JOURNAL.
These are Basic Entries for Beginners, after this Step we go for advance step.
In Second Video I will send you Exercise for  practice.
If Guys You have any doubt You Can Mail:
samrattechnologies1@gmail.com
follow us on Facebook, Instagram, Link din, Twitter.
You tube : https://youtu.be/84RaRn91XWU
Like & Subscribe this Chanel for More Trending Latest Technologies Related Videos.
This Lect. is Fast according Student Requirement in this you can use more concept.

Regards
Samrat Technologies

Monday, April 27, 2020

How to Calculate EMI(Equity Monthly Installment), Interest, Principal Va...

How to Calculate #EMI(Equity Monthly Installment), #Interest, #Principal Value when u take a Loan?

In ADVANCED EXCEL we will calculate the Loan EMI, Rate of Interest & Principal Value on any Product with the Latest Formulas of #PMT, #PPMT & #IPMT.
You can Calculate these Financial Functions in any Loan Product like #Mobile, #Car Loan, #Vehicle Loan, #Home Loan, #Education Loan, #Electronic Products, #Gold Loan etc.
You can easily calculate how many interest have to pay?
Calculate the how many EMI pay & which value to pay?
U can also calculate the Principal Value with every month or Year wise.
This is very Important Formulas in #Banking sector, #Financial Sectors.
Hi Guys This is very Interesting Video for more Notifications and Oher Advance Lectures Like & Subscribe You Tube Chanel
https://www.youtube.com/channel/UCs7V...

Excel: https://youtu.be/cUE3jRO34mo
Any other Doubt Follow us Instagram or Facebook
Email: samrattechnologies1@gmail.com



Thanks & Regards
Samrat Technologies

Sunday, April 26, 2020

3 Latest Trending Text Effect Animation Ways.

3 #Latest #Trending #Text  Effect Animation Ways.

#Intro Text Animation Effect, #Exit Text Animation Effect,#Typewriter Text Effect,  #Hand writing Text  Effect Animation.

In This video You Can use Font Type Tw Cen MT, Consols, Century, Gothic, Segoe print.
in this video you can use Animation like #wipe, #fade, #Appears, #Fly In, #Fly Out, #Custom, #Zigzag etc
These are Very Effective animation you can use these animation to Decorate your Presentation very smoothly.
Hand writing Effect you can use in white Board Animation Video if you not

See Guys  Click: https://youtu.be/nNSKANX0es8
This is very interesting video so See this video full complete.
and also like & Subscribe our you tube Chanel  Thats why you get more notification of latest  Trending Videos.
You Tube:  https://youtu.be/VO6xhkklbZQ


Thanks & Regards
Samrat Technologies

Saturday, April 25, 2020

In Excel How to make Attendance Sheet of Student or Employee with the he...

How to make a #Attendance Data in Excel when you do #Clerical Job in any Company, #School/Colleges, #Banks, Govt./ #Private Sector, #Show room, in #Factory etc.
You can make a Data for Maximum no.s of Persons & #Month wise, #Week wise, #Year wise or Day wise. U can Calculate How many days come in office  any people with % wise & Color wise description. 
Here we use Latest Formula of 'COUNT-IF' 'Percentage', #Sum & Conditional #Formatting tool.
Youtube: https://youtu.be/I4SCnwb1U60

Guys for More Notifications Like and subscribe our you tube Chanel.


Thanks & Regards 
Samrat Technologies

Friday, April 24, 2020

How to Add CHARTS in Excel? There is many type of CHART like Column Char...

How to Add CHARTS in Excel? There is many type of CHART like Column #Chart,#Pie Chart, #Line, Bar etc. 
When you are giving Presentation with data in any Sector, any Office, any Meeting Hall, You can use CHARTS with effective color & Formatting.

There are many types of CHARTS use in different type of data. #Column Chart, #Line Chart, #Bar Chart & #Pie Chart. You can use this tool to Comparison, Dividation, Horizontal, Vertical, Circle.

In the Office when u use Presentation u can Insert the CHARTS with the #Marks Sheet data, #Sale data, #Population data, #Product data, #Loan related data, #Stock related data, #Job related data, #Votes related data.

U can use this option to various purpose like: In Presentation, In #News Paper, #Books, #Printing, #Mail, #Social Media etc.
So this is the Most Important option in MS-EXCEL.

youtube: https://youtu.be/OqNM-kj1IGo

Guys for more notifications like & Subscribe the you tube Chanel.


Thanks & Regards
Samrat Technologies

How to Create White Board Animation Effect in PPT.?

How to Create White Board Animation Effect in PPT.?

#Create Motion with Picture, #Add Zigzag Animation to #Decorate,#Without #Hand Drawing Create Motion with Picture.
For motions, Effects and decorative Animation you can use MS-Office:( 2010, 2013, 2016)
Guys You Can use these Effects to Decorate your Presentation very Representative Way.
This is your Creativity of your Mind to Decorate any presentation.
Last Video You were using Spotlight Effect if you not see that video Click

You Tube: https://youtu.be/zpcdJ3W8Bb4

White Board Animation Effect Click: https://youtu.be/nNSKANX0es8

Guys if you like this Video You Like and Subscribe the Chanel. that's why you Get more Notifications.


 Thanks & Regards
Samrat Technologies

Wednesday, April 22, 2020

How to Insert, Delete, Hide, Unhide the Row & Column in Excel. ?

How to Rows, Columns to #Insert, #Delete, #Hide, Unhide. #Increase or #Decrease the Row Height, Column Width. 
How to Insert, Delete, Rename, Move, Copy, Protect, #Tab Color the Worksheet.
We can use this option to any Data which u want new Rows & Columns in between the data.
Some Data don't show while Presentation, you can easily Hide or Unhide.
#In Printing which data u want to print rest data will be hide.
In #bigger data where use maximum Rows & Columns, U can Increase or #Decrease Row Height & Column Width.
You can Organizing the sheet : #New Sheet #Create,# Delete Sheet, #Rename Sheet, Security where not to do any text, Move Sheet, Copy Sheet, Color change of Sheet.

These are the Major Tool which we have to use daily basis on Data.

Regards
Samrat Technologies

How to Create a Animated Spotlight Effect in MS-Power Point.?

How to Create a Animated Spotlight Effect in MS-Power Point.?

#Create a Spotlight Effect, #Add Animation on Spotlight Effect,#Moving One Point to another Spotlight Effect.
Use Merge Option First Click on Slide Then Press CTRL Key Then Select Circle then Choose Merge than Subtract.
This is very Interesting Video for Those Students who are Creative also Interest in Designing.
Many more Animation and Effects we can Discuss with you Next Videos Session.
Spotlight Effect you must use to make your Presentation Decorative and Creative.

You Tube: https://youtu.be/zpcdJ3W8Bb4

Guys if you like this Video You Like and Subscribe the Chanel. that's why you Get more Notifications.


Thanks & Regards
Samrat Technologies

Tuesday, April 21, 2020

How to do Data Sorting,Data Filter, Data Find, Data Replace,Data Clear.

How to do Data Sorting,Data Filter, Data Find, Data Replace,Data Clear.

You can #Alphabetic & #Numerical Data Sort which u use #Ascending,#Descending order, #Color wise Data sort.
You can also do Data Filter like any #Fees data, #Sales Data, #City wise, #Product wise, #Qty wise, #Price wise, #Name wise, #Class wise, #Country wise check the data.
You can find the any data or Replace.
Also Clear the Content, Clear All, Clear Format. 

you tube: https://youtu.be/PJDMFHyTeGE

Dear Friends if you Like this vIdeo Like & Subscribe you Tube Chanel . Thats why you get More Videos Notifications


Thanks & Regards 
Samrat Technologies

Day 2: Identifiers in C Language.

Identifiers in C Language. 

#Identifiers, #constants, Variables, #Keywords, #Instructions.
This video for Beginners Students but in this Session we will Discuss more Concepts Related Programming Language, 

also we can write first base C program in Dev c++ software.
Last Video we Discuss History of C language.
Why C language is so Important.?
to listen last Session click this play list:
https://www.youtube.com/watch?v=mTHyh...

click : https://www.youtube.com/watch?v=mTHyh...

 for First C Program how to run in Dev c++ s/w click:
https://youtu.be/-V5AcWhSbCY

Guys if you Like this Video then Like & Subscribr the You tube Chanel of Samrat Technologies. Thats why you get more Notifications Related C Programming.



Thanks & Regards 
Samrat Technologies

Monday, April 20, 2020

Why C Programming is so Important.?

What is C Programming?
Why C Programming is so Important than other language.?

#C is very Important Language in the world. Many #software , #Operating System, #Device Drivers written in c programming.
Like #Oracle Data base, #MY SQL Data Base, #Web Browsers,#Hardware Device Drivers,etc  also written in c Programming Language.
 In this Video You Can Learn History of  #BCPL Language, #B Language, #C Language
C programming Covers your Basic Feature of all, concepts than other Programming.
C is More #Secure, #Portable, #Compatible programming Language.
#Unix OS also made in C Prog.
This is theory video. Next Video We will Covers more Practical Sessions.

you tube: https://youtu.be/mTHyhaZM-H0



 Thanks & Regards 
Samrat Technologies

How to use Conditional Formatting in MS-EXCEL?


How to use Conditional Formatting in MS-EXCEL?

#Highlight Cell,#Top Bottom Rule, #Data Bar, #Color Scale, #Icon Sets,#Remove Conditional Formatting, Clear, #Editing, #Use Condition of #Greater Than, #Less Than,#Equal to, #Between.

Where to use Condition Formatting.?

To Create #Attendance Data, Show #Highest Lowest Sale Data,#Highlight Top Items | Bottom Items, Use Data Bar in #Mark Sheet data, #Sale Data,Income & #Expense Data,Stock #Product,#Qty , Price.
To #Show Date Related Data, To show #Duplicate Values,To show Highest & Lowest Score Runs,Sales, Marks, etc.

You Tube: https://youtu.be/yT4view8gSc

MS-EXCEL is Most Important software that everyone get a knowledge who want to do Business, or job..in every Field Excel is used for making Data for #company Record Maintaining or #Sale Maintaining etc.
#Making Salaries, #Balance Sheet, #Sale Data, #Budget Data, #Loan Data, #Profit & Loss Calculation etc. in each & every Field we can use MS- Excel.


Regards
Samrat Technologies

Sunday, April 19, 2020

How to use Percentage Calculation in MS-EXCEL .?


How to use Percentage Calculation in MS-EXCEL .?

You can use #Percentage #Calculation in Many Different Fields Like
#Marks Sheet Data, #Sale Incentive Data, #Company #Bonus Data, #Loan Interest Data, #Company #Production Data, #Price List Data,#Salary Calculation Data, #Share #Market Data, #Banking Data, #Product Margin Data, Calculate #Population Data, Calculate #Voting Data etc.

Lecture By: Mr. Samrat Singla, Samrat Technologies India Pvt. Ltd.

MS-EXCEL is Most Important software that everyone get a knowledge who want to do Business, or job..in every Field Excel is used for making Data for #company Record Maintaining or #Sale Maintaining etc.
#Making Salaries, #Balance Sheet, #Sale Data, #Budget Data, #Loan Data, #Profit & Loss Calculation etc. in each & every Field we can use MS- Excel.

Category: Education

YouTube Link: https://youtu.be/5aRAsErdlLA

Website Link: www.samrattechnologies.com

Learn Latest MS- Word: https://www.youtube.com/playlist?list...

Learn MS-Excel: https://www.youtube.com/playlist?list...

Guys Like & Subscribe Samrat Technologies you tube Chanel to get more Videos....:-)
To Get More Knowledge if You Not Listen Last Day Session Click on Link Which Describe on above of Text,Thats why you complete your task .



Thanks & Regards
Samrat Technologies
No.1 IT Training Institute.

Saturday, April 18, 2020

How to do Official Base Calculation in MS-EXCEL .?


How to do Official Base Calculation in MS-EXCEL .?

#SUM FORMULA, #AUTO SUM, #SUBTRACTION, #MULTIPLY, #DIVIDE
,#COUNT,#AVERAGE,#MAX / MIN,#FORMULA COPY. etc
Lecture By: Mr. Samrat Singla, Samrat Technologies India Pvt. Ltd.
MS-EXCEL is Most Important software that everyone get a knowledge who want to do Business, or job..in every Field Excel is used for making Data for #company Record Maintaining or #Sale Maintaining etc.
#Making Salaries, #Balance Sheet, #Sale Data, #Budget Data, #Loan Data, #Profit & Loss Calculation etc. in each & every Field we can use MS- Excel.

Category: Education

YouTube Link: https://youtu.be/5aRAsErdlLA
Website Link: www.samrattechnologies.com
Guys Like & Subscribe Samrat Technologies you tube chanel to get more Videos....:-)

Regards
Samrat Technologies


Friday, April 17, 2020

How to do Data Maintaining


How to do Data Maintaining & Formatting in MS-EXCEL 2019.?
#Data Formatting, #Alignment, #Clipboard,Font #Style, Font #Size,#Border setting, #Background Color, #Text Color,#Merge & #Center, Clip #Alignment etc.

Samrat Technologies
Website: www.samrattechnologies.com

Youtube link: https://youtu.be/EqXPHBEg1CA

Regards
Samrat Technologies

Thursday, April 16, 2020

How to do Page Setting in MS-Word File 2019?


How to do Page Setting in MS-Word File 2019?

#Page# Margins, page #Size, page #orientation, Page #Break, page# Line No.
Page #Columns, #Mirror Margin, Page #Gutter Position according #Binding.
Columns options can be used to convert sheet into multiple columns like for syllabus, table content etc.
Samrat Technologies
Website: www.samrattechnologies.com
youtube: https://youtu.be/jdr2BdyamQs

Regards
Samrat Technologies

Wednesday, April 15, 2020

How to do Security Protection and Recovery of Unsaved Document in MS-Wor...


How to do Security Protection and Recovery of Unsaved Document in MS-Word 2019.?
#Password #Protection to Word Document file, #Remove password protection,#Recover your unsaved #document .
These Security you can use when you have important document,and you want to be secure your file..

Website: www.samrattechnologies.com

Regards
Samrat Technologies

Tuesday, April 14, 2020

How to Apply Chart and Watermark in MS-Word.?

How to apply #chart and #watermark in MS-Word Document.Add #Chart,Edit Chart,Add #Water Mark, #Edit Watermark, #Logo Watermark, #Text Watermark,Page #Color with #Multiple Color, Page #Border, Picture #Border, Texture, Picture #Background, Multiple #Watermark etc.
These all Options used to make your Document Professional with Data...

https://youtu.be/96wOPBAaw4o

Regards
Samrat Technologies

Monday, April 13, 2020

How to use Header, Footer,Break of Page in MS-Word 2019

Header / Footer Used to make Document Professional,#Different Header Title used in MS-#Word, Also edit #Header & #Footer,#Remove Header & Footer, #Insert Page No. on Top, #Page No. #adjust according alignment, Page No according current position,#insert blank page etc..


Regards
Samrat Technologies

Sunday, April 12, 2020

How to Insert Different Objects in Ms-Word.?

#Object is used for Company #Project Report, #MIS Report, #Assignment etc. In Word Project Report if You want to use Excel #Spreadsheet, #Video, #Presentation, #Direct Text from other word File etc......
Object is very useful for Professional Official Documents.....

Regards
Samrat Technologies

Saturday, April 11, 2020

How to work with Picture & Shape Format in MS-Word 2019.?

Picture Formatting, Text writing on Picture & Shape, Picture Effect,Border Effects,Picture Positioning,Color Correction,Shape Change,Color, Texture Formatting,Border Thickness, Wrap Text, etc.. Where to use Picture & Shape Format: News Paper format,Book Format,To Make Assignment Professional,Company Documentation,Text Decoration,Cover Page Design,Magazine Design,Brochure, Pamphlet, Leaflet, etc.

Regards
Samrat Technologies

How to Work with Table in MS-Word

Table Formatting, Table Alignment, Table Design,Working with Excel Spreadsheet in Table,Text Formatting,Insert Rows, Insert Columns, Deleting, Merge cells, Split Cells, Split Table.etc

Regards
Samrat Technologies

Friday, April 10, 2020

How to use MS-Word 2019, Learn in 10 Min.

Microsoft Word Use for Data Entry & Office Management Work.
Home Tab use for Paragraph, Font Styling, Formatting, Bullets & Numbering, Heading Style, Find & Replacement.

Regards
Samrat Technologies

Sunday, April 5, 2020

PURPOSE IN LIFE

purpose in life

There are many Kind of Desire- Desire for Success,Desire to do one's Duty even at the cost of Pleasure.Desire for Purpose-something worth dying for which gives meaning to life.

what good is it if you gain the whole world and loose your conscience.?

A purposeless life is a living Death. What is your Purpose? Do you have one.?
Purpose Brings Passion.Find or Create a purpose then pursue it with Passion and perseverance.

Everyday we need to ask ourselves: " Am I getting any closer to purpose in my life.? Am i making this a better place to live? " if the answer is no,then we have just wasted a day of our life. Life will reward us in proportion to our contribution.

The Earlier we find a purpose in life, the better our life will be. The greatest Challenge lies in unending search for purpose of life,not only as an individual but also for our family, organization, & country.once our purpose & values are clear,Conflicts between self interest & social obligations find a moral balance among themselves.We become aware of when to take a stand.That is when we start a right making Decisions for long term rather than gain making the wrong decisions for short term gain.

Wisdom & Maturity lead to Greater understanding of major issues.


                                    "Study as if you were to live forever 
                                      Life as if you were to die Tomorrow."

                 " We can't help ourselves without helping others.
                    We can't enrich our lives without enriching others.
                    We can.t Prosper without bringing prosperity to others."

Janette Cole once said," Show me a Person who is content with mediocrity, & i will show you a person destined for failure." life is not Spectator sport. We can't sit back & watch things happen.

We need to find a purpose  in order to make life meaningful & strive to achieve that purpose


                                                                                                                                 Thanks & Regards
                                                                                                                                   Sheenu Singla



Featured post

Do i Need a Website for my Business

Do I Need A Website  For My Business? We live in a time where people use the internet for everything, from shopping to making bookings and s...