29579 Courses

***A Better Pathway for Rapid Growth! Limited Time Opportunity; Hurry Up!*** Ignite your dynamic career and strengthen your deep insight knowledge by signing up for SQL Programming Bootcamp. 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 SQL Programming Bootcamp 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 SQL Programming Bootcamp 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 SQL Programming Bootcamp 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 SQL Programming Bootcamp Unit 01: Introduction Unit 02: Setting up Course Tools Unit 03: Browsing & Filtering Data Unit 04: Filter Data with AND, OR, NOT Operators Unit 05: Math Operations Unit 06: String Concatenation Unit 07: Tidy Up Your Results: Sorting, Alias Names, Limit Records Unit 08: NULL, DISTINCT & CASE Statements Unit 09: Functions in SQL: Multiple-Row Functions Unit 10: Functions in SQL: Single-Row Functions Unit 11: Nested Queries Unit 12: Casting & Data Conversion Unit 13: Combination Relationships Unit 14: Joins in SQL Unit 15: Data Manipulation (DML) Unit 16: SQL Data Definition Language (DDL) 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 15 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Course the Right Option for You? This SQL Programming Bootcamp 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 SQL Programming Bootcamp 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 SQL Programming Bootcamp course is to help you toward your dream career. So, complete this course and enhance your skills to explore opportunities in relevant areas.

Imagine embarking on a Customer Support Training Course that equips you with essential skills crucial in today's digital age. Customer support is not just about solving problems; it's about fostering positive relationships and ensuring satisfaction. In our modern world, where businesses thrive on customer loyalty, mastering Customer Support is paramount. This course teaches you effective communication, telephone etiquettes, and negotiation techniques, preparing you to handle various customer interactions confidently. These skills are invaluable in both daily life and professional careers, opening doors to job opportunities across the UK. Customer Support roles are in high demand, with salaries reflecting this need-ranging from competitive entry-level packages to lucrative senior positions. The sector is growing steadily, with a significant rise in job openings over the past decade. By enrolling in this course, you not only enhance your employability but also contribute to your personal growth and the success of any organization you join. Customer Support isn't just a skill; it's a pathway to thriving in today's service-driven economy. Key Features: CPD Certified Customer Support Course Free Certificate from Reed CIQ Approved Customer Support Course Developed by Specialist Lifetime Access Course Curriculum Module 01: Introduction to Call Centre Module 02: Traits of a Call Centre Agent Module 03: Agent and Customer Relationship Module 04: Telephone Etiquettes Module 05: Communication Skills Module 06: Scripts and Negotiation Techniques Module 07: Managing Difficult Customers Module 08: Call Centre Metrics and Benchmarking Module 09: Call Centre Technology and Trends Learning Outcomes: Develop strong customer rapport for enhanced service delivery and satisfaction. Perfect telephone etiquette to create a positive and professional impression. Acquire effective communication skills for seamless customer-agent interactions. Hone negotiation techniques within scripted scenarios for optimal outcomes. Navigate challenging customer situations with confidence and strategic proficiency. Interpret call centre metrics to drive performance and achieve benchmarked success. CPD 10 CPD hours / points Accredited by CPD Quality Standards Customer Support Training 1:58:15 1: Module 1: Introduction to Call Centre Preview 13:52 2: Module 2: Traits of a Call Centre Agent 13:07 3: Module 3: Agent and Customer Relationship 15:02 4: Module 4: Telephone Etiquettes 10:06 5: Module 5: Communication Skills 13:15 6: Module 6: Scripts and Negotiation Techniques 12:40 7: Module 7: Managing Difficult Customers 09:06 8: Module 8: Call Centre Metrics and Benchmarking 16:18 9: Module 9: Call Centre Technology and Trends 13:49 10: CPD Certificate - Free 01:00 Who is this course for? This Customer Support Training course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Customer Support Training. Moreover, this course is ideal for: Aspiring customer service professionals seeking skills enhancement. Call centre agents eager to refine their customer interaction capabilities. Team leaders aiming to elevate their team's customer satisfaction scores. Customer support managers focused on improving overall team performance. Individuals in roles requiring mastery of call centre dynamics and metrics. Requirements There are no requirements needed to enrol into this Customer Support Training course. We welcome individuals from all backgrounds and levels of experience to enrol into this Customer Support Training course. Career path After finishing this Customer Support Training course you will have multiple job opportunities waiting for you. Some of the following Job sectors of Customer Support are: Customer Service Representative - £18K to 25K/year Call Centre Team Leader - £22K to 30K/year Customer Support Manager - £30K to 40K/year Technical Support Specialist - £20K to 28K/yr Customer Experience Analyst - £25K to 35K/yr Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Our extensive Call Centre & Customer Service Training course will help your call center workforce reach its full potential. Our 10-module programme covers all the essentials for providing great customer service, from learning the fundamentals to honing communication skills and creating goals. Develop your questioning skills, master phone etiquette, and improve your public speaking abilities. Equip yourself with the instruments required to succeed in the fast-paced field of customer service with an emphasis on pragmatism and benchmarking. Become a light of excellence for your call center by partnering with us. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access Throughout this course, participants will first gain an understanding of the core competencies and knowledge required for work in contact centres and customer service. The nuances of phone etiquette will then be covered in detail, enabling them to speak with professionalism and effectiveness when on the phone. Learners will explore different types of questions and how to respond to them appropriately, enhancing their ability to assist customers efficiently. They'll also learn techniques to speak confidently and skillfully, aiming to provide stellar customer service experiences. The curriculum emphasises key steps in handling customer interactions, setting achievable goals, and effectively closing conversations. Learners will gain insights into benchmarking performance and utilising various tools to support their customer service efforts effectively. Overall, this curriculum equips learners with the essential skills and knowledge needed to excel in call centre and customer service roles. Course Curriculum: Module 01: The Basics (I) Module 02: The Basics (II) Module 03: Phone Etiquette Module 04: Types of Questions Module 05: Speaking Like a Star Module 06: Key Steps Module 07: Goal Setting Module 08: Closing Module 09: Benchmarking Module 10: Tools Learning Outcomes: Understand fundamental principles of call centre and customer service operations. Master phone etiquette for effective communication in customer interactions. Develop skills to handle various types of customer inquiries confidently. Enhance verbal communication techniques to engage and assist customers effectively. Implement key steps and strategies to achieve customer service goals. Utilise benchmarking and tools for continuous improvement in service quality. CPD 10 CPD hours / points Accredited by CPD Quality Standards Call Centre & Customer Service Training 41:29 1: Module 01: The Basics (I) 05:23 2: Module 02: The Basics (II) 04:02 3: Module 03: Phone Etiquette 04:04 4: Module 04: Types of Questions 04:41 5: Module 05: Speaking Like a Star 02:59 6: Module 06: Key Steps 04:30 7: Module 07: Goal Setting 04:58 8: Module 08: Closing 03:32 9: Module 09: Benchmarking 03:34 10: Module 10: Tools 02:46 11: CPD Certificate - Free 01:00 Who is this course for? Individuals aspiring for customer service or call centre roles. Professionals seeking to enhance customer communication and service skills. Job seekers aiming for entry-level positions in customer support. Anyone interested in understanding call centre operations and customer service. Individuals aiming to improve their communication skills in service-oriented roles. Career path Customer Service Representative Call Centre Operator Customer Support Assistant Helpdesk Support Agent Client Relationship Manager Sales Support Executive Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Our extensive Call Centre & Customer Service Training course will help your call center workforce reach its full potential. Our 10-module programme covers all the essentials for providing great customer service, from learning the fundamentals to honing communication skills and creating goals. Develop your questioning skills, master phone etiquette, and improve your public speaking abilities. Equip yourself with the instruments required to succeed in the fast-paced field of customer service with an emphasis on pragmatism and benchmarking. Become a light of excellence for your call center by partnering with us. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access Throughout this course, participants will first gain an understanding of the core competencies and knowledge required for work in contact centres and customer service. The nuances of phone etiquette will then be covered in detail, enabling them to speak with professionalism and effectiveness when on the phone. Learners will explore different types of questions and how to respond to them appropriately, enhancing their ability to assist customers efficiently. They'll also learn techniques to speak confidently and skillfully, aiming to provide stellar customer service experiences. The curriculum emphasises key steps in handling customer interactions, setting achievable goals, and effectively closing conversations. Learners will gain insights into benchmarking performance and utilising various tools to support their customer service efforts effectively. Overall, this curriculum equips learners with the essential skills and knowledge needed to excel in call centre and customer service roles. Course Curriculum: Module 01: The Basics (I) Module 02: The Basics (II) Module 03: Phone Etiquette Module 04: Types of Questions Module 05: Speaking Like a Star Module 06: Key Steps Module 07: Goal Setting Module 08: Closing Module 09: Benchmarking Module 10: Tools Learning Outcomes: Understand fundamental principles of call centre and customer service operations. Master phone etiquette for effective communication in customer interactions. Develop skills to handle various types of customer inquiries confidently. Enhance verbal communication techniques to engage and assist customers effectively. Implement key steps and strategies to achieve customer service goals. Utilise benchmarking and tools for continuous improvement in service quality. CPD 10 CPD hours / points Accredited by CPD Quality Standards Call Centre & Customer Service Training 41:29 1: Module 01: The Basics (I) 05:23 2: Module 02: The Basics (II) 04:02 3: Module 03: Phone Etiquette 04:04 4: Module 04: Types of Questions 04:41 5: Module 05: Speaking Like a Star 02:59 6: Module 06: Key Steps 04:30 7: Module 07: Goal Setting 04:58 8: Module 08: Closing 03:32 9: Module 09: Benchmarking 03:34 10: Module 10: Tools 02:46 11: CPD Certificate - Free 01:00 Who is this course for? Individuals aspiring for customer service or call centre roles. Professionals seeking to enhance customer communication and service skills. Job seekers aiming for entry-level positions in customer support. Anyone interested in understanding call centre operations and customer service. Individuals aiming to improve their communication skills in service-oriented roles. Career path Customer Service Representative Call Centre Operator Customer Support Assistant Helpdesk Support Agent Client Relationship Manager Sales Support Executive Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Are you looking to enhance your Content & Social Media Executive skills? If yes, then you have come to the right place. Our comprehensive course on Content & Social Media Executive will assist you in producing the best possible outcome by mastering the Content & Social Media Executive skills. The Content & Social Media Executive course is for those who want to be successful. In the Content & Social Media Executive course, you will learn the essential knowledge needed to become well versed in Content & Social Media Executive. Our Content & Social Media Executive course starts with the basics of Content & Social Media Executive and gradually progresses towards advanced topics. Therefore, each lesson of this Content & Social Media Executive course is intuitive and easy to understand. Why would you choose the Content & Social Media Executive course from Compliance Central: Lifetime access to Content & Social Media Executive course materials Full tutor support is available from Monday to Friday with the Content & Social Media Executive course Learn Content & Social Media Executive skills at your own pace from the comfort of your home Gain a complete understanding of Content & Social Media Executive course Accessible, informative Content & Social Media Executive learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the Content & Social Media Executive bundle Study Content & Social Media Executive in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Content & Social Media Executive Course Improve your chance of gaining in demand skills and better earning potential by completing the Content & Social Media Executive Content & Social Media Executive Curriculum Breakdown of the Content & Social Media Executive Course Section 1: Introduction Unit 1: Introduction Section 2: Importance of Social Media Marketing for Business Unit 1: Why Social Media Marketing is Important for Every Business Unit 2: Social Media Terminology Section 3: Creating a Social Media Strategy Unit 1: How to Create an Internet Marketing System That Will Generate Sales Unit 2: How to Find Sources for Great Posts Unit 3: How to Create a Social Media Calendar Unit 4: Elements for the Perfect Posts Unit 5: How to Create Standard Social Media Messages Unit 6: How to Stay in Touch with Your Followers Unit 7: How to Evaluate Your Social Media Campaigns CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Content & Social Media Executive course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Content & Social Media Executive. It is also great for professionals who are already working in Content & Social Media Executive and want to get promoted at work. Requirements To enrol in this Content & Social Media Executive course, all you need is a basic understanding of the English Language and an internet connection. Career path The Content & Social Media Executive course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Content & Social Media Executive. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Introduction to Excel's Pivot Tables This presentation will explore the use of pivot tables, including what they are, what you can do with them, how to create them, and other special features. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Master the art of private investigation with the Private Investigator Level 3 Diploma. This comprehensive course equips you with crucial skills such as interviewing, criminal psychology, surveillance, and business management, ensuring you have the expertise for a successful career in the field.

>>24 Hours Left! Don't Let the Winter Deals Slip Away - Enrol Now!<< Did you know that over 850,000 people in the UK live with dementia, and this number is projected to rise to over 1 million by 2025? This progressive brain disease affects memory, thinking, and behavior, impacting individuals and their families significantly. Our Course will help you improve the physical and mental skills needed to provide care to clients who have been diagnosed with light, moderate or even severe dementia. This course is designed to equip you with the knowledge and skills necessary to understand dementia, support those affected, and navigate the complexities of this disease. Learners will gain insights into legal and ethical considerations, effective caregiving strategies, and the financial implications of dementia care. Additionally, this course delves into pharmacological treatments and provides practical guidance for supporting individuals living with dementia. If you are ever faced with this challenge, the Dementia Training skills will be very helpful, both for you and the person you care for. This will create a real difference. So get started with this program today and develop yourself to be the most suitable caregiver you can be. Become a confident advocate and caregiver for those living with dementia. Don't wait. Enrol in our Dementia Training course today! Learning Outcomes Differentiate between major dementia types through case studies presented in Dementia Training sessions. Analyse the UK's current dementia landscape and its economic impact using data explored in course modules. Apply ethical principles to real-life scenarios presented in the course, ensuring person-centred care. Develop effective communication strategies for diverse dementia presentations, honed through the course role-plays. Implement evidence-based dementia care strategies learned in the course to manage challenging behaviors. Advocate for individuals living with dementia, utilizing skills and resources gained through the Training programs. Why Choose Our Course? Get a free student ID card with this course Get instant access to this course course. Learn from anywhere in the world This course is affordable and simple to understand This course is an entirely online, interactive lesson with voiceover audio Lifetime access to the course materials This course comes with 24/7 tutor support This course seeks to improve the well-being and experience of people with dementia and of the care staff working with them. It should improve your self-confidence in handling situations you find challenging. *** Course Curriculum *** Module 01: Introduction to Dementia Module 02: Status of Dementia Module 03: Attitudes Toward Dementia Module 04: Awareness and Prevention of Dementia Module 05: Law, Ethics and Safeguard Regarding Dementia Module 06: Strategies for Caring Module 07:The Cost of Dementia Module 08: Drug for Dementia Module 09: Living with Dementia Assessment Process Once you have finished the learning stages in the Course, your abilities will be assessed by an automated multiple-choice question session, after which you will receive the results immediately. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This is ideal for: Students seeking mastery in this field Professionals seeking to enhance their skills Anyone who is passionate about this topic Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career. Like as: Dementia Care Assistant - £19,000 - £23,000 Dementia Support Worker - £17,000 - £21,000 Dementia Outreach Worker - £18,000 - £22,000 Dementia Adviser - £20,000 - £25,000 Dementia Trainer - £22,000 - £28,000 Dementia Nurse - £24,000 - £32,000 Certificates CPDQS Accredited Certificate Digital certificate - £10 Upon passing the Bundle, you need to order to receive a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPDQS CPDQS Accredited Certificate Hard copy certificate - £29 Upon passing the Bundle, you need to order to receive a Hard copy Certificate for each of the courses inside this bundle. If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Almost every business, organization, companies, and individual owner need Microsoft Excel to record finances, hours, data, and to perform many other activities at once. It is widely used software that assists to analyze data, send invoices, share works with different people at a time, and function many more activities. Are you looking fresher? Don't you have any training and knowledge about this software? Are you interested to improve your skills to pursue the best position in any organization? if so, the ultimate Microsoft Excel for Beginners course assists you to learn further all you need in your quest. As the course is online based, you can complete it from any part of the world at any time at your own pace. The course is accessible through an internet connection from any Computer, Laptop, Mac, smartphones, or any electronic devices that support MS Excel software. The course contents require a few minutes for each. So, it is convenient for you to start or stop at any time as you want. It entertains you, though you have less than 20 minutes to go through this course. Who is this Course for? Microsoft Excel for Beginners is 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. 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 the English language, numeracy and ICT are required to attend this course CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99 Course Curriculum Excel Beginners Identify the Elements of the Excel Interface 00:30:00 Activity - Identify the Elements of the Excel Interface 00:05:00 Create a Basic Worksheet 01:00:00 Activity - Create a Basic Worksheet 00:05:00 Use the Help System 00:30:00 Activity - Use the Help System 00:05:00 Create Formulas in a Worksheet 01:00:00 Activity - Create Formulas in a Worksheet 00:05:00 Insert Functions in a Worksheet 00:30:00 Activity - Insert Functions in a Worksheet 00:05:00 Reuse Formulas 00:30:00 Activity - Reuse Formulas 00:05:00 Manipulate Data 00:30:00 Activity - Manipulate Data 00:05:00 Insert, Manipulate, and Delete Cells, Columns, and Rows 00:30:00 Activity - Insert, Manipulate, and Delete Cells, Columns, and Rows 00:05:00 Search For and Replace Data 00:30:00 Activity - Search For and Replace Data 00:05:00 Spell Check a Worksheet 00:30:00 Activity - Spell Check a Worksheet 00:05:00 Modify Fonts 00:30:00 Activity - Modify Fonts 00:05:00 Add Borders and Colors to Cells 01:00:00 Activity - Add Borders and Colors to Cells 00:05:00 Apply Number Formats 00:30:00 Activity - Apply Number Formats 00:05:00 Align Cell Contents 00:30:00 Activity - Align Cell Contents 00:05:00 Apply Cell Styles 00:30:00 Activity - Apply Cell Styles 00:05:00 Define the Basic Page Layout for a Workbook 01:00:00 Activity - Define the Basic Page Layout for a Workbook 00:05:00 Refine the Page Layout and Apply Print Options 00:30:00 Activity - Refine the Page Layout and Apply Print Options 00:05:00 Format Worksheet Tabs 00:30:00 Activity - Format Worksheet Tabs 00:05:00 Manage Worksheets 00:30:00 Activity - Manage Worksheets 00:05:00 Manage the View of Worksheets and Workbooks 00:30:00 Activity - Manage the View of Worksheets and Workbooks 00:05:00 Customize General and Language Options 00:30:00 Activity - Customize General and Language Options 00:05:00 Customize Formula Options 00:30:00 Activity - Customize Formula Options 00:05:00 Customize Proofing and Save Options 01:00:00 Activity - Customize Proofing and Save Options 00:05:00 Customize the Ribbon and Quick Access Toolbar 00:30:00 Activity - Customize the Ribbon and Quick Access Toolbar 00:05:00 Customize the Functionality of Excel by Enabling Add-Ins 00:30:00 Activity - Customize the Functionality of Excel by Enabling Add-Ins 00:05:00 Customize Advanced and Trust Center Options 00:30:00 Activity - Customize Advanced and Trust Center Options 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 for Beginners 00:00:00 Mock Exam Mock Exam- Microsoft Excel for Beginners 00:20:00 Final Exam Final Exam- Microsoft Excel for Beginners 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Data Analysis In Excel is suitable for anyone aspiring to or already working in this field or simply want to learn deeper into data analysis. You will be able to add this qualification to your CV by downloading your certificate instantly without any cost. To make this course more accessible for you, we have designed it for both part-time and full-time students. This course is packed into the bite-size module for your convenience. You can study at your own pace or become accredited within hours! If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email. This Data Analysis In Excel aims to introduce Data Analysis in Excel 2016. You'll learn the best way to enter and organize data, sort and map data, perform calculations with simple functions, format the appearance of your data and cells, and build charts and PivotTables for data analysis. You will know how to validate data, search and remove invalid data. The course covers Lookup information using VLOOKUP, and INDEX-MATCH, data forecasting and cleansing, providing external and 3D references and inserting sparklings, so that you have a great foundation in the world's most popular spreadsheet programme. Finally, you will learn different features to visualise or analyse your data in the most convenient way, which allows you to take the right business decisions for your company Who is this Course for? Data Analysis In Excel is 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 Data Analysis In Excel 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. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Create and Modify Tables 00:15:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00