MS Office 2021/365 Complete Basic to Advance Course

سرفصل های دوره

Learn MS office applications EXCEL, WORD, POWERPOINT, OUTLOOK from Trainer with 20+ Experience

1. MS Word - Introduction

1.1 MS Word Practice and Exercise Files.rar

1. Interface of MS Word Document

2. Backstage View

2. MS Word - Understanding the Basics

1. Create New Document and Save

2. How to open word document

3. Navigate the document

4. Find replace and go to

5. Basic Editing

6.1 Practice Module 2.docx

6. Practice

3. Mastering Auto Correction, Selection, and Clipboard Techniques

1. Autocorrect Part 1

2. Autocorrect Part 2

3. Selection Techniques

4. Cut copy paste clipboard

4. MS Word - Comprehensive Guide to Table Options

1. Create New Table

2. Insert delete table row column

3. Insert content adjust cell height width

4. Formatting

5. Table Border

6. Border styles

7. Table styles

8. Function in ms word document

9. Convert text to table merge split cells

10. Quick Table

11. Sort

5. MS Word - Advanced Page Layout

1. Page break

2. Column Part 1

3. Column Part 2

4. Adding water mark

5. Header and Footer

6. MS Word - Mastering Sections

1. Introductions of sections

2. Apply sections in ms document

3. Sections in Detail

4. Apply header and footer in section

7. MS Word - Play with Images, Pictures, Graphics, 3D Objects, Smart Art and Charts

1. Insert Picture

2. Text wrap in ms word document

3. Pictures Styles

4. Remove background color correct of pictures

5. insert Graphics in ms word document

6. Insert icon and 3d models

7. smart art

8. Insert chart

9. Take screenshot

8. MS Word - Mail Merge

1. Working with envelops

2. Working with labels

3. Introduction of mail merge

4. Mail merge letter

5. Mail merge labels

9. MS Word - Index and Table of Content

1. Index

2. table of content

10. MS - Spell Check, Comments, Page Setup and Printing of Document

1. Therusus and spell check

2. Comments

3. Page Setup

4. Printing Document

11. MS Word - Backstage Settings and Security Options

1. MS Word Setting Options

2. Protect Word Document with Password

12. PowerPoint - Basic of PowerPoint

1.1 PowerPoint Practice Files.rar

1. Screen Overview & Interface

2. Presentation Tips and Guidelines

13. PowerPoint - Understanding Slides & Formatting

1. create new presentation

2. working with slides

3. Formatting of text place holder

4. Format painter

5. Clipboard options with bullets using chatgpt

6. Numbering list

14. PowerPoint - Working with Graphics, 3D Object & Smart Arts

1. Working with graphics

2. Create slide with graphic

3. Another graphic design

4. Insert icon and 3d object

5. Insert smart art

15. PowerPoint - Working with Tables & Data

1. Introduction of table

2. Table design option

3. Table layout

4. Table layout option

5. Insert excel spreadsheet in powerpoint

6. Use of word art in powerpoint

16. PowerPoint - Working with Charts

1. Introduction of chart in power point

2. Chart styles and elements

3. Formatting of chart elements

4. Link excel data in powerpoint chart

17. PowerPoint Advanced - Understanding Slide Master

1. Introduction of slidemaster

2. How to use slidemaster in presentation

3. Creating slide master from scratch

18. PowerPoint - Learn Transition

1. Transition

19. PowerPoint - Animation

1. Introduction of animation in power point

2. Animation of multiple objects

3. Advance animation options

4. Motion graphics

5. Interactive animation using trigger in powerpoint

20. PowerPoint - Action Button and Hyperlinks

1. Action buttons in powerpoint

2. Hyperlinks in Powerpoint

21. PowerPoint - Run your SlideShow

1. Start your slide show

2. Presenters view

3. Hide a particular slide

4. Custom slide show

5. Setup slide show

6. Record slide show in video format

7. Export slideshow in other formats

8. Backstage and printing options

9. Conclusion

22. Outlook - Basics

1. Quick Access toolbar or QAT

2. Adding new account in outlook

23. Outlook - Setup Working Area & Alerts

1. Setting focused and reading area

2. Manage alerts of outlook in windows 11

24. Outlook - Compose & Sending Emails

1. Compose New Email

2. Formatting Text

3. Apply Formatting Find and Replace Options

4. Insert Table

5. Insert Image Icon 3d model and their Formatting tools

25. Outlook - Advanced Options

1. EMAIL Message Attachements

2. Manage Signatures

3. Searching Outlook

4. Search Folder

5. Conversation Message

6. Delete and Archive Messages

26. Outlook - Manager Data and Folders

1. Categories

2. Followup Flag

3. Folder and Subfolders

4. Quick Steps

5. Conditional Formatting

6. Rules

7. Junk Emails

27. Outlook - Recall, Out of Office Replies

1. Use of Mention in the Outlook

2. Recall Message

3. Automatic Replies

28. Outlook - Manage Contacts

1. Adding New Contact

2. Update Contact

3. Create New Group

29. Outlook - Manage Appointments

1. Introduction of Calender and Setup New Appointment

2. Use Categories in Appointment

3. Schedule a New Meeting

30. Chap 1 Excel

1. Excel Interface

2. Create New File and Save

3. Quick Access Toolbar

4. Basic Data Entry in Excel

5. Create Basic Data Table

6. Selection and Movement Tips in Excel

7. Alignment

8. Formatting Table

9. Employee Time Sheet Table

10. Form Design Advance

31. Chap 2 excel

1. Data Types in Excel

2. Insert Special Characters

3. Autocorrect in Excel

4. Auto Suggestion for Data Entry

5. Autofill

6. Flash Fill

7. Insert and Delete Rows and Column

8. Hide Unhide Rows Columns

9. Spreadsheet Management

10. Find and Replace

32. Chap 3 excel

1. Introduction of Calculation

2. Use of Inbuilt Function

3. Cell Absolute Reference

4. Error In Formula

5. Circular References

6. Value Paste

33. Chap 4 excel

1. Define Name of Cell and Cell Range

2. Define Name Using Name Manager

3. Retrieve value from Other Workbook

4. Naming Convention in define Names

5. Intersection

34. Chap 5 Excel

1. Determine Cell Values are Text or Not

2. Determine Cell Values are Identical or Not

3. Joining Multiple text in Single Cell with Real Life Practical Examples

4. Removing Excess Space and Non Printing Characters

5. Counting Characters Using Len Function

6. Padding a Number

7. Changing Case of Text

8. Extract Characters from String

9. Extracting First Word Using Find Function

35. Chap 6 excel

1. Understanding the Dates in Excel

2. Today Function in Excel

3. Date Function in Excel

4. Convert Non Date String to a Date in Excel

5. Calculate Days between Two Dates

6. Days and Days 360 Functions in Excel

7. Network Days Calculate Work Days

8. Network Day INTL

9. Workday and Workday INTL Function

10. DateDIF

11. Calculate Last Day of the Year

36. Chap 7 excel

1. Understand Time Functionality in Excel

2. Summing of Time Values

3. Calculate Working Hours in Excel

4. Convert Integer values into Time Value

5. Round Up Time Values

37. Chap 8 excel

1. How to use Images and Shapes in Excel

38. Chap 9 excel

1. Data Validation

39. Chap 10 excel

1. logical Functions

40. Chap 11 excel

1. VLOOKUP Function

2. advance Use of VLOOKUP and HLOOKUP Function

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy