1242 Accountant courses in Linlithgow delivered Online

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

UK Tax Accounting: UK Tax Accounting Course Are you willing to learn from case studies and real-world examples of UK tax accounting? Then you must apply our UK tax accounting course which will support you practically. In our UK tax accounting course, you can get a comprehensive instruction on the principles of tax accounting in the UK. also, this UK tax accounting course teaches corporation tax, income tax, VAT, and national insurance payments. Moreover, this UK tax accounting course will cover tax planning, compliance, and correct tax return preparation and filing. By this UK tax accounting course you will have acquired the knowledge and abilities needed to successfully handle both individual and corporate tax responsibilities. Enrol in our UK tax accounting course and learn to negotiate the complexity of the UK tax system. Special Offers of this UK Tax Accounting: UK Tax Accounting Course: This UK Tax Accounting: UK Tax Accounting Course includes a FREE PDF Certificate. Lifetime access to this UK Tax Accounting: UK Tax Accounting Course Instant access to this UK Tax Accounting: UK Tax Accounting Course 24/7 Support Available to this UK Tax Accounting: UK Tax Accounting Course UK Tax Accounting: UK Tax Accounting Course Master the essentials of UK Tax Accounting: UK Tax Accounting with our in-depth UK Tax Accounting: UK Tax Accounting course. Dive into comprehensive instruction on corporation tax, income tax, VAT, and national insurance payments. This UK Tax Accounting: UK Tax Accounting course also covers crucial aspects of tax planning, compliance, and the accurate preparation and filing of tax returns. By completing our UK Tax Accounting: UK Tax Accounting course, you’ll gain the knowledge and skills needed to effectively manage both individual and corporate tax obligations. Enroll today and become a proficient UK Tax Accounting: UK Tax Accounting expert! Who is this course for? UK Tax Accounting: UK Tax Accounting Course Anyone can take our UK tax accounting course to expand their knowledge. Requirements UK Tax Accounting: UK Tax Accounting Course To enrol in this UK Tax Accounting: UK Tax Accounting Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our UK Tax Accounting: UK Tax Accounting Course. Be energetic and self-motivated to complete our UK Tax Accounting: UK Tax Accounting Course. Basic computer Skill is required to complete our UK Tax Accounting: UK Tax Accounting Course. If you want to enrol in our UK Tax Accounting: UK Tax Accounting Course you must be at least 15 years old. Career path UK Tax Accounting: UK Tax Accounting Course Jobs in corporate finance, tax compliance, tax advice, accountancy, and financial consulting are all accessible to graduates of this UK tax accounting course.

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

Safeguarding Course Information   Description This course provides a guide to the safeguarding procedures that medical practices and other service providers need to have in place to guard against abuse or neglect. Safeguarding procedures are needed within doctors’ surgeries, schools, nurseries, clubs and associations and any organisation dealing with children and young people, and vulnerable adults. This is not a course about the clinical detection or escalation of safeguarding concerns The aim of the course is to help providers design the administrative procedures in place that they need for safeguarding The focus of the course is the United Kingdom, but the principles covered in the course, and the procedures presented, should apply anywhere.     Course Pre-Requisites There are no course pre-requisites.   What Students will Learn The safeguarding procedures that organisations dealing with young people and vulnerable adults need The definition of Safeguarding The types of organisation that need safeguarding procedures The responsibilities of organisations for safeguarding Sources of information on safeguarding     Curriculum 1. What is Safeguarding? 2. Who is covered by safeguarding? 3. The Responsibilities of Service Providers 4. Key Decisions for Service Providers 5. Documents relating to safeguarding 6. Registration of new service users 7. Identification of Concerns 8. Proactive Analysis of Issues 9. Collaborative Review 10. Audit of Effectiveness     Additional Resources PDFs uploaded: What_to_do_if_you_re_worried_a_child_is_being_abused.pdf (328.0 kB) Scottish Government Safeguarding Guidance.pdf (4.1 MB) Working_Together_to_Safeguard-Children.pdf (2.3 MB) Making Safeguarding Personal - Guide 2014.pdf (277.9 kB)     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

Move up a Grade A Revision guide for students in all subjects at school, university and professional levels Course Information   Description Exams are a difficult time. Studying can be tedious and frustrating, but you have to put in the hours in to get the marks. There are no quick fixes, but you can get a better grade with a good revision strategy. This course presents the revision strategy I used to get the second highest mark in the finals of my accountancy qualifications and 10 A’s out of 11 exams through three years of accountancy study. The revision strategy is not complicated, and you still have to do the work – it’s not a magic solution – but it guides you through each phase of revision, and the exam itself, to help you get the best possible marks. I firmly believe that this revision strategy will get you a better mark than you would have without it. Thank you for your interest in this course. I hope this course will help you prepare for your exams   Course Pre-Requisites There are no pre-course requirements.   What Students will Learn How to structure your days and weeks during the revision period How to plan your revision An effective way to learn your material The importance of giving your mind a break – every day The importance of exam practice How to allocate the exam time over the questions How exam marks work To go for the marks, rather than for perfection What to do (and what not to do) on the day of the exam Tips for the exam A simple technique to reduce stress and boost learning     Curriculum SS1 Introduction and Agenda 3 mins SS2 Structure your Week 7 mins SS3 Start Each Day on a Positive Note 2 mins SS4 Revision Phase 1 2 mins SS5 Revision Phase 2 2 mins SS6 Give your Mind a Break 2 mins SS7 Revision Phase 3 5 mins SS8 Revision Phase 4 2 mins SS9 Exam Preparation 1 2 mins SS10 Exam Preparation 2 5 mins SS11 Emotional Freedom Technique 9 mins SS12 The Exam 5 mins SS13 Final Thoughts on Revision 6 mins SS14 Test your Knowledge 8 mins   Total time 1 hour    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

Duration 1 Days 6 CPD hours This course is intended for This course is intended for IT Asset Managers and other professionals involved in Asset Management, strategic planning, security programs and those affected or influenced by ITAM and security initiatives. The mission of IAITAM?s CAMSE course is to maximize the contribution of IT Asset Management professionals to the information security and physical security of the organization by bridging the gap between ITAM and IT security processes while incorporating security strategies throughout the ITAM policies, processes and procedures so that ITAM enhances the security program and improves the applicable governance. This course includes the comprehensive online examination necessary for achieving CAMSE Certification. Course Outline Scope of IT Security & ITAM Threat Prevention vs. Threat Protection Decentralized vs. Centralized Security The IT Security Plan ITAM?s Role in Risk Management The 12 KPAs & Security Program Management & Security Communication & Education Management & Security Policy Management & Security Acquisition Management & Security Asset Identification Management & Security Disposal Management & Security Project Management & Security Documentation Management & Security Financial Management & Security Legislation Management & Security Compliance Management & Security Vendor Management & Security Assessing Asset Risk Level Program Issues by Asset Type ITAM Program Assessment for Security