الدرس 8 | اكسيل | Excel

قائمة الدروس

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

ترتيب الدرس : 08

00:07:59

MS Excel Tutorial - 08 - 4 ways to protect excel workbooks worksheets

تشغيل

درس الطلاب ايضا

مهارات التواصل

مهارات التواصل

5 محاضر

تدريب المدربين (TOT)

تدريب المدربين (TOT)

5 محاضر

التسويق الشخصى

التسويق الشخصى

6 محاضر

مهارات القائد الناجح

مهارات القائد الناجح

7 محاضر

ادارة الوقت

ادارة الوقت

6 محاضر

مهارات حل المشكلات

مهارات حل المشكلات

4 محاضر

© حقوق النشر محفوظة لمالكى القنوات | القوانين والخصوصية

اضف التطبيق الى شاشتك الرئيسية