Building on the current twelve-part blog series, this webinar will show you how to use the many Chart options in Excel and apply the vast array of graphical choices and features that are available. We will begin with a simple Sparkline, that provides a unique visual audit of data, through to multi-layered double axis Charts. Also, how to use the new Excel ‘ideas’ button that does much of the work for you. Along the way we will cover axis bounds, axis positions, labels, stacking order, trend lines and the benefit of =NA.
Charts can convey messages in management reports much more effectively than tables of data, particularly to people who have Numerophobia or a visual learning style.
With an emphasis on clarity John Tennent will take you through the options.
John provides a wide range of our portfolio of business course though specialises in strategic financial planning, business modelling and investment appraisal. His background is in finance starting his career as a Chartered Accountant with Deloitte & Touche in 1983. He went onto become the Financial Controller of a US bank before joining a training consultancy as Client Director. He co-founded Corporate Edge in 1996.
He is the author of the Economist Guide to Business Modelling, the Economist Guide to Financial Management and the Economist Guide to Cash Management. He is a member of an Institute of Chartered Accountants Technical Committee and Excel Advisory Committee.
Access to this webinar is included within membership of the Excel Community (which is also part of Tech Faculty membership), and to subscribers of Faculties Online. Excel Community membership gives you access to exclusive premium content including our webinars, eight suites of Excel online training, regular eBulletins and extensive online resources focused on technical and soft skills to support your career. For more information about Excel Community membership and our latest joining offers, please visit icaew.com/joinexcel. For more information about Faculties Online, please visit icaew.com/subscribefo
Should you experience webinar difficulties, please click here
If you are an ICAEW Member or Student or have already created an Account please login below. Otherwise please create an Account.
This screen shows you the details for the selected product.
Click the "Add to Cart" button to add this product to your shopping cart. You can enter a quantity larger then 1 to add multiples of this product to your shopping cart.
If the product is full you will see a "Wait List" button. Click this button if you would like to be notified if/when capacity is added. If capacity is increased we will email you. Upon receipt of the increased capacity notification, registration will be on a first-come, first-served basis.
If the product is not ready for purchase you will see a "Notify Me" button. You can click this button if you would like to be notified when this product is ready for purchase.
Some products can only be purchased through our partner. In this case you will see an "External Register" button. Click this button to purchase through our partner's website.