BEST PRACTICE SPREADSHEET

Modelling Level 1 Course.

Why Best Practice Spreadsheet Modelling

Most professionals acknowledge the importance of manipulating numerical data using spreadsheets yet this very important business tool is greatly underutilised (i.e. less than 10% of its capability is actually used).

The main reason for the under utilisation is a lack of formal training in Best Practice Spreadsheet modelling that is necessary to enable them to tap into the features that excel can offer if applied properly.

As a result most professionals spend more hours working in Ms Excel based reports than desired. Therefore This two (2) day practical course, is packed with spreadsheet fundamentals and essentials which every professional must know.

Who Should Attend

Every serious Excel user who has not received any formal training is must as the course introduces Best Practice Spreadsheet Modelling fundamentals and is not a basic Excel course.

Summary Course Outline

  • Overview of Excel and acquainting with the Excel Environment and what’s new in Excel 2019 and Offices 365.
  • Formulas and Functions, including Function Golden Rules
  • Cell Referencing - when Copying Formulas
  • Types of errors including the Circular Reference
  • Excel Short Cuts
  • Flash fill and Custom list
  • Data Outlining tools like Su-Total and Grouping
  • Analysing data with Tables, and Remove Duplicates
  • Exporting data from other systems to Excel - Exploring the use of TEXT TO COLUMNS tool
  • Collaboration of Excel and other MS Office packages - Embedding and linking
  • Consolidating several sheets into a summary page
  • Printing by creating print titles, headers & footers in Excel for professional reporting.