4626 Security courses in Manchester delivered Online

🚀 Unlock Your Business Potential with Bitcoin-Powered Business Growth! 🚀 Are you ready to take your business to new heights? Discover the revolutionary power of Bitcoin and supercharge your growth with our exclusive online course - 'Bitcoin-Powered Business Growth.'   🌐 Why Bitcoin? 🌐 In an ever-evolving digital landscape, Bitcoin isn't just a currency; it's a game-changer for entrepreneurs and businesses. Embrace the future of finance and learn how to leverage Bitcoin to propel your business forward.   💡 What You'll Learn: 💡 📈 1. Mastering Bitcoin Basics: Gain a comprehensive understanding of Bitcoin and blockchain technology. Learn how to integrate Bitcoin into your business operations seamlessly. 💼 2. Bitcoin for Business Expansion: Explore innovative ways to use Bitcoin to expand your customer base. Unlock international markets and tap into new revenue streams. 💰 3. Bitcoin as an Investment Strategy: Discover how to use Bitcoin as a strategic investment tool for your business. Learn risk management techniques to navigate the volatile market. 🔒 4. Securing Your Assets with Bitcoin: Explore robust security measures to protect your business and assets. Implement best practices for storing and managing Bitcoin securely. 🌐 5. Navigating the Global Economy: Understand the impact of Bitcoin on the global economy. Position your business for success in the era of digital currencies.   🎓 Why Choose Our Course? 🎓 ✅ Expert-Led Instruction: Learn from industry experts with hands-on experience in Bitcoin and business growth. ✅ Practical Insights: Gain actionable insights and strategies that you can implement immediately. ✅ Interactive Learning: Engage in discussions, case studies, and real-world scenarios to enhance your learning experience. ✅ Lifetime Access: Enjoy unlimited access to course materials, updates, and a supportive community.   🌟 Don't miss this opportunity to transform your business with the disruptive power of Bitcoin! 🌟 Course Curriculum Basic Overview 00:00 A Word About Bitcoin and Stripe 00:00 Set Up With Bitpay 00:00 Marketplaces 00:00 Your Cloud Based Network - Part 3 00:00 Create a Product in Send Owl 00:00 Adding-Your-Autoresponder 00:00 Adding-Coupons 00:00 Adding Upsells 00:00 Adding-An-Affiliate-Program 00:00 The Rocketr Network 00:00 Set Up Bitcoin in Rocketr 00:00 Add-a-Product in Rocketr 00:00 Add-A-Pay-Button 00:00 Add a Rocketr Pay Button To Your Site 00:00 Setting Up Affiliates in Rocketr 00:00 Adding Coupons in Rocketr 00:00 E-Mail Marketing In Rocketr 00:00 Blacklisting-Buyers 00:00 Introduction to WordPress and Bitcoin 00:00 Advanced Overview of the Advanced Course 00:00 WordPress Vs. Shopify 00:00 Set Up Shopify 00:00 Setting Up Shopify to Accept Bitcoin 00:00 Setting Up Shopify to Accept Bitcoin - Part 2 00:00 Promoting Your Shopify Products Through Your AR 00:00 Promoting Your Shopify Products To YouTubers 00:00 WordPress Installation 00:00 WordPress Plugin - Digital Paybox 00:00 WordPress Plugin - Bitpay and Wp-Ecommerce 00:00 WordPress Plugin - WP - E-Commerce Additional Settings 00:00 Installing Woocommerce 00:00 Woo Commerce Plugin Set Up Part One 00:00 Woo Commerce Plugin Set Up Part 2 00:00 Woo Commerce Plugin Set Up Part 1 00:00 Woo Commerce Plugin 2 Set Up Part 2 00:00 Affiliate Connections Through Woo Commerce 00:00 Woo Commerce Theme Customization 00:00 Woo Commerce Autoresponders 00:00 Conclusion 00:00

🚀 Unlock the Power of Cloud Storage with Our 'Introduction to Amazon S3 Essentials' Course! 🌐   Are you ready to dive into the world of cloud storage and harness the unparalleled potential of Amazon S3? Look no further! Our comprehensive online course is your gateway to mastering the fundamentals of Amazon S3, designed to empower beginners and enthusiasts alike.   🔍 What You'll Learn: Foundation of Amazon S3: Gain a solid understanding of Amazon Simple Storage Service (S3) and its core functionalities. Setting Up & Configuration: Learn step-by-step how to create buckets, set permissions, and configure storage options effectively. Data Management: Master the art of storing, retrieving, and organizing data efficiently in Amazon S3. Security & Compliance: Understand best practices for securing your data and complying with industry standards. Integration & Automation: Explore integration possibilities and automate processes for seamless functionality.   💡 Why Choose Our Course? Expert Guidance: Led by industry experts with extensive experience in cloud computing and Amazon S3. Practical Approach: Hands-on exercises and real-life examples to reinforce learning. Flexible Learning: Study at your own pace, accessible 24/7 from anywhere in the world. Updated Content: Stay current with the latest trends, tips, and techniques in Amazon S3.   🎓 Who Is This Course For? Newcomers to Cloud Computing: Perfect for beginners looking to understand the basics of Amazon S3. IT Professionals: Enhance your skill set and advance your career in cloud technology. Developers & Entrepreneurs: Learn how to optimize Amazon S3 for your projects or business.   🏆 Enroll Today and Take Your First Step Towards Mastery! 🏆 Invest in your future with our 'Introduction to Amazon S3 Essentials' course and gain the expertise to navigate the world of cloud storage confidently. 👉 Don't miss this opportunity! Enroll now and unlock the potential of Amazon S3! 👈 Course Curriculum Basic Overview 00:00 Pricing 00:00 Set Up 00:00 File Storage 00:00 File Interface-Filezilla 00:00 File Interface-Cloudberry 00:00 File Delivery 00:00 File Backup 00:00 File Backup- Part-2 00:00 File Sharing 00:00 Cloud Transfers 00:00 Zapier Connection - Part 1 - Dropbox 00:00 Zapier Connection - Part 2 - Google Drive 00:00 Hosting Multimedia on S3 00:00 Using a Multimedia Interface on S3 00:00 Should I Host Multimedia on S3 00:00 File Protection 00:00 Tracking Bandwidth 00:00 Embedding Amazon S3 Video to Static HTML 00:00 Conclusion 00:00 Advanced Overview 00:00 Create and Configure a Bucket 00:00 Add A Bucket Policy 00:00 Uploading and Testing 00:00 Using Your Own Domain 00:00 Custom Domain Configuration - Part 1 00:00 Custom Domain Configuration - Part 2 - Bucket Configuration 00:00 Custom Domain Configuration - Part 3 00:00 Custom Domain Configuration - Part 4 - Domain Offsite 00:00 Custom Domain Configuration-Part 5 - Alias 00:00 Custom Domain Configuration - Part 6 - Testing 00:00 WordPress Installation - Part 1 00:00 WordPress Installation - Part 2 00:00 WordPress Backup to S3 00:00 WordPress Media Offload to S3 00:00 Serving Website Images From Amazon S3 00:00 Embedding Media Into WordPress 00:00 Embedding S3 Video Into WordPress with HTML 00:00 Securing Downloads In S3 and WordPress 00:00 Conclusion 00:00

Information on the risks and practical advice to address them TSC's eBooks, whitepapers, and reports cover some of the most important risks in information and cyber security — risks that constantly challenge information and cyber security professionals who work tirelessly to reduce them across their organisations and home users alike.

Duration 2 Days 12 CPD hours This course is intended for This course is intended for Sales Representatives (SR), Sales Managers and End-users who have an interest in the Sales components of Dynamics 365. Students should have an existing working knowledge of either Microsoft Dynamics 365 or Microsoft Dynamics CRM. As a minimum, students should attend the prerequisite course Introduction to Microsoft Dynamics 365 Overview Understand the features and tools that exist in Microsoft Dynamics 365 for SR?s and Sales Managers. Be familiar with the stages of the Sales Order. Process in Microsoft Dynamics 365. Understand the fundamentals of Lead and Opportunity Management. Be able to track, manage, qualify Leads and convert to Opportunities and related customer records in Microsoft Dynamics 365. Know how to disqualify and cancel Leads, and convert Activity records to Leads and Opportunities. Understand how to collaborate on Opportunities with other SR?s and close Opportunity records as Won and Lost. Be able to track Competitors and Stakeholders. Understand how to view Resolution Activities. Add Products and Write-In Products to Opportunities. Build and maintain a repository of Products, Product Bundles and Product Families in the Product Catalog. Configure Unit Groups, Price Lists and Discount Lists. Work with Product Properties and view a Product Hierarchy. Create Quotes and add Products. Work with the Sales Order Process to convert Quotes to Orders and Invoices. Fulfill Orders and manage Invoice payments. Explore the Sales Reports and create a custom Sales Report using the Reporting Wizard in Microsoft Dynamics 365. Understand the significance of Sales Goal Management and Metrics in Microsoft Dynamics 365. Explore the Sales Charts and Dashboards and create a custom Sales Dashboard in Microsoft Dynamics 365. This course provides students with a detailed hands-on experience of the Salesfeatures and components of Microsoft Dynamics 365. Introduction Sales Order Process Scenarios An Introduction to Sales in Dynamics 365 The Dynamics 365 Platform Dynamics 365 Sales Fundamentals Security Considerations Where to get Help Further Reading and Resources Lead Management The Lead Management Process Working with Lead Records Working with the Lead Form Lead Assignment Leads and Activities Qualifying a Lead Disqualifying a Lead Opportunities Management Introduction to Opportunities The Opportunity Views The Opportunity Form Opportunity Sales Process Closing an Opportunity Resolution Activities Products Introduction to the Product Catalog Adding Products Configuring Unit Groups Price Lists and Price List Items Quotes, Orders and Invoices Introduction to Order Processing Adding Products to an Opportunity Working with Quotes Working with Orders Working with Invoices Sales Analysis Introduction to Sales Analysis in Dynamics 365 The Sales Reports The Reporting Wizard Working with Sales Charts Working with Sales Dashboards Working with Sales Goals and Metrics

Duration 2 Days 12 CPD hours This course is intended for This in an intermediate-level Java development course geared for students experienced with Java and Spring programming essentials. This course does not cover Java or Spring development basics. Overview This 'skills-centric' course is about 50% hands-on lab and 50% lecture, designed to train attendees in core Cucumber and web testing skills, coupling the most current, effective techniques with the soundest industry practices. Working within in an engaging, hands-on learning environment, guided by our expert team, attendees will: Learn the request-response cycle of REST requests Implement a REST controller using Spring Map URLs to service endpoints Use Spring's template class to develop a REST client Bootstrap a Spring REST applications Return different media types for a service Setting the response headers Discuss Exceptions and HTTP Status codes Handle exceptions thrown by a service Spring REST focuses on providing an understanding of the fundamental principles and technologies that are used in the development of RESTful services and clients. This understanding is critical to being able to diagnose, troubleshoot, tune, and perform other lifecycle activities.Working with Spring REST is a two-day, fast-paced coding course geared for experienced developers who have prior working knowledge of Java. Throughout the course students learn the best practices for writing Restful services in Java using Spring Boot. The course provides an in-depth view of the APIs provided by Spring to develop both the REST service and the REST client. Implementing REST with Spring REST principles Introduction to RESTful Services in Spring Introduction to REST Clients in Spring Bootstrapping the REST application Content Representation Implementing the REST Service Error Handling Security and RESTful Services Securing Untrusted Input Defending RESTful Services Additional course details: Nexus Humans Working with Spring REST (TT3358) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Working with Spring REST (TT3358) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 2 Days 12 CPD hours This course is intended for This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases and developing tables, queries, forms, and reports in Microsoft Access for Office 365. Overview In this course, you will optimize an Access database. You will: Provide input validation features to promote the entry of quality data into a database. Organize a database for efficiency and performance, and to maintain data integrity. Improve the usability of Access tables. Create advanced queries to join and summarize data. Use advanced formatting and controls to improve form presentation. Use advanced formatting and calculated fields to improve reports. In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users.This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Access Expert (Office 365 and Office 2019): Exam MO-500 certification. Improving Table Usability Topic A: Create Lookups Within a Table Topic B: Work with Subdatasheets Creating Advanced Queries Topic A: Create Query Joins Topic B: Create Subqueries Topic C: Summarize Data Improving Form Presentation Topic A: Apply Conditional Formatting Topic B: Create Tab Pages with Subforms and Other Controls Creating Advanced Reports Topic A: Apply Advanced Formatting to a Report Topic B: Add a Calculated Field to a Report Topic C: Control Pagination and Print Quality Topic D: Add a Chart to a Report Importing and Exporting Table Data Topic A: Import and Link Data Topic B: Export Data Topic C: Create a Mail Merge Using Queries to Manage Data Topic A: Create Action Queries Topic B: Create Unmatched and Duplicate Queries Creating Complex Reports and Forms Topic A: Create Subreports Topic B: Create a Navigation Form Topic C: Show Details in Subforms and Popup Forms Creating Access Macros Topic A: Create a Standalone Macro to Automate Repetitive Tasks Topic B: Create a Macro to Program a User Interface Component Topic C: Filter Records by Using a Condition Topic D: Create a Data Macro Using VBA to Extend Database Capabilities Topic A: Introduction to VBA Topic B: Using VBA with Form Controls Managing a Database Topic A: Back Up a Database Topic B: Manage Performance Issues Topic C: Document a Database Distributing and Securing a Database Topic A: Split a Database for Multiple-User Access Topic B: Implement Security Topic C: Convert an Access Database to an ACCDE File Topic D: Package a Database with a Digital Signature

Duration 2 Days 12 CPD hours This course is intended for This course is intended for network engineers, network support personnel, and reseller support. Overview After successfully completing this course, you should be able to:Configure LAN-to-LAN IP Security (IPsec) VPNs in various configurations. Configure VPN redundancy. Configure dynamic routing using IPsec VPNs. Configure remote access IPsec connectivity including group Internet Key Exchange (IKE) and shared IKE. Configure generic routing encapsulation (GRE) tunnels. This intermediate-level course focuses on the wide range of options available when configuring virtual private networks (VPNs) using Juniper Networks firewall/VPN products. Students attending the course will learn these various deployments through detailed lectures and hands-on lab exercises. Chapter 1: Course IntroductionChapter 2: ScreenOS VPN Basics Review VPN Review Verifying Operations VPN Monitor Lab: VPN Review Chapter 3: VPN Variations Dynamic Peers Transparent Mode Overlapping Addresses Lab: VPN Variations Chapter 4: Hub-and-Spoke VPNs Concepts Policy-Based Hub-and-Spoke VPNs Route-Based Hub-and-Spoke VPNs with No Policy and NHTB Route-Based Hub-and_Spoke VPNS with Policy Centralized Control Hub-and-Spoke VPNs ACVPNs Lab: Hub-and-Spoke VPNs Chapter 5: Routing over VPNs Routing Overview Configuring RIP Configuring OSPF Case Studies Lab: Dynamic Routing Chapter 6: Using Certificates Concepts and Terminology Configuring Certificates and Certificate Support Configuring VPNs with Certificates Lab: Using Certificates Chapter 7: Redundant VPN Gateways (Optional) Redundant VPN Gateways Other Options Demonstration: Redundant VPN Gateways Chapter 8: Generic Routing Encapsulation (Optional) Configuring GRE Chapter 9: Dial-Up IPsec VPNs (Optional) Basic Dial-Up Configuration Group IKE ID XAUTH and Shared IKE ID Additional course details: Nexus Humans Advanced Juniper Networks VPN Implementations training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Advanced Juniper Networks VPN Implementations course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 1 Days 6 CPD hours This day-long workshop gives participants a thorough understanding of the iPad iOS operating system. This course is designed for both those who want to learn more about their iPads, those who work in business environments and who want to integrate the iPad into their existing company?s infrastructure, as well as personnel who are responsible for supporting other iPad users. Setting Up The iPad iPad Essentials The Home Screen Launching and Running Apps Changing Screen Orientation Locking the Rotation The Control Center Creating Folders Accessibility and Voice Over Settings General Settings Parameters Passcode Setting Up Notifications Location Services iCloud and Synching your iPad Other Application Settings Multi-Touch Gestures Tap, Touch and Hold Drag, Flick and Swipe Pinch, Rotate and Shake Switching Between Applications Using the Apple Applications Showing and Hiding Applications Closing Documents vs. Quitting Applications Working With Documents Type, Select, Cut, Copy, Paste and Replace Understanding the iPad Keyboard Opening Pages, Numbers and Keynote Accessing Files and Documents Copying files between the iPad and Computer Working with Microsoft Office Connecting To The Internet WI-FI and Bluetooth Devices Through Servers Browsing and Searching The Web Enterprise Network The iPad In Business iOS Security Deployment Seamless Integration Mobile Device Management Printing with AirPrint Creating Passcodes Working with Photos and Camera Photos and Video Recording Video Integrating Photos or Video Into Documents or Presentations Mirroring Video Finding and Installing Apps The App Store Apps for Enterprise Installing and Deleting Apps Resetting the iPad Connecting and Mirroring with the iPhone Battery Issues Tips for Improving Battery Use Rebooting the iPad Hidden Keystrokes Troubleshooting Connectivity Issues ReInstalling Apps Preserving Batter Power Accessibility Functions Additional course details: Nexus Humans iPad For Business training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the iPad For Business course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for This basic course is for IT personnel with a theoretical background of z/OS. Overview Review the main concepts of z/OS Log on to TSO and start ISPF/PDF Navigate through ISPF/PDF dialogs and use the basic ISPF/PDF functions and the ISPF Editor Use ISPF/PDF to allocate data sets and edit data sets (including hierarchical file system (HFS) files) via the ISPF Editor primary and line commands Use ISPF to create and manipulate (copy, rename, delete, list, sort and merge) data sets Identify security considerations for Multiple Virtual Storage (MVS) data sets and HFS files Describe and use TSO/E commands Perform simple modifications to existing ISPF/PDF panels Invoke a REXX exec and TSO CLIST Tailor existing JCL and submit batch jobs Review job status and job output using SDSF Invoke UNIX processes Manipulate HFS directories and file systems using the UNIX System Services ISHELL This course is designed to teach students the fundamental practical skills to navigate and work in a z/OS environment. This includes the use of ISPF/PDF dialogs, TSO/E commands, JCL, UNIX System Services shell, and BookManager. Review of the z/Architecture and z/OS An Introduction to ISPF, ISPF/PDF, and RACF System familiarization Working with ISPF/PDF (Part 1 & 2) Allocate new data sets ISPF editor primary commands ISPF editor line command Copy/move/rename/delete data sets and members Data set lists Working with TSO/E Using TSO/E commands Working with JCL Submit a job JCL exercises Working with UNIX System Services Procedures ISHELL and hierarchical file system Additional course details: Nexus Humans ES10 IBM Fundamental System Skills in z/OS training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the ES10 IBM Fundamental System Skills in z/OS course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Overview Learn to use the full power and functionality of Microsoft's Excel and deliver impressive charts and analysis work. This Advanced Diploma in MS Excel course allows you to exploit the full abilities of Microsoft's best-selling tool and become capable of providing higher-quality results from it. You may use Excel every day in your work or business, but are you really using it to its full potential? With the advanced training from this course, you will quickly produce stunning spreadsheets and visually perfect graphs that will showcase business data to a much more professional degree. Use Excel to make your customer service excellent. How will I get my certificate? At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Advanced Diploma in MS Excel. It is available to all students, of all academic backgrounds. Requirements Our Advanced Diploma in MS Excel 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 21 sections • 90 lectures • 22:14:00 total length •Introduction to Microsoft Excel 2019 New Features: 00:07:00 •CONCAT: 00:02:00 •IFS: 00:01:00 •MAXIFS: 00:01:00 •MINIFS: 00:01:00 •SWITCH: 00:02:00 •TEXTJOIN: 00:01:00 •Map Chart: 00:02:00 •Funnel Chart: 00:01:00 •Better Visuals: 00:06:00 •Pivot Table Enhancements: 00:02:00 •Power Pivot Updates: 00:01:00 •Navigate the Excel User Interface: 00:28:00 •Use Excel Commands: 00:10:00 •Create and Save a Basic Workbook: 00:19:00 •Enter Cell Data: 00:12:00 •Use Excel Help: 00:05:00 •Create Worksheet Formulas: 00:15:00 •Insert Functions: 00:17:00 •Reuse Formulas and Functions: 00:17:00 •Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00 •Search for and Replace Data: 00:09:00 •Use Proofing and Research Tools: 00:07:00 •Apply Text Formats: 00:16:00 •Apply Number Format: 00:08:00 •Align Cell Contents: 00:09:00 •Apply Styles and Themes: 00:12:00 •Apply Basic Conditional Formatting: 00:11:00 •Create and Use Templates: 00:08:00 •Preview and Print a Workbook: 00:10:00 •Set Up the Page Layout: 00:09:00 •Configure Headers and Footers: 00:07:00 •Manage Worksheets: 00:05:00 •Manage Workbook and Worksheet Views: 00:07:00 •Manage Workbook Properties: 00:06:00 •Work with Ranges: 00:18:00 •Use Specialized Functions: 00:11:00 •Work with Logical Functions: 00:23:00 •Work with Date & Time Functions: 00:08:00 •Work with Text Functions: 00:11:00 •Sort Data: 00:10:00 •Filter Data: 00:10:00 •Query Data with Database Functions: 00:09:00 •Outline and Subtotal Data: 00:09:00 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •Create a PivotTable: 00:13:00 •Analyze PivotTable Data: 00:12:00 •Present Data with PivotCharts: 00:07:00 •Filter Data by Using Timelines and Slicers: 00:11:00 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:05:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:09:00 •Watch and Evaluate Formulas: 00:08:00 •Collaborate on a Workbook: 00:19:00 •Protect Worksheets and Workbooks: 00:08:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •Determine Potential Outcomes Using Data Tables: 00:08:00 •Determine Potential Outcomes Using Scenarios: 00:09:00 •Use the Goal Seek Feature: 00:04:00 •Forecasting Data Trends: 00:05:00 •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 •Resources - Microsoft Excel - Beginner Course - Cpd Accredited: 00:00:00 •Assignment - Advanced Diploma in MS Excel: 00:05:00