Whether you're an average Java Developer and looking for a course to master Java Design Patterns or want to get the insights into the core of Software Development principles and Design patterns, then taking this Java Design Patterns - The Complete Masterclass - Update '18 course will be perfect for you. With this course, learn the patterns for creating versatile, reusable objects, and discover example use cases, conclude with implementation guidance, tips and techniques for avoiding the challenges posed by an individual pattern Some of the popular creational patterns such as Builder, Singleton, Prototype, Factory Method, and Abstract Factory and other essential concepts like multithreading, hierarchies and mutability also discussed in this course. By the time you complete this course, you'll be able to implement each design pattern in your own Java projects efficiently. What you'll learn Master Java Design Patterns Apply Design Patterns to Real-World Projects Build Software that's Robust and Flexible Using Java Design Patterns Solve common Software architecture problems with Java Design Patterns Requirements Working Java or any OOP Programming Language Knowledge Understand Interfaces, Composition, Inheritance, Polymorphism Willingness to learn and work hard This is NOT a Beginners Course Who this course is for: Programmers with Intermediate to advanced Software development knowledge Developers who want to learn about Programming Design Patterns Introduction Introduction 00:03:00 What You'll Get from this Course 00:05:00 Value: $5000 USD - Download Your FREE Bundle 00:05:00 Download All of the Slides Used in the Course 00:30:00 Download all the Source code for this Course 00:05:00 The gang of Four - The origins of Design Patterns -Strategy Design Pattern The Concepts Behind Design Patterns 00:05:00 The Strategy Design Pattern - Introduction 00:06:00 The Strategy Design Pattern -Score System 00:15:00 The Strategy Design Pattern - Payment System 00:02:00 The Strategy Design Pattern - Payment System - Part 2 00:12:00 The Strategy Design Pattern - Payment System - Final 00:07:00 Resources 00:15:00 Strategy Pattern Exercise and Challenge 00:15:00 The Observer Design Pattern The Observer Design Pattern 00:04:00 The Observer Design Pattern - Classes Creation 00:12:00 The Observer Design Pattern - Final 00:13:00 Resources 2 00:05:00 Strategy Pattern Exercise and Challenge 11 00:15:00 The Java Decorator Design Pattern The Decorator Design Pattern - Introduction 00:04:00 The Decorator Design Pattern - Classes Creation 00:11:00 The Decorator Design Pattern - Final 88 00:09:00 Resources 88 1 00:10:00 The Factory and Simple Factory Design Pattern Introduction to Simple Factory Design Pattern 00:07:00 The Factory Design Pattern - Introduction 00:03:00 The Factory Design Pattern - Part 2 00:12:00 The Factory Design Pattern - Final 00:08:00 Resources 88 2 00:05:00 The Singleton Design Pattern The Singleton Design Pattern - Introduction 00:03:00 The Singleton Design Pattern -Our First Singleton Class 00:06:00 The Singleton Design Pattern - Synchronized Method 00:07:00 The Singleton Design Pattern - Eager Creation 00:04:00 The Singleton Design Pattern - Double-Check Locking Creation 00:06:00 Resources 88 3 00:05:00 The Command Design Pattern in java The Command Design Pattern - Introduction 00:09:00 The Command Design Pattern - Gameboy Example 00:06:00 The Command Design Pattern - Command Interfaces Creation 00:09:00 The Command Design Pattern - Final 00:16:00 Resources 88 4 00:05:00 The Adapter Design Pattern The Adapter Design Pattern - Introduction 00:04:00 The Adapter Design Pattern - Diagram and Class Creation 00:12:00 The Adapter Design Pattern - Object Adapter 00:05:00 The Adapter Design Pattern - Final 00:03:00 Resources 88 5 00:05:00 The Facade Design Pattern The Facade Design Pattern - Introduction 00:04:00 The Facade Design Pattern - Final 00:13:00 Resources 88 6 00:05:00 The Template Design Pattern The Template Method Design Pattern 00:04:00 The Template Method Design Pattern - Part 2 00:07:00 The Template Method Design Pattern - Final 00:12:00 Resources 88 7 00:05:00 The Iterator Design Pattern About Iterator Design Pattern - Introduction 00:06:00 The Problem and Obvious Solution 00:05:00 Iterator Design Pattern Example - Geeky and Dev Stores 888 00:14:00 Rolling our Own Iterator Class 00:08:00 The Java Iterator Class 00:09:00 The State Design Pattern Introduction to Design Patterns - The State Design Pattern 00:08:00 State Design Pattern- The Obvious Solution 00:12:00 State Design Pattern- The Obvious Solution - Part 2 00:06:00 State Design Pattern- The Correct Solution - Part 1 00:13:00 State Design Pattern- The Correct Solution - Part 2 00:12:00 State Design Pattern- The Correct Solution - Test drive - Final 00:09:00 Resources 88 9 00:05:00 The Proxy Design Pattern Introduction to Proxy Design Pattern 00:05:00 Remote Proxy Design Pattern Implementation 00:11:00 Resources 88 10 00:05:00 The MVC - Model View Controller Design Pattern Introduction to MVC Design Pattern 00:07:00 MVC - Class Creation 00:10:00 MVC - Implementation 00:08:00 The Builder Design Pattern Introduction to Builder Design Pattern 00:05:00 Builder Design Pattern Implementation 00:14:00 The Interface Builder Design Pattern - Part 1 00:09:00 The Interface Builder Design Pattern - Final 00:08:00 The Prototype Design Pattern Introduction to Prototype Design Pattern 00:04:00 Cloning Person and Dolphin Objects 00:10:00 Using the Java Cloneable Interface 00:10:00 The Mediator Design Pattern Introduction to Mediator Design Pattern 00:05:00 Meditator Project with Code - Part 1 00:09:00 Meditator Project with Code - Final 00:10:00 Resources 88 11 00:05:00 The Visitor Design Pattern Introduction to Visitor Design Pattern 00:05:00 The Visitor Design Pattern - Cont. 00:07:00 The Visitor Design Pattern - Final 00:10:00 Resources 88 12 00:05:00 The Memento Design Pattern Introduction to Memento Design Pattern 00:05:00 Memento Class Creation 00:06:00 Memento - Final 00:08:00 Resources 88 13 00:05:00 The Interpreter Design Pattern Introduction to the Interpreter Design Pattern 00:03:00 The Interface Interpreter Design Pattern - Final 00:12:00 Resources 88 14 00:05:00 The Chain of Responsibility Design Pattern Introduction to Chain of Responsibility Design Patterns 00:04:00 The Chain of Responsibility Design Pattern - cont 00:09:00 The Chain of Responsibility Design Pattern - Final 00:07:00 Resources 88 15 00:05:00 The Bridge Design Pattern Introduction to Bridge Design Pattern 00:04:00 Bridge Design Pattern - Classes Setup 00:07:00 Bridge Design Pattern - Final 00:03:00 Resources 88 16 00:05:00 The Flyweight Design Pattern Introduction to Flyweight Design Pattern 00:01:00 Flyweight - Final 00:12:00
This course is a mix of theory and coding to give you experience in building Kafka applications using AVRO and Schema Registry. You will code and build a coffee order service using Spring Boot and Schema Registry. Anyone interested in learning about Schema Registry and how to build Kafka Producer and Consumer applications that interact with Schema Registry can take up the course.
In this course, we will understand the absolute basic concepts of programming. Learn essential C# scripting for game development by building 20+ mini projects. We will also build 2D games with Unity and C#, and master C# by building these games with Unity.
Get ready to dive into the exciting world of Unity game development and C# scripting! With a hands-on approach, you will craft a variety of thrilling 2D and 3D games using Unity and C#. Uncover the art of building and exporting games to the Android mobile platform. This course is tailor-made for someone who wants to learn Unity and C# through real-world projects.
This course is designed to demonstrate and help you learn the core concepts of working with jQuery. jQuery can help you develop web projects more quickly. jQuery makes creating dynamic and interactive web content easy! Learn the fundamentals of jQuery and find out why it's so amazing to work with. You can do so many great things with jQuery.
Learn RabbitMQ: Asynchronous Messaging with Java and Spring
Course on all the Essentials of Microsoft Office Looking to learn everything there is about all the Microsoft Office programs? This course will give you exactly what you are looking for. Learn all there is about Microsoft Word, Excel, Outlook, PowerPoint, OneNote, Access, Publisher, Project, InfoPath, SharePoint Designer and Visio. Certified Microsoft Office Essentials introduces a new graphical interface user called the Fluent User Interface, which uses ribbons and an Office menu instead of menu bars and toolbars. Office also introduced Office Open XML file formats as the default file formats in Excel, PowerPoint, and Word. Office also introduces a feature called 'Live Preview', which temporarily applies formatting on the focused text or object, when any formatting button is moused-over. This Course is designed to make you learn everything about all the Microsoft Office tools of and all of its new features. Learning all the office softwares increases your credibility in today's competitive job market. So what are you waiting for? This is the course for you. Course Highlights Certified Microsoft Office Essentials is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Certified Microsoft Office Essentials into 77 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 2 days, 19 hours hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Certified Microsoft Office Essentials Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Certified Microsoft Office Essentials is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Certified Microsoft Office Essentials is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Microsoft Word Module One - Getting Started FREE 00:30:00 Module Two - Opening Word FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Document 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Basic Formatting Tasks 01:00:00 Module Seven - Formatting Paragraphs 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Sharing Your Document 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities- Microsoft Word for Beginners Accredited Course 00:00:00 Microsoft Excel Module One - Getting Started FREE 00:30:00 Module Two - Opening Excel FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Worksheet 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Building Formulas 01:00:00 Module Seven - Using Excel Functions 01:00:00 Module Eight - Using Quick Analysis 01:00:00 Module Nine - Formatting Your Data 01:00:00 Module Ten - Using Styles, Themes, and Effects 01:00:00 Module Eleven - Printing and Sharing Your Workbook 01:00:00 Module Twelve - Wrapping Up 01:00:00 Activities - Microsoft Excel for Beginners CPD & IAO Accredited 00:00:00 Microsoft PowerPoint Module One - Getting Started FREE 00:30:00 Module Two - Opening PowerPoint FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Presentation 01:00:00 Module Five - Working with Text 01:00:00 Module Six - Formatting Text and Paragraphs 01:00:00 Module Seven - Adding Pictures 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Transitions and Animations 01:00:00 Module Ten - Setting Up Your Slide Show 01:00:00 Module Eleven - Showtime! 01:00:00 Module Twelve - Wrapping Up 00:30:00 Certified Microsoft PowerPoint for Beginners - Activities 00:00:00 Microsoft Access Module One - Getting Started 00:30:00 Module Two - Opening and Closing Access FREE 01:00:00 Module Three - An Introduction to Databases 01:00:00 Module Four - Sharing Data Using Apps 01:00:00 Module Five - Working in Your App 01:00:00 Module Six - An Introduction to Desktop Databases 01:00:00 Module Seven - Performing Basic Table Tasks 01:00:00 Module Eight - Working with Fields 01:00:00 Module Nine - Working with Table Relationships 01:00:00 Module Ten - An Introduction to Queries, Forms, and Reports 01:00:00 Module Eleven - Protecting Your Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft Access for Beginners CPD Accredited 00:00:00 Microsoft Outlook Module One - Getting Started FREE 00:30:00 Module Two - Opening and Closing Outlook FREE 01:00:00 Module Three - Understanding the Interface 01:00:00 Module Four - Working with the Message List and the Reading Pane 01:00:00 Module Five - Using Message List Commands 01:00:00 Module Six - Creating a New Email 01:00:00 Module Seven - Managing Email 01:00:00 Module Eight - Searching for Items 01:00:00 Module Nine - An Introduction to the Calendar 01:00:00 Module Ten - An Introduction to Tasks 01:00:00 Module Eleven - An Introduction to Contact 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Accredited Microsoft Outlook for Beginners 00:00:00 Microsoft Publisher Module One - Getting Started 00:30:00 Module Two - Opening Publisher 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Publication 01:00:00 Module Five - Working with Pictures 01:00:00 Module Six - Basic Editing Tasks 01:00:00 Module Seven - Formatting Fonts 01:00:00 Module Eight - Formatting Paragraphs 01:00:00 Module Nine - Working with Objects 01:00:00 Module Ten - Working with Pages 01:00:00 Module Eleven - Publishing Your Work 01:00:00 Module Twelve - Wrapping Up 00:30:00 Mock Exam Mock Exam- Certified Microsoft Office Essentials 00:30:00 Final Exam Final Exam- Certified Microsoft Office Essentials 00:30:00
Embark on a transformative Python web development journey with this course and dive deep into creating a dynamic book rental system from scratch. Master Django's import-export capabilities, design elegant UI with Tailwind CSS, implement advanced features, and more. Elevate your skills and build real-world applications effortlessly!
Register on the AutoCAD Programming using C# with Windows Forms today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The AutoCAD Programming using C# with Windows Forms is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The AutoCAD Programming using C# with Windows Forms Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the AutoCAD Programming using C# with Windows Forms, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Introduction Introduction 00:03:00 Who is this course for? 00:02:00 Tools needed in this course 00:01:00 What will you learn from this course? What will you learn from this course? 00:05:00 Windows Form and Controls Controls Project Demo - Overview 00:03:00 Controls Demo Project Requirement - Explained 00:03:00 Create the Controls Demo Project 00:03:00 Controls Demo Project - Creating the Form (User Interface) 00:15:00 Develop the Controls Demo Utility Class 00:10:00 Using Combobox Control to select an option 00:13:00 Using Textbox Control to select an option 00:09:00 Using Radiobutton Control to select an option 00:06:00 Using Checkbox Control to select an option(s) 00:18:00 Developing Real World Projects Developing Projects - Overview 00:03:00 Project 1: Creating a Rectangle - Project Overview 00:03:00 Project 1: Creating the Rectangle Utility Class 00:17:00 Project 1: Creating the User Interface 00:10:00 Project 1: Coding the User Interface28:50 00:29:00 Project 1: Running and Testing the Draw Rectangle Plugin 00:08:00 Project 2: Update Objects Layer - Overview 00:02:00 Project 2: Create the User Interface of Update Objects Layer Plugin 00:09:00 Project 2: Coding the Form Load Event 00:07:00 Project 2: Coding the Browse drawing Button 00:03:00 Project 2: Coding the Update Button control 00:07:00 Project 2: Coding the Update Layer Utility Class 00:12:00 Project 2: Running and Testing the Plugin 00:08:00 Project 3: Extracting Block Attributes to Files - Overview 00:03:00 Project 3: Creating the AutomaticBlockExtractor Project 00:02:00 Project 3: Creating the User Interface for the BlockExtractor Project 00:09:00 Project 3: Completing User Interface code 00:22:00 Project 3: Coding the AutoBlockExtractor Utility Class 00:24:00 Project 3: Running and Testing the AutomaticBlockExtractor Plugin in AutoCAD 00:15:00 Project 4: Updating MText Textstyle Project - Overview and Walkthrough 00:05:00 Project 4: Creating the UpdateTextStyle Utility Class 00:19:00 Project 4: Designing the UpdateTextStyle Plugin User Interface 00:06:00 Project 4: User Interface Code 00:16:00 Project 4: Running and Testing the UpdateTextstyle Plugin 00:05:00 Project 5: Converting Drawing to PDF Plugin - Overview 00:03:00 Project 5: Creating the PlotDWGtoPDF Project in Visual Studio 2019 00:04:00 Project 5: Creating the User Interface for MultiplePlotDWGtoPDF Project 00:09:00 Project 5: Coding the User Interface 00:16:00 Project 5: Developing the GetPlotSizes Method 00:10:00 Project 5: Developing the PlotCurrentLayout Method 00:27:00 Project 5: Testing and Running the MultiplePlotDWGtoPDF Project 00:10:00 Project 6: Multiple Object Extractor Project - Overview 00:03:00 Project 6: Creating the MultiObjectExtractor Project 00:02:00 Project 6: Designing the MultiObjectExtractor User Interface 00:14:00 Project 6: Coding the FormLoad Event 00:07:00 Project 6: Coding the BrowseDwg Button 00:12:00 Project 6: Coding the BrowseFile Button 00:03:00 Project 6: Coding the ProcessExtract Button 00:05:00 Project 6: Creating the Code Validation Methods 00:10:00 Project 6: Coding the ProcessDrawing Method 00:19:00 Project 6: Coding the ProcessObjectExtraction Method 00:11:00 Project 6: Coding the ExtractLine Method 00:11:00 Project 6: Coding the ExtractCircle Method 00:04:00 Project 6: Coding the ExtractPolyline Method 00:11:00 Project 6: Coding the ExtractMText Method 00:05:00 Project 6: Coding the ExtractBlock Method 00:03:00 Project 6: Coding the ExtractObjects Method 00:02:00 Project 6: Running and Testing the MultiObjectExtractor Plugin 00:14:00 Conclusion Conclusion and Thank you 00:01:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.
Overview This comprehensive course on Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. It is available to all students, of all academic backgrounds. Requirements Our Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 34 sections • 135 lectures • 08:20:00 total length •Introduction: 00:03:00 •Getting started on Windows, macOS, and Linux: 00:01:00 •How to ask great questions: 00:01:00 •FAQ's: 00:01:00 •Excel Overview: 00:05:00 •Start Excel Spreadsheet: 00:04:00 •Enter Text and Numbers: 00:07:00 •Relative References: 00:04:00 •Working with ranges: 00:07:00 •Save and Save as Actions: 00:08:00 •File Extensions, Share, Export, and Publish files: 00:06:00 •Adding Rows and Columns: 00:03:00 •Modifying Rows and Column lengths: 00:05:00 •Copy, Cut, and Paste: 00:07:00 •Copying Formulas: 00:03:00 •Page setup options: 00:06:00 •Fit to print on One Page: 00:03:00 •Print Workbooks: 00:03:00 •Sorting Data Ascending Order: 00:04:00 •Sorting Data Descending Order: 00:02:00 •Filter Data: 00:04:00 •Creating Basic Formulas: 00:06:00 •Datetime Formulas: 00:06:00 •Mathematical formulas phase1: 00:20:00 •Mathematical formulas phase2: 00:12:00 •VLOOKUP formula: 00:12:00 •HLOOKUP formula: 00:04:00 •XLOOKUP: 00:08:00 •Handling #NA and Approximates match in XLOOKUP: 00:11:00 •Split Text into columns: 00:07:00 •Flash Fill: 00:07:00 •Data Validation: 00:07:00 •Remove Duplicates: 00:08:00 •Import Data from Text files: 00:06:00 •Import Data from .CSV files: 00:03:00 •Formatting Font: 00:04:00 •Formatting Alignment: 00:06:00 •Formatting Numbers: 00:05:00 •Formatting Date: 00:03:00 •Formatting Tables: 00:05:00 •Pivot Tables: 00:07:00 •Pivot Charts: 00:02:00 •Excel Charts - Categories: 00:03:00 •Elements of a chart: 00:04:00 •Creating Charts: 00:02:00 •Column or Bar charts: 00:04:00 •Formatting charts: 00:04:00 •Line Charts: 00:02:00 •Pie and Doughnut charts: 00:04:00 •Overview: 00:04:00 •Start PowerPoint Presentation: 00:05:00 •Screen setting and Views: 00:05:00 •Presentation Tips and Guidelines: 00:06:00 •Creating a New Presentation: 00:04:00 •Working with Slides: 00:04:00 •Save a Presentation: 00:04:00 •Print Slides: 00:03:00 •Formatting Text: 00:05:00 •Slide Text Alignments: 00:03:00 •Multi-Column Text Alignments: 00:02:00 •Adding Bullets and Numbered List Items: 00:03:00 •Insert Shapes: 00:03:00 •Insert Icons: 00:03:00 •Insert Graphics: 00:04:00 •Add 3D Models: 00:03:00 •Insert Pictures: 00:03:00 •Picture Options: 00:04:00 •Picture Cropping: 00:03:00 •Applying Built-in Picture Styles: 00:04:00 •Add SmartArt Graphic: 00:03:00 •Modifying SmartArt: 00:03:00 •Creating a Target Chart using SmartArt: 00:03:00 •Create a Table on Slide: 00:04:00 •Formatting Tables: 00:02:00 •Inserting Tables: 00:02:00 •Table Layouts: 00:01:00 •Add a Chart: 00:02:00 •Formatting Charts: 00:02:00 •Insert Chart from Microsoft Excel: 00:03:00 •Adding Video to a Presentation: 00:03:00 •Adding Audio to a Presentation: 00:02:00 •Screen Recording and Adding: 00:02:00 •Applying Transitions to Presentation: 00:04:00 •Object Animation: 00:03:00 •Effect Options: 00:02:00 •Advanced Animation: 00:02:00 •Triggers to control animation: 00:02:00 •Onscreen Presentation: 00:02:00 •Hiding Slides: 00:02:00 •Changing Order of Slides: 00:02:00 •Copying Slides: 00:02:00 •Overview of MS Word: 00:04:00 •Start MS Word 2021: 00:05:00 •Create a new blank document: 00:04:00 •Creating a paragraph text: 00:05:00 •Non-printing characters: 00:03:00 •Save a document: 00:03:00 •Open a document: 00:01:00 •Find and replace: 00:04:00 •AutoCorrect options: 00:03:00 •Formatting text: 00:04:00 •Copy cut and paste: 00:04:00 •Character formatting: 00:02:00 •Format painter: 00:04:00 •Work with numbers: 00:02:00 •Add bullets: 00:03:00 •Outline creation: 00:04:00 •Creating a table: 00:03:00 •Adding rows and columns to a table: 00:02:00 •Formatting table data: 00:02:00 •Borders and shading: 00:02:00 •Sorting in a table: 00:04:00 •Draw a table: 00:04:00 •Convert text to table: 00:03:00 •Convert table to text: 00:02:00 •Insert a spreadsheet: 00:02:00 •Quick tables - readily available formats: 00:02:00 •Working with styles: 00:02:00 •Creating styles: 00:02:00 •Clear formatting: 00:01:00 •Margins: 00:02:00 •Orientation: 00:01:00 •Page size setting: 00:01:00 •Adding columns: 00:03:00 •Page break - section break: 00:02:00 •Adding watermark: 00:03:00 •Headers and footers: 00:03:00 •Create envelops: 00:02:00 •Creating labels: 00:02:00 •Creating a mail merge document: 00:03:00 •Thesaurus and spell check: 00:01:00 •Word count: 00:01:00 •Speech - read aloud: 00:01:00 •Language - translate: 00:01:00 •Tracking: 00:01:00