امتیاز کاربران

مشخصات دوره :

نام دوره : 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

• قبلی
• بعدی