Creating Interactive Dashboards in Excel 2013 Год выпуска: 2015 Производитель: Lynda Сайт производителя: lynda.com Автор: Nate Makdad Продолжительность: 2:34 Тип раздаваемого материала: Видеоклипы Язык: Английский Описание: Learn how to explore and analyze your data by creating an interactive dashboard in Excel using pivot tables and a little Visual Basic. Using these lessons, you can create a dynamic template to generate reports for customers and to better understand your own data. Along the way, you'll learn how to import external data, design a template using pivot tables, and add slicers, macros, and action buttons to make the template more interactive. Author Nate Makdad also shares some basic principles of visual design to guide you in developing an easy-to-use and visually appealing report. Интерактивные дашборды в Экселе 2013.
Содержание
Introduction Welcome Using the exercise files 1. Introduction to Dynamic Dashboards Why would you want to create a dynamic dashboard? Topics in this course 2. Preparing Your Data Defining your requirements Selecting your software Setting up your data Creating variables Adding reference tables Creating action queries 3. Designing Your Visual Layout Introduction to visual design Creating hierarchy in the template Design elements: Color Design elements: Typography and font size 4. Designing the Report Importing data using PivotTables Learning the four dimensions of a pivot table Inserting slicers Advanced slicers Recording a macro Editing VBA code Copying VBA code to all macros Inserting control buttons Formatting charts 5. Improving User Experience Definitions and help text Inserting hyperlinks within a report Debugging the template Updating your data Conclusion Next steps
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}
