3938 Office Skills courses

Description Microsoft Azure is an open, flexible, enterprise-grade cloud computing service created by Microsoft for building, testing, deploying, and managing applications and services. Azure Active Directory is one of the excellent services among other Microsoft Azure service. Azure Active Directory is a cloud-based directory that combines core directory services, application access management, and identity protection into a single solution. It also allows the developers to deliver access control to their applications, based on centralized policy and rules. In the course, you will learn how to apply the above mention services provided by Azure Active Directory for your organization. A discussion will be focused on the user interface, access system of Azure Active Directory together with the Hybrid Active Directory of Azure. You will know the techniques of extending and deploying AD to the cloud, preparing for synchronization, installing Azure AD Connect, and managing directory synchronization. Finally, the course helps you to understand Azure AD Federation and guides you how to convert a domain to Federated. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? MS Azure - Azure Active Directory 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 MS Azure - Azure Active Directory 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. Introduction Introduction FREE 00:04:00 Azure Active Directory Directory Service Options 00:03:00 Custom Domains 00:05:00 Managing Users and Groups in the Portal 00:04:00 Managing Users and Groups in the Powershell 00:07:00 Multi-Factor Authentication 00:08:00 Multiple Directories 00:04:00 Application Access 00:02:00 Adding and Accessing Applications 00:06:00 Azure AD Versions 00:03:00 Hybrid Azure AD Hybrid Active Directory 00:03:00 Deploying DC to Azure 00:04:00 Directory Synchronization Pre Reqs 00:05:00 Installing and Configuring Azure AD Connect 00:13:00 Modifying Directory Sync 00:05:00 Active Directory Federation Services Understanding Identity Federation 00:02:00 ADFS Authentication with Online Services 00:03:00 ADFS Pre-reqs 00:03:00 Installing ADFS 00:04:00 Installing ADFS Proxy 00:06:00 Converting Domains to Federated 00:05:00 Pass-through Authentication Pass-through Authentication 00:02:00 Seamless Single Sign-on 00:01:00 Configuring Pass-Through 00:04:00 Conclusion Course Recap 00:06:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview Learn about the functions of Microsoft Azure from this AZ-900 | Microsoft Azure Fundamentals Full Course course. The course will give you a clear understanding of the basics of Microsoft Azure and how you can use this cloud platform to grow and strengthen your online existence. In this AZ-900 | Microsoft Azure Fundamentals Full Course course, you will learn about the tools and basic functions of Microsoft Azure. You will be familiarized with the core Azure services, security, privacy and compliance policies. This course will teach you how you can secure your website and account using multi-factor authentication and protect data from hackers. This course will also help you to understand the supports Azure can offer you and get the best suitable one for you. Microsoft Azure is one of the most popular and safe cloud platforms. This AZ-900 | Microsoft Azure Fundamentals Full Course course will teach you the functions of Microsoft Azure from scratch. You don't need any prior knowledge or technical background to understand the lessons of this course. Learning Outcomes familiarize with the fundamentals of cloud services Understand the benefits of using cloud services Learn about the differences between capital expenditure and operational expenditure Be able to compare and contrast the IAAS, PAAS and SAAS service Learn about different cloud models and how they work Understand the core Azure architectural components Learn about the solutions you will get from Azure Learn about the management tools of Azure Get to know about the security and private privacy protocols of Microsoft Azure Understand how Azure identity services work Familiarize with role-based access control system Understand the policies and compliance standards in Azure Who is this course for? This comprehensive AZ-900 | Microsoft Azure Fundamentals Full Course is ideal for those who want to learn more about the functions of Microsoft Azure. You will learn about the application of Microsoft Azure and the career prospect from this course. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path AZ-900 | Microsoft Azure Fundamentals Full Course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Managers Managing Directors Management Executives Data Security Officers Programmers Microsoft Azure Developers Technicians Computer Operators Cloud Engineers Cloud Data Consultants Azure Consultants Data Scientists Course Introduction Introduction 00:04:00 Module 1 : Cloud Concepts What is Cloud Computing - I 00:05:00 What is Cloud Computing - II 00:06:00 Benefits of Cloud Computing 00:09:00 Key Concepts and Terminology 00:06:00 Economies of Scale 00:01:00 CapEx Vs OpEx 00:03:00 Cloud Models : What is Public Cloud 00:02:00 Cloud Models : Characteristics of Public Cloud 00:02:00 Cloud Models : What is Private Cloud 00:01:00 Cloud Models : Characteristics of Private Cloud 00:01:00 Cloud Models : Hybrid Cloud 00:01:00 Cloud Models : Characteristics of Hybrid Cloud 00:01:00 Review and What Next!! 00:01:00 What is IAAS 00:04:00 Use Cases of IAAS 00:02:00 What is PAAS ? 00:02:00 Use Cases of PAAS 00:04:00 What is SAAS ? 00:02:00 Cloud Models : Shared Responsibility Model 00:09:00 Module 2 : Core Azure Services Introduction 00:01:00 Azure Regions 00:01:00 Special Azure regions 00:01:00 Region pairs 00:01:00 Feature Availability Region Wise 00:01:00 Availability Zones 00:01:00 Availability Sets 00:02:00 What are Resource Groups? 00:02:00 Azure Resource Manager 00:01:00 What Next!! - Azure Core Services and Products 00:02:00 What is Azure Compute 00:01:00 Azure Virtual Machines - Audiocast Only 00:01:00 Azure Virtual Machines I - LAB 00:15:00 Azure Virtual Machines II - LAB 00:01:00 Azure Virtual Machines III - LAB 00:02:00 Azure Virtual Machines IV - LAB 00:04:00 Azure Virtual Machines V - LAB 00:03:00 Azure Virtual Machines VI - LAB 00:03:00 What are Containers? 00:04:00 Containers ( LAB Activity ) 00:07:00 Containers VS Virtual Machines 00:04:00 What Are Virtual Networks 00:01:00 Virtual Networks - LAB 00:15:00 Azure Load Balancer 00:01:00 VPN Gateway 00:01:00 Azure Application Gateway - I 00:02:00 Azure Application Gateway - II 00:01:00 Azure Content Delivery Networks (CDN's) 00:02:00 How CDN works ? 00:03:00 Azure CDN - Lab Activity 00:07:00 Azure Storage Services 00:01:00 Structured Data 00:01:00 Semi Structured Data 00:01:00 Unstructured Data 00:01:00 Azure Storage Account - Types 00:03:00 Azure Storage Account - Blob - Lab Activity - I 00:07:00 Azure Storage Account - Blog - Lab Activity - II 00:07:00 Azure Storage Account - Blob - Lab Activity - III 00:16:00 Azure Storage Account - Blog - Lab Activity - IV 00:09:00 Azure Storage Account - Blob - Lab Activity - V 00:04:00 Azure Storage Account - Blob - Lab Activity - VI 00:07:00 Azure Database Services 00:02:00 Azure SQL - Lab Demo 00:09:00 Azure MarketPlace 00:02:00 What is Internet of Things ( IOT ) - Intro 00:01:00 IOT Hub 00:01:00 IOT Hub Demo 00:09:00 Azure Big Data and Analytics 00:01:00 Azure SQL Data Warehouse 00:01:00 Azure HDInsights 00:01:00 Azure Data Lake Analytics 00:01:00 Machine Learning 00:02:00 Azure Machine Learning Services and Studio 00:02:00 What is Server less Computing ? 00:02:00 The concept of DevOps 00:03:00 Azure Management Tools 00:01:00 Creating Resources with Powershell - Lab Activity 00:05:00 Creating Resources with Azure CLI - Lab Activity 00:07:00 Provision Resources using Cloud Shell - Lab Activity 00:05:00 Deployment with JSON - Lab Activity 00:08:00 Azure Advisor 00:01:00 Module 2 : What did we learn 00:01:00 Module 3 Security, Privacy, Compliance and Trust What to expect in Module 3 00:01:00 Azure Firewalls 00:02:00 Azure Firewall - Lab Activity - notes 00:02:00 Azure Firewall - Lab Activity 00:19:00 Azure DDOS 00:02:00 Network Security Groups 00:03:00 Application Security Groups 00:02:00 Which Network Security Solution to choose from ? 00:04:00 AuthZ and AuthN 00:01:00 Azure Active Directory 00:02:00 Multi Factor Authentication 00:03:00 Azure Security Center 00:02:00 Azure Security center - LAB activity 00:08:00 Azure Key Vault 00:02:00 Azure Information Protection 00:02:00 Azure Advanced Threat Protection 00:04:00 What is Azure Policy 00:03:00 Azure Policy - Lab Activity 00:06:00 Azure Role Based Access Control ( RBAC ) 00:02:00 Azure Role Based Access Control ( RBAC ) - Lab Activity 00:07:00 Azure Locks 00:01:00 Azure Locks - Lab Activity 00:02:00 Azure Blueprints 00:01:00 Subscription Governance 00:02:00 Azure Tags 00:03:00 Azure Monitoring 00:02:00 Azure Monitor- Lab Activity 00:03:00 Azure Service Health 00:01:00 Monitoring Applications and Services 00:04:00 Compliance Terms and Requirements 00:02:00 Microsoft Privacy Statement 00:01:00 Microsoft Trust Center 00:01:00 Service Trust Portal 00:01:00 Azure Government Services 00:02:00 Azure Germany Services 00:01:00 Azure China 21Vianet 00:02:00 Module 4 : Azure Pricing and Support Module 4 Introduction : What tÌ¥o expect in this module 00:02:00 Azure Subscriptions 00:06:00 What are Management Groups 00:01:00 Purchase Azure Product & Services : Available Options 00:01:00 Usage Metrics 00:01:00 Factors Affecting Costs 00:02:00 The concept of Zones for Billing 00:02:00 Azure Pricing Calculator 00:04:00 Azure Total Cost of Ownership ( TCO ) 00:02:00 Ways to Minimize Costs in Azure 00:04:00 Azure Cost Management 00:02:00 Azure Support Plans 00:03:00 Alternative Support Options 00:02:00 Service Level Agreements ( SLA's ) 00:03:00 Composite SLA's 00:03:00 Improving Application SLA's 00:04:00 Public and Preview Features 00:01:00 Providing Feedback 00:01:00 General Availability 00:01:00 Azure Updates , Announcements and Roadmaps 00:01:00 Course Conclusion Course Conclusion 00:01:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description OneNote online is a part of the Office 365 suite apps that assist to take free notes from drawings, links, and implanted files. A OneNote notebook is assimilated to multi-subject notebook that contains sections and pages. Interestingly, all of the works are automatically saved in OneNote. The MS OneNote Online course precisely implements the concept of MS Office 365 suite to make a clear functioning idea to his learner about OneNote and how it works effectively. The course shows how it incorporates text, images, web content, rooted objects, tables, and many other things. It also teaches the student how to share and print the document from OneNote Online Notebook. At the end of the course, the learner can learn the all effective aspects and use of OneNote Online Notebook and can implement their learning knowledge reliably. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? MS OneNote Online 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 MS OneNote Online 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. Introduction Introduction FREE 00:02:00 Working with OneNote Overview of OneNote 00:04:00 Creating a New Notebook 00:05:00 Navigating in OneNote 00:05:00 Adding Sections and Pages 00:06:00 Adding Content 00:08:00 Formatting Content 00:05:00 Using Tags 00:05:00 Using Search 00:04:00 Using Print and Sharing Options 00:05:00 Using Immersive Reader 00:05:00 Conclusion Course Recap 00:03:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description Take your networking knowledge to the next level with the MS Azure - Networking course. The course familiarizes you to virtual network configuration through the Microsoft Azure Portal. You will learn how to use network services to configure and load balance network traffic using tools such as Azure DNS. The course teaches you about IP Address space and shows you the procedures for creating a Vnet or virtual networking. You will understand Vnet peering and DNS in Azure Vnet. The course guides you to configure a Point to Site VPN and a Site to Site VPN. Lastly, the course focuses on the procedures of Azure Vnet peering, and shows you how peering between Vents can reduce the need to build Vnet-to-Vnet VPN gateways. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? MS Azure - Networking 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 MS Azure - Networking 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. Introduction Introduction FREE 00:02:00 Virtual Networks Virtual Network Overview 00:02:00 IP Address Space 00:03:00 DNS in Azure Vnets 00:03:00 Creating a VNet 00:03:00 VPNs with VNets 00:04:00 Configuring a Point to Site VPN 00:12:00 Configuring a Site to Site VPN 00:05:00 Azure Vnet Peering 00:05:00 Conclusion Course Recap 00:04:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description Learn to optimize your cloud application containers with Microsoft Azure. Enrol the MS Azure - Containers course and be an expert user of Azure Containers. Microsoft Azure helps you to develop, update, and manage your containerized applications faster with an end to end developer and CI/CD tools. You can store images in Docker Hub or Azure Container. You will also able to the registry and deploy to your preferred targets. The course teaches all these applications of the software chronologically. Throughout the course, you will be acquainted with the procedures of using the application. The course shows you how to deploy containers using widely adopted orchestrator, or choose a fully-managed container platform. The course describes what containers are within Azure. You will learn how to use docker host to manage both on-premises and Azure containers. To recapitulate, you will be confident enough to use Azure Containers by the end of the course. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? MS Azure - Containers 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 MS Azure - Containers 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. Introduction Introduction FREE 00:01:00 Introduction to Containers Introduction to Containers 00:04:00 Docker 00:04:00 Deploying Containers 00:08:00 Multi-container Applications 00:02:00 Azure Container Registry 00:03:00 Azure Container Clustering Options 00:02:00 Installing ACS 00:04:00 Conclusion Course Recap 00:02:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description Learn to leverage Azure Storage in your applications with the intensive course MS Azure - Azure Storage. Microsoft Azure Storage is the durable, highly available, massively scalable, secure, durable, and redundant cloud storage solution of Microsoft. It includes Azure Blobs (objects), Azure Data Lake Storage Gen2, Azure Files, Azure Queues, and Azure Tables. In the course, you will learn how to work with Azure storage accounts. You will learn how to expose file shares to multiple VMs in Azure at the same time. The course guides you the procedures of using Blob storage, File Storage, and Content Delivery Network. Additionally, you will know how to monitor the storage and look at Azure File Sync. Finally, the course teaches you how to work with Backup Vault and site Recovery. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? MS Azure - Azure Storage 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 MS Azure - Azure Storage 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. Introduction Introduction FREE 00:03:00 Working with Storage Azure Storage Overview 00:03:00 Working with Azure Storage Accounts 00:09:00 Storage Access 00:05:00 Using Azure Blob Storage 00:06:00 Using Azure File Storage 00:04:00 Azure File Sync 00:10:00 Monitoring Storage 00:03:00 Content Delivery Network 00:03:00 CDN Profile 00:06:00 Azure Backup Vault 00:04:00 Azure Site Recovery 00:03:00 Conclusion Course Recap 00:03:00

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

Compliance Management Course will guide you to understand child psychology issues and development, including its various stages.

Overview This comprehensive course on Excel Must know Formulas and Functions will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel Must know Formulas and Functions 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 Excel Must know Formulas and Functions. It is available to all students, of all academic backgrounds. Requirements Our Excel Must know Formulas and Functions 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 2 sections • 13 lectures • 01:53:00 total length •Building basic math formulas: 00:08:00 •Autosum and Relative references: 00:09:00 •Absolute references: 00:06:00 •Named Ranges: 00:06:00 •Linking sheets and workbooks: 00:06:00 •If, And, Or, and the nested If functions: 00:16:00 •Countif, Sumif, Averageif, Sumifs, and Countifs functions: 00:09:00 •Vlookup and Hlookup functions: 00:15:00 •Match and Index functions: 00:07:00 •Date and time formulas and functions: 00:12:00 •Text functions: 00:11:00 •Tracing formulas: 00:08:00 •Assignment - Excel Must know Formulas and Functions: 00:00:00

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