1635 Database courses delivered Online

Duration 4.5 Days 27 CPD hours This course is intended for This intermediate course is for people who are new to the RACF component of the z/OS Security Server, and responsible for security administration. This includes people who are planning to implement RACF for the first time, and people who are security administrators in installations where RACF is already implemented. Those inexperienced z/OS users may find the course Basics of z/OS RACF Administration (ES19) more appropriate Overview Identify the security requirements of a system Evaluate the facilities and options of RACF Define users to RACF Set up a RACF group structure Use RACF to protect resources Select options to tailor RACF Evaluate and implement RACF database and performance options Identify tools available for auditing Administer the system so that it is consistent with the installation's security goals Be a more effective security administrator using the RACF component of the z/OS Security Server to define users, set up group structures, define general resources, protect z/OS data sets, & use several RACF utilities. Security and RACF overview . Administering groups and users . Protecting z/OS data sets . Introduction to user administration and delegation and general resources . RACF database, tables, and performance options . RACF utilities and exits . RACF options . Auditing the RACF environment . Storage management and RACF . Security for JES facilities . Security classification .

Duration 3.5 Days 21 CPD hours This course is intended for This course is for AWS Cloud Architects with expertise in designing and implementing solutions running on AWS who now want to design for Microsoft Azure. Overview After completing this course, students will be able to: Secure identities with Azure Active Directory and users and groups. Implement identity solutions spanning on-premises and cloud-based capabilities Apply monitoring solutions for collecting, combining, and analyzing data from different sources. Manage subscriptions, accounts, Azure policies, and Role-Based Access Control. Administer Azure using the Resource Manager, Azure portal, Cloud Shell, and CLI. Configure intersite connectivity solutions like VNet Peering, and virtual network gateways. Administer Azure App Service, Azure Container Instances, and Kubernetes. This course teaches Solutions Architects who have previously designed for Amazon Web Services how to translate business requirements into secure, scalable, and reliable solutions for Azure. Introduction to Azure Subscriptions and accounts Resource groups and templates in Azure Resource Manager Azure global infrastructure Azure regions Azure Availability Zones Comparison with AWS Implement Azure Active Directory Introduction to Azure Active Directory Domains and custom domains Safety features Guest users in Azure Active Directory Manage multiple directories Comparison with AWS Implement and manage hybrid identities Introduction to Azure AD Connect Comparison with AWS Implement virtual networking Azure Virtual Network and VNet peering VPN and ExpressRoute connections Comparison with AWS Implement VMs for Windows and Linux Configure high availability Comparison with AWS Implement load balancing and network security Implement Azure Load Balancer Implement an Azure Application Gateway Implement Azure Firewall Implement network security groups and application security groups Comparison with AWS Implement container-based applications Configure Azure Kubernetes Service Publish a solution on an Azure Container Instance Comparison with AWS Implement an application infrastructure Create an App Service plan Create and configure Azure App Service Configure networking for an App Service Introduction to Logic Apps and Azure Functions Comparison with AWS Implement storage accounts Azure Storage core concepts Managing the Azure Blob storage lifecycle Working with Azure Blob storage Comparison with AWS Implement NoSQL databases Introduction to Azure Cosmos DB Consistency Select appropriate CosmosDB APIs Set up replicas in CosmosDB Comparison with AWS DynamoDB Implement Azure SQL databases Configure Azure SQL database settings Implement Azure SQL Database managed instances Configure high availability for an Azure SQL database Comparison with AWS Implement cloud infrastructure monitoring Monitor security Monitor cost Configure a Log Analytics workspace Comparison with AWS Implement and manage Azure governance solutions Assign RBAC roles Configure management access to Azure Implement and configure an Azure Policy Comparison with AWS Manage security for applications Implement Azure Key Vault Implement and configure Azure AD Managed Identities Register and manage applications in Azure AD Comparison with AWS Migration, backup, and disaster recovery management Migrate workloads Implement Azure Backup for VMs Implement disaster recovery Comparison with AWS

The Microsoft Access application is used by professionals who manage the database in their organisation. The advanced users of Access can write rich solutions with advanced data manipulation and user control. Access also has report creation features that can work with any data source that Microsoft Access can access. Through this course, you will learn the advanced skills, knowledge, and information about Microsoft Access. You will learn things related to shareable apps, action bar, customising the records in your desktop database, and much more. Course Highlights Certified Microsoft Access Professional is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Certified Microsoft Access Professional into 13 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 11 hours, 40 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Certified Microsoft Access Professional Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Certified Microsoft Access Professional is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Certified Microsoft Access Professional 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. Module One - Getting Started 00:30:00 Module Two - Using App Views 01:00:00 Module Three - Customizing Apps, Part One 01:00:00 Module Four - Customizing Apps, Part Two 01:00:00 Module Five - Working with More Record Tasks 01:00:00 Module Six - Using Advanced Field Tasks 01:00:00 Module Seven - Working in Table Design View 01:00:00 Module Eight - Working with the Expression Builder 01:00:00 Module Nine - Working with External Data 01:00:00 Module Ten - Creating Queries 01:00:00 Module Eleven - Creating Forms and Reports 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities - Certified Microsoft Access Professional 00:00:00 Mock Exam Mock Exam- Certified Microsoft Access Professional 00:20:00 Final Exam Final Exam- Certified Microsoft Access Professional 00:20:00

Learn how to combine the three most important tools in data science: Python, SQL, and Tableau

Overview This comprehensive course on Machine Learning for Predictive Maps in Python and Leaflet will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Machine Learning for Predictive Maps in Python and Leaflet comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Machine Learning for Predictive Maps in Python and Leaflet. It is available to all students, of all academic backgrounds. Requirements Our Machine Learning for Predictive Maps in Python and Leaflet is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 9 sections • 33 lectures • 05:59:00 total length •Introduction: 00:10:00 •Python Installation: 00:04:00 •Creating a Python Virtual Environment: 00:07:00 •Installing Django: 00:09:00 •Installing Visual Studio Code IDE: 00:06:00 •Installing PostgreSQL Database Server Part 1: 00:03:00 •Installing PostgreSQL Database Server Part 2: 00:09:00 •Adding the settings.py Code: 00:07:00 •Creating a Django Model: 00:10:00 •Adding the admin.py Code: 00:21:00 •Creating Template Files: 00:10:00 •Creating Django Views: 00:10:00 •Creating URL Patterns for the REST API: 00:09:00 •Adding the index.html code: 00:04:00 •Adding the layout.html code: 00:19:00 •Creating our First Map: 00:10:00 •Adding Markers: 00:16:00 •Installing Jupyter Notebook: 00:07:00 •Data Pre-processing: 00:31:00 •Model Selection: 00:20:00 •Model Evaluation and Building a Prediction Dataset: 00:11:00 •Creating a Django Model: 00:04:00 •Embedding the Machine Learning Pipeline in the Application: 00:42:00 •Creating a URL Endpoint for our Prediction Dataset: 00:06:00 •Creating Multiple Basemaps: 00:09:00 •Creating the Marker Layer Group: 00:10:00 •Creating the Point Layer Group: 00:12:00 •Creating the Predicted Point Layer Group: 00:07:00 •Creating the Predicted High Risk Point Layer Group: 00:12:00 •Creating the Legend: 00:09:00 •Creating the Prediction Score Legend: 00:15:00 •Resource: 00:00:00 •Assignment - Machine Learning for Predictive Maps in Python and Leaflet: 00:00:00

Sale Ends Today JavaScript Application Programming - CPD Certified Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Till date, JavaScript remains the backbone of interactive web applications worldwide, with over 95% of all websites using it in some form. In the rapidly evolving digital landscape, mastering JavaScript is more than a skill, rather, it's a necessity. The JavaScript Application Programming bundle is designed to transform you from a novice to a master developer, and elevate your programming skills to set the web on fire. The JavaScript Application Programming bundle provides a comprehensive exploration into JavaScript and its powerful ecosystem. Starting with JavaScript Foundations for Everyone, the course progressively covers advanced topics such as JavaScript Functions and JavaScript Promises, ensuring a deep understanding of core concepts. Additional modules like jQuery, WebGL 3D Programming, and Web GIS Application Development with ASP.NET CORE MVC expand your skillset into creating dynamic, data-driven web applications along with courses in other essential languages such as Python, C#, and SQL. Courses Are Included In This JavaScript Application Programming - CPD Certified Bundle: Course 01: JavaScript Foundations for Everyone Course 02: JavaScript Functions Course 03: JavaScript Promises Course 04: jQuery: JavaScript and AJAX Coding Bible Course 05: Java Certification Cryptography Architecture Course 06: Master JavaScript with Data Visualisation Course 07: Coding Essentials - Javascript, ASP. Net, C# - Bonus HTML Course 08: Kotlin Programming: Android Coding Bible Course 09: Secure Programming of Web Applications Course 10: Web GIS Application Development with C# ASP.NET CORE MVC and Leaflet Course 11: Mastering SQL Programming Course 12: Complete Microsoft SQL Server from Scratch: Bootcamp Course 13: Ultimate PHP & MySQL Web Development & OOP Coding Course 14: SQL for Data Science, Data Analytics and Data Visualisation Course 15: Quick Data Science Approach from Scratch Course 16: Python Programming Bible Course 17: Python Programming from Scratch with My SQL Database Course 18: Machine Learning with Python Course Course 19: HTML Web Development Crash Course Course 20: CSS Web Development Course 21: Three.js & WebGL 3D Programming Course 22: Basics of WordPress: Create Unlimited Websites Course 23: Masterclass Bootstrap 5 Course - Responsive Web Design Course 24: C++ Development: The Complete Coding Guide Course 25: C# Basics Course 26: C# Programming - Beginner to Advanced Course 27: Stripe with C# Course 28: C# Console and Windows Forms Development with LINQ & ADO.NET Course 29: Cyber Security Incident Handling and Incident Response Course 30: Computer Networks Security from Scratch to Advanced Don't miss the chance to become a versatile and highly skilled software developer with our JavaScript Application Programming course. Aim to start your own tech venture, work for a top tech company, or freelance as a developer, this course will provide you with the skills needed to succeed. Enrol today to take the first step towards a lucrative career in software development, where your ability to innovate and solve complex problems will shape the future of technology! Learning Outcomes of this Bundle: Master fundamental and advanced JavaScript programming techniques. Learn to implement interactive web features using jQuery and AJAX. Develop proficiency in data visualisation with JavaScript. Understand and apply Python, C#, and SQL in web development contexts. Create responsive and secure web applications using Bootstrap and C#. Manage and deploy sophisticated web-based GIS applications. With this JavaScript Application Programming - CPD Certified course, you will get 30 CPD Accredited PDF Certificates, a Hard Copy Certificate and our exclusive student ID card absolutely free. Why Prefer this Course? Get a Free CPD Accredited Certificate upon completion of the course Get a Free Student ID Card with this training program (£10 postal charge will be applicable for international delivery) The course is Affordable and Simple to understand Get Lifetime Access to the course materials The training program comes with 24/7 Tutor Support Start your learning journey straight away! The JavaScript Application Programming course bundle is an exceptional resource for those looking to dive deep into the world of modern web development. By mastering fundamental and advanced JavaScript programming techniques, learners will gain the ability to create dynamic and interactive web applications that are both efficient and visually appealing. This foundational knowledge is essential, as JavaScript remains a critical tool for front-end development, enabling developers to implement complex features that improve user experience and site functionality. Beyond the basics, the course introduces students to data visualisation with JavaScript, which is an increasingly important skill in the tech industry. Additionally, the inclusion of frameworks like jQuery and Bootstrap ensures that learners can streamline their coding process and design responsive layouts that adapt to different devices, a must-have in today's mobile-first world. Learners will also develop proficiency in other programming languages such as Python, C#, and SQL, which are integral to backend development and database management. Moreover, this diploma offers learners the opportunity to acquire a Recognised Qualification that is highly valued in the field of JavaScript. With this Certification, graduates are better positioned to pursue career advancement and higher responsibilities within the JavaScript setting. The skills and knowledge gained from this course will enable learners to make meaningful contributions to JavaScript related fields impacting their JavaScript experiences and long-term development. Course Curriculum Course 01: JavaScript Foundations for Everyone Module 01: About the Author Module 02: Introduction to JavaScript Module 03: Strengths and Weaknesses of JavaScript Module 04: Writing JavaScript in Chrome Module 05: JavaScript Variables Module 06: Demo of JavaScript Variables Module 07: Basic Types of JavaScript Module 08: JavaScript Boolean Module 09: JavaScript Strings Module 10: JavaScript Numbers Module 11: JavaScript Objects Module 12: Demo of JavaScript Objects Module 13: JavaScript Arrays Module 14: Demo of JavaScript Arrays Module 15: JavaScript Functions Module 16: Demo of JavaScript Functions Module 17: JavaScript Scope and Hoisting Module 18: Demo of JavaScript Scope and Hoisting Module 19: Currying Functions Module 20: Demo of Currying Functions Module 21: Timeouts and Callbacks Module 22: Demo of Timeouts and Callbacks Module 23: JavaScript Promises Module 24: Demo of JavaScript Promises Module 25: Demo of Javascript Async Module 26: Flow Control Module 27: Demo of Flow Control Module 28: JavaScript For Loop Module 29: Demo of JavaScript For Loop Module 30: Demo of Switch Statements Module 31: Error Handling Module 32: Demo Project Course 02: JavaScript Functions Module 01: Introduction Module 02: Defining And Invoking Functions Module 03: Function Scope Module 04: Composing Functions Module 05: Asynchronous Functions Course 03: JavaScript Promises Module 01: JavaScript Promises Module 02: Understanding Promises Module 03: Using Promises Module 04: Multiple Promises Module 05: Handling Errors With Promises =========>>>>> And 27 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*30 = £390) CPD Hard Copy Certificate: Free (For The First Course: Previously it was £29.99) CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Aspiring software developers. Web developers. Computer science students. Tech industry professionals. Entrepreneurs in tech. Career changers. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Web Developer: $40,000 - $85,000 Software Developer: $50,000 - $120,000 Full-Stack Developer: $60,000 - $120,000 Data Analyst: $45,000 - $85,000 Systems Engineer: $60,000 - $130,000 Cyber Security Analyst: $60,000 - $100,000 Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited e-Certificate - Free Enrolment Letter - Free Student ID Card - Free CPD Accredited Hard Copy Certificate Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

Duration 2 Days 12 CPD hours This course is intended for System Engineers/Administrators; Backup/Virtualization Administrators; Solution Architects/Consultants Overview By the end of the course, students should be able to:Maximize your expertise on consulting/professional services for the Veeam Availability Suite solutionAim for the VMCA title and comply with some of the certifications requirements for Platinum ProPartners and Veeam Accredited Service Partners (VASPs)Gain professional advantage with the highest level of Veeam technical certification This course covers Veeam Availability Suite? design and optimization and is based on best practices from Veeam solutions architects. IntroductionDesign & Sizing DNS and name resolution Veeam backup server Backup and replication database Proxy server Transport modes Repository server WAN accelerator Interaction with hypervisors Infrastructure Stages of Proof of Concept Assessment using Veeam ONE? Important data to collect (Veeam ONE + infrastructure accounts) Security Permissions Design Scenario: Part 1 Discovery Create a design based on the customer environment Optimizations Backup and replication database Proxy server Repository server WAN accelerator Tape Veeam Backup Enterprise Manager Indexing Antivirus on Veeam servers and guest VM (if VSS is used) Protecting Veeam Backup & Replication? configuration Design Scenario: Part 2 Create a design based on the customer?s evolving environment Automation Veeam backup server VMware vSphere tags Audit & Compliance Auditing Compliance SureBackup© and SureReplica Troubleshooting Deep dive into reading log files Common issues Troubleshooting mode (SureBackup/SureReplica)

Duration 2 Days 12 CPD hours This course is intended for This course is designed for security experts and Check Point resellers who desire to obtain the necessary knowledge required to perform more advanced troubleshooting skills while managing their security environments. Overview Understand how to use Check Point diagnostic tools to determine the status of a network. Understand how to use network packet analyzers and packet capturing tools to evaluate network traffic.Become familiar with more advanced Linux system commands. Obtain a deeper knowledge of the Security Management architecture. Understand how the Management database is structured and how objects are represented in the database. Understand key Security Management Server processes and their debugs. Understand how GuiDBedit operates. Understand how the kernel handles traffic and how to troubleshoot issues with chain modules. Understand how to use the two main procedures for debugging the Firewall kernel and how they differ. Recognize User mode processes and how to interpret their debugs. Discuss how to enable and use core dumps. Understand the processes and components used for policy installs and processing packets in Access Control policies. Understand how to troubleshoot and debug issues that may occur with App Control and URLF. Understand how to debug HTTPS Inspection-related issues. Understand how to troubleshoot and debug Content Awareness issues. Understand how IPS works and how to manage performance issues. Understand how to troubleshoot Anti-Bot and Antivirus. Recognize how to troubleshoot and debug Site-to-Site VPN related issues. Understand how to troubleshoot and debug Remote Access VPNs. Understand how troubleshoot Mobile Access VPN issues. Recognize how to use SecureXL features and commands to enable and disable accelerated traffic. Understand how the server hardware and operating system affects the performance of Security Gateways. Understand how to evaluate hardware configurations for optimal performance. Provide advanced troubleshooting skills to investigate and resolve more complex issues that may occur while managing your Check Point Security environment. Course Outline Advanced Troubleshooting Management Database and Processes Advanced Kernel Debugging User Mode Troubleshooting Advanced Access Control Understanding Threat Prevention Advanced VPN Troubleshooting Acceleration and Performance Tuning Additional course details: Nexus Humans CCTE Check Point Troubleshooting Expert 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 CCTE Check Point Troubleshooting Expert 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.

Deal with large numbers and key information in this Big Data Course Are interested in understanding and protecting big data? Do you want to utilize any data that have been presented to you to its full extent? This Innovative Course will solve all of your problems! Big data is a term that describes the large volume of data - both structured and unstructured - that inundates a business on a day-to-day basis. Interpreting data is of immense importance when you handle data. Only then you can fully use it to your business. At the same time when you use data online, there is always a chance that your data can be stolen. Learn how to protect your information in this data bundle course. Make your own database and reap its benefits. Since there are people who do not like to deal with database, scripts and all the technical parts, this hinders them to start learning because they already have the mindset that it is difficult. Understanding Big Data course will give you a clear perception on how to deal with large data and ways you can easily handle them. This course has multiple units designed to help your data managing skills. Course Highlights Understanding Big Data is an award winning and the best selling course that has been given the CPD Certification & CiQ accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Understanding Big Data into 6 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 6 hours hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Understanding Big Data 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? Understanding Big Data is CPD certified and CiQ 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 Understanding Big Data 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 CiQ accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Understanding Big Data What Is Big Data? Hint: You're a Part of It Every Day FREE 01:00:00 Why Is Big Data Important? FREE 01:00:00 Why IBM for Big Data? 01:00:00 All About Hadoop: The Big Data Lingo Chapter 01:00:00 InfoSphere BigInsights: Analytics for Big Data at Rest 01:00:00 IBM InfoSphere Streams: Analytics for Big Data in Motion 01:00:00 Mock Exam Final Exam

Description: This course follows up from the Beginners Excel 2010 course by delving even deeper into features and functions of this powerful spreadsheet software. This Microsoft Office 2010 Excel Advanced - Complete Video Course builds on the skills and concepts taught in Excel 2010: intermediate. In this series you will learn to work with advanced formulas, as well lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, you will learn about data validation and database functions such as DSUM. You will learn how to work with Pivot Tables and PivotCharts, how to import and export data, and how to query external databases. Finally, you will learn about the analytical features of Excel, running and recording macros, SmartArt graphics and conditional formatting with graphics, and more. Before you taking this course you should have a firm grasp of the basics. This course will pull up your basic knowledge. So join this course to be an expert. 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 2010 Excel Advanced - Complete Video 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 Office 2010 Excel Advanced - Complete Video 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. Logical and Statistical Functions Logical Functions FREE 00:17:00 Math and Statistical Functions 00:19:00 Financial and Date Functions Financial Functions 00:04:00 Date and Time Functions 00:10:00 Array Formulas 00:09:00 Displaying and Printing Formulas 00:08:00 Lookups and Data Tables Using Lookup Functions 00:14:00 Using MATCH and INDEX 00:06:00 Array Formulas 00:07:00 Advanced Data Management Validating Cell Entries 00:08:00 Exploring Database Functions 00:06:00 Exporting and Importing Exporting and Importing Text Files 00:11:00 Exporting and Importing XML Data 00:03:00 Querying External Databases 2 hours agoMore 00:09:00 Analytical Tools Goal Seek and Solver 00:15:00 The Analysis ToolPak 00:05:00 Scenarios 1 hour agoMore 00:06:00 Macros and Custom Functions Running and Recording a Macro 00:19:00 Working with VBA Code 00:07:00 Creating Functions 00:05:00 Mock Exam Mock Exam- Microsoft Office 2010 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010 Excel Advanced - Complete Video Course 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00