MS Office Full Course 2022

About Course

माइक्रोसॉफ्ट ऑफिस MS Office दुनिया का सबसे Popular Office Suite है Suite का मतलब एक जैसे Computer Programs का एक सेट होता है यह program एक दूसरे से Data share कर सकते हैं इनके Tools भी लगभग लगभग एक समान होते हैं इस लिए इन्‍हें सुइट कहा जाता है MS Suite में ऑफिस में काम आने वाले सभी program का एक सेट बनाया गया है जिससे आपका Office work और भी आसान हो जाता है Office में कई प्रकार के कार्य होते हैं जैसे लेटर बनाना Spreadsheet तैयार करना, Presentation तैयार करना, email भेजना, Database Management करना आदि

Component of Microsoft Office in Hindi

माइक्रोसॉफ्ट वर्ड (Microsoft Word)
माइक्रोसॉफ्ट ऍक्सेल (Microsoft Excel)
माइक्रोसॉफ्ट पावरप्वाइण्ट (Microsoft PowerPoint)
माइक्रोसॉफ्ट एक्सेस (Microsoft Access)
माइक्रोसॉफ्ट आउटलुक (Microsoft Outlook)
माइक्रोसॉफ्ट पब्लिशर (Microsoft publisher)

Course Content

Microsoft Word (33 videos)

1- Introduction to Microsoft Word

11:56
2- Use Clipboard Group Of Home Tab

12:32
3- Text Formatting in Microsoft Word

05:50
4 – Line and Paragraph Spacing

08:53
5 – Sort Paragraph, Bullet and Number Lists

09:55
6- Using Find, Replace, and Go To

06:44
7- Page Setup And Printing

08:31
8- How to Create Custom Cover Pages

06:56
9- Hyperlink, Bookmark And Cross Reference

18:55
10- Creating and Formatting Tables

10:39
11- Insert Pictures in Word

09:22
12- Insert ClipArt & Online Image

05:22
13- Using Word Text Boxes

05:43
14- Create a SmartArt graphic

04:28
15- Add or Edit Shapes in Microsoft Word

06:14
16- Create or Run a Macro

05:21
17- Create Fillable Forms

06:07
18- Use Autocorrect in Word

04:51
19- How to Insert Watermarks

03:33
20- Set Default Hindi Font And Font Size

01:48
21- Check Spelling and Grammar

05:31
22- Perfect Text Alignment Using Tabs

09:51
23- Add Footnote And Endnote

04:11
24- Insert Caption in Word

05:28
25- Insert Table of Contents

05:59
26- Create a Bibliography, Citations, and Referencess son

07:14
27- Microsoft Word Best Keyboard Shortcuts

08:47
28- Letter Format Example and Writing Tips

09:34
29- How to Create a Resume in Word

06:43
30- Using Mail Merge in MS Word

06:01
31- How to Use Sum Formula in Word

05:05
32 – Create Certificate in MS Word

11:18
33 – How To Make Visiting Card

18:27

Microsoft Excel (90 videos)

1- Microsoft Excel Introduction

10:56
2 – How to Work in Excel And Use Basic Formulas

11:10
3- Use Clipboard Like Pro Full Explain

11:57
4 – Organize Row Column And Worksheet

08:47
5 – Data Entry Like Pro

05:45
6 – Create Your Own Custom List

06:30
7 – How Make Password your Excel File

05:55
8 – How To Create a Backup Excel File

06:01
9 – How to Use Sum Formula

06:14
10 – How to Use Skip Blanks

03:24
11 – Subtract, Multiple, Divide And Percentage

07:57
12 – Use of Number Format in Excel

11:14
13 – Use Conditional Formatting

13:38
14 – How to Sort & Filter Data

08:37
15 – Using Find and Replace and Using GoTo

07:20
16 – How to Use Status Bar

07:27
17 – Freeze Panes Option

04:42
18 – Split Window

04:41
19 – Fill Option

10:51
20 – Flesh Fill

08:09
21 – Pivot Table

12:24
22 – All Table Option

11:22
23 – Pictures Option

12:23
24 – Use Shape

12:23
25 – Use 3D Modal

12:23
26 – Smart Art

12:24
27 – Advanced Charts & Graph

12:24
28 – People Graph

12:24
29 – Create Hyperlinks

12:24
30 – Header and Footer

12:24
31 – Write, Insert, or Change an Equation

12:24
32 – Using the Draw Tab

12:24
33 – How to Use Themes

12:24
34 – Complete Page Setup

12:24
35 – Scale to Fit Setup

12:24
36 – IF Formula

12:24
37 – IF Formula With Multiple Conditions

12:24
38 – Change Case and Round Figure Formula

12:24
39 – VLOOKUP Formula

12:24
40 – VLOOKUP Formula Examples

12:24
41- HLOOKUP Formula

12:24
42 – And Formula

12:24
43 – Convert Number into Word Formula

12:24
44 – Use Macros with Example

12:24
45 – Subtotal Formula

12:24
46 – Link Data in Excel Spreadsheets Formula

12:24
47 – Data Consolidate Formula

12:24
48 – Calculate Age With Date, Date If Formula

12:24
49 – E-Date and Eo-Month Formula

12:24
50 – Calculating Percent Formula

12:24
51 – Superscript and Subscript Formula

12:23
52 – Group Ungroup Subtotal Formula

12:23
53 – Goal Seek Formula

12:23
54 – PMT Formula

12:23
55 – Goal With PMT Formula

12:23
56 – Concat Formula

12:23
57 – INDIRECT Formula

12:23
58 – Match Formula

12:23
59 – Count, Counta, Countblank Formula

12:23
60 – EXACT Formula

12:23
61 – Sumif Formula

12:23
62 – Sumifs Formula

12:23
63 – Round, RoundUp, RoundDown, MRound Formula

12:23
64 – Array Formula

12:23
65 – LEFT, RIGHT, MID, LEN & FIND Formula

12:23
66 – Split Name Using LEFT, RIGHT, MID, LEN Formula

12:23
67 – Mod Formula

12:23
68 – Quotient Formula

12:23
69 – Replace Formula

12:23
70 – SUBSTITUTE Formula

12:23
71- Excel Formula Error Types

12:23
72 – SUMPRODUCT Formula

12:23
73 – Text Formula

12:23
74 – Double VLOOKUP Formula

12:23
75 – Simple Interest Formula

12:23
76 – Compound Interest Formula

12:23
77 – Ceiling And Floor Formula

12:23
78 – Index Formula

12:23
79 – INDEX + MATCH Formula

12:23
80 – Forecast Formula

12:23
81 – Value Formula

12:23
82 – Most Important Keyboard Shortcut

12:23
83 – Employees Payroll and Salary Slip

12:23
84 – Daily Stock Register

12:23
85 – Dynamic Unit Converter

12:23
86 – Dynamic Dropdown List

12:23
87 – School Marksheet With Grade

12:23
88 – Make Checklist & To Do List

12:23
89 – Make Attendance Sheet

12:23
90 – Student Database With Mail Merge

12:23

PCskill

About Course

Component of Microsoft Office in Hindi

What Will You Learn?

Course Content

Microsoft Word (33 videos)

1- Introduction to Microsoft Word

2- Use Clipboard Group Of Home Tab

3- Text Formatting in Microsoft Word

4 – Line and Paragraph Spacing

5 – Sort Paragraph, Bullet and Number Lists

6- Using Find, Replace, and Go To

7- Page Setup And Printing

8- How to Create Custom Cover Pages

9- Hyperlink, Bookmark And Cross Reference

10- Creating and Formatting Tables

11- Insert Pictures in Word

12- Insert ClipArt & Online Image

13- Using Word Text Boxes

14- Create a SmartArt graphic

15- Add or Edit Shapes in Microsoft Word

16- Create or Run a Macro

17- Create Fillable Forms

18- Use Autocorrect in Word

19- How to Insert Watermarks

20- Set Default Hindi Font And Font Size

21- Check Spelling and Grammar

22- Perfect Text Alignment Using Tabs

23- Add Footnote And Endnote

24- Insert Caption in Word

25- Insert Table of Contents

26- Create a Bibliography, Citations, and Referencess son

27- Microsoft Word Best Keyboard Shortcuts

28- Letter Format Example and Writing Tips

29- How to Create a Resume in Word

30- Using Mail Merge in MS Word

31- How to Use Sum Formula in Word

32 – Create Certificate in MS Word

33 – How To Make Visiting Card

Microsoft Excel (90 videos)

1- Microsoft Excel Introduction

2 – How to Work in Excel And Use Basic Formulas

3- Use Clipboard Like Pro Full Explain

4 – Organize Row Column And Worksheet

5 – Data Entry Like Pro

6 – Create Your Own Custom List

7 – How Make Password your Excel File

8 – How To Create a Backup Excel File

9 – How to Use Sum Formula

10 – How to Use Skip Blanks

11 – Subtract, Multiple, Divide And Percentage

12 – Use of Number Format in Excel

13 – Use Conditional Formatting

14 – How to Sort & Filter Data

15 – Using Find and Replace and Using GoTo

16 – How to Use Status Bar

17 – Freeze Panes Option

18 – Split Window

19 – Fill Option

20 – Flesh Fill

21 – Pivot Table

22 – All Table Option

23 – Pictures Option

24 – Use Shape

25 – Use 3D Modal

26 – Smart Art

27 – Advanced Charts & Graph

28 – People Graph

29 – Create Hyperlinks

30 – Header and Footer

31 – Write, Insert, or Change an Equation

32 – Using the Draw Tab

33 – How to Use Themes

34 – Complete Page Setup

35 – Scale to Fit Setup

36 – IF Formula

37 – IF Formula With Multiple Conditions

38 – Change Case and Round Figure Formula

39 – VLOOKUP Formula

40 – VLOOKUP Formula Examples