Our Aim Is Your Satisfaction! Offer Ends Soon; Hurry Up!! Are you looking to improve your current abilities or make a career move? Our unique Management and Leadership Development Programme course might help you get there! Expand your expertise with high-quality training - study the Management and Leadership Development Programme course and get an expertly designed, great-value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through theonline training course. The HR & Leadership Management Diploma Offers the Following Courses with Free Certificate: Course 01: Strategic Business Management Course 02: Financial Management Course 03: Diploma in Performance Analysis The Management and Leadership Development Programme course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Management and Leadership Development Programme course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this course. This Management and Leadership Development Programme training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Why Prefer Us? Opportunity to earn a certificate accredited by CPDQS. Get a free student ID card!(£10 postal charge will be applicable for international delivery) Innovative and Engaging Content. Free Assessments 24/7 Tutor Support. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Management and Leadership Development Programme course: Introduction to Manager: Management Course Objectives Module 01: Grooming a New Manager Set Specific Goals Authority (What They Can and Can't Do) Create a Shared Vision The More They Learn, the More Responsibility They Get Module 02: Coaching and Mentoring (I) Writing Performance Reviews Provide Clear and Timely Feedback Praise in Public, Criticize in Private Make Sure Your Door is Always Open Module 03: Coaching and Mentoring (II) Offer Advice, Not the Solution Create a Supportive Environment Build Ownership 360 Degree Feedback Module 04: Measuring Performance Staying Within Their Budget Setting Measurable Objectives Skip Level Feedback Collaborate on Criteria to be Evaluated Module 05: Motivating Managers Provide the Needed Resources Bonuses and Incentives Give Credit for Good Work Keep Them Challenged Module 06: Signs of Poor Management Missed Deadlines Team Turnover Losing Customers Little or No Growth Module 07: Trust Your Team of Managers Do Not Micromanage Promote Open and Honest Communication Reward Initiative Trust, But Verify Module 08: When an Employee Complains About Their Manager Keep the Information Confidential Gather Information from Both Sides Coach or Delegate the Solution Follow-up with the Manager or Employee Module 09: When Do You Step In? Unsafe or Dangerous Events Legal Ramifications Severe Financial Costs Repeated Failures after Coaching Has Occurred Module 10: Remember These Basic Qualities Express Confidence in Their Abilities Practice What You Preach Have an Open Door Their Success is Your Success Assessment Process Once you have completed all the modules in the Management and Leadership Development Programme course, you can assess your skills and knowledge with an optional assignment. Certificate of Completion The learners have to complete the assessment of this Management and Leadership Development Programme course to achieve the CPDQS accredited certificate. Hard Copy Certificate: £29 (Inside UK) Hard Copy Certificate: £39 (for international students) CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this Management and Leadership Development Programme course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career.
Our Aim Is Your Satisfaction! Offer Ends Soon; Hurry Up!! Are you looking to improve your current abilities or make a career move? Our unique Hormone Health & Testosterone Certification course might help you get there! Expand your expertise with high-quality training - study the Hormone Health & Testosterone Certification course and get an expertly designed, great-value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through theonline training course. The Hormone Health & Testosterone Certification course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Hormone Health & Testosterone Certification course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this course. This Hormone Health & Testosterone Certification training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Why Prefer Us? Opportunity to earn a certificate accredited by CPDQS. Get a free student ID card!(£10 postal charge will be applicable for international delivery) Innovative and Engaging Content. Free Assessments 24/7 Tutor Support. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Hormone Health & Testosterone Certification course: Introduction Course Overview & What you will learn The Endocrine System Explained Hormones Introduction The 3 Types Of Hormones The Endocrine System explained Cholesterol, Hormones And Heart Disease Anabolic Steroids - Why You Should Avoid Them Individual Hormones Explained Overview: Most Important Hormones Insulin Glucagon Adrenaline Cortisol Ghrelin Leptin Thyroid Hormones Estrogen Growth Hormone Testosterone Optimizing Testosterone Levels: Introduction Testosterone Explained Why Testosterone Is Also Important For Women How To Check If You Suffer From Low Testosterone Levels Diet Strategies To Boost Testosterone & Balance Hormones Diet Introduction Calories & Testosterone Carbohydrates & Testosterone Fat & Testosterone Protein & Testosterone Meal Timing & Testosterone Setting Up Your Diet Setting Up Your Diet Overview How To Determine Your Calorie Maintenance Level (TDEE) How To Track Calories Ideal Protein Intake Ideal Fat Intake What About The Remaining Calories Determining Meal Structure Quality Protein Foods Quality Fat Foods 19 Adjusting Your Diet For Weight Loss Adjusting Your Diet For Muscle Gains Cheat Meals & Cheat Days Testosterone Boosting Workout Workout Introduction The Best Gym Exercises To Boost Testosterone Muscle Building Formula Progressive Overload How To Set Up Your Workout Your Gym Workout Routine Bench Press Squats Military Press Deadlift Lat Pulldown Underhand Grip Row HIIT Explained How To Design Your HIIT Workout How To Progress With HIIT Rest & Sleep Rest & Sleep Introduction Sleeping Correctly 6 Tips To Fall Asleep Faster Supplements For Better Sleep Lifestyle Improvements Lifestyle Improvements Introduction Body Language Managing Stress The Right Foods To Reduce Stress Work And Life Balance Cold Showers BPA Sex Alcohol Supplements Testosterone Supplements Introduction Maca Tribulus Vitamin D Zinc DHEA Assessment Process Once you have completed all the modules in the Hormone Health & Testosterone Certification course, you can assess your skills and knowledge with an optional assignment. Certificate of Completion The learners have to complete the assessment of this Hormone Health & Testosterone Certification course to achieve the CPDQS accredited certificate. Digital Certificate: £10 Hard Copy Certificate: £29 (Inside UK) Hard Copy Certificate: £39 (for international students) CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this Hormone Health & Testosterone Certification course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career. Certificates CPD Accredited Certificate Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.
Our Aim Is Your Satisfaction! Offer Ends Soon; Hurry Up!! Are you looking to improve your current abilities or make a career move? Our unique Photography for Beginners course might help you get there! Expand your expertise with high-quality training - study the Photography for Beginners course and get an expertly designed, great-value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through theonline training course. The Photography for Beginners course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Photography for Beginners course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this course. This Photography for Beginners training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Why Prefer Us? Opportunity to earn a certificate accredited by CPDQS. Get a free student ID card!(£10 postal charge will be applicable for international delivery) Innovative and Engaging Content. Free Assessments 24/7 Tutor Support. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of this course: Photography for Beginners Course Introduction Introduction to the Photography Masterclass How Does a Camera Work Lecture Types Exposure Intro to Exposure What is Aperture What is Shutter Speed Digital Photography Masterclass Intro to Composition The Rule of Thirds Negative Space Focus and Depth of Field Intro to Focus and Depth of Field Understanding Depth of Field How to Get a Blurrier Background Camera Anatomy Intro to Camera Anatomy The Main Camera Features Camera Scene Modes White Balance and Color Intro to White Balance and Color What is White Balance The Kelvin Light Temperature Scale Lighting Intro to Lighting Using Natural Light Using Natural Light a Window Mobile Photography Intro to Mobile Photography Using a Smartphone Camera Exposing Properly With the Smartphone Camera Equipment - Cameras Intro to Cameras Camera Types What is Your Budget Equipment - Lenses Intro to Lenses A Deeper Dive into Focal Length A Deeper Dive Into Aperture Equipment - Accessories Intro to Camera Accessories Memory Cards Batteries Photo Scenario - Portrait Intro to Scenarios Intro and Tips for Portrait Photography Portrait Photo Demo Photo Scenario - Long Exposure Intro and Tips for Long Exposure Photography Daytime Long Exposure Demo Activity: Portrait Photo Scenario - Landscape Intro and Tips for Landscape Photography Landscape Photo demo Activity: Landscape Photo Scenario - Product Intro and Tips for Product Photography Product Photo Demonstration with Natural Light Product Photography with Lights Photo Scenario - Low Light Intro and Tips for Low Light Photography Low Light Demo Activity - Low light Photo Scenario - Sports & Action Intro and Tips for Sports and Action Photography Sports Photography Activity: Action and Sports Photo Scenario - Macro Intro and Tips for Macro Photography Macro Photography Demo Activity: Macro Photo Scenario - Street & Architecture Street Photo demo Activity: Street & Architecture Photo Scenario - Events Intro to Event Photography A Chat About Event Photography Bring the Right Tools Photo Scenario - Aerial Intro to Drone Photography Our Recommended Drone Equipment Photo Scenario - Night Intro and for Night Photography Night Photo Demo Activity - Night Intro to Photo Editing Intro to Editing Activity - Photo Editing Photoshop CC Intro Photoshop Opening Photos in Photoshop CC Cropping in Photoshop CC Lightroom Classic CC Intro to Lightroom Classic CC Importing and Organizing in Lightroom Classic CC Crop and Rotate Lightroom Classic CC Lightroom CC Intro to Lightroom CC Import and Organize in Lightroom CC Crop and Rotate in Lightroom CC Mac Photos Intro to Mac Photos Importing and Organizing Mac Photos Google Photos Intro to Google Photos Importing and Organizing in Google Photos Photoshop Express Intro to Photoshop Express Importing and Understanding the Workspace in Photoshop Express Snapseed Intro to Snapseed Opening Photos and Navigating the App Making Adjustments and Editing Exposure Sharing Your Photos Intro to Sharing Online Platforms for Photographers Starting a Photo Business Finding Your First Client Payments and Accounting Selling Stock Photos Intro to Stock Photography The Best Stock Photos Sites to Sell on Printing How to Print Your Photos How Big Can You Print Your Photos Framing Wildlife Intro and Tips for Wildlife Wildlife Photography Demonstration Conclusion Thank You and Conclusion Video Photo Submission Submit Your Photos Assessment Process Once you have completed all the modules in this course, you can assess your skills and knowledge with an optional assignment. Certificate of Completion The learners have to complete the assessment of this Photography for Beginners course to achieve the CPDQS accredited certificate. Digital Certificate: £10 Hard Copy Certificate: £29 (Inside UK) Hard Copy Certificate: £39 (for international students) CPD 25 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this Photography for Beginners course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career.
Register on the Diet and Nutrition Diploma today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Diet and Nutrition Diploma is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Diet and Nutrition Diploma Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) 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 Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Diet and Nutrition Diploma, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16.
Register on the Light Current Systems for Electrical Engineering today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Light Current Systems for Electrical Engineering is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Light Current Systems for Electrical Engineering Receive an e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) 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 Certification 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. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Light Current Systems for Electrical Engineering, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Light Current Systems for Electrical Engineering Light Current Fire Alarm System Module 1- Light Current Fire Alarm System Part 1 00:17:00 Module 2- Light Current Fire Alarm System Part 2 00:15:00 Module 3- Light Current Fire Alarm System Part 3 00:18:00 Module 4- Light Current Fire Alarm System Part 4 00:17:00 Module 5- Light Current Fire Alarm System Part 5 00:17:00 Module 6- Light Current Fire Alarm System Part 6 00:17:00 Light Current MATV and Telephone System Module 1- Light Current MATV System Part 1 00:14:00 Module 2- Light Current MATV System Part 2 00:17:00 Module 3- Light Current Telephone System 00:19:00 Light Current Data System Module 1- Light Current Data System Part 1 00:15:00 Module 2- Light Current Data System Part 2 00:20:00 Light Current CCTV System Module 1- Light Current CCTV System Part 1 00:14:00 Module 2- Light Current CCTV System Part 2 00:23:00 Light Current Sound System Module 1- Light Current Sound System Part 1 00:18:00 Module 2- Light Current Sound System Part 2 00:16:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.
Business Finance 101: A Beginner’s Guide to Business Accounting and Finance Course Description Course Description Three are three main reasons for business failure – an under-skilled management team; ineffective marketing; and poor financial management. Every manager, or student of management, requires a good grasp of business finance. This course will help. Business finance concerns the management of the monetary resources of an organisation. There are two aspects to this: Raising the money to invest in the business Managing that investment properly to generate a return Raising the money is about having an attractive proposition and managing the risk to investors. Managing the investment is about the financial controls and reporting of the business. This course covers the three main financial reports; financial performance indicators; and investment analysis. This course will give you a good grasp of the key principles and issues in business finance. Key Learning Participants in this course will learn: The history of business accounting Why businesses fail The two main purposes of business finance and accounting The key principles of business finance and what they mean What debits and credits are The three key financial statements for an organisation What the Balance Sheet tells you What the Income Statement (also called the Profit and Loss Account) tells you What the Cashflow Statement tells you Key financial performance indicators in business Analysing business investments Curriculum L1 What is business finance? L2 Why businesses fail L3 The Principles of Business Finance Part 1 L4 The Principles of Business Finance Part 2 L5 The Balance Sheet L6 The Income Statement L7 The Cashflow Statement L8 A Business Finance Exercise L9 Financial Performance Indicators L10 Investment Analysis L11 Investment Analysis Exercise L12 Key Learning Points in Business Finance Pre-Course Requirements None Additional Resources None Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel
Dealing with Angry or Rude Customers Course Description Copyright Ross Maynard 2021 Course Description If you work in customer service in any way, then, from time to time, you are going to have to deal with angry or rude customers. This course will help you manage those stressful situations and support the customer as best you can. Anger is a normal and relatively common emotion caused by a perceived hurt or provocation. In some cases a customer’s anger or rude behaviour may be driven by the failings of your organisation or its products and services. In other cases, the problem may be outside your control but you still have to deal with the impact. In this course we look at anger in a customer service situation and how to deal with it. We review the nature and causes of anger; we look at how poor customer service can cause anger and what you can do to prepare your organisation to deal with anger. We cover the warning signs for anger and present a 12 step approach to dealing with an angry customer. We cover questions and short scripts that can help you start a discussion with an angry customer, and we consider why customers might be rude. Finally we look at managing the stress of dealing with an angry customer and finish the course with a review of the key learning points. I hope you find the course helpful. Key Learning Points On completion of the course, delegates will be able to: Understand the nature and causes of anger as an emotion. Consider their objectives when dealing with an angry customer. Help prepare their organisation for dealing with angry customers. Identify appropriate customer service metrics Work through a series of steps to deal with an angry customer. Use questions and short scripts to try to help a customer bring their anger under control . Consider why a customer might be rude, and how to deal with that rudeness. Understand how to manage the stress of dealing with angry or rude customers. Curriculum L1: Anger as an Emotion L2: Your Objectives when Dealing with Anger L3: Poor Customer Service L4: Preparing your Organisation L5: Warning Signs and What Not to Do L6: The 12 Steps to Dealing with Anger L7: Example Scripts for Angry Customers L8: Dealing with Rude Customers L9: Dealing with Stress, and Key Learning Points Pre-Course Requirements There are no pre-course requirements Additional Resources Copy of customer behaviour policy Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel
CyberSec First Responder: Threat Detection and Response (Exam CFR-210) Course Description The CyberSec First Responder: Threat Detection and Response (Exam CFR-210) is organized into 12 modules and includes everything you need to become successful in this profession. To make this course more accessible for you, we have designed it for both part-time and full-time students. You can study at your own pace or become an expert in just 12 hours! If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email. Why choose this CyberSec First Responder: Threat Detection and Response (Exam CFR-210) 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 £119.00. 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 To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support.
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