
دوره رایگان "Creating Interactive Dashboards in Excel 2013" از مجموعه آموزشی Lynda منتشر شد.
نوشته شده توسط بهار حاج حسینی
مشخصات دوره :
نام دوره : Creating Interactive Dashboards in Excel 2013
گروه اصلی : دوره های آموزشی Lynda
مدت زمان دوره : 2 ساعت و 34 دقیقه
قیمت دوره : رایگان
حداکثر زمان استفاده از دوره : نا محدود
سرفصل مطالب دوره :
00 - Introduction
01 - Welcome
02 - Using the exercise files
01 - Introduction to Dynamic Dashboards
01 - Why would you want to create a dynamic dashboard
02 - Topics in this course
02 - Preparing Your Data
01 - Defining your requirements
02 - Selecting your software
03 - Setting up your data
04 - Creating variables
05 - Adding reference tables
06 - Creating action queries
03 - Designing Your Visual Layout
01 - Introduction to visual design
02 - Creating hierarchy in the template
03 - Design elements- Color
04 - Design elements- Typography and font size
04 - Designing the Report
01 - Importing data using PivotTables
02 - Learning the four dimensions of a pivot table
03 - Inserting slicers
04 - Advanced slicers
05 - Recording a macro
06 - Editing VBA code
07 - Copying VBA code to all macros
08 - Inserting control buttons
09 - Formatting charts
05 - Improving User Experience
01 - Definitions and help text
02 - Inserting hyperlinks within a report
03 - Debugging the template
04 - Updating your data
06 - Conclusion
01 - Next steps