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

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...