4407 Courses delivered Online

This course is designed to cater for trainers at all stages of their careers. This course will help you understand your audience, help them follow along and ensure that they are absorbing and understanding the lecture. This Course At A Glance Accredited by CPD UK Endorsed by Quality Licence Scheme Know how to teach effectively Understand the 4 learning styles Know how to keep your audience engaged Know how to use the buddy system to help them follow along Understand how to use visual aids correctly Know how to ensure your audience is understanding you properly Understand how to use the right tone and body language Know how to convince your audience with your voice Train The Trainer Course - All Levels (Part 2) Overview This Train The Trainer Course aimes to help those who aspire to become competent trainers or for trainers looking to enhance their existing skills and take it to another level. This course will provide current trainers with new, cutting-edge approaches to develop and deiver training while also enhancing their training skills. You'll learn how to maximise learning, engage adult learners, deal with difficult participants, and motivate them. In the end, you will discover how to use the perfect body language and tone to convince them. Upon successful completion of this Train The Trainer Course, you will be trained to train anyone or members of your own team and enhance their knowledge and skills about the most recent trends and best practises. Who should take this course? This Train The Trainer Course is primarily aimed at: Teachers Facilitators Team Leads Project Managers Training Professionals Founders and CEOs Business Professionals Entrepreneurs Technical Professionals Human Resource Managers Sales Professionals Instructional Designers This course is not, however, limited to any particular profession or line of employment. It might also be helpful to a wider spectrum of individuals who desire to improve and advance their training skills. Entry Requirements There are no academic entry requirements for this Train The Trainer Course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This Train The Trainer 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 can grasp from each section. In the assessment pass mark is 60%. Course Curriculum Introduction Introduction to Teach Effectively Keep Them Engaged Keep Them Engaged Intro The 4 Learning Styles Ask Recall Questions Ask Relevance Questions Ask Expert Questions Ask Questions Activity Give Targeted Directionals Use the Agree and See If You're Right Help Them Follow Along Refer to Hooks Use the Buddy System Use the Buddy System Ensure They Understand Ensure They Understand Introduction Use Etch-a-Sketch Effectively Use Visual Aids Correctly Use Visual Aids Correctly Give Benchmark Checks - Part 2 Use Effective Body Language and Tone Convince with Your Voice - Part 1 Convince with Your Voice - Part 2 Command With Your Body Show Genuine Enthusiasm Recognised Accreditation CPD Certification Service 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. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Quality Licence Scheme Endorsed The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees.     Certificate of Achievement Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.   FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Description: Bookkeeping and managing payrolls are very important for a company as they eventually need to keep books by law for at least 6 years. This has made accounting technicians or professionals in charge of a company's finances to learn the secrets behind professional bookkeeping. If you are a business owner yourself or acting as an accounts manager, you might feel the necessity of understanding bookkeeping and payroll management. These skills add values to your career and give you what it takes to stand out in the crowd by proving yourself by accurately record financial purchases, sales, and receipts. This course is designed especially for you to deliver the rules of bookkeeping and professional tips that will help you in the long run. After successfully completing this course, you will be able to handle any kind of accounting records, manage compensations of your employees, prepare professional invoices and also prepare statements that help your business to take better decision.The course is intended to prepare you get a complete control of the entire cycle of finance aspects of your company. Anybody facing this process would be in a position to add more value to their organizations and in the long run get greater expert and quicker growth. In this course you will learn the necessary skills, knowledge and information of Bookkeeping, Payroll Management & Career in Accounting.   Who is this course for? This course will be ideal for business owners and business professionals who would like to understand better the transactions and controls used in business. This course would be ideal for anyone who is interested in accounting as a future career. 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 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 Accounts & Payroll Management course will be very beneficial and helpful, especially to the following professionals: Payroll Administrator Accounting Clerk Bookkeeper Bookkeeping Assistant Account Assistant Office Administrator Office Manager Accounts Payable Clerk. Accounts Receivable Clerk. Payroll Clerk Staff Accountant. Accounting Career Basics A Career in Accounting: Tips on How You Can be Successful 00:30:00 Accountancy Auditing Careers 00:30:00 Accountancy Career Change 00:30:00 Accountancy Career: The Reasons Why You Should Choose Accounting 01:00:00 Accounting/Accountancy Career: Steps to Success 00:30:00 Accounting Auditing Careers 00:30:00 Accounting Careers in Pontypridd 00:30:00 Accounting Careers: Promising Opportunities and Tips 00:30:00 Accounting Dictionary 00:30:00 Accounting Principles and Tulsa 00:30:00 Accounting Software for Small Businesses 00:30:00 Accounting Terms - Profit, Loss and Other Terms 00:30:00 Accounting Career Fundamentals Accounting 00:30:00 Advanced Accounting Career Training 00:30:00 Careers in Accountancy 01:00:00 Church Accounting Software 00:30:00 Finding an Accounting Job 00:30:00 Forensic Accounting 00:30:00 Free Accounting Software 00:30:00 List of Accounting Careers 00:30:00 Services in Financial Accounting 00:30:00 Successful Career in Accounting Even if You're Hit Forty! 00:30:00 The Benefits of an Accountancy Career 00:30:00 Types of Accountancy Career 00:30:00 Bookkeeping & Payroll Basics Module One - Introduction 00:30:00 Module Two - Basic Terminology 01:00:00 Module Three - Basic Terminology (II) 01:00:00 Module Four - Accounting Methods 01:00:00 Module Five - Keeping Track of Your Business 01:00:00 Module Six - Understanding the Balance Sheet 01:00:00 Module Seven - Other Financial Statements 01:00:00 Module Eight - Payroll Accounting Terminology 01:00:00 Module Nine - End of Period Procedures 01:00:00 Module Ten - Financial Planning, Budgeting and Control 01:00:00 Module Eleven - Auditing Corporate Behavior 01:00:00 Module Twelve - Wrapping Up 00:30:00 Managing Payroll What Is Payroll? 00:30:00 Principles Of Payroll Systems 01:00:00 Confidentiality And Security Of Information 00:30:00 Effective Payroll Processing 01:00:00 Increasing Payroll Efficiency 01:00:00 Risk Management in Payroll 00:30:00 Time Management 00:30:00 Personnel Filing 00:30:00 When Workers Leave Employment 01:00:00 Hiring Employees 00:30:00 Paye and Payroll for Employers 01:00:00 Tell HMRC about a New Employee 01:00:00 Net And Gross Pay 00:30:00 Statutory Sick Pay 00:30:00 Minimum Wage for Different types of Work 01:00:00 Mock Exam Mock Exam- Bookkeeping, Payroll Management & Career in Accounting 00:30:00 Final Exam Final Exam- Bookkeeping, Payroll Management & Career in Accounting 00:30:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Product Management is the strategic nerve centre of successful business ventures. This course explores the full lifecycle of product development — from idea to execution — focusing on how to manage teams, define priorities, and align offerings with business goals. It blends insight, structure, and decision-making logic into a streamlined learning experience that speaks to aspiring and current professionals looking to shape market-ready products with clarity and intent. Without dipping into gimmicks, this course covers the fine art of keeping things simple while moving projects forward in fast-paced environments. Whether you're defining features or navigating shifting demands, you'll get to know how great product managers think, communicate, and keep calm under pressure — all with a dash of logic, some solid frameworks, and the occasional well-placed spreadsheet. Our Product Management course includes modules on: Product Classification Product Plan Product Life Cycle Pricing Strategy Brand Portfolio Analysis So if you're ready to get a head start in your Product Management career, enrol in this updated course. Meet the Endorsement The Quality Licence Scheme has been designed specifically to recognise high-quality courses. This Product Management course materials are recognised by Quality Licence Scheme (QLS). This ensures the deep research and quality resource allocation behind the development phase of the course. In addition, the QLS certificate enriches your CV and recognises your quality study on the relevant subject. Meet the Accreditation CPD Quality Standards (CPD QS) accreditation assure the Product Management course training and learning activities are relevant, reliable, and upto date. Expert Support Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course. Key Benefits Learning materials of the Design course contain engaging voiceover and visual elements for your comfort. Get 24/7 access to all content for a full year. Each of our students gets full tutor support on weekdays (Monday to Friday) This 10-module Product Management course includes a range of audio, guides, resources, and quizzes to help you kick-start your career. Course Curriculum: Module 01: Introduction to Product Management In this module, you will learn the importance and impact of product management. You will also get informed about the job responsibilities of a product manager. Module 02: Product Classification Products are organised for a variety of purposes which are known as classification. In this module, you will learn the classification of products. You will learn about the product categories and their subcategories. Module 03: Developing the Product Plan In this module, you will learn the steps of developing a plan for product management. We will also give you insightful ideas about creating an effective planning process. Module 04: New Product Development In this module, you will learn all the activities for developing a new product. We will also give you ideas about prototype testing before launching a new product. Module 05: Levels of a Product and Product Life Cycle In this module, you will learn the different levels of a product. We will introduce you to different stages of a product life cycle. Module 06: Product Pricing Strategy This module will teach you the effective strategy and tactics needed for setting product prices. We will also give you ideas that work on how you can initiate price changes. Module 07: Product and Brand Portfolio Analysis In this module, you will learn the process of brand equity management. We will also elaborate on the advantages of brand building. Module 08: Channels Management In this module, you will learn the process of Channel management. We will also introduce different types of channels to you. Module 09: Basics of Marketing for Products In this module, you will learn about the marketing mix for your products. Also, we will elaborate on the four core Ps and three additional Ps of the marketing mix. Module 10: Financial Analysis for Product Management In this module, you will learn the process of necessary financial calculations for product management. We will also delve deep and provide insightful information for effective sales and profitability analysis. Course Assessment To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%. When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme. Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme After successfully completing the Product Management course, learners will be able to order an endorsed certificate as proof of their achievement. Hardcopy of this certificate of achievement endorsed by the Quality Licence Scheme can be ordered and received straight to your home by post, by paying Within the UK: £69 International: £69 + £10 (postal charge) = £79 CPD Accredited Certification from One Education After successfully completing this Product Management course, you will qualify for the CPD accredited certificate from One Education. Certification is available in both PDF & hardcopy format, which can be received by paying - PDF Certificate: £9 Hardcopy Certificate (within the UK): £15 Hardcopy Certificate (international): £15 + £10 (postal charge) = £25 CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Product Management course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge. Requirements No formal requirements -anyone interested to learn about Product Management can enrol and start learning. Career path This Product Management course certificate will enrich your CV and increase your probability of getting hired or promoted. This course will help you to pursue a career in Project Management Digital Project Management Construction Management Process Engineering Product Development Program Management

This course reveals the secrets to making your business viral and employing the power of social media to grow your business as well as your career. From a thorough introduction of social media, auditing social media to setting goals and selecting the right platforms, creating the social media policy, you will gain relevant knowledge, skills and competencies needed to excel at social media marketing. This comprehensive course also provides invaluable insights into integrating marketing strategies, developing compelling content, and understanding the most popular platforms that have high potential to get you better results faster and quicker. In just 9 Hours 40 Minutes you will: Develop a great grounding and skillset to enter into the world of social media Discover how Social Media Marketing works and why people use it Learn to connect with people through social media and grow your visibility Successfully build a social media strategy for your business Experience the broad scope of social media Develop a foolproof social media marketing campaign Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate. Who is this course for? Social Media Marketing Strategy is suitable for anyone who want to gain extensive knowledge, potential experience and expert skills in the related field. This course is designed by industry experts so you don't have to worry about the quality. Most importantly, this course does not require any experience or lesson to get enrolled. You will learn everything that is required from this course directly. This is a great opportunity for all students from any academic backgrounds to learn more on this subject. This lesson is ideal for: Social Media Specialists Digital Marketers Sales Managers Public Relations Managers Office Managers Small Business Owners

Do you want to hire top candidates quickly? Do you want to free up your schedule from recruiting so you can focus on other aspects of your job? Do you want to turn your hiring efforts into a scalable, repeatable recruitment system? Learn how we reduced our time-to-hire while improving hiring quality in our simple online Level 3 Recruitment Training for HR Course. Recruitment HR Consultants collaborate closely with businesses and potential employees to find the best candidate for a job opening. This includes understanding the recruitment needs of each company with which you work and having an eye for selecting the best candidates from among all those looking for work. Learning Outcome Discover the importance of hiring the right employees during the Recruitment process Learn how to deal with the frustration of not being able to find the right candidate for a job. Get an overview of the UK recruitment industry, including UK recruitment legislation. Develop your sales skills and learn why they are so important as a Recruitment Consultant Take an in-depth look at every stage of the recruitment process Learn how to attract the best candidate for any position you're looking to fill. Understand the importance of candidate management Discover the candidate interview process and the follow-up questions you should ask your clients and candidates. Key Features CPD Accredited Instant FREE PDF certificate and a hard copy included Fully online, interactive Recruitment for HR course with audio voiceover Developed by qualified HR professionals Self-paced learning and laptop, tablet, and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Additional Gifts HR Management Course This Recruitment Training for HR course is for you if you want to make great hires. The Recruitment Training for HR is designed to expand your skill set and develop your expertise so that you can always present the best candidates for the job. Learn how to develop close relationships with employers and employees in order to make long-lasting connections and ensure professional success. The Recruitment Training for HR course also teaches you about each stage of the process so that you can offer expert advice to potential hires and prepare them for success. So enrol in the course right away to pursue your dream of becoming a Recruitment Consultant. Course Curriculum The detailed curriculum outline of our Recruitment Training for HR is as follows: Module 01: Introduction to the Recruitment Process Model Module 02: Recruitment Method Module 03: HR Human Resource Management Module 04: Key Skills and Issues in Recruitment Module 05: Virtual Interviewing Module 06: Employee On-Boarding Accreditation This Recruitment Training for HR course is fully CPD accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Recruitment Training for HR course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we do recommend that you renew them every 12 months. Assessment At the end of the Recruitment Training for HR course, there will be an online assessment, which you will need to pass to complete the course. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Recruitment Training for HR course is ideal for: Recruiters and human resource professionals looking to make great hires Entrepreneurs or business owners who are in charge of their own hiring process Team leaders who need to recruit or filter through internal candidate applications Anyone who is interested to learn more about recruiting. Requirements Learners do not require any prior qualifications to enrol on this Recruitment course. Career path After completing this Recruitment course course, you can explore trendy and in-demand jobs, such as HR Coordinator Payroll Coordinator Recruiting Coordinator HR Specialist Recruiter Human Resource Information Specialist (HRIS) HR Manager Recruiting Manager Compensation and Benefits Manager HR Business Partner These professionals typically make between £35k to £75k per annum in the United Kingdom Certificates Certificate of completion Hard copy certificate - Included You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each. Certificate of completion Digital certificate - Included

So, the Project Manager's Starter Kit features our Project Management Fundamentals course. Four straightforward videos built around the same four-stage as all our core programs. Take a look...

Duration 3 Days 18 CPD hours This course is intended for This class is ideal for business users - the people who need to learn what's possible with Salesforce functionality across the suite of products, but aren't necessarily responsible for managing the application. If you're a customer service manager, business executive, business operations manager, sales operations manager, or any other operations, management, or process analysis 'super user,' this class is just what you need to better understand the business value of the Salesforce Platform. Overview Describe the primary business value of each major Salesforce Cloud. Manage users and data. Manage basic org configuration. Create email templates. Create reports and dashboards. Apply and champion Chatter. Understand the Salesforce implementation and maintenance lifecycle. Extend Salesforce functionality beyond basic configuration. Explore what?s possible with Salesforce. In this 3-day class, our Salesforce experts will walk you through the Salesforce Platform, its specific applications, and their business values and benefits. Familiarize yourself with Salesforce Cloud, and learn about platform features and processes to more effectively support day-to-day Salesforce operations within your organization. Through interactive lectures, discussions, and hands-on exercises, you?ll recognize the core elements of the implementation lifecycle, the key considerations to drive user adoption, and the important components of ongoing management of your Salesforce environment. Introduction Understand How Salesforce Works Explore Salesforce Applications Review Salesforce Organization Data Access and Security Control Org Access Manage Who Views and Modifies Objects Unlock Access to Records Share Access to Records Lock Down Individual Fields User Management and Troubleshooting Create New Users Troubleshoot Login, Record Access, and Field Visibility Issues Salesforce Customizations Think About Your Implementation Explore Custom Fields, Picklists, Page Layouts, and Record Types Create Email Templates Business Processes Automation Review Validation Rules Review Assignment and Escalation Rules Review Web-to-Lead and Entitlements Review Lightning Process Builder and Workflow Review Approval Processes and Visual Workflow Reports Explore the Reports Tab, Folders, and Formats Explore the Report Builder Summarize Your Data Dashboards and Data Insights Get More Insight from Your Data Visualize Your Data with Dashboards Create Your Analytics Strategy Everyday Salesforce Collaborate with Chatter, Groups, and Communities Share Feedback with Chatter Answers and Ideas Go Mobile with Salesforce1 Make Salesforce Part of Your Day Data Management Create a Data Migration Strategy Ensure Data Quality Extending Salesforce Drive a Salesforce Implementation Customize Salesforce Using Custom Objects, Apps, and the Salesforce AppExchange Build It Yourself Wrap-up and Certification Review the Certification Process and Resources

Duration 2.25 Days 13.5 CPD hours This course is intended for The job roles best suited to the material in this course are: sales personnel, accountants, administrators, auditors, lab assistants, office job positions. Overview Work with functions. Work with lists. Analyze data. Visualize data with charts. Use PivotTables and PivotCharts. Work with multiple worksheets and workbooks. Share and protect workbooks. Automate workbook functionality. Use Lookup functions and formula auditing. Forecast data. Create sparklines and map data This course provides the knowledge to create advanced workbooks and worksheets that can deepen the understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it and present that information to decision makers. In addition this course will give you the ability to collaborate with colleagues, automate complex or repetitive tasks and use conditional logic to construct and apply elaborate formulas and functions which will allow you to work through a lot of data and generate the answers that your organisation needs. WORKING WITH FUNCTIONS Topic A: Work with Ranges Topic B: Use Specialized Functions Topic C: Work with Logical Functions Topic D: Work with Date and Time Functions Topic E: Work with Text Functions WORKING WITH LISTS Topic A: Sort Data Topic B: Filter Data Topic C: Query Data with Database Functions Topic D: Outline and Subtotal Data ANALYZING DATA Topic A: Create and Modify Tables Topic B: Apply Intermediate Conditional Formatting Topic C: Apply Advanced Conditional Formatting VISUALIZING DATA WITH CHARTS Topic A: Create Charts Topic B: Modify and Format Charts Topic C: Use Advanced Chart Features USING PIVOTTABLES AND PIVOTCHARTS Topic A: Create a PivotTable Topic B: Analyze PivotTable Data Topic C: Present Data with PivotCharts Topic D: Filter Data by Using Timelines and Slicers WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS Topic A: Use Links and External References Topic B: Use 3-D References Topic C: Consolidate Data SHARING AND PROTECTING WORKBOOKS Topic A: Collaborate on a Workbook Topic B: Protect Worksheets and Workbooks AUTOMATING WORKBOOK FUNCTIONALITY Topic A: Apply Data Validation Topic B: Search for Invalid Data and Formulas with Errors Topic C: Work with Macros USING LOOKUP FUNCTIONS AND FORMULAS AUDITING Topic A: Use Lookup Functions Topic B: Trace Cells Topic C: Watch and Evaluate Formulas FORECASTING DATA Topic A: Determine Potential Outcomes Using Data Tables Topic B: Determine Potential Outcomes Using Scenarios Topic C: Use the Goal Seek Feature Topic D: Forecast Data Trends CREATING SPARKLINES AND MAPPING DATA Topic A: Create Sparklines Topic B: Map Data

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

This online course covers how technical communicators can use Generative Artificial Intelligence to help them: Be more efficient Create better deliverables for their users We went through all the key stages in a technical writing project. At each step, we investigated whether AI tools like ChatGPT and Claude could make a Technical Writer's job easier and better. After a lot of research and testing, we ended up with the content for this course. The course provides a framework that attendees can use to identify opportunities and best practices for integrating ChatGPT, Claude, LLaMA, and similar tools into their technical authoring processes – creating, managing, and delivering technical content. Why attend this course? Integrating AI and natural language processing technologies promise to make Technical Writers more efficient and more effective at what they do. By attending this course, you’ll gain a better understanding of how generative AI can be used by technical communicators. You learn a framework you can use for using tools such as ChatGPT at the different stages of a technical writing project. Who is this course for? This course is for people who have some experience of technical writing, and who want to improve their skills. What will I learn? You’ll learn and practice: What are AI technologies and their relevance to technical writing? Career opportunities and threats How you can use AI at different stages of the documentation process. We cover topics such as planning, writing, reviewing, and production. How to work more efficiently. How to work more effectively. The course does not go into much detail about using generative AI to create images, audio or videos. Learning Materials The course comprises online training modules (4.75 hours of video, plus handouts), which you can complete at your own pace. The course modules are delivered over the Web in small, manageable video presentations. You can pause the videos at any time and return to the course at times that suit you. The course is roughly equivalent to a 1.5 days long classroom course. Examples The modules describe practical examples and techniques you can use right away. Demonstrations The modules contain demonstrations of the techniques and tools when they’re applied to technical writing. Exercises You’ll be given exercises to work on throughout the course. This is a great way to put your learning to practice. Your Instructor Cherryleaf Cherryleaf is a technical writing services company formed in 2002 by people with a passion for technical communication and learning development. Cherryleaf is recognised as a leader within the technical communication profession. Our staff have written articles for the Society for Technical Communication's (STC) Intercom magazine, the Institute of Scientific and Technical Communicator's Communicator journal and tekom's TCWorld magazine. They've also written books on technical communication. We've presented webinars for Adobe, Madcap Software or the STC, and we've spoken at various conferences around the world. Today, organisations throughout Europe use Cherryleaf’s services so they can provide clear information that enables users and staff to complete tasks productively. Course Curriculum Introduction Introduction (0:56) ChatGPT and AI Basics What do the buzzwords mean? (18:19) Using ChatGPT and similar tools - Software and Websites (15:30) Prompt Engineering (17:23) Why use generative AI? Why use generative AI? (5:37) The limitations of Large Language Models (LLMs) and AI systems (7:48) Data security (10:09) Legal considerations (2:59) Quiz Section summary  Frequently Asked Questions When does the course start and finish? The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.How long do I have access to the course?After enrolling, you have 12 months access to this course for as long as you like - across any and all devices you own.What if I am unhappy with the course?We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 14 days and we will give you a full refund.