337 Courses in Cardiff delivered On Demand

Sage 50 Payroll Complete Course Overview If you want to work in the accounting or finance sector but lack the necessary payroll knowledge and abilities, the Sage 50 Payroll Complete Course is the ideal course for you. Sage is a widely used software system that is utilized by both large and small organizations worldwide. You must be familiar with Sage 50 Payroll in order to stay up to date with technology and get hired by the majority of firms. You will be a great addition to any business after completing this course. An annual cost of salaries, tax code modification, SSP processing, employing advanced payment choices, and more will all be covered in this course. While the list is endless, one thing always stays the same: Sage 50 Payroll will keep you informed about the newest techniques and technology, enabling you to utilize it with assurance. Why You Should Choose Sage 50 Payroll Complete Course Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Sage 50 Payroll Complete Course is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Sage 50 Payroll Complete 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. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Sage 50 Payroll For Beginners Module 1: Payroll Basics Payroll Basics 00:10:00 Module 2: Company Settings Company Settings 00:08:00 Module 3: Legislation Settings Legislation Settings 00:07:00 Module 4: Pension Scheme Basics Pension Scheme Basics 00:06:00 Module 5: Pay Elements Pay Elements 00:14:00 Module 6: The Processing Date The Processing Date 00:07:00 Module 7: Adding Existing Employees Adding Existing Employees 00:08:00 Module 8: Adding New Employees Adding New Employees 00:12:00 Module 9: Payroll Processing Basics Payroll Processing Basics 00:11:00 Module 10: Entering Payments Entering Payments 00:12:00 Module 11: Pre-Update Reports Pre-Update Reports 00:09:00 Module 12: Updating Records Updating Records 00:09:00 Module 13: E-Submissions Basics e-Submissions Basics 00:09:00 Module 14: Process Payroll (November) Process Payroll (November) 00:16:00 Module 15: Employee Records And Reports Employee Records and Reports 00:13:00 Module 16: Editing Employee Records Editing Employee Records 00:07:00 Module 17: Process Payroll (December) Process Payroll (December) 00:12:00 Module 18: Resetting Payments Resetting Payments 00:05:00 Module 19: Quick SSP Quick SSP 00:10:00 Module 20: An Employee Leaves An Employee Leaves 00:13:00 Module 21: Final Payroll Run Final Payroll Run 00:07:00 Module 22: Reports And Historical Data Reports and Historical Data 00:08:00 Module 23: Year-End Procedures Year-End Procedures 00:09:00 Sage 50 Payroll Intermediate Level Section 01: The Outline View And Criteria The Outline View and Criteria 00:11:00 Section 02: Global Changes Global Changes 00:07:00 Section 03: Timesheets Timesheets 00:12:00 Section 04: Departments And Analysis Departments and Analysis 00:11:00 Section 05: Holiday Schemes Holiday Schemes 00:10:00 Section 06: Recording Holidays Recording Holidays 00:12:00 Section 07: Absence Reasons Absence Reasons 00:13:00 Section 08: Statutory Sick Pay Statutory Sick Pay 00:16:00 Section 09: Statutory Maternity Pay Statutory Maternity Pay 00:17:00 Section 10: Student Loans Student Loans 00:09:00 Section 11: Company Cars Company Cars 00:13:00 Section 12: Workplace Pensions Workplace Pensions 00:21:00 Section 13: Holiday Funds Holiday Funds 00:13:00 Section 14: Roll Back Roll Back 00:03:00 Section 15: Passwords And Access Rights Passwords and Access Rights 00:08:00 Section 16: Options And Links Options and Links 00:10:00 Section 17: Linking Payroll To Accounts Linking Payroll to Accounts 00:08:00 Assignment Assignment - Sage 50 Payroll Complete Course 00:00:00

Cyber Security Training Course Overview This cyber security course is accredited by the CPD UK. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Employees, managers and directors should all have a good understanding of the threat posed by cyber-attacks and the importance of guarding against data breaches. This cyber security short course will explain why cyber attacks and data breaches happen and provide practical advice on how to set up effective defences. First, the course will identify potential 'cyber threat actors' who initiate cybercrime, along with looking at the main motivations behind cyber-attacks on individuals and organisations. On a more practical level, you'll learn how to recognise and deal effectively with phishing attempts. The cyber security course will highlight the importance of keeping passwords secure and cover security for devices, such as smartphones, laptops, tablets or desktop computers. You'll learn how to report a suspected cyber attack, and what to do if you genuinely make a mistake. Finally, we'll underline the importance of cooperation and show how working closely together helps overcome a wide range of cybersecurity issues. Who should take this course? The cyber security course is aimed at employees at all levels of an organisation as it provides an overview of some of the most common cyber security threats encountered in business. Entry Requirement There are no academic entry requirements for this cyber security course, and it is open to students of all academic backgrounds. Advantages Training staff in cyber security is vital to protect your business from these ever present online threats. CPD approval means that this course can be used by those that need to prove they are continually developing themselves. Online training is flexible, efficient and cost effective meaning the candidate can progress through the modules at their own pace and in their own time, so they can fit the training in around their work and personal life. Course Curriculum Module 1: Cyber Security - An Overview Module 2: Combating Cyber Attacks Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Certificate of Achievement Valuable Certification On completion of the course, you will be eligible to download CPD and IIRSM accredited and by the Institute of Hospitality endorsed free electronic certificate instantly. There is a minimal shipping charge applicable to get the hardcopy course completion certificate which is: Shipment Inside the UK = £5.99 International Shipment = £16.99 Overview Cyber Security Training Course Overview This cyber security course is accredited by the CPD UK. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Employees, managers and directors should all have a good understanding of the threat posed by cyber-attacks and the importance of guarding against data breaches. This cyber security short course will explain why cyber attacks and data breaches happen and provide practical advice on how to set up effective defences. First, the course will identify potential 'cyber threat actors' who initiate cybercrime, along with looking at the main motivations behind cyber-attacks on individuals and organisations. On a more practical level, you'll learn how to recognise and deal effectively with phishing attempts. The cyber security course will highlight the importance of keeping passwords secure and cover security for devices, such as smartphones, laptops, tablets or desktop computers. You'll learn how to report a suspected cyber attack, and what to do if you genuinely make a mistake. Finally, we'll underline the importance of cooperation and show how working closely together helps overcome a wide range of cybersecurity issues. Who should take this course? The cyber security course is aimed at employees at all levels of an organisation as it provides an overview of some of the most common cyber security threats encountered in business. Entry Requirement There are no academic entry requirements for this cyber security course, and it is open to students of all academic backgrounds. Advantages Training staff in cyber security is vital to protect your business from these ever present online threats. CPD approval means that this course can be used by those that need to prove they are continually developing themselves. Online training is flexible, efficient and cost effective meaning the candidate can progress through the modules at their own pace and in their own time, so they can fit the training in around their work and personal life. Course Curriculum Module 1: Cyber Security - An Overview Module 2: Combating Cyber Attacks Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Certificate of Achievement Valuable Certification On completion of the course, you will be eligible to download CPD and IIRSM accredited and by the Institute of Hospitality endorsed free electronic certificate instantly. There is a minimal shipping charge applicable to get the hardcopy course completion certificate which is: Shipment Inside the UK = £5.99 International Shipment = £16.99 FAQ Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org Course Fee £25 £60 58% OFF 👉 CPD UK Accredited PDF Certificate Included 4 interest-free payments of £6.25 Cyber Security Training quantity ENROL NOW Duration: * Hours Instant Access Get In Touch Today Live CHAT WITH US CALL ON - 0300 124 5585 Certificate of Achievement Valuable Certification On completion of the course, you will be eligible to download CPD and IIRSM accredited and by the Institute of Hospitality endorsed free electronic certificate instantly. There is a minimal shipping charge applicable to get the hardcopy course completion certificate which is: Shipment Inside the UK = £5.99 International Shipment = £16.99 FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Description This VMware vSphere 6.0 Ultimate Bootcamp covers everything you need to know about the VMware vSphere 6.0 Ultimate Bootcamp. In this course you will learn about virtualization, planning and installing ESXi, using tools to administer a VMware environment, vCenter Server 6.0 and licensing, configuring networking, configuring storage, VM creation, configuration, and snapshots, security and permissions, server and VM monitoring, advanced ESXi and vCenter server management, patching and upgrading ESXi, and disaster recovery and backup. This course is designed to immerse you into the new features inherent to version 6.0. It will prepare you to achieve the Certified Virtualization Expert 6.0 (CVE6.0) certification, which will demonstrate practical VMware vSphere knowledge and skills as a certified professional. So, if you are interested to learn more you can join this course now. Assessment & Certification To achieve a formal qualification, you are required to book an official exam separately with the relevant awarding bodies. However, you will be able to order a course completion CPD Certificate by paying an additional fee. Hardcopy Certificate by post - £19 Soft copy PDF via email - £10 Requirements Our VMware vSphere 6.0 Ultimate Bootcamp 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. Series Introduction and Methodology UB Learn IT! Do IT! Know IT! FREE 00:02:00 Virtualization Overview UB VMware Virtualization 00:09:00 Other VMware & 3rd Party Virtualization Technologies 00:05:00 Planning and Installing ESXi Planning the ESXi Deployment 00:09:00 vSphere 6.x Deployment Guidelines 00:06:00 vSphere Hypervisor (ESXi) Installation 00:12:00 Configuring Hostname Resolution and NTP 00:02:00 Troubleshooting ESXi 00:03:00 Using Tools to Administer a VMware Environment Overview of 3rd Party Tools 00:05:00 ESXi Management 00:19:00 Linux Command Review 00:03:00 Troubleshooting the vSphere Client (VIC) 00:01:00 vCenter Server 6.0 and Licensing Licensing 00:06:00 Planning vCenter Server Deployment 00:25:00 vCenter Server Installation 00:14:00 vSphere Web Client 00:11:00 vCenter Server Inventory 00:11:00 Managing vCenter Server 00:07:00 Troubleshooting vCenter Server and Database 00:08:00 Configuring Networking Creating & Modifying Virtual Networks 00:48:00 vSphere Distributed Switches 00:28:00 3rd Party Distributed Switches 00:03:00 Configuring Storage Storage Concepts 00:28:00 iSCSI Storage 00:12:00 Fibre Channel Storage 00:07:00 VMFS Datastores 00:12:00 NAS Storage and NFS Datastores 00:06:00 Raw Device Mapping (RDM) 00:03:00 Solid State Disks (SSD) 00:05:00 Storage & Management Solutions 00:01:00 VMware Virtual SAN (VSAN) 00:04:00 Virtual Volumes (VVols) 00:06:00 VM Creation, Configuration, and Snapshots Create a VM 00:37:00 Create Multiple VMs, Templates & Clones 00:18:00 Virtual Appliances 00:05:00 Configuration and Use of vApps 00:03:00 VMware Converter (P2V - V2V) 00:17:00 Manage VMs 00:22:00 Virtual Machine Startup Shutdown 00:02:00 Virtual Machine Snapshots 00:06:00 Virtual Machine Troubleshooting & Best Practices 00:02:00 Security and Permissions Controlling User Access and Passwords 00:15:00 ESXi Active Directory (AD) Integration 00:02:00 Managing Firewalls 00:02:00 Managing Security Certificates 00:02:00 Server and VM Monitoring Optimizing Resources 00:23:00 Resource Pools 00:05:00 Latency Sensitive Applications 00:01:00 Performance Monitoring 00:10:00 Configuring Alarms 00:07:00 ESXi & vCenter Logs 00:04:00 Advanced ESXi and vCenter Server Management Storage Reports 00:01:00 Storage vMotion 00:04:00 Configuring vMotion 00:13:00 Enhanced vMotion 00:01:00 Distributed Resource Scheduler (DRS) Cluster 00:17:00 DRS Cluster Monitoring 00:03:00 Profile Driven Storage, Datastore Clusters & Storage DRS (SDRS) 00:11:00 Host Profiles 00:05:00 Linked Mode Group of vCenter Servers 00:03:00 Patching and Upgrading ESXi Patching ESXi Standalone Hosts & vCSA 6.0 00:01:00 Patching the vCenter Environment 00:23:00 Upgrades and Migrations 00:29:00 Disaster Recovery and Backup vSphere Replication 6 00:06:00 Site Recovery Manager (SRM) 00:04:00 High Availability (HA) 00:21:00 VM Fault Tolerance 00:14:00 Microsoft Clustering 00:14:00 Backup Strategies 00:01:00 vSphere Data Protection 00:10:00 Third Party Backups 00:09:00 Mock Exam Mock Exam- VMware vSphere 6.0 Ultimate Bootcamp 00:20:00 Final Exam Final Exam- VMware vSphere 6.0 Ultimate Bootcamp 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Microsoft Access is the most popular database for Windows. It enables you to collect, organize, and report on data via a graphical interface. Templates provide pre-defined forms, reports and database designs - and Macros enable you to automate regular tasks. By this Microsoft Access 2016 Advanced explore the advanced Access features. Whether you are using Access for the first time, , or have been using it for years, this course will help you make the most of Access 2016's features and tools. So, if you are thinking to improve your knowledge in Microsoft Access 2016, you can join this course now. Learning Outcomes: 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 Access 2016 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 Microsoft Access 2016 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. Implementing Advanced Form Design 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 Using Data Validation Field Validation 00:30:00 Form and Record Validation 00:30:00 Using Macros to Improve User Interface Design 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 Using Advanced Database Management 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 Distributing and Securing a Database 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 Managing Switchboards Create a Database Switchboard 01:00:00 Modify a Database Switchboard 00:30:00 Set Startup Options 00:30:00 Activities Activities - Microsoft Access 2016 Advanced 00:00:00 Mock Exam Mock Exam- Microsoft Access 2016 Advanced 00:20:00 Final Exam Final Exam- Microsoft Access 2016 Advanced 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Microsoft Windows 10 Complete Course is comprised of lessons which will help the novice to advanced computer users. Windows 10 is the latest iteration of the popular Windows operating system. It has upgraded features which makes it completely different and advanced compared to its predecessors. In the introductory modules, you will be accustomed to the new interface and features. You will also be taught on using with virtual desktops, managing apps and devices, sharing files and folders, system recovery, security settings, etc. By the end of this course, learners will be comfortable with the Windows 10 interface, using Windows Store apps, work with the Windows 10 desktop, using Microsoft Edge, customizing the Windows 10 environment, using Windows 10 security features, and more. Learning Outcomes: Learn to use desktop and Start menu, multitask using apps, and focus on the new Snap Assist feature Familiarize yourself with notifications, Action Center, Contana, search fields, and virtual desktops in the Windows 10 environment before learning how to connect devices to PC Customize the Window according to your needs using the Settings window and Control panel to modify Windows settings Further personalize the lock screen, desktop, and get introduced to OneDrive - a prominent feature of this version of Windows Work with 3 key productivity apps: Mail, Calendar and Camera Have fun with the entertainment side of Windows 10 by getting to know Groove Music, Movies &TV, and Xbox apps Browse the internet using Microsoft Edge Introduction to PC's and Windows 10 user interface, learn to sign in and navigate smoothly through the Start menu Familiarize yourself with the use of desktop and its components, create and modify files through desktop applications, and manage files and folders with File Explorer Explore the internet with Microsoft Edge and utilizing its tabs Discover best ways to use the Windows Store and Universal Apps Interact with Microsoft Cortana and store and/or share files with OneDrive Create new user accounts for the Windows and customize the Start menu Set up account passwords for users and use Windows Defender Get to know how to use Settings window, control panel, working with desktops and managing apps Utilize the Control Panel and Settings window to configure the user accounts, before moving onto family safety features Best ways to utilize key Windows 10 apps like Mail, Calendar, Groove Music, Movies & TV, Camera and Xbox Connect your PC to other devices and change their settings, further manage devices and printer through the Control Panel Learn more about networks and manage them, and share files and folders with Homegroup features Work with file history and data backups, recovering your PC, and configure security settings View system information, utilize the Task Manager, optimize power consumption and troubleshoot problems 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 Windows 10 Complete Course 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 Windows 10 Complete 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. 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 Navigate the Desktop 01:00:00 Explore the Start Menu 01:00:00 Multitask with Apps 00:15:00 View Notifications 00:30:00 Search Your Computer 01:00:00 Work with Virtual Desktops 00:30:00 Connect Devices to Your PC 00:30:00 Change Basic Windows Settings 01:00:00 Customize the Lock Screen 00:30:00 Customize the Desktop 00:30:00 Store and Share Files with OneDrive 00:30:00 Use Mail 01:00:00 Use Calendar 01:00:00 Use Camera 00:30:00 Use Groove Music 00:30:00 Use Movies & TV 00:30:00 Use Xbox 01:00:00 Navigate Microsoft Edge 00:30:00 Use Microsoft Edge 01:00:00 Manage Tabs 00:15:00 Modify Microsoft Edge Options 01:00:00 Module - 2 Identify Components of a Personal Computer 00:30:00 Start and Sign into Windows 10 00:45:00 Navigate the Start Menu 00:45:00 Using the Desktop 00:30:00 Elements of a Desktop Window 00:30:00 Manage Files and Folders with File Explorer 00:45:00 Create and Modify Files with Desktop Applications 00:30:00 Components of the Internet 00:30:00 Use Microsoft Edge 00:30:00 Manage Tabs in Microsoft Edge 00:30:00 Using Windows Store 01:00:00 Universal Apps in Windows 10 00:30:00 Interact with Microsoft Cortana 01:30:00 Store and Share Files with OneDrive 00:30:00 Configure User Accounts Using the Settings Window 00:30:00 Personalize Windows 10 00:30:00 Account Passwords 00:30:00 Use Windows Defender 00:30:00 Module - 3 The Settings Window 00:30:00 The Control Panel 00:30:00 Work with Virtual Desktops 00:30:00 Manage Apps 00:30:00 Configure User Accounts Using the Control Panel 00:30:00 Configure User Accounts Using the Settings Window 01:00:00 Use Family Safety Features 00:45:00 Use Mail 00:45:00 Use Calendar 00:30:00 Use Groove Music 00:30:00 Use Movies & TV 00:30:00 Use Camera 00:30:00 Use Xbox 00:30:00 Connect Devices to Your PC 00:30:00 Modify Device Settings 00:30:00 Devices and Printers in the Control Panel 00:30:00 Overview of Networks 00:30:00 Share Files and Folders with a Homegroup 00:30:00 Manage Networks 00:30:00 File History 00:30:00 System Recovery 00:45:00 View System Information 00:30:00 Use the Task Manager 00:45:00 Optimize Power Consumption 00:30:00 Troubleshoot Problems 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 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

🌟 Unlock the Full Power of Microsoft Excel 2019! 🌟 Ready to take your Excel skills to the next level? Dive into our comprehensive online course - 'Microsoft Excel 2019 - Advanced Level Training' - designed to transform you into an Excel maestro! 🚀 Here's What You'll Master: 📊 Section 1: Excel - Advanced - Get hands-on with advanced techniques and shortcuts to streamline your workflow. 📂 Section 2: Working with Multiple Workbooks - Seamlessly manage multiple workbooks and boost your productivity effortlessly. 🔒 Section 3: Protecting Worksheets and Workbooks - Learn how to safeguard your data with robust protection strategies. 📝 Section 4: Conditional Formulas - Unravel the power of conditional logic and unleash the true potential of formulas. 🧮 Section 5: Advanced Functions - Elevate your Excel expertise by mastering complex functions for data analysis. 📚 Section 6: Text Based Functions - Manipulate text effortlessly and efficiently with advanced text-based functions. 🔍 Section 7: What IF Tools - Explore the 'What If' analysis tools to make informed decisions and predictions. 🏁 Section 8: Excel Advanced - Conclusion - Wrap up with a comprehensive understanding and practical application of advanced Excel features. 🎁 Section 9: Bonus #1 - Advanced Pivot Tables - Delve into bonus content covering advanced techniques for Pivot Tables, a must-have skill for data analysis pros. 🌟 Why Choose Our Course? 🔐 Expert Guidance: Led by seasoned Excel professionals, ensuring clarity and depth in learning. 🔄 Practical Assignments: Apply your newfound skills through real-world exercises. 📈 Career Growth: Elevate your career prospects by mastering sought-after Excel abilities. 🌐 Accessible Learning: Study at your own pace from anywhere, anytime with our user-friendly online platform. 🤝 Join our vibrant community of learners dedicated to mastering Excel's advanced functionalities. 💡 Enroll now and revolutionize your Excel prowess with 'Microsoft Excel 2019 - Advanced Level Training'! Don't miss this chance to become an Excel wizard! 💡   Course Curriculum Section 1 - Excel - Advanced Excel Advanced Introduction 01:39 Advanced Shortcut Keys 02:58 Section 2 - Working with Multiple Workbooks Tracing Precedents 00:00 Tracing Dependants 00:00 Watch Window 00:00 Show Formulas 00:00 Section 3 - Protecting Worksheets and Workbooks Protecting Cells in a Worksheet 00:00 Protecting the Workbook Structure 00:00 Encryption with Passwords 00:00 Section 4 - Conditional Formulas Name Ranges 00:00 Simple IF Function 00:00 IF, AND 00:00 IF, OR 00:00 Nested Formulas 00:00 CountIF and CountIFs 00:00 SumIF and SumIFs 00:00 Section 5 - Advanced Functions Advanced VLookUp 00:00 IF and IS Error - Part 1 00:00 IF and IS Error - Part 2 00:00 Advanced Index Match 00:00 Dates - Part 1 00:00 Dates - Part 2 00:00 Replace and Substitute - Part 1 00:00 Replace and Substitute - Part 2 00:00 Section 6 - Text Based Functions Left, Right and Mid Function 00:00 Search Function 00:00 Concatenate and Search 00:00 Indirect - Static 00:00 Indirect - Dynamic 00:00 Section 7 - What IF Tools Goal Seek 00:00 Data Tables 00:00 Scenarios 00:00 Solver 00:00 Section 8 - Excel Advanced - Conclusion Excel Advanced - Conclusion 00:00 Section 9 - Bonus # 1 - Advanced Pivot Tables Building a Mini Dashboard 00:00

🚀 Unlock the Power of Seamless Memberships with 'Creating Seamless Membership Experiences with WishList Member' Online Course! 🚀 Are you tired of struggling to build and manage your online community or membership site? Do you dream of creating a seamless and engaging experience for your members? Look no further! Introducing our groundbreaking online course: 'Creating Seamless Membership Experiences with WishList Member.'   🌟 What's Inside? 🌟 ✨ Master WishList Member: Dive deep into the features of WishList Member, the leading membership plugin for WordPress. Learn how to set up, configure, and optimize your membership site effortlessly. ✨ Design an Irresistible User Journey: Craft an exceptional member experience from start to finish. From the moment they land on your site to ongoing engagement, discover the secrets to keeping your members hooked and satisfied. ✨ Advanced Content Protection: Safeguard your premium content with advanced content protection strategies. Ensure that only your paying members access the exclusive materials you've worked so hard to create. ✨ Automate Member Onboarding: Say goodbye to manual onboarding processes! Automate the member registration and onboarding process to save time and create a seamless experience for your new members. ✨ Retention Strategies: Learn proven techniques to boost member retention rates. Keep your community thriving with strategies that encourage long-term commitment from your members. ✨ Troubleshooting and Optimization: Overcome common challenges and optimize your membership site for peak performance. Uncover troubleshooting tips and tricks to keep your site running smoothly.   🎓 Why Choose This Course? 🎓 🚀 Expert-Led Instruction: Taught by seasoned experts in membership site development, this course provides practical insights and real-world strategies. 🚀 Actionable Lessons: Each module is packed with actionable lessons that you can implement immediately to enhance your membership site. 🚀 Community Support: Join a vibrant community of like-minded individuals. Share experiences, seek advice, and grow together with our dedicated community platform. 🚀 Lifetime Access: Gain lifetime access to the course content, ensuring that you can revisit and review the materials whenever you need them.   💡 Who Is This Course For? 💡 🌐 Entrepreneurs building online communities 🌐 Content creators wanting to monetize their expertise 🌐 Coaches and consultants seeking to offer exclusive content 🌐 Anyone looking to enhance their knowledge of WishList Member and membership site management   Ready to transform your membership site into a seamless and thriving community? Don't miss this opportunity! Enroll now in 'Creating Seamless Membership Experiences with WishList Member' and embark on a journey to membership success! Course Curriculum Basic Overview 00:00 Pricing and Purchase 00:00 WordPress Installation 00:00 Wishlist Member Installation 00:00 Powered By Wishlist Member Affiliate Program 00:00 Integrations - Payment Gateway 00:00 Should I Integrate PayPal 00:00 Integrations With JVZoo 00:00 Integrations - E-Mail Providers 00:00 Integrations - Zapier 00:00 Setting Up Levels 00:00 Setting Up Levels - Part 2 00:00 Configuring Error Messages 00:00 Other Administration Settings 00:00 File Protection 00:00 Folder Protection 00:00 Protected Pages 00:00 Payment and E-Mail Connection 00:00 Testing Logins and Redirects 00:00 Conclusion - Page Access for Members Only 00:00 Advanced Overview 00:00 Importing Members 00:00 Exporting Members 00:00 Member Research and Service 00:00 Sequential Upgrade - Part 1 00:00 Sequential Upgrade - Part 2 00:00 Sequential Upgrade - Part 3 00:00 Chron Jobs 00:00 Broadcast E-Mails 00:00 Blacklisting Customers 00:00 Data Privacy 00:00 Data Privacy - Part 2 00:00 Logins and Passwords 00:00 Creating Custom Registrations 00:00 Category Protection 00:00 Live Example - JVZoo 00:00 Live Example - Thrivecart 00:00 Warrior Plus - Part 1 00:00 Warrior Plus - Part 2 00:00 Conclusion 00:00

Course Overview Ethical hacking, (or penetration testing) involves exploiting computer networks and systems to detect vulnerabilities that could be exposed to dangerous hackers. Many organisations use ethical hackers to test the security of their website or web applications, which is where the role of the Penetration Tester comes in. If you're looking to become a certified Penetration Tester or Ethical Hacker, then this is the course for you. It covers everything you need to know about security testing, including how to use Linux operating systems and SQL programming language.  Learn how to reduce the risk of a cyber attack with this step-by-step training course, designed to equip you with the skills to detect weaknesses in computer systems quickly and easily. It will familiarise you with a range of cyber attacks and techniques for securing systems, from how to create a fake WiFi network and even spy on your clients. Learn ethical hacking from scratch and enrol in this introductory training course today! What You Will Learn In this Ethical Hacking training course, you will learn how to exploit IT systems to detect vulnerabilities that attackers could take advantage of. It will provide you with the fundamental skills to become a qualified Penetration Tester. How to Hack a Windows 10 Computer & Access Their Webcam Installing Kali 2019 As a Virtual Machine A Basic Overview of Kali Linux and Linux Commands An Introduction to Network Penetration Testing Network Hacking - Pre Connection Attacks Website Hacking and Information Gathering Tips & Tricks An Introduction to SQL and SQLmap What is XSS or Cross-Site Scripting? How to Scan a Target Website For Vulnerabilities Extracting Sensitive Data Such As Passwords Why You Should Choose This Course From iStudy Study at your own pace Full Tutor support on weekdays (Monday - Friday) Fully compatible with any device Free Printable PDF Certificate immediately after completion No prior qualifications are needed to take this course No hidden fees or exam charges CPD Qualification Standards and IAO accredited Efficient exam system, assessment, and instant results Our customer support team is always ready to help you Gain professional skills and better earning potential Certification After completing the course you'll receive a free printable CPD accredited PDF certificate. Hard Copy certificate is also available, and you can get one for just £9! Accreditation This course is accredited by Continuing Professional Development (CPD). It is a recognised independent accreditation service. Enrol today and learn something new with iStudy. You'll find a full breakdown of the course curriculum down below, take a look and see just how much this course offers. We're sure you'll be satisfied with this course.

Learning Objectives Introduction , Customizing Excel , Analyzing Data with Logical Functions , Working with Lookup Functions , Using Text Functions , Working with Date and Time Functions , Formula Auditing , What-If Analysis , Worksheet and Workbook Protection , Automating with Macros , Working with Form Controls , Ensuring Data Integrity , Collaborating in Excel , Importing and Exporting Data to a Text File , Conclusion   Pre-Requisites Excel 365 Introduction and Intermediate courses or equivalent experience.   Description This course will teach students advanced concepts and formulas in Microsoft Excel 365. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks. Course Introduction Introduction 00:01:00 Section 01 Lesson 01-Customizing the Ribbon 00:09:00 Lesson 02-Customizing the Quick Access Toolbar 00:06:00 Lesson 03-Customizing the General and Formula Options 00:04:00 Lesson 04-Customizing the AutoCorrect Options 00:03:00 Lesson 05-Customizing the Save Defaults 00:04:00 Lesson 06-Customizing Advanced Excel Options 00:03:00 Section 02 Lesson 01-Working with the Most Common Logical Functions 00:03:00 Lesson 02-Understanding IF Functions 00:06:00 Lesson 03-Evaluating Data with the AND Function 00:05:00 Lesson 04-Evaluating Data with the OR Function 00:03:00 Lesson 05-Creating a Nested IF Function 00:05:00 Lesson 06-Using the IFS Function 00:03:00 Lesson 07-Summarizing Data with SUMIF 00:03:00 Lesson 08-Summarizing Data with AVERAGEIF 00:02:00 Lesson 09-Summarizing Data with COUNTIF 00:02:00 Lesson 10-Summarizing Data with MAXIFS and MINIFS 00:03:00 Lesson 11-Using the IFERROR Function 00:03:00 Section 03 Lesson 01-What are Lookup Functions 00:03:00 Lesson 02-Using VLOOKUP 00:08:00 Lesson 03-Using HLOOKUP 00:03:00 Lesson 04-Using VLOOKUP with TRUE 00:04:00 Lesson 05-Using HLOOKUP with TRUE 00:02:00 Lesson 06-Using the Index Function 00:03:00 Lesson 07-Using the MATCH Function 00:03:00 Lesson 08-Combining INDEX and MATCH 00:04:00 Lesson 09-Comparing Two Lists with VLOOKUP 00:02:00 Lesson 10-Comparing Two Lists with VLOOKUP and ISNA 00:04:00 Lesson 11-Using the New XLookup Function-v2 00:07:00 Lesson 12-Using Dynamic Array functions-v2 00:06:00 Lesson 13-Other New Functions-v2 00:04:00 Section 04 Lesson 01-What are Text Functions 00:01:00 Lesson 02-Using CONCAT, CONCATENATE, AND TEXTJOIN 00:04:00 Lesson 03-Using Text to Columns 00:02:00 Lesson 04-Using LEFT, RIGHT, and MID Functions 00:03:00 Lesson 05-Using UPPER, LOWER, and PROPER Functions 00:02:00 Lesson 06-Using the Len Function 00:03:00 Lesson 07-Using the Trim Function 00:01:00 Lesson 08-Using the SUBSTITUTE Function 00:02:00 Section 05 Lesson 01-What are Date and Time Functions 00:02:00 Lesson 02-Using TODAY, NOW, and DAY Functions 00:03:00 Lesson 03-Using NETWORKDAYS and YEARFRAC Functions 00:03:00 Section 06 Lesson 01-Showing Formulas 00:03:00 Lesson 02-Tracing Precedents and Dependents 00:04:00 Lesson 03-Adding a Watch Window 00:04:00 Lesson 04-Error Checking 00:04:00 Section 07 Lesson 01-Using the Scenario Manager 00:07:00 Lesson 02-Using Goal Seek 00:03:00 Lesson 03-Analyzing with Data Tables 00:04:00 Section 08 Lesson 01-Understanding Protection 00:02:00 Lesson 02-Encrypting Files with Passwords 00:05:00 Lesson 03-Allowing Specific Worksheet Changes 00:02:00 Lesson 04-Adding Protection to Selected Cells 00:03:00 Lesson 05-Additional Protection Features 00:03:00 Section 09 Lesson 01-What are Macros 00:03:00 Lesson 02-Displaying the Developer Tab 00:03:00 Lesson 03-Creating a Basic Formatting Macro 00:05:00 Lesson 04-Assigning a Macro to a Button 00:03:00 Lesson 05-Creating Complex Macros 00:04:00 Lesson 06-Viewing and Editing the VBA Code 00:04:00 Lesson 07-Adding a Macro to the Quick Access Toolbar 00:03:00 Section 10 Lesson 01-What are Form Controls 00:02:00 Lesson 02-Adding a Spin Button and Check Boxes 00:04:00 Lesson 03-Adding a Combo Box 00:07:00 Section 11 Lesson 01-What is Data Validation 00:02:00 Lesson 02-Restricting Data Entry to the Whole Numbers 00:02:00 Lesson 03-Restricting Data Entry to a List 00:04:00 Lesson 04-Restricting Data Entry to a Date 00:02:00 Lesson 05-Restricting Data Entry to Specific Text Lengths 00:01:00 Lesson 06-Composing Input Messages 00:02:00 Lesson 07-Composing Error Alerts 00:03:00 Lesson 08-Finding Invalid Data 00:02:00 Lesson 09-Editing and Deleting Validation Rules 00:01:00 Section 12 Lesson 01-Working with Comments-v2 00:03:00 Lesson 02-Printing Comments and Errors 00:02:00 Lesson 03-Sharing a Workbook 00:04:00 Lesson 04-Co-Authoring in Excel 00:02:00 Lesson 05-Tracking Changes in a Workbook 00:03:00 Lesson 06-Working with Versions 00:03:00 Lesson 07-Sharing files Via Email-v2 00:03:00 Section 13 Lesson 01-Importing a Text File 00:04:00 Lesson 02-Exporting Data to a Text File 00:01:00 Course Recap Recap 00:02:00 Additional Materials Resource - Excel 365 Advanced 00:00:00 Final Exam Final Exam - Excel 365 Advanced 00:20:00