Sponge Tool in Photoshop

In this video we can discuss about How to use Sponge Tool in Photoshop.

Sponge Tool:-
The sponge tool changes the color saturation & desaturation of an area.

Click the Below Link's and get the Photoshop Photos Using above Concept:-

http://www.mediafire.com/file/aro8ssm166fcsgx/photoshop_new_photos.rar

http://www.mediafire.com/file/ia8n29hkivshxr6/PS_PHOTOS.rar

Dodge & Burn Tools in Photoshop CC

In this video we can discuss about How to use Dodge Tool & Burn Tool in Photoshop.

Dodge Tool:-

The dodge tool lightens areas in an image.

Burn Tool:-

The burn tool darkens areas in an image.

The Dodge tool and the Burn tool lighten or darken areas of the image. These tools are based on a traditional darkroom technique for regulating exposure on specific areas of a print. Photographers hold back light to lighten an area on the print or increase the exposure to darken areas on a print

Click the Below Link's and get the Photoshop Photos Using above Concept:-

http://www.mediafire.com/file/aro8ssm166fcsgx/photoshop_new_photos.rar

http://www.mediafire.com/file/ia8n29hkivshxr6/PS_PHOTOS.rar

Smudge Tool In Photoshop CC

In this video we can discuss about How to use Smudge Tool in Photoshop

Smudge Tool:-
The smudge tool smudges data in an image.

The smudge tool is used to smear paint on your canvas. 

The effect is much like finger painting. 

You can use the smudge tool by clicking on the smudge icon and clicking on the canvas and while holding the mouse button down, dragging in the direction you want to smudge.

Click the Below Link's and get the Photoshop Photos Using above Concept:-

http://www.mediafire.com/file/aro8ssm166fcsgx/photoshop_new_photos.rar


http://www.mediafire.com/file/ia8n29hkivshxr6/PS_PHOTOS.rar

How to use Blur & Sharpen Tool's in Photoshop

In this video we can discuss about How to use Blur tool & Sharpen Tool in Photoshop

Blur Tool:-

The blur tool blurs hard edges in an image.

Sharpen Tool:-

The sharpen tool sharpens soft edges in an image.

In this Tools apply the Color Shapes & Images

Click the Below Link's and get the Photoshop Photos Using above Concept:-

http://www.mediafire.com/file/aro8ssm166fcsgx/photoshop_new_photos.rar

http://www.mediafire.com/file/ia8n29hkivshxr6/PS_PHOTOS.rar

How to use Gradient Tool in Photoshop CC

In this video we can discuss about How to use Gradient Tool in Photoshop.

Which topic's in this Video.

* What is the Gradient Tool

* Default Gradient Color's

* Gradient Settings

* Gradient Styles

* Custom Gradient Colors

* Adding Custom Gradient Colors

* Modes

* Opacity

The gradient tool allows you to fill an area with specific range of colors, with a defined pattern. 

Right click on paint bucket in toolbar. 

Click and drag the mouse from one point in image to the other. The image will be filled with the color. 

You can select colors from gradient. You can make shades accordingly. Drag and move the colors close to the gradient. 

Save the name from gradients. The gradient can be changed by clicking on it. These can be replaced by the current gradients. 

The type of gradients can also be changed. The settings of photoshop will be used for applying gradient.

Click the Below Link's and get the Photoshop Photos Using above Concept:-

http://www.mediafire.com/file/aro8ssm166fcsgx/photoshop_new_photos.rar


http://www.mediafire.com/file/ia8n29hkivshxr6/PS_PHOTOS.rar

Protect Sheet In Ms-Excel

In this video we can discuss about how to protect Excel Sheet.

Syntax:-

* Office button

* Prepare

* Encrypt Document

* Enter the Password (2 Times)

* Save

Insert, Delete & Format Columns & Rows

In this video we can discuss about how to insert & delete cells , Format & size Columns & rows in our Sheet.

Insert cells:-

Insert cells, rows,and columns into the table or sheet.

Delete cells:-

Delete cells ,rows, and columns from the table or sheet.

Cell Styles in Ms-Excel

In this video we can discuss about How to use Format as table & apply the cell styles

Cell styles:-
Quickly format a cell by a choosing from predefined styles.
You can also define your own cell styles.

Conditional Formatting In Ms-Excel

In this video we can discuss about How to use Conditional Formatting in our Sheet.

1. Conditional formatting:-

Highlight interesting cells, emphasize unusual values, and visualize data using data bars, color scales and icon sets based on criteria.

2. Format as Table:-

Quickly format a range of cells and convert it to a table by choosing a predefined table styles.

Number Group Options in Ms-Excel

We can discuss the above video How to change format of cells.

Choose the format your Cells (Cell, No of cells, Column, No of columns, Row, No of rows) such as

* General

* Number

* Currency

* Percentage

* Short date

* Long Date etc..

Percent style (ctrl + shift + %) :-

Displaying the value of the cell as a percentage.

Comma style:-

Displaying the value of the cell with a thousands separator.

Increase decimal:-

Show more precise values by showing more decimal places. 

Decrease decimal:-

Show less precise values by showing fewer decimal places.

Count Formulas in Ms-Excel

In this video we can discuss about Some Count Formulas in below notes

1. COUNT ():-
It counts the only numerical cells in range of selection.
Syntax:-
=COUNT (A1:A10)

2. COUNTA():-
It not counts the empty cells in range of selection
Syntax:-
=COUNTA (A1:A10)

3.COUNTBLANK():-
It counts the only blank cells in range of selection.
Syntax:-
=COUNTBLANK (A1:A10)

4.COUNTIF():-
It counts the highest (or) least value cells on required.
Syntax:-
=COUNTIF (A1:A10,”<=5”)
(OR)
=COUNTIF (A1:A10,”>=5”)

Logical Functions in Ms-Excel

In this video we can discuss about Some logical functions in below Notes.

Logical Functions :-

1. AND():-
It Returns true if all arguments are true,returns false if one or more arguments is false
Syntax:-
=AND(logical 1,logical 2)

2. NOT():-
Reverses the value of its argument
Syntax:-
=NOT(logical)

3. OR():-
Returns true if any argument is true , returns false if all arguments are false
Syntax:-
=OR(logical1,logical2)

Text Functions in Ms-Excel

In this video we can discuss about Text Functions or Formulas in our Excel Sheet.

1. CHAR ():-

It returns the character specified by the code number from the character set for your computer.

Syntax:- 

=CHAR (number)

2. CODE ():-

It returns a numeric code for the first character in a text string in the computer.

Syntax:- 

=CODE ("text")

3. LEFT ():-

It returns the first character.

Syntax:-

=LEFT("text", number char)

4. RIGHT ():-

It returns the last character

Syntax:-

=RIGHT("text",numberchar)

5. LENGTH ():-

It returns the number of characters in a string

Syntax:-

=LEN ("text")

6. UPPER ():-

It returns only upper case letters.

Syntax:- 

=UPPER ("text")

7. LOWER ():-

It returns only lower case letters.

Syntax:- 

=LOWER ("text")

8. PROPER ():-

It returns only proper word

Syntax:- 

=PROPER (“text”)

Date & Time Functions in Ms-Excel

In this video we can discuss about Time & Date Functions in our Excel Sheet.

Short Notes of Above Topic:-

1. DATE ():-

It returns given date.

Syntax:-

=DATE (yy,mm,dd)

2. TODAY ():- 

We can use this one to returns the today's date.

Syntax:-

=TODAY ()

3. TIME ():-

It returns the number that represents a particular time.

Syntax:- =TIME(hr,min,sec)

4. NOW ():- 

We can use this one to returns the today's date and time.

Syntax:-

=NOW ()

Statistical Functions in Ms-Excel

In this video we can discuss about Statistical functions or formulas in our Excel Sheet.

Short Notes of Above Topic:-

1. AVERAGE ():-

It returns the average of these arguments which can be numbers.

Syntax:- 

=AVERAGE (number1, number2, number)

2. MAX ():- 

It returns the large number in the set of numbers.

Syntax:-

=MAX (number1, number2, number3)

3. MIN ():-

It returns the smallest number in the set of numbers.

Syntax:-

=MIN (no1, no2, no3)

Arithmetic Functions in Ms-Excel

In this video we can discuss about Some Arithmetic Functions or Formulas in using our Excel Sheet.

Notes of Above Topic:-

1. SUM ():-

Adds all the numbers in arrange of cells.

Syntax:- 

=SUM (num1, num2, and nun)

2. ABS ():-

It gives the absolute value of a number. It displays the number without sign.

Syntax:-

=ABS (number)

3. EVEN ():-

If the number is divisible by 2.

Syntax:-

=EVEN (number)

4. ODD ():- 

If the number is not divisible by 2.

Syntax:-

=ODD (number)

5. PRODUCT ():-

Multiply all the numbers give as arguments and it returns the product.

Syntax:-

=PRODUCT (number1, number2,)

6. PI ():- 

It gives the value of pi. Pi=22/7=3.14

Syntax:-

=PI ()

7. FACT ():-

It gives the factorial of a given number (!)

Syntax:- 

=FACT (number)

8. POWER ():- It gives the result of a number raised to power

Syntax:-

=POWER (number, power)

9. SQRT ():-

It gives the square root of a given number 

Syntax:-

=SQRT (number)

How to Apply Formulas in Ms-Excel

In this video we can discuss about How to apply Formulas in Ms-excel Cells

By using excel we can perform all types calculations and office work and business applications and other industries oriented calculations . If you want to maintain the information in the format of rows and columns and we can perform calculations also in excel. its executable name is excel. Its extension is .xls . In excel to perform calculations we can use only cell address. and calculations must begins with equal to ( = ) symbol.

Design Tabel in Ms-Excel

In this video we can discuss about How to create Table Design with Content Using in Home tab all Commands.

Preview of Design Table:-

How to use Clone Stamp Tool in Photoshop CC

In this video we can discuss about How to use Clone Stamp Tool in Photoshop CC.

Short Notes of Above Topic:-

Clone Stamp Tool:-

The clone stamp tool paints with a sample of an image.

Click the Below Link's and get the Photoshop Photos Using above Concept:-

http://www.mediafire.com/file/aro8ssm166fcsgx/photoshop_new_photos.rar

http://www.mediafire.com/file/ia8n29hkivshxr6/PS_PHOTOS.rar

How to Use Pattern Stamp Tool in Photoshop CC

In this video we can discuss about How to use  Pattern Stamp Tool in Photoshop CC.

Short Notes of Above Topic:-

Pattern Stamp Tool (S):-

The pattern stamp tool paints using part of an image as a pattern.

Click the Below Link's and get the Photoshop Photos Using above Concept:-

http://www.mediafire.com/file/aro8ssm166fcsgx/photoshop_new_photos.rar

http://www.mediafire.com/file/ia8n29hkivshxr6/PS_PHOTOS.rar

Eraser, Back Ground Eraser, Magic Eraser Tools in Photoshop CC

In this video we can discuss about How to Use Eraser, Back Ground Eraser, Magic Eraser Tools in Photoshop CC.

Short Notes of Above Topic:-

Eraser Tool (E):-

The Eraser tool will restore parts of an image to previously saved state or will display the background color.

Background Eraser tool (Shif

t + E):-

The Background Eraser tool will turn the erased area in to a transparency.

Magic Eraser tool (Shift + E):-

The Magic Eraser tool will erase everything of the same color into a transparency.

Click the Below Link and get the Photoshop Photos Using above Concept:-

http://www.mediafire.com/file/aro8ssm166fcsgx/photoshop+new+photos.rar

History Brush & Art HistoryBrush Tools in Photoshop CC

In this video we can discuss about How to use History Brush Tool & Art History Brush Tool in Photoshop.

Short Notes of Above Topic:-

History Brush Tool(Y):-

The history brush tool paints a copy of the selected state or snapshot into the current image window.

Art History Brush Tool (Shift + Y):-

The art history brush tool paints with stylized strokes that simulate the look of different paint styles, using a selected state or snapshot.

Click the Below Link and get the Photoshop Photos Using above Concept:-

http://www.mediafire.com/file/aro8ssm166fcsgx/photoshop+new+photos.rar

Wrap Text & Merge and Center in Ms-Excel

In this video we can discuss about Some Layout Options in Ms-Excel

Wrap Text:-
Make all contents visible with in a cell by displaying it on multiple lines.

Merge and center:-
Joins the selected cell into one larger cell and centers the contents the new cell.

Alignments,Borders & Rotate options in Ms-Excel

In this video we can discuss about Some Layout Options in Ms-Excel

Topics of Above Video:-

* Apply the Borders on Selected Cells

* Alignments (9)

* Rotate the text on Selected Cells 

How to use Format Painter in Ms-Excel

In this video we can discuss about How to use Format Painter in Ms-Excel

Format Painter:-

Select the text or graphic that has the formatting that you want to copy.

Click Format Painter Button image. The pointer changes to a paintbrush icon.

To apply formatting to more than one block of text or graphic, double-click Format Painter 

To stop formatting, press Esc.

Format Option's in Ms-Excel

In this video we can discuss about some Format options with Short Cuts in Ms-Excel

Topics of Above Video:-

* Font Style

* Font Size

* Font Color

* Cell Highlight Color

* Bold

* Italic

* Underline

Using Spreadsheets in Ms-Excel

In this video we can discuss about How to Use Spread Sheets in Ms-Excel.

Topics of Above video:-

* New Sheet

* Hide/ UnHide Sheets

* Move Sheets

* Copy Sheets

* Fill the Tab Color on Sheets

* Delete Sheets

How to use Brush, Pencil, Color Replacement Tools in Photoshop

In this video we can discuss about How to use Some Painting Tools in Adobe Photoshop.

Painting Tools of Above Topic:-

* Brush Tool

* Pencil Tool

* Color Replacement Tool

Click the Below Link's and get the Photoshop Photos Using above Concept:-

http://www.mediafire.com/file/aro8ssm166fcsgx/photoshop_new_photos.rar


http://www.mediafire.com/file/ia8n29hkivshxr6/PS_PHOTOS.rar

Photo Correction Tools in Photoshop (Pimples & Red Eye & Jewelries)

In this Video we can discuss about the How to Remove Pimples & Jewelries in Human Photos. And directly remove the Red Eye in Photos.

Below Link's on Photoshop Photos of Above Topic:-

http://www.mediafire.com/file/ew7c1qfqxbgavjc/pimples.rar

http://www.mediafire.com/file/aro8ssm166fcsgx/photoshop_new_photos.rar

http://www.mediafire.com/file/ia8n29hkivshxr6/PS_PHOTOS.rar

Short Notes of Above Topic:-

Spot Healing Brush Tool:-
The Spot Healing Brush removes blemishes and objects. 

Healing Brush Tool:-
The healing brush tool repairs imperfections in a selected area of an image using a selected sample or pattern.

Patch Tool:-
The patch tool, like the healing brush tool, matches the texture, lighting, and shading of the sampled pixels to the source pixels. 

Red Eye:-
The Red Eye tool removes the red reflection caused by a flash.

How to use Crop Tool & Perspective Crop Tool in Photoshop

In this video we can discuss about How to use Crop Tool & Perspective Crop Tool in Photoshop

Topics of Above Video:-

Crop Tool (C):-
The Crop Tool Trims Images or Shapes.

Perspective Crop Tool (Shift + C):-
The Perspective Crop Tool Trims on the Corner and/or Side handles to  adjust the Crop Shapes or Images. 

Click the Below Link's and get the Photoshop Photos Using above Concept:-

http://www.mediafire.com/file/aro8ssm166fcsgx/photoshop_new_photos.rar

http://www.mediafire.com/file/ia8n29hkivshxr6/PS_PHOTOS.rar

More Free Transform Modes in Photoshop CC

In this video we can discuss about More Free Transform Modes in Photoshop

Topics of Above Video:-
* Scale

* Rotate

* Skew

* Distort

* Perspective

* Warp

* Flip Horizontal

* Flip Vertical

Scale:-

Enlarges or reduces an item relative to its reference point, the fixed point around which transformations are performed. You can scale horizontally, vertically, or both horizontally and vertically.

Rotate:-

Turns an item around a reference point. By default, this point is at the center of the object. however, you can move it to another location.

Skew:-

Slants an item vertically and horizontally.

Distort (Important):-

Stretches an item in all directions.

Perspective:-

Applies one‑point perspective to an item.

Warp:-

Manipulates the shape of an item.

Flip Horizontal (Important):-

Flips the item horizontally.

Flip Vertical (Important):-

Flips the item vertically.

Click the Below Link's and get the Photoshop Photos Using above Concept:-

http://www.mediafire.com/file/aro8ssm166fcsgx/photoshop_new_photos.rar

http://www.mediafire.com/file/ia8n29hkivshxr6/PS_PHOTOS.rar