What+my+project+is+about

====Introduction of **Excel 2010** Tips,Tricks, and Skills that will help you to improve and provide better understanding of using **Excel 2010**.====

==To introduce you to excel I found out a paragraph that described why excel is so beneficial and important to use not only for personal use:==
 * The need for Excel is very important to any business. It is used for matching and analyzing cost. Validating and maintaining item/cost information, analyzing cost variances for inventory. Auditing/processing invoices. Excel spreadsheet is used to store quantitative data and to perform accurate and rapid calculations with results ranging from simple budgets to financial analyses and statistical analyzes. Excel is part of a user interface which is the meeting point between computer software and the person using it and provides the means for a person to communicate with a software program. All businesses rely on some form of number system to keep track of merchandise, customer service surveys, stocks and employees. A system of accounting is used to keep records of employees, merchandise, materials, and all aspects that has to do with that business. The need for excel falls in the category of this need to keep the flow of the business. Since we are in the age of the computer the only use for paper is the backup system when the computers are down. This program is a more accurate way to keep up with the operation of any business.

Some benefits of using Excel 2010 are:

 * Making fast and effective comparisons
 * Get powerful analysis from your desktop
 * Save time, Simplify Your Work, and Increase Your Productivity
 * Break down barriers and work together in new ways
 * Access your workbooks anytime, anywhere

Here are eight functions that I have found beneficial using Excel 2010:
Some other functions that I found useful are count</range id="389614132_16">/<range type="comment" id="389614132_17">counta</range id="389614132_17">, <range type="comment" id="389614132_18">countif</range id="389614132_18">/<range type="comment" id="389614132_19">countifs</range id="389614132_19">, <range type="comment" id="389614132_20">averageif</range id="389614132_20">/<range type="comment" id="389614132_21">averageifs</range id="389614132_21">, <range type="comment" id="389614132_22">sum/sumif/sumifs</range id="389614132_22">, and <range type="comment" id="389614132_23">True and False functions</range id="389614132_23">.
 * 1) <range type="comment" id="389614132_8">Proper</range id="389614132_8">
 * 2) <range type="comment" id="389614132_9">Concatenate</range id="389614132_9">
 * 3) <range type="comment" id="389614132_10">VLookup</range id="389614132_10">
 * 4) <range type="comment" id="389614132_11">Clean Domain Names</range id="389614132_11">
 * 5) <range type="comment" id="389614132_12">Everything to the right of a domain</range id="389614132_12">
 * 6) <range type="comment" id="389614132_13">Get just the domain from the email adress</range id="389614132_13">
 * 7) <range type="comment" id="389614132_14">Find if the value is in the column</range id="389614132_14">
 * 8) <range type="comment" id="389614132_15">Find if the cell above is a duplicate</range id="389614132_15">

List of 10 important things to look at when working with excel 2010:

 * 1) Absolute and relative referencing
 * 2) Limitations
 * 3) Quick help on functions
 * 4) <range type="comment" id="389614132_46">Right-clicking</range id="389614132_46">
 * 5) <range type="comment" id="389614132_47">User preferences</range id="389614132_47">
 * 6) <range type="comment" id="389614132_48">The fill handle</range id="389614132_48">
 * 7) Formula auditing
 * 8) <range type="comment" id="389614132_49">Stored values vs. displayed values</range id="389614132_49">
 * 9) <range type="comment" id="389614132_50">Status bar info</range id="389614132_50">
 * 10) <range type="comment" id="389614132_51">Paste Special options</range id="389614132_51">

To make Excel 2010 more fun to learn about, I have found top ten features of excel:

 * Conditional Formatting&Sparklines
 * <range type="comment" id="389614132_45">Cell Styles</range id="389614132_45">
 * <range type="comment" id="389614132_44">Formatting and Editing from the Home tab</range id="389614132_44">
 * <range type="comment" id="389614132_43">Charts from the Insert tab</range id="389614132_43">
 * Format as Table
 * Page Layout View
 * <range type="comment" id="389614132_42">Style Galleries</range id="389614132_42">
 * <range type="comment" id="389614132_39">Document Information and Printing in Backstage View</range id="389614132_39">
 * <range type="comment" id="389614132_41">The Ribbon</range id="389614132_41">
 * <range type="comment" id="389614132_40">Live Preview</range id="389614132_40">

==To go little beyond the basics of excel and its basic functions, I found 15 functions that people will find not familiar, but some of them are key and beneficial functions to learn in order to master Excel 2010 skills.==

They are:

 * 1) <range type="comment" id="389614132_24">Change the case of cell contents- to Upper, lower, Proper</range id="389614132_24">
 * 2) <range type="comment" id="389614132_25">Clean up textual data with trim, remove trailing spaces</range id="389614132_25">
 * 3) <range type="comment" id="389614132_26">Extract characters from left, right or center of a given text</range id="389614132_26">
 * 4) <range type="comment" id="389614132_27">Find second, third, fourth element in a list without sorting</range id="389614132_27">
 * 5) <range type="comment" id="389614132_28">Find out current date, time with a snap</range id="389614132_28">
 * 6) <range type="comment" id="389614132_29">Convert those lengthy nested if functions to one simple formula with Choose</range id="389614132_29">
 * 7) <range type="comment" id="389614132_30">Repetitively print a character in a cell n number of times</range id="389614132_30">
 * 8) <range type="comment" id="389614132_31">Find out the data type of cell contents</range id="389614132_31">
 * 9) <range type="comment" id="389614132_32">Round a number to nearest even, odd number</range id="389614132_32">
 * 10) <range type="comment" id="389614132_33">Generate random number between any 2 given numbers</range id="389614132_33">
 * 11) <range type="comment" id="389614132_34">Convert pounds to KGs, meters to yards and tsps to table spoons</range id="389614132_34">
 * 12) <range type="comment" id="389614132_35">Instantly calculate loan installmens using spreadsheet formula</range id="389614132_35">
 * 13) <range type="comment" id="389614132_36">What is this week's number in the current year</range id="389614132_36">
 * 14) <range type="comment" id="389614132_37">Find out what is the date after 30 working days from today</range id="389614132_37">
 * 15) <range type="comment" id="389614132_38">With so many functions, how to handle errors.</range id="389614132_38">

media type="youtube" key="_PBPU_5jTUA" height="315" width="420"media type="youtube" key="KwENULmMaiA" height="315" width="420"media type="youtube" key="h-VJlIstu5U" height="315" width="420" media type="youtube" key="-SnBlC_1tSk" height="315" width="560"