• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

47120 Courses in Cardiff delivered On Demand

Level 3 Diploma in Microsoft Excel 2007

4.3(43)

By John Academy

Description:  Whether you use excel for work or study, this online course covers beginner, intermediate and advanced lessons in excel. Learn the main topics related to Microsoft excel 2007. Identify the basic excel techniques, explore the advanced functions of excel 2007 and create automated reports with the press of a button in this course. By completing this course, you will become an excel expert and use excel 2007 as a professional. Who is the course for? This course is perfect for individuals who are looking forward to developing their skills of using Microsoft Excel application. This course is for office professionals who want to nail all the meetings and projects at the workplace. This course will be ideal for professionals in business, finance and many other areas that need to analyse data in accounts. Entry Requirement: This course is available to all learners, of all academic backgrounds. However, an education and experience in accounting is an advantage. 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. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, 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 hard copy at a cost of £39 or in PDF format at a 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 recognised 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: The diploma in Microsoft Excel 2007 will be very beneficial and helpful, especially to the following professionals: Admin Assistant. PA. Secretary. Administrator. Account Assistant. Bookkeeper. Accountant. Office Manager. Microsoft Excel 2007 for Beginners Module One - Getting Started 01:00:00 Module Two - Opening and Closing Excel 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 01:00:00 Module Ten - Formatting your Data 01:00:00 Module Eleven - More Formatting 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2007 for Beginners 00:00:00 Microsoft Excel 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt 01:00:00 Module Three - Inserting Objects 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with Pivot Tables 01:00:00 Module Seven - Creating Pivot Charts 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What-If Analysis 01:00:00 Module Ten - Managing Your Data 01:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2007 Advanced Level 00:00:00 Mock Exam Final Exam Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Level 3 Diploma in Microsoft Excel 2007
Delivered Online On Demand22 hours 30 minutes
£11.99

Diploma in Meeting Management

4.3(43)

By John Academy

Do you have the interest to become a leader but having a hard time in facilitation and meeting? Then worry no more! This course is created for people who need to know about meeting management. Description: Anyone who wants to become a leader or manager needs to have the right meeting skills. Meeting with clients or your team will be part of your work and this course will help you with that. Learn how to plan and prepare for meetings. Know how to choose the right time and place for your meetings. Explore how to create agenda and all the things needed for a meeting. Understand meeting roles and responsibilities during meetings. Most importantly, in this course you will learn how to professional conduct meetings and resolve personality conflicts if there are. Who is the course for? Leaders or potential meeting facilitators that need meeting and facilitation skills. People who need to learn about meeting management. 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. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, 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: The Diploma in Meeting Management is a useful qualification to possess, and would be beneficial for the following careers: Businessmen Facilitators Manager Supervisor Team Leaders. Diploma in Meeting Management - Updated Version Module 01: Planning and Preparation Planning and Preparation 00:15:00 Module 02: Online Meeting Platforms Online Meeting Platforms Part - 01 01:03:00 Online Meeting Platforms Part - 02 00:45:00 Module 03: Meeting Etiquette and Tips Meeting Etiquette and Tips 00:13:00 Diploma in Meeting Management - Old Version Module - One Getting Started 00:30:00 Module Two - Planning and Preparing (I) 01:00:00 Module Three - Planning and Preparing (II) 01:00:00 Module Four - Setting up the Meeting Space 01:00:00 Module Five - Electronic Options 01:00:00 Module Six - Meeting Roles and Responsibilities 01:00:00 Module Seven - Chairing a Meeting (I) 01:00:00 Module Eight - Chairing a Meeting (II) 00:30:00 Module Nine - Dealing with Disruptions 00:30:00 Module Ten - Taking Minutes 00:30:00 Module Eleven - Making the Most of Your Meeting 01:00:00 Module Twelve - Wrapping Up 01:00:00 Activities Diploma in Meeting Management- Activities 00:00:00 Mock Exam Mock Exam- Diploma in Meeting Management 00:20:00 Final Exam Final Exam- Diploma in Meeting Management 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Diploma in Meeting Management
Delivered Online On Demand12 hours 56 minutes
£11.99

Positive Discipline Methods

4.3(43)

By John Academy

Do you know what the effective discipline methods are? Discipline basics can be hard if you don't give a chance to learn it thoroughly. Enrol now to start learning the positive discipline techniques! Description: To be able to discipline children, you have to understand that children are not born knowing what is right and bad. They still need the guidance of their parents or guardian to be able to determine this. And this course is perfect to be able to learn how to discipline children since this is designed for parents or anyone who is struggling with controlling kids. Also, you will learn what the appropriate discipline methods to be used that are still positive for the development of the kids. This course will be providing the guidelines that can help parents or guardians on how to help children in their growth and development, specifically on how they are disciplined. You should be able to learn what positive discipline methods should be used so that it won't affect the children's growth negatively. This course is also designed to know the perspective of children and how to be able to relate to them and their behaviour to know what appropriate discipline methods that should be implemented. Who is the course for? Parents, guardians or anyone who deals with disciplining children. People who have an interest in child care and development. 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. Assessment:  At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, 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 hard copy at a cost of £39 or in PDF format at a 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 recognised 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: The Positive Discipline Methods is a useful qualification to possess, and would be beneficial for: Child Development Specialist Counsellors Guardians Parents Teachers. Positive Discpline Methods Introduction To Discipline Dynamic 00:30:00 Identify Where Your Child Struggles 00:30:00 Use Natural And Logical Consequences 01:00:00 Establish Clear Expectations And Consequences 00:15:00 Select The Best Consequences Firm 00:30:00 Don't Give Up.. Be Consistent 00:30:00 Effect Of Consequences Of Incorrect Discipline 00:15:00 Mock Exam Mock Exam- Positive Discipline Methods 00:20:00 Final Exam Final Exam- Positive Discipline Methods 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Positive Discipline Methods
Delivered Online On Demand4 hours 10 minutes
£11.99

Ethnobotany Course

4.3(43)

By John Academy

Overview Explore the fascinating connection between humans and plants with our comprehensive Ethnobotany Course. This course is designed to help the learners understand how human societies and cultures have captivated the power of nature. The course will help you understand the concepts of ethnobotany. Here, you will learn about the relationship between our societies and plants. The course will provide you with a detailed understanding of ethnological research methods. In addition, you will be able to explore the traditional uses of places. Along with that, the course will educate you on biodiversity conservation and sustainability. You will also get a clear view of the future of ethnobotany. Join now! Course Preview Learning Outcomes Understand the definition and concepts of ethnobotany Learn about the connection between plants and human society Enhance your understanding of ethnobotanical research methods Deepen your understanding of traditional plant uses Learn about biodiversity conservation and sustainability Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Engaging tutorial videos, materials from the industry-leading experts Opportunity to study in a user-friendly, advanced online learning platform Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email. What Skills Will You Learn from This Course? Ethnobotany research Biodiversity conservation Who Should Take This Ethnobotany Course ? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Ethnobotany Course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Certificate of Achievement After completing this course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates & Transcripts can be obtained either in Hardcopy at £14.99 or in PDF format at £11.99. Career Path​ This exclusive Ethnobotany Course will equip you with effective skills and abilities and help you explore career paths such as  Ethnobotanist Agriculture Officer Community Development Specialist Researcher Module 01: Introduction to Ethnobotany Introduction to Ethnobotany 00:17:00 Module 02: Plants and Human Societies Plants and Human Societies 00:18:00 Module 03: Botanical Foundations Botanical Foundations 00:19:00 Module 04: Ethnobotanical Research Methods Ethnobotanical Research Methods 00:16:00 Module 05: Traditional Plant Uses Traditional Plant Uses 00:17:00 Module 06: Biodiversity Conservation and Sustainability Biodiversity Conservation and Sustainability 00:18:00 Module 07: Future Horizons in Ethnobotany Future Horizons in Ethnobotany 00:15:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Ethnobotany Course
Delivered Online On Demand2 hours
£11.99

Level 2 Certificate in Tax Management (USA)

4.3(43)

By John Academy

Description: People want to pay less in taxes including the rich. Here are some universal techniques that help you to reduce your taxes. Enrol the Level 2 Certificate in Tax Management (USA) course and learn the tips for saving money. The course guides you the procedures for saving money in the tax sessions. At first, the history of tax and marginal rates along with the concept of deductions and credits will be discussed in the course. Then, you will learn the tax strategies such as retirement accounts and FATCA that is followed by the techniques of using CPAs and other tax preparation software. Finally, the course shows you the ways of avoiding the audit by the IRS. Shortly, the Level 2 Certificate in Tax Management (USA) provides the necessary tricks and methods followed by the wealthy to pay less in the tax session. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Level 2 Certificate in Tax Management (USA) 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 Level 2 Certificate in Tax Management (USA) 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 Everything You Need to Know About Taxes Introduction: Why the Rich Get Richer FREE 00:07:00 The History of Taxes & Marginal Rates A Brief History of Taxes in America 00:12:00 Understanding Marginal Tax Rates 00:06:00 Deductions & Credits How to Maximize Tax Deductions 00:11:00 How to Maximize Tax Credits 00:11:00 Retirement Accounts & FATCA Building Wealth Through Tax Efficient Retirement Accounts 00:13:00 Taxes on Foreign Earned Income and Assets 00:10:00 Strategies of the Wealthy Using CPAs & Tax Preparation Software 00:06:00 Tax Tips & Tricks of the Wealthy 00:07:00 How to Avoid an Audit by the IRS 00:08:00 Conclusion: Bringing it All together Creating a Wealth Building Tax Strategy 00:04:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Level 2 Certificate in Tax Management (USA)
Delivered Online On Demand1 hour 35 minutes
£11.99

Microsoft Office 2013 Lync Essentials - Complete Video Course

4.3(43)

By John Academy

Description: Lync 2013 is a communication tour. By taking this Microsoft Office 2013 Lync Essentials - Complete Video Course you will get the knowledge and skills to setup Lync 2013, use presence, IM and Contacts, make audio and video calls, and schedule, join and conduct Lync meetings. Here, you will learn how to sign into Lync 2013, or how to get oriented to the interface, you will also learn how to establish Lync options and how to add contacts and groups. At first, you need a Microsoft account before you can utilize Lync. After signing in you will get the Lync Interface. For the organizations that want a scalable solution, Microsoft recommends using a hardware load balancer to distribute the traffic among multiple Lync servers. This course will give you the option to build a strong communication system which will be very helpful for you or your organization. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2013 Lync Essentials - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2013 Lync Essentials - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Setup Lync 2013 Sign In and Get Oriented FREE 00:06:00 Establish Lync Options 00:07:00 Add Contacts and Groups 00:05:00 Presence, IM and Contacts Use Presence 00:06:00 Send and Receive IM's 00:10:00 Use Conversation History 00:04:00 Use the Contact Card 00:04:00 Make Audio and Video Calls Make an Audio Call 00:10:00 Make a Video Call 00:04:00 Schedule, Join and Conduct Lync Meetings Schedule a Meeting 00:09:00 Join a Meeting 00:05:00 Conduct a Meeting 00:14:00 Mock Exam Mock Exam- Microsoft Office 2013 Lync Essentials - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Lync Essentials - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2013 Lync Essentials - Complete Video Course
Delivered Online On Demand2 hours 4 minutes
£11.99

Certificate Course in Raising Children Properly

4.3(43)

By John Academy

Description: This course will teach you the important aspects of raising your children. With our busy lives it is so easy to become geared up to making sure our children have all the essentials covered, such as food, shelter, learning to read and write, and all those important jobs were done, that we forget that so much of what our children need us for is for us to impart a spark of desire for them to succeed, to become all they were made to be. It's the drive of many parents to watch their child surpass them in their life in some way. Whether it is a talent, a discovered passion, or their standard of living, children should be able to combine what they learn from our mistakes, and our life lessons with the lessons and opportunities they themselves face and collate them together to succeed. To have a successful child we need to create a childhood that breeds success. The best part about this is it doesn't cost you thousands of dollars in private school fees or in plenty of extracurricular activities. This course has been designed to teach the parents in depth knowledge, information and effective ways of raising children in this modern world. Who is the course for? Teachers or professionals who are working with kids. Anyone who loves to become a teacher and likes children in general. 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. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, 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 hard copy at a cost of £39 or in PDF format at a 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: Certificate Course in Raising Children Properly will be useful and would be beneficial for children-related kind of occupations and careers like: Child Care Specialists Child and Family Social Worker Early Educators Paediatric Nurse Pediatric Physical Therapist And Much More. Certificate Course in Raising Children Properly Raising Children Who Succeed 01:00:00 How Do We Define Success? 00:30:00 What The Children Don't Need 01:00:00 What They Do Need 01:00:00 The Legacy of Books 01:00:00 The Power of Role Models 01:00:00 Teaching Social Skills 01:00:00 Money, Money, Money 00:30:00 Mock Exam Mock Exam- Certificate Course in Raising Children Properly 00:20:00 Final Exam Final Exam- Certificate Course in Raising Children Properly 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Certificate Course in Raising Children Properly
Delivered Online On Demand7 hours 40 minutes
£11.99

Dream Analysis and Interpretation Training

4.3(43)

By John Academy

Overview Dreams are a mysterious creation of our mind. Some dreams reflect our subconscious thoughts, while others may mean something else. Understand what your dreams are trying to tell you with our Dream Analysis and Interpretation Training course. This interesting course will help you explore the fascinating realm of dreams. In this course, you will be able to connect the bridge between dreams and psychology. The course will help you understand different symbols of dreams. Furthermore, you will grasp the techniques to analyse and find the meanings of your dreams. Through the informative modules, you will learn about common dreams and their meanings. By the end of the course, you will know how to dream positively. Course Preview Learning Outcomes Understand the relationship between psychology and dreams Learn the meaning of the dream symbols Grasp the strategies to interpret your dreams Deepen your knowledge of common dreams and their meanings Know how to dream positively Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email What Skills Will You Learn from This Course? Dream Interpretation Dream Analysis Who Should Take This Dream Analysis and Interpretation Training? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Dream Analysis and Interpretation Training Certificatio After completing and passing the Dream Analysis and Interpretation Training successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Path​ This exclusive Dream Analysis and Interpretation Training will equip you with effective skills and abilities and help you explore career paths such as  Dream interpreters Psychology professionals Module 01: Dream Basics Dream Basics 00:25:00 Module 02: Psychology And Dreams Psychology and Dreams 00:24:00 Module 03: Understanding The Secrets In Dream Symbols Understanding the Secrets in Dream Symbols 00:28:00 Module 04: Interpreting Your Dreams Interpreting Your Dreams 00:30:00 Module 05: Benefits Of Dreaming Benefits of Dreaming 00:19:00 Module 06: Common Dreams And Their Meanings Common Dreams and Their Meanings 00:23:00 Module 07: How To Dream Positively How to Dream Positively 00:23:00 Module 08: Meditations And Dreams Meditations and Dreams 00:32:00 Assignment Assignment - Dream Analysis And Interpretation 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Dream Analysis and Interpretation Training
Delivered Online On Demand3 hours 24 minutes
£11.99

The New functions in Microsoft Excel in 2021

4.3(43)

By John Academy

Course Overview Take your career to the next level by mastering new Excel functions. This The New functions in Microsoft Excel in 2021 course aims to provide you with a greater understanding of Excel's new formulas to boost your work output. Microsoft Excel is a widely used spreadsheet program in various organizations. It simplifies the process of calculation, analysis and visualization of data and information. Having Excel skills adds a considerable amount of weight to your resume. In this The New functions in Microsoft Excel in 2021 course, you will learn about the latest functions of Excel to simplify your Excel tasks. You will learn the principles behind dynamic arrays and explore how to create a table of random numbers or random dates with Randarray. It will teach you the new ways of dynamically sorting data with the sort by function. You will also delve into other functions such as XLOOKUP, SWITCH and CONCAT and determine how they work.  Learning Outcomes Familiarize with the new functions of Excel Understand how the FILTER function works Explore how the new UNIQUE, SORT and SORTBY Excel functions work Know how to use RANDARRAY function to randomly sort lists Be able to use DYNAMIC array formulas Understand how to use the new functions in reports Who is this course for? The New functions in Microsoft Excel in 2021 course is highly relevant for professionals who want to excel in their position with their Excel skills. Gaining the skills adds weight to the resume and provides tremendous career opportunities. 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 The New functions in Microsoft Excel in 2021 course provides useful skills to possess and would be beneficial for any related profession or industry such as: Office administrators Accounting officers Managers HR Project Supervisors Data analyst Teachers Sales Representatives The New functions in Microsoft Excel in 2021 Module 01: Introduction and Agenda 00:07:00 Module 02: RANDARRAY 00:04:00 Module 03: UNIQUE 00:05:00 Module 04: SEQUENCE 00:04:00 Module 05: SORT and SORTBY 00:09:00 Module 06: SORT A Practical Example 00:06:00 Module 07: FILTER 00:07:00 Module 08: FILTER A Practical Example 00:08:00 Module 09: Other Useful New Functions 00:15:00 Module 10: Using the New Functions in Reports 00:08:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

The New functions in Microsoft Excel in 2021
Delivered Online On Demand1 hour 13 minutes
£11.99

Cycling Essentials

4.3(43)

By John Academy

Overview A cycle is convenient for commuting, good for your health and excellent for the environment. Learn how to ride a cycle like a pro with our Cycling Essentials course. This course will introduce you to the fundamentals of cycling and take your riding skills to the next level.  In this course, you will first learn the principles of buying a cycle. Then, it will introduce you to the necessary tools and accessories. Then, you will get lessons on how to ride better on the road. Through this course, you will also get the chance to learn the skills required for cycle maintenance. By the end of the course you will grasp the strategies to get the most out of your cycle. Whether you want to participate in races or just want to use a cycle as a means of transport, this is the perfect course. Enrol today! Course Preview Learning Outcomes Understand the strategies for buying the right cycle Get introduced to the essential fittings and accessories Improve your riding skills Develop the ability to keep your cycle in top shape Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email What Skills Will You Learn from This Course? Cycling Cycle Maintenance Who Should Take This Cycling Essentials Course? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Cycling Essentials course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Cycling Essentials Certification After completing and passing the Cycling Essentials course successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Path​ This exclusive Cycling Essentials course will equip you with effective skills and abilities and help you explore career paths such as  Cyclist Cycling Coach Fitness Professional Module 01: How To Buy A Cycle How to Buy a Cycle 00:22:00 Module 02: Fitting And Accessories Fitting and Accessories 00:27:00 Module 03: Road Skills Road Skills 00:43:00 Module 04: Cycling In The Real World Cycling in the Real World 00:38:00 Module 05: Cycle Maintenance Cycle Maintenance 00:32:00 Module 06: Getting The Most Out Of Cycling Getting the Most Out of Cycling 00:45:00 Assignment Assignment - Cycling 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Cycling Essentials
Delivered Online On Demand3 hours 27 minutes
£11.99