Finance
Excel for Managers

"[spreadsheets] permit users to simulate change in a business or a process in far more complex and revealing ways. It leads users to ask much smarter what-if questions at a much higher level"

Alvin Toffler


"A business proposal such as a new investment, the acquisition of another company, or a restructuring plan will raise the firm's value only if the present value of the future stream of net cash benefits the proposal is expected to generate exceeds the initial cash outlay required to carry out the proposal."

Hawawini & Viallet


"If you just torture the data long enough, they will confess."

Anon


"Where in the past marketing managers were seen as experts on customers, channels and competitors, in the future they should be seen as experts on how marketing and growth can increase shareholder value. To do this, marketers need to extend their skill base to add expertise in modern financial planning techniques."

Peter Doyle


Click here for information on our Management Programmes


Menu loading - please wait

 

We offer Excel courses for managers ranging from introductory through to application development level.

 

 

Why do we offer "Excel for Managers" rather than simply "Excel" courses? Because we set our courses within a managerial context, addressing the types of problems that face managers. We also use our expertise in marketing and strategy to build models and exercises that accurately mirror the real world. Many of the models used in our courses will be of lasting value to managers.

All courses can be tailored to your specific needs. Here are a few examples of programmes:

General

  • Introduction to Excel
  • Moving, copying data
  • Formatting data and spreadsheets
  • Formulae and functions
  • Charting
  • Printing
  • Absolute and relative addressing
  • Intermediate Excel
  • Ranges
  • Views
  • Multiple spreadsheets
  • Templates
  • Data - Sorting and Filtering
  • Formatting with Styles
  • Customising the Excel working environment
  • Simple macros
  • Advanced Excel
  • Functions
  • Scenarios
  • Goal seeking
  • Pivot Tables
  • Auditing
  • Customising user input - forms
  • Macros

Specific Applications

We have tried to stress throughout our website that the principal reason organisations choose Hard Management is because of the "connections" between our areas of expertise. Therefore we can fuse our knowledge of finance and marketing with our technical Excel expertise to produce highly tailored programmes that tackle real business issues. The end result is often not only learning that can be used in the future but the solution to a current problem.

For instance, for:

  • marketing professionals, we can incorporate techniques on brand valuation, forecasting, statistical analysis and media evaluation; we can examine ways to justify promotional expenditure on the basis of value management techniques
  • business planning applications, we can create the traditional financial statements - cash flow, profit and loss, balance sheet - from the ground up, creating inputs such as number of visits by the salesforce or responses to direct mail. This enables sensitivity analysis based on actual performance drivers rather than "let's see what happens if we increase sales by 10%". Planning is thus rooted in what actually happens in the business.
  • human resources, we can demonstrate the link between training and development and financial performance in terms and language that accountants understand

In these areas, and others, we can help managers to build models that represent reality and that can be of real benefit on a day-to-day basis in managing the business.

 top of page

   Contact Hard Management