Description Here at iStudy, we put our heart and soul into every single course we design. We make sure that all our courses are designed and developed by industry experts. Our aim is to always provide value to our learners with quality courses. Our learners are our top priority, and you as a learner will gain tremendous knowledge and skill on this topic from this The Magic Of Starting Over. The certification that you will receive upon completing this The Magic Of Starting Over will help to boost your resume and will help you stand out among your peers in the competitive job market. Our course will help you get employed in the relevant field and advance your career. Enjoy this expertly made course from iStudy. Enrol now! Why You Should Choose The Magic Of Starting Over Lifetime access to the course No hidden fees or exam charges 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? The Magic Of Starting Over is CPD Qualification Standards and CiQ accredited, 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 The Magic Of Starting Over 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. Start Fresh: Break the Chains of Past Mistakes Course Promo 00:03:00 Lesson 01: Introduction 00:01:00 Lesson 02: The Past Is Gone Forever 00:06:00 Lesson 03: The Dangers Of Getting Stuck In The Past 00:06:00 Lesson 04: Why The Past Doesn't Equal The Future 00:05:00 Lesson 05: Benefits Of Forging Ahead 00:05:00 Lesson 06: How To Bounce Back From Past Failures 00:05:00 Lesson 07: Great People Who Had Rough Pasts 00:06:00 Lesson 08: Overcoming Negative Self-Talk 00:06:00 Lesson 09: Making Plans For A Better Future 00:06:00 Lesson 10: Conclusion - Final Thoughts & Ideas 00:01:00 Downloadable Resources Resource - Start Fresh: Break the Chains of Past Mistakes 00:00:00
Description Here at iStudy, we put our heart and soul into every single course we design. We make sure that all our courses are designed and developed by industry experts. Our aim is to always provide value to our learners with quality courses. Our learners are our top priority, and you as a learner will gain tremendous knowledge and skill on this topic from this Microsoft Advertising Course. The certification that you will receive upon completing this Microsoft Advertising Course will help to boost your resume and will help you stand out among your peers in the competitive job market. Our course will help you get employed in the relevant field and advance your career. Enjoy this expertly made course from iStudy. Enrol now! Why You Should Choose Microsoft Advertising Course Lifetime access to the course No hidden fees or exam charges 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? Microsoft Advertising Course is CPD Qualification Standards and CiQ accredited, 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 Microsoft Advertising Course 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. Introduction to Microsoft Ads Training Lesson 1 - Microsoft Ads Training 00:02:00 Lesson 2 - Microsoft Ads Training 00:02:00 Lesson 3 - Microsoft Ads Training 00:01:00 Lesson 4-5 - Microsoft Ads Training 00:02:00 Lesson 6-10 - Microsoft Ads Training 00:07:00 Lesson 11-15 - Microsoft Ads Training 00:11:00 Lesson 16-20 - Microsoft Ads Training 00:06:00 Lesson 21-25 - Microsoft Ads Training 00:07:00 Lesson 26-30 - Microsoft Ads Training 00:06:00 Lesson 31-35 - Microsoft Ads Training 00:06:00 Lesson 36-40 - Microsoft Ads Training 00:06:00 Lesson 41-45 - Microsoft Ads Training 00:06:00 Lesson 46-50 - Microsoft Ads Training 00:06:00 Resource - Introduction to Microsoft Ads Training 00:00:00
Overview The Advanced Diploma in Microsoft Excel is the best way for you to gain deep insight and knowledge of this topic. You will learn from industry experts and obtain certificates after completing the course. Enrol now for a limited-time discounted price. Like all the courses of The Teachers Training, this Advanced Diploma in Microsoft Excel is designed with the utmost attention and thorough research. All the topics are broken down into easy to understand bite-sized modules that help our learners to understand each lesson very easily. We don't just provide courses at The Teachers Training; we provide a rich learning experience. After purchasing a course from The Teachers Training, you get complete lifetime access with tutor support. Our expert instructors are always available to answer all your questions and make your learning experience exquisite. After completing the Advanced Diploma in Microsoft Excel, you will instantly get an e-certificate that will help you get jobs in the relevant field and will enrich your CV. What You Will Learn Get to know about relevant job opportunities. Format data labels, create excel values and build basic formulas in excel. Learn all the functions like SUM(), MIN(), MAX() etc Be able to insert images and shapes and customise icons Change layout views, convert spreadsheets into PDFs and print specific ranges of cells Learn how to group and filter pivot table data Skills You Will Gain Keyboard shortcuts Conditional formatting Flash Fill Filters/ AutoFilter Fast Track your Excel skills Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Assessment To successfully complete the course you must have to attend the MCQ assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion. Certification CPD Certification from The Teachers Training: Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs.
ð Elevate Your Business with 'Strategic Marketing Initiatives for Customer Growth' Online Course! ð Are you ready to skyrocket your business to new heights? Unleash the power of strategic marketing with our exclusive online course - 'Strategic Marketing Initiatives for Customer Growth.' Whether you're a seasoned entrepreneur or just starting, this course is your roadmap to success! ð Module 1: Introduction Dive into the foundations of strategic marketing as we kickstart your journey towards business excellence. Discover the key principles, concepts, and frameworks that form the backbone of successful marketing initiatives. Gain insights into market dynamics, consumer behavior, and the latest trends that will shape your marketing strategy. ð¥ Module 2: Marketing Programs Unlock the secrets to creating impactful marketing programs that resonate with your target audience. From traditional methods to cutting-edge digital strategies, this module covers it all. Learn how to design and implement campaigns that not only attract but also retain customers. Explore case studies of successful marketing programs and adapt them to suit your unique business needs. ⨠What You'll Gain: Strategic Thinking: Develop a strategic mindset to identify and leverage opportunities in the market. Effective Planning: Learn how to plan and execute marketing initiatives that align with your business goals. Customer-Centric Approach: Understand your customers better and tailor your marketing efforts to meet their needs. Measurable Results: Discover how to track and measure the success of your marketing programs for continuous improvement. Industry Insights: Stay ahead of the competition with the latest trends and insights in the ever-evolving marketing landscape. ð©âð» Who Should Enroll: Entrepreneurs and Small Business Owners Marketing Professionals Aspiring Marketers and Students Anyone Looking to Boost Customer Growth ð Why Choose Our Course: Expert Instructors: Learn from industry experts with a proven track record in strategic marketing. Flexible Learning: Study at your own pace and from the comfort of your home or office. Practical Applications: Gain real-world skills through practical exercises and case studies. Lifetime Access: Enjoy lifetime access to course materials and updates. ð¯ Don't miss this opportunity to transform your marketing approach and drive unprecedented growth for your business! Enroll now and embark on a journey towards success! Course Curriculum Module 1- Introduction Marketing Programs Explained 00:00 Module 2- Marketing Programs What types of marketing programs are best for your business 00:00 Your Website 00:00 SEO 00:00 Advertising Online 00:00 Print Advertising 00:00 Press Relations 00:00 Social Media 00:00 Email 00:00 Content Marketing 00:00 Trade Shows 00:00 Retention Marketing 00:00 Additional Marketing Programs 00:00
The First Aid for Families course is designed to give you the theoretical knowledge needed to keep your family safe and learn how to help each other in a medical emergency. The course covers vital aspects of first aid for parents, teenagers, children, babies and people caring for elderly relatives. It covers topics such as the recovery position, choking, drowning, burns and much more. The course consists of illustrated step by step directions, flow charts, diagrams, videos and test yourself sections fully compatible with all computers and mobile devices. You will be able to stop and start as often as you like and print your Certificate on completion. You will have continuous access to the course for 12 months. It is impossible to cover all eventualities within this course, or to equip you with the knowledge and skills to appropriately diagnose and treat in unpredictable real life situations. If you suspect serious illness or injury, you should always seek immediate professional medical advice. The author has made every effort to ensure the accuracy of the information contained within the course, however this course is merely a guide and the author does not accept any liability or responsibility for any inaccuracies or for any mistreatment or misdiagnosis of any person, however caused. The First Aid for Families course material has been written by Emma Hammett, qualified nurse, first aid trainer and founder of First Aid for Life in conjunction with other medical and first aid professionals. If you have any queries concerning this course, please contact emma@firstaidforlife.org.uk Course contents: Action in an emergency Keep yourself safe Priorities of treatment Preparing for an emergency Helpful information What to put in your first aid kit Information to give the emergency services Role of the first aider The primary survey – how to help in an emergency Danger Response Airway Breathing Unresponsive and breathing Recovery position How to put someone into the recovery position How to put a baby into the recovery position Secondary survey Unconscious and not breathing Resuscitation Resuscitating a child Resuscitating a baby Hygiene during CPR Compression-only resuscitation Breathing problems Choking How to help a choking adult How to help a choking child How to help a choking baby Drowning Step-by-step – how to help a drowning casualty Asthma What causes asthma How to help in an asthma attack Croup Anaphylactic shock Wounds and bleeding Wounds and bleeding How to treat a bleeding wound Dressings Embedded objects How much blood can you afford to lose? Shock Symptoms of shock Treatment of shock Internal bleeding Knocked out teeth Amputated parts Eye injuries Nose bleeds Objects in nose Objects in ears Types of wounds Bites and stings Burns Poisoning Breaks, sprains and dislocations Head injuries Spinal injuries Fitting/seizures/convulsions Extremes of body temperature Medical conditions and childhood illnesses Useful advice Final test-yourself section and certificate
Description Have you been watching auction programs online and fancied having a go at it yourself? Do you want to be a property investor who finds great bargains at auction? Join the course tutor on this course to discover what it takes, auction secrets, how to find good deals and how to successfully prepare for the auction day. On this course, we cover: How to prepare and what to expect when buying property at auction The different types of auction buyers Going to view property Arranging finance Improving your credit rating Solicitors and legal packs On the auction day The Bidding process The Completion timeframe Case studies - real life This is a practical course and will be helpful if you are new to buying at auction and want more guidance. The tutor is online most days to answer all questions promptly. Who is the target audience? Students who want to be property investors in auction What Will I Learn? Buy a property in a UK auction Requirements You should be keen to buy at auction Introduction Introduction to the course and your tutor FREE 00:10:00 Novice vs pro FREE 00:12:00 Benefits of buying at auction 00:04:00 3 Types of buyers 00:07:00 Preparation Going to view 00:14:00 Improve credit 00:09:00 Raising funds 00:08:00 Legal packs 00:08:00 Small print 00:07:00 At the Auction On the day 00:11:00 Bidding process 00:11:00 Cant make it on the day 00:06:00 Post auction 00:04:00 Real Life Examples of Buying In Auction A Case Study 00:14:00 Options 00:10:00 Conclusion Conclusion 00:05:00 Bonus - Nightmare Scenario Introduction to one of the worst months of my life 00:12:00 Warning signs 00:14:00 28 day countdown 00:11:00 14 days till completion 00:07:00 7 day countdown 00:08:00 Completion day 00:07:00 Post Completion 00:10:00 Key learning points 00:11:00 Financials - show me the money 00:08:00
Course Description: Everybody love to travel. Travel & tourism industry is not just one of the largest economic sectors but it also enriches the life experience to communities and travelers. This Travel and Tourism certification course from Online Courses Learning is ideal for anyone who is looking to work in the travel industry especially in the United Kingdom. This course is filled with information that will put you on the right path to begin a career in this field. Travel and tourism is a booming industry, and those who wish to travel always require assistance when planning their holiday and travel plans. As you work through this course, you will obtain a full overview of working in the travel and tourism field and how you can even start your own business. Introduction This Travel and Tourism Certification Level 2 is an online course; all of the information is available to you whenever and wherever your require it. You can study at a pace that is comfortable for you, and access the information in the course 24 hours a day. Most people who take the course still work full time, which helps you maintain your current lifestyle whilst working towards achieving your dreams. To access the course, you will require a device that allows you to access the internet, and not only can you see the course, you can also use the online support feature. Furthermore, you will find the course to be incredibly easy to go through thanks to the individual modules. When completing the course, you must pass a multiple choice test, and you will then be awarded your certification. We can post this to you for an additional cost, or you can download and print it at home. What You Will Learn The Travel and Tourism course will give you a full overview of working in the travel and tourism industry, and it will fully prepare you for your new career. The course covers the following: An introduction to travel and tourism Customer services in the travel and tourism industry Developing your career in the travel and tourism industry The different sectors of the travel and tourism industry Understanding why people need the travel and tourism industry Promoting travel and tourism services Planning and development in the tourism industry Ecotourism, short haul and long haul destinations Domestic tourism in the UK How to deal with issues within the travel and tourism industry Benefits of the Travel and Tourism Certification course When you work towards earning your travel and tourism certification online, you will find a number of benefits. These include the following: You can study from anywhere there is an internet connection, and you can study at a time that is convenient for you. You can also study at a pace that is comfortable for you. There is no time limit, so if it takes you days or months, you can still complete the course. You can study from any device including a tablet, PC or mobile phone. There are easily manageable modules, which help to make studying an enjoyable experience. Online support is available to help you stay on track. Access to a comprehensive syllabus, which helps you to stay on the fast track while learning how to become a travel and tourism expert. Improving your prospects when applying for work in the field. When completing the course, you receive a certification that is respected in the industry. A pricing structure that is affordable. Course Modules: Module 1: Introduction to the Concept of Travel and Tourism Module 2 : Customer Service within the Tourism Industry Module 3 : Career Development within the Industry Module 4 : Sectors in the Industry Module 5 : The Fundamentals of Tourism Management Module 6 : Understanding the Reasons for Travel and Tourism Module 7 : Travel and Tourism Promotion Module 8 : Social Media and Tourism Module 9 : Understanding Tourism Policy and Strategy Module 10 : Tourism Planning and Development Module 11 : The Emergence of Ecotourism Module 12 : Long and Short Haul Destinations Module 13 : Domestic Tourism & the UK Market Module 14 : Current Trends in the Travel Industry Module 15: Travel and Tourism Issues to Contend With In the below video, you will see the fundamentals of travel industry
This course gives an exhaustive outline of information insurance necessities in the working environment. The course starts by giving an overall outline of information assurance. Like its advantages, and key realities about the Data Protection Act. The course additionally turns out how to assemble an information security strategy for your organization just as telling you how to react to data demands. Information insurance is a vital part of pretty much every working environment. Most organizations have some close to home information or touchy information with respect to every last one of their clients and representatives. Figuring out how to make a powerful information assurance strategy just as the accepted procedures you should utilize when managing private information is the most ideal approach to guarantee consistence with the Data Protection Act. What's Covered in the Course? Data about the Data Protection Act, including the rights stood to people and the duties presented onto associations The conditions that are joined to the social occasion, preparing, and support of information What is expected of your organization on the off chance that you need to impart information to different branches in your association The four fundamental parts of information security The most effective method to build up an ideal information assurance strategy that addresses your association's issues The means you should take to deal with demands for data from people Advantages of Taking This Course Finding out about the Data Protection Act and the advantages of consistence Acquiring knowledge into the rights stretched out to people under the Data Protection Act with respect to the treatment of their own and touchy information Understanding the commitments associations should meet on the off chance that they need to gather, use, and keep up close to home or touchy information Securing data about how to appropriately impart information to others inside your association without abusing the demonstration Acquiring significant data about the advancement of an extensive information security strategy Who can take the course? Any individual who has a premium in becoming familiar with this topic is urged to take the course. There are no passage necessities to take the course. What is the design of the course? The course is separated into 6 individual modules. Every module takes somewhere in the range of 5 and an hour on normal to consider. In spite of the fact that you are allowed to spend so a lot or as brief period as you feel vital on every module, essentially sign all through the course whenever it might suit you. Where/when would i be able to contemplate the course? You can consider the course any time you like. Just sign all through the online course as frequently as you require. The course is viable with all PCs, tablet gadgets and advanced mobile phones so you can even investigation while moving! Is there a test toward the finish of the course? Whenever you have finished all modules there is a various decision test. The inquiries will be on a scope of subjects found inside the modules. The test, similar to the course, is on the web and can be taken a period and area based on your personal preference. What is the finish mark for the last assessment? The breeze through mark for the assessment is 70%. On the off chance that you don't finish the assessment first time you will get further freedoms to step through the exam again after additional examination. There are no restrictions to the occasions you can step through the exam. All test retakes are incorporated inside the cost of the course. When will I get my endorsement? Whenever you have finished your test you can sign in to your record and download/print your endorsement any time you need it. What amount of time does it require to finish the course? We gauge that the course will require around 3 hours to finish altogether, in addition to an extra 30 minutes for the finish obviously test. Course Content Module 1: Benefits of Good Data Safety and the Data Protection Act Module 2: Conditions and Permissible Reasons to Access Data Module 3: The General Data Protection Regulation Module 4: Data Sharing and Security Module 5: Creating a Data Protection Policy Module 6: Managing Requests for Personal Data Course Detail Course Access: Lifetime Tests Included: Yes Similarity: All significant gadgets and programs
Learning Objectives Introduction , Getting Started with InCopy , Working with Text , Collaborating with InCopy , Exporting from InCopy , Conclusion Pre-Requisites Basic computer skills. Knowledge of Microsoft Word or Adobe InDesign is helpful. Description Adobe InCopy is a professional word processor that integrates with Adobe InDesign. Adobe InCopy lets copywriters and editors style text, track changes, and make simple layout modifications to a document while designers work on the same document simultaneously in Adobe InDesign - all without overwriting each other's contributions and notifying each when updates have been made to the document. Learn and master Adobe InCopy with hands-on InCopy training courses. Our Adobe InCopy classes are task-based and focus on real-world uses and challenges individuals face in their day-to-day work environments. Adobe InCopy's editing capabilities are useful for both print, web and work seamlessly when collaborating with your colleagues. Students will learn about workflows, setting preferences, creating new documents, and work with workspaces, views and tools. In addition, students will learn to use styles, import from Word and Excel, add tables, understand copyfitting text, use Spellcheck, and Find and Change. Students will learn about collaborating with InCopy, using check-in and check-out features, as well as printing or exporting from InCopy. Whether you are new to Adobe InCopy, or have been using it for some time, training provides tips and tricks to take full advantage of this amazing tool. Introduction to the Course Introduction 00:02:00 Section 01 Understanding Workflow Requirements 00:06:00 Workflow Demonstration 00:08:00 Dropbox Shared Workflow 00:05:00 Setting Preferences 00:09:00 Creating a New Document 00:04:00 InCopy Interface and Workspaces 00:07:00 Understanding Galley Story & Layout View 00:03:00 Using Tools 00:06:00 Section 02 Using Styles 00:07:00 Importing Copy From Word 00:09:00 Adding a Table 00:08:00 Importing Tables from Excel 00:04:00 Understanding Copy Fitting 00:04:00 Using Spellcheck 00:08:00 Using Find and Change 00:06:00 Section 03 Using Notes 00:05:00 Tracking Changes 00:07:00 Creating Assignments 00:08:00 Check-in and Check-out Process 00:06:00 Section 04 Printing in InCopy 00:04:00 Exporting to Other Formats 00:06:00 Course Recap Recap 00:01:00 Final Exam Final Exam - Adobe InCopy CC Beginner 00:20:00
Microsoft Office skills are in high demand across industries, and proficiency in Microsoft Word, Microsoft Excel, Microsoft PowerPoint, and Microsoft Office 365 opens up numerous career opportunities. In the UK, administrative roles, data analysis positions, office management, project coordination, and marketing support roles are just a few examples of job prospects. With average salaries ranging from £20,000 to £45,000 per year, individuals with comprehensive Microsoft Office skills can secure stable employment and contribute to the success of various organisations. Enrol in the Ultimate Microsoft Office Skills Training course today and equip yourself with the knowledge and expertise needed to thrive in the ever-evolving workplace. You Will Learn Following Things: Develop a solid foundation in Microsoft Office applications, including Word, Excel, PowerPoint, and Office 365. Acquire essential skills to efficiently navigate and manipulate data in Microsoft Excel, such as organising, sorting, filtering, and writing formulas. Gain proficiency in creating professional presentations in Microsoft PowerPoint, utilising features like multimedia, transitions, animations, and smart graphics. Master the art of document creation and formatting in Microsoft Word, including tables, styles, page layouts, envelopes, labels, and mail merges. Understand advanced features like pivot tables, charts, and data analysis tools in Microsoft Excel, enabling effective data visualisation and decision-making. This course covers everything you must know to stand against the tough competition. The future is truly yours to seize with this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access This course covers everything you must know to stand against the tough competition. The future is truly yours to seize with this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. Enrol today and complete the course to achieve a certificate that can change your career forever. Process of Evaluation After studying the course, your skills and knowledge will be tested with an MCQ exam or assignment. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This course is designed for individuals who want to enhance their Microsoft Office skills for personal or skilled purposes. Whether you are a student, an experienced entrepreneur, or anyone who regularly works with Microsoft Word, Excel, PowerPoint, and Office 365, this Microsoft Office skills course will provide you with a solid foundation and advanced techniques to maximise your productivity and efficiency. No prior experience is required, making it suitable for beginners and intermediate users looking to expand their knowledge and capabilities in the Microsoft Office suite. On the other hand, anyone who wants to establish their career as: like MS Office User Microsoft Office 2019 User Touch Typing Worker Audio Typist Can take this Ultimate Microsoft Office Skills Training (Word, Excel, PowerPoint, and 365) course. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career path Administrative Assistant - £20K to £30K/year Data Analyst - £25K to £45K/year Office Manager - £25K to £40K/year Project Coordinator - £25K to £35K/year Marketing Assistant - £20K to £30K/year Course Curriculum Section 01: Getting Started 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 Section 02: Excel 2021: Basics 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 Section 03: Excel 2021: Rows, Columns, and Cells Adding Rows and Columns 00:03:00 Modifying Rows and Column lengths 00:05:00 Section 04: Excel 2021: Data Handling Copy, Cut, and Paste 00:07:00 Copying Formulas 00:03:00 Section 05: Excel 2021: Page Setting Up and Print Page setup options 00:06:00 Fit to print on One Page 00:03:00 Print Workbooks 00:03:00 Section 06: Excel 2021: Sorting and Filtering Sorting Data Ascending Order 00:04:00 Sorting Data Descending Order 00:02:00 Filter Data 00:04:00 Section 07: Excel 2021: Writing Formulas Creating Basic Formulas 00:06:00 Datetime Formulas 00:06:00 Mathematical formulas phase1 00:20:00 Mathematical formulas phase2 00:12:00 Section 08: Excel 2021: Advanced Formulas VLOOKUP formula 00:12:00 HLOOKUP formula 00:04:00 Section 09: Excel 2021: XLOOKUP only for 2021 and Office 365 XLOOKUP 00:08:00 Handling #NA and Approximates match in XLOOKUP 00:11:00 Section 10: Excel 2021: Data and Tools 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 Section 11: Excel 2021: Formatting data and tables 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 Section 12: Excel 2021: Pivot Tables Pivot Tables 00:07:00 Pivot Charts 00:02:00 Section 13: Excel 2021: Charts 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 Section 14: PowerPoint 2021: Course Introduction Overview 00:04:00 Start PowerPoint Presentation 00:05:00 Screen setting and Views 00:05:00 Section 15: PowerPoint 2021: Basics 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 Section 16: PowerPoint 2021: Text and Bullet Options 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 Section 17: PowerPoint 2021: Adding Graphic Assets 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 Section 18: PowerPoint 2021: Picture Formatting Picture Options 00:04:00 Picture Cropping 00:03:00 Applying Built-in Picture Styles 00:04:00 Section 19: PowerPoint 2021: SmartArt Graphics Add SmartArt Graphic 00:03:00 Modifying SmartArt 00:03:00 Creating a Target Chart using SmartArt 00:03:00 Section 20: PowerPoint 2021: Working with Tables Create a Table on Slide 00:04:00 Formatting Tables 00:02:00 Inserting Tables 00:02:00 Table Layouts 00:01:00 Section 21: PowerPoint 2021: Working with Charts Add a Chart 00:02:00 Formatting Charts 00:02:00 Insert Chart from Microsoft Excel 00:03:00 Section 22: PowerPoint 2021: Adding Multimedia Adding Video to a Presentation 00:03:00 Adding Audio to a Presentation 00:02:00 Screen Recording and Adding 00:02:00 Section 23: PowerPoint 2021: Working with Transition Applying Transitions to Presentation 00:04:00 Section 24: PowerPoint 2021: Animation Object Animation 00:03:00 Effect Options 00:02:00 Advanced Animation 00:02:00 Triggers to control animation 00:02:00 Section 25: PowerPoint 2021: Slideshow Effects Onscreen Presentation 00:02:00 Hiding Slides 00:02:00 Changing Order of Slides 00:02:00 Copying Slides 00:02:00 Section 26: Word 2021: Introduction Overview of MS Word 00:04:00 Start MS Word 2021 00:05:00 Section 27: Word 2021: Basics 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 Section 28: Word 2021: Word Formatting 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 Section 29: Word 2021: Tables 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 Section 30: Word 2021: Styles Working with styles 00:02:00 Creating styles 00:02:00 Clear formatting 00:01:00 Section 31: Word 2021: Page Layout 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 Section 32: Word 2021: Envelops and Lables Create envelops 00:02:00 Creating labels 00:02:00 Section 33: Word 2021: Mail Merges Creating a mail merge document 00:03:00 Section 34: Word 2021: Review and Printing 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