1637 Database courses delivered Online

Learn the basics and the advanced concepts of Tableau to create stunning and detailed visualizations. This course provides step-by-step guidance on how we can make data easier to understand and easier to interpret by using visualizations. We'll be working with Tableau 2020.3.

Turn yourself into the linchpin of highly organised data and a facilitator of streamlined processes. Learn about Using Excel's Flash Fill and Autofill to Automate Data Entry.

Duration 1 Days 6 CPD hours This course is intended for This course is intended for the following participants: Individuals planning to deploy applications and create application environments on Google Cloud Platform Developers, systems operations professionals, and solution architects getting started with Google Cloud Platform Executives and business decision makers evaluating the potential of Google Cloud Platform to address their business needs. Overview This course teaches participants the following skills: Identify Google Cloud counterparts for Azure IaaS, Azure PaaS, Azure SQL, Azure Blob Storage, Azure Application Insights, and Azure Data Lake Configure accounts, billing, projects, networks, subnets, firewalls, VMs, disks, auto scaling, load balancing,storage, databases, IAM, and more Manage and monitor applications Explain feature and pricing model differences This 1-day instructor led course introduces Azure professionals to the core capabilities of Google Cloud in the four technology pillars: networking, compute, storage, and database. It is designed for Azure system administrators, Solution Architects and SysOps Administrators familiar with Azure features and setup; and want to gain experience configuring Google Cloud products immediately. With presentations, demos, and hands-on labs, participants get details of similarities, differences, and initial how-tos quickly. Introducing Google Cloud Explain the advantages of Google Cloud. Define the components of Google's network infrastructure, including: Points of presence, data centers, regions, and zones. Understand the difference between Infrastructure-as-a-Service (IaaS) and Platform-as-a-Service (PaaS). Getting Started with Google Cloud Identify the purpose of projects on Google Cloud. Understand how Azure's resource hierarchy differs from Google Cloud's Understand the purpose of and use cases for Identity and Access Management. Understand how Azure AD differs from Google Cloud IAM. List the methods of interacting with Google Cloud. Launch a solution using Cloud Marketplace. Virtual Machines in the Cloud Identify the purpose and use cases for Google Compute Engine Understand the basics of networking in Google Cloud. Understand how Azure VPC differs from Google VPC. Understand the similarities and differences between Azure VM and Google Compute Engine. Understand how typical approaches to load-balancing in Google Cloud differ from those in Azure. Deploy applications using Google Compute Engine Storage in the Cloud Understand the purpose of and use cases for: Cloud Storage, Cloud SQL, Cloud Bigtable and Cloud Datastore. Understand how Azure Blob compares to Cloud Storage. Compare Google Cloud?s managed database services with Azure SQL. Learn how to choose among the various storage options on Google Cloud. Load data from Cloud Storage into BigQuery Containers in the Cloud Define the concept of a container and identify uses for containers. Identify the purpose of and use cases for Google Container Engine and Kubernetes. Understand how Azure Kubernetes Service differs from from Google Kubernetes Engine. Provision a Kubernetes cluster using Kubernetes Engine. Deploy and manage Docker containers using kubectl Applications in the Cloud Understand the purpose of and use cases for Google App Engine. Contrast the App Engine Standard environment with the App Engine Flexible environment. Understand how App Engine differs from Azure App Service. Understand the purpose of and use cases for Google Cloud Endpoints. Developing, Deploying and Monitoring in the Cloud Understand options for software developers to host their source code. Understand the purpose of template-based creation and management of resources. Understand how Google Cloud Deployment Manager differs from Azure Resource Manager. Understand the purpose of integrated monitoring, alerting, and debugging Understand how Google Monitoring differs from Azure Application Insights and Azure Log Analytics. Create a Deployment Manager deployment. Update a Deployment Manager deployment. View the load on a VM instance using Google Monitoring. Big Data and Machine Learning in the Cloud Understand the purpose of and use cases for the products and services in the Google Cloud big data and machine learning platforms. Understand how Google Cloud BigQuery differs from Azure Data Lake. Understand how Google Cloud Pub/Sub differs from Azure Event Hubs and Service Bus. Understand how Google Cloud?s machine-learning APIs differ from Azure's. Load data into BigQuery from Cloud Storage. Perform queries using BigQuery to gain insight into data Summary and Review Review the products that make up Google Cloud and remember how to choose among them Understand next steps for training and certification Understand, at a high level, the process of migrating from Azure to Google Cloud.

Get ready for an exceptional online learning experience with the Data Analysis, Data Science, Data Protection, Business Analysis, Python & Excel bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The Data Analysis & Data Protectionl is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, theData Analysis & Data Protection package has something for everyone. As part of the Data Analysis, Data Science, Data Protection, Business Analysis, Python & Excel package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Data Analysis & Data Protection bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Bundle Comprises the Following Data Analysis, Data Science, Data Protection, Business Analysis, Python & Excel CPD-accredited courses: Course 01: Data Analytics Course 02: Diploma in Data Analytics with Tableau Course 03: Google Data Studio: Data Analytics Course 04: Business Intelligence Analyst Course 05: Diploma in Business Analysis Course 06: Data Science & Machine Learning with Python Course 07: Spatial Data Visualization and Machine Learning in Python Course 08: Python Programming: Beginner To Expert Course 09: SQL For Data Analytics & Database Development Course 10: Easy to Advanced Data Structures Course 11: R Programming for Data Science Course 12: Data Center Training Essentials: General Introduction Course 13: Data Analysis In Excel Course 14: Data Protection Course 15: Microsoft Excel Complete Course Course 16: Career Development Plan Fundamentals Course 17: CV Writing and Job Searching Course 18: Learn to Level Up Your Leadership Course 19: Networking Skills for Personal Success Course 20: Ace Your Presentations: Public Speaking Masterclass What will make you stand out? Upon completion of this online Data Analysis, Data Science, Data Protection, Business Analysis, Python & Excel bundle, you will gain the following: CPD QS Accredited Proficiency with this Data Analysis & Data Protection bundle After successfully completing the Data Analysis & Data Protection bundle, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this Data Analysis & Data Protection bundle The online test with immediate results You can study and complete the Data Analysis & Data Protection bundle at your own pace. Study for the Data Analysis & Data Protection bundle using any internet-connected device, such as a computer, tablet, or mobile device. Each course in this Data Analysis, Data Science, Data Protection, Business Analysis, Python & Excel bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This Data Analysis & Data Protection bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with Data Analysis, Data Science, Data Protection, Business Analysis, Python & Excel, a rich anthology of 30 diverse courses. Our experts handpick each course in the Data Analysis & Data Protection bundle to ensure a wide spectrum of learning opportunities. This Data Analysis & Data Protection bundle will take you on a unique and enriching educational journey. The Data Analysis, Data Science, Data Protection, Business Analysis, Python & Excel bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Data Analysis & Data Protection bundle offers you the flexibility and convenience to learn at your own pace. Make the Data Analysis & Data Protection package your trusted companion in your lifelong learning journey. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Data Analysis, Data Science, Data Protection, Business Analysis, Python & Excel bundle is perfect for: Start Your Data Journey: Ideal for those new to data analysis or looking to enhance their skills. Data-Driven Business: Perfect for business professionals who want to leverage data for better decisions. Aspiring Data Scientist: Excellent for those eager to learn advanced data science techniques. Data Compliance Expertise: Great for privacy and compliance officers needing data protection knowledge. Lifelong Data Learner: Beneficial for individuals who want to combine Python and Excel for data analysis. Requirements You are warmly invited to register for this Data Analysis, Data Science, Data Protection, Business Analysis, Python & Excel bundle. Please be aware that no formal entry requirements or qualifications are necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Upon Data Analysis, Data Science, Data Protection, Business Analysis, Python & Excel course completion, you can expect to: Data Analyst Data Scientist Business Analyst Data Protection Officer Data Engineer Machine Learning Engineer Data Consultant Operations Analyst Marketing Analyst Project Manager Certificates 20 CPD Quality Standard Pdf Certificates Digital certificate - Included

Get ready for an exceptional online learning experience with the Coding (C++, Python, JavaScript, Networking & IT) bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The Coding, C++ & Python package is dynamic, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Coding, C++ & Python package has something for everyone. As part of the Coding, C++ & Python, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Coding (C++, Python, JavaScript, Networking & IT) bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Bundle Comprises the Following Coding (C++, Python, JavaScript, Networking & IT) CPD-accredited courses: Course 01: Introduction to Coding With HTML, CSS, & Javascript Course 02: C++ Development: The Complete Coding Guide Course 03: C# Programming - Beginner to Advanced Course 04: Python Programming: Beginner To Expert Course 05: The Complete MySQL Server from Scratch: Bootcamp Course 06: Kotlin Programming: Android Coding Bible Course 07: Learn Web Development from Scratch Course 08: The Complete Front-End Web Development Course! Course 09: Secure Programming of Web Applications Course 10: JavaScript Project - Game Development with JS Course 11: Bash Scripting, Linux and Shell Programming Course 12: Advanced Diploma in PHP Web Development with MySQL, GitHub & Heroku Course 13: Data Analysis Course 14: R Programming for Data Science Course 15: Learn Ethical Hacking From A-Z: Beginner To Expert Course 16: Cyber Security Awareness Training Course 17: Cloud Computing / CompTIA Cloud+ (CV0-002) Course 18: CompTIA A+ (220-1001) Course 19: Computer Networks Security from Scratch to Advanced Course 20: Microsoft Excel Complete Course What will make you stand out? Upon completion of this online Coding (C++, Python, JavaScript, Networking & IT) bundle, you will gain the following: CPD QS Accredited Proficiency with this Coding, C++ & Python bundle After successfully completing the Coding, C++ & Python bundle, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials in this Coding, C++ & Python bundle The online test with immediate results You can study and complete the Coding, C++ & Python bundle at your own pace. Study for the Coding, C++ & Python bundle using any internet-connected device, such as a computer, tablet, or mobile device. Each course in this Coding (C++, Python, JavaScript, Networking & IT) bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This Coding, C++ & Python bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with Coding (C++, Python, JavaScript, Networking & IT), a rich anthology of 30 diverse courses. Our experts handpick each course in the Coding, C++ & Python bundle to ensure a wide spectrum of learning opportunities. This Coding, C++ & Python bundle will take you on a unique and enriching educational journey. The Coding (C++, Python, JavaScript, Networking & IT) bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Coding, C++ & Python bundle offers you the flexibility and convenience to learn at your own pace. Make the Coding, C++ & Python package your trusted companion in your lifelong learning journey. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Coding (C++, Python, JavaScript, Networking & IT) bundle is perfect for: Aspiring Programmers: Individuals interested in learning to program and develop software using popular languages like C++, Python, and JavaScript. IT Professionals: Those working in IT who wish to enhance their programming and networking skills to improve job performance and career prospects. Students in Technology: University or college students pursuing degrees in computer science, information technology, or related fields looking to supplement their studies with practical skills. Career Changers: Professionals aiming to transition into the tech industry and seeking foundational knowledge in programming and network management. Hobbyists and Tech Enthusiasts: Individuals passionate about technology and keen on developing their own projects or improving their understanding of how different aspects of the internet and software work. Requirements You are warmly invited to register for this Coding (C++, Python, JavaScript, Networking & IT) bundle. Please be aware that no formal entry requirements or qualifications are necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Upon Coding (C++, Python, JavaScript, Networking & IT) course completion, you can expect to: Software Developer Web Developer Systems Programmer Network Administrator Database Administrator Cybersecurity Analyst Data Scientist AI and Machine Learning Engineer Freelance Programmer Tech Entrepreneur Certificates CPD Certificates Digital certificate - Included

Explore everything that Vue.js has to offer from the ground up, all while building 4 projects to put your knowledge into practice. You will learn all of the essential Vue skills, along with the new Vue.js 3 features and syntax.

Ignite your dynamic career and strengthen your deep insight knowledge by signing up for Business Intelligence Analysis Course. This course is the ideal approach for you to obtain a thorough understanding and knowledge of the subject. We are concerned about the progression of your career. Therefore, after conducting extensive studies and consulting with experienced personnel, we formulated this outstanding Business Intelligence Analysis Course to improve your pertinent skills. In this easy-to-digest course, you will get exclusive training, which will enable you to stand out in this competitive market. However, the course covers all of the recent materials in order to keep you up to date with the job market and make you a good fit for your career. This top-notch Business Intelligence Analysis Course curriculum comprises basic to advanced levels of modules that will increase your skill sets. After completing this programme, you will attain the productivity to succeed in your organisation. So, if you are eager to see yourself in a gratifying career, then enrol in the course today! What will Make You Stand Out? On completion of this Business Intelligence Analysis Course online course, you will gain: CPD QS Accredited course After successfully completing the Course, you will receive a FREE PDF Certificate as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials. Enroling in the Course has no additional cost. 24x7 Tutor Support You can study and complete the course at your own pace. Course Curriculum : Business Intelligence Analysis Course Module 01: An Introduction to Business Intelligence Module 02: Real-time Business Intelligence Module 03: Fundamentals of Statistics and Data Science Module 04: Fundamentals of SQL Module 05: Database Management Essentials Module 06: Data Warehouse Concepts Module 07: Data Visualisation in Business Intelligence Module 08: Basics of Python Show off your new skills with a certificate of completion. After successfully completing the course, you can order your CPD Accredited Certificates as proof of your achievement absolutely free. Please Note: The delivery charge inside the U.K. is £4.99, and international students have to pay £8.99. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Course the Right Option for You? This Business Intelligence Analysis Course is open to everybody. You can access the course materials from any location in the world and there are no requirements for enrolment. Requirements Without any formal requirements, you can delightfully enrol in this Business Intelligence Analysis Course. Just get a device with internet connectivity and you are ready to start your learning journey. Thus, complete this course at your own pace. Career path The aim of this exclusive Business Intelligence Analysis Course is to help you toward your dream career. So, complete this course and enhance your skills to explore opportunities in relevant areas.

Feeling Stuck in Your Career? The C++, Javascript, HTML, Web Development, Web Design & SQL Training - 30 Courses Bundle is Your Skill-Building Solution. This exceptional collection of 30 premium courses is designed to encourage growth and improve your career opportunities. Suited to meet different interests and goals, the SQL Training: Web Development & Web Design bundle provides an engaging learning experience, helping you learn skills across various disciplines. With the C++, Javascript, HTML, Web Development, Web Design & SQL Training - 30 Courses Bundle, you'll have a personalised journey that aligns with your career goals and interests. This comprehensive package helps you confidently tackle new challenges, whether entering a new field or enhancing your existing knowledge. The SQL Training: Web Development & Web Design bundle is your gateway to expanding your career options, increasing job demand, and enhancing your skill set. By enrolling in this bundle, you'll receive complimentary PDF certificates for all courses, adding value to your resume at no extra cost. Develop key skills and achieve important progress in your career and personal development. Start your journey today and experience the transformative impact of the SQL Training: Web Development & Web Design bundle on your job life and career growth! This C++, Javascript, HTML, Web Development, Web Design & SQL Training - 30 Courses Bundle Comprises the Following CPD Accredited Courses: Course 01: C++ Programming for Absolute Beginners Course 02: Computer Vision By Using C++ and OpenCV with GPU support Course 03: Basic C# Coding Course 04: Refactor Javascript Course 05: Basic Asynchronous JavaScript Course 06: Javascript for Data Structures Course 07: Basic HTML 5 Course 08: HTML Web Development Crash Course Course 09: Microsoft SQL Server Development for Everyone Course 10: Learn to Build Complete CMS Blog in PHP MySQL Bootstrap & PDO Course 11: PHP and MySQL Training 2022: Build 5 Real World Projects Course 12: PHP for Beginners 2023 Guide: Develop an ECommerce Store Course 13: PHP and MySQL Training Masterclass 2023 Course 14: Easy to Advanced Data Structures Course 15: jQuery: JavaScript and AJAX Coding Bible Course 16: AutoCAD Programming using C# with Windows Forms Course 17: C# Console and Windows Forms Development with LINQ & ADO.NET Course 18: Programming AutoCAD with SQL Server Database Using C# Course 19: Web GIS Application Development with C# ASP.NET CORE MVC and Leaflet Course 20: Creative Web Design with HTML5, CSS3 and Bootstrap Course 21: Beginners Course on ESP32 and IoT Course 22: Learn DOM Manipulation with JavaScript Course 23: Ultimate PHP & MySQL Web Development & OOP Coding Course 24: Internet of Things Course 25: Excel Add-in with C# VSTO and Web Course 26: Career Development Plan Fundamentals Course 27: CV Writing and Job Searching Course 28: Learn to Level Up Your Leadership Course 29: Networking Skills for Personal Success Course 30: Ace Your Presentations: Public Speaking Masterclass What will make you stand out? Upon completion of this online C++, Javascript, HTML, Web Development, Web Design & SQL Training - 30 Courses Bundle, you will gain the following: CPD QS Accredited Proficiency with this SQL Training: Web Development & Web Design Bundle After successfully completing the SQL Training: Web Development & Web Design bundle, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this SQL Training: Web Development & Web Design Bundle The online test with immediate results You can study and complete the SQL Training: Web Development & Web Design bundle at your own pace. Study for the SQL Training: Web Development & Web Design bundle using any internet-connected device, such as a computer, tablet, or mobile device. The C++, Javascript, HTML, Web Development, Web Design & SQL Training - 30 Courses bundle is a premier learning resource, with each course module holding respected CPD accreditation, symbolising exceptional quality. The content is packed with knowledge and is regularly updated to ensure it remains relevant. This bundle offers not just education but a constantly improving learning experience designed to enrich both your personal and professional development. Advance the future of learning with the SQL Training: Web Development & Web Design bundle, a comprehensive, complete collection of 30 courses. Each course in the SQL Training: Web Development & Web Design bundle has been handpicked by our experts to provide a broad range of learning opportunities. Together, these modules form an important and well-rounded learning experience. Our mission is to deliver high-quality, accessible education for everyone. Whether you are starting your career, switching industries, or enhancing your professional skills, the SQL Training: Web Development & Web Design bundle offers the flexibility and convenience to learn at your own pace. Make the SQL Training: Web Development & Web Design package your trusted partner in your lifelong learning journey. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The C++, Javascript, HTML, Web Development, Web Design & SQL Training - 30 Courses bundle is perfect for: Expand your knowledge and skillset for a fulfilling career with the SQL Training: Web Development & Web Design bundle. Become a more valuable professional by earning CPD certification and mastering in-demand skills with the SQL Training: Web Development & Web Design bundle. Discover your passion or explore new career options with the diverse learning opportunities in the SQL Training: Web Development & Web Design bundle. Learn on your schedule, in the comfort of your home - the SQL Training: Web Development & Web Design bundle offers ultimate flexibility for busy individuals. Requirements You are warmly invited to register for this bundle. Please be aware that no formal entry requirements or qualifications are necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Gain a wide range of skills across various fields, improve your problem-solving capabilities, and keep current with industry trends. Perfect for those aiming for career advancement, exploring a new professional direction, or pursuing personal growth. Begin your journey with the C++, Javascript, HTML, Web Development, Web Design & SQL Training - 30 Courses bundle. Certificates CPD Certificate Digital certificate - Included

Personalized Revit Training: One-to-One Sessions with Pay-as-You-Go Flexibility

Highlights of the Course Course Type: Online Learning Duration: 2 Hours 26 Minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about Fusion 360 graphic designing Understand the core competencies and principles of Fusion 360 graphic designing Explore the various areas of Fusion 360 graphic designing Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert graphic designer Microsoft Office Excel 2016: Part 2 (Intermediate Level) Course Master the skills you need to propel your career forward in Microsoft Office Excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive excel 2016 intermediate level course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this excel 2016 intermediate leve course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft Office Excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft Office Excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft Office Excel. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft Office Excel. Enrol in this excel 2016 intermediate leve course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive excel 2016 intermediate leve course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Office Excel can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This excel 2016 intermediate leve course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This excel 2016 intermediate leve course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This excel 2016 intermediate leve course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation 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. Course Curriculum Course Overview Introduction and Course Overview 00:02:00 Working with Functions Working and Function - Introduction 00:01:00 Work with Ranges - Introduction 00:01:00 Name and Edit Ranges 00:05:00 Use Defined Names in a Formula 00:03:00 Locate and Use Specialized Functions 00:05:00 Work with Logical Functions - Introduction (02:13) 00:02:00 IF Function 00:04:00 AND, OR and NOT Function 00:05:00 Combine Functions 00:06:00 Functions Similar to the IF Function 00:05:00 Work with Date and Time Functions - Introduction 00:01:00 TODAY, NOW and DATE Functions 00:03:00 NETWORKDAY, WEEKDAY, WORKDAY and ISOWeeknum Functions 00:05:00 Work with Text Functions - Introduction 00:01:00 LEFT, RIGHT and MID Functions 00:02:00 FIND Function 00:03:00 Text to Columns Feature 00:03:00 CONCATENATE Function 00:03:00 UPPER, LOWER and PROPER Functions 00:02:00 Practice File Working with Functions Practice File Working with Functions 00:00:00 Working with Lists Sort Data - Introduction 00:01:00 Sort Data 00:03:00 Filter Data - Introduction 00:01:00 Filter Data 00:02:00 Query Data with Database Functions 00:01:00 Database Functions 00:03:00 Outline and Subtotal Data - Introduction 00:01:00 Use Subtotals to Summarize Data 00:03:00 Practice File Working with Lists Practice File Working with Lists 00:00:00 Assessment Mock 1 Assessment Mock 1 - Microsoft Office Excel 2016: Part 2 (Intermediate Level) 00:10:00 Analyzing Data Create and Modify Tables - Introduction 00:01:00 Create and Modify Tables 00:06:00 Use Summary Functions in Tables 00:03:00 Apply Intermediate Conditional Formatting - Introduction 00:01:00 Apply Intermediate Conditional Formatting 00:02:00 Apply Advanced Conditional Formatting - Introduction 00:01:00 Use Logical Functions to Apply Conditional Formatting 00:03:00 Practice File Analyzing Data Practice File Analyzing Data 00:00:00 Visualizing Data with Charts Create Charts - Introductions 00:01:00 Create Charts 00:04:00 Modify and Format Charts - Introduction 00:01:00 Modify and Format Charts 00:05:00 Use Advanced Chart Features - Introduction 00:01:00 Create a Dual-Axis Chart 00:04:00 Create a Chart Template 00:03:00 Visualizing Data with Charts - Best Practice 00:04:00 Practice File Visualizing Data with Charts Practice File Visualizing Data with Charts 00:00:00 Using PivotTables and PivotCharts Create a PivotTable - Introductions 00:01:00 Create a PivotTable 00:04:00 Analyze PivotTable Data - Introduction 00:01:00 Analyze PivotTable Data 00:04:00 Present Data with PivotCharts - Introduction 00:01:00 Present Data with PivotCharts 00:05:00 Filter Data by Using Timelines and Slicers - Introduction 00:01:00 Filter Data by Using Slicers and Timelines 00:04:00 Bonus Lecture 00:01:00 Practice File Using PivotTables and PivotCharts Practice File Using PivotTables and PivotCharts 00:00:00 Assessment Mock 2 Assessment Mock 2 - Microsoft Office Excel 2016: Part 2 (Intermediate Level) 00:10:00 Final Assessment Final Assessment - Microsoft Office Excel 2016: Part 2 (Intermediate Level) 00:10:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00