• Lesson.No : 51
  • 00:11:55

  • 13- Spreadsheets – Functions Part 2

  • Play

Course Lessons

  1. 1- 01- Computer Essentials - Hardware
  2. 2- 02- Computer Essentials – Software
  3. 3- 03- Computer Essentials – Desktop
  4. 4- 04- Computer Essentials – Windows
  5. 5- 05- Computer Essentials – Folder
  6. 6- 06- Computer Essentials – Organize Files
  7. 7- 07- Computer Essentials – Shortcut
  8. 8- 08- Computer Essentials – Files and Extensions
  9. 9- 09- Computer Essentials – Save and Save As
  10. 10- 10- Computer Essentials – Open with and File Properties
  11. 11- 11- Computer Essentials – Microsoft Word
  12. 12- 12- Computer Essentials – Search
  13. 13- 13- Computer Essentials – Storage and Compression
  14. 14- 14- Computer Essentials – Tools and Settings
  15. 15- 15- Computer Essentials –Windows Help and Task Manager
  16. 16- 16- Computer Essentials – Removable Devices and Print Screen
  17. 17- 17- Computer Essentials – Printers and Printing
  18. 18- 18- Computer Essentials – Networks
  19. 19- 19- Computer Essentials – security and Well Being
  20. 20- 01- Word Processing – Word Interface
  21. 21- 02- Word Processing – Save a Document
  22. 22- 03- Word Processing – Enhancing Productivity
  23. 23- 04- Word Processing – View Modes and edit text
  24. 24- 05- Word Processing – Find and Replace
  25. 25- 06- Word Processing – Font Formatting
  26. 26- 07- Word Processing – Hyperlinks and Hyphenation
  27. 27- 08- Word Processing – Copy text and copy formatting
  28. 28- 09- Word Processing – Paragraph Formatting
  29. 29- 10- Word Processing – Indentations and Tabs
  30. 30- 11- Word Processing – Numbering
  31. 31- 12- Word Processing – Insert Pictures and Objects
  32. 32- 13- Word Processing - Shapes and Charts
  33. 33- 14- Word Processing - Tables
  34. 34- 15- Word Processing - Mail Merge
  35. 35- 16- Word Processing - Spelling
  36. 36- 17- Word Processing - Header and Footer
  37. 37- 18- Word Processing - Page Background
  38. 38- 19- Word Processing - Page Setup and Printing
  39. 39- 01- Spreadsheets – Excel Interface
  40. 40- 02- Spreadsheets – Create and Save Files and Templates
  41. 41- 03- Spreadsheets – Enhancing Productivity
  42. 42- 04- Spreadsheets – Selection
  43. 43- 05- Spreadsheets – AutoFill
  44. 44- 06- Spreadsheets – Work Sheets
  45. 45- 07- Spreadsheets – Insert and Delete Rows and Columns
  46. 46- 08- Spreadsheets – Column width and Row height
  47. 47- 09- Spreadsheets – Sort
  48. 48- 10- Spreadsheets – Formulas
  49. 49- 11- Spreadsheets – Relative and Absolute References
  50. 50- 12- Spreadsheets – Functions Part 1
  51. 51- 13- Spreadsheets – Functions Part 2
  52. 52- 14- Spreadsheets – Cells Formatting Number
  53. 53- 15- Spreadsheets – Cells Formatting Alignment and Borders
  54. 54- 16- Spreadsheets – Chart
  55. 55- 17- Spreadsheets – Page Setup
  56. 56- 18- Spreadsheets – Header and Footer
  57. 57- 19- Spreadsheets – View and Freeze Panes
  58. 58- 20- Spreadsheets – Print Options
  59. 59- 21- Spreadsheets – Errors
  60. 60- 01- Databases - Open and Create a Database
  61. 61- 02- Databases - Create a Table
  62. 62- 03- Databases - Table Properties
  63. 63- 04- Databases - Data Types
  64. 64- 05- Databases - Field Properties - Part 1
  65. 65- 06- Databases - Field Properties - Part 2
  66. 66- 07- Databases - Sort and Filter
  67. 67- 08- Databases - Query
  68. 68- 09- Databases - Relationships
  69. 69- 10- Databases - Forms
  70. 70- 11- Databases - Reports
  71. 71- 12- Databases - Export and Import Data
  72. 72- 01- Presentations - Create , Open And Save Files
  73. 73- 02- Presentations - PowerPoint Interface
  74. 74- 03- Presentations - Slides and Layouts
  75. 75- 04- Presentations - Text Formatting
  76. 76- 05- Presentations - Pictures
  77. 77- 06- Presentations - Tables
  78. 78- 07- Presentations - Hyperlinks
  79. 79- 08- Presentations - Charts
  80. 80- 09- Presentations - Smart Arts
  81. 81- 10- Presentations - Shapes
  82. 82- 11- Presentations - Themes
  83. 83- 12- Presentations - Format Background
  84. 84- 13- Presentations - Slide Size
  85. 85- 14- Presentations - Transitions
  86. 86- 15- Presentations - Animations
  87. 87- 16- Presentations - Slide Show
  88. 88- 17- Presentations - Views and Slide Master
  89. 89- 18- Presentations - Spelling
  90. 90- 19- Presentations - Header and Footer
  91. 91- 20- Presentations - Printing and Help