Facebook Tweet Google + Pinterest Email WhatsApp
Comprehensive MS EXCEL 2010 video lecture (DVD)
Comprehensive MS EXCEL 2010 video lecture (DVD)
Comprehensive MS EXCEL 2010 video lecture (DVD)
Comprehensive MS EXCEL 2010 video lecture (DVD)
Comprehensive MS EXCEL 2010 video lecture (DVD)
Mouse Hover to open Zoom view

Comprehensive MS EXCEL 2010 video lecture (DVD)

Be the first to Review this product

90% OFF, Hurry*

   Shipping Charge 60

₹ 285
Use ₹ 14 WC
Product Price : 299
Wincash Use : - 14
You Pay : 285
Register now and instantly get ₹500 WinCash money. You can use WinCash to get extra discounts while shopping from our website. Not usable with Cash on Delivery payment method, usable only on Prepaid orders. T&C*, for more visit.

  • Type : Audio Visual
  • Operating System : Windows
  • Language : English
  • Model : excel017
  • Pack Of : 1
  • Set Contents : 1 DVD
  • Hard Drive Size : NA
  • Additional Information : Duration: 16 Hours

No Returns and Replacement Available for this product

Generally delivered in 5 - 9 days.

Accept all type of payment like: Credit Card , Debit Card , Net Banking , COD

Key Features

  • Type : Audio Visual
  • Operating System : Windows
  • Language : English
  • Model : excel017
  • Pack Of : 1
  • Set Contents : 1 DVD
  • Additional Information : Duration: 16 Hours
  • Subject : MS Excel


What is and why “Comprehensive MS EXCEL 2010 video lecture DVD”

Now you can learn MS EXCEL from home with this DVD. This DVD has been designed for them who want to learn according to their free time as they are busy in other activities also like their jobs, in colleges in house hold course etc.

It saves your cost of traveling like cost of petrol on arriving coaching centers, it provides safety from the accident that may happens on the way, is saves time that can consume on arriving coaching centers and that time can be used in learning more things.

These lectures are made by a team of twenty-two persons. Half of them researched for the lectures of excel all over the world. They made their own lecture series from the best lectures they found. The necessary topics for everyone in daily use

This enthusiastic introduction provides support for MS Excel beginners and focuses on using the program immediately for maximum efficiency. With explicit information on everything from rows, columns, and cells to subtotaling, sorting, and pivot tables, this guide aims to alleviate the frustrations that come with using the program for the first time. This manual offers strategies for avoiding problems and streamlining efficiency and assists readers from start to finish, turning Excel 2010 novices into experts.

Compressive MS excel video DVD’ actually tells the story of what you can do with Excel from beginning to end. No bits are left out. You get the complete story of how to build a foundation of Excel skills that will enable you to accomplish any of your goals at work, home, or play. However, this DVD is not just for beginners. Because most Excel users have never been given the complete story of how Excel works, this DVD will provide an excellent foundation for beginners as well as for more advanced users.

The DVD is for Beginner Level Excel people. However…. most DVDs are designed to give you just enough Excel to get by; this DVD is different. It gives you a complete foundation in Excel. How to do things and what to avoid - so that you don't end up in a bind later on.

It is also really good for someone who has to self-study to get a better job where they rely on Excel

Along the way, you will learn 43 Excel Efficiency Rules to make your life easier in Excel.

After complete this course you will able to do all this.

1_ How Excel Is Set Up, Customize Ribbon and Toolbar

2_ Excel 2010 Keyboard Shortcuts Are Fast!

3_ Data Into Information_ SUMIFS, PivotTable, Verifying Formulas _ Data

4_ Table Format Structure For Raw Data _ Data Analysis

5_ Excel Table Feature (Excel as Database)

6 Number Formatting As Decimal, Date, Time, Percentage

7_ Excel Data Alignment_ Pitfalls & Advantageous Tricks

8_ Excel Stylistic Formatting

9_ Excel Page Setup For Reports Large or Small

10_ Excel Cell Styles and Table Styles

11_ Comprehensive Excel Formula Creation Guide (Formula Types, Elements)

12_ How Excel Formulas Are Evaluated Order of Operations Excel 1Formulas

13_ Putting Cell References In Formulas (3 Methods)

14 Percentage Increase Or Decrease Formulas

15_ Cell References in Formulas_ Relative, Absolute, Mixed

16: Relative, Absolute, Mixed Cell Ranges & Adding With Two Criteria

17_ Mixed Cell References & Orientation of Formula Inputs

18_ What If and Scenario Analysis in Excel

19_ Worksheet, WorkDVD3-D Cell References, Arrange All Feature

20_ Efficient Use Of Cell Ranges in Formulas. Insert Row, Range Updates.

21_ Benefits of Insert Function Dialog Box. FV Function Example

22_ Averaging without Zeros AVERAGEIF function or Replace Feature

23 PMT Function For Loan Payment

24_ Defined Names, Create Names From Selection & Name Manager

25_ AND and OR Criteria For Adding, Counting, and Averaging Formulas

26_ SUMPRODUCT Function (12 Examples)

27 IF function (12 Examples), AND OR functions, Nesting Ifs

28_ VLOOKUP Function & Data Validation Dropdown List (11 Examples)

29_ MATCH Function To Compare Two Lists, Tables or Databases

30_ INDEX & MATCH Function For Unusual Lookup Situations (10 Examples)

31_ ROUND Function -- When & How To Use ROUND

32_ 3 Types Of Averages AVERAGE, MEDIAN, MODE, COUNTIF Functions

33_ RANK Functions _ Excel 2010 Compatibility Functions RANK.AVE RANK.EQ

34_ Goal Seek What If Analysis_2

35_ Basic Array Formulas _ Functions

36_ Custom Number Format _ the TEXT function

37_ Sort Sorting in Excel, Data Analysis (Sorting 20 Examples)

38_ Data Analysis Subtotal Feature (9 Examples)

39_ Data Analysis Pivot Tables _ Pivot Charts, PivotTables _ PivotCharts

40_ Grouping Dates in PivotTables_ Years, Months or Weeks, and more

41_ Blanks (Empty Cells) or Text in Number Fields PivotTable Trouble

42_ PivotTable Slicers, Report Filter _ Show Report Filter Pages

43_ 5 Special PivotTables __ Changing Functions and Calculations

44_Data Analysis Filter Feature_ Extract Data Based on Criteria

45_ PivotTables Treat Integer _ Decimal Numbers Differently inGrouping

46_ Advanced Filter For Extracting Records From Data Set (12 Examples)

47_ Text To Columns Last Name First Name _ Address

48_ Importing Data Into Excel From Excel, Text File, Access, Web Query

49_ Complete Lessons On Excel Charts (26 Examples)

50_ Conditional Formatting (12 Examples)

51_ Find and Replace _ Go To Special

52_ Recorded Macros

53_ Defined Name Formula Dynamic Ranges For Charts and Array Formulas

Terms & Conditions

The images represent actual product though color of the image and product may slightly differ. No Return & No Refund.
Questions and Answers