Covering a wide range of advanced skills for Microsoft Excel 2013, such as creating and visualising elements, advanced formats, layouts, formulas and function and more, this selection of courses for financial management will take your analysis, reporting and presentations to a higher level. This comprehensive 10 pack is designed to deliver advanced skills using Microsoft Excel 2013.
Anyone looking to expand their financial management skills using Microsoft Excel 2013.
This course will give you an understanding on customising cells, adding forms, and creating templates to tailor your workbooks to your individual needs.
Master the skills of data search, validation and macros in Excel 2013
Learn the skills to organise data using built in features in Excel 2013
An introduction to the basic concepts and terminology associated with formulas and functions.
Learn how to effectively use and customise tables and charts in Excel 2013.
Learn how to apply conditional formatting, creating custom rules, and creating basic and advanced sparklines.
Understand Excel 2013 function library including Date and time, Logical, and Lookup and reference categories to enable you to quickly complete tasks and analyse data.
Master the skills of using visual elements in Excel 2013
Understand how to use financial functions, iterative calculations, and the Watch Window to help you make better financial decisions and ensure the calculations are accurate.
Learn how to create advanced chart elements, such as trend lines and dual axis.
Where appropriate, choose an offering for each course then click