MS Office 2021/365 Complete Basic to Advance Course

Focused View

Veer Tutorial,Mahavir Bhardwaj

15:46:42

0 View

1. MS Word - Introduction

1.1 MS Word Practice and Exercise Files.rar

1. Interface of MS Word Document.mp4

05:43

2. Backstage View.mp4

06:18

2. MS Word - Understanding the Basics

1. Create New Document and Save.mp4

05:04

2. How to open word document.mp4

04:30

3. Navigate the document.mp4

04:13

4. Find replace and go to.mp4

08:04

5. Basic Editing.mp4

02:26

6.1 Practice Module 2.docx

6. Practice.mp4

00:44

3. Mastering Auto Correction, Selection, and Clipboard Techniques

1. Autocorrect Part 1.mp4

08:55

2. Autocorrect Part 2.mp4

04:46

3. Selection Techniques.mp4

07:28

4. Cut copy paste clipboard.mp4

06:17

4. MS Word - Comprehensive Guide to Table Options

1. Create New Table.mp4

04:01

2. Insert delete table row column.mp4

04:45

3. Insert content adjust cell height width.mp4

04:48

4. Formatting.mp4

02:26

5. Table Border.mp4

01:45

6. Border styles.mp4

04:55

7. Table styles.mp4

05:35

8. Function in ms word document.mp4

04:29

9. Convert text to table merge split cells.mp4

05:12

10. Quick Table.mp4

03:16

11. Sort.mp4

02:16

5. MS Word - Advanced Page Layout

1. Page break.mp4

04:49

2. Column Part 1.mp4

03:05

3. Column Part 2.mp4

05:46

4. Adding water mark.mp4

04:09

5. Header and Footer.mp4

08:38

6. MS Word - Mastering Sections

1. Introductions of sections.mp4

02:00

2. Apply sections in ms document.mp4

06:10

3. Sections in Detail.mp4

05:22

4. Apply header and footer in section.mp4

03:41

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

1. Insert Picture.mp4

05:16

2. Text wrap in ms word document.mp4

05:37

3. Pictures Styles.mp4

04:19

4. Remove background color correct of pictures.mp4

08:29

5. insert Graphics in ms word document.mp4

07:32

6. Insert icon and 3d models.mp4

04:44

7. smart art.mp4

08:32

8. Insert chart.mp4

06:38

9. Take screenshot.mp4

02:15

8. MS Word - Mail Merge

1. Working with envelops.mp4

03:40

2. Working with labels.mp4

03:58

3. Introduction of mail merge.mp4

02:18

4. Mail merge letter.mp4

09:00

5. Mail merge labels.mp4

02:49

9. MS Word - Index and Table of Content

1. Index.mp4

06:58

2. table of content.mp4

05:19

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

1. Therusus and spell check.mp4

05:15

2. Comments.mp4

05:02

3. Page Setup.mp4

05:50

4. Printing Document.mp4

05:49

11. MS Word - Backstage Settings and Security Options

1. MS Word Setting Options.mp4

06:40

2. Protect Word Document with Password.mp4

03:34

12. PowerPoint - Basic of PowerPoint

1.1 PowerPoint Practice Files.rar

1. Screen Overview & Interface.mp4

06:07

2. Presentation Tips and Guidelines.mp4

04:36

13. PowerPoint - Understanding Slides & Formatting

1. create new presentation.mp4

05:49

2. working with slides.mp4

04:00

3. Formatting of text place holder.mp4

07:01

4. Format painter.mp4

02:50

5. Clipboard options with bullets using chatgpt.mp4

07:53

6. Numbering list.mp4

05:10

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

1. Working with graphics.mp4

10:26

2. Create slide with graphic.mp4

06:32

3. Another graphic design.mp4

02:21

4. Insert icon and 3d object.mp4

04:48

5. Insert smart art.mp4

04:45

15. PowerPoint - Working with Tables & Data

1. Introduction of table.mp4

05:39

2. Table design option.mp4

07:18

3. Table layout.mp4

06:08

4. Table layout option.mp4

05:21

5. Insert excel spreadsheet in powerpoint.mp4

05:37

6. Use of word art in powerpoint.mp4

02:25

16. PowerPoint - Working with Charts

1. Introduction of chart in power point.mp4

04:11

2. Chart styles and elements.mp4

04:42

3. Formatting of chart elements.mp4

05:31

4. Link excel data in powerpoint chart.mp4

04:30

17. PowerPoint Advanced - Understanding Slide Master

1. Introduction of slidemaster.mp4

05:42

2. How to use slidemaster in presentation.mp4

05:07

3. Creating slide master from scratch.mp4

08:12

18. PowerPoint - Learn Transition

1. Transition.mp4

05:00

19. PowerPoint - Animation

1. Introduction of animation in power point.mp4

06:06

2. Animation of multiple objects.mp4

04:59

3. Advance animation options.mp4

04:29

4. Motion graphics.mp4

03:32

5. Interactive animation using trigger in powerpoint.mp4

04:16

20. PowerPoint - Action Button and Hyperlinks

1. Action buttons in powerpoint.mp4

05:34

2. Hyperlinks in Powerpoint.mp4

03:07

21. PowerPoint - Run your SlideShow

1. Start your slide show.mp4

06:23

2. Presenters view.mp4

03:37

3. Hide a particular slide.mp4

02:35

4. Custom slide show.mp4

02:08

5. Setup slide show.mp4

03:12

6. Record slide show in video format.mp4

02:42

7. Export slideshow in other formats.mp4

03:56

8. Backstage and printing options.mp4

06:26

9. Conclusion.mp4

01:27

22. Outlook - Basics

1. Quick Access toolbar or QAT.mp4

05:30

2. Adding new account in outlook.mp4

06:01

23. Outlook - Setup Working Area & Alerts

1. Setting focused and reading area.mp4

04:12

2. Manage alerts of outlook in windows 11.mp4

05:23

24. Outlook - Compose & Sending Emails

1. Compose New Email.mp4

05:41

2. Formatting Text.mp4

10:58

3. Apply Formatting Find and Replace Options.mp4

06:47

4. Insert Table.mp4

05:19

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

10:31

25. Outlook - Advanced Options

1. EMAIL Message Attachements.mp4

04:58

2. Manage Signatures.mp4

05:00

3. Searching Outlook.mp4

06:25

4. Search Folder.mp4

03:34

5. Conversation Message.mp4

03:44

6. Delete and Archive Messages.mp4

04:35

26. Outlook - Manager Data and Folders

1. Categories.mp4

06:28

2. Followup Flag.mp4

03:26

3. Folder and Subfolders.mp4

05:01

4. Quick Steps.mp4

05:28

5. Conditional Formatting.mp4

02:55

6. Rules.mp4

07:53

7. Junk Emails.mp4

06:10

27. Outlook - Recall, Out of Office Replies

1. Use of Mention in the Outlook.mp4

03:34

2. Recall Message.mp4

03:49

3. Automatic Replies.mp4

02:38

28. Outlook - Manage Contacts

1. Adding New Contact.mp4

06:04

2. Update Contact.mp4

04:16

3. Create New Group.mp4

03:12

29. Outlook - Manage Appointments

1. Introduction of Calender and Setup New Appointment.mp4

07:09

2. Use Categories in Appointment.mp4

02:20

3. Schedule a New Meeting.mp4

04:39

30. Chap 1 Excel

1. Excel Interface.mp4

07:55

2. Create New File and Save.mp4

04:04

3. Quick Access Toolbar.mp4

03:03

4. Basic Data Entry in Excel.mp4

06:51

5. Create Basic Data Table.mp4

05:43

6. Selection and Movement Tips in Excel.mp4

09:21

7. Alignment.mp4

05:49

8. Formatting Table.mp4

08:18

9. Employee Time Sheet Table.mp4

08:55

10. Form Design Advance.mp4

12:05

31. Chap 2 excel

1. Data Types in Excel.mp4

03:26

2. Insert Special Characters.mp4

03:06

3. Autocorrect in Excel.mp4

03:30

4. Auto Suggestion for Data Entry.mp4

02:29

5. Autofill.mp4

06:33

6. Flash Fill.mp4

03:26

7. Insert and Delete Rows and Column.mp4

05:00

8. Hide Unhide Rows Columns.mp4

03:01

9. Spreadsheet Management.mp4

05:02

10. Find and Replace.mp4

05:08

32. Chap 3 excel

1. Introduction of Calculation.mp4

03:57

2. Use of Inbuilt Function.mp4

04:12

3. Cell Absolute Reference.mp4

07:42

4. Error In Formula.mp4

03:39

5. Circular References.mp4

01:59

6. Value Paste.mp4

02:04

33. Chap 4 excel

1. Define Name of Cell and Cell Range.mp4

05:25

2. Define Name Using Name Manager.mp4

02:38

3. Retrieve value from Other Workbook.mp4

02:26

4. Naming Convention in define Names.mp4

04:16

5. Intersection.mp4

02:41

34. Chap 5 Excel

1. Determine Cell Values are Text or Not.mp4

05:32

2. Determine Cell Values are Identical or Not.mp4

06:01

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

05:59

4. Removing Excess Space and Non Printing Characters.mp4

02:46

5. Counting Characters Using Len Function.mp4

04:19

6. Padding a Number.mp4

05:16

7. Changing Case of Text.mp4

01:17

8. Extract Characters from String.mp4

05:52

9. Extracting First Word Using Find Function.mp4

04:18

35. Chap 6 excel

1. Understanding the Dates in Excel.mp4

03:59

2. Today Function in Excel.mp4

07:00

3. Date Function in Excel.mp4

04:36

4. Convert Non Date String to a Date in Excel.mp4

03:04

5. Calculate Days between Two Dates.mp4

03:23

6. Days and Days 360 Functions in Excel.mp4

04:50

7. Network Days Calculate Work Days.mp4

03:51

8. Network Day INTL.mp4

02:38

9. Workday and Workday INTL Function.mp4

03:52

10. DateDIF.mp4

03:42

11. Calculate Last Day of the Year.mp4

02:07

36. Chap 7 excel

1. Understand Time Functionality in Excel.mp4

08:41

2. Summing of Time Values.mp4

04:00

3. Calculate Working Hours in Excel.mp4

02:11

4. Convert Integer values into Time Value.mp4

02:25

5. Round Up Time Values.mp4

02:42

37. Chap 8 excel

1. How to use Images and Shapes in Excel.mp4

13:56

38. Chap 9 excel

1. Data Validation.mp4

07:43

39. Chap 10 excel

1. logical Functions.mp4

08:53

40. Chap 11 excel

1. VLOOKUP Function.mp4

05:33

2. advance Use of VLOOKUP and HLOOKUP Function.mp4

05:32

Description

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

What You'll Learn?

Mastering Word Basics: Students will learn fundamental skills, including creating, editing, and formatting documents, as well as utilizing essential tools like
Advanced Formatting Techniques: Gain proficiency in advanced formatting options such as styles, themes, and templates, ensuring documents are professional and v
Efficient Document Management: Discover how to effectively manage and organize documents using features like headers and footers, page numbering, and table of c
Collaborative Tools and Techniques: Explore Microsoft Word's collaboration features, including track changes, comments, and sharing documents with others for re
Automation and Productivity Enhancements: Learn to automate tasks and boost productivity with Word's powerful tools such as mail merge, macros, and custom short
PowerPoint - Stunning Slide Design: Craft visually striking and professional slides with ease.
Dynamic Animations: Master advanced animations and transitions to captivate your audience.
Multimedia Integration: Seamlessly incorporate images, videos, and audio for richer presentations.
Data Visualization: Create and customize charts and graphs to present data clearly.
Confident Delivery: Enhance your presentation skills for impactful and professional delivery.
Outlook: Email Management: Organize and prioritize emails with folders, categories, and rules.
Outlook: Calendar Scheduling: Manage appointments and events, and sync with other calendars.
Outlook: Tasks and To-Do Lists: Create and track tasks, set deadlines, and set reminders.
Outlook: Search and Filtering: Use advanced search and filtering to find emails and events quickly
EXCEL: Cell Formatting & Conditional Formatting: Enhance readability and highlight key data.
EXCEL: Formulas & Functions: Use essential functions like SUM, VLOOKUP, and IF for calculations
EXCEL: Data Management & Validation: Manage and validate data entry for consistency.
EXCEL: Advanced Formulas: Apply complex functions and text manipulations.

Who is this for?

Beginners: Individuals who are new to Microsoft Office and want to build a strong foundation in document creation and editing.

Students: College and university students looking to enhance their Excel, word, power point processing skills for academic assignments, reports, and research papers.

Professionals: Office workers, administrative assistants, and other professionals who use Microsoft office Applications in their daily tasks and want to improve their efficiency and productivity

Freelancers and Writers: Freelance writers, authors, and bloggers who need advanced formatting and editing skills to produce high-quality content.

Job Seekers: Anyone preparing for job applications and interviews who needs to create polished and professional resumes, cover letters, and other documents.

What You Need to Know?

Basic Computer Skills: Students should have a basic understanding of how to use a computer, including navigating the operating system and using a mouse and keyboard.

Access to Microsoft Office: A copy of Microsoft Office 2016 or later is required to follow along with the course exercises and practice the skills being taught.

Internet Connection: A stable internet connection is needed to access course materials, watch video lectures, and participate in any online activities or discussions.

Willingness to Learn: Students should come prepared with a desire to learn and improve their Microsoft Word skills, from the basics to advanced functionalities

No Prior Experience Necessary: No previous experience with Microsoft Word is required, as the course will cover everything from the ground up.

More details

Description
Ultimate Complete Microsoft Office 2019/2021/365 Course: Basic to Advanced
Unlock the full potential of Microsoft Office with this comprehensive course designed to take you from a beginner to an advanced user. Whether you're looking to enhance your career skills or improve your personal productivity, this course covers everything you need to know about Excel, PowerPoint, Outlook, and Word.

What You'll Learn:
TOPICS PROVIDED HERE JUST FOR REFERENCE. SEE THE CURRICULUM SECTION FOR ALL TOPICS

Microsoft Excel:

Excel Interface: Explore the Excel interface, including the Ribbon and Quick Access Toolbar, to efficiently navigate and utilize various tools and features for effective spreadsheet management.
Formatting: Learn how to apply and customize cell formatting, use conditional formatting to highlight important data, and employ styles and themes to ensure a consistent and professional look across your spreadsheets.
Selection Techniques: Master various selection techniques, from basic click-and-drag methods to advanced shortcuts and Fill Handle features, to streamline data manipulation and enhance productivity.
Data Entry Tricks: Discover tips and tricks for efficient data entry, including using Data Validation to ensure accurate input, leveraging AutoComplete and Flash Fill for quicker entry, and employing keyboard shortcuts for faster data handling.
Complex Form Design in Minutes: Develop advanced form design skills.
Date Functions: Gain proficiency in working with date functions, such as TODAY(), NOW(), and DATEDIF(), to manage and manipulate date values effectively and format dates in various styles.
Time Functions: Understand and apply time functions, including TIME(), HOUR(), and TEXT(), to manage time values, calculate time differences, and format time in different styles.
Lookup Functions: Learn to use lookup functions such as VLOOKUP(), HLOOKUP(), INDEX(), MATCH(), and XLOOKUP() to search for and retrieve data from tables or ranges based on specified criteria.
Comparison Functions: Utilize comparison functions like IF(), AND(), OR(), and comparison operators to perform logical tests, handle errors, and make decisions based on data conditions.

Microsoft PowerPoint:
Design visually appealing presentations with professional templates
Incorporate multimedia elements and animations for engaging slideshows
Master the art of presenting data effectively with custom charts and graphs
Use advanced features for seamless presentations and speaker notes
Microsoft Outlook:
Manage your email efficiently with advanced sorting, filtering, and organization techniques
Schedule and manage tasks and appointments using the integrated calendar
Collaborate effectively with team members through shared mailboxes and folders
Utilize Outlookâ€™s integration with other Office applications for streamlined workflow
Microsoft Word:
Develop professional documents with advanced formatting and styling techniques
Create and manage long documents with features like tables of contents and indexes
Use collaboration tools for editing and reviewing documents with others
Automate repetitive tasks with templates and mail merge

Course Features:
Expert Instruction: Learn from an experienced instructor with a proven track record in teaching Microsoft Office.
Hands-On Practice: Engage in practical exercises and real-world scenarios to reinforce your learning.
Lifetime Access: Get lifetime access to course materials and updates to stay current with the latest features.
Certification: Receive a certificate upon completion to showcase your skills to potential employers or clients.
Whether you're a complete beginner or looking to refine your skills, this course provides a step-by-step approach to mastering Microsoft Office applications. Enroll now and transform your productivity!
Who this course is for:
Beginners: Individuals who are new to Microsoft Office and want to build a strong foundation in document creation and editing.
Students: College and university students looking to enhance their Excel, word, power point processing skills for academic assignments, reports, and research papers.
Professionals: Office workers, administrative assistants, and other professionals who use Microsoft office Applications in their daily tasks and want to improve their efficiency and productivity
Freelancers and Writers: Freelance writers, authors, and bloggers who need advanced formatting and editing skills to produce high-quality content.
Job Seekers: Anyone preparing for job applications and interviews who needs to create polished and professional resumes, cover letters, and other documents.

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Office 365

Veer Tutorial

Instructor's Courses

Veer Tutorial is an company having high quality of computer related courses. We teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

Mahavir Bhardwaj

Instructor's Courses

Education:Master of Business Administration (MBA) with a specialization in FinanceProfessional Background:Over 20 years of extensive experience in finance, having worked in management-level positions across diverse industries.Proven track record of successful financial management and strategic decision-making.Areas of Expertise:Excel Mastery:Comprehensive understanding of advanced Excel functionalities for data analysis, financial modeling, and reporting.Practical insights into leveraging Excel as a powerful tool for financial professionals.Accounting Excellence:In-depth knowledge of accounting principles and practices.Real-world application of accounting concepts for effective financial management.SAP FICO Proficiency:Certified SAP FI ConsultantHands-on experience with SAP Financial Accounting (FI) and Controlling (CO) modules.Practical insights into integrating SAP FICO for streamlined financial processes.MS Office Integration:Expertise in utilizing the Microsoft Office suite to enhance productivity in finance-related tasks.Integration of MS Office tools for seamless workflow in financial management.Professional Approach:Dedicated to providing practical, real-world insights derived from years of experience.Embraces a dynamic teaching style that combines theory with hands-on, practical applications.Committed to staying updated on the latest technological advancements in the finance industry.Passion for Technology:A genuine tech enthusiast with a keen interest in adopting and teaching the latest technologies in the finance domain.Actively seeks out and incorporates innovative tools and techniques to enhance the learning experience.Why Learn from Mahavir Bhardwaj?Benefit from a wealth of industry knowledge accumulated over two decades.Gain practical skills that are immediately applicable in professional settings.Join a learning journey led by an instructor passionate about staying at the forefront of technological advancements in finance.Embark on your learning path with Mahavir Bhardwaj, where expertise meets innovation in the realm of finance education.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.