- This event has passed.
Dashboard Reports in Excel
March 22 @ 8:30 am - 4:00 pm
Creating a dashboard in Excel is the ideal way of making it easy for your audience to interpret information without overloading them with figures.
Pivot tables and conditional formatting can be very handy to extract the relevant data. Learn how to use formulas and then edit the formatting to suit your needs.
Charts are an integral part of many dashboards, as are drawn objects and pictures.The use of advanced formulas will make your dashboards work better through the use of Look ups, If statements, choose function and the camera tool.