6805 Courses delivered Online

Overview This comprehensive course on 50 Tips to Upgrade your Excel Skill will deepen your understanding on this topic.After successful completion of this course you can acquire the required skills in this sector. This 50 Tips to Upgrade your Excel Skill comes with accredited certification 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 50 Tips to Upgrade your Excel Skill. It is available to all students, of all academic backgrounds. Requirements Our 50 Tips to Upgrade your Excel Skill is fully compatible with PC's, Mac's, Laptop,Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 7 sections • 52 lectures • 02:57:00 total length •Welcome: 00:02:00 •Camera Tool: 00:05:00 •Add Line Break in Formula Bar: 00:03:00 •Advanced Copy-Paste using Office Clipboard: 00:03:00 •Navigation between Worksheets using Shortcut Keys: 00:01:00 •Flash Fill: 00:02:00 •Add Multiple Rows and Columns Quickly: 00:02:00 •Delete Blank Rows: 00:03:00 •Multi Level Row and Column Sorting: 00:04:00 •Add Sparklines: 00:03:00 •Paste Special - Transpose: 00:03:00 •Snap to Grid: 00:03:00 •Create Custom Auto fill List: 00:06:00 •Absolute Cell Reference: 00:03:00 •Import Data from Web page: 00:04:00 •Move Cell Direction: 00:03:00 •Delete Data using Mouse: 00:02:00 •Status Bar Quick Calculations: 00:03:00 •Link Text Boxes to Cell: 00:04:00 •Phone Number and ZIP Code Format: 00:04:00 •Speaking Cell: 00:05:00 •Invisible Text: 00:03:00 •Worksheet Grouping: 00:04:00 •Advanced Transpose: 00:04:00 •XLStart Folder: 00:03:00 •Use Slicers: 00:05:00 •Convert Text to Numbers: 00:03:00 •Hiding Workbook Elements: 00:02:00 •Useful Shortcut Keys: 00:03:00 •Sort data from Left to Right: 00:03:00 •Advanced Filter (Complex): 00:11:00 •Email as PDF: 00:02:00 •Synchronous Scrolling: 00:03:00 •Quick Analysis of data within Excel: 00:02:00 •Fill blank cells with Value: 00:03:00 •Hidden Chart Source Data: 00:03:00 •Two more Shortcuts: 00:03:00 •Add Blank Rows: 00:03:00 •Custom views in Excel: 00:06:00 •EMBED Feature: 00:04:00 •Adding Country code in Mobile Numbers: 00:04:00 •Plot an Average Line to a Chart: 00:04:00 •3D Referencing: 00:04:00 •Extract Unique Values: 00:03:00 •Excel Array Formula: 00:04:00 •Forecast Sheet: 00:04:00 •Add Spin Controls in Excel: 00:05:00 •Move Data using Mouse: 00:01:00 •Add new entry in Auto Correct to use across Office Applications: 00:05:00 •Find Differences between Two Lists: 00:02:00 •Find formulas Quickly: 00:02:00 •Thank You: 00:01:00

Occupational Therapy: Occupational Therapy Online Unlock your potential with our Occupational Therapy course, where you’ll dive deep into the world of Occupational Therapy. This comprehensive Occupational Therapy program is designed to equip you with the essential skills needed for a successful career in Occupational Therapy. Our Occupational Therapy curriculum covers a wide range of topics, ensuring that you understand the fundamental principles of Occupational Therapy. With hands-on experiences and expert instructors, you’ll gain practical knowledge that enhances your expertise in Occupational Therapy. Join our community of passionate learners in the Occupational Therapy course and connect with professionals who share your commitment to improving lives through Occupational Therapy. Whether you're starting your journey or advancing your career, this Occupational Therapy course is the perfect choice for aspiring therapists. Enroll today to transform your future with our Occupational Therapy course, and become a vital part of the Occupational Therapy field! Special Offers of this Occupational Therapy: Occupational Therapy Course This Occupational Therapy Course includes a FREE PDF Certificate. Lifetime access to this Occupational Therapy Course Instant access to this Occupational Therapy Course 24/7 Support Available to this Occupational Therapy Course Occupational Therapy: Occupational Therapy Online Throughout the Occupational Therapy: Occupational Therapy course you will learn to make strategies for assisting patients in overcoming depression and poor self-esteem, and possible alternatives to occupational therapy. Moreover, from occupational therapy You will also learn about occupational therapists' ongoing professional and personal development. By the end of the Occupational Therapy: Occupational Therapy course you will know how to assist a patient in accepting their current state and moving toward a full recovery, and much more. Who is this course for? Occupational Therapy: Occupational Therapy Online If you want to advance your technical abilities and get ready for the career you want, this Occupational Therapy: Occupational Therapy course is ideal for you! Requirements Occupational Therapy: Diploma in Occupational Therapy Online To enrol in this Occupational Therapy: Occupational Therapy Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Occupational Therapy: Occupational Therapy Course. Be energetic and self-motivated to complete our Occupational Therapy: Occupational Therapy Course. Basic computer Skill is required to complete our Occupational Therapy: Occupational Therapy Course. If you want to enrol in our Occupational Therapy: Occupational Therapy Course you must be at least 15 years old. Career path Occupational Therapy: Occupational Therapy Online With the help of this Occupational Therapy: Occupational Therapy course, you may now access the relevant job market. Moreover, occupational therapy strengthens your CV, improves your career, and makes you more competitive in your field of choice.

Close Protection: Close Protection Online Unlock the Power of Close Protection: Close Protection Course: Enrol Now! Would you like to be able to react with assurance and power in any circumstance with the help of Close Protection skills? We have created our Close Protection: Close Protection Course specifically to help you gain a deeper comprehension of Close Protection. From the beginning of close protection to all of its ethical and legal ramifications, our close protection has addressed the most recent subjects. The Close Protection: Close Protection Course will also teach you about awareness, monitoring, and reconnaissance. Also, the Close Protection explains personal security and threat mitigation for Close Protection that can help to improve proficiency with related topics. Enrol in our Close Protection: Close Protection Course to make your CV stand out on the job market and wow potential employers. Main Course: Close Protection Course Courses you will Get Close Protection: Close Protection Course Along with Close Protection Course you will get free General Data Protection Regulation (GDPR) Along with Close Protection Course you will get free Anti Money Laundering (AML) Special Offers of this Close Protection: Close Protection Course This Close Protection: Close Protection Course includes a FREE PDF Certificate. Lifetime access to this Close Protection: Close Protection Course Instant access to this Close Protection: Close Protection Course 24/7 Support Available to this Close Protection: Close Protection Course Close Protection: Close Protection Online Our Close Protection: Close Protection has covered all the latest topics from the introduction of Close Protection to all the legal and ethical considerations of Close Protection. Also, you will learn about personal security, awareness, surveillance and reconnaissance from the Close Protection course. This Close Protection: Close Protection course involves threat mitigation helpful for boosting skills on the Close Protection: Close Protection topics. Who is this course for? Close Protection: Close Protection Online This Close Protection: Close Protection training is open to everyone. Requirements Close Protection: Close Protection Online To enrol in this Close Protection: Close Protection Course, students must fulfil the following requirements: Close Protection: Good Command over English language is mandatory to enrol in our Close Protection Course. Close Protection: Be energetic and self-motivated to complete our Close Protection Course. Close Protection: Basic computer Skill is required to complete our Close Protection Course. Close Protection: If you want to enrol in our Close Protection Course, you must be at least 15 years old. Career path Close Protection: Close Protection Online This Close Protection training can help your career possibilities in this industry.

Learn Xero from the experts and keep track of your business accounts and cash flow with the Xero Bookkeeper Training Course. This Xero training certification is designed to help small to mid-sized businesses, accountants and bookkeepers master Xero accounting software for smoother financial management. In this online bookkeeping course, you will learn how to run payroll and VAT returns, reconcile the bank, create a budget, post customer invoices and much more. You will also learn how to conduct real-time financial reports and utilise the payroll accounting system. Our time-saving tips and tricks are specially designed to make everyday accounting tasks a breeze. Enrol today and discover a smarter, faster way of keeping the books! Your Learning Goals: Fast track your career in bookkeeping and develop the practical knowledge to manage everyday accounting tasks efficiently Discover how to run payroll and process a pay run in Xero Learn how to activate your free trial, add your organisation and set up the system Understand how to amend bank details, add and merge bank accounts Get step-by-step guidance on processing refunds, creating a budget, forecasting and running a VAT return. Learn how to enter conversion balances, suppliers and customers Get trained on how to post customer invoices, credit notes, cheques & sundry payments Be able to add petty cash transactions and write off bad debt Who is this Course for? Xero Bookkeeper Training is 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 background. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Getting Prepared - Access the software and course materials Introduction To The Course And Your Tutor 00:04:00 Activating Your Free Trial With Xero 00:02:00 Getting started Signing Up For The Free Trial 00:04:00 Instruction of Updated Xero Accounting Software 00:00:00 Create The Organisation 00:08:00 The Ficticious Scenario 00:02:00 Setting up the system Add Bank Accounts To The System 00:14:00 Enter Opening Balances 00:07:00 Opening Trial Balance 00:01:00 Nominal ledger Amend The Nominal Ledger 00:06:00 Chart Of Accounts Report 00:01:00 Customers & Suppliers Enter customers 00:07:00 Entering suppliers 00:06:00 Reporting Customer And Supplier Information 00:02:00 Sales ledger Enter Invoices 00:07:00 Invoicing tips - adding logo, repeat billing 00:09:00 Entering Invoices 6574 to 6610 00:16:00 Post Credit Notes 00:03:00 Report Showing Customer Activity 00:08:00 Aged Debtors 00:02:00 Suppliers Post supplier invoices 00:09:00 Enter suppliers invoices 6028 onwards 00:14:00 Enter More Supplier Invoices No 4308 Onwards 00:06:00 Credit Notes Suppliers 00:02:00 Supplier Activity Report 00:04:00 Aged Creditors Info 00:01:00 Purchases ledger Reciepts from Customers 00:10:00 Apply Customer Credit Notes 00:05:00 Sundry payments Post Supplier Cheques 00:08:00 Apply Supplier Credit Notes 00:03:00 Print List Of Bank Receipts And Payments 00:01:00 Sundry payments Post Sundry Payments 00:07:00 Make a credit card payment 00:08:00 Petty Cash Add Petty Cash Transactions - Week 1 00:16:00 Add Petty Cash Transactions - Week 2 00:12:00 Add Petty Cash Transactions - Week 3 00:07:00 Add Petty Cash Transactions - Week 4 00:09:00 Imprest System on Petty Cash 00:04:00 Print a Copy of Petty Cash Receipts and Payments 00:01:00 Bad Debt Writing Off A Bad Debt - Print Customer Statement 00:02:00 Write Off A Bad Debt 00:09:00 Credit Card Reconcile The Credit Card Statement 00:09:00 Bank Reconciliation Bank Statement As A CSV File 00:27:00 Bank Statement Closing Balances 00:11:00 Reconcile The Petty Cash 00:05:00 Payroll / Wages Wages And Salaries 00:09:00 Post the Wages Journal 00:07:00 Report Wages Journal 00:02:00 Payday 00:11:00 Pay The Two Staff 00:05:00 VAT - Value Added Tax Depreciation 00:04:00 VAT Return 00:03:00 Reports Month End Reports PnL, BS, TB 00:05:00 Payroll unit Using Payroll 00:12:00 Setting Up Employees 00:10:00 Running Payroll - An Example 00:14:00 Conclude Recap And Next Steps 00:06:00 What happens next 00:02:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Description Do you want to master the world's best photo editing software? Or are you new to Adobe Photoshop CC? Then enrol the Adobe Photoshop CC Foundation course and begin your acquaintance with the course. The course is for the learners who have little or no knowledge about the photo editor. You will start your journey from the beginning. You will be familiar with the user interface and know how to open and create an image in Adobe Photoshop. The course introduces you to the essential tools, brushes and other features so that you can able to decide which tools to select while editing. Additionally, the course illustrates the concepts of colour schemes and guides you on how to use the colors efficiently. The procedures of adding text and text styles, working with Layers, adjusting Layers, customizing the workspace, moving and transforming Pixels, cropping images, etc. will be covered in the course. Finally, the course shows you how to print, convert and export files from Photoshop. Shortly, the course gives you a general understanding of the application so that you can proceed with the advanced skills. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Photoshop CC Masterclass - Beginner to Advanced is certified by CPD Qualifications Standards and CiQ. 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 background. Requirements Our Photoshop CC Masterclass - Beginner to Advanced 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 After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Adobe Photoshop CC Beginner Introduction Introduction FREE 00:03:00 Introduction to Photoshop Introduction to Photoshop 00:05:00 Understanding Types of Documents 00:04:00 Understanding Resolution 00:04:00 Creating New Documents 00:06:00 Using Artboards 00:05:00 Using CC Templates 00:03:00 Utilizing the Search Feature 00:02:00 Customizing the Workspace Using Workspace Presets 00:02:00 Moving, Closing, and Opening Panels 00:06:00 Understanding Document Views 00:06:00 Using the History Panel 00:06:00 Working with Layers Why Layers 00:02:00 Using Layers 00:07:00 Creating Fill Layers 00:05:00 Applying Blending Modes 00:04:00 Using Layer Styles 00:09:00 Discovering the Properties Panel 00:08:00 Understanding Selections Creating Basic Selections 00:09:00 Using the Lasso Tools 00:08:00 Understanding the Quick Select Tools 00:07:00 Editing the Quick Mask 00:04:00 Saving Selectionsv 00:04:00 Moving Selections to Layers.mp 00:03:00 Understanding and Using Color Understanding Color Modes 00:10:00 Creating Swatches 00:06:00 Using Masks and Advanced Layers Applying Layer Masks 00:00:00 Deleting Layer Masks 00:01:00 Organizing Layers 00:03:00 Merging Layers 00:02:00 Flattening Layers 00:02:00 Working with Layer Comps 00:06:00 Using Adjustment Layers Using Image Adjustments 00:07:00 Understanding Adjustment Layers 00:10:00 Using Layer Masks with Adjustment Layers 00:03:00 Cropping Images Using the Crop Tool 00:05:00 Using the Crop Tool to Add Canvas 00:02:00 Moving and Transforming Pixels Using Free Transform 00:04:00 Working with Other Transform Options 00:03:00 Flipping Pixels 00:01:00 Adding Text and Text Styles Using the Type Tool 00:10:00 Discovering Typesetting 00:08:00 Formatting Text 00:09:00 Creating Type on a Path 00:03:00 Warping Type 00:03:00 Using Styles on Type 00:08:00 Applying Special Effects Using Layer Styles 00:05:00 Working with Patterns 00:03:00 Applying Filters 00:04:00 Creating Pixels with Filters 00:06:00 Exporting from Photoshop Printing in Photoshop 00:03:00 Converting to CMYK 00:04:00 Converting to Other File Types 00:13:00 Using File Info 00:09:00 Conclusion Course Recap 00:03:00 Adobe Photoshop CC Intermediate Start Here Introduction FREE 00:03:00 Painting and Using Brushes Painting with Brushes 00:09:00 Using the Brushes Panel 00:06:00 Defining Custom Brushes 00:04:00 Saving Tool Presets 00:02:00 Using the History Brush 00:03:00 Using Vector Tools Working with Vector Shapes 00:10:00 Creating Custom Shapes 00:02:00 Using the Pen Tool 00:07:00 Discovering Paths 00:04:00 Understanding Vector Masks 00:03:00 Using Vector Objects and Spot Colors 00:06:00 Using Libraries What is the CC Library 00:02:00 Adding and Deleting Assets in the Library 00:03:00 Sharing Assets 00:02:00 Creating New Libraries 00:03:00 Sharing a Library 00:02:00 Advanced Special Effects Using the Blur Filters 00:06:00 Applying the Distort Filters 00:03:00 Creating a Pixelated Look 00:02:00 Stylizing Effects 00:02:00 Using Liquify 00:05:00 Using Smart Filters 00:04:00 Working with Smart Objects 00:03:00 Loading a Texture into Type 00:04:00 Working with RAW Images What is a Raw Image 00:05:00 Processing Raw Images 00:12:00 Opening a JPEG File in Raw 00:06:00 Retouching Basics Developing a Strategy for Retouching 00:04:00 Using Retouching Tools 00:10:00 Using the Dust and Scratches Filter 00:04:00 Applying Sharpening 00:08:00 Working with Face Aware Liquify 00:06:00 Automating Tasks Using Actions 00:03:00 Creating Actions 00:07:00 Using Droplets 00:05:00 Using the Image Processor 00:05:00 Creating an HDR Image 00:07:00 Creating a Panoramic Image 00:07:00 Integration with other Adobe Software Using PSD Files in InDesign 00:04:00 Using PSD Files in Illustrator 00:03:00 Using PSD Files in Dreamweaver 00:04:00 Understanding Color Management Why Color Management 00:03:00 Calibrating a Monitor 00:04:00 Calibrating a Printer 00:03:00 Loading Profiles into PSDs 00:02:00 Conclusion Course Recap 00:03:00 Adobe Photoshop CC Advanced Introduction Introduction FREE 00:03:00 Processing Raw Images What is the RAW Format 00:04:00 Understanding White Balance 00:05:00 Setting Exposure 00:07:00 Working with Color and Clarity 00:03:00 Working with Adobe Camera Raw Updating Adobe Camera Raw 00:01:00 Using the Before and After Views 00:05:00 Resetting the Sliders 00:01:00 Understanding the Workflow Options 00:04:00 Setting the Camera Raw Preferences 00:03:00 Working with the Tools Understanding the White Board Tool 00:03:00 Using the Color Sampler 00:01:00 Working with the Targeted Adjustment Tool 00:02:00 Cropping Images 00:03:00 Applying Straightening 00:01:00 Using the Spot Removal Tool 00:05:00 Applying the Red Eye Tool 00:03:00 Understanding the Adjustment Brush 00:04:00 Using the Graduated Filter 00:02:00 Applying the Radial Filter 00:02:00 Rotating Images 00:01:00 Using Advanced Exposure Settings and Sharpening Using Curves 00:03:00 Understanding Sharpening and Noise 00:03:00 Creating Grayscale Images 00:03:00 Using Split Toning 00:03:00 Managing Corrections and Effects Enabling Lens Profiles 00:03:00 Using Effects 00:02:00 Adding Grain 00:02:00 Applying Post Crop Vignette 00:02:00 Using Camera Calibration 00:03:00 Saving Presets 00:02:00 Applying Snapshots 00:02:00 Creating Image Adjustments Using Adjustment Layers 00:02:00 Painting Layer Masks 00:05:00 Discovering Plugins for Photoshop What are Plugins 00:04:00 Using the Nik Collection 00:08:00 Using HDR Pro Effex 00:06:00 Using On1 Effects 00:04:00 Exploring Workflows Introudcing the Workshop Videos 00:04:00 Processing a Landscape Image 00:13:00 Processing a Macro Image 00:09:00 Processing a City 00:11:00 Conclusion Course Recap 00:02:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Overview: Are you tired of watching your competitors soar while your Digital Marketing efforts remain stagnant? In today's digital-first world, mastering Digital Marketing and growth hacking techniques is no longer a luxury but a necessity. With the UK's Digital Marketing economy booming, now is the perfect time to equip yourself with the Digital Marketing skills to drive exponential growth. Imagine having the power to strategically leverage Digital Marketing tools like social media, content marketing, and SEO to attract, engage, and convert customers. Our comprehensive Digital Marketing bundle offers you the tools and knowledge to succeed in Digital Marketing and achieve your business goals. This Digital Marketing course dives deep into core Digital Marketing principles and equips you with practical skills to implement growth-hacking strategies. From understanding the Digital Marketing customer journey to mastering advanced SEO, you'll gain a holistic perspective on how to optimize your Digital Marketing presence. Learning Outcomes of this Digital Marketing Bundle: Develop a data-driven approach to Digital Marketing. Master content marketing strategies in Digital Marketing. Optimize your website with advanced Digital Marketing SEO techniques. Leverage Digital Marketing tools on social media platforms. Implement targeted Digital Marketing email campaigns. Analyze and optimize your Digital Marketing performance. Don't let your Digital Marketing efforts fall short. By enrolling in our Digital Marketing bundle, you're investing in your Digital Marketing career and positioning yourself for success in the competitive world of online business. Key Features of the Digital Marketing Course: FREE Digital Marketing CPD-accredited certificate Get a free student ID card with Digital Marketing training (£10 applicable for international delivery) Lifetime access to the Digital Marketing course materials The Digital Marketing program comes with 24/7 tutor support Get instant access to this Digital Marketing course Learn Digital Marketing from anywhere in the world The Digital Marketing training is affordable and simple to understand The Digital Marketing training is entirely online How will I get my certificate? You may have to take a quiz or a written test online during or after the Digital Marketing course. After successfully completing the course, you will be eligible for the certificate. Who is this Digital Marketing course for? There is no experience or previous qualifications required for enrolment in this Digital Marketing - Growth Hacking Techniques. It is available to all students, of all academic backgrounds. Digital Marketing professionals Entrepreneurs focused on Digital Marketing Small business owners looking to improve Digital Marketing skills Marketing students interested in Digital Marketing Anyone seeking expertise in Digital Marketing Requirements Our Digital Marketing bundle is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This Digital Marketing 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as: Digital Marketing Manager (£35,000 - £55,000) SEO Specialist in Digital Marketing (£30,000 - £45,000) Social Media Manager in Digital Marketing (£25,000 - £40,000) Content Marketing Manager in Digital Marketing (£30,000 - £50,000) Email Marketing Specialist in Digital Marketing (£25,000 - £40,000) Course Curriculum 11 sections • 11 lectures • 07:12:00 total length •Fundamentals of Digital Marketing •Growth Hacking •Customer Journey •Content Marketing •SEO •E-Mail Marketing •Facebook Marketing •Instagram Marketing •Twitter Marketing •YouTube Marketing •Mobile Marketing

Overview TThe demand for skilled professionals in the plumbing industry is rapidly increasing, making it one of the most sought-after trades globally. The Professional Plumbing course is designed to equip you with essential plumbing skills and knowledge to excel in this hands-on career. From understanding pipe systems to mastering plumbing installation and maintenance, this course covers every crucial aspect of the plumbing trade. Throughout the course, you will learn about water systems, sanitation practices, and how to troubleshoot common plumbing issues. Gain expertise in plumbing regulations, safety standards, and using the latest plumbing tools and techniques to ensure efficiency and compliance. Whether you're starting your career or looking to advance in the plumbing industry, this course offers the foundation for success. Enrol today in the Professional Plumbing course and gain the practical knowledge required to excel as a plumbing technician or plumbing engineer. Start building a career in a thriving industry that offers stability and growth opportunities. So enrol in this course today to fast track your career ladder. Key Features of the Course: FREE Professional Plumbing CPD-accredited certificate Get a free student ID card with Professional Plumbing training (£10 applicable for international delivery) Lifetime access to the Professional Plumbing course materials The Professional Plumbing program comes with 24/7 tutor support Get instant access to this Professional Plumbing course Learn Professional Plumbing training from anywhere in the world The Professional Plumbing training is affordable and simple to understand The Professional Plumbing training is an entirely online How will I get my certificate? You may have to take a quiz or a written test online during or after the Professional Plumbing course. After successfully completing the Professional Plumbing 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 Professional Plumbing. It is available to all students, of all academic backgrounds. Requirements Our Professional Plumbing 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 Unlock a range of career opportunities with the Professional Plumbing course. Explore these rewarding paths: Plumbing Technician Plumbing Engineer Pipefitter Maintenance Plumber Sanitation Specialist Plumbing Supervisor Course Curriculum 12 sections • 12 lectures •Basic Components of Plumbing •Principles of Effective Plumbing Systems •Tools Used for Plumbing: •Process of Plumbing •Central Heating Systems •Domestic Cold-Water System •Hot Water System - Part 1 •Hot Water System - Part 2 •The Sanitation System and Repairs •Installation of a Domestic Rainwater System •Plumbing Projects Case Study •Plumbing Standards in the UK

Overview Dive into the exciting world of coding with our comprehensive Coding with Scratch course. From the very start, you’ll be introduced to the basics, including how to get started with Scratch, creating and manipulating sprites, and setting up engaging backdrops. As you progress, you'll explore essential coding concepts such as motion blocks, looks, sound, and events, giving you a solid foundation in coding fundamentals. The course continues with in-depth tutorials on control, operators, sensing, and variables, which are crucial for developing complex coding projects. A sample activity and guidance on creating your own sample activities will provide practical, hands-on experience. Perfect for beginners and those looking to enhance their coding skills, this course offers a structured approach to mastering coding with Scratch, equipping you with the tools to build your own interactive projects and games. So enrol in this course today to fast-track your career ladder. Key Features of the Course: FREE Coding with Scratch CPD-accredited certificate Get a free student ID card with Coding with Scratch training (£10 applicable for international delivery) Lifetime access to the Coding with Scratch course materials The Coding with Scratch program comes with 24/7 tutor support Get instant access to this Coding with Scratch course Learn Coding with Scratch training from anywhere in the world The Coding with Scratch training is affordable and simple to understand The Coding with Scratch training is entirely online 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 Coding with Scratch 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 Coding with Scratch. It is available to all students, of all academic backgrounds. Requirements Our Coding with Scratch 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 Explore diverse career opportunities with our Coding with Scratch course: Junior Software Developer: £25,000 - £35,000 Game Designer: £28,000 - £40,000 Coding Instructor: £22,000 - £30,000 Interactive Media Designer: £30,000 - £45,000 Educational Technologist: £25,000 - £38,000 App Developer: £30,000 - £50,000 Course Curriculum 5 sections • 17 lectures • 01:54:00 total length •Meet your instructor: 00:01:00 •Article 1: 00:58:00 •Article 2: 00:10:00 •Getting Started with Scratch: 00:02:00 •Sprites: 00:03:00 •Backdrops: 00:02:00 •Motion blocks: 00:04:00 •Looks: 00:05:00 •Sound: 00:02:00 •Events: 00:04:00 •Control: 00:05:00 •Operators: 00:01:00 •Sensing: 00:05:00 •Variables: 00:03:00 •Sample Activity: 00:01:00 •How to make a sample activity: 00:08:00 •Assignment - Coding with Scratch: 00:00:00

Description: Microsoft Office 2016 Complete Bundle Course (Word, Excel, PowerPoint, Outlook and Access) is intended to prepare you to get complete control on Microsoft Office 2016. It is designed to educate about Microsoft Office 2016. In this course, you will learn about the basic features of Microsoft Word such as creating a new document, personalizing the Microsoft Word interface, adding graphics, etc. Besides, you will learn about the techniques of controlling page appearance, proofing and editing a document. Following that, you will learn about the essentials to create and work with an electronic spreadsheet. You will be able to insert and delete text or images, adjust cells, create columns, rows and much more. This advanced course helps you to navigate the PowerPoint environment, create and save PowerPoint presentation, delivering advanced text editing etc. Finally, you will learn how to set up and use Outlook on Windows. It will assist you in creating and sending messages, managing contacts, using the calendar, managing tasks, working with notes and so much more. Overall, this course is created especially for you to provide all information to access Microsoft Office 2016. Enroll today and get benefit from this course. Learning Outcomes: Changing user information, sharing documents, working with comments and comparing document changes Collaborate on documents by reviewing them, merging changes and co-authoring Discover how to best use reference tools, like captions, cross-references, bookmarks, hyperlinks, footnotes, endnotes, citations and bibliographies Working with master documents and subdocuments Adding cover page; creating an index, table of contents, and ancillary tables; and managing outlines to simplify and manage large documents Suppressing information from a document, setting editing restrictions, adding digital signature platforms, and restricting document access Find out techniques for saving and exporting form data, along with creating and manipulating forms Using SharePoint Server with Word in order to create, compare and combine different document versions Ways to update worksheet properties, create and edit macros, applying conditional formatting and add data validation criteria Auditing worksheets through tracing cells, troubleshooting invalid data and formula errors, watching and evaluating formulas, and creating a data list online Create Sparklines, scenarios and interactive data using Power View Perform what-if analysis and statistical analysis with the Analysis ToolPak Ways to multitask by consolidating data, linking cells in different workbooks, and merging them Export Excel data, import delimited text files, integrate Excel data with the web and create web queries How to import and export XML data PowerPoint environment and how to modify it according to needs Customizing user interface and setting up options Create and manage sections, modify slide masters and slide layouts, add headers and footers, modify notes master and handout master Creating and modifying SmartArt Adding audio video to presentations and customizing animations and transitions to enhance presentation Better collaboration by adding comments, reviews, storing and sharing presentations on the web Setting up and creating custom slide shows, adding hyperlink and action buttons, and recording a presentation Security and distribution of presentations through various outlets Change message settings, properties, options, using automatic replies and inserting objects Sort and filter options, organising and searching messages, managing junk mail and mailbox Managing advanced calendar options, additional calendars, meeting responses, and assigning tasks Advanced, forward and export contact options, handling contacts and editing electronic business cards Sharing calendars and contacts whilst also delegating access to mail folders to others Modifying data file settings and backing up Outlook items Email security and configuring email message security Designing forms through adding and setting controls, creating subforms, using tab pages to organize information, improve navigation, formatting and applying conditional formatting Data, field, form and record validation Creating macros, restricting records using conditions, validate data, automate data entry and convert a macro to VBA in order to enhance user interface design Link tables to external data sources, manage database, determine object dependency, document database, and analyze database performance Allow multiple user access to database by splitting it, implement security, set passwords, convert Access database to ACCDE file, and add digital signatures Create and modify switchboards and startup options Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 Complete Bundle Course (Word, Excel, PowerPoint, Outlook and Access) is certified by CPD Qualifications Standards and CiQ. 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 background. Requirements Our Microsoft Office 2016 Complete Bundle Course (Word, Excel, PowerPoint, Outlook and Access) 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 After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Microsoft Word 2016 Modify User Information 00:15:00 Share a Document 00:30:00 Work with Comments 00:15:00 Compare Document Changes 00:15:00 Review a Document 00:15:00 Merge Document Changes 00:15:00 Coauthor Documents 00:15:00 Add Captions 00:15:00 Add Cross-References 00:15:00 Add Bookmarks 00:15:00 Add Hyperlinks 00:15:00 Insert Footnotes and Endnotes 00:15:00 Add Citations 00:30:00 Insert a Bibliography 00:15:00 Insert Blank and Cover Pages 00:15:00 Insert an Index 00:30:00 Insert a Table of Contents 00:30:00 Insert an Ancillary Table 00:15:00 Manage Outlines 00:30:00 Create a Master Document 00:30:00 Suppress Information 00:30:00 Set Editing Restrictions 00:30:00 Add a Digital Signature to a Document 00:15:00 Restrict Document Access 00:15:00 Create Forms 00:30:00 Manipulate Forms 00:15:00 Form Data Conversion 00:15:00 Create a New Document Version 00:30:00 Compare Document Versions 00:15:00 Merge Document Versions 00:15:00 Activities - Microsoft Word 2016 Advanced 00:00:00 Microsoft Excel 2016 Update Workbook Properties 00:15:00 Activity-Update Workbook Properties 00:05:00 Create and Edit a Macro 00:15:00 Activity-Create and Edit a Macro 00:05:00 Apply Conditional Formatting 00:15:00 Activity-Apply Conditional Formatting 00:05:00 Add Data Validation Criteria 00:15:00 Activity-Add Data Validation Criteriaty 00:05:00 Trace Cells 00:15:00 Activity-Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:15:00 Activity-Troubleshoot Invalid Data and Formula Errors 00:05:00 Watch and Evaluate Formulas 00:15:00 Activity-Watch and Evaluate Formulas 00:05:00 Create a Data List Outline 00:15:00 Activity-Create a Data List Outline 00:05:00 Create Sparklines 00:15:00 Activity_Create Sparklines 00:05:00 Create Scenarios 00:15:00 Activity-Create Scenarios 00:05:00 Perform a What-If Analysis 00:15:00 Activity-Perform a What-If Analysis 00:05:00 Perform a Statistical Analysis with the Analysis ToolPak 00:15:00 Activity-Perform a Statistical Analysis with the Analysis ToolPak 00:05:00 Create Interactive Data with Power View 00:15:00 Activity-Create Interactive Data with Power View 00:05:00 Consolidate Data 00:15:00 Activity-Consolidate Data 00:05:00 Link Cells in Different Workbooks 00:15:00 Activity-Link Cells in Different Workbooks 00:05:00 Merge Workbooks 00:15:00 Activity-Merge Workbooks 00:05:00 Export Excel Data 00:15:00 Activity-Export Excel Data 00:05:00 Import a Delimited Text File 00:14:00 Activity- Import a Delimited Text File 00:05:00 Integrate Excel Data with the Web 00:15:00 Activity-Integrate Excel Data with the Web 00:05:00 Create a Web Query 00:15:00 Activity-Create a Web Query 00:05:00 Import and Export XML Data 00:15:00 Activity-Import and Export XML Data 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 Advanced 00:00:00 Microsoft PowerPoint 2016 Customize the User Interface 01:30:00 Set PowerPoint 2016 Options 00:45:00 Create and Manage Sections 01:00:00 Modify Slide Masters and Slide Layouts 01:15:00 Add Headers and Footers 00:30:00 Modify the Notes Master and the Handout Master 00:45:00 Create SmartArt 00:45:00 Modify SmartArt 01:00:00 Add Audio to a Presentation 00:45:00 Add Video to a Presentation 01:00:00 Customize Animations and Transitions 01:00:00 Add Comments to a Presentation 00:45:00 Review a Presentation 00:45:00 Store and Share Presentations on the Web 01:30:00 Annotate a Presentation 00:45:00 Set Up a Slide Show 00:45:00 Create a Custom Slide Show 00:30:00 Add Hyperlinks and Action Buttons 00:45:00 Record a Presentation 00:15:00 Secure a Presentation 01:30:00 Present a Slide Show Online 01:00:00 Create a Video or a CD 00:45:00 Activities - Microsoft PowerPoint 2016 Advanced 00:00:00 Microsoft Outlook 2016 Insert Advanced Characters and Objects 01:30:00 Modify Message Settings, Properties, and Options 01:30:00 Use Automatic Replies 01:30:00 Sort Messages 00:45:00 Filter Messages 01:00:00 Organize Messages 02:00:00 Search Messages 01:30:00 Manage Junk Mail 01:00:00 Manage Your Mailbox 02:00:00 Manage Advanced Calendar Options 00:45:00 Manage Additional Calendars 01:00:00 Manage Meeting Responses 00:45:00 Assign and Manage Tasks 01:00:00 Edit an Electronic Business Card 01:00:00 Manage Advanced Contact Options 01:30:00 Forward Contacts 00:30:00 Export Contacts 01:00:00 Delegate Access to Mail Folders 01:00:00 Share Your Calendar 00:30:00 Share Your Contacts 00:15:00 Back Up Outlook Items 00:45:00 Change Data File Settings 00:45:00 Configure E-mail Message Security Settings 00:30:00 Activities - Microsoft Outlook 2016 Advanced 00:00:00 Microsoft Access 2016 Add Controls to Forms 01:00:00 Set Form Controls 01:00:00 Create Subforms 00:30:00 Organize Information with Tab Pages 00:30:00 Enhance Navigation with Forms 00:30:00 Format a Form 01:00:00 Apply Conditional Formatting 00:30:00 Field Validation 00:30:00 Form and Record Validation 00:30:00 Create a Macro 01:00:00 Restrict Records Using a Condition 00:30:00 Validate Data Using a Macro 00:30:00 Automate Data Entry Using a Macro 00:30:00 Convert a Macro to VBA 00:30:00 Link Tables to External Data Sources 00:30:00 Manage a Database 00:30:00 Determine Object Dependency 00:30:00 Document a Database 00:30:00 Analyze the Performance of a Database 00:30:00 Split a Database for Multiple User Access 00:30:00 Implement Security 00:30:00 Set Passwords 00:30:00 Convert an Access Database to an ACCDE File 00:30:00 Package a Database with a Digital Signature 00:30:00 Create a Database Switchboard 01:00:00 Modify a Database Switchboard 00:30:00 Set Startup Options 00:30:00 Activities - Microsoft Access 2016 Advanced 00:00:00 Mock Exam Mock Exam- Microsoft Office 2016 Advanced 00:30:00 Final Exam Final Exam- Microsoft Office 2016 Advanced 00:30:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Description Microsoft Excel is a powerful and easy to use spreadsheet program that almost all businesses use on a day-to-day basis. It is used to store and retrieve numerical data and it is ideal for entering, calculating and analysing company data such as sales figures, sales taxes or commissions. This Level 3 Diploma in Microsoft Excel 2016 is a course which will help you learn the various features incorporated in the software. This course has been specially designed to cover everything from the basic concepts to the advanced levels. This course allows you to take advantage of the online aspect of training by learning at your own pace. As long as you have access to an eligible device, such as a laptop, or smartphone, and an internet connection, you can access this Level 3 Diploma in Microsoft Excel 2016 from anywhere, and anytime. Learning Outcomes: Familiarize the excel user interface, creating basic worksheet and using the help system How to create formulas, reuse them and insert functions in a worksheet Managing cells, columns and rows and ways to manipulate data Utilizing the 'Search and replace' data options and spell checking Modifying fonts, adding borders and colours to cells, using number formats, aligning cell contents and applying cell styles Define and refine page layouts for printing options Managing large workbooks through worksheet tab formatting and using different views Options for general customization, language, formula, proofing and saving Customizing Quick Access toolbar, ribbon, advanced and Trust Center options Utilize Excel's version control features and enabling add-ins Best ways to utilize Macro Recorder, how to edit and debug a macro, and setting up macro security Customizing the Quick Access toolbar and hotkeys Utilizing Macros to insert and format texts, sort and duplicate data, and generate reports Determine appropriate dialog box types to use Using variety of techniques to capture user input Managing worksheets using macros Creating user-defined functions and ways to automate SUM functions with macros Explore PowerPivot applications Importing data from different sources Creating linked tables Organizing and formatting tables Creating calculated columns PowerPivot data filtering and sorting Creating PivotTables and PivotCharts, and filtering data using slicers Presenting Visual data through visual outlets Utilizing DAX functions for manipulating PowerPivot data Extracting data from tables using functions, and working with time-dependent data Saving data in different formats and protecting reports Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Level 3 Diploma in Microsoft Excel 2016 is certified by CPD Qualifications Standards and CiQ. 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 background. Requirements Our Level 3 Diploma in Microsoft Excel 2016 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 After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module : 1 Identify the Elements of the Excel Interface 00:30:00 Activity - Identify the Elements of the Excel Interface 00:05:00 Create a Basic Worksheet 01:00:00 Activity - Create a Basic Worksheet 00:05:00 Use the Help System 00:30:00 Activity - Use the Help System 00:05:00 Create Formulas in a Worksheet 01:00:00 Activity - Create Formulas in a Worksheet 00:05:00 Insert Functions in a Worksheet 00:30:00 Activity - Insert Functions in a Worksheet 00:05:00 Reuse Formulas 00:30:00 Activity - Reuse Formulas 00:05:00 Manipulate Data 00:30:00 Activity - Manipulate Data 00:05:00 Insert, Manipulate, and Delete Cells, Columns, and Rows 00:30:00 Activity - Insert, Manipulate, and Delete Cells, Columns, and Rows 00:05:00 Search For and Replace Data 00:30:00 Activity - Search For and Replace Data 00:05:00 Spell Check a Worksheet 00:30:00 Activity - Spell Check a Worksheet 00:05:00 Modify Fonts 00:30:00 Activity - Modify Fonts 00:05:00 Add Borders and Colors to Cells 01:00:00 Activity - Add Borders and Colors to Cells 00:05:00 Apply Number Formats 00:30:00 Activity - Apply Number Formats 00:05:00 Align Cell Contents 00:30:00 Activity - Align Cell Contents 00:05:00 Apply Cell Styles 00:30:00 Activity - Apply Cell Styles 00:05:00 Define the Basic Page Layout for a Workbook 01:00:00 Activity - Define the Basic Page Layout for a Workbook 00:05:00 Refine the Page Layout and Apply Print Options 00:30:00 Activity - Refine the Page Layout and Apply Print Options 00:05:00 Format Worksheet Tabs 00:30:00 Activity - Format Worksheet Tabs 00:05:00 Manage Worksheets 00:30:00 Activity - Manage Worksheets 00:05:00 Manage the View of Worksheets and Workbooks 00:30:00 Activity - Manage the View of Worksheets and Workbooks 00:05:00 Customize General and Language Options 00:30:00 Activity - Customize General and Language Options 00:05:00 Customize Formula Options 00:30:00 Activity - Customize Formula Options 00:05:00 Customize Proofing and Save Options 01:00:00 Activity - Customize Proofing and Save Options 00:05:00 Customize the Ribbon and Quick Access Toolbar 00:30:00 Activity - Customize the Ribbon and Quick Access Toolbar 00:05:00 Customize the Functionality of Excel by Enabling Add-Ins 00:30:00 Activity - Customize the Functionality of Excel by Enabling Add-Ins 00:05:00 Customize Advanced and Trust Center Options 00:30:00 Activity - Customize Advanced and Trust Center Options 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 for Beginners 00:00:00 Module : 2 Apply Range Names 00:30:00 Use Specialized Functions 00:30:00 Use Text Functions 00:30:00 Use Logical Functions 00:30:00 Use Lookup Functions 00:30:00 Use Date Functions 00:30:00 Use Financial Functions 00:30:00 Create and Modify Tables 00:30:00 Sort and Filter Data 00:30:00 Use Subtotal and Database Functions to Calculate Data 00:30:00 Create Charts 00:30:00 Modify and Format Charts 00:30:00 Create a Trendline 00:30:00 Create Advanced Charts 00:30:00 Create a PivotTable 00:30:00 Filter Data by Using Slicers 00:30:00 Analyze Data with PivotCharts 00:30:00 Insert and Modify Graphic Objects 00:30:00 Layer and Group Graphic Objects 00:30:00 Incorporate SmartArt 00:30:00 Customize Workbooks 00:30:00 Manage Themes 00:30:00 Create and Use Templates 00:30:00 Protect Files 00:30:00 Preparing a Workbook for Multiple Audiences 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 Intermediate 00:00:00 Module : 3 Update Workbook Properties 00:15:00 Activity-Update Workbook Properties 00:05:00 Create and Edit a Macro 00:15:00 Activity-Create and Edit a Macro 00:05:00 Apply Conditional Formatting 00:15:00 Activity-Apply Conditional Formatting 00:05:00 Add Data Validation Criteria 00:15:00 Activity-Add Data Validation Criteriaty 00:05:00 Trace Cells 00:15:00 Activity-Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:15:00 Activity-Troubleshoot Invalid Data and Formula Errors 00:05:00 Watch and Evaluate Formulas 00:15:00 Activity-Watch and Evaluate Formulas 00:05:00 Create a Data List Outline 00:15:00 Activity-Create a Data List Outline 00:05:00 Create Sparklines 00:15:00 Activity_Create Sparklines 00:05:00 Create Scenarios 00:15:00 Activity-Create Scenarios 00:05:00 Perform a What-If Analysis 00:15:00 Activity-Perform a What-If Analysis 00:05:00 Perform a Statistical Analysis with the Analysis ToolPak 00:15:00 Activity-Perform a Statistical Analysis with the Analysis ToolPak 00:05:00 Create Interactive Data with Power View 00:15:00 Activity-Create Interactive Data with Power View 00:05:00 Consolidate Data 00:15:00 Activity-Consolidate Data 00:05:00 Link Cells in Different Workbooks 00:15:00 Activity-Link Cells in Different Workbooks 00:05:00 Merge Workbooks 00:15:00 Activity-Merge Workbooks 00:05:00 Export Excel Data 00:15:00 Activity-Export Excel Data 00:05:00 Import a Delimited Text File 00:14:00 Activity- Import a Delimited Text File 00:05:00 Activity-Integrate Excel Data with the Web 00:05:00 Activity-Integrate Excel Data with the Web 00:05:00 Create a Web Query 00:15:00 Activity-Create a Web Query 00:05:00 Import and Export XML Data 00:15:00 Activity-Import and Export XML Data 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 Advanced 00:00:00 Module : 4 Create a Macro Using the Macro Recorder 01:00:00 Edit a Macro 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 and VBA 00:00:00 Module : 5 Enable and Navigate 00:30:00 Import Data from Various Data Sources 01:00:00 Refresh Data from a Data Source 00:30:00 Create Linked Tables 00:30:00 Organize and Format Tables 00:30:00 Create Calculated Columns 00:30:00 Sort and Filter PowerPivot Data 00:30:00 Create and Manage Table Relationships 01:00:00 Create PivotTables 01:00:00 Create PivotCharts 00:30:00 Create Power Views 01:00:00 Filter Data Using Slicers 00:30:00 Present PivotTable Data Visually 01:00:00 Manipulate PowerPivot Data Using DAX Functions 01:00:00 Extract Data from Tables Using Functions 00:30:00 Save Reports in Different File Formats 01:00:00 Work with Time Dependent Data 00:30:00 Protect Reports 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 PowerPivot 00:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Level 3 Diploma in Microsoft Excel 2016 00:30:00 Final Exam Final Exam- Level 3 Diploma in Microsoft Excel 2016 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00