

Ross has more than 30 years of experience as a process improvement consultant and facilitator, combining strong analytical skills, with decades of experience in process analysis and improvement, and organisational transformation. He has supported improvement projects with some of the worlds leading organisations including Boeing, Rolls Royce, Thermofisher Scientific, Royal Bank of Scotland, Parker Hannifin, Watlow Electric, Bosch, the NHS (National Health Service in the UK), and many others. He has spoken at conferences and seminars in the UK, Denmark, Russia

By the end of this course, you will be able to:
- Distinguish between the SORT and SORT BY functions
- Explain the purpose of RAND, RANDARRAY and RANDBETWEEN functions
- Define dynamic arrays and state their uses
- List multiple functions used in the creation of management reports
- Describe the use of FILTER and SORT functions to filter and sort data
- Outline the different lookup functions
- Evaluate the different functions to be used in a multi-scenario situation
- Explain the syntax of various functions

By the end of this course, you will be able to:
- Discuss the several thinking styles people use when making decisions
- Explain the process to follow for creative problem solving and decision making
- Explain the basis of the benefits realization
- Discuss the benefits map as an approach towards problem solving
- Outline the steps involved in the benefits realization model
- Discuss the think-outside-the-box ideology

By the end of this course, you will be able to:
- Define the three main types of problems
- Outline some examples and characteristics of these problem types
- Explain the reason why most change programmes fail
- List some factors that result in poor solutions to problems
- Describe how to deal with each of the three types of problems
- Outline the several tools for handling problems
- Explain the solution-focused approach
- Discuss the tips on how to become a change agent

By the end of this course, you will be able to:
- List the key elements that should appear in every spreadsheet model
- Outline the steps involved in getting ready to build a spreadsheet model
- Summarize the factors that need to be considered when building the input datasheet for a pricing model
- Select an appropriate discount rate for use in net present value analysis
- State the risks that increase with the life of a project
- Estimate the value of the project or business using the discounted cash flow valuation model

By the end of this course, you will be able to:
- Recognize the various personality types and their characteristics
- List the various elements of a successful negotiation
- Recall the factors that lead one party to outweigh the other in a negotiation agreement
- Outline the various possible outcomes of a negotiation
- Explain the phenomenon of buyer's remorse
- Explain the significance of developing a rapport with the responder

By the end of this course, you will be able to:
- Define fraud and lists the common types of business fraud
- Discuss the personality types of people who tend to commit business fraud
- Outline steps required to guard against fraud
- Explain how to create clear anti-fraud policies and procedures
- Describe the components of a fraud risk management strategy
- Lists examples of legislation on fraud and bribery
- Recall the elements of an anti-fraud culture

By the end of this course, you will be able to:
- Discuss the history and evolution of business finance
- Identify the main reasons why most new businesses fail within five years
- Indicate the most important business rules to keep in mind when managing or reviewing business finances
- Explain how the balance sheet, income statement, and cashflow statement works
- Identify key financial performance indicators that the management of every business should use
- Select the best tool for the appraisal of your business investment projects

By the end of this course, you will be able to:
- Recall the purpose of different menu options in Microsoft Excel
- List the use of various logical functions like AND, OR, and NOT
- Summarize various text and numeric functions and explain their uses
- Discuss the different types of lookup functions in Microsoft Excel
- Distinguish between the various random number generation functions
- Recall the steps to create a pivot table
- Identify the various scenarios to use the IF and IFS functions






Frequently Asked Questions
Once you have completed your purchase, your Digital Certificate/Digital Diploma and Transcript can be downloaded from the Dashboard of your Alison Account.
I access Alison via my computer:
Expand the Your Completed Courses & Claimed Certificates widget in your dashboard as shown below:
You will then be able to download your Digital Certificate/Diploma and Transcript. 
I access Alison via my Mobile Browser:
Expand the Your Completed Courses & Claimed Certificates widget in your Dashboard as shown below:
You will then be able to download your Digital Certificate/Diploma and Transcript. 
I access Alison via App:
Open My Certificates in your Dashboard, as shown in the example below:

You will then be able to download your Digital Certificate/Diploma and Transcript.

Continuing Professional Development, or CPD, is the process of continually developing or maintaining your professional skills. CPD helps individuals focus on how they can become a more competent and effective professional. Due to our rigorous publishing review process, courses on Alison are now being accredited by CPD UK, an independent organisation. Accredited CPD training means the learning activity has reached the required Continuing Professional Development standards and benchmarks, and the learning value has been scrutinised to ensure integrity and quality. This CPD Certification Service provides recognised independent CPD accreditation compatible with global CPD requirements. This means a certificate from a course on Alison can now be used as part of your CPD requirements (please check with your organisation’s guidelines). You can find out more about Alison accreditation here.
Users can pay a nominal fee to automatically download Digital Certificates or purchase paper or framed Certificates that are shipped via mail. For a more detailed list of the costs, visit the Shop page.













