MS Excel (Advance)

Upon completion of this course, attendees will have the knowledge and skills to design effective spreadsheets and work with financial or other business applications in an efficient manner. 

Attendees will have the skills to design and create larger and more complex spreadsheets incorporating protection, automation with macros, and importing /exporting data to and from other applications. They will be able to use advanced techniques to analyse historical data and compare future scenarios.

Learning Outcomes:

• • Design larger and more complex spreadsheet solutions
• • Design spreadsheet solutions that require linked workbooks and linked applications
• • Complete everyday tasks faster and more effectively
• • Construct and enter formulae and functions relevant to a business environment
• • Use a wide range of statistical, text, logical and lookup functions
• • Use advanced techniques to analyse historical data
• • Use advanced charting techniques to analyse graphical data
• • Use advanced techniques to project current data and analyse future scenarios