322 Management Accounting courses delivered Online

Power Query and Power Pivot in Microsoft Excel:  A Quickstart Guide   Course Description   Copyright Ross Maynard 2022   Course Description Power Query and Power Pivot are two tools available in Microsoft Excel. If you are serious about data analysis, then you need to know how to use these tools. This Quickstart guide will give you the skills you need to get started with these powerful features. The Power Query tool allows you to import external data and then modify it to meet your needs, before loading it into Excel. These editing tasks are all things you can do manually in Excel, but Power Query greatly speeds things up when you have a large volume of data. The Power Pivot tool allows you to connect multiple data tables in an extended pivot table. Power Pivot also introduces new analysis and query tools to further enhance data analysis. If data analysis is your thing, then this course will help you get up to speed with these feature-filled tools. Through screen-capture video, the course provides a step-by-step guide to the foundation skills needed to use both Power Query and Power Pivot effectively. The course is designed to make your first steps into Power Query easy and to build your confidence to use them on your own. Both Power Query and Power Pivot are also available in Microsoft Power BI – the data visualisation suite. Once you have learned how to use Power Query and Power Pivot in Excel with this course, you’ll have a head start in getting to grips with Power BI Get up to speed with Power Query and Power Pivot in Microsoft Excel with this Quickstart guide.     Key Learning Points  On completion of the course, delegates will be able to: Use Power Query to load data from an external source into Microsoft Excel Clean and manipulate external data before loading it into Excel Consolidate separate files with Power Query Update Excel tables with new data in the same format Use Power Query to “unpivot” report tables to prepare the data for analysis Explain the core functionality of Power Pivot Link data tables together in the Power Pivot data model Create pivot tables that draw data from several source data tables Create performance measures and new analysis in the Power Pivot data model Use the most popular DAX query language functions in Power Pivot     Curriculum Lesson 1: Power Query Quickstart Lesson 2: Consolidating Files with Power Query Lesson 3: Unpivoting a Table Lesson 4: Power Pivot Quickstart Lesson 5: Power Pivot – Adding Data and Functionality Lesson 6: Key DAX Functions for Power Pivot Lesson 7: The DAX CALCULATE Function Lesson 8: Key Learning Points     Pre-Course Requirements There are no pre-course requirements     Additional Resources Starter spreadsheets for each lesson are provided so that learners can follow the steps presented.     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 is the main feature of Power Query? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     What is the main feature of Power Pivot? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     Which of the following actions cannot be performed within Power Query? Split text into multiple columns Trimming text and removing spaces Creating calculated columns using DAX functions Make date based calculations   Which of the following statements is true? You can use Power Query to combine files that have the same format and open them all in the same spreadsheet You can use Power Query to link data tables and create pivot tables that pull data items from all the linked tables You can use Power Query to create interactive dashboard reports You can use Power Query to export data files to Microsoft Access and other databases     Which of the following provides a compelling case to use Power Pivot in Microsoft Excel? The data visualisation and presentation features of Power Pivot are much more powerful than those in Excel Power Pivot offers the ability to clean large files of data imported from other systems quickly Existing reports and tables can be “reverse engineered” (unpivoted) to create data tables for more advanced analysis Files sizes in Power Pivot are smaller than in Excel and there is no limit on the number of rows of data that can be stored. This makes it much faster and more efficient to use Power Pivot for large data sets     Power Pivot uses analysis functions from the DAX formula language. What does “DAX” stand for? Digital Architecture Extraction Data Arbitrage Extrapolation Display Analytics Extension Data Analysis Expressions Deeply Annoying Exercise   The DAX CALCULATE function is one of the most powerful and useful functions available in Power Pivot. Which statement best describes it? It performs row by row calculations defined by the user and adds the total of them all together for a specified table It performs row by row calculations defined by the user and displays the maximum result for a specified table It performs a defined calculation and then applies filters specified by the user It filters the data in a specified table according to criteria set by the user   As well as in Power Pivot in Microsoft Excel, in what application are DAX functions also available? Microsoft PowerPoint Microsoft Forms Microsoft Teams Microsoft Power BI   How do DAX functions differ from Microsoft Excel functions? DAX functions are designed specifically for use with SQL based data sources DAX functions are completely new and provide additional functionality within Microsoft Excel DAX functions never take a cell reference or a range as reference, but instead take a column or table as reference DAX date and time functions return a date as a serial number, whereas Excel date and time functions return a datetime data type  

Xero is a cloud-based accounting software used by over 3 million users in over 180 countries. It is expected to grow by 10% in the next five years, making it a lucrative and rewarding career choice for accountants and bookkeepers. With Xero Accounting & Bookkeeping skills, you can have a career that is both financially rewarding and versatile. The average salary for a Xero accountant or bookkeeper in the UK is £35,000, with experienced professionals earning upwards of £50,000. And, because Xero is used by businesses of all sizes in a variety of industries, you have the flexibility to work in the setting that best suits your needs and interests. Whether you want to work full-time or part-time, remotely or in an office, Xero offers a career path that is right for you. And, with the increasing demand for Xero skills, there are more job opportunities than ever before. If you are looking for a career that is both lucrative and rewarding, Xero Accounting & Bookkeeping is a great option to consider. With its high demand for skilled professionals, competitive salaries, and versatility, a career in Xero Accounting & Bookkeeping is a smart choice for your future. Courses in this Xero Accounting & Bookkeeping Exclusive Package: Course 01: Advanced Diploma in Xero Accounting & Bookkeeping at QLS Level 7 Course 02: Quickbooks Online Course 03: Tax Accounting Course 04: Sage 50 Accounts Course 05: Diploma in Payroll: UK Payroll Course 06: Pension What will make you stand out? On completion of this online Xero Accounting & Bookkeeping course, you will gain: CPD QS Accredited Proficiency After successfully completing the Xero Accounting & Bookkeeping course, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials. The online test with immediate results You can study and complete the Xero Accounting & Bookkeeping course at your own pace. Achieve mastery in Xero Accounting & Bookkeeping with our QLS Level 7 Diploma. From invoices and sales to VAT returns, our comprehensive course covers everything you need to excel in modern financial management. The curriculum of the Advanced Diploma in Xero Accounting & Bookkeeping at QLS Level 7: Introduction: Learn the basics of Xero accounting & bookkeeping. Getting Started: Set up your Xero account and start recording transactions. Invoices and Sales: Create and manage invoices and sales. Bills and Purchases: Record and pay bills and expenses. Bank Accounts: Reconcile bank accounts and track cash flow. Products and Services: Set up and manage products and services. Fixed Assets: Record and track fixed assets. Payroll: Calculate and pay payroll. VAT Returns: Prepare and file VAT returns. Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Upon successful completion of the Xero Accounting & Bookkeeping course, you will be eligible to order an original hardcopy certificate of achievement. This prestigious certificate, endorsed by the Quality Licence Scheme, will be titled 'Advanced Diploma in Xero Accounting and Bookkeeping at QLS Level 7'. Your certificate will be delivered directly to your home. The pricing scheme for the certificate is as follows: £129 GBP for addresses within the UK. Please note that delivery within the UK is free of charge. Disclaimer This course will teach you about Xero accounting software and help you improve your skills using it. It's created by an independent company, & not affiliated with Xero Limited. Upon completion, you will earn a CPD accredited certificate, it's not an official Xero certification. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Xero Accounting & Bookkeeping course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Xero Accounting & Bookkeeping. This Xero Accounting course is suitable for: Aspiring accountants looking to specialize in Xero Accounting & Bookkeeping. Small business owners are managing their own finances with Xero. Bookkeepers are seeking advanced knowledge and certification in Xero. Financial professionals are aiming to enhance their skills in Xero Accounting & Bookkeeping Career changers interested in Xero Accounting & Bookkeeping. Entrepreneurs want to streamline their accounting processes with Xero. Requirements To enrol in this Xero Accounting & Bookkeeping course, all you need is a basic understanding of the English Language and an internet connection. Study for the Xero Accounting & Bookkeeping course using any internet-connected device, such as a computer, tablet, or mobile device. Career path After completing this Xero Accounting & Bookkeeping training, you can explore Xero accounting course-related jobs easily, such as - Senior Supervisor Mentor Auditor Account Assistant Bookkeeper Assistant Accountant Finance Manager Payroll Administrator Accounts Assistant Credit Controller Sales Ledger Clerk Management Accountant Sales Ledger Clerk Financial Controller Certificates Certificate of completion Digital certificate - Included After successfully completing this course, you can get a CPD accredited digital PDF certificate for free. QLS Endorsed Hard Copy Certificate Hard copy certificate - £129

In the current age, the intricacies of law and property management are more vital than ever. As our societies grow more complex, the need for knowledge in wills and probate law, family and contract law, as well as social housing and property management, rises. Not to mention the integral role that tax accounting principles play in our economic landscape, our comprehensive Wills and Probate Law course bundle is an invaluable compass, guiding you through these interwoven legal and property domains and arming you with the knowledge that's crucial in today's world. From Wills and Probate Law to Contracts Law UK, Family Law to Tax Accounting Diploma, we offer you a transformative learning experience that equips you with the knowledge and skills needed to navigate complex legal scenarios. Whether you aspire to be a paralegal, property manager, or tax expert, this course bundle empowers you to confidently tackle diverse legal challenges, making you an invaluable asset in today's dynamic legal landscape. The course bundle comprises the following CPD Accredited courses: Wills and Probate Law Family Law Property Law Contracts Law UK Social Housing Management Property Management Paralegal Training Tax Accounting Diploma Learning Outcomes: Acquire knowledge of the crucial aspects of wills and probate law, increasingly vital in today's society. Learn about family and contract law, essential areas in our evolving legal landscape. Understanding social housing and property management, is key in our growing urban environments. Gain insights into the role of a paralegal, a career of growing importance. Delve into the specifics of UK property law, critical in the modern real estate market. Develop an understanding of tax accounting, essential for navigating today's economic climate. Wills and Probate Law: Equip yourself with the necessary skills to understand wills and probate law. Family Law: Learn to navigate the complex landscape of family law. Property Law: Discover the fundamentals of property law in the modern world. Contracts Law UK: Gain an understanding of the laws governing contracts in the UK. Social Housing Management: Grasp the complexities of managing social housing. Property Management: Understand the modern approaches to property management. Paralegal Training: Learn about the vital role of a paralegal in today's legal world. Tax Accounting Diploma: Gain knowledge of the intricacies of tax accounting in the contemporary economic landscape. Make a difference in today's society. Equip yourself with the right skills now. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring legal professionals looking to specialise in wills and probate law. Individuals are interested in understanding the current dynamics of family and contract law. Professionals in the housing sector aim to boost their skills in social and property management. Accountants wishing to upgrade their tax accounting skills in line with today's requirements. Career path Probate Lawyer - £45K to 80K/year. Family Law Solicitor - £30K to 70K/year. Property Law Solicitor - £40K to 85K/year. Contract Law Solicitor - £45K to 100K/year. Social Housing Manager - £30K to 60K/year. Paralegal - £20K to 50K/year. Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.

An Introduction to Payroll Accounting   Course Description   Copyright Ross Maynard 2021   Course Description Welcome to an Introduction to Payroll Accounting.   This course provides an overview of payroll accounting. It is aimed at accountants and business managers and owners new to payroll accounting and looking for straightforward coverage of the key elements and features of payroll. In this course we will cover the core elements of payroll; how gross pay is calculated; and issues when dealing with tips and benefits in kind. We’ll also look at tax-exempt deductions and the statutory deductions from pay. We’ll review the main elements of payroll taxation and social security contributions including the terminology used in the United States, Canada and the United Kingdom. And we’ll cover the calculation of Net Pay – that is the amount that the employee actually receives in their bank account. Finally we’ll explore the main journal entries required in the accounts. The principles and structure of payroll accounting are common across many jurisdictions, and the learning in this course applies in many countries of the world. For this reason, the course does not go into the detail of any country-specific legislation or regulations, and does not cover the particular tax rates, tax bands or deduction rates that apply in different jurisdictions. This course provides a grounding in the principles and structure of payroll accounting whatever your country of operation. I hope you enjoy it.     Key Learning Points  On completion of the course, delegates will be able to: Describe the main components of payroll including allowances, taxes and deductions. Explain the terms Gross Pay, Taxable Pay and Net Pay Identify the statutory taxes and deductions applicable in the United States, Canada and the United Kingdom Complete the main Journal Entries required to process payroll Describe the elements recorded in a Payroll Register     Curriculum Lesson 1: First Principles in Payroll Accounting Lesson 2: Getting to Gross Pay Lesson 3: Allowances and Deductions Lesson 4: Income Taxes and Social Security Contributions Lesson 5: The Calculation of Net Pay Lesson 6: Specific Payroll Terminology for the United States, Canada and the United Kingdom Lesson 7: Payroll Journal Entries Lesson 8: Final Thoughts on Payroll Accounting Appendix: The Payroll Register     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

Business Communication Skills: Communicating effectively in the workplace   Course Description   Course Description Poor communication and presentation of business information breeds poor decisions. We may be masters of the spreadsheet and wizards with a project plan, but we are not always brilliant at communicating or presenting the results of our work Management meetings can, sometimes, be tedious and uninspiring, where managers compete for excuses to avoid attending! A good manager is someone who understands performance and can present information in a way that enables others to understand what the issues are and make correct decisions. A good manager can cut through the fog of numbers to make a clear point and assist others to make effective decisions. In “Business Communication Skills” we present tools and structures that will help you plan and deliver your message effectively and facilitate group meetings to achieve a useful outcome. Topics covered include the principles of good communication; planning your communication; structuring your message; and facilitating business meetings, including online meetings. We hope you enjoy it.   Key Learning Participants in this course will learn: The principles of effective communication Planning your communication – message, audience, medium, structure, call to action. How to structure your communication Language patterns to help get your message across How to facilitate Business Meetings The Skills of a good facilitator The rules for a well-structured meeting Planning your meeting agenda How to facilitate an online meeting What to look for when facilitating a session Tools you can use in facilitation. Evaluating your Facilitation   Curriculum L1 Effective Communication L2 Planning your Communication 1 L3 Planning your Communication 2 L4 Planning your Communication 3 L5 Exercise: Stakeholder Analysis L6 Facilitating Business Meetings L7 Planning your Meeting Agenda L8 As a facilitator what should I look for? L9 Tools you can use in facilitation L10 Facilitation Tools L11 Exercise: Planning your Agenda Resource: Tools to help you communicate and facilitate     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

Selling Skills for Professionals: Part 1 Prospecting   Course Description   Copyright Ross Maynard 2021   Course Description Welcome to Selling Skills for Professionals: Part 1 Prospecting. If you are an accountant, a lawyer, a consulting engineer, a surveyor, an actuary, a management consultant, an events organiser, an HR professional or any other form of professional businessperson, and you need to identify and develop new clients, then this course is for you This is part 1 of a two-part course on selling skills for professionals. In Part 1 I cover prospecting, that is identifying potential future clients and making the initial approach. In Part 2 of Selling Skills for Professionals I cover the sales process once you have a make contact with a potential client. Selling Skills for Professionals covers high involvement purchases where the commitment is a significant one for the purchaser. This covers relatively expensive business investments, but also purchase agreements which the purchaser feels will have a significant impact on their business – for example engaging an accountant or a lawyer, or a management consultant, and so on. With a high involvement purchase, the client typically will consider a range of alternatives; will review a variety of information sources; and will evaluate product and service attributes in detail. This means that there is a relatively high barrier to surmount to get the potential client’s attention. A solid approach to prospecting and a well-structured sales process can increase that conversion rate and enhance your success in securing clients who will remain with you for the long term. That is the purpose of this course.   I hope you enjoy the course.     Key Learning Points  On completion of the course, delegates will be able to: Describe the scope and purpose of sales prospecting for professional services Understand the five rules of selling professional services Develop a branding statement for themselves and their organisation Define the criteria for the clients they wish to target Appreciate the importance of client pain points and how to identify them Prepare materials for prospecting Create a cold calling script for prospecting Write a cold email or LinkedIn message to prospects including a strong subject line Understand the sorts of questions they can use to stimulate client engagement in a discussion Move prospects onto the next stage of the selling process     Curriculum Module 1: First Principles in Selling Professional Services Lesson 1: The Five Rules of Selling Professional Services Lesson 2: The Five Rules of Selling Professional Services Lesson 3: Branding   Module 2: Getting Ready to Prospect Lesson 4: Identifying Prospects Lesson 5: Client Pain Points and the Purpose of Prospecting Lesson 6: Preparing to Prospect   Module 3: Making the Approach Lesson 7: Seven Seconds to make an Impact Lesson 8: Crafting the Message: Cold Calling Lesson 9: Crafting the Message: Cold Email Lesson 10: Sample Scripts for Cold Email  Lesson 11: Trigger Questions Lesson 12: Getting Ready to Sell: The Next Stage  Lesson 13: Key Learning Points in Prospecting     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

Selling Skills for Professionals: Part 2 Making the Sale   Course Description   Copyright Ross Maynard 2021   Course Description Welcome to Selling Skills for Professionals: Part 2 Making the Sale.   In Part 1 of Selling Skills for Professionals I covered prospecting, that is identifying potential future clients and making the initial approach. In this course, Part 2 of Selling Skills for Professionals, I cover the sales process – converting a prospect into a client. In Selling Skills for Professionals: Part 2 Making the Sale, I look at the skills you need for selling professional services and how to create a series of webinars to build prospects’ interest. I then cover a five-step sales process in detail: Understand the current situation Surface the pain points Exploring the impacts of the pain points Shape the future state Close the sale   The course also covers why people buy professional services, and why they might not buy; and it shows how to deal with objections.   Selling professional services is not like selling a car, or solar panels. It’s about building a relationship with a prospect as a professional advisor; coaching them through the challenges facing them; and offering services tailored to their needs which will help the prospect make tangible improvements.   If you want to know how to sell professional services successfully, this is the course for you.   I hope you enjoy the course.     Key Learning Points  On completion of the course, delegates will be able to: Describe a five-stage sales process for professional services Identify the core skillset needed for selling professional services Deploy best practice when creating webinars to engage prospects Explore a prospect’s current situation on an online video call Identify a prospect’s pain points and explore their root causes and impacts Coach a prospect to visualise the future state they would like to get to be resolving the problems identified Handle objections surfaced as the prospect moves towards closing the sale Understand why people buy professional services, and why they don’t buy Reduce buyer’s remorse and plan to develop the client relationship after the sale     Curriculum Module 1: The Foundations for Selling Professional Services Lesson 1: The Purpose of Prospecting Lesson 2: The Selling Professional Services Skillset Lesson 3: Moving Beyond Prospecting Lesson 4: Script for the Webinar Follow-Up Call   Module 2: Building a Case for the Sale Lesson 5: No Pain No Gain Lesson 6: Building a Case: Initial Diagnosis Lesson 7: Building a Case: Root Causes Lesson 8: Building a Case: Impacts Lesson 9: Building a Case: Shaping the Future State Lesson 10: Building a Case: The Gap   Module 3: Closing the Sale Lesson 11: Selling is about Change Lesson 12: A Time to Close  Lesson 13: Closing (At Last)   Module 4: Evasion and Objections Lesson 14: Evasion Lesson 15: Handling Objections Lesson 16: Specific Example of Objections Part 1 Lesson 17: Specific Example of Objections Part 2   Module 5: After the Sale Lesson 18: Aftercare Lesson 19: Key Learning Points     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

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  

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

This course will help you to enhance your digital skills by learning Microsoft OneDrive A to Z. From this course, you will learn to store, sync and share files securely in the cloud, collaborate with others in real-time, and access documents from anywhere. This Course At A Glance Accredited by CPD UK Endorsed by Quality Licence Scheme Learn what is manual payroll in the UK Payroll System Understand what is benefits in kind Learn how to install Brightpay Know how to find software per HMRC Brightpay Learn how to add employees to Brightpay Understand what is Payroll settings Get familiar with terms such as Directors NI, reports, RTI submissions, 102 schedules, and AEO Learn what is Paye tax, NI2, Pensions, payslips, and journal entries Understand what is total photo scenario and computeEntry Requirements rised systems Microsoft OneDrive Course Overview This extensive Microsoft Onedrive course is beneficial for those who want to learn to create a folder and renaming it, understand Onedrive, its free and paid plans, Onedrive sign up, personal vault, and PC folder backup. You will learn Onedrive functions and interface, Microsoft Word OneDrive, Microsoft project and tables, Microsoft Excel OneDrive, and Microsoft Powerpoint Onedrive. This interactive course will educate you on the steps to create a powerful password for your account and the Onedrive desktop app download and installation.By the end of the course, you will learn everything about Onedrive, sign up, personal vault, pc folder backup, desktop app download and installation, and much more. Who should take this course? This comprehensive Microsoft Onedrive course is suitable for those who want to gain in-depth knowledge in Onedrive functions, applications, interface, and password generation. Entry Requirements There are no academic entry requirements for this Microsoft Onedrive course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This Microsoft Onedrive course for diet assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Course Curriculum You Can Master Onedrive The Complete Microsoft Onedrive Course - Mastering Onedrive Promo Quick Reminder - You Can Ask Me Anytime Another Quick Reminder: You Facebook Group Quick Win - Create a Folder and Rename It Another Quick Quick Win - Share and Collaborate What_Is OneDrive OneDrive Free And Paid Plans Onedrive Sign Up Onedrive Personal Vault OneDrive PC folder Backup Onedrive Desktop App Download and Installation Onedrive Mobile App Download and Installation On Drive Function and Interface Quick Win - Change the View of Displayed Files and Folder Another Quick Win Create a New Album Complete Onedrive Environment Upload and Download in Onedrive Creating New File and Folder in Onedrive Selecting Files And Folder In OneDrive Sharing and Collaborating Files and Folder in Onedrive Other Options in Top Bar of the Files and Folder Other Options in Top Bar of the Files and Folder Part 2 Picture Options In OneDrive Right Click Options In OneDrive Personals Valid in OneDrive Personals Valid Options in Onedrive Shared Folder in Onedrive Onedrive Settings - Storage Management OneDrive Settings (cont.) Microsoft Onedrive Mobile Version Microsoft Word OnDrive Complete Microsoft Word Environment Ribbon Guide Menu and Groups Guide Learn Functions and Options Then Projects Microsoft Word Home Menu Tools Microsoft Word Home Reviewing and Viewing Mode Microsoft Word File Menu Microsoft Word Insert Menu - Page Break and Table Microsoft Word Insert Picture Menu Microsoft Word Word Inserting Header and Footer, Symbol and Emoji Microsoft Word Layout Menu Microsoft OneDrive References Menu Microsoft Word Review Menu Microsoft Word View and Help Microsoft Word Project and Tables Practice Timetable Making in Microsoft Word Bill System in Microsoft Word Microsoft Excel OneDrive Microsoft Excel in Onedrive Environment Microsoft Excel Home (Part 1) Microsoft Excel Number Formats Microsoft Excel Conditional Format Microsoft Excel Formatting a Table Microsoft One Drive Insert Microsoft Data, Review and View Microsoft Excel Practice Salary Table in Microsoft Excel Salary Table In Microsoft Excel (Cont.) Microsoft PowerPoint OneDrive Microsoft PowerPoint Environment Microsoft PowerPoint Home and Insert Menu Microsoft PowerPoint Insert and Design Menu Microsoft Power Point Animation and Transition and More Microsoft PowerPoint Practice Projects of PowerPoint Other Apps in OneDrive and Setting OneNote in OneDrive Forms Survey in Onedrive Plain Text in Onedrive OneDrive Profile Management Account OneDrive Settings Quick Win - Create Unknown Password Security Is Everything Create Powerful Password for Your Account Quick Win - Insecurity is Coming from You and Others Understand Security Type or Category Life Savers - You Should Know These Have Proper Password - Start Securing You Now Don't Use the Same Password Anymore Should You Use Longer Password or Complicated. The Best and Only Solution to Make and Keep Password Un-Crack-Able Lastpass Setup and Configure Last-Pass Options Part 1 Last-Pass Options Part 2 Last-Pass Option Part 3 2FA Makes You Even Stronger in Password Last-Pass & Authy Mobile App Security is Everything, Keep Secured Your Devices Security on Your Data and Privacy Conclusion Congratulations - You Are Now a Master of OneDrive Assessment Assessment - Microsoft OneDrive Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Quality Licence Scheme Endorsed The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. Certificate of Achievement Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.   FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org