Scroll To Top
Search
Excel 2010 Basic to Advance Video Training in Hindi

Excel 2010 Basic to Advance Video Training in Hindi

Excel 2010 Basic to Advance Video Training in Hindi Get best prices of Excel 2010 Basic to Advance Video Training in Hindi on Shopclues.com Product Id : 84655819
3 (2) 1 Review
₹539 MRP:₹1,599 66% off

Inclusive of all taxes

Get this for as low as: ₹529 How to earn CluesBucks+

English हिंदी

  • 1) Create account & Earn 500 CB+ instantly (New User)
  • 2) Get 100% Cashback as CB+ on all orders*
  • 3) Complete any COD order to earn CB/ CB+
  • 4) Win CB/CB+ as part of our Promotions.
Original Price
Applicable for All Users
Apply cluesbucks+
Deal Price
₹539
(  ₹10 ) 
₹529

*All discounts can be availed in the cart page

Extra CluesBucks+only on VIP Club. Join Now
item is available on 201301 Change
  • COD Available
  • Free Shipping
  • Delivered 2-5 Business Days
  • No Returns & Replacement

    If applicable customer can place a return/replacement request within 10 Days of order delivery.

    In case of damaged/missing/wrong product or empty parcel, the return/replacement request should be placed within 2 days of delivery.

    Know More
  • Payment Options: (Credit Card , Debit Card , Net Banking , Wallets , COD)
Sold by :

Veer Tutorial

Palwal , Haryana

3 (1) Reviews
Visit Seller Store
Product Details:

Excel 2010 Basic to Advance Video Training in Hindi

Learn MS Excel 2010 Basic to Advance Video Training in Hindi

If you want to learn Excel 2010 in Hindi, you are on the right place as we designed this DVD Course to learn Excel from BASIC to ADVANCE at your Home in Hindi

In Today’s Competitive world Excel is such a tool to help to make your work very easy no matter in which profession you are. You should be master in Excel.

We will start the course with Basic Understanding of New Interface of Excel 2010 covering all tools of Excel and finish with Advance formulas such as Vlookup, Macros etc.

Exercise Files

You will get all excel files used to make this Course in which you will find definitions, formula and many other things which help you to spend less time to type the formulas and examples.

  1. Introduction of Excel 2010
  2. Introduction & Understanding of Interface of Excel 2010
  • How to Move in Cells – Tips & Tricks
  • Autofill of Data in Cells
  • Customs Format of Different Numbers

    1. Text Formulas in Excel

    2. Determine whether Cell Contains Text
    • How to Insert Special Symbol in Cells
    • Determine whether two Strings are identical
    • How to join two or more text
    • Display formatted values as Text
    • Remove Extra Space from Text Lines
    • Counting Characters in String
    • Padding a Number
    • Change the Case of Text (UPPER, lower, Proper)
    • Extracting Character from String
    • Remove Trailing Minus Sign
    • Expressing a number as Ordinal
    • Extracting the First word from String
    • Extracting word Except First word

    1. Date Formulas in Excel

    2. Understanding the Dates in Excel
    • Autofil Dates in Cells – Tips & Tricks
    • Convert Non-Date String to Date Format
    • Calculate number of days between two dates
    • Calculate number of workings days between two dates
    • Calculate number of networking days
    • Date Value formula
    • Network Days formula
    • Working Days between two days – Tips & Tricks Advance
    • Offsetting a Date using only work days – Tips & Tricks Advance
    • Calculate number of years between two dates
    • Calculate remaining days in a year
    • Determine Weekday
    • Calculate last day of the month

    1. Time Formulas in Excel

    2. Display Current Time
    • How to sum of Hours
    • Calculate number of hours worked returns Error if the Shift Spans midnight
    • Converting decimal hours, minutes, or seconds to a Time
    • Rounding the Time Values

    1. Count Formulas in Excel

    2. Basic understanding of Count formula
    • Count the values using And Criteria : Countif Formula – Tips & Tricks Advance
    • Counting most frequently occurring entry : Mode formula – Tips & Tricks Advance
    • Counting the occurrences of specific Text
    • More Examples of Countif Formula – Tips & Tricks Advance

    1. Sum, Sumif and Sumiffs Formula in Excel

    2. Use of Sum formula : Basic to Advance
    • Conditional Sum using single Criteria : Sumif Formula – Tips & Tricks Advance
    • Conditional Sum using multiple Criteria : sumifs – Tips & Tricks Advance

    1. Lookup formulas in Excel

    2. Understand Vlookup Formula
    • Understand Hlookup Formula
    • Vlookup Formula – Tips & Tricks Advance
    • Use Vlookup with iferror formula – Tips & Tricks Advance
    • Vlookup Example 1
    • Vlookup Example 2
    • Vlookup Example 3

    1. Tables in Excel

    2. Introduction of Tables in Excel
    • Filling the Gap in Table
    • Use of filter in Table – Tips & Tricks Advance
    • Learn All Database Functions used in Table
    • Learn SubTotal Function in Table

    1. Financial Formula in Excel

    2. Present Value of Money
    • Present Value of Lum Sum Money
    • Present Value of an Annuity with Lum Sum Money
    • Future Value of Money
    • PMT Function
    • Calculating Rates
    • Calculating Periods
    • Calculate Deferred Payments
    • Pricing a Bond – Tips & Tricks Advance
    • NPV Function
    • NPV Function Advance – Tips & Tricks Advance
    • Calculate Internal Rate of Return – Tips & Tricks Advance
    • Calculate Depreciation – Tips & Tricks Advance

    1. Logical Formulas in Excel

    2. Use of “AND” Function
    • Use of “OR” Function
    • Use of “IFERROR” Function
    • Use of “NOT” Function
    • Use of “IF” Function

    1. Macro in Excel 2010

    2. Understanding of Macro
    • Record of Macro
    • Attach a Macro with Button – Tips & Tricks Advance

    1. Security in Excel

    2. Protect Excel Sheet / Work book with Password
    • Protect Particular Cell in Excel

    1. Pivot Table in Excel

    2. Understanding of Pivot Table in Excel 2010
    • Create Pivot Table & Filter with Column
    • Use of Conditional Formatting with Pivot Table in Excel
    • Advance use Pivot Table in Excel 2010 – Tips & Tricks Advance

    1. Data Validation in Excel

    2. Learn Data Validation in Excel 2010
    • List Feature in Excel 2010

    1. Page Setup with Header Footer in Excel

    2. How to Setup Page in Excel 2010
    • Understanding & Create Header / Footer in Excel
    • Page Setup to Take Print outs in Excel

    1. Extra & Advance use of Excel

    2. How to Convert Numbers into Words
    • Statutory Compliance Sheet
    • Re-Statement of Accounts

    Key Feature

    Model ID :   VT002

    Educational CD Specificaton

    Ideal Course :   Education

    Media Specifications

    Author(s) :   

    Media Specification

    Media Type :   DVD's & CD's
    Language :   Hindi

    More Details
    Maximum Retail Price (inclusive of all taxes) Rs.1599
    Common or Generic Name -
    Net Contents / Net Quantity -
    Manufacturer's Name and Address -
    Packer's Name and Address -
    Marketer's name and Address -
    Importer's Name and Address -
    Country of Origin / Manufacture / Assembly India

    Rating & Reviews

    3
    5
    1
    4
    0
    3
    0
    2
    0
    1
    1

    2 Ratings, 1 Reviews

    • 1
      ashwini
      Friday Apr 30, 2021
      Verified Buyer

      apki Camponi fake he dho dvd paise liye or ek bhej di

      Was this review helpful?

      Yes No
    Please Note: Seller assumes all responsibility for the products listed and sold . If you want to report an intellectual property right violation of this product, please click here.
    Some text some message..