ResearchBib Share Your Research, Maximize Your Social Impacts
Sign for Notice Everyday Sign up >> Login

2019 - Excel as a BI Tool - Creating a Dashboard

Date2019-02-20

Deadline2019-02-20

VenuePalo Alto, USA - United States USA - United States

KeywordsCreating dashboard using excel; Pivot tables; KPI summaries; Key performance indicators

Websitehttps://www.complianceonline.com/excel-b...

Topics/Call fo Papers

Best practice for setting up data sources
Using Pivot Tables to summarize data
Visual communication using charts
Creating a rolling 30-day summary
Using formulas to create KPI summaries
Creating interactive filters with Slicers
Automating the dashboard with a simple macro
Using protection to prevent accidental changes

Last modified: 2019-01-21 00:07:37