20315 Courses

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 Commercial Manager has been developed for analysing commercial risk management. This course also will educate you on several management factors which include management of budget, project management, management of loans and debt along with an overview of commercial management. Start learning Commercial Manager that will give you enough knowledge and skills to build your dream career. About this course This Commercial Manager helps to grow your skills faster through the power of relevant content and world-class tutors. In this industry-leading bite-sized course, you will learn up-to-date knowledge in the relevant field within a few hours and get certified immediately. The modules of this course are very easy to understand and all of the topics are split into different sections. You will easily grasp and use the knowledge gained from this course in your career and go one step ahead of your competitors. The course is designed to improve your employability and provide you with the tools you need to succeed. Enrol today and start learning your essential skills. Why choose this course Earn a digital 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 Get 24/7 help or advice from our email and live chat teams Get full tutor support on weekdays (Monday to Friday) Course Design The Commercial Manager 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 Who Is This Course For:​ This Commercial Manager is ideal for those who want to be skilled in this field or who wish to learn a new skill to build their dream career. If you want to gain extensive knowledge, potential experience, and be an expert in the related field then this is a great course for you to grow your career. Requirements This course is for anyone who would like to learn Commercial Manager related skills to aid his/her career path. No formal entry prerequisites are required 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. Course Content Module 1: An Overview of Commercial Management Module 2: Commercial Risk Management Analysis Module 3: Management of Budget Module 4: Project Management Module 5: Management of Loans and Debt Course Content Commercial Manager Module 1: An Overview of Commercial Management 00:14:00 Module 2: Commercial Risk Management Analysis 00:15:00 Module 3: Management of Budget 00:19:00 Module 4: Project Management 00:19:00 Module 5: Management of Loans and Debt 00:13: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.

Start learning Basics of Corporate Finance Training that will give you enough knowledge and skills to build your dream career. About this course This Basics of Corporate Finance Training helps to grow your skills faster through the power of relevant content and world-class tutors. In this industry-leading bite-sized course, you will learn up-to-date knowledge in the relevant field within a few hours and get certified immediately. The modules of this course are very easy to understand and all of the topics are split into different sections. You will easily grasp and use the knowledge gained from this course in your career and go one step ahead of your competitors. The course is designed to improve your employability and provide you with the tools you need to succeed. Enrol today and start learning your essential skills. Why choose this course Earn a digital 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 Get 24/7 help or advice from our email and live chat teams Get full tutor support on weekdays (Monday to Friday) Course Design The Basics of Corporate Finance Training 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 Who Is This Course For:​ This Basics of Corporate Finance Training is ideal for those who want to be skilled in this field or who wish to learn a new skill to build their dream career. If you want to gain extensive knowledge, potential experience, and be an expert in the related field then this is a great course for you to grow your career. Requirements This course is for anyone who would like to learn Basics of Corporate Finance Training related skills to aid his/her career path. No formal entry prerequisites are required 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. Course Content Module 01: Basics of Corporate Finance Module 02: Financial Planning and Growth for the Long Term Module 03: Financial Statement Analysis Module 04: Corporate Finance as a Career Course Content Finance: Basics of Corporate Finance Module 01: Basics of Corporate Finance 00:08:00 Module 02: Financial Planning and Growth for the Long Term 00:20:00 Module 03: Financial Statement Analysis 00:22:00 Module 04: Corporate Finance as a Career 00:08: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.

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

A recorded video of a presention given by Rev Don MacGregor to The Hamblin Vision on the subject of Science, Oneness and God.

Discover the world around you! Explore the fundamentals of geography, from physical landscapes to human interactions. Gain insights into maps, cultures, and environmental phenomena through engaging lessons and captivating visuals, thanks to Spark Generation's Cambridge self-paced course.

11-in-1 Premium Bundle | CPD QS Certified | 110 CPD Points | Free Hardcopy + PDF Certificate + Exam | Lifetime Access

Trong tiếng Anh, idioms không chỉ làm cho ngôn ngữ trở nên phong phú hơn mà còn giúp người nói thể hiện cảm xúc và ý tưởng một cách sinh động hơn. Dưới đây là một số idioms thông dụng mà bạn có thể sử dụng trong giao tiếp hàng ngày. 1. Break a leg "Break a leg" là một cách chúc may mắn, thường được sử dụng trước khi ai đó lên sân khấu hoặc tham gia một sự kiện quan trọng. Câu này xuất phát từ truyền thống của các nghệ sĩ, khi mà họ tin rằng việc chúc nhau "may mắn" có thể mang lại điều ngược lại. Ví dụ: "Goodluck with your performance tomorrow. Break a leg!" 2. Under the weather Cụm từ này có nghĩa là cảm thấy không khỏe hoặc có triệu chứng bệnh tật. Nguồn gốc của nó có thể bắt nguồn từ thời hàng hải, khi thời tiết xấu đi có thể ảnh hưởng đến tình trạng sức khỏe của thủy thủ. Ví dụ: "I think I’m a bit under the weather today, so I might skip work tomorrow." 3. Broaden my horizon "Broaden my horizon" có nghĩa là mở rộng kiến thức hoặc trải nghiệm của bản thân. Câu này xuất phát từ ý tưởng về "horizon" như một ranh giới của cái mà chúng ta biết, và việc "mở rộng" nó có thể giúp chúng ta hiểu biết hơn. Ví dụ: "Traveling to different countries really helped me broaden my horizon." 4. Elephant in the room Cụm từ này chỉ một vấn đề lớn mà mọi người đều biết nhưng không ai muốn nói đến. Ý tưởng là nếu có một con voi lớn trong phòng, mọi người sẽ không thể không nhìn thấy, nhưng vẫn có thể tránh nói về nó. Ví dụ: "I really don't want to address the elphant in the room. But our budgets are getting cut" 5. Hidden gem "Hidden gem" dùng để chỉ một nơi, người, hoặc điều gì đó đặc biệt nhưng chưa được khám phá hoặc công nhận. Cụm từ này liên quan đến việc tìm kiếm những viên ngọc quý ẩn mình trong đá, tượng trưng cho những điều tốt đẹp chưa được phát hiện. Ví dụ: "This little café is a hidden gem. Not only the coffee is fantastic but also the food!" 6. Hit the sack "Hit the sack" có nghĩa là đi ngủ. Câu này có thể xuất phát từ hình ảnh của việc nằm xuống một chiếc bao tải để ngủ, thường là trong những hoàn cảnh khi ngủ ở nơi tạm bợ. Ví dụ: "I’m really tired after a long day at work, so I'll be hitting the sack early tonight." 7. Piece of cake Cụm từ này diễn tả một nhiệm vụ hoặc công việc rất dễ dàng. Không rõ nguồn gốc chính xác, nhưng có thể liên quan đến việc làm bánh — một việc đơn giản và dễ dàng đối với nhiều người. Ví dụ: "The exam was a piece of cake; I studied well for it." 8. I could eat a horse Câu này diễn tả cảm giác đói bụng rất lớn. Nó không có nguồn gốc rõ ràng, nhưng thể hiện sự phóng đại để nhấn mạnh mức độ đói. Ví dụ: "After that workout, I could eat a horse!" 9. On a roll "On a roll" có nghĩa là đang gặp nhiều may mắn hoặc thành công liên tiếp. Câu này có thể liên quan đến các trò chơi hoặc hoạt động mà khi bắt đầu "cuộn" thì mọi thứ diễn ra suôn sẻ. Ví dụ: " He’s been on a roll lately, winning every game he plays." 10. Call it a day Cụm từ này có nghĩa là kết thúc công việc trong một ngày. Nó xuất phát từ ý tưởng rằng một ngày làm việc đã đủ và đến lúc nghỉ ngơi. Ví dụ: "I think we’ve accomplished enough for today; let’s call it a day." 11. Diamond in the rough "Diamond in the rough" chỉ một người hoặc một vật có tiềm năng lớn nhưng chưa được phát hiện hoặc chưa được phát triển. Cụm từ này gợi lên hình ảnh của một viên kim cương chưa được mài dũa, vẫn còn thô ráp nhưng rất quý giá. Ví dụ: "This young artist is a diamond in the rough; with some training, she could be amazing!" 12. A little birdie told me Cụm từ này được dùng khi bạn không muốn tiết lộ nguồn gốc hoặc danh tính của người mà bạn vừa nhận được thông tin. Nó thường mang tính hài hước và bí ẩn, có thể bắt nguồn từ những câu chuyện dân gian, trong đó chim chóc được coi là người mang tin tức. Ví dụ: "How did I know about the party? A little birdie told me about it." 13. Blew someone away Cụm từ này có nghĩa là làm ai đó rất ấn tượng hoặc kinh ngạc, thể hiện sự ngạc nhiên mạnh mẽ trước một điều gì đó tuyệt vời. Hình ảnh "bị thổi bay" diễn tả cảm giác mạnh mẽ đến mức không thể đứng vững. Ví dụ: "The performance last night really blew me away; they are so talented!" 14. Give someone a hand Cụm từ này có nghĩa là giúp đỡ ai đó, đặc biệt là trong một tình huống khó khăn. Hình ảnh "cho một bàn tay" thể hiện sự hỗ trợ và giúp đỡ, biểu trưng cho sự đồng lòng trong công việc. Ví dụ: "Can you give me a hand with this project? I could really use your help." 15. Spill the tea Cụm từ này được dùng để chỉ việc tiết lộ thông tin, đặc biệt là những tin đồn hoặc bí mật thú vị. Hình ảnh "đổ trà" mang tính chất xã hội, thường được sử dụng trong những cuộc trò chuyện thân mật hoặc giải trí. Ví dụ: "Come on, spill the tea! I want to know what happened at the party." KẾT LUẬN Việc nắm vững các idioms trong tiếng Anh không chỉ giúp bạn giao tiếp hiệu quả hơn mà còn làm phong phú thêm khả năng diễn đạt và thể hiện cảm xúc một cách tự nhiên. Những cụm từ này thường mang những hình ảnh và ý nghĩa sâu sắc, giúp bạn kết nối với người nghe một cách dễ dàng hơn. Hy vọng rằng qua bài viết này, bạn đã có thêm nhiều kiến thức hữu ích về các idioms thông dụng. Hãy thử áp dụng chúng trong các cuộc hội thoại hàng ngày để tăng cường sự tự tin và khả năng giao tiếp của mình.

Example

Support culture change by giving line managers the skills to look at practices within their areas, role model appropriately and address unacceptable behaviours. Our dynamic, assertive trainer for EDI has a very practical approach, with plenty of real-life examples to help participants view the subject from a new angle