ICT301- Microsoft office complete training

About Course

ICT101- Microsoft Office Complete Training

This course has been prepared and distributed under Memorandum of Understanding (MoU) between Yash Institute of Pharmacy, Aurangabad, Maharashtra and Mintbotics Edutech Pvt. Ltd. Aurangabad. The course is distributed in collaboration with Yash Institute of Pharmacy, Aurangabad in blended learning mode (online + offiline). Enrollment is free for students and staff of Yash Institute of Pharmacy, Aurangabad. Students and faculty of other institutes can enroll for the course on payment basis.

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.

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

41. Fill series

07:36
42. Editing custom lists

03:20
43. Important Information

00:00
44. Excel Short Keys and Golden Key

04:22
45. Introduction to Absolute and Relative References (Fixed and Variable)

07:20
46. The Marksheet

04:08
47. Random Number Generation

02:21
48. Clearing Formula With Intact Values

03:38
49. Key Components of Marksheet

04:29
50. Introduction to IF-Then Conditions

03:28
51. Nested IF’s (Looping Function)

06:17
52. Ranking Positions

05:47
53. Conditional Formatting & Data Bars

07:28
54. Freeze Panes

03:19
55. Table Formatting & Range Conversion

04:53
56. Sort & Filters

08:32
57. Max Min Average Countblank Count if and Much More

12:40
58. Prepare a Sales and Bonus Report With Manual Totaling

08:28
59. Grouping and Auto totaling

07:30
61. Hiding and Unhiding Rows Grouping and Auto Totaling

05:42
62. Removing Duplicates and Sales Summary With Sum if Function

05:12
63. Understanding Absolute and Relative Referencing

09:10
64. Applying Sum if With Absolute and Relative Referencing

05:20
65. SUMIF with External Sheet References

03:48
66. IF Conditions With Multiple Logics

12:00
67. Introduction to Aged Debtors Analysis

05:27
68. Arranging the data to get Started

07:53
69. Automate data arrangement

08:18
70. Quick Trick Formatting

03:16
71. Conditional formatting Advanced

08:31
72. Applying Advance Formatting Tricks

06:59
73. Formula Analysis for Aging

19:41
74. Absolute , Relative Functions & Date values

11:55
75. Live Aging

08:07
77. Introduction to VLOOKUP

08:59
78. Using Named Ranges and IF ERROR

03:01
79. Simplifying Even More With data Validation

02:34
81. Using Combo Boxes

06:15
82. The Hlookup Function

05:57
83. Lookup for Inverse Data

10:15
84. Introduction To Index Match

07:38
85. Quiz Assignment Remington Pharma Explanation

02:22
86. Invoicing System Remington Pharmaceuticals

12:20
87. Sum If and IFS

08:47
88. Forget filters – use DSUM Search Box

04:31
89. Amazing Advanced Filters & Macros

20:05
90. Introduction to Pivot tables

08:25
91. Grouping In Pivot Tables

08:18
92. Calculated Fields

06:00
93. Pivot Charts

09:11
94. Dashboard Reporting

09:36
95. Automated Cheque Printing System (Using Mail Merge)

13:29
96. Introduction to Hyperlinks

04:45
97. Hyperlinks With External Sheet References

02:09
98. Columns Separation & Concatenation

06:10
99. Excel Flash Fill Saves The day

04:04

Section 3: Microsoft PowerPoint training

101. Creating Blank Presentation and PowerPoint Interface

06:04
102. Inserting New Slides and Working with Layouts

04:19
103. Changing Layout and Arrangement of Slides

02:40
104. Designing Slides in Powerpoint

04:51
105. Inserting and Customizing Pictures In Powerpoint 7min

06:53
106. Logo Insert in Presentation and Online Images

02:36
107. Use Smart Art to Enhance Graphical Look of Presentation

05:13
108. Using Charts In Powerpoint Presentations

08:38
109. Inserting Audio to your Slides

04:22

Section 4: Microsoft outlook training

110. Introduction and Configure Gmail on Outlook

06:21
111. Understanding Microsoft Outlook Interface

02:55
112. Using Calendar feature for Appointments and Meetings

06:13
113. Sending Meeting Invites to Attendees

02:38
114. Using Auto Correct Function to Automate Email Typing

03:26
115. Using Quick Access Toolbar

01:20
116. Use of Voting Buttons

02:01
117. Enable Blind Carbon Copy

01:12
118. Change Reply to Address in Outlook

02:08
119. Using Search Folders for Email Management

04:43
120. Inserting Signature in Outlook

05:21
121. Adding Calendar to Email

01:14
122. Adding Calendar to Email

01:14
123. Working in Offline Mode

01:49
124. Delay Delivery

01:27
125. Insert Attachments and Pictures in Email

02:40
126. Send Emails to Multiple Recipients

02:09
127. Creating and Managing Folders in Outlook

02:10
128. Creating Rules for Managing Emails

03:19
129. Managing Emails By Color Categories

02:24
130. How to Add Contacts in Outlook

01:04
131. Managing and Importing Contacts in Outlook

04:23
132. Congratulations on Completion of Outlook

00:13

About Course

Course Content

Section 1: MS Word training

1. Introduction

2. Grammar and spell checker vocabulary for MS Word

3. Using auto correct for automatic typing

4. Creating mail merge to integrate Word with Excel

5. Configure Gmail account on Outlook for mail merge

6. Send individual emails to persons

7. Letter formatting and word spacing

8. Non printing characters in Word document

9. Line spacing settings in MS Word

10. Save as types in MS Word

11. Edit multiple documents with split and view options

12. Short keys in Word part 1

13. Short keys in Word part 2

14. Find and replace options

15. Formatting techniques

16. Using style function to format with navigation

17. Selection techniques in MS Word

18. Working with tabs for auto spacing

19. Working with tab alignments

20. Dealing with bullets and numbers

21. Storing data in MS Word

22. Demote and promote functions in MS Word

23. Creating and working on tables in MS Word

24. FAQs on leaving a review

25. Insert and Deleting Rows and Columns in a Table

26. Tables layout and design

27. Creating custom design in tables

28. Sorting data in a table

29. Creating a custom table

30. Saving custom table templates in Word

31. Converting raw text to table

32. Inserting formulas to tables

33. Inserting hard page breaks in document

34. Column breaks in word

35. Column break settings

36. Inserting watermarks

37. Applying page borders

38. Headers and footers

39. Working with pictures

Section 2: Microsoft Excel training

41. Fill series

42. Editing custom lists

43. Important Information

44. Excel Short Keys and Golden Key

45. Introduction to Absolute and Relative References (Fixed and Variable)

46. The Marksheet

47. Random Number Generation

48. Clearing Formula With Intact Values

49. Key Components of Marksheet

50. Introduction to IF-Then Conditions

51. Nested IF’s (Looping Function)

52. Ranking Positions

53. Conditional Formatting & Data Bars

54. Freeze Panes

55. Table Formatting & Range Conversion

56. Sort & Filters

57. Max Min Average Countblank Count if and Much More

58. Prepare a Sales and Bonus Report With Manual Totaling

59. Grouping and Auto totaling

61. Hiding and Unhiding Rows Grouping and Auto Totaling

62. Removing Duplicates and Sales Summary With Sum if Function

63. Understanding Absolute and Relative Referencing

64. Applying Sum if With Absolute and Relative Referencing

65. SUMIF with External Sheet References

66. IF Conditions With Multiple Logics

67. Introduction to Aged Debtors Analysis

68. Arranging the data to get Started

69. Automate data arrangement

70. Quick Trick Formatting

71. Conditional formatting Advanced

72. Applying Advance Formatting Tricks

73. Formula Analysis for Aging

74. Absolute , Relative Functions & Date values

75. Live Aging

77. Introduction to VLOOKUP

78. Using Named Ranges and IF ERROR

79. Simplifying Even More With data Validation