3079 Courses in Liverpool delivered Online

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Excel 2016 Advanced Formulas and Functions Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Excel 2016 Advanced Formulas and Functions Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Excel 2016 Advanced Formulas and Functions Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Excel 2016 Advanced Formulas and Functions Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Excel 2016 Advanced Formulas and Functions? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Excel 2016 Advanced Formulas and Functions there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Excel 2016 Advanced Formulas and Functions course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Excel 2016 Advanced Formulas and Functions does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Excel 2016 Advanced Formulas and Functions was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Excel 2016 Advanced Formulas and Functions is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Advanced Functions Work with Ranges 00:18:00 Use Specialized Functions 00:12:00 Work with Logical Functions 00:24:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:13:00 Trace Cells 00:06:00 Watch and Evaluate Formulas 00:09:00 Automating Workbook Functionality Search for Invalid Data and Formulas with Errors 00:04:00 Troubleshoot Invalid Data and Formula Errors 00:08:00 Other Functions and Formulas Use Text Functions 00:34:00 Use Specialized Functions 00:44:00 Use Date Functions 00:12:00 Use Financial Functions 00:26:00 Automate SUM Functions 00:36:00

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

Overview This comprehensive course on New Functions in Microsoft Excel 2021 will deepen your understanding on this topic.After successful completion of this course you can acquire the required skills in this sector. This New Functions in Microsoft Excel 2021 comes with accredited certification which will enhance your CV and make you worthy in the job market.So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this New Functions in Microsoft Excel 2021. It is available to all students, of all academic backgrounds. Requirements Our New Functions in Microsoft Excel 2021 is fully compatible with PC's, Mac's, Laptop,Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 1 sections • 10 lectures • 01:11:00 total length •Introduction and Agenda: 00:07:00 •RANDARRAY: 00:04:00 •UNIQUE: 00:05:00 •SEQUENCE: 00:04:00 •SORT and SORTBY: 00:09:00 •SORT A Practical Example: 00:04:00 •FILTER: 00:07:00 •FILTER A Practical Example: 00:08:00 •Other Useful New Functions: 00:15:00 •Using the New Functions in Reports: 00:08:00

Course Overview Enjoy better spreadsheet management and learn how to carry out everyday data-based tasks in Excel with expertise, with this complete Excel functions masterclass.  Through video guidance, the Simple but Powerful Functions in Microsoft Excel course will take you through the basic functions and features of Excel step-by-step. You will learn how to create pivot tables, use text formulas, search a value in a column, and carry out other typical spreadsheet tasks, gaining valuable office skills that will help you gain a competitive edge in your field. Are you looking to build your efficiency in Excel? Go from beginner to expert and build full proficiency in no time, by mastering Excel's core functions today. No previous experience is needed to take this course. Enrol as a full-time or part-time learner and add new skills to your CV. This best selling Simple but Powerful Functions in Microsoft Excel has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Simple but Powerful Functions in Microsoft Excel is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Simple but Powerful Functions in Microsoft Excel is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Simple but Powerful Functions in Microsoft Excel is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Simple but Powerful Functions in Microsoft Excel, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Simple but Powerful Functions in Microsoft Excel will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Simple but Powerful Functions in Microsoft Excel to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Dr Rebecca Ashton will guide you in developing a broad range of knowledge and skills around Executive Functions. From understanding what EFs are, to equipping you with the formulation, assessment, intervention and consultation skills to confidently use EFs within casework and improve outcomes for CYP. Designed for Educational Psychologists by Educational Psychologists.

New Excel Functions   Course Description   Ross Maynard     Description In the second half of 2020 Microsoft released a significant upgrade to the most used spreadsheet programme in the world. Microsoft Excel now offers the ability to handle dynamic arrays – functions that return a range of results that update as the source data changes. In this course, we discuss the power of dynamic arrays and introduce the new functions. The functions I am going to cover are: RANDARRAY- creating a table of random numbers or random dates UNIQUE – identifying the distinct items in a list SEQUENCE – listing numbers with a set interval SORT and SORTBY – new ways of dynamically sorting data FILTER – building the ability to filter data into formulae XLOOKUP – replacing VLOOKUP with greater flexibility IFS and SWITCH making it easier to construct IF statements The new CONCAT, and TEXTJOIN text functions   If you have an earlier version of Microsoft Excel then these functions will not be available to you and this course might not be for you. But if you do have a subscription to Office365 – either personally or through your work – I think you will find this course extremely useful.         Learning Outcomes Participants in this course will learn: What the new dynamic arrays feature in Microsoft Excel means How the new RANDARRAY function works How the new UNIQUE function works How the new SEQUENCE function works How the new SORT and SORTBY functions work How the new FILTER function works How the new XLOOKUP function can replace VLOOKUP How to build IF statements with the new IFS function How the new SWITCH function works How the new TEXTJOIN function can replace CONCATENATE and CONCAT How the new functions can be used in management reporting     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

Overview This comprehensive course on Excel Must know Formulas and Functions will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel Must know Formulas and Functions comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Excel Must know Formulas and Functions. It is available to all students, of all academic backgrounds. Requirements Our Excel Must know Formulas and Functions is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 13 lectures • 01:53:00 total length •Building basic math formulas: 00:08:00 •Autosum and Relative references: 00:09:00 •Absolute references: 00:06:00 •Named Ranges: 00:06:00 •Linking sheets and workbooks: 00:06:00 •If, And, Or, and the nested If functions: 00:16:00 •Countif, Sumif, Averageif, Sumifs, and Countifs functions: 00:09:00 •Vlookup and Hlookup functions: 00:15:00 •Match and Index functions: 00:07:00 •Date and time formulas and functions: 00:12:00 •Text functions: 00:11:00 •Tracing formulas: 00:08:00 •Assignment - Excel Must know Formulas and Functions: 00:00:00

Overview This comprehensive course on Learn Trigonometry and Trigonometric Functions will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Learn Trigonometry and Trigonometric Functions comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Learn Trigonometry and Trigonometric Functions. It is available to all students, of all academic backgrounds. Requirements Our Learn Trigonometry and Trigonometric Functions is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 7 sections • 54 lectures • 10:40:00 total length •Course Promo: 00:02:00 •Number Tools: 00:10:00 •Graphing Tools: 00:06:00 •The Coordinate Plane: 00:06:00 •Introduction: 00:01:00 •The Unit Circle: 00:08:00 •Terminal Points: 00:31:00 •Reference Number: 00:22:00 •Trigonometric Functions: 00:12:00 •Evaluating Trigonometric Functions: 00:14:00 •Graph of Sine & Cosine: 00:24:00 •Sine & Cosine Graph Transformations: 00:17:00 •Tangent & Cotangent Graphs: 00:20:00 •Secant & Cosecant Graphs: 00:25:00 •Domain and Range of Sin, Cos and Tan: 00:22:00 •Examples: 00:13:00 •Domain and Range of Sec, Csc and Cot: 00:13:00 •Examples: 00:16:00 •Introduction: 00:01:00 •Angles: 00:16:00 •Standard Position: 00:08:00 •Trigonometric Ratios: 00:15:00 •Examples: 00:13:00 •Special Angles: 00:24:00 •Examples: 00:05:00 •Reference Angle: 00:14:00 •Evaluating Trig Functions and Points: 00:18:00 •Inverse Trigonometric Functions: 00:12:00 •The Law of Sines: 00:13:00 •The Law of Cosines: 00:10:00 •Area of a Triangle: 00:08:00 •Introduction: 00:01:00 •Fundamental Identities: 00:10:00 •Examples: 00:18:00 •Addition and Subtraction Formulas: 00:15:00 •Sums of Sines and Cosines: 00:07:00 •Double Angle Formulas: 00:10:00 •Half Angle Formulas: 00:08:00 •Formulas for Lowering Powers: 00:05:00 •Sum-to-Product Formulas: 00:06:00 •Product-to-Sum Formulas: 00:05:00 •Polar Coordinates: 00:19:00 •Polar and Rectangular Coordinates: 00:11:00 •Polar Equations: 00:07:00 •Graph of Polar Equations: 00:18:00 •Symmetry: 00:17:00 •Common Polar Curves: 00:12:00 •Graphing Complex Numbers: 00:06:00 •Modulus: 00:04:00 •Polar Form of Complex Numbers: 00:09:00 •Multiplication and Division: 00:07:00 •De Moivre's Theorem: 00:05:00 •nth Roots of a Complex Number: 00:21:00 •Resource - Learn Trigonometry and Trigonometric Functions: 00:00:00

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Powerful Functions in Microsoft Excel course will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Powerful Functions in Microsoft Excel course will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Powerful Functions in Microsoft Excel and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Powerful Functions in Microsoft Excel course is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Powerful Functions in Microsoft Excel course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. 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. Career path The Powerful Functions in Microsoft Excel will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Powerful Functions in Microsoft Excel Introduction 00:03:00 Basic Functions 00:12:00 Date Functions 00:09:00 Random Numbers 00:09:00 IFS so many IFS 00:11:00 Text Functions 00:13:00 Logical Functions 00:09:00 Creating a Drop-Down List 00:05:00 VLOOKUP and XLOOKUP 00:09:00 Pivot Tables 00:08:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Trigonometry and Trigonometric Functions Teaching is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Trigonometry and Trigonometric Functions Teaching and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 11 hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Course Promo Course Promo 00:02:00 Module 01: Fundamentals Number Tools 00:10:00 Graphing Tools 00:06:00 The Coordinate Plane 00:06:00 Module 02: Trigonometry Unit Circle Approach Introduction 00:01:00 The Unit Circle 00:08:00 Terminal Points 00:31:00 Reference Number 00:22:00 Trigonometric Functions 00:12:00 Evaluating Trigonometric Functions 00:14:00 Graph of Sine & Cosine 00:24:00 Sine & Cosine Graph Transformations 00:17:00 Tangent & Cotangent Graphs 00:20:00 Secant & Cosecant Graphs 00:25:00 Domain and Range of Sin, Cos and Tan 00:22:00 Examples 00:13:00 Domain and Range of Sec, Csc and Cot 00:13:00 Examples 00:16:00 Module 03: Trigonometry: Right Triangle Approach Introduction 00:01:00 Angles 00:16:00 Standard Position 00:08:00 Trigonometric Ratios 00:15:00 Examples 00:13:00 Special Angles 00:24:00 Examples 00:05:00 Reference Angle 00:14:00 Evaluating Trig Functions and Points 00:18:00 Inverse Trigonometric Functions 00:12:00 The Law of Sines 00:13:00 The Law of Cosines 00:10:00 Area of a Triangle 00:08:00 Module 04: Analytic Trigonometry Introduction 00:01:00 Fundamental Identities 00:10:00 Examples 00:18:00 Addition and Subtraction Formulas 00:15:00 Sums of Sines and Cosines 00:07:00 Double Angle Formulas 00:10:00 Half Angle Formulas 00:08:00 Formulas for Lowering Powers 00:05:00 Sum-to-Product Formulas 00:06:00 Product-to-Sum Formulas 00:05:00 Module 05: Polar Coordinates Polar Coordinates 00:19:00 Polar and Rectangular Coordinates 00:11:00 Polar Equations 00:07:00 Graph of Polar Equations 00:18:00 Symmetry 00:17:00 Common Polar Curves 00:12:00 Graphing Complex Numbers 00:06:00 Modulus 00:04:00 Polar Form of Complex Numbers 00:09:00 Multiplication and Division 00:07:00 De Moivre's Theorem 00:05:00 nth Roots of a Complex Number 00:21:00 Resources Resource - Learn Trigonometry and Trigonometric Functions 00:00:00