4618 Consultant courses delivered Online

If you are planning for a thriving career in HR this course is perfect for you. It provides tools necessary to optimise your workforce and resources for success. Enrol now and take the first step towards a successful career in HR.

Learn the essentials of international law and human rights with our comprehensive course. Perfect for aspiring lawyers, policy-makers, and activists. Enrol now to make a global impact!

Master the essentials of primary teaching with our Level 5 Primary Teaching Training course. Explore the UK education system, learn about early years education, teaching techniques, and more. Perfect for aspiring primary school teachers and teaching assistants

Learn the fundamental principles of athlete representation and sports management with our Accredited Sports Agent Training. Gain insights into the duties and responsibilities of sports agents, understand their social and economic impact, and acquire essential skills in brand building, networking, and sponsorship.

Learn furniture restoration and design with our comprehensive course. Master wood and upholstery techniques, restore antiques, and undertake practical DIY projects. Gain a globally recognised CPD certificate and explore career opportunities in the UK.

Discover the world of TikTok marketing with our TikTok Social Media Marketing Course. Learn the essential strategies and techniques to harness the power of TikTok for your marketing efforts.

Unlock professional skills in hair removal with our Waxing and Threading Online Course. Learn waxing, threading, client care, and salon safety for flawless results.

Description Microsoft Excel has hundreds, if not thousands, of functions and features. This course aims to cover some of the best – that is the ones I find most useful. In “Adventures in Excel”, I cover the simple-to-use but powerful functions that I use most often: Basic features including products and powers Key date functions including the calculation of due dates and days past due Generating random numbers and random dates The new IFS functions (new to Office365) Text functions The most useful logical functions and IS functions How to create a drop-down list The new XLOOKUP function Pivot tables   These functions are easy to use, and, unless your role is extremely specialised, they are probably the ones you’ll use 90% of the time. I hope you find the course helpful.   Learning Outcomes Participants in this course will learn: Basic Excel functions including SUM, AVERAGE, MIN, MAX, PRODUCT, POWER and SQRT Useful date functions including TODAY, EOMONTH, EDATE, and DAYS Generating random numbers using RAND and RANDBETWEEN; generating random dates; and randomly picking an item from a list or table The new RANDARRAY function in Office365 The new IFS functions in Office365 including AVERAGEIFS, MAXIFS, MINIFS, COUNTIFS, and SUMIFS Text functions including TRIM, LOWER, UPPER, PROPER, LEFT, MID, RIGHT, FIND, TEXTJOIN and CONCATENATE Logical functions AND, OR, and NOT and IS functions ISTEXT, ISNUMBER, ISBLANK and ISERROR How to create a drop-down list The new SORT and FILTER functions in Office365 VLOOKUP and the new XLOOKUP function How to create a Pivot table and analyse data with one     Course Requirements There are no pre-course requirements.   Additional Resources Course Spreadsheet with the examples covered.     About Ross Ross Maynard is a Fellow of the Chartered Institute of Management Accountants in the UK. He is director of Ideas2Action Process Excellence Ltd and has 30 years’ experience as a process improvement consultant and facilitator. Ross is also a professional author of online training courses for accountants. Ross lives in Scotland with his wife, daughter and Cocker Spaniel

This course is your key to fostering a culture of safety and well-being. Ensure a productive, healthy work environment for everyone.

Unlocking Google Ranking is a comprehensive course designed to empower learners with the knowledge and skills required to master the art of Google My Business and secure top positions in the Google Map Pack. In the age of digital dominance, the significance of Google My Business cannot be overstated, making this course an indispensable asset for anyone seeking to elevate their local business. Dive into this creative and immersive learning journey, and let the world of Google ranking unfold before your eyes. The course starts with an enticing introduction, painting a vivid picture of what lies ahead. As you delve deeper, you'll realize why Microsoft Office is an essential tool in mastering Google My Business. Through meticulously designed lectures, you'll understand the intricacies of setting up your Google My Business page, determining your service distance, selecting the perfect business category, and crafting an enticing business introduction. The course also takes you on a captivating journey into the world of image tagging and insights analysis within Google My Business, helping you optimize your profile to reach that coveted 100% completeness. Unlocking Google Ranking also explores the critical role of reviews in local business success, and it uncovers the secrets to effectively managing and generating reviews. As you progress, you'll appreciate how Microsoft Office can be a game-changer in this domain. The course culminates by guiding you towards mastering the art of ranking in the top three positions in the Google Map Pack, paving the way for unparalleled success in local SEO. Learning Outcomes: Master the setup of Google My Business pages, maximizing their potential for local business growth. Gain an in-depth understanding of the importance of reviews and how to manage and generate them effectively. Unlock the power of Microsoft Office for optimizing your Google My Business profile. Learn the secrets of local SEO and how to secure top positions in the Google Map Pack. Achieve a complete Google My Business profile with 100% optimization, increasing your visibility and attracting more customers. Course Description: Unlocking Google Ranking is a dynamic course that takes you on an educational journey through Google My Business, reviews management, and local SEO. With Microsoft Office as your trusty companion, you'll navigate through a meticulously crafted curriculum, ensuring that you don't miss a single step in your quest to conquer the digital landscape. Who Is This Course For? Small business owners looking to enhance their online presence and attract local customers. Marketing professionals seeking to sharpen their local SEO skills. Entrepreneurs and startups aiming to establish a strong digital footprint. E-commerce businesses desiring better visibility in local search results. Digital marketing enthusiasts eager to explore the world of Google ranking. Certification If you are a newbie to managing a WordPress website, then congratulations! You are here at the right track with us because we are going to introduce you one of the most basic knowledge when owning a WordPress page: how to find your site the best WordPress Hosting service. This process is often overlooked by most of the website owners. But it can be considered the most important key point to bring your site to stand out of the crowd. A great hosting service could help you to improve SEO and increase sales as well. Career path Digital Marketing Manager: £30,000 - £50,000 per annum SEO Specialist: £25,000 - £45,000 per annum Small Business Owner: Earnings vary based on business success Marketing Coordinator: £20,000 - £35,000 per annum E-commerce Manager: £25,000 - £50,000 per annum Freelance SEO Consultant: Hourly rates range from £20 to £100 Course Content Section 1: Introduction To The Course Lecture 1 What To Expect In This Course Lecture 2 Why Having Google My Business is Critical For Every Local Business Section 2: Getting Started With Google My Business Lecture 3 Intro To Google My Business Lecture 4 An Example Google My Business Page Setup Lecture 5 Setting Your Service Distance & Address Lecture 6 Selecting The Best Business Category Lecture 7 Creating a Good Introduction For Your Page Lecture 8 Tagging Photos Inside Of Google My Business or Using Picasa Lecture 9 Bulk Tagging Photos With a Location Lecture 10 Viewing Insights About Your Business Lecture 11 A Completed Google My Business Profile - Getting to 100% Section 3: Getting Reviews For Your Business Lecture 12 Why Reviews Are So Important Lecture 13 Responding To Reviews Lecture 14 Grade.us Lecture 15 The Review Handout Generator Section 4: Ranking In The Top 3 Positions in the Google Map Pack Lecture 16 Where To Go From Here - Learning About Local SEO