Advance excel with tips & tricks

Tutorial Videos in Hindi language
Tutorial Videos: 80+
Audio Language: Hindi
Video Format: MP4
Compatible: Computer, Laptop, Smart Phone, Tablet
Download Pack Size: 580 MB Approx
Advance Excel Syllabus   
  1. If,And,Or Functions
  2. Array Functions
  3. Autofill And Custom List
  4. Autosum With Row Reference And Column Reference
  5. Concatenate
  6. Condition Formatting With Mod Function
  7. Convert Function
  8. Countblank And Counta Function
  9. Creating Combo Box
  10. Large And Small
  11. Find, Search And Mid Function
  12. Formula Copy Shortcut
  13. Hyperlink Through Drag And Drop
  14. Index Function
  15. Information Function
  16. Left And Right Function
  17. Macro In Excel
  18. Match And Index Function
  19. Match Function
  20. Mod Function
  21. More Text
  22. Nested If
  23. Proper, Upper And Lower Function
  24. Rank Function
  25. Replace And Substitute Function
  26. Sumif, Countif And Averageif Function
  27. Sumifs, Countifs, Averageifs Function
  28. Text Functions
  29. Transpose Function
  30. Vlookup
  31. Weekday
  32. Insert And Edit the Data in Multiple Worksheets
  33. Insert Watermark in Excel 2010
  34. Quickly Transpose Data Using Shortcut
  35. Turn Off And On Worksheet Tabs And Scroll Bars
Excel Tips & Tricks:
  1. Changing Grid line Color And Hide Or Show Formula Bar
  2. Cycle Font Color
  3. Specify The Behavior Of Enter Key
  4. Changing Label Orientation
  5. Selecting Group Of Cells
  6. Changing Worksheets Orientations In One Go
  7. Selecting Ranges With Keyboard
  8. Shortcut To Viewing Formulas
  9. Switch Between Workbooks
  10. Create Button
  11. Manipulating Objects
  12. Deleting Graphics When Deleting Row
  13. Hide Graphics
  14. Change Column Label In Number Label
  15. Change Shape Of Comment
  16. Controlling Display Of The Scroll Bars
  17. Print Gridlines And Headings
  18. Print Page Number At The Bottom Of Each Page
  19. Print Several Portions Of A Worksheet On A Single Paper
  20. Printing A Draft Of A Worksheet
  21. Printing A Portion Of A Worksheet
  22. Printing Rows Conditionally
  23. Printing Without Opening Workbooks
  24. Hiding Errors On Printout
  25. Print Comments In Excel
  26. Quickly Copy Formula
  27. Quickly Insert Current Date And Time
  28. Open A Copy Of A Workbook
  29. Centering The Worksheet Data
  30. Create Bar Graph
  31. Applying Range Names To Formula
  32. Entered Values Are Divided By 100
  33. Share Workbook
  34. Split Column Data
  35. Trick To Change Predefined Group Name
  36. Trick To Create Own Tab
  37. Trick To Insert Picture Comment
  38. Trick To Open Specific Workbooks
  39. Unprotect Only A Portion Of An Excel Spreadsheet
  40. Spelling Check
  41. Insert Total Row
  42. Search Box
  43. Data validation
  44. Dependent Dropdown list
  45. Conditional Formatting
  46. Pivot Table
  47. Insert Sheet
  48. Copy Numbers Only
  49. Text value Convert Number