Probably some of the most critical tools in your Excel armory are Dashboards and Reports. You can be the management or a personnel, a shareholder or prospective investor – these tools will provide you valuable insights into the Key Performance Indicators (KPIs) which helps measuring business. Often used to provide a visual summary, dashboards enables you as a decision maker, to determine your business’ future direction.
Yes, there are many other tools other than Excel which can create a Dashboard. However, Excel is used and favored commonly due to its power and flexibility, and also because almost everyone have Excel in their computers or mobile devices.
Join this session by Excel expert Mike Thomas and understand how you can build eye-catchy, professional looking dashboards with real-world examples. Know the importance of data cleaning, how to use Pivot Tables, how to display the ‘top x’ and much more. You will also get example worksheets at the end of the session.
Who Should Attend
For any user of Excel who wants to learn how to create Excel Dashboard. You should have an intermediate level of Excel knowledge. The training will be delivered using Excel 2016 for Windows. However, much of the functionality is available in Excel 2013 and 2010 and 2016 for Mac.
Mike has worked in the IT training business since 1989 where his expertise and experience covers designing, delivering training courses, writing training materials and recording and editing video-based tutorials. Although he is a subject matter expert in a range of Microsoft technologies and has worked extensively with... More info