Scale to Fit in Ms-Excel

In this video we can discuss about Scale to Fit option in Excel.

Scale to fit:-

You can scale a worksheet for printing by shrinking or enlarging its size to better fit the printed pages. 

You can also scale a worksheet to fit the paper width of printed pages, or specify the number of pages that you want to use for the printed worksheet.

Page Setup & Printing Options in Ms-Excel

In this video we can discuss about Page Setup & Printing Option's in our Excel Sheet.

Many of the commands you'll use to prepare your workbook for printing and PDF export can be found on the Page Layout tab. These commands let you control the way your content will appear on a printed page, including the page orientation and margin size. Other page layout options, such as print titles and page breaks, can help make your workbook easier to read.

Simple Macros in Ms-Excel

In this video we can discuss about How to use Macros in Excel Sheet.

Macros are code that automate work in a program. They let you add your own tiny features and enhancements to help you accomplish exactly what you need to do, quickly with just a click of a button. In a spreadsheet tool like Excel, macros can be especially powerful. Hidden behind the normal user interface, they are more powerful than standard functions you enter into a cell.

View,Zoom & Show options in Ms-Excel

In this video we can discuss about Show & Zoom Options in Excel

Show & Zoom Groups:-

Show Group on the Hide & Unhide the Grid lines, Formula bar, Heading's Options

The Zoom group on the View tab allows you to increase or decrease the size of the view of your document.

It just simply changes the view size.

And click the 100% button to bring your document back to 100% view.

Click the Zoom to Selection Options Display the Selection of Area in Excel sheet.

Freeze panes & Split in Ms-Excel

In this video we can discuss about How to use Freeze Panes Options in Excel

Freeze Panes:-

If you have a large table of data in Excel, it can be useful to freeze rows or columns. This way you can keep rows or columns visible while scrolling through the rest of the worksheet.

Group,Ungroup & Subtotal in Ms-Excel

In this video we can discuss about How to Group & Ungroup the Rows & Columns.
How to use the Sub Total option Excel Sheet.

Group:-
Select a set of rows or columns that you wish to group together.
Click on the Data tab  in the Ribbon.
Click on the Group button in the Outline Group.
Click on Group option

Hide the Selected rows & columns in excel sheet.

Then click the Plus Icon.

Then display the selected rows & columns

Ungroup:-

Select a Grouping rows or columns
Click on the Data tab  in the Ribbon.
Click on the UnGroup button in the Outline Group.
Click on UnGroup option

Then Ungrouping the selected rows & columns

Sub total (Table) Click the below Link:-

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

http://www.mediafire.com/download/x6e66rdlhtaa5ow/sub_total.xlsx

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

Pivot Table in Ms-Excel

In this video we can discuss about How to use Pivot Table in Excel

Pivot table:-

You might think of a pivot table as a user created summary table of your original spreadsheet. 

You create the table by defining which fields to view and how the information should be displayed.

Based on your field selections, Excel organizes the data so you see a different view of your data.

click the below links:- (Table & Problems)

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

Table link:-
http://kaitect.com/NVN

Problems link:-

http://kaitect.com/NW4

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

How to Prepare Charts in Ms-Excel

In this video we can discuss about How to Use Chart in Excel.

In Microsoft Excel, you can represent numbers in a chart. On the Insert tab, you can choose from a variety of chart types, including column, line, pie, bar, area, and scatter. As you change your data, your chart will automatically update. You select a chart type by choosing an option from the Insert tab's Chart group.

How to Use Comments in Ms-Excel

In this video we can discuss about How to use Comments in Excel.

* Select the cell that contains the comment that you want to edit.

* On the Review tab, in the Comments group, click Edit Comment. Keyboard shortcut You can also press SHIFT+F2.

* Double-click the text in the comment, and then in the comment text box, edit the comment text.

Formula Auditing Option in Ms-Excel

In this video we can discuss  about  How to use Formula Auditing in Excel Sheet.

Formula auditing group:-

Formula Auditing graphically displays, or traces, the relationships between cells and formulas. Adding tracer arrows lets you visually step through which formulas refer to which cells.

Trace Precedents:-

Draws arrows from all cells that contribute values to the formula result, i.e., active cell (precedents). 

Trace Dependents:-

Draws arrows from the active cell to the formula cells, and shows what other cells use the active cell 

Remove All Arrows:-

Remove all tracer arrows (both precedent and dependent arrows) at once.

Error Checking:-

Check for errors in a formula using a set of rules to find common mistakes and if there is, the Error Checking dialog box is displayed.

Defined Names Option in Ms-Excel

In this video we can discuss about How to use Defined Names in excel sheet.

Defined names group:-

* Assign a descriptive name to a cell or range in Excel to help make formulas in your worksheets much easier to understand and maintain. Range names make it easier for you to remember the purpose of a formula, rather than using somewhat obscure cell references.

Data Table Option in Ms-Excel

In this video we can discuss about Data table in Excel Sheet.

Data Table:-

A data table is a range of cells in which you can change values in some in some of the cells and come up with different answers to a problem.

Goal Seek Option in Ms-Excel

In this video we can discuss about How to use Goal Seek Option in Excel

Goal Seek:-
Goal Seek is a built-in Excel tool that allows you to see how one data item in a formula impacts another.

Scenario Manager Option in Ms-Excel

In this video we can discuss about How to use Scenario Manager in Excel.

What-if analysis:-

What-if analysis is the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet.

Three kinds of what-if analysis tools come with Excel: scenarios, data tables, and Goal Seek. 

Scenario Manager:-

A scenario is a set of values that Excel saves and can substitute automatically in cells on a worksheet. You can create and save different groups of values on a worksheet and then switch to any of these new scenarios to view different results.

Consolidate option in Ms-Excel

In this video we can discuss about How to use Consolidate Option in Excel Sheet.

Consolidate:-

It is used to find the different sheet values calculations and its result produced in a new sheet. 

It supports mainly for sum or average or max or min or etc...

Data Validation in Ms-Excel

In this video we can discuss about How to use Data Validation in Excel Sheet.

Data validation:-
Data validation is invaluable when you want to share a workbook with others in your organization, and you want the data entered in the workbook to be accurate and consistent.

Flash Fill & Remove Duplicates

In this video we can discuss about How to work with Flash Fill & Remove Duplicates Options in Excel Sheet.

Remove Duplicates:-

Remove Duplicates window check the boxes next to the columns you would like the duplicate data removed. Then click OK and all duplicates will be deleted from the spreadsheet.

Text to Columns in Ms-Excel

In this video we can discuss about How to use Text to Columns option in Excel Sheet.

Text to Columns:- 

This button will separate words into 2 columns. To try this type you first and last name in one cell. Then click the Text to Columns button. It will open the Convert Text to Columns Wizard. click next for the third window. It will return you to your spreadsheet with all of the selected cells separated into 2 cells.

Filter Option in Ms-Excel

In this video we can discuss about How to use Filter Option of Content in Cells.

Download the below 2 files(Filter Table & Problems):-

http://www.mediafire.com/download/19v3cv466llgt1n/FILTER_EXCEL.xlsx

http://www.mediafire.com/download/8mdeb0245scsvdh/Filter_Problems.docx

Filtering cells:-
Filtering, or temporarily hiding, data in a spreadsheet is simple. This allows you to focus on specific spreadsheet entries.

To Filter data:
* Click the Filter command on the Data tab. Drop-down arrows will appear beside each column heading.
* Click Filter button
* Click the Arrow at the bottom of the first cell
* Click the Text Filter
* Click the Words you wish to Filter.

Sort Option in Ms-Excel

In this video we can discuss about How to Sorting of Content in no of cells.

Sorting:-

Sorting lists is a common spreadsheet task that allows you to easily reorder your data. The most common type of sorting is alphabetical ordering, which you can do in ascending or descending order.

Hyperlink Option in Ms-Excel

In this video we can discuss about How to use Hyperlink Option in Excel sheet.

Hyperlink :-
Create a link to a web page, a picture ,mail address on u r selected cell.

* Type the Text on Cell

* Select the Cell

* Click the Hyper link Option

* Selection the link address

* Then press ok.

Travelling Agency Table in Ms-Excel

In this video we can discuss about Travelling Agency Table in Excel Sheet.

Using Traveling Agency:-

Traveling Agency name = Sandya Travels
No. of vehicles = 65
Per day rent on each vehicle = 2600/-
Total sent vehicles = 35
Total taken days = 11
Driver charges per day = 350/-
Advance on vehicles = 40000/-
Advance on drivers = 4000/-

Then find ?

Available vehicles =?
Total bill on vehicles =?
Total bill on drivers =?
Total bill =?
Net amount =?
Balance bill =?

Financial Problem(Rotation interest) in Ms-Excel

In this video we can discuss about Financial Problem in Excel.

Financial problem:-
Amount: 1650/- interest: 2.75% Time: 32 months
Then find monthly interest, total interest, rotation interest, total cash..?

Then find:
Monthly interest = amount * interest
Total interest = Monthly interest * time
Rotation interest = Amount + MI + Total interest
Total Cash = Amount + total interest

Using IF formula Problems in Excel

In this video we can discuss about Using IF Formulas in Excel Sheet.

Using IF formula

Total = Telugu + Hindi + English

Grades:-

Two grades:-
=IF(Total>value,”A”,”B”)

Three grades :-
= IF(Total>=High Value,”A”,IF(Total>=Middle value,”B”,”C”))

Pass & Fail:-
=IF(AND(Telugu>35,Hindi>35,English>35),”Pass”, “Fail”)

Employee Payroll Table in Ms-Excel

In this video we can discuss about Employee Payroll Table in Excel

Ex Problem:-

Take Employee Number=012025
Name= K. Kishore
Basic=8650/-

Then find the following calculations 

1. HRA is 13.7% on Basic =? 

2. TA is 8.3% on basic =?
3. DA is 6.2% on basic =?
4. MA is 16.2% on basic =?
5. Allowances =? (HRA + TA+DA+MA)
6. Gross =? (Basic + Allowances)
7. IT is 2.7% on Gross =?
8. PF is 3.2% on Gross =?
9. LIC is 1.6% on Gross =?
10. Deductions =? (IT+PF+LIC)
11. Net Salary =? (Gross – Deductions)

Inventory Table in Ms-Excel

In this video we can discuss about Inventory Table (Stock Items)

Ex Problem:-

Item Name = Lux
opening Stock=85
Purchase price=8/-
Sales price=13/-
Sales Quantity=47

Closing stock =?
Profit on each one =?
Net profit =?
Close stock value=?

Partner Ship Table in Ms-Excel

In this video we can discuss about Using Partner Ship Table

Ex Problem:-

Partnership:- 

Total Capital investment = 5,68,000. 

Ravi share 33% . 

Remaining share for Ganesh. 

Total profit = 1,78,950. 

Then find

Ravi profit , Ganesh Profit = ?

Ganesh share =100%-33%

Ravi profit = total profit * Ravi share

Ganesh Profit = total profit * Ganesh share

Cinema Tickets Table in Ms-Excel

In this video we can discuss about Using Movie Theaters Table

Ex Problem:-

Using Cinema Theater:- 

Theater name = Krishna Mahal

Total tickets = 475

Sale tickets = 382

Ticket rate = 55/-

Empty tickets = Total tickets - sale tickets.

Loss = Empty tickets * ticket rate

Total cash = t rate * sale tickets

Discount of Hotel Bill Table in Ms-Excel

In this video we can discuss about How to find the Discount of Hotel Bill

Ex Problem:-

Discount Table :- 

Take Bill, discount on bill, then find concession amount, final bill ?

Bill = 1250/-

Discount = 13%

Concession amount = ? (1250*13%)

Final bill = ? ( Bill - Concession amount)

Power bill Table in Ms-Excel

In this video we can discuss about How to Find the Power bill.

Ex Problem:-

Using Power Station :- 

Take Service No, Customer name, Unit Rate, Present month reading, Last month reading, then find the No. Units consumed, total Bill?

Service No = 0449

Customer name = A. Srnivasa rao

Unit Rate = 2.75/-

Present month reading = 669

Last month reading = 502

Find:-

No. of units consumed = present month reading- last month reading.

Total bill = No. of units consumed * unit rate

Working on Employee Table in Ms-Excel

In this video we can discuss about Working on Employee. Find the Employee Per day salary & Net Salary.

Ex Problem:-

Working on Employee Table:- 

Take Employee Number, Name, Salary ,Total Working days, Total Present Days, then find Per day salary, Net Salary ? 

Employee  no = 120

Employee name = Rajesh

Salary = 12000

Total working days = 30

Total present days = 24

Find:-

Per day salary = salary/total working days

Net salary       = per day salary * total present days

Student Marks Table(Find Total,Avg,Grade) In Ms-Excel

In this video we can discuss about How to find the Students Total, Average, Grade of Student Marks.

Ex Problem:-

Student Table:-

Take Student No, Name, Sub1, Sub2, Sub3 Marks the find Total marks, Average marks?

S.no = 1214

Name = PRASAD

Math’s = 95

Telugu = 64

English = 85

Hindi = 66

Total = ? (Math’s + Telugu + English + Hindi)

AVG = ? (Total / No. of Subjects)

Grade =?

Fill & Clear Options in Ms-Excel

In this video we can discuss about How to use fill & clear options in Excel Sheet.

Fill:-

To display the list of Auto Fill options, click the Auto Fill Options button. The list of options varies according to the type of data: text and formulas, numbers, months, days of the week, and dates. 

Clear:-

You can clear cells to remove the cell contents (formulas and data), formats (including number formats, conditional formats, and borders), and any attached comments. 

The cleared cells remain as blank or unformatted cells on the worksheet.

Auto Formulas in Ms-Excel

In this video we can discuss about Auto Formulas & Small Tricks in Excel Sheet.

Auto sum (ALT + =):-
Display sum of the selected cells directly after the selected cells.

Fill Handle Trick's using in this Below Formulas

* Average

* Minimum

* Maximum

* Count

* Sum

How to use Shape Tools in Photoshop

In this video we can discuss about  How to use Shape Tools in Photoshop

Shape Tools (U):-

The Shape tools will create a solid color shape of their type.

The Line tool will create a solid color line.

The Custom Shape tool makes customized shapes selected from a custom shape list.

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

http://www.mediafire.com/file/agdww7vtwaytaqj/wedding+photos.rar

How to Text Tools in Photoshop

In this video we can discuss about How to use Text Tools in Photoshop.

Which Tools Above Video:-

* Horizontal Type Tool

* Vertical Type Tool

* Horizontal Type Mask Tool

* Vertical Type Mask Tool

Text Tools (T):-

The type tools create type on top of an image or Page.

The type mask tools make a selection of the document in the shape of type.

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

http://www.mediafire.com/file/agdww7vtwaytaqj/wedding+photos.rar

Modification work Pen tools in Photoshop

In this video we can discuss about How to use modification of Pen tool path work.

Free Form Pen Tool:-

The Free form Pen Tool enables easy drawing vector shapes and paths (shape outlines) by automatically adding anchor points. 

Add Anchor Point Tool:-

The Add Anchor Point Tool adds anchors and reshapes existing vector shapes / paths

Delete Anchor Point Tool:-

The Delete Anchor Point Tool deletes anchors and reshapes existing vector shapes.

Convert Point Tool:-

Convert Point Tool. The Convert Point Tool edits existing vector shape masks and paths (shape outlines) by converting smooth anchor points to corner anchor points and vice versa. In the Toolbox, select the Convert Point Tool. Click on a smooth anchor point to convert it to corner anchor point.

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

http://www.mediafire.com/file/agdww7vtwaytaqj/wedding+photos.rar

How to use Pen tool in Photoshop

In this video we can discuss about How to use Pen tool in Photoshop

Pen Tool (P):-

The pen tool has several different options for the resulting path. The most commonly used is “add to path area”. 

Using the Pen tool, click corner points in two locations to create a straight segment.

Position the Pen tool over the selected end point.

Position the pen where you want the next anchor point; then click the new anchor point to complete the curve.

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

http://www.mediafire.com/file/agdww7vtwaytaqj/wedding_photos.rar