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