ICT301- Microsoft office complete training

Uncategorized
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

ICT101- Microsoft Office Complete Training

This course has been prepared and distributed under Memorandum of Understanding (MoU) with following institutes:

  • Yash Institute of Pharmacy, Aurangabad, Maharashtra.

This course on MS Office is being offered to students of undergraduate and postgraduate levels. The syllabus and curriculum has been designed to impart ICT (Information and Communication Technologies) skills to students. The course can be integrated in the curriculum of colleges and Universities to fill up the curricular gap.

Students have to undergo this course during third year of their graduation.

What the student learn

  • Learn the basics of Microsoft Office in this pack of courses: Excel, Word, PowerPoint, and Outlook
  • Learn practical ways to back up and restore your spreadsheets in Excel without losing any data.
  • Use efficient Autofill and Flash Fill to be more productive in Microsoft Excel.
  • Find the basics of using formulas and functions in Excel
  • Learn how to create stunning charts and graphs in Excel
  • Learn practical ways to sort and filter your data in Excel
  • Explore new features in PowerPoint 2019, including icons and 3D models
  • Learn how to insert shapes, graphics, and pictures to add a little charm to your PowerPoint
  • Add charts, graphs, and tables in non-text format to your PowerPoint presentation information
  • Keep your audience happy by adding animation, audio, and video to PowerPoint
  • Here are practical tips for presenting your PowerPoint presentation to your audience
  • Learn time-saving techniques, including copying your slides and exporting your presentation
  • Master the most commonly used Microsoft Word applications
  • Learn about Word’s tools, including how to use columns, indentations, footers, frames, and watermarks.
  • How to create a mail merge in Microsoft Word
  • Learn how to print envelopes and labels properly in Word
  • Learn how to protect your Word document from changes
  • Add professional photos and graphics to your Word documents
  • Make your Word document cool by inserting and editing tables

Are there any course requirements or prerequisites?

  • Excel, Word, PowerPoint and Outlook installed on your machine. Preferably Office 2013 or Office 2016

Who this course is for:

  • Anyone new to Microsoft Office and want to gain expertise on it

 

Course Outcomes

CE610.1 Create scientific and technical documents incorporating equations, images, tables, and bibliographies with MS Word.

CE610.2 Build spreadsheets to perform calculations, display data, conduct analysis, and explore what-if scenarios with MS-Excel.

CE610.3 Develop technical and scientific presentations which use charts and visual aids to share data with MS-PowerPoint.

CE610.4 Understand working of MS-Outlook and manage mailing operations.

Show More

Course Content

Section 1: MS Word training

  • 1. Introduction
    08:05
  • 2. Grammar and spell checker vocabulary for MS Word
    03:27
  • 3. Using auto correct for automatic typing
    03:03
  • 4. Creating mail merge to integrate Word with Excel
    03:54
  • 5. Configure Gmail account on Outlook for mail merge
    08:02
  • 6. Send individual emails to persons
    01:25
  • 7. Letter formatting and word spacing
    09:02
  • 8. Non printing characters in Word document
    03:03
  • 9. Line spacing settings in MS Word
    01:41
  • 10. Save as types in MS Word
    02:15
  • 11. Edit multiple documents with split and view options
    02:51
  • 12. Short keys in Word part 1
    08:25
  • 13. Short keys in Word part 2
    04:03
  • 14. Find and replace options
    04:09
  • 15. Formatting techniques
    03:56
  • 16. Using style function to format with navigation
    06:16
  • 17. Selection techniques in MS Word
    03:23
  • 18. Working with tabs for auto spacing
    05:17
  • 19. Working with tab alignments
    02:39
  • 20. Dealing with bullets and numbers
    05:01
  • 21. Storing data in MS Word
    03:39
  • 22. Demote and promote functions in MS Word
    01:34
  • 23. Creating and working on tables in MS Word
    06:03
  • 24. FAQs on leaving a review
    00:00
  • 25. Insert and Deleting Rows and Columns in a Table
    03:13
  • 26. Tables layout and design
    04:21
  • 27. Creating custom design in tables
    01:17
  • 28. Sorting data in a table
    02:02
  • 29. Creating a custom table
    04:37
  • 30. Saving custom table templates in Word
    04:03
  • 31. Converting raw text to table
    03:14
  • 32. Inserting formulas to tables
    03:54
  • 33. Inserting hard page breaks in document
    02:37
  • 34. Column breaks in word
    01:22
  • 35. Column break settings
    04:18
  • 36. Inserting watermarks
    03:17
  • 37. Applying page borders
    01:32
  • 38. Headers and footers
    08:06
  • 39. Working with pictures
    06:20

Section 2: Microsoft Excel training

Section 3: Microsoft PowerPoint training

Section 4: Microsoft outlook training

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?