Create a simple yet powerful Dashboard in Excel

This video will walk you through the steps of creating a simple yet powerful interactive dashboard in Excel. #exceltutorial #exceltips 0:00 Preview 0:39 Dashboard design plan 4:16 Setup pivot tables 6:40 Create interactive charts and paste them to the Dashboard 10:00 Create slicers and paste them to the Dashboard 12:21 Create a summary table with scroll bar 19:49 Dashboard in action NOTE: This video assumes that you are comfortable with creating Pivot Tables. Here is my video that shows how to create a Pivot Table the right way: https://youtu.be/R5xhSw7VUi0 It also assumes that you know how to connect a Slicer to a Pivot Table. Here is my video that shows how you can insert Slicers in Excel: https://youtu.be/EpBVxHjpmyY This video uses a scroll bar that is available in the Developer tab in Excel's ribbon. If this tab in not populated in your Excel, you can follow these steps to enable it: 1. Click the "File" menu, and then click "Options". 2. Click "Customize Ribbon". Then, on the right side under the list of "Main Tabs", click the checkbox for "Developer". Click OK. 3. The Developer tab will now appear in Excel's ribbon. The excel workbook used in this video is located at: https://github.com/geekoholic4ever/dashboard_1

Видео Create a simple yet powerful Dashboard in Excel автора Эксель для Работы с Финансовыми Моделями