• Lesson.No : 55
  • 00:02:50
  • MS Excel Tutorial - 55 - How to use count if and data validation to prevent-duplications

  • Play
Loading...

Course Lessons

  1. 1- MS Excel Tutorial - 01 - MS Excel Tutorial Introduction
  2. 2- MS Excel Tutorial - 02 - Useful keyboard shortcuts and tips
  3. 3- MS Excel Tutorial - 03 - Customizing the quick access toolbar
  4. 4- MS Excel Tutorial - 04 - Customizing the ribbon
  5. 5- MS Excel Tutorial - 05 - Using keyboard to access ribbon
  6. 6- MS Excel Tutorial - 06 - The best techniques for inserting deleting data
  7. 7- MS Excel Tutorial - 07 - Undo redo and repeat
  8. 8- MS Excel Tutorial - 08 - 4 ways to protect excel workbooks worksheets
  9. 9- MS Excel Tutorial - 09 - Navigate between workbooks quickly
  10. 10- MS Excel Tutorial - 10 - Applying document themes in a workbook
  11. 11- MS Excel Tutorial - 11 - Saving excel as a read only web page file
  12. 12- MS Excel Tutorial - 12 - Navigate between worksheets quickly
  13. 13- MS Excel Tutorial - 13 - How to create a hyperlink to other worksheets
  14. 14- MS Excel Tutorial - 14 - How to prevent someone to unhide a worksheet
  15. 15- MS Excel Tutorial - 15 - Copying and moving worksheets with various ways
  16. 16- MS Excel Tutorial - 16 - Entering data to multiple worksheets at a time
  17. 17- MS Excel Tutorial - 17 - How to print a 2 page worksheet on 1 page
  18. 18- MS Excel Tutorial - 18 - Hiding scroll bars in a worksheet
  19. 19- MS Excel Tutorial - 19 - How to set the number of worksheets
  20. 20- MS Excel Tutorial - 20 - Learning different techniques for navigating within a given worksheet
  21. 21- MS Excel Tutorial - 21 - How to create and save custom views of a worksheet
  22. 22- MS Excel Tutorial - 22 - Solving the problem with leading zero
  23. 23- MS Excel Tutorial - 23 - How to add text to a number
  24. 24- MS Excel Tutorial - 24 - How to enter a lline break into one of your cells data
  25. 25- MS Excel Tutorial - 25 - Using wrap text and shrink cell tools to have the size of the cells right
  26. 26- MS Excel Tutorial - 26 - Creating a conditional format based on a value
  27. 27- MS Excel Tutorial - 27 - Blocking a user to interact outside a specific range
  28. 28- MS Excel Tutorial - 28 - How to hide the status bar
  29. 29- MS Excel Tutorial - 29 - Changing values without formulas
  30. 30- MS Excel Tutorial - 30 - How to highlight formula cells using conditional formatting
  31. 31- MS Excel Tutorial - 31 - How to color rows using conditional formatting
  32. 32- MS Excel Tutorial - 32 - How to format numbers using key stroke shortcuts
  33. 33- MS Excel Tutorial - 33 - How to modify or create a cell style
  34. 34- MS Excel Tutorial - 34 - Duplicate records and how to get rid of these
  35. 35- MS Excel Tutorial - 35 - Creating bulleted list
  36. 36- MS Excel Tutorial - 36 - Format painter tips
  37. 37- MS Excel Tutorial - 37 - How to insert a watermark
  38. 38- MS Excel Tutorial - 38 - Making your comments stand out
  39. 39- MS Excel Tutorial - 39 - Creating a custom list
  40. 40- MS Excel Tutorial - 40 - The paste special feature
  41. 41- MS Excel Tutorial - 41 - Using fill handle to enter sequences of values
  42. 42- MS Excel Tutorial - 42 - How to use flashfill to fill values in a range rapidly
  43. 43- MS Excel Tutorial - 43 - How to select data using various keystroke shortcuts
  44. 44- MS Excel Tutorial - 44 - How to set a specific print area
  45. 45- MS Excel Tutorial - 45 - Entering data quickly and efficiently
  46. 46- MS Excel Tutorial - 46 - Copying and moving data with various ways
  47. 47- MS Excel Tutorial - 47 - Using pick from drop down list and enter data quickly
  48. 48- MS Excel Tutorial - 48 - Using autocorrect to enter data fast
  49. 49- MS Excel Tutorial - 49 - How to freeze titles and split screens
  50. 50- MS Excel Tutorial - 50 - How to create a data entry form
  51. 51- MS Excel Tutorial - 51 - Filling non adjacent cells with the current entry
  52. 52- MS Excel Tutorial - 52 - Highlighting blank cells and sorting columns with them
  53. 53- MS Excel Tutorial - 53 - Filling random values into every cell in a selection
  54. 54- MS Excel Tutorial - 54 - How to generate random decimal numbers between 0 and 1
  55. 55- MS Excel Tutorial - 55 - How to use count if and data validation to prevent-duplications
  56. 56- MS Excel Tutorial - 56 - How to add comments inside formulas
  57. 57- MS Excel Tutorial - 57 - The autosum magic
  58. 58- MS Excel Tutorial - 58 - Identifying and fixing error inside of an excel formula
  59. 59- MS Excel Tutorial - 59 - Finding related formulas easy
  60. 60- MS Excel Tutorial - 60 - How to enter the current date or time
  61. 61- MS Excel Tutorial - 61 - Using the new in excel 2013 function pduration
  62. 62- MS Excel Tutorial - 62 - How to round values with various ways
  63. 63- MS Excel Tutorial - 63 - Converting formulas to values easy
  64. 64- MS Excel Tutorial - 64 - Using named ranges in formulas
  65. 65- MS Excel Tutorial - 65 - Displaying all worksheet formulas in a second
  66. 66- MS Excel Tutorial - 66 - Using trim function to get rid of unwanted spaces
  67. 67- MS Excel Tutorial - 67 - How to calculate a persons age
  68. 68- MS Excel Tutorial - 68 - How to convert values between measurement systems
  69. 69- MS Excel Tutorial - 69 - Locking and hiding formula cells
  70. 70- MS Excel Tutorial - 70 - Formatting data as table with table styles
  71. 71- MS Excel Tutorial - 71 - Using the table reference to create a formula
  72. 72- MS Excel Tutorial - 72 - How to create separate worksheets from pivot table
  73. 73- MS Excel Tutorial - 73 - Create mini charts using sparklines
  74. 74- MS Excel Tutorial - 74 - Linking chart titles with cell content
  75. 75- MS Excel Tutorial - 75 - How to make all the charts exactly the same size
  76. 76- MS Excel Tutorial - 76 - How to deal with missing data for a chart
  77. 77- MS Excel Tutorial - 77 - Creating a chart with keyboard shortcuts
  78. 78- MS Excel Tutorial - 78 - How to analyze an active workbook using the inquire add in
  79. 79- MS Excel Tutorial - 79 - How to compare two lists of items and identify difference between them
  80. 80- MS Excel Tutorial - 80 - Using quick analysis tool to find information about data
  81. 81- MS Excel Tutorial - 81 - Getting data from a pdf file
  82. 82- MS Excel Tutorial - 82 - Getting data from a pdf file
  83. 83- MS Excel Tutorial - 83 - Applying goal seek tool to find a target
  84. 84- MS Excel Tutorial - 84 - Forecasting scenarios with scenario manager
  85. 85- MS Excel Tutorial - 85 - Monitoring the value in a worksheet using watch window
  86. 86- MS Excel Tutorial - 86 - Calculating running totals