Establishing Excel Dashboards 2018

Topics

• Creating dynamic and interactive graphs with Excel`s PivotChart feature
• Implementing the Slicer feature in Excel 2010 and later
• Learning why certain features, such as Slicers, Sparklines, and even charts, are disabled in some workbooks
• Using Microsoft Query to create self-updating links to databases, spreadsheets, text files, and other data sources
• Moving beyond worksheet column restrictions using the Paste Picture Link feature to easily present data from various sections of a spreadsheet all in one place
• Creating dashboards that look less like an Excel spreadsheet by hiding screen elements
• Expanding or collapsing data with Excel`s Group and Ungroup feature
• Condensing large amounts of data into manageable chunks

Who should Attend

Attendees from:

• CPAs
• Accountants
• Financial consultants
• CFOs
• Controllers