a

Lorem ipsum dolor sit amet, conse ctetur adip elit, pellentesque turpis.

Image Alt

Advanced Excel Skills for Finance Managers

  /    /  Advanced Excel Skills for Finance Managers

Most Financial Accountants realized that they could further harness the power of Excel if they could have a better handle of its structure, formulas and functions. This is much complicated by the incomprehensive jargon and procedures. This course is therefore directed at the person who needs to use Excel in their everyday job to improve decision-making and productivity.

  • Handle Excel’s structure, formulas and functions effectively.
  • Know how to build a clear and accurate data.
  • Establish a complex spreadsheet system in the area of finance and business, accounting, banking and insurance.
  • Understanding the process of spreadsheet consolidation and linking.
  • Know how Formulae and Functions work.
  • Find out how to design and create forms using Excel.
  • Spreadsheet Concept and Structure
  • Building Basic Formulas
  • Creating Advanced Formulas
  • Spreadsheet Calculation Techniques
  • Spreadsheet Consolidation and Linking
  • Charting Techniques and Presentation
  • Auditing and Debugging
Course Overview

Most Financial Accountants realized that they could further harness the power of Excel if they could have a better handle of its structure, formulas and functions. This is much complicated by the incomprehensive jargon and procedures. This course is therefore directed at the person who needs to use Excel in their everyday job to improve decision-making and productivity.

Course Objective
  • Handle Excel’s structure, formulas and functions effectively.
  • Know how to build a clear and accurate data.
  • Establish a complex spreadsheet system in the area of finance and business, accounting, banking and insurance.
  • Understanding the process of spreadsheet consolidation and linking.
  • Know how Formulae and Functions work.
  • Find out how to design and create forms using Excel.
Course Outline
  • Spreadsheet Concept and Structure
  • Building Basic Formulas
  • Creating Advanced Formulas
  • Spreadsheet Calculation Techniques
  • Spreadsheet Consolidation and Linking
  • Charting Techniques and Presentation
  • Auditing and Debugging

Call Me Back