PowerPoint for Business in 60 Minutes Course Description Copyright Ross Maynard 2021 Course Description Welcome to PowerPoint for Business in 60 Minutes. Microsoft PowerPoint has been around for nearly 35 years, and I am sure you are familiar with it, and have experienced many PowerPoint presentations – some good; many extremely tedious! Creating a business presentation in PowerPoint presents a number of challenges and there is a danger of “death by PowerPoint”. I recently attended a meeting which was supposed to be a planning discussion but which the person leading the meeting insisted on introducing with a PowerPoint presentation of 60 slides – mostly bullet points! We were hardly in the mood for action planning after that assault on our senses. PowerPoint is good for presenting business results or for a training course, but you need to plan your slideshow carefully to avoid bullet-point boredom and to keep your audience engaged and interested. And that is the purpose of this course – to teach you PowerPoint techniques which you may not be familiar with, and which will help you improve the impact of your business presentations. Less is more in a slide show so it is important to use techniques and effects which will help engage your audience and draw their attention to the points that matter. In “PowerPoint for Business in 60 Minutes”, I cover six key topics that will help you produce more impactful business presentations: The best slide transitions and animations for business presentations The morph transition to make the narration of an agenda, or similar list, or a team photograph extremely slick and professional The Zoom effect to create a summary slide with hyperlinks to zoom into the section that you or your audience choose How to animate charts to highlight the key points you want to bring out How to embed Excel tables with slicers into PowerPoint, and why PowerPoint is not developed enough to make this useful for a business presentation How to turn your PowerPoint presentation into a video. This is the technique I am most often asked how to do. This is not a full “PowerPoint from scratch” course: it assumes familiarity of Microsoft’s ubiquitous programme. Instead, the course takes only 1 hour of your time to focus on key techniques that can help you improve the impact of the presentations you create. I hope you enjoy the course. Key Learning Points On completion of the course, delegates will be able to: Identify the most useful slide transitions and animations for business presentations Use the morph transition to draw the audience’s attention Create a “zoom” summary slide to jump to user-selected sections of slides Animate charts to highlight key points Embed a Microsoft Excel table in a PowerPoint slide Create a video with commentary of their PowerPoint presentation Curriculum Lesson 1: Transitions and Animations Lesson 2: The Morph Transition Lesson 3: Zoom Lesson 4: Animating Charts Lesson 5: Excel Tables and Slicers in PowerPoint (or Not!) Lesson 6: Making a PowerPoint Video Pre-Course Requirements There are no pre-course requirements 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 Questions What slide effect allows you to give the illusion of moving around a larger “page”? The Wipe transition. The Dissolve transition. The Push transition. The Fly-In animation What does “Zoom” in PowerPoint allow you to do? Zoom creates the illusion of “zooming in” on a particular part of a slide Zoom creates a summary slide with hyperlinks to the individual slides or sections contained in the summary Zoom creates a smooth object animation from one slide to another to animate, for example, an agenda or timeline Zoom is used to highlight areas of a chart or graphic to draw the audience’s attention What is the main problem with embedding a Microsoft Excel table with slicers into PowerPoint? The slicers do not work, and the table cannot be manipulated, in presentation mode in PowerPoint The table cannot be opened or manipulated in PowerPoint slide view Microsoft Excel and PowerPoint are incompatible with each other The file size created is too large for most business PCs to handle When seeking to create an MP4 video file from a PowerPoint presentation, why is it advisable to record the commentary separately? PowerPoint’s built-in recording facility is unreliable and frequently crashes It’s much quicker to record the audio separately and then insert it into PowerPoint and save as a video file Separate video editing software needs to be used to improve the video’s look and sound where the audio is recorded directly in PowerPoint It removes the stress of commentating “live” on the presentation while recording it, and allows any mistakes and errors to be cut out
Duration 1 Days 6 CPD hours This course is intended for This course is intended for those persons who will implement, manage and direct mobile asset Initiatives for their organizations. Overview The CMAM course prepares students to implement a foundation of best practice policies and processes whereby mobile assets are controlled. This should lead to savings opportunities, risk mitigation surrounding BYOD and financial responsibility. Students will be able to incorporate mobile asset management and BYOD into their environment, policies and procedures to mitigate risk, increase productivity of employees, and bring value from the mobile asset management program. The IAITAM Certified Mobile Asset Manager (CMAM) course prepares individuals and organizations responsible for the management of mobile devices. Proliferation of mobile devices within the enterprise, whether corporate-owned or BYOD-based, has brought a complexity to ITAM never before seen in IT environments. The course will prepare individuals with the knowledge to manage personnel, policies and processes, the key elements in organizational IT management. This course encompasses both organizational owned assets as well as BYOD (employee-owned). The CMAM course has the IAITAM Best Practice Library as its foundation and encompasses financial viability, risk mitigation, policy enforcement and lifecycle management of mobile assets. Course Outline Mobile Asset Management and ITAM People & Mobile Assets Bring Your Own Device (BYOD) Tools Repository Management Assessment The 12 KPAs and Mobile Asset Management Program Management & Mobility Policy Management & Mobility Communication & Education Management & Mobility Education & Mobility Acquisition Management & Mobility Asset Identification Management & Mobility Legislation & Compliance Management & Mobility Software & Application Licensing Disposal Management & Mobility Documentation Management & Mobility Financial Management & Mobility Vendor Management & Mobility Data Protection
Duration 1 Days 6 CPD hours This course is intended for This course provides an introductory overview of the CMMC program for organizational decision makers. Business and IT leaders and IT staff might consider taking this course to learn about the CMMC Model to get a sense of what's required for a successful assessment, and the various ways they can start preparing. Overview In this course, you will identify the key elements and potential impacts of the Cybersecurity Maturity Model Certification (CMMC) program. You will: Identify the crucial elements that are driving the CMMC initiative. Describe the architecture of the CMMC Model and the rationale behind it. Prepare your organization for a successful CMMC Assessment. Identify the roles and responsibilities in the CMMC ecosystem and describe the phases of an Assessment. The Cybersecurity Maturity Model Certification (CMMC), managed by The Cyber AB (formerly known as the CMMC Accreditation Body or the CMMC-AB), is a program through which an organization's cybersecurity program maturity is measured by their initial and ongoing compliance with applicable cybersecurity practices. This course provides a complete review of the key elements of this important program and will entitle you to a CMMC Trailblazer badge.Important: This curriculum product is not considered CMMC-AB Approved Training Material (CATM). This course is not intended as certification preparation and does not qualify students to sit for the CMMC CP certification exam. Identifying What's at Stake Topic A: Identify the Threats and Regulatory Responses Topic B: Identify Sensitive Information Describing CMMC Topic A: Describe the CMMC Model Architecture Topic B: Describe the CMMC Program Getting Ready for a CMMC Assessment Topic A: Scope Your Environment Topic B: Analyze the CMMC Assessment Guides Topic C: Foster a Mature Cybersecurity Culture Topic D: Identify Helpful Documents Topic E: Evaluate Your Readiness Interacting with the CMMC Ecosystem Topic A: Identify the CMMC Ecosystem Topic B: Describe a CMMC Assessment
Unlock Your Potential with Account Management Mastery Course! Are you ready to soar in the dynamic world of business? ð Welcome to the Account Management Mastery Course, where you'll discover the keys to unlocking unparalleled success in managing client relationships, driving revenue, and fostering long-term partnerships. If you're ready to take your career to new heights and become a force to be reckoned with in the realm of account management, then this course is your ticket to excellence. Why Account Management Matters In today's competitive business landscape, effective account management is more critical than ever before. It's the backbone of sustainable growth and profitability for companies across industries. Account managers play a pivotal role in nurturing client relationships, understanding their needs, and delivering solutions that exceed expectations. With the right skills and strategies, you can transform ordinary clients into loyal advocates who propel your business forward. What You'll Gain ð Strategic Insights: Learn the art of strategic account planning and gain valuable insights into your clients' businesses. Develop customized strategies to drive mutual growth and success. ð Effective Communication: Master the art of communication and negotiation to build trust, resolve conflicts, and win over even the toughest clients. Develop your persuasion skills and become a master influencer. ð Relationship Building: Cultivate lasting relationships with your clients based on trust, respect, and mutual understanding. Discover the secrets to building rapport and fostering loyalty that stands the test of time. ð Revenue Generation: Unlock the secrets to driving revenue and maximizing profitability through upselling, cross-selling, and identifying new business opportunities within your accounts. ð Problem Solving: Develop the ability to anticipate and address challenges before they arise. Learn how to navigate difficult situations with grace and professionalism, turning obstacles into opportunities for growth. Who is This For? The Account Management Mastery Course is designed for professionals across industries who are passionate about driving results and exceeding client expectations. Whether you're a seasoned account manager looking to sharpen your skills or a newcomer eager to make your mark in the field, this course is your pathway to success. Sales representatives, client success managers, business development executives, and entrepreneurs alike will benefit from the practical insights and strategies offered in this comprehensive program. Career Path With the skills and knowledge gained from the Account Management Mastery Course, you'll be poised for success in a variety of career paths, including: ð Account Manager: Take on leadership roles within your organization and become a trusted advisor to your clients. ð Business Development Executive: Drive business growth and expansion by identifying new opportunities and cultivating strategic partnerships. ð Client Success Manager: Ensure the satisfaction and loyalty of your clients by delivering exceptional service and support. ð Entrepreneur: Apply your newfound skills to build and grow your own business, creating value for your clients and driving long-term success. FAQs Q: Is this course suitable for beginners? A: Absolutely! The Account Management Mastery Course caters to professionals at all levels, from beginners to seasoned veterans. Our comprehensive curriculum is designed to provide valuable insights and practical strategies that anyone can apply to excel in the field of account management. Q: Can I access the course materials at my own pace? A: Yes! We understand that professionals have busy schedules, which is why our course is designed to be flexible. You can access the materials at any time and progress through the course at your own pace. Q: Will I receive a certification upon completion of the course? A: Yes! Upon successfully completing the Account Management Mastery Course, you will receive a certificate of completion that you can proudly showcase to demonstrate your expertise and commitment to excellence in account management. Q: Are there any prerequisites for enrolling in the course? A: While there are no formal prerequisites for enrolling in the course, a basic understanding of business principles and client relationship management would be beneficial. However, our course is designed to accommodate learners with diverse backgrounds and experiences. Q: Will I have access to instructors for guidance and support? A: Absolutely! Our team of experienced instructors is dedicated to providing personalized support and guidance throughout your learning journey. Whether you have questions about course materials or need assistance with assignments, we're here to help you succeed. Don't Miss Out on This Opportunity! Are you ready to take your career to the next level and become a master of account management? Don't miss out on this opportunity to unlock your full potential and achieve unparalleled success. Enroll in the Account Management Mastery Course today and embark on a transformative journey towards excellence! Course Curriculum Module 1_ Introduction to Account Management Introduction to Account Management 00:00 Module 2_ Customer Relationship Management Customer Relationship Management 00:00 Module 3_ Sales and Negotiation Techniques Sales and Negotiation Techniques 00:00 Module 4_ Account Planning and Strategy Account Planning and Strategy 00:00 Module 5_ Technology and Tools for Account Management Technology and Tools for Account Management 00:00 Module 6_ Marketing and Advertising Marketing and Advertising 00:00 Module 7_ Sales and Negotiations Sales and Negotiations 00:00 Module 8_ Customer Service and Support Customer Service and Support 00:00 Module 9_ Account Management Account Management 00:00 Module 10_ Performance Management and Evaluation Performance Management and Evaluation 00:00
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
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
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
The Birth of the Industrial Revolution in Britain 1707 to 1830 Course Description Introduction The Industrial Revolution started in Britain in the eighteenth century. A number of factors converged to create the conditions for developments in industry and science. Agricultural improvements created a cadre of wealthy landowners with money to invest. Improved educational opportunities, particularly in Scotland, created a broader set of young people with ideas and ambition. Greater religious freedom allowed individuals of talent to develop businesses. Interest in science and technology blossomed and the birth of the coffee house culture brought people with ideas into the orbit of those with money. But it was not all rosy. The new culture of ideas and experimentation was almost entirely limited to men. A woman’s place was seen to be in the home. At the same time the slave trade flourished providing much of the wealth for investment and, shamefully, Britain was a key facilitator in this odious business – and there were few voices of dissent at the time. And the poor lived short and brutish lives of hard physical work in grim conditions with an inadequate diet and very little healthcare. In this course I am going to take you through the key milestones of the early industrial revolution – in the textile industry, in coal mining and iron production, in civil engineering; in the development of steam power and the birth of the railways. Course Pre-Requisites There are no course pre-requisites. What Students will Learn The history of the industrial revolution in Britain from 1707 to 1830 The factors that created the conditions for the industrial revolution Developments in the textile industry in the eighteenth century The development of steam as a source of power The birth of steam locomotion Developments in coal, coke and iron Civil engineering in the eighteenth century Scientific developments in the eighteenth century Curriculum SS1 The Birth of the Industrial Revolution 6 mins SS2 The Textiles Revolution 13 min SS3 The Birth of the Steam Engine 10 mins SS4 The Age of Steam Locomotion 14 mins SS5 Fuelling the Industrial Revolution 10 mins SS6 The Engineering Revolution 6 mins SS7 The Scientific Revolution 18 mins SS8 Black Lives during the Industrial Revolution 5 mins SS9 The Birth of the Industrial Revolution 2 mins SS10 The Industrial Revolution History Quiz 19 mins Total time: 1 hour 44 minutes 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 finance processes. Ross is also a professional author of online training courses for accountants. Ross lives in Scotland with his wife, daughter and Cocker Spaniel
Microsoft Excel training | Excel Courses for Accountants: Excel Courses Overview Microsoft Excel is the world's most popular spreadsheet program, learning how to use the software with Osborne Training shows that you've taken one of the best Excel training courses available. Comprehensive excel courses come with up to date material to practice at home and during your class. Excel courses for accountants This course is a highly recognised excel course for accountants. We will also provide a step by step manual of all the tricks you can do using Excel spreadsheets to gain better management reporting and budgeting skills. It is a fundamental program for professional Accountants. Excel spreadsheets are the most powerful tool, extensively used for reporting and analysis. Having advanced skills in excel can excel your career and help you to stand ahead of the competitive job market. Advanced skills in Excel is a must for any potential professional accountants and who are already running a practice or considering opening a practice. Certificate of Attendance Excel Course Content Creating worksheets, formatting text Simple and complex formulas Handling rows and columns Average, max and min functions and using charts. Use of IF Formula Summing Techniques Cell References Formula Linking Tables and Bordering Look up References (Vlookup, Hlookup, etc) Data Validation Conditional Formatting Date & Time Formulas Charts & Graphs Protection & Security Creating Pivot Table Pivot Table Analysis